package org.citsoft.db;
import java.sql.*;
public class LinkedDB {
static Connection con=null;
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
Connection conn=getConSQLServerDriver();
conn.close();
}
public static Connection getConSQLServerDriver() {//返回通过驱动程序创建的Connection 对象,此程序必须要导入驱动程序的.JAR文件
String url = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=pubs";//连接数据库的URL
String userName = "sa";//登录数据库的用户名称
String password = "sa";//登录数据库的密码
String driverString="com.microsoft.jdbc.sqlserver.SQLServerDriver";//类的字符串
try {
Class.forName(driverString);//加载驱动程序
try {
con=DriverManager.getConnection(url, userName, password);//通过DriverManager类创建Connection 对象
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;//返回创建的对象
}
public static Connection getConSQLServerOdc() {//返回通过ODBC创建的Connection 对象
String url = "jdbc:odbc:rj062";//rj062表示的是采用数据源连接DNS
String userName = "sa";
String password = "sa";
String driverString="sun.jdbc.odbc.JdbcOdbcDriver";//ODBC方式的类的字符串
try {
Class.forName(driverString);
try {
con=DriverManager.getConnection(url, userName, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
public static Connection getConMysql() {//返回通过ODBC创建的Connection 对象
String url = "jdbc:mysql://localhost:3306/test";//test是MYSQL的数据库
String userName = "root";//登录数据库的用户名
String password = "sa";//登录数据库的密码
String driverString="com.mysql.jdbc.Driver";//
try {
Class.forName(driverString);
try {
con=DriverManager.getConnection(url, userName, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
}
