//Stringsql="select*fromfilewherenameLIKEBINARY'%"+name+"%'";Stringsql="SELECT*FROMfileWHERElocate(name,\'"+name+"\')>0;";//Stringsql="selectpathfromfilewherenamelike'%"+...
//String sql = "select * from file where name LIKE BINARY '%"+name+"%'"; String sql = "SELECT * FROM file WHERE locate(name,\'"+name+"\') > 0;" ; //String sql = "select path from file where name like '%"+name+"%'"; //String sql= "SELECT * FROM file WHERE locate(name,'"+name+"') > 0"; //String sql = "select path from file where name LIKE '%"+name+"%'"; //String sql = "select path from file where name LIKE ?"; // SELECT * FROM table_name WHERE field_name LIKE BINARY '%了%'; PreparedStatement ps = con.prepareStatement(sql); //ps.setString(1, "%"+name+"%"); ResultSet rs = ps.executeQuery(); System.out.println(sql); 以上sql语句我都试过,都得不到值;可是控制台打印出来的sql语句,我粘贴到cmd上运行,可以得到结果; 运行 show variables like 'character\_set\_%';显示 +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | +--------------------------+--------+ 都搞一天了,真不知道该怎么办了
展开