代码如下:目的是注册。想要两次输入的密码一致后,到数据库中的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+ " ') ");/////////加这一句进去看看