以下的文章主要是介紹用java訪問數據庫DB2代碼的實際操作步驟,首先我們是從創建表語句開始的,以下就是文章的主要內容描述,望大家在j對ava訪問數據庫DB2代碼的實際操作步驟浏覽之後會對其有更深的了解。
建表語句:
- create table test (id int,name varchar(20),password varchar(20))
插入一條數據:
- insert into test values (1,'zhu','yan')
java 代碼:
- package com.test;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class ConnToDB2 {
//獲得數據庫連接
- public static Connection getconn(String location,String username,String password)
- {
- Connection conn = null;
- try {
- Class.forName("com.ibm.DB2.jcc.DB2Driver");
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- try {
- conn = DriverManager.getConnection(location,username,password);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return conn;
- }
//查詢數據
- public static void select()throws Exception
- {
- Connection conn = getconn("jdbc:DB2://192.168.10.100:50000/yan", "DB2inst1", "abc");
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("select *from test");
- System.out.println("表中的數據如下:");
- while (rs.next())
- {
- System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
- }
- stmt.close();
- conn.close();
- }
//插入數據
- public static void insert()throws Exception
- {
- System.out.println("插入數據....");
- Connection conn = getconn("jdbc:DB2://192.168.10.100:50000/yan", "DB2inst1", "abc");
- Statement stmt = conn.createStatement();
- int rs = stmt.executeUpdate("insert into test values (3,'li','si')");
- stmt.close();
- conn.close();
- System.out.println();
- }
//跟新數據
- public static void update()throws Exception
- {
- System.out.println("更新數據....");
- Connection conn = getconn("jdbc:DB2://192.168.10.100:50000/yan", "DB2inst1", "abc");
- Statement stmt = conn.createStatement();
- int rs = stmt.executeUpdate("update test set password='kkk' where name='li'");
- stmt.close();
- conn.close();
- System.out.println();
- }
//刪除數據
- public static void delete()throws Exception
- {
- System.out.println("刪除數據....");
- Connection conn = getconn("jdbc:DB2://192.168.10.100:50000/yan", "DB2inst1", "abc");
- Statement stmt = conn.createStatement();
- int rs = stmt.executeUpdate("delete from test where name='li'");
- System.out.println();
- stmt.close();
- conn.close();
- }
- public static void main(String[] args)throws Exception {
- ConnToDB2 con = new ConnToDB2();
- con.select();
- con.insert();
- con.select();
- con.update();
- con.select();
- con.delete();
- con.select();
- }
- }
上述的相關內容就是對java實現訪問數據庫DB2代碼的描述,希望會給你帶來一些幫助在此方面。