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();
%>
Ïà¹ØÎĵµ£º
Ò» ¡£×Ô¶¨Òå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Ìá½»Ó¢ÎÄ×Ö·ûÄÜÕýÈ·ÏÔʾ£¬¶øÌá½»ÖÐÎÄʱ¾Í»á³öÏÖÂÒÂë¡£
ÔÒò£ºä ......
ÄÇôÏÖÔÚ¿ªÊ¼ÎÒÃǵÄ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 ......
ÓÉÓÚϵͳÐèÇó£¬×î½üÔÚ¿ª·¢¹ý³ÌÖн«ÏµÍ³´ÓÔÀ´µÄMySQL×ªÒÆµ½SQL
2000Ï£¬ÆäÖÐÓöµ½ÁËÖî¶àÎÊÌ⣬»¨·ÑÁËÎÒ²»ÉÙʱ¼ä¡£ÏÖÔÚ°ÑÎҵľÑéÄóöÀ´¸æËß´ó¼Ò£¬ºÃÈôó¼ÒÉÙ×ßÍä·£¬½ÚԼʱ¼ä¡£
¡¡¡¡Ê×ÏÈÊÇSQL
2000Êý¾Ý¿âµÄ°²×°ÎÊÌ⣬ÔÚ´ËÎÒÖ÷Òª½²Ð©¹ØÓÚSQL 2000µÄ°æ±¾Óë²Ù×÷ϵͳµÄ¼æÈÝÐÔÎÊÌ⣺SQL
2000×ܹ²ÓÐ7¸ö²»Í¬°æ±¾£¬ÊÊ ......
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"%>
<%
/*********************
&nb ......