ncc，nc手动调用数据库查询

qq_25310483

已于 2023-03-29 17:33:06 修改

阅读量348

点赞数

文章标签：数据库 sql java

于 2023-03-29 16:52:00 首次发布

本文链接：https://blog.csdn.net/qq_25310483/article/details/129840395

版权

1.查询单值
int id =(int) new BaseDAO().executeQuery(" select count(1) from so_saleinvoice where dr =0 and vdef17 = ‘“+vdef17+”’ ",
new ColumnProcessor());
2.查询
PersistenceManager manager = null;
try {
manager = PersistenceManager.getInstance();
JdbcSession session = manager.getJdbcSession();
session.setAddTimeStamp(false);
String sql = “insert into tb_pu_temp2_gx (code_measure,code_mat,code_mat_buynum,pk_org,yearcode) values(?,?,?,?,?)”;
for (String uk : dataMap.keySet()) {
SQLParameter sp = new SQLParameter();
sp.addParam(uk);
String[] valuestr = dataMap.get(uk);
sp.addParam(valuestr[0]);
sp.addParam(valuestr[1]);
sp.addParam(valuestr[2]);
sp.addParam(valuestr[3]);
session.addBatch(sql, sp);
}
session.executeBatch();