java注册验证_注册验证java代码[针对上篇文章]

用户注册

string strsql="";

string database_username="root";

string database_password="";

string url="jdbc:mysql://localhost/ch3?useunicode=true&characterencoding=gb2312";

try

{

class.forname("org.gjt.mm.mysql.driver");

connection dbconn= drivermanager.getconnection(url,database_username,database_password);

statement stmt=dbconn.createstatement();

resultset rs=null;

string s_username = request.getparameter("username");

strsql = "select * from users where username like '"+s_username+"'";

rs = stmt.executequery(strsql);

if(rs.next())

{

out.println("

用户名"+s_username+"已经存在！

");

out.println("

}

else

{

string s_userpassword = request.getparameter("userpassword");

string s_nickname = request.getparameter("nickname");

string s_sex = request.getparameter("sex");

string s_email = request.getparameter("email");

strsql = "insert into users (username,userpassword,nickname,sex,email) values('"+s_username+"','"+s_userpassword+"','"+s_nickname+"','"+s_sex+"','"+s_email+"')";

try

{

stmt.executeupdate(strsql);

out.println("

用户注册成功，您的注册信息如下

");

out.println("

用户名："+s_username+"

");

out.println("

密码："+s_userpassword+"

");

out.println("

昵称："+s_nickname+"

");

if(s_sex.equals("0"))

{

out.println("

性别：男

");

}

else

{

out.println("

性别：女

");

}

out.println("

email："+s_email+"

");

}

catch(exception ex)

{

out.println("

用户注册失败

");

out.println("

}

}

rs.close();

stmt.close();

dbconn.close();

}

catch(exception ex)

{

out.println("

数据库连接错误

");

out.println("

}

%>

希望与广大网友互动？？

点此进行留言吧！