databasemanager.java

学生成绩查询系统

package 学生成绩;

import java.sql.*;

public class DataBaseManager
{
	Connection con;
	ResultSet res;
	Statement stmt;
	String m_dbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	public DataBaseManager()
	{
		try{
	    
		Class.forName(m_dbDriver);
		String url="jdbc:odbc:student"; 
		String user=""; 
		String password="";
		
		con=DriverManager.getConnection(url,user,password);
		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{
		res=stmt.executeQuery(strSQL);
		return res;
	    }
    	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());
        	}
        }
       
}