mysql是怎么连接数据库服务器

1)连接Oracle 8/8i/9i/10g/11g（thin模式）

Class.forName(oracle.JDBC.driver.OracleDriver).newInstance();
String url=JDBC:oracle:thin:@localhost:1521:orcl //orcl为Oracle数据库的SID
String user=test;
String password=test;
Connection con=DriverManager.getConnection(url,user,password);
2)连接DB2数据库
Class.forName(com.ibm.db2.jcc.DB2Driver);
String url=JDBC:db2://localhost:5000/testDb;/**数据库连接串**/
String user=test; String password=test;
Connection con=DriverManager.getConnection(url,user,password);
3)连接MySQL数据库
Class.forName(com.mysql.jdbc.Driver);
String url=JDBC:mysql://localhost:8080/testDB;
String user=test; String password=test;
Connection con=DriverManager.getConnection(url,user,password);
4)连接SQL Server数据库
Class.forName(com.microsoft.JDBC.sqlserver.SQLServerDriver);
String url=JDBC:microsoft:sqlserver://localhost:1433;DatabaseName=testDb;
String user=test; String password=test;
Connection con=DriverManager.getConnection(url,user,password);
5)连接PostgreSQL数据库
Class.forName(org.postgresql.Driver);
String url=JDBC:postgresql://localhost/testDb;
String user=test; String password=test;
Connection con=DriverManager.getConnection(url,user,password);
6)连接Access数据库
Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);
String url=JDBC:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=+application.getRealPath(/Data/testDb/mdb);
Connection conn=DriverManager.getConnection(url,,);
7连接Sybase数据库
Class.forName(com.sybase.JDBC.SybDriver);
String url=JDBC:sybase:Tds:localhost:5007/testDb;
Properties pro=System.getProperties();
pro.put(user,userId);
pro.put(password,user_password);
Connection con=DriverManager.getConnection(url,pro);
8连接informix数据库
Class.forName(com.informix.JDBC.ifxDriver);
String url=JDBC:informix-sqli:localhost:1533/testDb:INFORMIXSERVER=myserveruser=testUser;password=testpassword; Connection con=DriverManager.getConnection(url);

示例：
连接SQL Server2008R2数据库
首先Build Path → 添加外部sqljdbc.jar驱动

import java.sql.*;
public class DB {
public static void main(String[] args) throws Exception {
Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);
Connection conn = DriverManager.getConnection(jdbc:sqlserver://localhost:1433; DatabaseName=数据库名, sa, 1234);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(select * from 表名);
while(rs.next()) {
System.out.println(id为： + rs.getString(id) + name为: + rs.getString(name));
}
System.out.println(数据库连接成功！);
rs.close();
stmt.close();
conn.close();
System.out.println(数据库成功关闭！);
}
}