使用JDNI连接数据库

 

一 server.xml

 

<Context docBase="BCS2" path="/BCS2" reloadable="true" source="org.eclipse.jst.jee.server:BCS2">
                <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxIdle="10" maxWait="1000" name="jdbc/uinfo" password="mysql" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/test?autoReconnect=true" username="root"/>
            </Context>

二项目web.xml

 

 

<resource-ref>
    <res-ref-name>jdbc/uinfo</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

三DB

 

 

public static Connection getConnection(){

    DataSource ds;
    try {
        Context ctx=new InitialContext();
        ds = (DataSource) ctx.lookup("java:comp/env/jdbc/uinfo");
        con = ds.getConnection();
    } catch (NamingException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    return con;
}

注意：一定要将mysql-connector-java-5.1.7-bin.jar拷贝到tomcat的lib下

 

复制搜索

更多信息请查看 java进阶网 http://www.javady.com/index.php/category/thread