看了一遍Java语法,开始动手做一些练习, 主要集中在多线程,读文件,写数据这几个方面。
在研究多线程的过程中,碰到了线程名字的问题,做了一点研究。
而在连接DB2的时候,又碰到了ClassNotFoundException 找不到driver的问题,也找到了解决方案。
创建数据表的DDL:
create database TEST automatic storage yes;
create table customers(name varchar(20), age integer, location varchar(20));
连接数据库,并写数据库:
test.DB2Conn.java
package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class DB2Conn {
private static Connection conn = null;
private static PreparedStatement stmt = null;
private static String url = "jdbc:db2://localhost:50000/TEST";
private static String user = "ADMIN";
private static String pwd = "test";
public DB2Conn() {
// TODO Auto-generated constructor stub
try{
System.out.println("Start to connecting DB2 database...");
Class.forName("com.ibm.db2.jcc.DB2Driver"); //load DB driver
conn = DriverManager.getConnection(url, user, pwd);
System.out.println("Connet to DB2 database successfully.");
}catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
/**
* Insert data
*/
public void insert(String[] fields, String sql){
try{
stmt = conn.prepareStatement(sql);
stmt.setString(1,fields[0]);
stmt.setInt(2, Integer.parseInt(fields[1]));
stmt.setString(3,fields[2]);
int record = stmt.executeUpdate();
System.out.println("Insert " + record + " records successfully.");
}
catch(SQLException e){
System.out.println(e);
}
}