java串連db2

標籤：style   io   ar   os   java   for   sp   on   cti   

package com.java.test.jdbc;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.ResultSet;

import java.sql.Statement;

 

public class TestJDBCDB2 {

   private static Connection con = null;

   private static Statement sql = null;

   private static ResultSet rs = null;

 

   public static void main(String[] args) throws SQLException {

      int no;

      String dep;

      String sal;

      try {

        con = dbConn("db2inst1", "123456");

        if (con == null) {

           System.out.print("串連失敗");

           System.exit(0);

        }

        sql = con.createStatement();

        rs = sql.executeQuery("select empid, deptid, salary from employee");

        System.out.println("工號" + "            " + "部門號" + "             "

              + "薪水");

        while (rs.next()) {

           no = rs.getInt(1);

           dep = rs.getString(2);

           sal = rs.getString(3);

           System.out.println(no + "         " + dep + "         " + sal);

        }

      } catch (Exception e) {

        e.printStackTrace();

 

      } finally {

        con.close();

      }

   }

 

   public static Connection dbConn(String name, String pass) {

      Connection c = null;

      try {

        Class.forName("com.ibm.db2.jcc.DB2Driver");

      } catch (ClassNotFoundException e) {

        e.printStackTrace();

      }

      try {

        c = DriverManager.getConnection("jdbc:db2://localhost:50000/uibs",

              name, pass);

      } catch (SQLException e) {

        e.printStackTrace();

      }

      return c;

   }

}

 

需要的jar包：

java串連db2