database.java

来自「自己做的一个企业招标系统,B/S结构。开发工具Eclipse」· Java 代码 · 共 61 行

/**
 * 
 */
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());
		}
	}

}