MySQL预编译模糊查询出现错误，最后自己给解决了, 希望对大家有所帮助

原代码是:

String sql = "select id,name,password,age,sex,birthday" +                 "from user where name like ? or password like ? or sex like ?";                           Class.forName(DBDRIVER);                  conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);                  ps = conn.prepareStatement(sql);  //实例化对象                           ps.setString(1, "%" + keyWord + "%");                  ps.setString(2, "%" + keyWord + "%");                  ps.setString(3, "%" + keyWord + "%");

报的错误是:

Exception in thread "main" 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 'where name like '%æ�Ž%' or password like '%æ�Ž%' or sex like '%æ�Ž%'' at line 1     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)     at java.lang.reflect.Constructor.newInstance(Constructor.java:525)     at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)     at com.mysql.jdbc.Util.getInstance(Util.java:381)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)     at com.heima.services.PreparedStatementDemo2.main(PreparedStatementDemo2.java:45)

刚开始看网上的资料 有的说是编码不对,,我就查看了我的MySQL数据库和myeclipse的编码都是utf-8,首先排除这个问题.

最后又在网上看资料说是sql语句写的不对,空格的问题,我也看了好多就是找不出了

折腾了一会发觉是少了一个空格

String sql = "select id,name,password,age,sex,birthday" +

 "from user where name like ? or password like ? or sex like ?";

应该写成  " from user where name like ? or password like ? or sex like ?";   这个from前面少了一个空格, 这是最容易犯得一个错误,因为代码太长,换到第二行后会自动出现双引号,,,而容易导致少了空格,弄成birthday和from变成了一个词birthdayfrom