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利用jsp寫登錄界面時出現(xiàn)上面報錯,是什么原因呢?<%try{? conn = DBHelper.getConnection();? String sql = "insert into userinfo (yid,username,password,sex,age,addr,tel,sid,email,balance) values (?,?,?,?,?,?,?,?,?,?)";//插入語句,”?”表示接受參數(shù)值 ? 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 回答

忍帥鍋
TA貢獻(xiàn)2條經(jīng)驗(yàn) 獲得超1個贊
已解決:
?????String sql ="insert into userinfo(yid,username,password,sex,age,addr,tel,email,sid,balance) values("+yid+","+username+","+password+","+sex+","+age+","+addr+","+tel+","+email+","+sid+","+balance+")";?
? ? ?這樣寫就通過了!
添加回答
舉報
0/150
提交
取消