mysql 无论输入什么都是现实 not found_为什么无论输入什么都是"该用户名已经注册，请重新输入！"...

注册页面注册页面

String name=request.getParameter("username");

String pwd=request.getParameter("password");

String realname=request.getParameter("name");

String sx=request.getParameter("sex");

String tel=request.getParameter("phone");

String add=request.getParameter("address");

String zip=request.getParameter("zipcode");

String mail=request.getParameter("email");

Connection conn;

ResultSet rst;

Statement sql;

try{

// 加载JDBC驱动器类

Class.forName("com.mysql.jdbc.Driver");

}

catch(ClassNotFoundException e){out.print(e);}

// 建立到bookstore的数据库连接

try{

conn = DriverManager.getConnection(

"jdbc:mysql://localhost:3306/bookstore", "root", "123");

//查询数据

sql=conn.createStatement();

rst = sql.executeQuery("select * from userinfo where username='"+name+"'");

if (rst.next())

{

out.println("");

}

else

{

String sql1="Insert into userinfo(username,password,name,sex,phone,address,zipCode,email)values('"+name+"','"+pwd+"','"+realname+"','"+sx+"','"+tel+"','"+add+"','"+zip+"','"+mail+"')";

int ret=0;

ret=sql.executeUpdate(sql1);

if(ret!=0)

{out.println("");}

else {out.println("");}

}

}

catch (SQLException sqle)

{

out.println(sqle.getMessage());

}

//finally {out.println("出错了！");}

%>

展开