Package org.nutz.dao.sql

Examples of org.nutz.dao.sql.SqlCallback

62
63
64
65
66
67
68
69
70
71
72
  public void test_query_without_entity() {
    pojos.initPet();
    dao.insert(Pet.create(4));
    Sql sql = Sqls.create("SELECT * FROM t_pet $condition");
    sql.setCondition(Cnd.where("name", "like", "pet_%").asc("name"));
    sql.setCallback(new SqlCallback() {
      public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
        List<Pet> pets = new ArrayList<Pet>(4);
        while (rs.next())
          pets.add(dao.getObject(Pet.class, rs, null));
        return pets;
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
        // 这个仅仅测试MySQL数据库
        if (isMySql) {
            dao.create(TableWithTimestampInMySql.class, true);
            Sql descTable = Sqls.create(DESC_TABLE_SQL);
            descTable.params().set("tableName", "t_ts");
            descTable.setCallback(new SqlCallback() {
                public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
                    boolean ts1 = false;
                    boolean ts2 = false;
                    boolean ts3 = false;
                    boolean ts4 = false;
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    public void test_query_without_entity() {
        pojos.initPet();
        dao.insert(Pet.create(4));
        Sql sql = Sqls.create("SELECT * FROM t_pet $condition");
        sql.setCondition(Cnd.where("name", "like", "pet_%").asc("name"));
        sql.setCallback(new SqlCallback() {
            public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
                List<Pet> pets = new ArrayList<Pet>(4);
                while (rs.next())
                    pets.add(dao.getObject(Pet.class, rs, null));
                return pets;
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
        // 这个仅仅测试MySQL数据库
        if (isMySql) {
            dao.create(TableWithTimestampInMySql.class, true);
            Sql descTable = Sqls.create(DESC_TABLE_SQL);
            descTable.params().set("tableName", "t_ts");
            descTable.setCallback(new SqlCallback() {
                public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
                    boolean ts1 = false;
                    boolean ts2 = false;
                    boolean ts3 = false;
                    boolean ts4 = false;
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
    public <T> T queryForObject(String sql,
                                Map<String, Object> vars,
                                Map<String, Object> params,
                                Class<T> classOfT) {
        Sql sqlObj = createSqlObj(sql, params);
        sqlObj.setCallback(new SqlCallback() {
            public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
                if (null != rs && rs.next())
                    return rs.getObject(1);
                return null;
            }
View Full Code Here
393
394
395
396
397
398
399
400
401
402
403
                                    Map<String, Object> vars,
                                    Map<String, Object> params,
                                    final Class<T> classOfT) {
        Sql sqlObj = createSqlObj(sql, params);

        sqlObj.setCallback(new SqlCallback() {
            public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
                List<T> list = new ArrayList<T>();
                while (rs.next()) {
                    T result = Castors.me().castTo(rs.getObject(1), classOfT);
                    list.add(result);
View Full Code Here
TOP

Related Classes of org.nutz.dao.sql.SqlCallback

  • org.nutz.dao.impl.sql.SqlTemplate
  • org.nutz.dao.test.normal.CreateDropTableTest
  • org.nutz.dao.test.sqls.CustomizedSqlsTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.