코스모스팜 스레드

jsp게시판 글순서

<%@ page language="java" contentType="text/html; charset=euc-kr" %>
<%@ page import = "java.sql.*, java.util.*" %>
<% request.setCharacterEncoding("euc-kr"); %>

<SCRIPT language="JavaScript">
function Check()
{
if (Form.keyword.value.length < 1) {
   alert("검색어를 입력하세요.");
   Form.keyword.focus();
return false;
   }
}
</SCRIPT>

</HEAD>
<BODY>

<%
String key = request.getParameter("key");
String keyword = request.getParameter("keyword");

String pageNum = request.getParameter("pageNum");
if(pageNum == null){
pageNum = "1";
}

int listSize = 5;
int currentPage = Integer.parseInt(pageNum);
int startRow = (currentPage - 1) * listSize + 1;
int endRow = currentPage * listSize;
int lastRow = 0;
int i = 0;
String strSQL = "";

String driverName = "com.mysql.jdbc.Driver";
String dbURL = "jdbc:mysql://localhost:3306/univdb";

Class.forName(driverName);
Connection conn = DriverManager.getConnection(dbURL, "root", "dongyang");
Statement stmt = conn.createStatement();

ResultSet rs = null;

if (key==null || keyword==null){
strSQL = "SELECT count(*) FROM tblboard";
}else{
strSQL = "SELECT count(*) FROM tblboard WHERE " + key + " like '%" + keyword + "%'";
}
rs = stmt.executeQuery(strSQL);
rs.next();
lastRow = rs.getInt(1);

   <TR bgcolor='cccccc'>
       <TD><font size=2><center><b>번호</b></center></font></TD>
       <TD><font size=2><center><b>글 제목</b></center></font></TD>
       <TD><font size=2><center><b>작성자</b></center></font></TD>
       <TD><font size=2><center><b>작성일</b></center></font></TD>
       <TD><font size=2><center><b>조회</b></center></font></TD>
   </TR>

<%
if(lastRow > 0) {
   if(key==null || keyword==null){
       strSQL = "SELECT * FROM tblboard WHERE num BETWEEN " + startRow + " and " + endRow + " ORDER BY num DESC";
       rs = stmt.executeQuery(strSQL);
   } else {
       strSQL = "SELECT * FROM tblboard WHERE " + key + " like '%" + keyword + "%' ORDER BY num DESC";
       rs = stmt.executeQuery(strSQL);
   }

for (i = 1; i < listSize; i++){
while(rs.next()){

       int listnum = rs.getInt("num");
       String name = rs.getString("name");
       String email = rs.getString("email");
       String title = rs.getString("title");
       String writedate = rs.getString("writedate");
       int readcount = rs.getInt("readcount");

   <TR bgcolor='ededed'>
       <TD align=center><font size=2 color='black'><%=listnum %></font></TD>
       <TD align=left>
           <a href="write11_output.jsp?num=<%=listnum %>">
           <font size=2 color="black"><%=title %></font></a>
       </TD>
       <TD align=center>
           <a href="<%=email %>">
           <font size=2 color="black"><%=name %></font></a>
       </TD>
       <TD align=center><font size=2><%=writedate %></font>
       </TD>
       <TD align=center><font size=2><%=readcount %></font>
   </TR>

<%
       }
   }

</TABLE>

<TABLE border='0' width='600' cellpadding='0' cellspacing='0'>
   <TR>
       <TD><hr size='1' noshade>
       </TD>
    </TR>
</TABLE>

<%
}

if(lastRow > 0) {
   int setPage = 1;
   int lastPage = 0;
   if(lastRow % listSize == 0)
       lastPage = lastRow / listSize;
   else
       lastPage = lastRow / listSize + 1;

   if(currentPage > 1) {
%>
       <a href="listboard11.jsp?pageNum=<%=currentPage-1%>">[이전]</a>
<%
   }
   for(i=setPage; i<=lastPage; i++) {
       if (i == Integer.parseInt(pageNum)){
%>
       [<%=i%>]
<%
       }else{
%>
       <a href="listboard11.jsp?pageNum=<%=i%>">[<%=i%>]</a>
<%
       }
   }
   if(lastPage > currentPage) {
%>
       <a href="listboard11.jsp?pageNum=<%=currentPage+1%>">[다음]</a>
<%
   }
}
%>

jsp공부중인 학생인데요

게시판을 최근글 순서대로 하고싶은데요

1번에 2번에

5번게시물 10

4번게시물 9

3번게시풀 8

2번게시물 7

1번게시물 6

1 2 3 4 5

현재이렇게나오거든요 ㅜㅜ 근데 이거를 최근글 순서대로

12 7 2

11 6 1

10 5

9 4

8 3

이렇게 나오게할수는있나요ㅠㅠ

맴조우 (2 Point)ㆍ2019.06.07 11:02ㆍ조회 3920ㆍ RSS

코스모스팜 스레드

jsp게시판 글순서

스토어인기제품 더보기

커뮤니티새로운 글 더보기