JAVA MSN机器人主要代码开放

Tomcat中通过JNDI配置访问数据库 
 
   
 
 
1，所需要的jar文件：commons-pool.jar, commons-dbcp.jar

2，server.xml的配置：

<Resource name="jdbc/hellohibernate" scope="Shareable" auth="Container" type="javax.sql.DataSource"/>   <ResourceParams name="jdbc/hellohibernate">    <parameter>     <name>factory</name>     <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>    </parameter>    <parameter>              <name>removeAbandoned</name>              <value>true</value>            </parameter>   <parameter>              <name>logAbandoned</name>              <value>true</value>            </parameter>   <!-- DBCP database connection settings -->    <parameter>     <name>url</name>     <value>jdbc:mysql://localhost:3306/test</value>    </parameter>    <parameter>     <name>driverClassName</name><!--<value>com.mysql.jdbc.Driver</value>-->     <value>org.gjt.mm.mysql.Driver</value>   </parameter>    <parameter>     <name>username</name>     <value>root</value>    </parameter>    <parameter>     <name>password</name>     <value></value>    </parameter> 

   <!-- DBCP connection pooling options -->    <parameter>     <name>maxWait</name>     <value>3000</value>    </parameter>    <parameter>     <name>maxIdle</name>     <value>100</value>    </parameter>    <parameter>     <name>maxActive</name>     <value>10</value>    </parameter>   </ResourceParams> 

3，程序中的调用：

Context ctx = new InitialContext();            if (ctx == null)                throw new Exception("Boom - No Context");

            DataSource ds =                (DataSource) ctx.lookup(                "java:comp/env/jdbc/hellohibernate");

            if (ds != null) {                Connection conn = ds.getConnection();

                if (conn != null) {                    foo = "Got Connection " + conn.toString();                    Statement stmt = conn.createStatement();                    ResultSet rst =                        stmt.executeQuery(                        "select username,id from user");                    if (rst.next()) {                        foo = rst.getString(1);                        bar = rst.getInt(2);                    }                    conn.close();                }            }