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

Introduction

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

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

From source file:com.itfsw.mybatis.generator.plugins.TableRenameConfigurationPluginTest.java

License:Apache License

/**
 * exampleSuffix//w  w w.j a  v  a 2 s.c om
 */
@Test
public void testExampleSuffix() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool
            .create("scripts/TableRenameConfigurationPlugin/mybatis-generator-with-exampleSuffix.xml");
    MyBatisGenerator myBatisGenerator = tool.generate();

    boolean find = false;
    for (GeneratedJavaFile file : myBatisGenerator.getGeneratedJavaFiles()) {
        String name = file.getCompilationUnit().getType().getShortName();
        if (name.equals("TbQuery")) {
            find = true;
        }
    }
    Assert.assertTrue(find);
    // ???
    tool.generate(() -> DBHelper.resetDB("scripts/TableRenameConfigurationPlugin/init.sql"),
            new AbstractShellCallback() {
                @Override
                public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz)
                        throws Exception {
                    ObjectUtil tbMapper = new ObjectUtil(
                            sqlSession.getMapper(loader.loadClass(packagz + ".TbMapper")));

                    ObjectUtil tbQuery = new ObjectUtil(loader, packagz + ".TbQuery");
                    ObjectUtil criteria = new ObjectUtil(tbQuery.invoke("createCriteria"));
                    criteria.invoke("andIdLessThan", 4L);

                    // sql
                    String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "selectByExample",
                            tbQuery.getObject());
                    Assert.assertEquals(sql,
                            "select id, field1, inc_f1, inc_f2, inc_f3 from tb WHERE ( id < '4' )");
                    // 
                    List list = (List) tbMapper.invoke("selectByExample", tbQuery.getObject());
                    Assert.assertEquals(list.size(), 3);
                }
            });
}

---

From source file:com.itfsw.mybatis.generator.plugins.TableRenameConfigurationPluginTest.java

License:Apache License

/**
 * modelSuffix/* w w w .  ja v a  2 s.  c o  m*/
 */
@Test
public void testModelSuffix() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool
            .create("scripts/TableRenameConfigurationPlugin/mybatis-generator-with-modelSuffix.xml");
    MyBatisGenerator myBatisGenerator = tool.generate();

    boolean find = false;
    for (GeneratedJavaFile file : myBatisGenerator.getGeneratedJavaFiles()) {
        String name = file.getCompilationUnit().getType().getShortName();
        if (name.equals("TbEntity")) {
            find = true;
        }
    }
    Assert.assertTrue(find);
    // ???
    tool.generate(() -> DBHelper.resetDB("scripts/TableRenameConfigurationPlugin/init.sql"),
            new AbstractShellCallback() {
                @Override
                public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz)
                        throws Exception {
                    ObjectUtil tbMapper = new ObjectUtil(
                            sqlSession.getMapper(loader.loadClass(packagz + ".TbMapper")));

                    ObjectUtil tbExample = new ObjectUtil(loader, packagz + ".TbExample");
                    ObjectUtil criteria = new ObjectUtil(tbExample.invoke("createCriteria"));
                    criteria.invoke("andIdEqualTo", 4L);

                    ObjectUtil tb = new ObjectUtil(loader, packagz + ".TbEntity");
                    tb.set("id", 4L);
                    tb.set("field1", "ts1");
                    tb.set("incF1", 5L);

                    // sql
                    String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "updateByExample",
                            tb.getObject(), tbExample.getObject());
                    Assert.assertEquals(sql,
                            "update tb set id = 4, field1 = 'ts1', inc_f1 = 5, inc_f2 = null, inc_f3 = null WHERE ( id = '4' )");
                    // 
                    int count = (int) tbMapper.invoke("updateByExample", tb.getObject(), tbExample.getObject());
                    Assert.assertEquals(count, 1);
                    // 
                    List list = (List) tbMapper.invoke("selectByExample", tbExample.getObject());
                    ObjectUtil result = new ObjectUtil(list.get(0));
                    Assert.assertEquals(result.get("id"), 4L);
                    Assert.assertEquals(result.get("field1"), "ts1");
                    Assert.assertEquals(result.get("incF1"), 5L);
                }
            });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  upsert//from  w  w  w .  j a v  a 2  s.c o m
 */
@Test
public void testUpsert() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            ObjectUtil tbMapper = new ObjectUtil(sqlSession.getMapper(loader.loadClass(packagz + ".TbMapper")));

            ObjectUtil tb = new ObjectUtil(loader, packagz + ".Tb");
            tb.set("id", 10l);
            tb.set("field1", "ts1");
            tb.set("field2", 5);

            // sql
            String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsert", tb.getObject());
            Assert.assertEquals(sql,
                    "insert into tb (id, field1, field2) values (10, 'ts1', 5) on duplicate key update id = 10, field1 = 'ts1', field2 = 5");
            Object result = tbMapper.invoke("upsert", tb.getObject());
            Assert.assertEquals(result, 1);

            tb.set("field2", 20);
            tbMapper.invoke("upsert", tb.getObject());

            ResultSet rs = DBHelper.execute(sqlSession, "select * from tb where id = 10");
            rs.first();
            Assert.assertEquals(rs.getInt("field2"), 20);
        }
    });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  upsertWithBLOBs/*from w w  w.j ava2  s. c o m*/
 */
@Test
public void testUpsertWithBLOBs() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            // 1.  blob
            ObjectUtil TbBlobsMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbBlobsMapper")));

            ObjectUtil TbBlobsWithBLOBs = new ObjectUtil(loader, packagz + ".TbBlobsWithBLOBs");
            TbBlobsWithBLOBs.set("id", 10l);
            TbBlobsWithBLOBs.set("field1", "ts1");
            TbBlobsWithBLOBs.set("field2", "ts2");

            // sql
            String sql = SqlHelper.getFormatMapperSql(TbBlobsMapper.getObject(), "upsertWithBLOBs",
                    TbBlobsWithBLOBs.getObject());
            Assert.assertEquals(sql,
                    "insert into tb_blobs (id, field1, field2, field3) values (10, 'ts1', 'ts2', 'null') on duplicate key update id = 10, field1 = 'ts1', field2 = 'ts2', field3 = 'null'");
            Object result = TbBlobsMapper.invoke("upsertWithBLOBs", TbBlobsWithBLOBs.getObject());
            Assert.assertEquals(result, 1);

            TbBlobsWithBLOBs.set("field2", "ts3");
            TbBlobsMapper.invoke("upsertWithBLOBs", TbBlobsWithBLOBs.getObject());

            ResultSet rs = DBHelper.execute(sqlSession, "select * from tb_blobs where id = 10");
            rs.first();
            Assert.assertEquals(rs.getString("field2"), "ts3");

            // 1. ?blob
            ObjectUtil TbSingleBlobMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbSingleBlobMapper")));

            ObjectUtil TbSingleBlob = new ObjectUtil(loader, packagz + ".TbSingleBlob");
            TbSingleBlob.set("id", 10l);
            TbSingleBlob.set("field1", "ts1");
            TbSingleBlob.set("field2", 3);

            // sql
            sql = SqlHelper.getFormatMapperSql(TbSingleBlobMapper.getObject(), "upsertWithBLOBs",
                    TbSingleBlob.getObject());
            Assert.assertEquals(sql,
                    "insert into tb_single_blob (id, field2, field1) values (10, 3, 'ts1' ) on duplicate key update id = 10, field2 = 3, field1 = 'ts1'");
            result = TbSingleBlobMapper.invoke("upsertWithBLOBs", TbSingleBlob.getObject());
            Assert.assertEquals(result, 1);

            TbSingleBlob.set("field1", "ts2");
            TbSingleBlobMapper.invoke("upsertWithBLOBs", TbSingleBlob.getObject());

            rs = DBHelper.execute(sqlSession, "select * from tb_single_blob where id = 10");
            rs.first();
            Assert.assertEquals(rs.getString("field1"), "ts2");
        }
    });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  upsertSelective/*from w  w w .ja  v  a 2s  .c  om*/
 */
@Test
public void testUpsertSelective() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            // 1. 
            ObjectUtil tbMapper = new ObjectUtil(sqlSession.getMapper(loader.loadClass(packagz + ".TbMapper")));

            ObjectUtil tb = new ObjectUtil(loader, packagz + ".Tb");
            tb.set("id", 20l);
            tb.set("field1", "ts1");

            // sql
            String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsertSelective", tb.getObject());
            Assert.assertEquals(sql,
                    "insert into tb ( id, field1 ) values ( 20, 'ts1' ) on duplicate key update id = 20, field1 = 'ts1'");
            Object result = tbMapper.invoke("upsertSelective", tb.getObject());
            Assert.assertEquals(result, 1);

            // 2. blobs
            ObjectUtil TbBlobsMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbBlobsMapper")));

            ObjectUtil TbBlobsWithBLOBs = new ObjectUtil(loader, packagz + ".TbBlobsWithBLOBs");
            TbBlobsWithBLOBs.set("id", 500l);
            TbBlobsWithBLOBs.set("field1", "ts1");
            TbBlobsWithBLOBs.set("field2", "ts2");

            // sql
            sql = SqlHelper.getFormatMapperSql(TbBlobsMapper.getObject(), "upsertSelective",
                    TbBlobsWithBLOBs.getObject());
            Assert.assertEquals(sql,
                    "insert into tb_blobs ( id, field1, field2 ) values ( 500, 'ts1', 'ts2' ) on duplicate key update id = 500, field1 = 'ts1', field2 = 'ts2'");
            result = TbBlobsMapper.invoke("upsertSelective", TbBlobsWithBLOBs.getObject());
            Assert.assertEquals(result, 1);
        }
    });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  upsertByExample/*from  w  w  w.  j  av a2s  .c  o  m*/
 */
@Test
public void testUpsertByExample() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            ObjectUtil tbMapper = new ObjectUtil(sqlSession.getMapper(loader.loadClass(packagz + ".TbMapper")));

            ObjectUtil TbExample = new ObjectUtil(loader, packagz + ".TbExample");
            ObjectUtil criteria = new ObjectUtil(TbExample.invoke("createCriteria"));
            criteria.invoke("andIdEqualTo", 50l);

            ObjectUtil tb = new ObjectUtil(loader, packagz + ".Tb");
            tb.set("id", 50l);
            tb.set("field1", "ts1");
            tb.set("field2", 5);

            // sql
            String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsertByExample", tb.getObject(),
                    TbExample.getObject());
            Assert.assertEquals(sql,
                    "update tb set id = 50, field1 = 'ts1', field2 = 5 WHERE ( id = '50' ) ; insert into tb (id, field1, field2) select 50, 'ts1', 5 from dual where not exists ( select 1 from tb WHERE ( id = '50' ) )");
            tbMapper.invoke("upsertByExample", tb.getObject(), TbExample.getObject());

            tb.set("field2", 20);
            tbMapper.invoke("upsertByExample", tb.getObject(), TbExample.getObject());

            ResultSet rs = DBHelper.execute(sqlSession, "select * from tb where id = 50");
            rs.first();
            Assert.assertEquals(rs.getInt("field2"), 20);
        }
    });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  upsertByExampleWithBLOBs//from   w  w  w  .j a  v  a  2  s  .c  o  m
 */
@Test
public void testUpsertByExampleWithBLOBs() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            // 1.  blob
            ObjectUtil TbBlobsMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbBlobsMapper")));

            ObjectUtil TbBlobsExample = new ObjectUtil(loader, packagz + ".TbBlobsExample");
            ObjectUtil criteria = new ObjectUtil(TbBlobsExample.invoke("createCriteria"));
            criteria.invoke("andIdEqualTo", 60l);

            ObjectUtil TbBlobsWithBLOBs = new ObjectUtil(loader, packagz + ".TbBlobsWithBLOBs");
            TbBlobsWithBLOBs.set("id", 60l);
            TbBlobsWithBLOBs.set("field1", "ts1");
            TbBlobsWithBLOBs.set("field2", "ts2");

            // sql
            String sql = SqlHelper.getFormatMapperSql(TbBlobsMapper.getObject(), "upsertByExampleWithBLOBs",
                    TbBlobsWithBLOBs.getObject(), TbBlobsExample.getObject());
            Assert.assertEquals(sql,
                    "update tb_blobs set id = 60, field1 = 'ts1', field2 = 'ts2', field3 = 'null' WHERE ( id = '60' ) ; insert into tb_blobs (id, field1, field2, field3) select 60, 'ts1', 'ts2', 'null' from dual where not exists ( select 1 from tb_blobs WHERE ( id = '60' ) )");
            TbBlobsMapper.invoke("upsertByExampleWithBLOBs", TbBlobsWithBLOBs.getObject(),
                    TbBlobsExample.getObject());

            TbBlobsWithBLOBs.set("field2", "ts3");
            TbBlobsMapper.invoke("upsertByExampleWithBLOBs", TbBlobsWithBLOBs.getObject(),
                    TbBlobsExample.getObject());

            ResultSet rs = DBHelper.execute(sqlSession, "select * from tb_blobs where id = 60");
            rs.first();
            Assert.assertEquals(rs.getString("field2"), "ts3");

            // 1. ?blob
            ObjectUtil TbSingleBlobMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbSingleBlobMapper")));

            ObjectUtil TbSingleBlobExample = new ObjectUtil(loader, packagz + ".TbSingleBlobExample");
            ObjectUtil criteria1 = new ObjectUtil(TbSingleBlobExample.invoke("createCriteria"));
            criteria1.invoke("andIdEqualTo", 70l);

            ObjectUtil TbSingleBlob = new ObjectUtil(loader, packagz + ".TbSingleBlob");
            TbSingleBlob.set("id", 70l);
            TbSingleBlob.set("field1", "ts1");
            TbSingleBlob.set("field2", 3);

            // sql
            sql = SqlHelper.getFormatMapperSql(TbSingleBlobMapper.getObject(), "upsertByExampleWithBLOBs",
                    TbSingleBlob.getObject(), TbSingleBlobExample.getObject());
            Assert.assertEquals(sql,
                    "update tb_single_blob set id = 70, field2 = 3, field1 = 'ts1' WHERE ( id = '70' ) ; insert into tb_single_blob (id, field2, field1) select 70, 3, 'ts1' from dual where not exists ( select 1 from tb_single_blob WHERE ( id = '70' ) )");
            TbSingleBlobMapper.invoke("upsertByExampleWithBLOBs", TbSingleBlob.getObject(),
                    TbSingleBlobExample.getObject());

            TbSingleBlob.set("field1", "ts2");
            TbSingleBlobMapper.invoke("upsertByExampleWithBLOBs", TbSingleBlob.getObject(),
                    TbSingleBlobExample.getObject());

            rs = DBHelper.execute(sqlSession, "select * from tb_single_blob where id = 70");
            rs.first();
            Assert.assertEquals(rs.getString("field1"), "ts2");
        }
    });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  upsertByExampleSelective//from ww  w .  j av a  2  s .  c o m
 */
@Test
public void testUpsertByExampleSelective() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            // 1. 
            ObjectUtil tbMapper = new ObjectUtil(sqlSession.getMapper(loader.loadClass(packagz + ".TbMapper")));

            ObjectUtil TbExample = new ObjectUtil(loader, packagz + ".TbExample");
            ObjectUtil criteria = new ObjectUtil(TbExample.invoke("createCriteria"));
            criteria.invoke("andIdEqualTo", 100l);

            ObjectUtil tb = new ObjectUtil(loader, packagz + ".Tb");
            tb.set("id", 100l);
            tb.set("field1", "ts1");

            // sql
            String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsertByExampleSelective",
                    tb.getObject(), TbExample.getObject());
            Assert.assertEquals(sql,
                    "update tb set id = 100, field1 = 'ts1' WHERE ( id = '100' ) ; insert into tb ( id, field1 ) select 100, 'ts1' from dual where not exists ( select 1 from tb WHERE ( id = '100' ) )");
            tbMapper.invoke("upsertByExampleSelective", tb.getObject(), TbExample.getObject());

            // 2. blobs
            ObjectUtil TbBlobsMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbBlobsMapper")));

            ObjectUtil TbBlobsExample = new ObjectUtil(loader, packagz + ".TbBlobsExample");
            ObjectUtil criteria1 = new ObjectUtil(TbBlobsExample.invoke("createCriteria"));
            criteria1.invoke("andIdEqualTo", 60l);

            ObjectUtil TbBlobsWithBLOBs = new ObjectUtil(loader, packagz + ".TbBlobsWithBLOBs");
            TbBlobsWithBLOBs.set("id", 200l);
            TbBlobsWithBLOBs.set("field1", "ts1");
            TbBlobsWithBLOBs.set("field2", "ts2");

            // sql
            sql = SqlHelper.getFormatMapperSql(TbBlobsMapper.getObject(), "upsertByExampleSelective",
                    TbBlobsWithBLOBs.getObject(), TbBlobsExample.getObject());
            Assert.assertEquals(sql,
                    "update tb_blobs set id = 200, field1 = 'ts1', field2 = 'ts2' WHERE ( id = '60' ) ; insert into tb_blobs ( id, field1, field2 ) select 200, 'ts1', 'ts2' from dual where not exists ( select 1 from tb_blobs WHERE ( id = '60' ) )");
            TbBlobsMapper.invoke("upsertByExampleSelective", TbBlobsWithBLOBs.getObject(),
                    TbBlobsExample.getObject());
        }
    });
}

---

From source file:com.itfsw.mybatis.generator.plugins.UpsertPluginTest.java

License:Apache License

/**
 *  /*from  w w  w.j a  v a 2  s .c o m*/
 */
@Test
public void testWithIdentityAndGeneratedAlwaysColumns() throws Exception {
    MyBatisGeneratorTool tool = MyBatisGeneratorTool.create("scripts/UpsertPlugin/mybatis-generator.xml");
    tool.generate(new IBeforeCallback() {
        @Override
        public void run() throws Exception {
            DBHelper.resetDB("scripts/UpsertPlugin/init.sql");
        }
    }, new AbstractShellCallback() {
        @Override
        public void reloadProject(SqlSession sqlSession, ClassLoader loader, String packagz) throws Exception {
            // ------------------------------------------ upsert
            // ---------------------------------------------------
            ObjectUtil tbMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbWithIncIdMapper")));

            ObjectUtil tb = new ObjectUtil(loader, packagz + ".TbWithIncId");
            tb.set("field1", "ts1");
            tb.set("field2", 5);

            // sql
            String sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsert", tb.getObject());
            Assert.assertEquals(sql,
                    "insert into tb_with_inc_id ( field1, field2 ) values ( 'ts1', 5 ) on duplicate key update field1 = 'ts1', field2 = 5");
            tbMapper.invoke("upsert", tb.getObject());
            // ?ID
            Long id = (Long) tb.get("id");

            tb.set("field2", 20);
            tbMapper.invoke("upsert", tb.getObject());

            ResultSet rs = DBHelper.execute(sqlSession, "select * from tb_with_inc_id where id = " + id);
            rs.first();
            Assert.assertEquals(rs.getInt("field2"), 20);

            // ------------------------------------------ upsertWithBlobs
            // ---------------------------------------------------
            tbMapper = new ObjectUtil(
                    sqlSession.getMapper(loader.loadClass(packagz + ".TbBlobsWithIncIdMapper")));

            ObjectUtil tbWithBLOBs = new ObjectUtil(loader, packagz + ".TbBlobsWithIncIdWithBLOBs");
            tbWithBLOBs.set("field1", "ts1");
            tbWithBLOBs.set("field2", "ts2");

            // sql
            sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsertWithBLOBs",
                    tbWithBLOBs.getObject());
            Assert.assertEquals(sql,
                    "insert into tb_blobs_with_inc_id ( field1, field2, field3 ) values ( 'ts1', 'ts2', 'null' ) on duplicate key update field1 = 'ts1', field2 = 'ts2', field3 = 'null'");
            tbMapper.invoke("upsert", tbWithBLOBs.getObject());
            // ?ID
            id = (Long) tbWithBLOBs.get("id");

            tbWithBLOBs.set("field2", "ts3");
            tbMapper.invoke("upsertWithBLOBs", tbWithBLOBs.getObject());

            rs = DBHelper.execute(sqlSession, "select * from tb_blobs_with_inc_id where id = " + id);
            rs.first();
            Assert.assertEquals(rs.getString("field2"), "ts3");

            // sql(withOutBlobs)
            tb = new ObjectUtil(loader, packagz + ".TbBlobsWithIncId");
            tb.set("field1", "ts4");

            sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsert", tb.getObject());
            Assert.assertEquals(sql,
                    "insert into tb_blobs_with_inc_id ( field1 ) values ( 'ts4' ) on duplicate key update field1 = 'ts4'");
            tbMapper.invoke("upsert", tb.getObject());
            // ?ID
            id = (Long) tb.get("id");

            tb.set("field1", "ts5");
            tbMapper.invoke("upsert", tb.getObject());

            rs = DBHelper.execute(sqlSession, "select * from tb_blobs_with_inc_id where id = " + id);
            rs.first();
            Assert.assertEquals(rs.getString("field1"), "ts5");

            // ------------------------------------------ upsertByExample
            // ---------------------------------------------------
            tbMapper = new ObjectUtil(sqlSession.getMapper(loader.loadClass(packagz + ".TbWithIncIdMapper")));

            tb = new ObjectUtil(loader, packagz + ".TbWithIncId");
            tb.set("field1", "ts6");
            tb.set("field2", 5);

            ObjectUtil tbExample = new ObjectUtil(loader, packagz + ".TbWithIncIdExample");
            ObjectUtil criteria = new ObjectUtil(tbExample.invoke("createCriteria"));
            criteria.invoke("andField1EqualTo", "ts6");

            // sql
            sql = SqlHelper.getFormatMapperSql(tbMapper.getObject(), "upsertByExample", tb.getObject(),
                    tbExample.getObject());
            Assert.assertEquals(sql,
                    "update tb_with_inc_id set field1 = 'ts6', field2 = 5 WHERE ( field1 = 'ts6' ) ; insert into tb_with_inc_id ( field1, field2 ) select 'ts6', 5 from dual where not exists ( select 1 from tb_with_inc_id WHERE ( field1 = 'ts6' ) )");
            tbMapper.invoke("upsertByExample", tb.getObject(), tbExample.getObject());

            tb.set("field2", 21);
            tbMapper.invoke("upsertByExample", tb.getObject(), tbExample.getObject());

            rs = DBHelper.execute(sqlSession, "select * from tb_with_inc_id where field1 = 'ts6'");
            rs.first();
            Assert.assertEquals(rs.getInt("field2"), 21);
        }
    });
}

---

From source file:com.jklas.search.interceptors.ibatis.dao.PersonDao.java

License:Open Source License

public PersonDao(SqlSession session) {
    this.personMapper = session.getMapper(PersonMapper.class);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »