www.pudn.com > zhaobiao.rar > dataBase.java

/** 
 *  
 */ 
package com.centralsoft.zhaobiao.util; 
 
import java.sql.*; 
 
/** 
 * @author Administrator 
 * 
 */ 
public class dataBase { 
	private Connection conn = null; 
	private Statement stmt = null; 
	private ResultSet rs = null; 
	private String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
	private String url = "jdbc:odbc:zhaobiaoDataSource"; 
	private String user = "sa"; 
	private String password = "12345678"; 
	public dataBase() { 
		this.setConnection(); 
	} 
	public void setConnection() { 
		try { 
			Class.forName(sDBDriver); 
			//conn = DriverManager.getConnection(url,user,password); 
		} catch (Exception e) { 
			e.printStackTrace(); 
			System.out.println("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡"+e.getMessage()); 
		} 
	} 
	public Connection getConnection() { 
		try { 
			conn = DriverManager.getConnection(url,user,password); 
		} catch (Exception e) { 
			System.out.println(e.getMessage()); 
		} 
		return conn; 
	} 
	public ResultSet getResultSet(String sql) { 
		try { 
			conn = DriverManager.getConnection(url,user,password); 
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
			rs = stmt.executeQuery(sql); 
		} catch (Exception e) { 
			System.out.println(e.getMessage()); 
		} 
		return rs; 
	} 
	public void closeConn() { 
		try { 
			if (conn != null) { 
				conn.close(); 
			} 
		} catch (Exception e) { 
			System.out.println(e.getMessage()); 
		} 
	} 
 
}