jsp·ÖÒ³£¨oracle+jsp+apache£©

Ò» Ç°Ìá 
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
±í£ºmytable 
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼Í¼idºÅ 
¶þ Ô´³ÌÐò 
<%String sConn="ÄãµÄÁ¬½Ó" 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
Connection conn=DriverManager.getConnection(sConn,"ÄãµÄÓû§Ãû","ÃÜÂë"); 
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
Statement stmtcount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
ResultSet rs=stmt.executeQuery("select * from mytable_view"); 
String sqlcount="select count(*) from mytable_view"; 
ResultSet rscount=stmtcount.executeQuery(sqlcount); 
int pageSize=ÄãµÄÿҳÏÔʾ¼Í¼Êý£» 
int rowCount=0; //×ܵļǼÊý 
while (rscount 
int pageCount; //×ܵÄÒ³Êý 
int currPage; //µ±Ç°Ò³Êý 
String strPage; 
strPage=request.getParameter("page"); 
if (strPage==null){ 
currPage=1; 
} 
else{ 
currPage=Integer.parseInt(strPage); 
if (currPage<1) currPage=1; 
} 
pageCount=(rowCount+pageSize-1)/pageSize; 
if (currPage>;pageCount) currPage=pageCount; 
int thepage=(currPage-1)*pageSize; 
int n=0; 
rs.absolute(thepage+1); 
while (n<(pageSize)&&!rs 
%>; 
<%rs.close(); 
rscount.close(); 
stmt.close(); 
stmtcount.close(); 
conn.close(); 
%>; 
//ÏÂÃæÊÇ µÚ¼¸Ò³µÈ 
<form name="sinfo" method="post" action="sbinfo_index.jsp?condition=<%=condition%