ResultSet rs = this.pstmt.executeQuery()不通过
语句不执行
原因就出在SQL语句中。
MySQL中数据库分页:
public List<Emp> findAllSplit(Integer currentPage, Integer lineSize, String column, String keyWord) throws Exception { List<Emp> all = new ArrayList<Emp>(); String sql = "SELECT * FROM " +"emp" +" WHERE "+column+" LIKE? LIMIT ?,? "; System.out.println("EmpDAOImpl:109"); this.pstmt = this.conn.prepareStatement(sql) ; System.out.println("EmpDAOImpl:110"); this.pstmt.setString(1,"%"+keyWord+"%"); this.pstmt.setInt(2,(currentPage-1)*lineSize); this.pstmt.setInt(3,lineSize); System.out.println("EmpDAOImpl:121"); ResultSet rs= this.pstmt.executeQuery() ; System.out.println("EmpDAOImpl:111"); while (rs.next()){ Em