0
 19   2   1
  View Articles

Name  
   ¼Õº´¸ñ  (2003-05-05 22:07:14, Hit : 57374, Vote : 2197)
Homepage  
   http://www.itmembers.net
Subject  
   °Ô½ÃÆÇ ½Ç½À(9) - ±Û ¸ñ·Ï º¸±â ¼Ò½º(list.jsp)
±Û ¸ñ·Ï º¸±â ÇÁ·Î±×·¥(list.jsp) ¼Ò½ºÀÔ´Ï´Ù.
Áß°£Áß°£ ÁÖ¼®À» ´Þ¾Æ³õ±ä ÇßÀ¸³ª ¹Ù·Î ÀÌÇØÇϱ⿡´Â Á» ¹«¸®ÀÏ °Í °°±¸¿ä,
´ÙÀ½ ½Ã°£ºÎÅÍ Á¶±Ý¾¿ ³ª´²¼­ ¼³¸íµå¸®°Ú½À´Ï´Ù.

  1. ¡´!--
  2. ¡á ÆÄ  ÀÏ  ¸í : list.jsp
  3. ¡á ÀÛ  ¼º  ÀÚ : ¼Õº´¸ñ (www.itmembers.net)
  4. ¡á ÃÖÃÊÀÛ¼ºÀÏ : 2003.3.16(ÀÏ)
  5. ¡á ÃÖÁ¾¼öÁ¤ÀÏ : 2003.3.20(¸ñ)
  6. ¡á www.itmembers.netÀÇ JSP °Ô½ÃÆÇ ¸¸µé±â °­Á¸¦ À§ÇÑ ¼Ò½ºÀÔ´Ï´Ù.
  7. --¡µ

  8. ¡´%@ page language="java" import="java.sql.*" contentType="text/html;charset=KSC5601" %¡µ
  9. ¡´%@ include file="conn_db.jsp" %¡µ

  10. ¡´%

  11. String s_mail_addr; // ¸ÞÀÏ ÁÖ¼Ò°¡ ÀÖÀ» °æ¿ì ÀÛ¼ºÀÚ À̸§¿¡ ¸ÞÀÏ ÁÖ¼Ò¸¦ ¸µÅ©ÇÒ ¶§ »ç¿ë
  12. String s_subject, s_name, s_email, s_sql;
  13. int i_number, i_count;

  14. int i_cur_num=0, i_total_no=0, i_total_page=0; // °¡»ó ±Û ¹øÈ£
  15. int i_page_num = 10; // ÇÑ È­¸é¿¡ º¸¿©ÁÙ ÆäÀÌÁö ¸µÅ© °¹¼ö -¡µ ºí·Ï
  16. int i_list_num = 10 ; // ÇÑ ÆäÀÌÁö¿¡ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ ¼ö
  17. int i_total_block, i_block;
  18. int i_first, i_last, i_block_prev, i_block_next, i_page_link;
  19. int i_page, i_prev, i_next;
  20. String s_page, s_writetime ;

  21. s_page = request.getParameter("page"); // list.jsp?page=3 °ú °°ÀÌ ³Ñ¾î¿Â °ª "3"À» ³Ñ°Ü¹ÞÀ½.
  22. if(s_page==null) s_page="1"; // ±×³É list.jsp·Î ÇßÀ» °æ¿ì
  23. i_page = Integer.parseInt(s_page);

  24. int i_offset = i_list_num*(i_page-1); //ÇÑ ÆäÀÌÁöÀÇ ½ÃÀÛ ±Û ¹øÈ£(i_listnum ¼ö¸¸Å­ ³ª´©¾úÀ» ¶§ ½ÃÀÛÇÏ´Â ±ÛÀÇ ¹øÈ£)

  25. %¡µ


  26. ¡´html¡µ
  27. ¡´head¡µ
  28. ¡´meta http-equiv=content-type content=text/html; charset=euc-kr¡µ
  29. ¡´title¡µJSP °Ô½ÃÆÇ - ±Û¸ñ·Ïº¸±â¡´/title¡µ
  30. ¡´STYLE TYPE=text/css¡µ
  31. BODY,TD,SELECT,input,DIV,form,TEXTAREA,center,option,pre,i_blockquote {font-family:±¼¸²;font-size:9pt;color:#555555;}
  32. A:link    {color:black;text-decoration:none;}
  33. A:visited {color:black;text-decoration:none;}
  34. A:active  {color:black;text-decoration:none;}
  35. A:hover   {color:gray; text-decoration:none;}
  36. ¡´/STYLE¡µ
  37. ¡´/head¡µ
  38. ¡´body background=./images/body_bg.gif¡µ
  39. ¡´img src=./images/maintitle.gif¡µ
  40. ¡´table border=1 cellspacing=0 width=680 bordercolordark=white bordercolorlight=#999999¡µ
  41.     ¡´tr¡µ
  42.         ¡´td width=30 bgcolor=#CCCCCC¡µ
  43.             ¡´p align=center¡µno¡´/p¡µ
  44.         ¡´/td¡µ
  45.         ¡´td bgcolor=#CCCCCC width=490¡µ
  46.             ¡´p align=center¡µsubject¡´/p¡µ
  47.         ¡´/td¡µ
  48.         ¡´td width=60 bgcolor=#CCCCCC¡µ
  49.             ¡´p align=center¡µname¡´/p¡µ
  50.         ¡´/td¡µ
  51.         ¡´td width=70 bgcolor=#CCCCCC¡µ
  52.             ¡´p align=center¡µdate¡´/p¡µ
  53.         ¡´/td¡µ
  54.         ¡´td width=30 bgcolor=#CCCCCC¡µ
  55.             ¡´p align=center¡µhit¡´/p¡µ
  56.         ¡´/td¡µ
  57.     ¡´/tr¡µ

  58. ¡´%

  59. try {

  60.         rs=stmt.executeQuery("select count(number) from bbs");
  61.         if(rs.next()) {
  62.                 i_total_no=rs.getInt(1);  //ÃÑ ±Û¼ö
  63.         }

  64.         if(i_total_no%i_list_num==0) { // Àüü ±Û ¼ö¸¦ ÆäÀÌÁö´ç ±Û ¼ö·Î ³ª´« °ªÀÇ ¿Ã¸² °ª = Àüü ÆäÀÌÁö ¼ö¸¦ ±¸ÇÕ´Ï´Ù.
  65.                 i_total_page = i_total_no/i_list_num;
  66.         } else {
  67.                 i_total_page = (i_total_no/i_list_num)+1; // ¿Ã¸² ¼ö ±¸Çϱâ
  68.         }

  69.         i_cur_num = i_total_no - i_list_num*(i_page-1); // ÇöÀç ±ÛÀÇ °¡»ó ¹øÈ£(½ÇÁ¦ Å×À̺íÀÇ number °ª°ú´Â ´Ù¸¨´Ï´Ù.)

  70.         s_sql = "select number,subject,name,from_unixtime(writetime,'%Y/%m/%d'),count,email from bbs order by number desc limit "+i_offset+","+i_list_num;  
  71.         // ¸ñ·Ï Á¶È¸¸¦ À§ÇÑ SQL ¹®

  72.         rs = stmt.executeQuery(s_sql); // Äõ¸®¹® ½ÇÇà °á°ú °ªÀ» ´ãÀ» °´Ã¼

  73.         while(rs.next()) {
  74.                 i_number = rs.getInt(1);
  75.                 s_subject = rs.getString(2);
  76.                 s_name = rs.getString(3);
  77.                 s_writetime = rs.getString(4);
  78.                 i_count = rs.getInt(5);
  79.                 s_email = rs.getString(6);

  80.                 if(!s_email.equals("")) {
  81.                         s_mail_addr="¡´a href=mailto:"+s_email+"¡µ"+s_name+"¡´/a¡µ";
  82.                 } else {
  83.                         s_mail_addr=s_name;
  84.                 }

  85. %¡µ

  86.     ¡´tr¡µ
  87.         ¡´td width=30¡µ
  88.             ¡´p align=center¡µ¡´%=i_cur_num %¡µ¡´/p¡µ
  89.         ¡´/td¡µ
  90.         ¡´td width=490¡µ
  91.             ¡´a href="view.jsp?page=¡´%= i_page %¡µ&number=¡´%= i_number %¡µ"¡µ¡´%=s_subject %¡µ¡´/a¡µ
  92.         ¡´/td¡µ
  93.         ¡´td width=60¡µ
  94.             ¡´p align=center¡µ¡´%=s_mail_addr %¡µ¡´/p¡µ
  95.         ¡´/td¡µ
  96.         ¡´td width=70¡µ
  97.             ¡´p align=center¡µ¡´%=s_writetime %¡µ¡´/p¡µ
  98.         ¡´/td¡µ
  99.         ¡´td width=30¡µ
  100.             ¡´p align=center¡µ¡´%=i_count %¡µ¡´/p¡µ
  101.         ¡´/td¡µ
  102.     ¡´/tr¡µ

  103. ¡´%

  104.                 i_cur_num --;

  105.         } //while¹® ´ÝÀ½

  106.         stmt.close(); // ÀÎŬ·çµå ÆÄÀÏ(db_conn.jsp)¿¡¼­ »ý¼ºÇÑ stmt ´Ý±â
  107.         Conn.close(); // ÀÎŬ·çµå ÆÄÀÏ(db_conn.jsp)¿¡¼­ »ý¼ºÇÑ Conn ´Ý±â

  108. } catch (Exception e) {
  109.                 out.println(e);
  110. }

  111. %¡µ

  112.     ¡´tr¡µ
  113.         ¡´td width=100% colspan=5¡µ


  114. ¡´%
  115. /*************************************
  116. *ÆäÀÌÁö ¸µÅ©
  117. **************************************/

  118. if (i_total_page%i_page_num==0) { // Àüü ºí·ÏÀÇ ¼ö : Àüü ÆäÀÌÁö ¼ö¸¦ ÇÑ È­¸é¿¡ º¸ÀÌ´Â ÆäÀÌÁö ¼ö·Î ³ª´®
  119.         i_total_block = i_total_page/i_page_num;
  120. } else {
  121.         i_total_block = (i_total_page/i_page_num)+1;
  122. }

  123. if (i_page%i_page_num==0) {
  124.         i_block = i_page/i_page_num; // ÇöÀç ºí·ÏÀÇ ¹øÈ£ :
  125. }
  126.         else {
  127.         i_block = (i_page/i_page_num)+1;
  128. }

  129. i_first = (i_block-1)*i_page_num; // ÇöÀç ºí·ÏÀÌ ½ÃÀÛÇϴ ù ÆäÀÌÁö
  130. i_last = i_block*i_page_num; // ÇöÀç ºí·ÏÀÇ ³¡ ÆäÀÌÁö

  131. if(i_block ¡µ= i_total_block) {
  132.         i_last = i_total_page;
  133. }

  134. out.println("¡´p align=center¡µ");

  135. if(i_block ¡µ1) {
  136.         i_block_prev = i_first -1;
  137.         out.println("¡´a href='list.jsp?page=1'¡µ[óÀ½]¡´/a¡µ ");
  138.         out.println("¡´a href='list.jsp?page="+i_block_prev+"'¡µ["+i_page_num+"°³ ¾Õ]¡´/a¡µ");
  139. }

  140. if(i_page¡µ1) {
  141.         i_prev = i_page-1;
  142.         out.println("¡´a href='list.jsp?page="+i_prev+"'¡µ[ÀÌÀü]¡´/a¡µ         ");
  143. }

  144. for (i_page_link=i_first+1;i_page_link¡´=i_last;i_page_link++) {
  145.         if(i_page_link==i_page) {
  146.                 out.println("¡´font color=green¡µ¡´b¡µ"+i_page_link+"¡´/b¡µ¡´/font¡µ");
  147.         } else {
  148.                 out.println("¡´a href='list.jsp?page="+i_page_link+"'¡µ["+i_page_link+"]¡´/a¡µ");
  149.         }
  150. }

  151. if (i_total_page ¡µ i_page) {
  152.         i_next = i_page+1;
  153.         out.println(" ¡´a href='list.jsp?page="+i_next+"'¡µ[´ÙÀ½]¡´/a¡µ");
  154. }

  155. if (i_block ¡´ i_total_block) {
  156.         i_block_next = i_last + 1;
  157.         out.println("¡´a href='list.jsp?page="+i_block_next+"'¡µ["+i_page_num+"°³ µÚ]¡´/a¡µ ");
  158.         out.println("¡´a href='list.jsp?page="+i_total_page+"'¡µ[¸¶Áö¸·]¡´/a¡µ ");
  159. }


  160. %¡µ
  161.         ¡´/td¡µ
  162.     ¡´/tr¡µ
  163.     ¡´tr¡µ
  164.         ¡´td width=100% colspan=5¡µ
  165.             ¡´p align=center¡µ¡´a href='write.html'¡µ[±Û¾²±â]¡´/a¡µ¡´/p¡µ
  166.         ¡´/td¡µ
  167.     ¡´/tr¡µ
  168. ¡´/table¡µ
  169. ¡´/body¡µ
  170. ¡´/html¡µ

¿Ã µé¾î °¡Àå ´õ¿ü´Ù°í Çϳ׿ä.
¿À´ÃÀº ¾î¸°À̳¯, µ¿Á־ƺü ¼Õº´¸ñÀ̾ú½À´Ï´Ù.

Next
   °Ô½ÃÆÇ ½Ç½À(8) - ±Û ¸ñ·Ï ÆäÀÌÁö ¸ð¾ç ¸¸µé±â

¼Õº´¸ñ


Copyright 1999-2025 Zeroboard / skin by Zetyx