¼òµ¥µÄjsp·ÖÒ³
<%@ page import="java.sql.*,java.io.*" %>
<%
int intPage;//´ýÏÔʾµÄÒ³Âë
int pageSize;//ÿҳÏÔʾµÄÌõÄ¿
int pageCount;//×ÜÒ³Êý
int rowCount;//¼Ç¼×ÜÊý
String strPage;//»ñÈ¡´ýÏÔʾҳÂë
pageSize=12;//ÉèÖÃÿҳÏÔʾÌõÊý
Connection con;//Á¬½Ó¶ÔÏó
Statement stmt;//Êý¾Ý¿â¶ÔÏó
ResultSet rs£»//½á¹û¼¯
String strCon;//Á¬½Ó×Ö·û´®
strPage=request.getParameter("page");
if(strPage==null)
{
int page=1;
}
else
{
intPage=Integer.parseInt(strPage);
if(intPage<1)
intPage=1;
}
//×°ÔØSQLÇý¶¯
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
out.print("¼ÓÔØÇý¶¯´íÎó");
}
//ÉèÖÃÁ¬½Ó×Ö·û´®
strCon="jdbc:mysql://localhost:3306/database";
//Á¬½ÓÊý¾Ý¿â
con=DriverManager.getConnection(strCon,"root","");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//ÉèÖÃsqlÓï¾ä
strSql="select * from bwf_appraise order by appraiseDate desc";
//Ö´ÐÐSQLÓï¾ä²¢»ñÈ¡½á¹û¼¯
rs=stmt.executeQuery(strSql);
//»ñÈ¡¼Ç¼×ÜÊý
rs.last();
rowCount=rs.getRow()
%>
Ïà¹ØÎĵµ£º
½ñÌìÏÂÎ磬ÁÙÏ¿εÄʱºòÓиöѧÉúÎÊÁ˸ö¹ØÓÚ¹ýÂËÆ÷µÄʹÓõÄÎÊÌ⣬Ҳ²»ÖªµÀËý´Ó¸ãÏëµ½µÄ£¬¹À¼ÆÒ²ÊÇÍøÉÏÄÄλ´ïÈ˵ÄÑÝʾ£¬Ëý˵ÔÀ´ÄǸö¹¦ÄÜÓÐЩ¾ÖÏÞ£¬×Ô¼ºÀ©ÕÅÁËһϣ¬µ«ÀÏÊÇ´ï²»µ½Ð§¹û¡£ÓÚÊǾÍÀ´ÕÒÎÒÁË¡£
ËýµÄÐèÇóÈçÏ£º
1¡¢Ä¿±ê£ºÏÞÖÆµÇ¼Óû§µÄ·ÃÎÊÒ³Ãæ£¬¸ù¾Ý²»Í¬µÄȨÏÞ¿ÉÒÔ²éѯÏàÓ¦µÄÒ³Ãæ¡£
2¡¢³¡¾°£ºÒÑÓÐÈý¸öÓû§admi ......
session¾ÍÊÇÒ»¸öÈ«¾Ö±äÁ¿£¬ÊÇä¯ÀÀÆ÷Ïß³ÌÔÚ·þÎñÆ÷¶ËµÄ´úÀí¡£web·þÎñ³ÌÐòÖ»Òª´ò¿ª£¬session¾Í»á´æÔÚ£¬µ±ÄãµÚÒ»´Î·ÃÎÊʱ£¬session»á×Ô¶¯ÎªÄã·ÖÅäÒ»¸ösession ID£¬ËùÒÔsessionΪн¨Á¢µÄ£¬ËùÒÔsession.isNew()Ϊtrue¡£µ±ÄãË¢ÐÂÒ³ÃæÊ±£¬Õâ¸ösession IDÒ»Ö±´æÔÚ(session.getId()²»±ä)£¬²»»áÏûʧ£¬ËùÒÔsession.isNew()Ϊfalse¡£³ý· ......
jsp(java server pages)ÊÇÒ»ÖÖ¼¼Êõ,ÓÃÀ´´¦Àí¿Í»§¶ËÇëÇóµÄ,(Ä¿µÄÊÇΪÁË´ïµ½¶¯Ì¬ÍøÒ³µÄЧ¹û),´¦Àíºó´«¸ø¿Í»§¶Ë(Ò²¿ÉÒÔ˵¸øÁËä¯ÀÀÆ÷),¾Í³ÉÁËÎÒÃÇ¿´µ½µÄ¾²Ì¬ÍøÒ³(HTML)
HTML ¼ÓÈëJava´úÂë(±ÈÈç<%...%>)²»»áÓÖÈκÎЧ¹û,Ö»»á½²<%...%>ÏÔʾµ½Ò³ÃæÐÐ,»òÕ߸ù¾ÝλÖÃÓ°Ïì±àÒë. JSP(Java Server Page)Ò³ÃæÆäʵ¾ÍÊÇ ......