´¿JSP·ÖÒ³´úÂëÖ®sqlserver2005/2008
ÉÏһƪ·ÖÒ³ÎÄÕ£¬ÊÇÓÃÓÚmysql£¬ÉÔ΢ÐÞ¸ÄÏ£¬ÓÃÓÚSqlserver2005/2008£¬Ã»ÓÐÒì³£´¦Àí¡£Ã»Óп¼ÂÇÐÔÄܵȡ£
ÏÖ½«´úÂëÌù³ö£¬ÒÔ¹©³õѧÕ߲ο¼£º
×¢£ºÑûÔÂʹÓû·¾³Eclipse 3.4.2+Tomcat 6.18+Sqlserver2005 sp3µ÷ÊԳɹ¦¡£
Ò³ÃæpagelistDemo.jspÄÚÈÝ£º
Code
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
//Á¬½Ó×Ö·û´®
String url = "jdbc:sqlserver://" + Globals.Server
+ ";databaseName=" + Globals.DbName;
Class.forName(Globals.driverName).newInstance();
Connection connection = DriverManager.getConnection(url,
Globals.username, Globals.pwd);
Statement statement = connection.createStatement();
//ÿҳÏÔʾ¼Ç¼Êý
int PageSize = 10;
int StartRow = 0; //¿ªÊ¼ÏÔʾ¼Ç¼µÄ±àºÅ
int PageNo = 0;//ÐèÒªÏÔʾµÄÒ³Êý
int CounterStart = 0;//ÿҳҳÂëµÄ³õʼֵ
int CounterEnd = 0;//ÏÔʾҳÂëµÄ×î´óÖµ
int RecordCount = 0;//×ܼǼÊý;
int MaxPage = 0;//×ÜÒ³Êý
int PrevStart = 0;//ǰһҳ
int NextPage = 0;//ÏÂÒ»Ò³
int LastRec = 0;
int LastStartRecord = 0;//×îºóÒ»Ò³¿ªÊ¼ÏÔʾ¼Ç¼µÄ±àºÅ
//»ñÈ¡ÐèÒªÏÔʾµÄÒ³Êý£¬ÓÉÓû§Ìá½»
if (request.getParameter("PageNo") == null) {&n
Ïà¹ØÎĵµ£º
<%
int a =1;
out.println("<input type='checkbox' value='"+a+"'>");
%>
<%int b =1 ;%>
<i ......
Ê×ÏÈ˵˵ΪʲôҪ¾²Ì¬»¯¡£
¶ÔÓÚÏÖÔÚµÄWeb ApplicationÀ´Ëµ£¬¶¯Ì¬Ò³ÃæÊÇÕ¼Óоø¶Ô¸ßµÄµØÎ»µÄ£¬ÕýÒòΪÓÐÁ˶¯Ì¬»¯£¬²ÅÓÐÁËÏÖÔÚWebµÄ·á¸»¶à²Ê£¬µ«ÊÇÈçͬËùÓбðµÄÊÂʵһÑù£¬ºÃ´¦ÍùÍù¶¼ÊÇÓдú¼ÛµÄ¡£
ΪÁ˲úÉú³ö¶¯Ì¬µÄЧ¹û£¬Ã¿Ò»´Î¶ÔÒ³ÃæµÄÇëÇó¶¼»áÒªÇó·þÎñÆ÷¶ÔÒ³Ãæ½øÐбàÒë»òÕßÖ´ÐУ¬ÕâЩ²Ù×÷¶¼ºÜÏûºÄϵͳ×ÊÔ´¡£Èç¹ûÕâÆÚ¼ä»¹ÓÐ ......
JSPµÄ×¢ÊÍ
<%--........--%>
JSPÖ¸ÁîºÍJSP¶¯×÷£¨±ê×¼µÄJSP±êÇ©£©
JSPÖ¸ÁîµÄÓï·¨
<%@... ....%>
<%@include file="...."%> °üº¬Ö¸Á°üº¬Ö¸Áî»á½«Òª°üº¬µÄÎļþ´úÂëÔÑùÊä³öµ½±¾Ò³Ã棨ÔÚ·Òëʱ°Ñ°üº¬ÎļþµÄÄÚÈÝÒýÈë²¢ºÏ²¢£©£¬²»½øÐзÒ룬fileÊôÐÔÖÆ¶¨Òª°üº¬µÄÎļþµÄÃû×Ö£¨×¢ÒâÒª°üº¬µÄÎļþµÄ·¾¶£©£ ......
(1)include ÔÚJSP±àÒë³ÉJavaÀàÎļþʱ£¬ÏȽ«includeÎļþÄÚÈݺϲ¢ºó£¬ÔÙ½øÐбàÒë
(2)jsp:include ÔËÐÐʱºÏ²¢,»á½«ÔËÐÐʱµÄ½á¹û°üº¬½øÀ´
(3)c:import ÔËÐÐʱºÏ²¢,»á½«ÔËÐÐʱµÄ½á¹û°üº¬½øÀ´
Òò´Ë£¬
£¨1£©ÀûÓÃinclude°üº¬µÄÒ³ÃæÖÐÈç¹û°üº¬Á˺ÍÔÒ ......