shujuku.java

一个简单的图书管理系统

import java.sql.*;
public class ShuJuKu   //把数据库的操作封装在这个类里面
{
	Connection con;
	ResultSet rs;
	Statement stmt;
	public ShuJuKu()
	{
		try{
		Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
		con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Data/fangjing.mdb");
		stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	}
	 catch (ClassNotFoundException cnfex ) {
         System.err.println("无法载入JDBC/ODBC 驱动" );
         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 Vector additems
        public void closeStatement()
        {
        	try
        	{
        		stmt.close();
        	}
        	catch(SQLException sqle)
        	{
        		System.out.println(sqle.toString());
        	}
        }
       
        public void closeConnection() //关闭连接
        {
        	try
        	{
        		con.close();
        	}
        	catch(SQLException sqle)
        	{
        		System.out.println(sqle.toString());
        	}
        }
       
}