db2 连接测试

db2messagehttp://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp

import java.sql.*;

public class DBUtil {

private DBUtil() {

}

/**
* hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect<br>
* jdbc.driverClassName=COM.ibm.db2.jdbc.app.DB2Driver<br>
* jdbc.url=jdbc:db2:db2front<br>
* jdbc.username=icsadm<br>
* jdbc.password=icsadm<br>
* 需要建立本地客户机,用到jar:db2java.jar
*
* @return
*/
public static Connection getLocalConn() {
String userName = "db2admin";
String password = "Admin@123";
String url = "jdbc:db2:FRONT";// jdbc:db2:db2front
Connection con = null;
try {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
con = DriverManager.getConnection(url, userName, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
}
return con;

}

public static Connection getConn() {
String userName = "db2admin";
String password = "Admin@123";
String url = "jdbc:db2://127.0.0.1:50000/TPT0116";
Connection con = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");// 通用的
con = DriverManager.getConnection(url, userName, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;

}

public static Connection getMysqlConn() {
String userName = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/testdb?useUnicode=true&characterEncoding=utf8";
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url, userName, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}

private static void testMysqlConn() {
Connection conn = getMysqlConn();
try {
ResultSet set = conn.createStatement().executeQuery(
"select * from cbl_map_station ");
while (set.next()) {
System.out.println(set.getString(2));
}
} catch (SQLException e) {
e.printStackTrace();
}
}

@SuppressWarnings("unused")
private static void testConn() {
Connection conn = getConn();
try {
ResultSet set = conn.createStatement().executeQuery(
"select * from  TPTOOL.TRAFFIC_INCIDENT ");
while (set.next()) {
System.out.println(set.getInt(2));
}
} catch (SQLException e) {
e.printStackTrace();
}
}

@SuppressWarnings("unused")
private static void testLocalConn() {
Connection conn = getLocalConn();
try {
ResultSet set = conn.createStatement().executeQuery(
"select * from  zhangsheng.testdb ");
while (set.next()) {
System.out.println(set.getInt(1));
}
} catch (SQLException e) {
e.printStackTrace();
}
}

public static void main(String[] args) {
// testConn();
// testMysqlConn();
testLocalConn();

}

}