dom4j的应用(2)

来源：互联网发布：深圳高速工程顾问知乎编辑：程序博客网时间：2024/06/06 13:23

public void saveConfigInfo(List list)
    {
        Map map = (Map) list.get(0);
        String modSn = map.get("modSn") == null ? "" : map.get("modSn")
                .toString();
        String dsql = " delete from EOA_WF_ASSIGNMENT_POLICY a where a.MOD_SN=? ";
        StringBuffer isql = new StringBuffer();
        isql.append(" insert into EOA_WF_ASSIGNMENT_POLICY ");
        isql.append(" values( ");
        isql.append(" lower(sys_guid()), ");
        isql.append(" ? , ");
        isql.append(" ? , ");
        isql.append(" ?, ");
        isql.append(" ?, ");
        isql.append(" ?, ");
        isql.append(" ?, ");
        isql.append(" ?, ");
        isql.append(" ? ");
        isql.append(" )");
        try
        {
            jdbcTemplate.update(dsql, new Object[] { modSn });
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }