标题:jsp注册时出现下面问题:
取消只看楼主
张忍
Rank: 1
等 级:新手上路
帖 子:1
专家分:0
注 册:2016-5-12
结帖率:0
已结贴  问题点数:5 回复次数:0 
jsp注册时出现下面问题:
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() ;
}
 %>
搜索更多相关主题的帖子: jsp 注册 出现 SQL request 
2018-04-26 21:45



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-486422-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.818895 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved