주소창: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());}
}
}
}
'개발하자 > jgGrid' 카테고리의 다른 글
선택누르면 jqgrid에서 id값 alert에 띄우기 (0) | 2015.03.17 |
---|---|
editurl사용하기 (0) | 2015.03.17 |
rowList:[3,6,9] (0) | 2015.03.17 |
그리드에 페이지달기 (0) | 2015.03.17 |
그리드 초기화하기 (0) | 2015.03.17 |