在此上下文中不允許使用名稱 "userName"。有效表達式包括常量、常量表達式和變量(在某些上下文中)。//添加記錄public boolean addUser(UserBean proBean){boolean bool = false;try{conn = DBConn.getConn();ps = conn.prepareStatement("insert into userinfo (userName, passward, phone, address, eMail)values( '"+userName+"', "+passward+", "+phone+", '"+address+"',"+userEmail+")";ps.setString(1, proBean.getUserName());ps.setString(2, proBean.getPassward());ps.setString(3, proBean.getPhone());ps.setString(4, proBean.getAddress()); ps.setString(5, proBean.getUserEmail());int i = ps.executeUpdate();if(i >0){bool = true ;}}catch(Exception e){e.printStackTrace();}finally{DBConn.close(rs, ps, conn);}return bool;}這個有問題嗎？
2 回答
慕村9548890
TA貢獻1884條經驗 獲得超4個贊
兄弟，你既然已經傳值了再傳一遍值是何意啊?。。。?br/>ps = conn.prepareStatement("insert into userinfo (userName, passward, phone, address, eMail)values( '"+userName+"', "+passward+", "+phone+", '"+address+"',"+userEmail+")";
ps.setString(1, proBean.getUserName());
ps.setString(2, proBean.getPassward());
ps.setString(3, proBean.getPhone());
ps.setString(4, proBean.getAddress());
ps.setString(5, proBean.getUserEmail());
去掉
ps.setString(1, proBean.getUserName());
ps.setString(2, proBean.getPassward());
ps.setString(3, proBean.getPhone());
ps.setString(4, proBean.getAddress());
ps.setString(5, proBean.getUserEmail());
呼啦一陣風
TA貢獻1802條經驗 獲得超6個贊
ps = conn.prepareStatement("insert into userinfo (userName, passward, phone, address, eMail)values( '"+userName+"', "+passward+", "+phone+", '"+address+"',"+userEmail+")";
在這段代碼上面要調用userName,passward,phone,address,userEmail
但是前面并沒有聲明者些變量.
ps = conn.prepareStatement("insert into userinfo (userName, passward, phone, address, eMail)values( '"+proBean.userName+"', "+proBean.passward+", "+proBean.phone+", '"+proBean.address+"',"+proBean.userEmail+")";
添加回答
舉報
0/150
提交
取消