Stringsql1="select*fromuserwhereusername='"+username+"'";Stringsql2="insertintouser(username,u_password,u_name,u_age,u_sex,u_brithday,u_hometown,u_admission_y,u_identity,...
String sql1="select * from user where username= '" + username+ "' ";
String sql2="insert into user(username,u_password,u_name,u_age,u_sex,u_brithday,u_hometown,u_admission_y,u_identity,u_phone,u_qq,u_email,u_department,u_profession,u_class,u_hobbies,u_futurework,u_remark,u_description) values('"+username+"','"+u_password+"','"+u_name+"','"+u_age+"','"+u_sex+"','"+u_brithday+"','"+u_hometown+"','"+u_admission_y+"','"+u_identity+"','"+u_phone+"','"+u_qq+"','"+u_email+"','"+u_department+"','"+u_profession+"','"+u_class+"','"+u_hobbies+"','"+u_futurework+"','"+u_remark+"','"+u_description+"')";
try{
Connection conn=DatabaseUtil.getConnection();
Statement stmt=conn.createStatement();
if(username!="" && u_password!="" && u_name!=""&& request.getParameter("u_age")!="" && u_brithday!="" && u_admission_y!=null && u_hometown!="" && u_department!="" && u_profession!="" && u_class!="" ){
ResultSet rs=stmt.executeQuery(sql1);
if(rs.next()) {
out.println("
该用户名已经存在!请重新填写注册信息!3秒后返回注册页面!
");response.setHeader("Refresh","3;URL=register.jsp");
}else{
stmt.executeUpdate(sql2);
out.println("
亲爱的会员,您已经注册成功!3秒后返回登录页面,请您重新登录!
");response.setHeader("Refresh","3;URL=login.jsp");
}
}else{
out.println("
您填写的注册信息有误!请按照要求重新填写注册信息!3秒后返回注册页面!
");response.setHeader("Refresh","3;URL=register.jsp");
}
DatabaseUtil.close(conn);
}catch (Exception e)
{
e.printStackTrace();
}
已经在mysql中运行了insert 语句是可以插入的 没有问题 但是在JSP页面就是插入不了 而且运行也不报错 但就是插入不进去
展开