数据库查询一遍，有就更新，没有就插入操作(从接口调数据持久化到数据库，好用，数据永远是最新的不会重复)

最新推荐文章于 2023-04-23 16:49:28 发布

武侠㿝卄清

最新推荐文章于 2023-04-23 16:49:28 发布

阅读量676

点赞数

分类专栏： java web开发

本文链接：https://blog.csdn.net/qq_30347133/article/details/100532523

版权

web开发同时被 2 个专栏收录

611 篇文章 2 订阅

订阅专栏

java

574 篇文章 4 订阅

订阅专栏

public void insertDetail(){
	try {
	ApplicationContext context = new ClassPathXmlApplicationContext("applicationBt.xml");
	JdbcTemplate jdbcTemplate = (JdbcTemplate)context.getBean("jdbcTemplate");	
	System.out.println("-----------更新转账明细------------------");
	String jsonParam=this.read();
    JSONObject job = JSONObject.fromObject(jsonParam);
    if(null!=job.getString("a1")){
    	String sql="select count(1) from bankDetail where  sequenceNo=?";
		Object[] param=new Object[]{job.getString("a1")};
		int i=jdbcTemplate.queryForInt(sql, param);
		if(i>0){
			Object[] param2=new Object[]{job.getString("a16"),job.getString("a4"),job.getString("a3"),job.getString("a14"),job.getString("a10"),job.getString("a15"),job.getString("a1")};
		    sql="update bankDetail set cardId=?,toAccountName=?,toAccountNo=?,bank_id=?,accountNO=?,accountName=? where sequenceNo=?";
			jdbcTemplate.update(sql, param2);
		}else{
			Object[] param1=new Object[]{
					job.getString("a16"),job.getString("a1"),
					job.getString("a2").substring(0, 10),
					job.getString("a4"),job.getString("a3"),
					job.getString("a5"),job.getString("a6"),
					job.getString("a7"),job.getString("a2"),
					job.getString("a11"),job.getString("a12"),
					job.getString("a13"),job.getString("a14"),
					job.getString("a10"),job.getString("a15"),
					job.getString("a17"),job.getString("a18")
			};
			String sql1="insert into bankDetail(d_guid,cardId,sequenceNo,tranDate,toAccountName,toAccountNo,amount,accountBalance,summary,transDateTime,state,pay_from,pro_newid,btype,bank_id,AccountNo,AccountName,userpk,cust_guid) values(newid(),?,?,?,?,?,?,?,?,?,0,?,?,?,?,?,?,?,?)";
			jdbcTemplate.update(sql1, param1);
		}
    }
	

     System.out.println("插入充值明细==");
 	//返回服务端
		    this.getResponse().setCharacterEncoding("utf-8");
			PrintWriter out = this.getResponse().getWriter();
		    out.write("");
		    out.flush();
		    out.close();
    } catch (I){

}