不允许使用列名。请问是什么原因啊 我是用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+")";