connectionmgr.java

来自「一个很不错的移动业务简单业务支撑系统」· Java 代码 · 共 45 行

package com.oristand.dao;

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

public class ConnectionMgr {
   
   public static Connection getConnection(){
	   Connection con=null;
	   try {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		con=DriverManager.getConnection(url,"scott","tiger");
		   
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	   
	return con;   
   }
   public static void freeResource(Connection con,Statement st,ResultSet rs ){
		try {
			if(rs!=null){
			  rs.close();
			}
			if(st!=null){
				st.close();
			}
			if(con!=null){
				con.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
	   
   }
   
}