package com.dlj.utils;
import java.sql.ResultSet;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class Count {
public static void main(String[] args) {
System.out.println(Count.count("t_user"));
}
public static int count(String t_user) {
int i = 0;
Connection con = (Connection) DBUtil.getConnection();
try {
Statement stmt = (Statement) con.createStatement();
ResultSet rset = stmt.executeQuery("select count(*)as totalCount from " + t_user);
if (rset.next()) {
i = rset.getInt("totalCount");
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.close(con, stmt, rset);
}
return i;
}
}
Servlet:
Connection connection = null;
Statement statement = null;
ResultSet totalCountResultSet = null;
try {
connection = (Connection) DBUtil.getConnection();
statement = (Statement) connection.createStatement();
int totalCount = 0;
totalCountResultSet = statement.executeQuery("select count(*) as totalCount from t_user ");
if (totalCountResultSet.next()) {
totalCount = totalCountResultSet.getInt("totalCount");
}
request.setAttribute("totalCount", totalCount);
RequestDispatcher dispatcher = request.getRequestDispatcher("userList.jsp");
dispatcher.forward(request, response);
return;
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
DBUtil.close(connection, statement, totalCountResultSet);
}
jsp:
<!-- EL表达式 -->
总共${totalCount}条记录