Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

´¿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


Ïà¹ØÎĵµ£º

jsp servletÖеĹýÂËÆ÷FilterÅäÖÃ×ܽá

Ô­ÎĵØÖ·£ºhttp://hi.baidu.com/wangking/blog/item/8a109423ff3d2341ac34dec9.html
ÔÚJava web¿ª·¢Öг£»áʹÓõ½¹¦ÄÜÇ¿´óµÄ¹ýÂËÆ÷£¬Ëû±Ï¾¹ÄܸøÎÒÃÇ´øÀ´ºÜ´óµÄ·½±ã£¬µ«ÊÇÕë¶Ô¹ýÂ˵Ä×ÊÔ´ÎÒÃÇÐèÒªÏêϸµÄÁ˽âËûÃÇÔÚweb.xmlÖеÄÅäÖÃÐÅÏ¢¡£Õâ¸ö¸ù¾Ý¼¸ÖÖ³£ÓõIJ»Í¬Çé¿ö½øÐÐÁË×ܽ᣺
1¡£Èç¹ûÒªÓ³Éä¹ýÂËÓ¦ÓóÌÐòÖÐËùÓÐ×ÊÔ´£º
< ......

ʹÓÃjsp¹ýÂËÆ÷µÄÍêÕûÀý×Ó

ÔÚ±¾ÆªÎÄÕÂÖн«Ê¹ÓùýÂËÆ÷½øÐбàÂëת»»¡¢µÇ½ÑéÖ¤¡¢·ÀÕ¾ÍâÌá½»µÄ¹ý³Ì£¬ÎªÁËÑÝʾ£¬ÎҰѱàÂëת»»·ÅÔÚÒ»¸öfilterÖУ¬µÇ½ÑéÖ¤ºÍ·ÀÕ¾ÍâÌá½»·ÅÔÚÁíÒ»¸öfilterÖУ¬Á½¸öfilter½øÐд®Áª¹¤×÷¡£
1¡¢ÎªÁËÑÝʾ£¬ÏÈÖÆ×÷ÕâÁ½¸öfilter
//Õâ¸öfilterÊÇΪÁË×ö±àÂëת»»£¬Ö»Òª·ÃÎÊ.jspÍøÒ³¶¼Òª¹¦¹ýÕâ¸öfilter
/**ÀàÃû£ºfilter.Encoding
*×÷ ......

jspѧϰ±Ê¼Ç3

×¢Ò⣺jsp:useBean¶¯×÷£¬ÓÃ±íµ¥ÎªBeanµÄÊôÐÔ¸³ÖµÊ±£¬Ò²¾ÍÊÇjsp:setProperty¶¯×÷Ö±½ÓÊÕÇëÇóÖÐ±íµ¥µÄÐÅϢΪʹÓõÄBeanµÄÊôÐÔ½øÐи³Öµ£¬Ò²¾ÍÊÇ˵jsp:useBeanºÍjsp:setProperty²»Äܹ»³öÏÖÔÚΪÕâ¸öBeanµÄÊôÐÔ¸³ÖµµÄform±íµ¥µÄÒ³ÃæÉÏ¡£
JSPµÄÒì³£´¦Àí
<%@page errorPage="xxx.jsp"%> Ö¸¶¨±¾Ò³Ãæ³öÏÖÒì³£ºóҪתµ½µÄÒ³Ãæ
& ......

sqlserver°²×°ºÍ¿ò¼Ü

ÎÒÃÇ×ÜÊǰÑSQL Server Õâ¸öµ¥´Ê¹ÒÔÚ×ì±ß£¬Ò²ÐíºÜÉÙÓÐÈË˼¿¼¹ý SQL Server µ½µ×ÊÇʲô¶«Î÷¡£Õâ¸öÎÊÌâºÜÄÑÓü¸¾ä»°½²Çå³þ¡£ÎÒÃÇÖ®ËùÒÔÒªÓÃÁ¬Ôصķ½Ê½ÌÖÂÛ SQL Server£¬¾ÍÊÇÒª´Ó²»Í¬µÄ½Ç¶È²ûÊöÕâ¸öÎÊÌâ¡£
¡¡¡¡Ò»¡¢·þÎñÆ÷×é¼þ
¡¡¡¡SQL Server 2000ÓÉÁ½¸ö²¿·Ö×é³É£º·þÎñÆ÷×é¼þºÍ¿Í»§¶Ë¹¤¾ß¡£
¡¡¡¡1.ÄÚÈÝ
¡¡¡¡SQL ServerµÄ·þ ......

JSPÖеļ¸ÖÖ°üº¬Ò³Ãæ·½·¨µÄÇø±ð

(1)include     ÔÚJSP±àÒë³ÉJavaÀàÎļþʱ£¬ÏȽ«includeÎļþÄÚÈݺϲ¢ºó£¬ÔÙ½øÐбàÒë
(2)jsp:include     ÔËÐÐʱºÏ²¢,»á½«ÔËÐÐʱµÄ½á¹û°üº¬½øÀ´
(3)c:import     ÔËÐÐʱºÏ²¢,»á½«ÔËÐÐʱµÄ½á¹û°üº¬½øÀ´
Òò´Ë£¬
£¨1£©ÀûÓÃinclude°üº¬µÄÒ³ÃæÖÐÈç¹û°üº¬Á˺ÍÔ­Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ