Unknown column 'userName' in 'where clause'我也在网上查过类似问题，但出错原因不是，求助大神来

[qq_26064491]

String sql1="select * from user where userName='"+userName+"'";
语句有单引号

[shixitong]

把最后生成的sql语句在数据库里执行下看看

[qq_26064491]

try{ Connection con=null; Statement stmt=null; ResultSet rs=null; Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://localhost:3306/person?useUnicode=true&characterEncoding=gbk"; con=DriverManager.getConnection(url,"root","123456"); stmt=con.createStatement(); String sql1="select * from user where userName='"+userName+"'"; rs=stmt.executeQuery(sql1); rs.last(); int k; k=rs.getRow(); if(k>0){ wrong3(); response.sendRedirect("http://localhost:8080/PIMS/login.jsp"); }else{ String sql2="insert into user" +"(userName,password,name,sex,birth,nation,edu,work,phone,place,email)"+"values(" +"'"+userName+"'"+","+"'"+password1+"'"+","+"'"+name+"'"+","+"'"+sex+"'"+","+"'"+birth+"'"+"," +"'"+nation+"'"+","+"'"+edu+"'"+","+"'"+work+"'"+","+"'"+phone+"'"+","+"'"+place+"'"+","+"'"+email+"'"+")"; stmt.executeUpdate(sql2); } rs.close(); stmt.close(); con.close(); right(); response.sendRedirect("http://http://localhost:8080/PIMS/login.jsp"); }catch(Exception e){ e.printStackTrace(); }

[tony4geek]

有 userName 列 吗

[qq_26064491]

这个肯定有啊

[「已注销」]

环境：MySQL Sever 5.1 + MySQL命令行工具 　　问题：MySQL列名是否区分大小写 　　答案：Windows下不区分。 　　记住在Windows下是不区分大小写的。而Linux可不一定，详情请参考此文。 看试一下sql里的userName列名改成username,可能mysql自动把列名转成小写了，可能到命令行窗口下看看

[qq_26064491]

Unknown column 'username' in 'where clause' 楼上小哥，我全改了，结果。。。并没有什么。。。

[晴天_ccc]

String sql1="select * from user where userName='"+userName+"'"; 该为String sql1="select * from user where userName="+userName;

[晴天_ccc]

String sql1="select * from user where userName='"+userName+"'"; 改为String sql1="select * from user where userName="+"'"+userName"'";

[qq_26064491]

经过两天的检查，终于在页面的框架里面找到了数据库insert的一段代码错误，结贴了，谢谢各位大神

[yangfanxiao]

结帖了 为什么呢，答案呢

[qq_40063579]

怎么解决啊楼主