JSPÖÐÀûÓÃÊý¾ÝÔ´¶ÔÏó½¨Á¢Êý¾Ý¿âÁ¬½Ó
ÅäÖóÌÐòµÄÔËÐÐĿ¼ÓëJDBCÊý¾ÝÔ´:
<Context path="/test" docBase="F:\JSPLesson\test" reloadable="true">
<Resource name="jdbc/bookstore" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="123456"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bookstore?autoReconnect=true"/>
</Context>
JSPÖÐͨ¹ýÈçÏ·½Ê½µÃµ½Êý¾Ý¿âÁ¬½Ó:
<%
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/bookstore");
Connection conn = ds.getConnection();
%>
Ïà¹ØÎĵµ£º
¸Ð¾õÎÄÕºܺþÍתһÏÂ,Ê×ÏȸÐлÕâλÈÊÐÖ!http://www.blogjava.net/wake/archive/2006/04/28/43843.html
½ü¼¸Ìì²»ÊǺÜæ£¬¾ÍÏë¿´¿´¹ØÓÚ WEB ·½Ê½ (Jsp) ºǫ́ȨÏÞ¿ØÖƵÄÉè¼ÆÊµÏÖÎÊÌâ , ÔÚ Google ËÑÁËһϣ¬Ò»´ó¶ÑµÄ¶«Î÷£¬µ±¿´µ½Í·´óµÄʱºò¾ö¶¨×Ô¼ºÏÈÊÔ×Å×öÒ»¸ö¼òµ¥Àý×Ó¡£
ÏÈÍÆ¼ö´ó¼ÒÓÐʱ¼ä¿´Ò»Ï¹ØÓÚ RBAC ¼´½ÇÉ«·ÃÎÊ¿ØÖÆ ......
1 £©Ê×ÏȽ¨Á¢¹ÜÀíÓû§±í£¬ÆäÖÐ UserPopedom ¼Ç¼Óû§µÄȨÏÞ×Ö·û£¬ÆäʵҲ¾ÍÊÇһЩ JSP »òÕß ACTION µÄÎļþÃû£º
CREATE TABLE [dbo].[AdminUser] (
[UserID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[UserPass] [varchar ......
ÄÇôÏÖÔÚ¿ªÊ¼ÎÒÃǵÄjspºÍÊý¾Ý¿âÖ®Âðɡ£
Ò»¡¢jspÁ¬½ÓOracle8/8i/9iÊý¾Ý¿â£¨ÓÃthinģʽ£©
testoracle.jspÈçÏ£º
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"java.sql.*\"%>
<html>
<body>
<%Class.forName(\"oracle.jdbc.driver.Oracl ......
¡¡ÏÖÔÚÓкöà³õѧjspµÄÍøÓѾ³£»áÎÊÊý¾Ý¿âÔõôÁ¬½Ó°¡£¬ÔõôÀϳö´í°¡£¿ËùÒÔÎÒ¼¯ÖеÄÔÚÕâдƪÎÄÕ¹©´ó¼Ò²Î¿¼£¬ÆäʵÕâÖÖ°ÑÊý¾Ý¿âÂ߼ȫ²¿·ÅÔÚjspÀïδ±ØÊǺõÄ×ö·¨£¬µ«ÊÇÓÐÀûÓÚ³õѧÕßѧϰ£¬ËùÒÔÎÒ¾ÍÕâÑù×öÁË£¬µ±´ó¼Òѧµ½Ò»¶¨³Ì¶ÈµÄʱºò£¬¿ÉÒÔ¿¼ÂÇÓÃMVCµÄģʽ¿ª·¢¡£ÔÚÁ·Ï°ÕâЩ´úÂëµÄʱºò£¬ÄãÒ»¶¨½«jdbcµÄÇý¶¯³ÌÐò·Åµ½·þÎñÆ÷µÄÀà ......
Ò»¸öÏîÄ¿ÖлáÔÚ¶à¸öJSP½çÃæÖÐʹÓÃÏÂÀ¿ò£¬ÈÕÆÚ¿Ø¼þ£¬·ÖÒ³¿Ø¼þ¡£ÈôÄܽ«´ËÀà¿Ø¼þ³éÏó³öÀ´£¬×ö³ÉÒ»¸öJspTagµÄ»°£¬ÄÇʹÓÃÆðÀ´¾Í·½±ã¶àÁË¡£Í¬Ê±±ãÓÚJSPµÄÔĶÁ£¬¸üÖ÷ÒªµÄÊÇ·½±ãÁËÏîÄ¿µÄ¹ÜÀíÓëά»¤¡£
ÏÂÃæÒÔÐÐÒµÏÂÀ¿ò¿Ø¼þΪÀý½éÉÜ×Ô¶¨ÒåJspTag£¬ÓÈÆä×¢ÒâºìÉ«±ê×¢´¦£¬´Ó¶ÔÓ¦¹ØÏµ¿ÉÒÔÕÒµ½ÔËÓùæÂÉ£º
Ê×ÏȽ¨Á¢/WEB-INF/tags/my-t ......