dbmanager.java

来自「实现图书借阅管理,运用access数据库」· Java 代码 · 共 34 行

package bookmanager;
import java.sql.*;
public class DBManager{
	public DBManager(){}
	public ResultSet getResult(String sql){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn=DriverManager.getConnection(strurl);
			Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			ResultSet re=stmt.executeQuery(sql);
			return re;
		}
		catch(Exception e){
			System.out.println("getResult------"+e.toString());
			return null;
		}
	}
	public boolean executeSql(String sql){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn=DriverManager.getConnection(strurl);
			Statement stmt=conn.createStatement();
			stmt.executeUpdate(sql);
			conn.commit();
			return true;
		}
		catch(Exception e){
			System.out.println("executeSql----"+e.toString());
			return false;
		}
	}
	ResultSet re;
	String strurl="jdbc:odbc:bookmanager";
}