www.pudn.com > sjkjjwsu.store.rar > DataBaseManager.java

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"); 
		stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
	} 
	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()); 
        	} 
        } 
        
}