package common;

import java.io.Closeable;
import java.sql.*;

import javax.sql.*;
import javax.naming.*;

/**
 * 創建一個數據庫鏈接 
 * jdbc直連
 *  隋玉杰
 */
public class DAO {
	public static Connection getConnection2() {
		Connection conn = null;
		try {
			Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
			String url = "jdbc:sybase:Tds:192.168.0.40:4200/file?charset=cp936&jconnect_version=2";
			conn = DriverManager.getConnection(url, "sa", "");
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return conn;
	}
	
	public static Connection getConnection3() {
		Connection conn = null;
		try {
			Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
			String url = "jdbc:sybase:Tds:192.168.0.40:4200/lawdbs?charset=cp936&jconnect_version=2";
			conn = DriverManager.getConnection(url, "sa", "");
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return conn;
	}

	/**
	 * 創建一個數據庫鏈接
	 * resin連接池
	 * 隋玉杰
	 */
	public static Connection getConnection() {
		Connection conn = null;
		try {
			DataSource ds = null;
			InitialContext ctx = new InitialContext();
			ds = (DataSource) ctx.lookup("java:comp/env/jdbc/filedown");
			conn = ds.getConnection();
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return conn;
	}
	/**
	 * 
	* @author 隋玉杰  E-mail: suiyj1158@hotmail.com
	* @version 創建時間：Nov 27, 2008 2:54:57 AM 
	* 關閉連接  三個重載
	 */
	public static void closeResource(ResultSet rs){
		if(rs!=null){
			try {
				rs.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
			
		}
	}
	public static void closeResource(Statement stmt){
		if(stmt!=null){
			try {
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
			
		}
	}
	public static void closeResource(Connection conn){
		if(conn!=null){
			try {
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
			
		}
	}
	public static void closeResource(PreparedStatement	ps){
		if(ps!=null){
			try {
				ps.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
			
		}
	}

}