注册 登录
编程论坛 JAVA论坛

jsp注册时出现下面问题:

张忍 发布于 2018-04-26 21:45, 1519 次点击
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?,?,?,?,?,?,?,?,?)' at line 1

<%
try{
  conn = DBHelper.getConnection();
  String sql = "insert into userinfo(Yid,Username,Password,Sex,Age,Addr,Tel,sID,Email,Balance) values(?,?,?,?,?,?,?,?,?,?)";//插入语句,”?”表示接受参数值   
  pstmt = conn.prepareStatement(sql);
  //给sql语句中的变量赋值
  pstmt.setString(1, request.getParameter("yid"));
  pstmt.setString(2, request.getParameter("username"));
  pstmt.setString(3, request.getParameter("password"));
  pstmt.setString(4, request.getParameter("sex"));
  pstmt.setString(5, request.getParameter("age"));
  pstmt.setString(6, request.getParameter("address"));
  pstmt.setString(7, request.getParameter("tel"));
  pstmt.setString(8, request.getParameter("id"));
  pstmt.setString(9, request.getParameter("email"));
  pstmt.setString(10, request.getParameter("balance"));
  int updatenumber =  pstmt.executeUpdate(sql);
  if(updatenumber!=0)
      {
           request.getRequestDispatcher("login_success.jsp").forward(request, response);
         }
     else
     {
             response.sendRedirect("login_failure.jsp");
     }
      
 }catch(Exception e) {
    e.printStackTrace() ;
}
 %>
1 回复
#2
疯狂的小a2018-04-27 14:18
语法错误呗
1