JSPµØÖ·³ØÁ¬½ÓMySQLÊý¾Ý¿âʵÀý

JSPµØÖ·³ØÁ¬½ÓMySQLÊý¾Ý¿âʵÀý
2009-11-29 13:14
ËùÐèÒªÓõ½µÄjarÎļþ:
mysql-connector-java-5.1.7-bin.jar(*Ö÷ÒªÎļþhttp://dev.mysql.com/downloads/connector/j/5.1.html)
commons-dbutils-1.1.jar(QueryRunnerËùÐè°ühttp://commons.apache.org/downloads/download_dbutils.cgi)
ʵÀý:
1.°ÑËùÐè°ü·Åµ½TomcatµÄlibĿ¼ÏÂ.
2.ÐÞ¸Äcontext.xml(λÓÚTomcatµÄconfĿ¼ÏÂ)
ÔÚ<Context>...<Context/>Ö®¼ä¼ÓÈëÒÔÏ´úÂë
<Resource name = "jdbc/mysqlds"
    auth = "Container"
    type = "javax.sql.DataSource"
    maxActive = "100"
    maxIdle = "30"
    maxWait = "10000"
    username = "root"
    password = "123456"
    driverClassName = "com.mysql.jdbc.Driver"
    url = "jdbc:mysql://127.0.0.1/angelsix"/>
3.JSPÁ¬½Ó´úÂë
н¨JavaBean: DbConn.java
/********************************/
package com.angelsixth;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
public class DbConn {
public static QueryRunner getQueryRunner() {
   // Êý¾ÝÔ´¶ÔÏó¿ÉÒÔÀí½âΪÁ¬½Ó³ØµÄ¹ÜÀíÕß,ͨ¹ýËû¿ÉÒÔ»ñÈ¡Êý¾Ý¿âµÄÁ¬½Ó
   DataSource ds = null;
   try {
    // ͨ¹ýÔÚcontext.xmlÎļþ,É趨µÄÊý¾ÝÔ´µÄÃû×Ö,»ñÈ¡Êý¾ÝÔ´¶ÔÏó
    Context context = new InitialContext();
    ds = (DataSource) context.lookup("java:/comp/env/jdbc/mysqlds");
   } catch (Exception e) {
    System.out.println("»ñÈ¡Êý¾ÝԴʱ³ö´í");
   }
   // DButilsÖкËÐÄÀà,Éú³É¶ÔÏóʱ´«µÝÊý¾ÝÔ´¶ÔÏó
   QueryRunner qr = new QueryRunner(ds);
   return qr;
}
}