connnectmanager.java

来自「图书馆管理的源代码文件」· Java 代码 · 共 31 行

package com.nitpro.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;

public class ConnnectManager {
    private static Connection conn;
    
    public static Connection getConn(){
    	try {
			if((conn == null)||(conn.isClosed())){
				Class.forName("oracle.jdbc.driver.OracleDriver");
				conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.254:1521:nitpro","javauser","javauser");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
    }
    
    public static void closeConn(){
    	try {
			if ((conn != null)&&(!conn.isClosed())){
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
    }
}