首頁猿問不允許使用列名。請問是什么原因啊...

不允許使用列名。請問是什么原因啊我是用JAVA做的

Java

搖曳的薔薇 2023-03-12 16:12:17

在此上下文中不允許使用名稱 "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條經(jīng)驗獲得超4個贊

兄弟，你既然已經(jīng)傳值了再傳一遍值是何意?。。。。?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());

反對回復 2023-03-15

呼啦一陣風

TA貢獻1802條經(jīng)驗獲得超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+")";

反對回復 2023-03-15