81,091
社区成员
发帖
与我相关
我的任务
分享
<%@ page contentType="text/html" pageEncoding="gbk"%>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*"%>
<%
String DSNAME="java:comp/env/jdbc/mydatabase" ;
Context ctx = new InitialContext() ;
DataSource ds = (DataSource) ctx.lookup(DSNAME);
Connection conn = ds.getConnection() ;
%>
<%=conn%>
连接成功并关闭
<%
conn.close() ;//将连接放回池中
%>
package sjy.xg.myc.datasource;
import java.sql.*;//Connection
import javax.sql.*;//DataSource
import javax.naming.*;//Context
public class DatabaseConnection{
private Connection conn = null ;
private String DSNAME="java:comp/env/jdbc/mydatabase" ;
public DatabaseConnection() throws Exception{
Context ctx = new InitialContext() ;
DataSource ds = (DataSource) ctx.lookup(DSNAME);
this.conn = ds.getConnection() ;
}
public Connection getConnection(){
return this.conn ;
}
public void close() throws Exception {
if(this.conn != null){
try{
conn.close() ;
}catch(Exception e){
throw e ;
}
}
}
public static void main(String[] args) throws Exception{
Connection conn = new DatabaseConnection().getConnection();
System.out.println("sucess"+conn);
}
}
<%@ page contentType="text/html" pageEncoding="gbk"%>
<%@ page import="sjy.xg.myc.datasource.*"%>
<%@ page import="java.sql.*"%>
<%
Connection conn = new DatabaseConnection().getConnection() ;
%>
<%=conn %>
<!-- The contents of this file will be loaded for each web application -->
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
</Context>