java db2 import_Java连接DB2

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包：