databasemanager.java

一个图书管理系统

import java.sql.*;


public class DataBaseManager {
	Connection con;
	ResultSet rs;
	Statement stmt;
	String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
    String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs"; 
    String userName = "xu"; 
    String userPwd = ""; 

 public DataBaseManager() {
 	try
 	{
 		Class.forName(driverName);
       con=DriverManager.getConnection(dbURL,userName,userPwd); 
	   stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	}
	catch(ClassNotFoundException cnfex){
		System.err.println("Failed to load JDBC/ODBC driver.");
		cnfex.printStackTrace();
		System.exit(1);
	}
	catch(SQLException sqle)
	{
		System.out.println(sqle.toString());
		
	}
    }
    
    public  ResultSet getResult(String strSQL)
    {
    	try{
    		rs=stmt.executeQuery(strSQL);
    		return  rs;
    	}
    	catch(SQLException sqle)
    	{
    		System.out.println(sqle.toString());
    		return  null;
    		
    	}
    }
    
    public boolean updateSql(String strSQL)
    {
    	try{
    		stmt.executeUpdate(strSQL);
    		con.commit();
    		return true;
    	}
    	catch(SQLException sqle)
    	{
    		System.out.println(sqle.toString());
    		return false;
    	}
    }
    	
    	public void closeConnection()
    	{
    	
    		try{
    			con.close();
    		}
    		catch(SQLException sqle)
    		{
    			System.out.println(sqle.toString());
    		}
         }
    
    
}