开发者社区 问答 正文

数据库模糊查询语句报错 ?报错

数据库查询语句报错了,不知道是哪个部分错了
代码片:

                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

展开
收起
爱吃鱼的程序员 2020-06-23 00:59:00 451 分享 版权
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    group是关键字,需要转义。如果是sqlserver,用[],如果是mysql,用

    ``

    `

    希望有用

    你把sql语句复制到数据库中试一遍不就知道了。。。。。

    2020-06-23 00:59:19
    赞同 展开评论