|
发表于 2013-3-5 15:06:55
|
显示全部楼层
- package common;
- import java.math.*;
- import java.sql.*;
- import java.util.*;
- import org.dom4j.*;
- import com.justep.system.data.*;
- public class Connect {
- /**
- * 连接oracle
- * @param ip
- * @param port
- * @param databaseName
- * @param username
- * @param password
- * @param instance
- * @return
- * @throws Exception
- */
- static public Connection getOracleConnection(String ip,Integer port,String databaseName,String username,String password,String instance)throws Exception{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- if(port==0){
- port=1521;
- }
- String link="jdbc:oracle:thin:@"+ip+":"+String.valueOf(port)+":"+instance;
- return DriverManager.getConnection(link,username,password);
- }
- /**
- * sqlserver2005连接
- * @param ip
- * @param port
- * @param databaseName
- * @param username
- * @param password
- * @return
- * @throws Exception
- */
- static public Connection getSQL2005Connection(String ip,Integer port,String databaseName,String username,String password)throws Exception{
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- if(port==0){
- port=1433;
- }
- String link="jdbc:sqlserver://"+ip+":"+String.valueOf(port)+";databaseName="+databaseName;
- return DriverManager.getConnection(link,username,password);
- }
- /**
- * access连接
- * @param path
- * @return
- * @throws Exception
- */
- static public Connection getAccessConnection(String path) throws Exception{
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+path;
- Connection conn = DriverManager.getConnection(url);
- return conn;
- }
- }
复制代码 |
|