不允许使用列名。请问是什么原因啊 我是用JAVA做的

Question

在此上下文中不允许使用名称 "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;
}
这个有问题吗？

Answer 1

兄弟，你既然已经传值了再传一遍值是何意啊！！！！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()); 

Answer 2

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+")";