第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號安全,請及時綁定郵箱和手機(jī)立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException?

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException?

忍帥鍋 2018-04-26 22:03:56
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+")";?

? ? ?這樣寫就通過了!

查看完整回答
1 反對 回復(fù) 2018-04-26
  • 1 回答
  • 0 關(guān)注
  • 3781 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動學(xué)習(xí)伙伴

公眾號

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號