jspÁ¬½ÓÊý¾Ý¿â
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"%>
<%
/*********************
********* JDBC_ODBCÁ¬½Ó SQL Server Êý¾Ý¿â£¬²»ÐèÒªÉèÖÃÊý¾ÝÔ´
********* Date: 2005.8
********* Email:fanwsp@126.com
********* Author: DreamTime [ÃÎÏëÄ껪]
********* ÓÐÈκλ¶ÓÌá³öÖ¸Õý
****************************/
//Çë¸ù¾ÝÐèÒª£¬Ñ¡ÔñÒ»ÖÖ·½·¨£¬È¥µôÏàÓ¦µÄ·½·¨µÄ×¢ÊÍ£¬²¢×¢ÊÍÆäËüûÓÐʹÓõÄ
//ÒÔϼ¸ÏîÇë×ÔÐÐÐÞ¸Ä
String server="localhost"; //SQL Server ·þÎñÆ÷µÄµØÖ·
String dbname="test"; //SQL Server Êý¾Ý¿âµÄÃû×Ö
String user="sa"; //SQL Server Êý¾Ý¿âµÄµÇ¼Óû§Ãû
String pass="chfanwsp"; //SQL Server Êý¾Ý¿âµÄµÇ¼ÃÜÂë
String port="1433"; //SQL Server ·þÎñÆ÷µÄ¶Ë¿ÚºÅ£¬Ä¬ÈÏΪ1433
/***** ·½·¨1£º *******
* ÓÃnet.sourceforge.jtds.jdbc.Driver
* (http://jtds.sourceforge.net/) &n
Ïà¹ØÎĵµ£º
ÉÏÍø¿´Á˺ö࣬¾ÍÕâһƪ½â¾öÁËÎÒµÄÎÊÌ⣬ÏÖת£¬ÎÒµÄÏîÄ¿ÓõÄÊÇMVC¼Ü¹¹£¬ÓÐͳһµÄ¿ØÖÆÆ÷£¬×ªÏò²»Í¬µÄAction£¬ÉÏÍø¿´Á˺ö࣬´ó²¿·ÖÊÇ˵¼ÓÈërequest.setCharacterEncoding("utf-8");µ«ÊǾ¹ýÎÒµÄÊÔÑ飬ÕâÖ»ÓÐÔÚÀûÓÃJSP´¦Àí±íµ¥´«ÊäÊý¾Ýʱ²Å¿ÉÓã¬ÔÚÎҵĶ«Î÷ÖÐÎÞ·¨½â¾ö£¬ºóÀ´·¢ÏÖ»¹ÊÇÓÃFilterChainºÃ£¬ºÇºÇ£¬Öص㻹ÊÇÔÚrequest ......
¸Ð¾õÎÄÕºܺþÍתһÏÂ,Ê×ÏȸÐлÕâλÈÊÐÖ!http://www.blogjava.net/wake/archive/2006/04/28/43843.html
½ü¼¸Ìì²»ÊǺÜæ£¬¾ÍÏë¿´¿´¹ØÓÚ WEB ·½Ê½ (Jsp) ºǫ́ȨÏÞ¿ØÖƵÄÉè¼ÆÊµÏÖÎÊÌâ , ÔÚ Google ËÑÁËһϣ¬Ò»´ó¶ÑµÄ¶«Î÷£¬µ±¿´µ½Í·´óµÄʱºò¾ö¶¨×Ô¼ºÏÈÊÔ×Å×öÒ»¸ö¼òµ¥Àý×Ó¡£
ÏÈÍÆ¼ö´ó¼ÒÓÐʱ¼ä¿´Ò»Ï¹ØÓÚ RBAC ¼´½ÇÉ«·ÃÎÊ¿ØÖÆ ......
[list=1]
ÎÒÃÇÔÚ×öÑéÖ¤ÂëµÄʱºòÍùÍùÓÉÓÚÒª·´×÷±×£¬ÑéÖ¤ÓÐʱ¹ÊÒâ¼ÓÈë¶àµÄ¸ÉÈÅÒòËØ£¬ÕâʱÑéÖ¤ÂëÏÔʾ²»ºÜÇå³þ£¬Óû§¾³£ÊäÈë´íÎó¡£ÕâÑù²»µ«ÒªÖØÐÂË¢ÐÂÒ³Ãæ£¬µ¼ÖÂÓû§Ã»Óп´Çå³þÑéÖ¤Âë¶øÖØÌî¶ø²»ÊÇÐ޸쬶øÇÒÈç¹ûûÓÐÓÃsession±£´æÏÂÓû§ÊäÈëµÄÆäËüÊý¾ÝµÄ»°(ÈçÐÕÃû)£¬Óû§¸Õ¸ÕÊäÈëµÄÄÚÈÝÒ²²»´æÔÚÁË£¬ÕâÑù¸øÓû§Ôì³É²»ºÃµÄÌåÑé ......
Ò» ¡£×Ô¶¨ÒåJSP±êÇ©µÄ´¦Àí¹ý³Ì£º
¡¡ 1£®ÔÚJSPÖÐÒýÈë±êÇ©¿â£º
¡¡ 2£®ÔÚJSPÖÐʹÓñêÇ©¿â±êÇ©
¡¡ 3£®WebÈÝÆ÷¸ù¾ÝµÚ¶þ¸ö²½ÖèÖеÄprefix£¬»ñµÃµÚÒ»¸ö²½ÖèÖÐÉùÃ÷µÄtaglibµÄuriÊôÐÔÖµ
¡¡ 4£®WebÈÝÆ÷¸ù¾ÝuriÊôÐÔÔÚweb.xmlÕÒµ½¶ÔÓ¦µÄÔªËØ
5£®´ÓÔªËØÖлñµÃ¶ÔÓ¦µÄÔªËØµÄÖµ
6£®WebÈÝ ......
jspÂÒÂëÎÊÌâ½â¾ö
1¡¢Ò»°ãµÄjspÒ³ÃæÏÔʾÂÒÂë
<%@ page contentType="text/html; charset=UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
2¡¢±íµ¥Ìá½»ÖÐÎÄʱ³öÏÖÂÒÂë
Èç¹ûjspÌá½»Ó¢ÎÄ×Ö·ûÄÜÕýÈ·ÏÔʾ£¬¶øÌá½»ÖÐÎÄʱ¾Í»á³öÏÖÂÒÂë¡£
ÔÒò£ºä ......