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(); } } } |
Java 连接 DB2的工具类
最新推荐文章于 2023-09-18 16:56:15 发布