JDBC模糊查询SQL

JDBC模糊查询SQL

public static List SelectUid(String fuzzyuid){
  DaoTest test=new DaoTest();

  List list =new  ArrayList();
  conn=test.getConnection();
  String sql="select * from t_dev_property where uid like ?";
  String uid=fuzzyuid;
  try {
   ps=conn.prepareStatement(sql);
   ps.setString(1,""+uid+"%");
   rs=ps.executeQuery();
   while(rs.next()){
    i++;
    PropertyForm ppf=new PropertyForm();
    ppf.setUid(rs.getString("uid"));
    ppf.setDevicename(rs.getString("devicename"));
    list.add(ppf);
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return list;
 }

JDBC PreparedStatement 字符串字段 模糊查询 注意事项

针对字符串类型字段模糊查询的正确写法：

String sql = "select count(*) from category c where 1 = 1   and c.category_name like ? ";  
pstmts   =   conn.prepareStatement(sql);  
pstmts.setString(1,"%资讯%");  
rs   =   pstmts.executeQuery();  

注意：

这里“pstmts.setString(1,"%资讯%");  ”

不能写为：pstmts.setString(1,"'%资讯%'");