connectionmgr.java

新东方软件开发项目

package com.mobile.dao;



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectionMgr {
	public static Connection getConnection() throws Exception{
		Class.forName("oracle.jdbc.driver.OracleDriver");
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCLM";
		String user = "scott";
		String password = "tiger";
		return DriverManager.getConnection(url, user, password);
	}
	
	public static void closeResource(Connection con,Statement st,ResultSet rs){
		try{
			if(rs!=null){
				rs.close();
			}
			if(st!=null){
				st.close();
			}
			if(con!=null){
				con.close();
			}
		}catch(Exception e){
			e.printStackTrace();
		}
	}

}