Examples with Entity cn.hutool.db.Entity used on opensource projects

Example 1 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class CRUDTest method crudTest.

/**
 * 对增删改查做单元测试
 *
 * @throws SQLException
 */
@Test
@Ignore
public void crudTest() throws SQLException {
    // 增
    Long id = runner.insertForGeneratedKey(Entity.create("user").set("name", "unitTestUser").set("age", 66));
    Assert.assertTrue(id > 0);
    Entity result = runner.get("user", "name", "unitTestUser");
    Assert.assertSame(66, (int) result.getInt("age"));
    // 改
    int update = runner.update(Entity.create().set("age", 88), Entity.create("user").set("name", "unitTestUser"));
    Assert.assertTrue(update > 0);
    Entity result2 = runner.get("user", "name", "unitTestUser");
    Assert.assertSame(88, (int) result2.getInt("age"));
    // 删
    int del = runner.del("user", "name", "unitTestUser");
    Assert.assertTrue(del > 0);
    Entity result3 = runner.get("user", "name", "unitTestUser");
    Assert.assertNull(result3);
}

Example 2 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class CRUDTest method insertBatchOneTest.

@Test
@Ignore
public void insertBatchOneTest() throws SQLException {
    User user1 = new User();
    user1.setName("张三");
    user1.setAge(12);
    user1.setBirthday("19900112");
    user1.setGender(true);
    Entity data1 = Entity.parse(user1);
    Console.log(data1);
    int[] result = runner.insert(CollUtil.newArrayList(data1));
    Console.log(result);
}

Example 3 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class DsTest method c3p0DsTest.

@Test
public void c3p0DsTest() throws SQLException {
    DSFactory.setCurrentDSFactory(new C3p0DSFactory());
    DataSource ds = DSFactory.get();
    SqlRunner runner = SqlRunner.create(ds);
    List<Entity> all = runner.findAll("user");
    Assert.assertTrue(CollUtil.isNotEmpty(all));
}

Example 4 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class DsTest method defaultDsTest.

@Test
public void defaultDsTest() throws SQLException {
    DataSource ds = DSFactory.get();
    SqlRunner runner = SqlRunner.create(ds);
    List<Entity> all = runner.findAll("user");
    Assert.assertTrue(CollUtil.isNotEmpty(all));
}

Example 5 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class DsTest method dbcpDsTest.

@Test
public void dbcpDsTest() throws SQLException {
    DSFactory.setCurrentDSFactory(new DbcpDSFactory());
    DataSource ds = DSFactory.get();
    SqlRunner runner = SqlRunner.create(ds);
    List<Entity> all = runner.findAll("user");
    Assert.assertTrue(CollUtil.isNotEmpty(all));
}