페이지카운트

주소창:http://localhost:8090/jqgridex/jqgrid1.jsp?page=1&rows=3

 

a.jsp

===================

<%@page import="kr.co.seoulit.member.to.MemberBean"%>
<%@page import="kr.co.seoulit.common.to.ListForm"%>
<%@page import="kr.co.seoulit.member.dao.MemberDAOImpl"%>
<%@page import="java.lang.reflect.Member"%>
<%@page import="kr.co.seoulit.member.dao.MemberDAO"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="java.util.*" %>
<%@ page import="net.sf.json.*"%> 
<%
 int pagenum=Integevr.parseInt(request.getParameter("page"));
 int rowsize=Integer.parseInt(request.getParameter("rows"));
 MemberDAOImpl dao=(MemberDAOImpl)MemberDAOImpl.getInstance();
 int dbcount=dao.selectRowCount();
 ListForm listForm=new ListForm();
 listForm.setRowsize(rowsize);
 listForm.setPagenum(pagenum);
 listForm.setDbcount(dbcount);
 int sr=listForm.getStartrow();
 int er=listForm.getEndrow();
 
 List<MemberBean> list=dao.selectMemberList(sr,er);
 HashMap<String,Object> map=new HashMap<String,Object>();
 int pagecount=listForm.getPagecount();
 map.put("page",pagenum);
 map.put("total",pagecount);
 map.put("list",list);
 JSONObject jsonObject=JSONObject.fromObject(map);
 out.println(jsonObject);
%>

 

MemberDAOImpl.java

=================================

package kr.co.seoulit.member.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;

import kr.co.seoulit.common.dao.DataAccessException;
import kr.co.seoulit.common.sl.ServiceLocator;
import kr.co.seoulit.member.to.MemberBean;

public class MemberDAOImpl implements MemberDAO {

 private static MemberDAOImpl instance=new MemberDAOImpl();
 private MemberDAOImpl(){}
 public static MemberDAO getInstance(){ 
  return instance;
 }
 
 
 public List<MemberBean> selectMemberList(int sr, int er){
   ArrayList<MemberBean> v=new ArrayList<MemberBean>();
   Connection con = null;
   PreparedStatement pstmt = null;
   try {
   StringBuffer query = new StringBuffer();
   query.append("select * from ");
   query.append("(select rownum as rn, id, pw, addr, tel from ");
   query.append("(select * from member order by id)) t ");
   query.append("where t.rn between ? and ?");

   DataSource dataSource=ServiceLocator.getInstance().getDataSource("jdbc/myoracle");
   con = dataSource.getConnection();
   pstmt = con.prepareStatement(query.toString());
   pstmt.setInt(1, sr);
   pstmt.setInt(2, er);
   ResultSet rs = pstmt.executeQuery();
   while(rs.next()){
   MemberBean member=new MemberBean();
   member.setId(rs.getString("id"));
   member.setPw(rs.getString("pw"));
   member.setAddr(rs.getString("addr"));
   member.setTel(rs.getString("tel"));
   v.add(member);
   }
   return v;
   } catch(Exception sqle) {
   throw new DataAccessException(sqle.getMessage());
   } finally {
   try{
   if(pstmt!=null){pstmt.close(); pstmt=null;}
   if(con!=null){con.close(); con=null; }
   }catch(Exception e){throw new RuntimeException(e.getMessage());}
   }
   }
 
 public int selectRowCount(){
  Connection con = null;
  PreparedStatement pstmt = null;
  ResultSet rs=null;
  try {
   StringBuffer query = new StringBuffer();
   query.append("select count(*) from member");
   DataSource dataSource=ServiceLocator.getInstance().getDataSource("jdbc/myoracle");
   con = dataSource.getConnection();
   pstmt = con.prepareStatement(query.toString());
   rs=pstmt.executeQuery();
   rs.next();
   
   return rs.getInt(1);
  } catch(Exception sqle) {
   throw new DataAccessException(sqle.getMessage());   
  } finally {
   try{
   if(rs!=null){ rs.close(); rs=null; }
   if(pstmt!=null){ pstmt.close(); pstmt=null; }
   if(con!=null){ con.close(); con=null; }
   }catch(Exception e){throw new DataAccessException(e.getMessage()); }
  }
 }
 
 
 
 
 
 public MemberBean selectMember(String id){
  Connection con = null;
  PreparedStatement pstmt = null;
  ResultSet rs=null;
  try {
   StringBuffer query = new StringBuffer();
   query.append("select * from member where id=?");
   DataSource dataSource=ServiceLocator.getInstance().getDataSource("jdbc/myoracle");
   con = dataSource.getConnection();
   pstmt = con.prepareStatement(query.toString());
   pstmt.setString(1,id);
   rs=pstmt.executeQuery();
   MemberBean member=null;
   if(rs.next()){
     member=new MemberBean();
     member.setId(rs.getString("id"));
     member.setPw(rs.getString("pw"));
     member.setAddr(rs.getString("addr"));
     member.setTel(rs.getString("tel"));
   }
   return member;
  } catch(Exception sqle) {
   throw new DataAccessException(sqle.getMessage());   
  } finally {
   try{
   if(rs!=null){ rs.close(); rs=null; }
   if(pstmt!=null){ pstmt.close(); pstmt=null; }
   if(con!=null){ con.close(); con=null; }
   }catch(Exception e){throw new DataAccessException(e.getMessage()); }
  }
 }

 public List<MemberBean> selectMemberList(){
  ArrayList<MemberBean> v=new ArrayList<MemberBean>();
  Connection con = null;
  PreparedStatement pstmt = null;
  try {
   StringBuffer query = new StringBuffer();
   query.append("select * from member");

   DataSource dataSource=ServiceLocator.getInstance().getDataSource("jdbc/myoracle");
   con = dataSource.getConnection();
   pstmt = con.prepareStatement(query.toString());
   ResultSet rs = pstmt.executeQuery();
   while(rs.next()){
    MemberBean member=new MemberBean();
    member.setStatus("normal");
    member.setId(rs.getString("id"));
    member.setPw(rs.getString("pw"));
    member.setAddr(rs.getString("addr"));
    member.setTel(rs.getString("tel"));
    v.add(member);
   }
   return v;
  } catch(Exception sqle) {
   throw new DataAccessException(sqle.getMessage());   
  } finally {
   try{
    if(pstmt!=null){pstmt.close(); pstmt=null;}
    if(con!=null){con.close(); con=null; }
   }catch(Exception e){throw new RuntimeException(e.getMessage());}  
  }
 }
}