Java 连接 DB2的工具类
来源:互联网 发布:迅雷提示网络异常 编辑:程序博客网 时间:2024/05/02 13:27
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
public class CONN {
public static Connection createConn()
{
Connection conn=null;
try {
//Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
String url = "jdbc:db2://127.0.0.1:50000/sample";
Properties props = new Properties();
props.setProperty("user", "db2admin");
props.setProperty("password", "ibmdb2");
conn=DriverManager.getConnection(url,props);
}catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static PreparedStatement prepare(Connection conn,String sql)
{
PreparedStatement stat=null;
try {
stat=conn.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return stat;
}
public static void close(Connection conn)
{
if(conn==null) return;
try {
conn.close();
conn=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement stat)
{
if(stat==null) return;
try {
stat.close();
stat=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(ResultSet rs)
{
if(rs==null) return;
try {
rs.close();
rs=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
Connection conn = createConn();
System.out.println(conn);
String sql="(select * from DB2ADMIN.user where id not in ( select id from DB2ADMIN.user order by id asc fetch first 10 rows only ) order by id asc ) fetch first 10 rows only";
PreparedStatement ps;
try {
ps = conn.prepareStatement(sql);
try {
ResultSet rs=ps.executeQuery();
while(rs.next())
{
//System.out.println(rs.getString("userCount"));//(1);//.getString("name"));
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
System.out.println(rs.getString("password"));
}
} catch (SQLException e) {
e.printStackTrace();
}
conn.close();
ps.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
public class CONN {
public static Connection createConn()
{
Connection conn=null;
try {
//Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
String url = "jdbc:db2://127.0.0.1:50000/sample";
Properties props = new Properties();
props.setProperty("user", "db2admin");
props.setProperty("password", "ibmdb2");
conn=DriverManager.getConnection(url,props);
}catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static PreparedStatement prepare(Connection conn,String sql)
{
PreparedStatement stat=null;
try {
stat=conn.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return stat;
}
public static void close(Connection conn)
{
if(conn==null) return;
try {
conn.close();
conn=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement stat)
{
if(stat==null) return;
try {
stat.close();
stat=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(ResultSet rs)
{
if(rs==null) return;
try {
rs.close();
rs=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
Connection conn = createConn();
System.out.println(conn);
String sql="(select * from DB2ADMIN.user where id not in ( select id from DB2ADMIN.user order by id asc fetch first 10 rows only ) order by id asc ) fetch first 10 rows only";
PreparedStatement ps;
try {
ps = conn.prepareStatement(sql);
try {
ResultSet rs=ps.executeQuery();
while(rs.next())
{
//System.out.println(rs.getString("userCount"));//(1);//.getString("name"));
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
System.out.println(rs.getString("password"));
}
} catch (SQLException e) {
e.printStackTrace();
}
conn.close();
ps.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}
- Java 连接 DB2的工具类
- 连接db2的客户端工具(原创)
- JAVA连接DB2数据库的方法
- Java连接DB2数据库
- JAVA 连接DB2
- Java连接DB2相关
- Java程序连接DB2
- java jdbc 连接db2
- java连接DB2
- JAVA连接DB2
- java连接DB2数据库
- java连接db2
- JAVA连接DB2
- Java连接DB2
- java连接数据库的工具类
- java构建http连接的工具类
- java连接数据库的工具类
- java连接Redis的工具类
- 带饭族一定要注意的事
- 各人工作笔记-centos5显示中文
- 5.29 流水账
- 大话线性分组码编码技术
- USACO 1.3.4 Calf Flac(最大回文子串)
- Java 连接 DB2的工具类
- iOS学习之动态添加Button和监听UIAlertView按钮
- ODBC CRecordset
- 什么是SPI的bitbang / bit bang / bit-bang / bitbanging
- 【mysql】重置root密码,安全模式启动
- SPI总线协议及SPI时序图详解
- 被readLine()折腾了一把
- Jsp、Servlet、JavaBean三者的关系
- linux spi子系统驱动分析