dom4j的应用(2)

yesjava

于 2012-06-07 17:07:10 发布

阅读量387

点赞数

CC 4.0 BY-SA版权

分类专栏： spring 文章标签： exception string insert list delete object

本文链接：https://blog.youkuaiyun.com/yesjava/article/details/7642618

spring 专栏收录该内容

4 篇文章

订阅专栏

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();
        }
    }