package com.java.test.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.Statement;
public class TestJDBCDB2 {
private static Connection con = null;
private static Statement sql = null;
private static ResultSet rs = null;
public static void main(String[] args) throws SQLException {
int no;
String dep;
String sal;
try {
con = dbConn("db2inst1", "123456");
if (con == null) {
System.out.print("连接失败");
System.exit(0);
}
sql = con.createStatement();
rs = sql.executeQuery("select empid, deptid, salary from employee");
System.out.println("工号" + " " + "部门号" + " "
+ "薪水");
while (rs.next()) {
no = rs.getInt(1);
dep = rs.getString(2);
sal = rs.getString(3);
System.out.println(no + " " + dep + " " + sal);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
con.close();
}
}
public static Connection dbConn(String name, String pass) {
Connection c = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
c = DriverManager.getConnection("jdbc:db2://localhost:50000/uibs",
name, pass);
} catch (SQLException e) {
e.printStackTrace();
}
return c;
}
}
需要的jar包：