java¿ª·¢DB2³ÌÐò

1. JDBC Çý¶¯³ÌÐò

1.1 DB2 JDBC Type 2 Çý¶¯³ÌÐò

DB2 ¿Í»§»ú

²»½¨ÒéʹÓÃ

COM.ibm.db2.jdbc.app.DB2Driver µ÷ÓÃClass.forName() ·½·¨¡£

1.2 IBM DB2 ͨÓÃJDBC ºÍSQLJ Çý¶¯³ÌÐò

ÌṩÁËType 2 Á¬½ÓÐÔºÍType 4 Á¬½ÓÐÔ

¿ÉÒÔ½«Õâ¸öÇý¶¯³ÌÐòÓÃÓÚapplet ºÍÓ¦ÓóÌÐò

com.ibm.db2.jcc.DB2Driver µ÷ÓÃClass.forName() ·½·¨¡£
2. ½¨Á¢Êý¾Ý¿âÁ¬½Ó

import java.sql.*; Í·Îļþ

String url = "jdbc:db2:sample"; TYPE 2

String url = "jdbc:db2:sample://localhost:50000"; TYPE4

Class.forName("com.ibm.db2.jcc.DB2Driver");

Connection con = DriverManager.getConnection(url);
3. Statement ¶ÔÏó

Statement ¶ÔÏóÊÇʹÓÃConnection.createStatement() ·½·¨´´½¨µÄ
Statement stmt;
stmt = con.createStatement();
stmt.executeUpdate("DELETE from EMPLOYEE WHERE EMPNO = '000099'");
ResultSet rs;
rs = stmt.executeQuery("SELECT EMPNO, LASTNAME from EMPLOYEE");
while (rs.next()) {
System.out.println(rs.getString(1) + ", " + rs.getDate(2));
}
4. PreparedStatement ¶ÔÏó

PreparedStatement ¶ÔÏóÊÇʹÓÃConnection.prepareStatement() ·½·¨´´½¨µÄ
pStmt = con.prepareStatement("UPDATE STAFF SET COMM=? WHERE ID=?");
pStmt.setDouble(1,710.53);
pStmt.setInt(2,350);
pStmt.executeUpdate();
5. Ìá½»ÊÂÎñ

con.setAutoCommit(true); ×Ô¶¯Ìá½»

con.commit(); ...

con.rollback();

Ö´Ðзֲ¼Ê½ÊÂÎñ

DB2XADataSource db2ds = new com.ibm.db2.jcc.DB2XADataSource();
6.¿ª·¢SQLJ Ó¦ÓóÌÐò(¾²Ì¬sql)
6.1 Ìí¼ÓÍ·Îļþ

import sqlj.runtime.*; Í·Îļþ

import java.sql.*; Í·Îļþ

6.2 ½¨Á¢Á¬½ÓÉÏÏÂÎÄ

#sql context Ctx;

String url = " jdbc:db2:sample://localhost:50000"; TYPE 4

Class.forName("com.ibm.db2.jcc.DB2Driver");

Ctx connCtx = new Ctx(url,true);

String url = " jdbc:db2:sample”; TYPE 2

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

6.3 ·¢³öSQL Óï¾ä