怎么看mysql是不是有问题_写了一个mysql查询，怎么也看不出错误在哪

publicListquery(Paperp){Listlist=newArrayList<>();Stringsql="select*fromq_paperwhere1=1?";if(p!=null&&p.getPid()!=0){//不等于0表示传递了查询条件pidsql+="and...

public List query(Paper p) {

List list = new ArrayList<>();

String sql = "select * from q_paper where 1=1 ?";

if (p!=null&&p.getPid()!=0) { //不等于0表示传递了查询条件pid

sql+=" and pid = "+p.getPid();

}

if (p!=null&&p.getPtitle()!=null&&!p.getPtitle().equals("")) {//不为null，也不为空字符串表示传递了查询条件ptitle

sql+=" and ptitle like '%"+p.getPtitle() +"%'";

}

try {

con = getCon();

pst = con.prepareStatement(sql);

rs = pst.executeQuery();

while(rs.next()){

p = new Paper();

p.setPid(rs.getInt("pid"));

p.setPtitle(rs.getString("ptitle"));

p.setMark(rs.getString("mark"));

p.setPtime(rs.getString("ptime"));

p.setUserId(rs.getInt("userid"));

p.setIsOpen(rs.getInt("isOpen"));

list.add(p);

}

} catch (SQLException e) {

e.printStackTrace();

}finally {

try {

rs.close();

pst.close();

con.close();

} catch (SQLException e) {

//

e.printStackTrace();

}

}

return list;

}

java.lang.NullPointerException

at com.igeekhome.question.dao.impl.PaperDaoImpl.query(PaperDaoImpl.java:93)

at com.igeekhome.question.service.impl.PaperServiceImpl.query(PaperServiceImpl.java:32)

at com.igeekhome.question.servlet.PaperServlet.query(PaperServlet.java:57)

at com.igeekhome.question.servlet.PaperServlet.doGet(PaperServlet.java:42)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

展开