jdbc 连接各种数据库

1/sql server
在微软的网站上下载jdbc驱动
加载SQL Server 2000 JDBC的驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
获得一个连接
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost(或者IP):1433; DatabaseName=pubs", "sa", "password");

2/oracle
下载驱动,oracle的客户端的安装目录中有相关的包存在
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@zjzwA1.yw.zj.chinamobile.com:1521:zjzw", userid, passwd);

3/db2
查找IBM DB2 UDB的安装目录或者Java  Tiger的JDK目录你会找到db2java.zip,先将db2java.zip解压缩,把COM目录转移到代码的当前目录
Class.forName(“COM.ibm.db2.jdbc.app.DB2Driver”).newInstance();
Class.forName(“COM.ibm.db2.jdbc.net.DB2Driver”).newInstance();
前者是具有DB2客户端的Provider实例，后者是无DB2客户端的Provider实例。
Connection con=DriverManager.getConnection("jdbc:db2://192.168.1.10/50000:rdb","username","password");
 

4/mysql
Class.forName("com.mysql.jdbc.Driver");//加载驱动程序
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hjl","root","123456");

jdbc:mysql://localhost:3306/news?useUnicode=true&characterEncoding=gb2312

 

举例:
import java.sql.*;
public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
String userName = "sa";
String userPwd = "";
Connection dbConn

try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
Catch (Exception e) {
e.printStackTrace();
}
}
}

例2
public static void main(String[] args) {
String tableName=null;//表名
BufferedReader input=new BufferedReader(new InputStreamReader(System.in));
try{
Class.forName("com.mysql.jdbc.Driver");//加载驱动程序
System.out.println("OK,DownLoad the driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hjl","root","123456");/*hjl为在MYSQL下建
立的数据库名字，123456是进入数据库的密码*/
con.setCatalog("hjl");
System.out.println("GOOG,Connect the DataBase");
Statement statement = con.createStatement();//数据库操作
System.out.print("请输入表名：");
tableName=input.readLine();

String sql="SELECT * FROM "+tableName;
ResultSet rs = statement.executeQuery(sql);
System.out.print("请输入列名：");
String cName=input.readLine();
// 获得数据结果集合
if(!rs.next())
System.out.println("表名或列名输入有误或到了末尾");
else {
System.out.println("查询结果为:");
do
{
String result=rs.getString(cName);
result=new String(result.getBytes("ISO-8859-1"),"GB2312");
System.out.println(result);
}while(rs.next());
}
rs.close();
con.close();
}catch(Exception ex){
System.out.println(ex);
System.exit(0);
}

}
}