请帮忙看看这段代码，不要笑我，初学.谢谢！
代码如下：目的是注册。想要两次输入的密码一致后，到数据库中的TBL_STU表中查找是否重名，如果不重名，插入表中。
if(pwd.equals(repwd))
{
ResultSet rs1=sql.executeQuery( "select * from TBL_STU where xh= ' "+xh+ " ' ");
//out.print(sql1);
if(rs1.next())
{
rs1.close();
out.print( " <script> alert( '该用户名已经被注册，请选择其它的用户名！ '); </script> ");
}
else{
try
{
sql.executeUpdate( "insert into TBL_STU(xh,xm,bh,pwd,sex,nl,zy,sfzh,txdz,yb,dh,email) values( ' "+xh+ " ', ' "+xm+ " ', ' "+bh+ " ', ' "+pwd+ " ', ' "+sex+ " ', ' "+nl+ " ', ' "+zy+ " ', ' "+sfzh+ " ', ' "+txdz+ " ', ' "+yb+ " ', ' "+dh+ " ', ' "+email+ " ') ");
}
catch(SQLException e1)
{
out.print(e1.getMessage());
}
}
}
[解决办法]
sql.executeUpdate( "insert into TBL_STU(xh,xm,bh,pwd,sex,nl,zy,sfzh,txdz,yb,dh,email) values( ' "+xh+ " ', ' "+xm+ " ', ' "+bh+ " ', ' "+pwd+ " ', ' "+sex+ " ', ' "+nl+ " ', ' "+zy+ " ', ' "+sfzh+ " ', ' "+txdz+ " ', ' "+yb+ " ', ' "+dh+ " ', ' "+email+ " ') ");
你用其他方式单调用这句话.看看能不能插.有可能字段验证不通过
[解决办法]
if(pwd.equals(repwd))
{
ResultSet rs1=sql.executeQuery( "select * from TBL_STU where xh= ' "+xh+ " ' ");
//out.print(sql1);
System.out.println( "select * from TBL_STU where xh= ' "+xh+ " ' ");/////////加这一句进去看看
if(rs1.next())
{
rs1.close();
out.print( " <script> alert( '该用户名已经被注册，请选择其它的用户名！ '); </script> ");
}
else{
try
{
System.out.println( "insert into TBL_STU(xh,xm,bh,pwd,sex,nl,zy,sfzh,txdz,yb,dh,email) values( ' "+xh+ " ', ' "+xm+ " ', ' "+bh+ " ', ' "+pwd+ " ', ' "+sex+ " ', ' "+nl+ " ', ' "+zy+ " ', ' "+sfzh+ " ', ' "+txdz+ " ', ' "+yb+ " ', ' "+dh+ " ', ' "+email+ " ') ");/////////加这一句进去看看
sql.executeUpdate( "insert into TBL_STU(xh,xm,bh,pwd,sex,nl,zy,sfzh,txdz,yb,dh,email) values( ' "+xh+ " ', ' "+xm+ " ', ' "+bh+ " ', ' "+pwd+ " ', ' "+sex+ " ', ' "+nl+ " ', ' "+zy+ " ', ' "+sfzh+ " ', ' "+txdz+ " ', ' "+yb+ " ', ' "+dh+ " ', ' "+email+ " ') ");
}
catch(SQLException e1)
{
out.print(e1.getMessage());
}
}
}
看看有什么结果吧,先看这些语句的值是不是对的
[解决办法]
第一个页面是填写各项（包括会员名xh，密码pwd，确认密码repwd，等等一些），并检查会员名，密码，确认密码是否为空。
--------
这个前台用JS就可以完成了。
你设断点跟踪下看看，是到哪里的问题，还有在各个步骤执行的过程中，把SQL语句打印出来看一下，你也不说报的是什么错误，那些SQL语句在查询分析器里面插入看看能执行不，就按AWUSOFT(程序设计,一个字:爽!) 说的那个方法，System.out.println一下，看看控制台输出的是什么。
