数据库查询语句报错了,不知道是哪个部分错了
代码片:
con = DBUtil.getConnection();
System.out.println("select * from group where member like '%"+email+"%'");
System.out.println("select * from group where member = "+email+"");
pst = con.prepareStatement("select * from group where member like '%"+email+"%'");
ResultSet rs = pst.executeQuery();
控制台报错信息:
select * from group where member like '%989@qq.com%'
select * from group where member = 989@qq.com
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group where member like '%989@qq.com%'' at line 1
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
group是关键字,需要转义。如果是sqlserver,用[],如果是mysql,用
``
`
你把sql语句复制到数据库中试一遍不就知道了。。。。。