public class UserDao {

    private static PgsqlJdbc jdbc = new PgsqlJdbc();

    public static JSONArray getUserList(String page, String rows)
    {
        StringBuilder sql = new StringBuilder();
        sql.append("select * from public.user as u ");
        sql.append("order by u.id ");
        sql.append("limit "+rows+ " offset (("+page+"-1)*"+rows+") ");
        return jdbc.query(sql.toString());
    }

    public static Object getUserTotal()
    {
        StringBuilder sql = new StringBuilder();
        sql.append("SELECT COUNT(*) FROM public.user ");
        JSONObject findOne = jdbc.findOne(sql.toString());
        Object count = findOne.getBigInteger("count");
        return count;
    }
    
}