javaweb和mysql有关联嘛_java web与mysql的问题？？

注册新用户注册新用户

用户名

设置密码

确认密码

if((request.getParameter("user")!=null)&&(request.getParameter("user")!="")){

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

String pw2=request.getParameter("password2");

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

if((request.getParameter("password")!=null)&&(request.getParameter("password")!="")&&pw.equals(pw2)){

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

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/S2010150357?useUnicode=true&characterEncoding=utf-8","S2010150357","150357");

Statement stat=conn.createStatement();

String sql="SELECT id FROM Information ";

ResultSet rs=stat.executeQuery(sql);

int count=0;

while(rs.next())count++;

String sql2="INSERT INTO Users(id,username,password) VALUES(?,?,?)";

PreparedStatement p=conn.prepareStatement(sql2);

p.setInt(1,count);

p.setString(2,username);

p.setString(3,pw);

stat.executeUpdate(sql2);

stat.close();

conn.close();

}

else{

out.print("密码不相同，请重新输入!");

}

}

else{

out.print("请输入用户名！");

}%>

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /register.jsp at line 31

28: p.setInt(1,count);

29: p.setString(2,username);

30: p.setString(3,pw);

31: int i=stat.executeUpdate(sql2);

32: stat.close();

33: conn.close();

34: }

Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

展开