package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class CopyOfDBHelper {
static DataSource ds=null;
static{
try {
//初始化一个容器
Context context =new InitialContext();
//获得数据源
ds=(DataSource)context.lookup("java:comp/env/jdbc/news");
//Class.forName(cname);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getcon(){
Connection con=null;
try {
con=ds.getConnection();
//con=DriverManager.getConnection(url,"scott","tiger");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
public static void close(Connection con, PreparedStatement ps, ResultSet rs){
try {
if(rs!=null) rs.close();
if(ps!=null) ps.close();
if(con!=null && !con.isClosed()) con.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
public static void close(Connection con, PreparedStatement ps){
close(con, ps, null);
}
}
