public List queryByNiC2(String nickName){
List list=new ArrayList();
try {
conn=DbManager.getConn();
String sql="select * from snsuserinfo where nickName like "+"'%"+nickName+"%'";
ps=conn.prepareStatement(sql);
System.out.println(sql);
rs=ps.executeQuery();
System.out.println(rs.getRow()+"rs的长度");
while(rs.next()){
SNSUserInfo sns=new SNSUserInfo();
sns.setId(rs.getInt("id"));
sns.setOpenId(rs.getString("openId"));
sns.setNickName(rs.getString("nickName"));
sns.setCity(rs.getString("city"));
sns.setHeadImgUrl(rs.getString("headImgUrl"));
sns.setSex(rs.getInt("sex"));
sns.setAttentionTime(rs.getString("attentionTime"));
sns.setAuthNum(rs.getInt("authNum"));
list.add(sns);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}