访问DB2数据库进行数据更新的代码片段

1.访问Db2数据库首先请载入如下lib：db2jcc.jar，db2jcc_license_cu.jar在C:\Program Files\IBM\SQLLIB\java下可以找到它们。2.若

1.访问db2数据库首先请载入如下lib：  
   db2jcc.jar，db2jcc_license_cu.jar
   在c:\program files\ibm\sqllib\java下可以找到它们。

2.若用户没有想要访问的表的权限，，请打开db2控制中心，找到表，在右键菜单中加入用户访问许可。如果倒过来做不容易成功。

3.以下是访问代码：
package com.ibm;

import java.sql.connection;
import java.sql.drivermanager;
import java.sql.statement;
import java.util.hashmap;
import java.util.map;

public class tableupdater{
    public static void main(string[] args){
        int count=tableupdater.updatetablenotify_text("127.0.0.1","50000","db2admin","123456789");
        system.out.println(""+count+" records have been updated.");
    }
    
    public static int updatetablenotify_text(string dbipaddress,string dbport,string dbusername,string dbuserpassword){
        string driver = "com.ibm.db2.jcc.db2driver";
        string url = "jdbc:db2://"+dbipaddress+":"+dbport+"/oneteamp";
        string username = dbusername;
        string password = dbuserpassword;
        int updatedrecordcount=0;
        
        string sql = "";
        try {
            class.forname(driver).newinstance();
            connection conn =  drivermanager.getconnection(url, username, password);
            statement st = conn.createstatement();
            
            sql = " update oneteam.notify_text set notify_type='a23' where subject='a' ";
            
            map map=getupdatemap();
            
            for(string key:map.keyset()){
                string value=map.get(key);
                
                sql = " update oneteam.notify_text set notify_type='"+value+"' where subject='"+key+"' ";
                updatedrecordcount+=st.executeupdate(sql);
            }
            
            conn.close();
            return updatedrecordcount;
        } catch (exception e) {
            system.out.println("exception occured:" + e);
            return updatedrecordcount;
        }
    }
    
    private static map getupdatemap(){
        map map=new hashmap();
        
        map.put("recert_bundle_mgr_only_c", "action may be required: oneteam recertification completed. see recertify before date.");
        map.put("recert_bundle_mgr_only_f", "action may be required: oneteam recertification final reminder. see recertify before date.");
        map.put("recert_bundle_mgr_only_i", "action may be required: oneteam recertification initiated. see recertify before date.");
        map.put("recert_bundle_mgr_only_r", "action may be required: oneteam recertification reminder notification. see recertify before date.");
        map.put("recert_bundle_user_c", "action may be required: oneteam recertification completed. see recertify before date.");
        map.put("recert_bundle_user_f", "action may be required: oneteam recertification final reminder. see recertify before date.");
        map.put("recert_bundle_user_i", "action may be required: oneteam recertification initiated. see recertify before date.");
        map.put("recert_bundle_user_r", "action may be required: oneteam recertification reminder notification. see recertify before date");
        
        return map;
    }
}

行者AI

行者AI绘图创作，唤醒新的灵感，创造更多可能

100

查看详情