java获取内容为空_java-从属性获取空值

在Dynamic Web应用程序中,我遇到了一些问题,因此我要发布代码：

这是我的控制器(Servlet)：

String select = request.getParameter("select"); // getting proper value

String search = request.getParameter("search"); // getting proper value

request.setAttribute("select", select);

request.setAttribute("search", search);

System.out.println("Select : "+select+" Search : "+search);

int page = 1;

int recordsPerPage = 20;

if(request.getParameter("page") != null)

page = Integer.parseInt(request.getParameter("page"));

SearchDAO searchDAO=new SearchDAO();

List list=searchDAO.searchAllUsers((page-1)*recordsPerPage,recordsPerPage,select,search);

int noOfRecords = searchDAO.getNoOfRecords();

System.out.println("4> NoOfRecords : "+noOfRecords);

int noOfPages = (int) Math.ceil(noOfRecords * 1.0 / recordsPerPage);

System.out.println("5> NoOfPages : "+noOfPages);

request.setAttribute("searchList", list);

System.out.println("6> List : "+list);

request.setAttribute("noOfPages", noOfPages); // Getting null value, 0

request.setAttribute("currentPage", page); // Getting null value, 0

RequestDispatcher view = request.getRequestDispatcher("/jsp/Securex_Anti_Theft_SearchUserList.jsp");

view.forward(request, response);

这是我的DAO(简单的Java类)：

public class SearchDAO {

private int noOfRecords;

Connection connection;

Statement stmt;

public List searchAllUsers(int offset ,int noOfRecords,String select,String search){

private static Connection getConnection() throws SQLException,ClassNotFoundException{

Connection con = ConnectionFactory.getInstance().getConnection();

return con; //ConnectionFactory is class for making the connection to DB.

}

String query="select SQL_CALC_FOUND_ROWS * from info where '"+select+

"' like '%"+search+"%' order by serialNo asc limit

" + offset + " , " + noOfRecords;

List list1 = new ArrayList();

User user1=null;

try {

connection = getConnection();

stmt = connection.createStatement();

ResultSet rs=stmt.executeQuery(query);

System.out.println("1> :"+rs);

while(rs.next()){

user1=new User();

user1.setSerial(rs.getInt(1));

System.out.println("I'm inside a loop");

user1.setName(rs.getString(2));

user1.setEmail(rs.getString(3));

list1.add(user1);

}

rs.close();

rs = stmt.executeQuery("SELECT FOUND_ROWS()");

System.out.println("2> :" +rs);

if(rs.next())

this.noOfRecords = rs.getInt(1);

System.out.println("3> :" +this.noOfRecords);

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}finally

{

try {

if(stmt != null)

stmt.close();

if(connection != null)

connection.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

return list1;

}

public int getNoOfRecords() {

return noOfRecords;

}

}

输出为：

1> :com.mysql.jdbc.JDBC4ResultSet@1af8502

2> :com.mysql.jdbc.JDBC4ResultSet@455aa8

3> :0

4> NoOfRecords : 0

5> NoOfPages : 0

6> List : []

我有相同的servlet和类来选择所有用户,并且工作正常,但是从这里获取了空值.即使ResultSet也会返回值,即com.mysql.jdbc.JDBC4ResultSet@88d319,但是无法从DAO到servlet中获取值.

从//属性获取null值,对我来说一切都应该很好,但仍然获取null值,请指出我的错误,如果我做了任何事情