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.sc.mapper.generator.SellersSqlProvider.java

public String updateByExample(Map<String, Object> parameter) {
    SQL sql = new SQL();
    sql.UPDATE("TB_SELLERS");

    sql.SET("CM_SELLERID = #{record.CM_SELLERID,jdbcType=VARCHAR}");
    sql.SET("CM_SELLERNAME = #{record.CM_SELLERNAME,jdbcType=VARCHAR}");
    sql.SET("CM_PHONE = #{record.CM_PHONE,jdbcType=BIGINT}");
    sql.SET("CM_ACCOUNT = #{record.CM_ACCOUNT,jdbcType=VARCHAR}");
    sql.SET("CM_PASSWORD = #{record.CM_PASSWORD,jdbcType=VARCHAR}");
    sql.SET("CM_BRANDID = #{record.CM_BRANDID,jdbcType=INTEGER}");
    sql.SET("CM_CARDPATH = #{record.CM_CARDPATH,jdbcType=VARCHAR}");
    sql.SET("CM_STOREPATH = #{record.CM_STOREPATH,jdbcType=VARCHAR}");
    sql.SET("CM_LICENSEPATH = #{record.CM_LICENSEPATH,jdbcType=VARCHAR}");
    sql.SET("CM_ADDRESS = #{record.CM_ADDRESS,jdbcType=VARCHAR}");
    sql.SET("CM_LON = #{record.CM_LON,jdbcType=DOUBLE}");
    sql.SET("CM_LAT = #{record.CM_LAT,jdbcType=DOUBLE}");
    sql.SET("CM_CREATETIME = #{record.CM_CREATETIME,jdbcType=TIMESTAMP}");
    sql.SET("CM_ISEXAMINE = #{record.CM_ISEXAMINE,jdbcType=INTEGER}");
    sql.SET("CM_REASON = #{record.CM_REASON,jdbcType=VARCHAR}");
    sql.SET("CM_CARDNO = #{record.CM_CARDNO,jdbcType=VARCHAR}");
    sql.SET("CM_NAME = #{record.CM_NAME,jdbcType=VARCHAR}");
    sql.SET("CM_CONTACTNAME = #{record.CM_CONTACTNAME,jdbcType=VARCHAR}");
    sql.SET("CM_CONTACTPHONE = #{record.CM_CONTACTPHONE,jdbcType=VARCHAR}");
    sql.SET("CM_TELEPHONE = #{record.CM_TELEPHONE,jdbcType=VARCHAR}");
    sql.SET("CM_PAX = #{record.CM_PAX,jdbcType=VARCHAR}");

    SellersExample example = (SellersExample) parameter.get("example");
    applyWhere(sql, example, true);/*from  ww w  .  j ava 2 s  .  com*/
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UserapplicationsSqlProvider.java

public String countByExample(UserapplicationsExample example) {
    SQL sql = new SQL();
    sql.SELECT("count(*)").FROM("TB_USERAPPLICATIONS");
    applyWhere(sql, example, false);//from   w w w  .  j  a v a2  s  . c o  m
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UserapplicationsSqlProvider.java

public String deleteByExample(UserapplicationsExample example) {
    SQL sql = new SQL();
    sql.DELETE_FROM("TB_USERAPPLICATIONS");
    applyWhere(sql, example, false);/*from w w  w . ja v a  2 s.  co  m*/
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UserapplicationsSqlProvider.java

public String insertSelective(Userapplications record) {
    SQL sql = new SQL();
    sql.INSERT_INTO("TB_USERAPPLICATIONS");

    if (record.getCM_ID() != null) {
        sql.VALUES("CM_ID", "#{CM_ID,jdbcType=INTEGER}");
    }// w  w w.j av  a2  s .  co  m

    if (record.getCM_NAME() != null) {
        sql.VALUES("CM_NAME", "#{CM_NAME,jdbcType=VARCHAR}");
    }

    if (record.getCM_PHONE() != null) {
        sql.VALUES("CM_PHONE", "#{CM_PHONE,jdbcType=BIGINT}");
    }

    if (record.getCM_CARDFACEPATH() != null) {
        sql.VALUES("CM_CARDFACEPATH", "#{CM_CARDFACEPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_CARDBACKPATH() != null) {
        sql.VALUES("CM_CARDBACKPATH", "#{CM_CARDBACKPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_PERSONALPATH() != null) {
        sql.VALUES("CM_PERSONALPATH", "#{CM_PERSONALPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_LICENSEPATH() != null) {
        sql.VALUES("CM_LICENSEPATH", "#{CM_LICENSEPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_SHOPEADDRESS() != null) {
        sql.VALUES("CM_SHOPEADDRESS", "#{CM_SHOPEADDRESS,jdbcType=VARCHAR}");
    }

    if (record.getCM_SHOPLON() != null) {
        sql.VALUES("CM_SHOPLON", "#{CM_SHOPLON,jdbcType=DOUBLE}");
    }

    if (record.getCM_SHOPLAT() != null) {
        sql.VALUES("CM_SHOPLAT", "#{CM_SHOPLAT,jdbcType=DOUBLE}");
    }

    if (record.getCM_STATE() != null) {
        sql.VALUES("CM_STATE", "#{CM_STATE,jdbcType=INTEGER}");
    }

    if (record.getCM_REASON() != null) {
        sql.VALUES("CM_REASON", "#{CM_REASON,jdbcType=VARCHAR}");
    }

    if (record.getCM_TYPE() != null) {
        sql.VALUES("CM_TYPE", "#{CM_TYPE,jdbcType=INTEGER}");
    }

    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UserapplicationsSqlProvider.java

public String selectByExample(UserapplicationsExample example) {
    SQL sql = new SQL();
    if (example != null && example.isDistinct()) {
        sql.SELECT_DISTINCT("CM_ID");
    } else {/*from w ww. j av  a  2s  .c  om*/
        sql.SELECT("CM_ID");
    }
    sql.SELECT("CM_NAME");
    sql.SELECT("CM_PHONE");
    sql.SELECT("CM_CARDFACEPATH");
    sql.SELECT("CM_CARDBACKPATH");
    sql.SELECT("CM_PERSONALPATH");
    sql.SELECT("CM_LICENSEPATH");
    sql.SELECT("CM_SHOPEADDRESS");
    sql.SELECT("CM_SHOPLON");
    sql.SELECT("CM_SHOPLAT");
    sql.SELECT("CM_STATE");
    sql.SELECT("CM_REASON");
    sql.SELECT("CM_TYPE");
    sql.FROM("TB_USERAPPLICATIONS");
    applyWhere(sql, example, false);

    if (example != null && example.getOrderByClause() != null) {
        sql.ORDER_BY(example.getOrderByClause());
    }

    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UserapplicationsSqlProvider.java

public String updateByExampleSelective(Map<String, Object> parameter) {
    Userapplications record = (Userapplications) parameter.get("record");
    UserapplicationsExample example = (UserapplicationsExample) parameter.get("example");

    SQL sql = new SQL();
    sql.UPDATE("TB_USERAPPLICATIONS");

    if (record.getCM_ID() != null) {
        sql.SET("CM_ID = #{record.CM_ID,jdbcType=INTEGER}");
    }/*from  ww w  .  j  a  v a  2  s.c  om*/

    if (record.getCM_NAME() != null) {
        sql.SET("CM_NAME = #{record.CM_NAME,jdbcType=VARCHAR}");
    }

    if (record.getCM_PHONE() != null) {
        sql.SET("CM_PHONE = #{record.CM_PHONE,jdbcType=BIGINT}");
    }

    if (record.getCM_CARDFACEPATH() != null) {
        sql.SET("CM_CARDFACEPATH = #{record.CM_CARDFACEPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_CARDBACKPATH() != null) {
        sql.SET("CM_CARDBACKPATH = #{record.CM_CARDBACKPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_PERSONALPATH() != null) {
        sql.SET("CM_PERSONALPATH = #{record.CM_PERSONALPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_LICENSEPATH() != null) {
        sql.SET("CM_LICENSEPATH = #{record.CM_LICENSEPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_SHOPEADDRESS() != null) {
        sql.SET("CM_SHOPEADDRESS = #{record.CM_SHOPEADDRESS,jdbcType=VARCHAR}");
    }

    if (record.getCM_SHOPLON() != null) {
        sql.SET("CM_SHOPLON = #{record.CM_SHOPLON,jdbcType=DOUBLE}");
    }

    if (record.getCM_SHOPLAT() != null) {
        sql.SET("CM_SHOPLAT = #{record.CM_SHOPLAT,jdbcType=DOUBLE}");
    }

    if (record.getCM_STATE() != null) {
        sql.SET("CM_STATE = #{record.CM_STATE,jdbcType=INTEGER}");
    }

    if (record.getCM_REASON() != null) {
        sql.SET("CM_REASON = #{record.CM_REASON,jdbcType=VARCHAR}");
    }

    if (record.getCM_TYPE() != null) {
        sql.SET("CM_TYPE = #{record.CM_TYPE,jdbcType=INTEGER}");
    }

    applyWhere(sql, example, true);
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UserapplicationsSqlProvider.java

public String updateByExample(Map<String, Object> parameter) {
    SQL sql = new SQL();
    sql.UPDATE("TB_USERAPPLICATIONS");

    sql.SET("CM_ID = #{record.CM_ID,jdbcType=INTEGER}");
    sql.SET("CM_NAME = #{record.CM_NAME,jdbcType=VARCHAR}");
    sql.SET("CM_PHONE = #{record.CM_PHONE,jdbcType=BIGINT}");
    sql.SET("CM_CARDFACEPATH = #{record.CM_CARDFACEPATH,jdbcType=VARCHAR}");
    sql.SET("CM_CARDBACKPATH = #{record.CM_CARDBACKPATH,jdbcType=VARCHAR}");
    sql.SET("CM_PERSONALPATH = #{record.CM_PERSONALPATH,jdbcType=VARCHAR}");
    sql.SET("CM_LICENSEPATH = #{record.CM_LICENSEPATH,jdbcType=VARCHAR}");
    sql.SET("CM_SHOPEADDRESS = #{record.CM_SHOPEADDRESS,jdbcType=VARCHAR}");
    sql.SET("CM_SHOPLON = #{record.CM_SHOPLON,jdbcType=DOUBLE}");
    sql.SET("CM_SHOPLAT = #{record.CM_SHOPLAT,jdbcType=DOUBLE}");
    sql.SET("CM_STATE = #{record.CM_STATE,jdbcType=INTEGER}");
    sql.SET("CM_REASON = #{record.CM_REASON,jdbcType=VARCHAR}");
    sql.SET("CM_TYPE = #{record.CM_TYPE,jdbcType=INTEGER}");

    UserapplicationsExample example = (UserapplicationsExample) parameter.get("example");
    applyWhere(sql, example, true);//from   ww w .  j  a  va  2 s  .  c  o m
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UsersSqlProvider.java

public String countByExample(UsersExample example) {
    SQL sql = new SQL();
    sql.SELECT("count(*)").FROM("TB_USERS");
    applyWhere(sql, example, false);//from w w w.j  a  v  a  2s  .  c om
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UsersSqlProvider.java

public String deleteByExample(UsersExample example) {
    SQL sql = new SQL();
    sql.DELETE_FROM("TB_USERS");
    applyWhere(sql, example, false);/*from   www . j  a  va  2 s  . co  m*/
    return sql.toString();
}

---

From source file:com.sc.mapper.generator.UsersSqlProvider.java

public String insertSelective(Users record) {
    SQL sql = new SQL();
    sql.INSERT_INTO("TB_USERS");

    if (record.getCM_USERID() != null) {
        sql.VALUES("CM_USERID", "#{CM_USERID,jdbcType=VARCHAR}");
    }//from   w  w w . j  a  v a  2 s.com

    if (record.getCM_SHOPNAME() != null) {
        sql.VALUES("CM_SHOPNAME", "#{CM_SHOPNAME,jdbcType=VARCHAR}");
    }

    if (record.getCM_PHONE() != null) {
        sql.VALUES("CM_PHONE", "#{CM_PHONE,jdbcType=BIGINT}");
    }

    if (record.getCM_ACCOUNT() != null) {
        sql.VALUES("CM_ACCOUNT", "#{CM_ACCOUNT,jdbcType=VARCHAR}");
    }

    if (record.getCM_PASSWORD() != null) {
        sql.VALUES("CM_PASSWORD", "#{CM_PASSWORD,jdbcType=VARCHAR}");
    }

    if (record.getCM_INTEGRAL() != null) {
        sql.VALUES("CM_INTEGRAL", "#{CM_INTEGRAL,jdbcType=INTEGER}");
    }

    if (record.getCM_BALANCE() != null) {
        sql.VALUES("CM_BALANCE", "#{CM_BALANCE,jdbcType=DOUBLE}");
    }

    if (record.getCM_CARDPATH() != null) {
        sql.VALUES("CM_CARDPATH", "#{CM_CARDPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_STOREPATH() != null) {
        sql.VALUES("CM_STOREPATH", "#{CM_STOREPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_LICENSEPATH() != null) {
        sql.VALUES("CM_LICENSEPATH", "#{CM_LICENSEPATH,jdbcType=VARCHAR}");
    }

    if (record.getCM_SHOPEADDRESS() != null) {
        sql.VALUES("CM_SHOPEADDRESS", "#{CM_SHOPEADDRESS,jdbcType=VARCHAR}");
    }

    if (record.getCM_SHOPLON() != null) {
        sql.VALUES("CM_SHOPLON", "#{CM_SHOPLON,jdbcType=DOUBLE}");
    }

    if (record.getCM_SHOPLAT() != null) {
        sql.VALUES("CM_SHOPLAT", "#{CM_SHOPLAT,jdbcType=DOUBLE}");
    }

    if (record.getCM_LEVEL() != null) {
        sql.VALUES("CM_LEVEL", "#{CM_LEVEL,jdbcType=INTEGER}");
    }

    if (record.getCM_CREATETIME() != null) {
        sql.VALUES("CM_CREATETIME", "#{CM_CREATETIME,jdbcType=TIMESTAMP}");
    }

    if (record.getCM_ISEXAMINE() != null) {
        sql.VALUES("CM_ISEXAMINE", "#{CM_ISEXAMINE,jdbcType=INTEGER}");
    }

    if (record.getCM_REASON() != null) {
        sql.VALUES("CM_REASON", "#{CM_REASON,jdbcType=VARCHAR}");
    }

    if (record.getCM_CARDNO() != null) {
        sql.VALUES("CM_CARDNO", "#{CM_CARDNO,jdbcType=VARCHAR}");
    }

    if (record.getCM_NAME() != null) {
        sql.VALUES("CM_NAME", "#{CM_NAME,jdbcType=VARCHAR}");
    }

    if (record.getCM_CONTACTNAME() != null) {
        sql.VALUES("CM_CONTACTNAME", "#{CM_CONTACTNAME,jdbcType=VARCHAR}");
    }

    if (record.getCM_CONTACTPHONE() != null) {
        sql.VALUES("CM_CONTACTPHONE", "#{CM_CONTACTPHONE,jdbcType=VARCHAR}");
    }

    if (record.getCM_TELEPHONE() != null) {
        sql.VALUES("CM_TELEPHONE", "#{CM_TELEPHONE,jdbcType=VARCHAR}");
    }

    if (record.getCM_PAX() != null) {
        sql.VALUES("CM_PAX", "#{CM_PAX,jdbcType=VARCHAR}");
    }

    return sql.toString();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »