java连接DB2数据库

测试前准备工作：

确保系统已经安装DB2数据库(用户名：db2admin  密码：db2admin)

1、以下操作在命令行下操作(db2cmd db2)：

(1)创建数据库

create databse my2edDB

(2)连接数据库

connect to my2edDB

(3)创建表

create table t_user(id integer not null primary key,username varchar(20),password varchar(20))

(4)往表中插入数据

insert into t_user (id,username,password) values (1,'sunny','sunnny123')

2、编写java程序ConnectDB2.java:

package com.sunny.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ConnectBD2 {
	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
			conn = DriverManager.getConnection("jdbc:db2://localhost:50000/my2edDB", "db2admin", "db2admin");
			String url = "select * from t_user";
			ps = conn.prepareStatement(url);
			rs = ps.executeQuery();
			
			while(rs.next()){
				System.out.println(rs.getString("id")+" " +rs.getString("username")+" " + rs.getString("password"));
			}
		
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

3、在项目的lib下添加db2jcc.jar驱动包，并将其add to build path

4、运行 java application

5、控制台打印结果：

1 sunny sunny123