dbutil.java

java+oracle实现学生管理系统 学生信息的增删改查

package data;
import java.sql.*;

public class DBUtil
{
    static String serverName = "localhost";
	static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
	static String dbInstance = "ora9i";
	static String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:"+dbInstance;
	
	static String dbUser = "scott";
	static String userPwd = "tiger";
    
	
    public static Connection getConnection()
    {
        Connection conn = null;
        try 
        {
			Class.forName(sDBDriver); 
            conn = DriverManager.getConnection(sConnStr, dbUser, userPwd);             
		}		
		catch(ClassNotFoundException e) 
		{
			e.printStackTrace();
		}		
		catch(SQLException e1)
		{
		    e1.printStackTrace();
		}
		return conn;
    }
    /**
    *关闭指定的结果集
    *@param rs 要关闭的结果集
    */
    public static void closeResultSet(ResultSet rs)
    {
         if( rs != null)
    	 {
    	    try
    	    {
    	        rs.close();
    	    }
    	    catch(SQLException e)
    	    {            
    	    }
    	 }	    
    }
    /**
    *关闭指定的Statement
    *@param stmt 要关闭的Statement
    */
    public static void closeStatement(Statement stmt)
    {        
    	    if( stmt != null)
    	    {
    	        try
    	        {
    	            stmt.close();
    	        }
    	        catch(SQLException e)
    	        {    	        
    	        }
    	    }	
    }
    /**
    *关闭连接
    *@param conn 要关闭的连接
    */
    public static void closeConnection(Connection conn)
    {
	        if( conn != null)
    	    {
    	        try
    	        {
    	            conn.close();
    	        }
    	        catch(SQLException e)
    	        {
    	        }
    	    }
    }
    public static void main(String[] args)
    {
        System.out.println(getConnection());
    }    
}