<%@ page language="java" contentType="text/html; charset=euc-kr" %>

<%@ page import = "java.sql.*, java.util.*" %>

<% request.setCharacterEncoding("euc-kr"); %>


<HTML>

<HEAD>

<TITLE> 게시판 </TITLE>


<SCRIPT language="JavaScript">

function Check()

{

if (Form.keyword.value.length < 1) {

alert("검색어를 입력하세요.");

Form.keyword.focus(); 

         return false;

}

}

</SCRIPT>


<META http-equiv="Content-Type" content="text/html; charset=euc-kr">

<style type='text/css'>

<!--

a:link {font-family:"";color:black;text-decoration:none;}

a:visited {font-family:"";color:black;text-decoration:none;}

a:hover {font-family:"";color:black;text-decoration:underline;}

-->

</style>


</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/univdb";



        Class.forName(driverName);

        Connection conn = DriverManager.getConnection(dbURL, "root", "");

        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);



%>


<center><font size='3'><b> 게시판 </b></font></TD>

                                    

<TABLE border='0' width='600' cellpadding='0' cellspacing='0'>

<TR>

<TD><hr size='1' noshade>

</TD>

  </TR>

</TABLE>              

                    

<TABLE border='0' cellspacing=1 cellpadding=2 width='600'>      


<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) {

strSQL = "SELECT " + listSize + " *  FROM tblboard  WHERE num not in  ";

 strSQL = strSQL +  "  ( select" + (currentPage - 1) * listSize + " num FROM tblboard  ";

 

 if(key != null || keyword != null){

  strSQL = strSQL  + " where " + key+" like '%" + keyword + "%' ";

 }

 strSQL = strSQL +  "  order by num desc ) ";



 if(key != null || keyword != null){

  strSQL = strSQL  + " and " + key + " like '%" + keyword + "%' ";

 }


 strSQL = strSQL + "  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>

<%

}

}

%>  


<TABLE border='0' width='600' cellpadding='0' cellspacing='0'>

<TR>

<TD><hr size='1' noshade>

</TD>

  </TR>

</TABLE>                    


<TABLE border=0 width=600>

<TR>

<TD align='center'>

<TABLE border='0' cellpadding='0' cellspacing='0'>

<FORM Name='Form' Method='POST' Action='listboard11.jsp' OnSubmit='return Check()'>

<input type='hidden' name='search' value='1'>

<TR>

<TD align='right'>

<select name='key' style="background-color:cccccc;">

<option value='title' selected><font size='2'>

                                                        글제목</font></option>

<option value='contents'><font size='2'>

                                                        글내용</font></option>

<option value='name'><font size='2'>

                                                        작성자</font></option>

</select>

</TD>

<TD align='left'>

<input type='text' name='keyword' value='' size='20' maxlength='30'>

<input type='submit' value='검색'>

</td>

 </TR>

 </FORM>

 </TABLE> 

</TD>


<TD align='right'>

<a href='write11.jsp'>[등록]</a>

</TD>

</TR>

</TABLE>

                  

</BODY>                     

</HTML>




위 소스 코드로 게시판글의 순서를 1페이지에 최신글이 올라가는 식으로 만들려고하는데


start랑 end 쪽고쳐서 하는건 했는데 서브쿼리를 이용해서 바꾸는방법을 잘모르겠습니다.


sql쪽 쿼리문은 어느정도 독학했는데 서브쿼리 쪽은 깊게 하지 못해서 고민입니다.


혹시 힌트좀 주실수 없을까요?