您现在的位置：程式碼之家 >> 編程語言 > >> Java 程式設計 >> Java 相關知識

Java 連接主流資料庫完整範例集（JSP + JDBC）

編輯：Java 相關知識

本文匯總七大主流資料庫的 JSP 連接範例，涵蓋驅動類、連線 URL、認證方式與基本 CRUD 模板。

通用配置步驟

建立資料庫與測試表
將 JDBC 驅動 JAR 放入 Tomcat/common/lib 或專案 WEB-INF/lib
配置 web.xml 定義 DataSource（JNDI）
在 context.xml 關聯 ResourceLink

各資料庫連接範例

1. Oracle (Thin 模式)

Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = DriverManager.getConnection(url, "scott", "tiger");

2. SQL Server 7.0/2000

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
Connection conn = DriverManager.getConnection(url, "sa", "");

3. DB2

Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
String url = "jdbc:db2://localhost:5000/sample";
Connection conn = DriverManager.getConnection(url, "admin", "");

4. Informix

Class.forName("com.informix.jdbc.IfxDriver");
String url = "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";
Connection conn = DriverManager.getConnection(url);

5. Sybase

Class.forName("com.sybase.jdbc.SybDriver");
String url = "jdbc:sybase:Tds:localhost:5007/tsdata";
Properties props = new Properties();
props.put("user", "userid");
props.put("password", "user_password");
Connection conn = DriverManager.getConnection(url, props);

6. MySQL

Class.forName("org.gjt.mm.mysql.Driver");
String url = "jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1";
Connection conn = DriverManager.getConnection(url);

7. PostgreSQL

Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost/soft";
Connection conn = DriverManager.getConnection(url, "myuser", "mypassword");

通用查詢模板

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM test");
while (rs.next()) {
    out.println("欄位1：" + rs.getString(1) + " 欄位2：" + rs.getString(2));
}
rs.close(); stmt.close(); conn.close();