jdbc连接MySQL数据库查询中文数据查询不出来，数据库无乱码现象。

Question

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;


}

Answer 1

你在mysql中查询有结果吗？
select * from snsuserinfo where nickName like "%王五%";