database.java

qw.rar

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DataBase {
	static{
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			System.err.println("Counld not load driver,reason:"+e.getMessage());
			e.printStackTrace();
		}
	}
	private Connection conn;
	public DataBase() throws SQLException{
		conn = DriverManager.getConnection("jdbc:odbc:DB","","");
	}
	public ResultSet select(String sql) throws SQLException{
		Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_UPDATABLE);//可滚动且不受其他更新影响的、可更新的结果集
		return stmt.executeQuery(sql);
	}
	public int update(String sql) throws SQLException{
		Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_UPDATABLE);
		return stmt.executeUpdate(sql);
	}
	public void disconnect() throws SQLException{
		conn.close();
	}
	private static DataBase dbinstance = null;
	public static final DataBase getInstance() throws SQLException{
		if (dbinstance == null){
			dbinstance =  new DataBase();
		}
		return dbinstance;
		
	}
}