欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2022-06-16 09:13:48
...

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;
}
}

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