*注:conn 表示获取到的数据库连接对象
首先获取数据总条数
private static int getDataNum(Connection conn, String tableName) throws SQLException
{
PreparedStatement ps = conn.prepareStatement("select count(*) from "+tableName);
ResultSet getNum = ps.executeQuery();
if(getNum.next()) return getNum.getInt(1);