mysql为什么不能插入数据_为什么不能将数据插入到mysql数据库中？可以查询到数据库中的数据但是不能插入。以下是我的代码...

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页面就是插入不了 而且运行也不报错 但就是插入不进去

展开