批量更新订单

最新推荐文章于 2020-11-30 15:03:41 发布

狼魂豹速

最新推荐文章于 2020-11-30 15:03:41 发布

阅读量249

点赞数

本文链接：https://blog.csdn.net/liufeifeihuawei/article/details/103718908

版权

package com.system.dqfn.util;

import java.util.List;

import com.system.db.C3P0Utils;
import com.system.dqfn.model.DQFNBom;
import com.system.dqfn.model.DQFNPlanBom;

public class TestUtils {
	
	@SuppressWarnings("unchecked")
	public static void main(String[] args) {
		List<DQFNPlanBom> list = (List<DQFNPlanBom>) C3P0Utils.getListBySql("select tf_dingdan,tf_name,tf_cszk,tf_cszk2 from tb_dqfn_plan_bom "
				+ "where tf_dingdan in (select tf_dingdan from tb_dqfn_plan where tf_overflag = 'N')", DQFNPlanBom.class);
		for(DQFNPlanBom planBom:list){
			DQFNBom bom = (DQFNBom) C3P0Utils.getObjectBySql("select * from tb_dqfn_bom where tf_name = '"+ planBom.getTf_name() +"'", DQFNBom.class);
			if(bom != null){
				//更新
				String updateSql = "update tb_dqfn_plan_bom  set tf_cszk='"+bom.getTf_cszk()+"',tf_cszk2='"+bom.getTf_cszk2()+"' where tf_dingdan='"+ planBom.getTf_dingdan() +"'";
				System.out.println(updateSql);
			}
		}
	}
	
}