access中有表1和表2,表1字段acspkid1,companyno,companynam,表2字段acspkid2,acspkid1, 表1和表2通过acspkid1进行关联;oracle中有表1,表1字段orlpkid1,companyno,companynamoracle表1与access的表1可通过companyno进行匹配
请问如何使用hashmap 比较,将 oracle表orlpkid1字段值,赋给access表2的acspkid1字段
最好给出示例.
请问如何使用hashmap 比较,将 oracle表orlpkid1字段值,赋给access表2的acspkid1字段
最好给出示例.
map.put(companyno, orlpkid1);access
需要用orlpkid1将access中有表1和表2关联起来。if(map.containsKey(companyno)) {
// map.get(companyno); update access
}
最好给个,不然我看不懂,我步骤知道,可是不知道怎么下手去写了!我这边是这么定义的
Map<String, 一个javabean> map = new HashMap<String, 一个javabean>
private String orlpkid1;
private String companyno;
private String companynam; // getter setter........
}
Map<String, OracleInfoBean > map = new HashMap<String, OracleInfoBean>
SELECT orlpkid1,companyno,companynam FROM OracelTablewhile(rs.next()) {
OracleInfoBean bean = new OracleInfoBean();
bean.setOrlpkid1(rs.getString("orlpkid1"));
bean.setCompanyno(rs.getString("companyno"));
bean.setCompanynam(rs.getString("companynam")); map.put(bean.getCompanyno(), bean);
}
access表2 A2
oracle表1 O1String orlpkid1 = map.get(bean.getCompanyno()).getOrlpkid1();
"UPDATE A2 SET A2.acspkid1='" + orlpkid1 + "' WHERE
EXIST(
SELECT COUNT(*) FROM A1, O1
WHERE A1.companyno = '" + bean.getCompanyno() + "' AND A1.acspkid1 = A2.acspkid1
)"再看不懂我就没办法了。
其实一样的撒,主要就是将oracle表orlpkid1字段值,赋给access表2的acspkid1字段
你把生成的SQL运行有错没?