Example usage for org.apache.ibatis.jdbc SQL SQL

Introduction

In this page you can find the example usage for org.apache.ibatis.jdbc SQL SQL.

Prototype

SQL

Source Link

Usage

From source file:com.baomidou.mybatisplus.test.activerecord.ActiveRecordTest.java

License:Apache License

public static void main(String[] args) {
    // ?//from  www  .  ja  v  a2  s.  co  m
    InputStream in = TestMapper.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    SqlSessionFactory sqlSessionFactory = mf.build(in);
    TableInfoHelper.initSqlSessionFactory(sqlSessionFactory);
    sqlSessionFactory.openSession(false);
    // ??
    Test t1 = new Test();
    t1.setType("test10");
    boolean rlt = t1.insert();
    print(" ar save=" + rlt + ", id=" + t1.getId());

    // ?ID
    t1.setType("t1023");
    rlt = t1.updateById();
    print(" ar updateById:" + rlt);

    //  SQL
    Test t11 = new Test();
    t11.setType("123");
    rlt = t11.update("id={0}", t1.getId());
    print("update sql=" + rlt);

    //  SQL
    Test t10 = t1.selectOne("id={0}", t1.getId());
    print("selectOne=" + t10.getType());

    // ?OR
    t1.setType("t1021");
    rlt = t1.insertOrUpdate();
    print(" ar saveOrUpdate:" + rlt);

    // ?ID
    Test t2 = t1.selectById();
    print(" t2 = " + t2.toString());
    t2.setId(IdWorker.getId());
    t2.insert();

    // 
    List<Test> tl = t2.selectAll();
    for (Test t : tl) {
        print("selectAll=" + t.toString());
    }

    // 
    print(" count=" + t2.selectCount(null));

    // 
    Page<Test> page = new Page<>(0, 10);
    page = t2.selectPage(page, null);
    print(page.toString());

    // ?ID
    rlt = t2.deleteById();
    print("deleteById=" + rlt + ", id=" + t2.getId());

    //  SQL 
    List<Map<String, Object>> ul = t2.sql().selectList(new SQL() {
        {
            SELECT("*");
            FROM("test");
            WHERE("type='t1021'");
        }
    }.toString());
    System.err.println("selectList SQL:");
    for (Map<String, Object> map : ul) {
        System.err.println(map);
    }

    // ?ID
    Test t20 = t2.selectById();
    print("t2 ??" + (null != t20));

    //  SQL
    rlt = t2.delete("type={0}", "t1021");
    System.err.println("delete sql=" + rlt);
}

From source file:com.blazarquant.bfp.database.providers.MessageSQLProvider.java

License:Apache License

public String buildCountUserMessages() {
    return new SQL() {
        {//  w w w  . j  a  va  2  s  . c  o  m
            SELECT("count(*)");
            FROM(Tables.MESSAGES);
            WHERE("user_id = #{userId.id}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.MessageSQLProvider.java

License:Apache License

public String buildSaveMessage() {
    return new SQL() {
        {//from   w  w w .  ja  va  2 s .c o  m
            INSERT_INTO(Tables.MESSAGES);
            VALUES("user_id, message",
                    "#{userId.id}, #{message, typeHandler=com.blazarquant.bfp.database.typehandlers.fix.FixMessageTypeHandler}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.MessageSQLProvider.java

License:Apache License

public String buildClearHistory() {
    return new SQL() {
        {//from w ww .java 2 s .c o m
            DELETE_FROM(Tables.MESSAGES);
            WHERE("user_id = #{userId.id}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.ShareSQLProvider.java

License:Apache License

public String buildFindMessageByKey() {
    return new SQL() {
        {//ww w.  j  ava  2s. com
            SELECT("share_message");
            FROM(Tables.SHARED_MESSAGES);
            WHERE("share_key = #{shareKey}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.ShareSQLProvider.java

License:Apache License

public String buildSaveSharedMessage() {
    return new SQL() {
        {/*ww w .ja  v  a2s.c o m*/
            INSERT_INTO(Tables.SHARED_MESSAGES);
            VALUES("share_key, share_message", "#{shareKey}, #{shareMessage}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.TrackerSQLProvider.java

License:Apache License

public String buildFindTrackerData() {
    return new SQL() {
        {// w  ww  .  j a v a 2s . c  o m
            SELECT("*");
            FROM(Tables.TRACKER_TABLE);
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.TrackerSQLProvider.java

License:Apache License

public String buildSaveInputParse() {
    return new SQL() {
        {//from   w  w w . j a v  a  2 s. c  o  m
            INSERT_INTO(Tables.TRACKER_TABLE);
            VALUES("tracker_date, tracker_number",
                    "#{parseDate, typeHandler=com.blazarquant.bfp.database.typehandlers.InstantTypeHandler}, #{messageNumber}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindAllUsers() {
    return new SQL() {
        {
            SELECT("*");
            FROM(Tables.USERS_TABLE);
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindUserByLogin() {
    return new SQL() {
        {//from w ww.  jav  a  2  s. c o  m
            SELECT("*");
            FROM(Tables.USERS_TABLE);
            WHERE("user_login = #{userName}");
        }
    }.toString();
}