jdbctemplate 一个字段一个字段保存

controller

  @ResponseBody
    @RequestMapping(value = "/addOrUpdata.do", method = {RequestMethod.POST})
    public int save(@RequestBody Map<String, Object> map) {
        System.out.println(map);
        Integer num = 0;
        String primaryKeyValue = map.get("bh").toString();

        for (String key : map.keySet()) {//通过foreach方法来遍历
            System.out.println("key= " + key + " and value= " + map.get(key));
            num = Service.updateOrInsertKeyValue(key, map.get(key).toString(), primaryKeyValue);
        }
        return num;
    }

service

@Override
    public int updateOrInsertKeyValue(String key, String value, String primaryKeyValue) {
        String sql;
        if (Dao.getForBh(primaryKeyValue).isEmpty()) {
            sql = "insert into tablename  (bh) values ('" + primaryKeyValue + "')";
    
        } else {
            sql = "update tablename set " + key + " = '" + value + "' where bh = '" + primaryKeyValue + "'";
        }
        System.out.println("sql");
        System.out.println("sql");
        return jggzDaJbxxDao.updateOrInsertKeyValue(sql);
    }

dao

  @Override
    public int updateOrInsertKeyValue(String sql) {
        return jdbcTemplate.update(sql);
    }