김균도

페이징만들려고 합니다.

jsp파일로 페이징을 구현하려고 하는데 어떤 소스를 어느 부분에 붙여야 할지 모르겠습니다...제발 도와주시길....

<%@ page language="java" import="java.sql.*,java.util.*,common.db.*" contentType="text/html; charset=EUC-KR"%>
<%
DBConnectionPoolMgr poolMgr = DBConnectionPoolMgr.getInstance();
Connection conn = null;
java.sql.Statement stmt = null;
java.sql.Statement stmt1 = null;
java.sql.Statement stmt2 = null;
java.sql.Statement stmt3 = null;
java.sql.Statement stmt4 = null;
ResultSet rs = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
try{
conn = poolMgr.getConnection();
stmt = conn.createStatement();
stmt1 = conn.createStatement();
stmt2 = conn.createStatement();
stmt3 = conn.createStatement();
stmt4 = conn.createStatement();
String sql = "select * from addr_book";//rs.stmt
String aaa = "select * from user_info";
//out.println(aaa);
String sql1 = "select count(*) from addr_book"; //rs2.stmt2
//out.println(sql1);
String sql2 = "SELECT count(*) FROM addr_list";
//out.println(sql2);
String sql3 = "SELECT count(C.GROUP_NUM) FROM ADDR_BOOK B, ADDR_LIST C WHERE b.GROUP_NUM = C.GROUP_NUM GROUP BY B.GROUP_NUM"; //그룹 간 회원 수
//out.println(sql3);

rs1 = stmt1.executeQuery(aaa);
rs = stmt.executeQuery(sql);
rs2 = stmt2.executeQuery(sql1);
//out.println(rs);
//out.println(rs1);
//out.println(rs2);
int qqq = 0;
if(rs2.next()){
qqq = rs2.getInt(1);
//out.println(qqq);
}
rs3 = stmt3.executeQuery(sql2);
//out.println(rs3);
int www = 0;
if(rs3.next()){
www = rs3.getInt(1);
}
//out.println(asd);
rs4 = stmt4.executeQuery(sql3);
String rrr = null;
while(rs4.next()){
rrr = rs4.getString(1);
}

String two,barcelona;

while(rs1.next()){
two = rs1.getString(2);
barcelona = rs1.getString(1);

}

//out.println("<br>");
if (rs != null ){

%>

<html>

<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title>그룹 관리 페이지</title>

</head>
<center>
<h3>그룹을 관리할 수 있는 페이지입니다.</h3>
<script language="javascript">
function checkinput(){
  if(document.group.new_group.value==""){
   alert("그룹 이름을 써주세요!!");
   return();
  }
  document.group.submit();
}
</script>
<form name=group method=post action=addgroup_ok.jsp>
<table border="1" cellspacing=0 width="660">
    <tr align=center>
        <td width="115" height="40" rowspan="2">새 그룹 개설</td>
        <td width="220" height="30" rowspan="2">
        <input type="text" name="new_group">
        <input type="submit" value="추가" onClick="javascript:checkinput()"></td>
        <td width="130" height="40" rowspan="2">내 그룹 현황</td>
        <td width="195" height="20">개설한 그룹 수 : <%=qqq%>그룹</td>
    </tr>
    <tr align=center>
        <td width="195" height="22">그룹 내 회원 총 수 : <%=www%>명</td>
    </tr>
</table>
</form>
<h3>내 그룹 리스트 명단입니다.</h3>
<table border=1 cellspacing=0 width=650>
<tr align=center><td width="130" height="40">번호</td>
      <td width="220" height="30">그룹명</td>
      <td width="150" height="40">회원수</td>
      <td width="150" height="30">그룹관리</td>
</tr>
<%
//out.println(num+name);
while(rs.next()){
  int GROUP_NUM = rs.getInt("GROUP_NUM");
  //String USER_IDENT = rs.getString("USER_IDENT");
  String GROUP_NAME = rs.getString("GROUP_NAME");
%>
<tr align=center>
  <td width="130" height="20"><%=GROUP_NUM%></td>
  <td width="130" height="20"><%=GROUP_NAME%></td>
  <td width="130" height="20"></td>
  <td><a href="groupupdate.jsp?number=<%=GROUP_NUM%>" onClick="window.open(this.href,'newwin','width=300,height=200')"><input type=button value=수정하기></a>
   <a href="groupdelete.jsp?number=<%=GROUP_NUM%>" onClick="window.open(this.href,'newwin','width=300,height=200')"><input type=button value=삭제하기></a></td>
</tr>

<%
  }
%>
</table></center></html>
<%
}else{
out.println("There is no data!!");
}
}catch(SQLException ex) {

System.out.println(ex);
}catch(NullPointerException ex) {
System.out.println(ex);
}

finally {
    if (rs != null) rs.close();
    if (stmt != null) stmt.close();
    if (conn != null) poolMgr.releaseConnection(conn);
}