dbconnection.java

来自「这是一个超市管理系统」· Java 代码 · 共 55 行

package file2;
import java.sql.*;
public class DBConnection {
	private String driver="sun.jdbc.odbc.JdbcOdbcDriver";
	private String dataSource="jdbc:odbc:goods";
	private Connection con=null;
	private Statement st=null;
	private Statement st1=null;
	private ResultSet rs=null;
	private ResultSet rs1=null;
	public DBConnection(){
		try{
			Class.forName(driver);
			con=DriverManager.getConnection(dataSource);
			st=con.createStatement();
			st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	public ResultSet executeSelect(String sql){
		try{
			rs=st.executeQuery(sql);
			return rs;
		}catch(SQLException e){
			e.printStackTrace();
			return null;
		}
		
	}
	public ResultSet executeSelect1(String sql){
		try{
			rs1=st1.executeQuery(sql);
			return rs1;
		}catch(SQLException e){
			e.printStackTrace();
			return null;
		}
		
	}
	public void executeDML(String sql){
		try{
			st.execute(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		
	}
	public void resetCon(){
		this.con=null;
	}
}