Example usage for org.apache.ibatis.session SqlSession insert

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession insert.

Prototype

int insert(String statement, Object parameter);

Source Link

Document

Execute an insert statement with the given parameter object.

Usage

From source file:webim.dao.ibatis.WebimSettingDao.java

License:Apache License

/**
 * ??MySQL?: <br>/*ww  w . j a v  a 2 s  . co  m*/
 * 
 * "update webim_settings set data = ?  where uid = ?" <br>
 * 
 * ??????
 * 
 * @param uid
 *            uid
 * @param data
 *            ??JSON?
 */
public void set(String uid, String data) {
    Map<String, Object> map = new HashMap<String, Object>();
    Date now = new Date();
    map.put("uid", uid);
    map.put("data", data);
    map.put("created", now);
    map.put("updated", now);
    SqlSession session = sessionFactory.openSession();
    try {
        String oldData = (String) session.selectOne("SettingMapper.getSetting", uid);
        if (oldData == null) {
            session.insert("SettingMapper.insertSetting", map);
        } else {
            session.update("SettingMapper.updateSetting", map);
        }
        session.commit();
    } finally {
        session.close();
    }
}

From source file:webim.dao.ibatis.WebimVisitorDao.java

License:Apache License

public WebimVisitor insert(Map<String, String> data) {
    String vid = data.get("name");
    WebimVisitor v = new WebimVisitor(data.get("name"), "v" + vid);
    v.setIpaddr(data.get("ipaddr"));
    v.setReferer(data.get("referer"));
    v.setGroup("visitor");
    v.setAvatar("static/images/male.png");
    SqlSession session = sessionFactory.openSession();
    try {/*  w ww .j  a v  a 2 s .  c  o m*/
        session.insert("VisitorMapper.insertVisitor", v);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return v;
}