databasemanager.java

郑州市公交线路管理查询系统

package com.ljz.gongJiaoSearch;
import java.sql.*;
public class DataBaseManager
{
	Connection con;
	ResultSet rs;
	Statement stmt;
	public DataBaseManager()
	{
		try{
			//DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
			//con=DriverManager.getConnection("jdbc:oracle:thin:@happy:1521:myoracle","maimihui","maimihui");
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
			//con=DriverManager.getConnection("jdbc:odbc:LibraryBase");
	    	con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=zhanDian.mdb");
			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 );  // terminate program
      	}
		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());
       	}
    }      
}