连接DB2代码,Java代码库,德仔网

代码语言
代码分类
【Java】连接DB2
作者:一丁 / 发布于2015/4/21/ 614

	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();
	 }
	 }
	}连接DB2需要的jar包
试试其它关键字
　连接DB2　
同语言下
可能有用的
一丁贡献的其它代码(30)