DB2 连接数据库

最新推荐文章于 2024-12-30 11:34:20 发布

原创最新推荐文章于 2024-12-30 11:34:20 发布 · 975 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#db2 #exception #import #数据库 #jdbc #string

Struts学习专栏收录该内容

6 篇文章

订阅专栏

DB2 连接数据库

package com.mypkg.struts.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class conn {
private static Connection con;

public static Connection getCon() {
  try {
   Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
   con = DriverManager
     .getConnection(
       "jdbc:db2:pms168","pms", "pms");

  } catch (Exception e) {
   e.printStackTrace();

  }
  return con;
}

public static void main(String args[]){
  try{
   Connection con=conn.getCon();
   Statement state=con.createStatement();
   ResultSet rs=state.executeQuery("SELECT *FROM PAMS.ORGAN ORDER BY INSTNO");
   while(rs.next()){

    System.out.println(rs.getString(1)+"          "+rs.getString(2)+"          "+rs.getString(3));

   }
   rs.close();
   state.close();
   con.close();

  }catch(Exception ex){
   ex.printStackTrace();
  }

}

}