manageconnection.java

分为经理和出纳2个权限

package com.yiboit.cfss.db;

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

public class ManageConnection {
	public static final String driverName = "oracle.jdbc.driver.OracleDriver";
	public static final String url = "jdbc:oracle:thin:@192.168.0.119:1521:ora";
	public static final String userName = "scott";
	public static final String password = "tiger";
	
	public static Connection getConnection() throws SQLException {
		Connection result = null;
		
		try {
			Class.forName(driverName);
			result =  DriverManager.getConnection(url, userName, password);
		} catch (ClassNotFoundException e) {
			throw new SQLException(e.getMessage());
		} catch (SQLException e) {
			throw e;
		}
		
		return result;
	}
}