dbaccess.java

java课程的资料以及实验的代码

package com.hesj.db;

import java.sql.*;

public class DBAccess{
	private static String url="jdbc:odbc:SuperShop";
	
	static{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException ex){
			System.out.println(ex.getMessage());
		}
	}
	
	
	private Connection conn=null;
		
	public void open()throws SQLException{
		if(conn!=null && !conn.isClosed()) return;
			conn=DriverManager.getConnection("jdbc:odbc:Gooddb");
	}
	
	public ResultSet sqlQuery(String sql)throws SQLException{	
		if(conn.isClosed()) return null;
		Statement  stm=conn.createStatement();
		ResultSet rs=stm.executeQuery(sql);
		return rs;
	}
	
	public void close()throws SQLException{
		if(!conn.isClosed()){
			conn.close();
		}
	}
}