databasemanager.java

来自「可以用的成绩管理系统」· Java 代码 · 共 74 行

/**
 * @(#)DataBaseManager.java
 *
 *
 * @author 
 * @version 1.00 2008/7/3
 */


import java.sql.*;
public class DataBaseManager
{
	Connection con;
	ResultSet rs;
	Statement stmt;
	public DataBaseManager()
	{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:StudentScore");
			stmt=con.createStatement();
		/*DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
		con=DriverManager.getConnection("jdbc:oracle:thin:@happy:1521:myoracle","maimihui","maimihui");
		stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);*/
		}catch(ClassNotFoundException cnf){
			
			cnf.printStackTrace();
		}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());
        	}
        }
       
}