dbmanager.java

来自「图书馆管理系统：该系统的开发主要包括用户登陆」· Java 代码 · 共 33 行

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:Driver={SQL Server};server=.;database=bms;uid=sa;pwd=";
}