插入数据库无法成功

graydream · 发表于 2005-1-26 20:45:43

这是注册页面

<%@ page import="java.sql.*" %>
<html>
<body>
<jsp:useBean id= "dbwork" scope= "page" class= "db.link"/>
<%
String regname=request.getParameter("name");
String password=request.getParameter("password");
String realname=request.getParameter("realname");
ResultSet rs_checkname = dbwork.executeQuery("SELECT logname from member where logname='"+regname+"'");
if(rs_checkname.next())
out.print("用户名已存在");
else
{
dbwork.executeQuery("insert into member(logname,realname,password) values('"+regname+"','"+realname+"','"+password+"')");
out.print("注册成功");
}
%>
</body>
</html>

复制代码

数据库连接的bean

package db;
import java.sql.*;
public class link
{
ResultSet rs = null;
String driver = "org.gjt.mm.mysql.Driver";
public link()
{
try
{
Class.forName(driver);
}
catch(java.lang.ClassNotFoundException nf)
{
System.err.println("link:"+nf.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try
{
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/java?user=gray&password=111111");
Statement smt = conn.createStatement();
rs = smt.executeQuery(sql);
smt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("ex.executeQuery:"+ex.getMessage());
}
return rs;
}
}

复制代码

登录什么的都好用，注册的时候之显示注册成功，却没有写入数据库，也没有任何提示，
我用mysql客户端直接输入
insert into member(logname,realname,password) values("gray1","111111","王二");
是可以写入的。

menglianjing · 发表于 2005-1-26 20:52:48

这样写是不行的!

menglianjing · 发表于 2005-1-26 21:22:18

[php]
package com.test;

/**
* @author USER
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
import java.sql.*;

public class CheckID
{
private Connection con = null;
private ResultSet rs = null;

public CheckID()
{
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception err)
{
err.printStackTrace();
}

}

private void check()
{
boolean flag = false;
try
{
con = DriverManager.getConnection("jdbc

dbc:test");
PreparedStatement pstmt = con.prepareStatement("SELECT username,userpasswd FROM login WHERE username=? AND userpasswd=?");
pstmt.setString(1,"jxd");
pstmt.setString(2,"123456");
rs = pstmt.executeQuery();
if(rs.next())
{
flag = true;
}
else
{
flag = false;
}

if(flag)
{
System.out.println("登陆成功");
}
else
{
System.out.println("登陆失败");
}
//con.close();
//rs.close();
}
catch(Exception err)
{
err.printStackTrace();
}
finally
{
if(rs != null)
{
try
{
rs.close();
}
catch(Exception err)
{
err.printStackTrace();
}
}

if(con != null)
{
try
{
con.close();
}
catch(Exception err)
{
err.printStackTrace();
}
}
}
}

public static void main(String args[])
{
new CheckID().check();
}
}

[/php]

希望对你有帮助,页面自己写

eTony · 发表于 2005-1-26 22:31:44

注意 \'

hantsy · 发表于 2005-1-26 23:58:46

Post by eTony
注意 \'

什么东西呀

		自动登录	找回密码
密码			注册