java access远程连接oracle,Java连接Mysql,SQL Server, Access,Oracle

1 Java连接MySql

mysql-connector-java-3.1.12-bin.jar置于JDK的\jre\lib\ext目录下

try

{

// 连接字符串

String connName = "jdbc:mysql://localhost:3306/mysqldb?useUnicode=true&characterEncoding=gb2312";

// 登录用户名

String dbUser = "root";

// 登录密码

String dbPwd = "zhihua1124";

Class.forName("com.mysql.jdbc.Driver");

// 生成一个连接

Connection con = DriverManager.getConnection(connName, dbUser, dbPwd);

return con;

}catch(Exception e)

{

System.err.println("Connection the database is wrong  !!");

return null;

}

2 Java连接SQL Server 2005   下载sqljdbc.jar置于JDK的\jre\lib\ext目录下

try

{

// 连接字符串

String connName = "jdbc:sqlserver://localhost:1433;integratedSecurity=true;databaseName=sqlserverdb";

// 登录用户名

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //2005

// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//2000

// 生成一个连接

Connection con = DriverManager.getConnection(connName);

return con;

}catch(Exception e)

{

e.printStackTrace();

return null;

}

3 Java连接Access  建立ODBC数据源,此处为accessdb

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:accessdb");

Statement stmt = con.createStatement();

ResultSet rs   = stmt.executeQuery(sql);

while(rs.next())

{

int id         = Integer.parseInt(rs.getString("id"));

String name    = rs.getString("name");

String address = rs.getString("address");

String phone   = rs.getString("phone");

String email   = rs.getString("email");

StudentInfo stu = new StudentInfo(id,name,address,phone,email);

allStudent.add(stu);

}

rs.close();

stmt.close();

return allStudent;

}

catch (Exception e)

{

e.printStackTrace();

return null;

}

4 Java连接Oracle在Oracle的安装目录之中\Db_1\jdbc\lib找到classes12.jar，置于JDK的\jre\lib\ext目录下

同时在\Db_1\jdbc\lib解压classes12.zip，比方解压至D:\classes12，在环境变量classpath中添加

try

{

String name="oracle.jdbc.driver.OracleDriver";

String url="jdbc:oracle:thin:@localhost:1521:oracledb";

Class.forName(name).newInstance();

Connection con=DriverManager.getConnection(url,"ddbi","ddbi");

return con;

}catch(Exception e)

{

e.printStackTrace();

return null;

}