connectdb.java

用java程序的oracle数据库的一些分区操作

package com.lonton.par;

import java.sql.*;

public class ConnectDB {
	Connection conn = null;
	//Statement stmt = null;
	//通过jdbc-odbc桥连接数据库
    public Connection getConnection(){
    	String uri = "sun.jdbc.odbc.JdbcOdbcDriver";
    	String url = "jdbc:odbc:UnionMSC";
    	try{
    		Class.forName(uri);
    		conn = DriverManager.getConnection(url,"system","lonton");
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	return conn;
    }
    
    //关闭数据库连接
    public void closeCon(){
    	try{
    	}
    	finally{
    		try{
	    		if(conn != null){
	    			conn.close();
    		}
    		}catch(SQLException e){
    			e.printStackTrace();
    		}
    	}
    	
    }
}