Package com.github.yulichang.toolkit.sql

Class SqlScriptUtils

java.lang.Object
com.github.yulichang.toolkit.sql.SqlScriptUtils
All Implemented Interfaces:
com.baomidou.mybatisplus.core.toolkit.Constants, com.baomidou.mybatisplus.core.toolkit.StringPool, Serializable
public abstract class SqlScriptUtils extends Object implements com.baomidou.mybatisplus.core.toolkit.Constants
copy mp 3.4.3 SqlScriptUtils
See Also:

  • Field Summary

    Fields inherited from interface com.baomidou.mybatisplus.core.toolkit.Constants

    AES, AES_CBC_CIPHER, ARRAY, AS, ASC, COLL, COLLECTION, COLUMN_MAP, COLUMN_MAP_IS_EMPTY, DEFAULT_BATCH_SIZE, DESC, ENTITY, ENTITY_DOT, LIMIT, LIST, MD5, MP_FILL_ET, MP_OPTLOCK_VERSION_ORIGINAL, MYBATIS_PLUS, ORDER_BY, Q_WRAPPER_SQL_COMMENT, Q_WRAPPER_SQL_FIRST, Q_WRAPPER_SQL_SELECT, U_WRAPPER_SQL_SET, WHERE, WRAPPER, WRAPPER_DOT, WRAPPER_EMPTYOFNORMAL, WRAPPER_EMPTYOFWHERE, WRAPPER_ENTITY, WRAPPER_ENTITY_DOT, WRAPPER_EXPRESSION_ORDER, WRAPPER_NONEMPTYOFENTITY, WRAPPER_NONEMPTYOFNORMAL, WRAPPER_NONEMPTYOFWHERE, WRAPPER_PARAM, WRAPPER_PARAM_MIDDLE, WRAPPER_SQLSEGMENT

    Fields inherited from interface com.baomidou.mybatisplus.core.toolkit.StringPool

    AMPERSAND, AND, ASTERISK, AT, BACK_SLASH, BACKTICK, BYTES_NEW_LINE, COLON, COMMA, CRLF, DASH, DOLLAR, DOLLAR_LEFT_BRACE, DOT, DOT_CLASS, DOT_JAVA, DOT_NEWLINE, DOT_XML, DOTDOT, EMPTY, EMPTY_ARRAY, EQUALS, EXCLAMATION_MARK, FALSE, HASH, HASH_LEFT_BRACE, HAT, HTML_AMP, HTML_GT, HTML_LT, HTML_NBSP, HTML_QUOTE, ISO_8859_1, LEFT_BRACE, LEFT_BRACKET, LEFT_CHEV, LEFT_SQ_BRACKET, N, NEWLINE, NO, NULL, NUM, OFF, ON, ONE, PERCENT, PIPE, PLUS, QUESTION_MARK, QUOTE, RETURN, RIGHT_BRACE, RIGHT_BRACKET, RIGHT_CHEV, RIGHT_SQ_BRACKET, SEMICOLON, SINGLE_QUOTE, SLASH, SPACE, SQL, STAR, TAB, TILDA, TRUE, UNDERSCORE, US_ASCII, UTF_8, Y, YES, ZERO

  • Constructor Summary

    Constructors
    Constructor
    Description
    SqlScriptUtils()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    static String
    convertChoose(String whenTest, String whenSqlScript, String otherwise)
    生成 choose 标签的脚本
    static String
    convertForeach(String sqlScript, String collection, String index, String item, String separator)
    生成 foreach 标签的脚本
    static String
    convertIf(String sqlScript, String ifTest, boolean newLine)
    获取 带 if 标签的脚本
    static String
    convertParamMapping(Class<? extends org.apache.ibatis.type.TypeHandler<?>> typeHandler, org.apache.ibatis.type.JdbcType jdbcType, Integer numericScale)
     
    static String
    convertSet(String sqlScript)
    生成 set 标签的脚本
    static String
    convertTrim(String sqlScript, String prefix, String suffix, String prefixOverrides, String suffixOverrides)
    获取 带 trim 标签的脚本
    static String
    convertWhere(String sqlScript)
    生成 where 标签的脚本
    static String
    mappingJdbcType(org.apache.ibatis.type.JdbcType jdbcType)
     
    static String
    mappingNumericScale(Integer numericScale)
     
    static String
    mappingTypeHandler(Class<? extends org.apache.ibatis.type.TypeHandler<?>> typeHandler)
     
    static String
    safeParam(String param)
    安全入参: #{入参}
    static String
    safeParam(String param, String mapping)
    安全入参: #{入参,mapping}
    static String
    unSafeParam(String param)
    非安全入参: ${入参}

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Constructor Details

    • SqlScriptUtils

      public SqlScriptUtils()

  • Method Details

    • convertIf

      public static String convertIf(String sqlScript, String ifTest, boolean newLine)

      获取 带 if 标签的脚本

      Parameters:
      sqlScript - sql 脚本片段
      Returns:
      if 脚本

    • convertTrim

      public static String convertTrim(String sqlScript, String prefix, String suffix, String prefixOverrides, String suffixOverrides)

      获取 带 trim 标签的脚本

      Parameters:
      sqlScript - sql 脚本片段
      prefix - 以...开头
      suffix - 以...结尾
      prefixOverrides - 干掉最前一个...
      suffixOverrides - 干掉最后一个...
      Returns:
      trim 脚本

    • convertChoose

      public static String convertChoose(String whenTest, String whenSqlScript, String otherwise)

      生成 choose 标签的脚本

      Parameters:
      whenTest - when 内 test 的内容
      otherwise - otherwise 内容
      Returns:
      choose 脚本

    • convertForeach

      public static String convertForeach(String sqlScript, String collection, String index, String item, String separator)

      生成 foreach 标签的脚本

      Parameters:
      sqlScript - foreach 内部的 sql 脚本
      collection - collection
      index - index
      item - item
      separator - separator
      Returns:
      foreach 脚本

    • convertWhere

      public static String convertWhere(String sqlScript)

      生成 where 标签的脚本

      Parameters:
      sqlScript - where 内部的 sql 脚本
      Returns:
      where 脚本

    • convertSet

      public static String convertSet(String sqlScript)

      生成 set 标签的脚本

      Parameters:
      sqlScript - set 内部的 sql 脚本
      Returns:
      set 脚本

    • safeParam

      public static String safeParam(String param)

      安全入参: #{入参}

      Parameters:
      param - 入参
      Returns:
      脚本

    • safeParam

      public static String safeParam(String param, String mapping)

      安全入参: #{入参,mapping}

      Parameters:
      param - 入参
      mapping - 映射
      Returns:
      脚本

    • unSafeParam

      public static String unSafeParam(String param)

      非安全入参: ${入参}

      Parameters:
      param - 入参
      Returns:
      脚本

    • mappingTypeHandler

      public static String mappingTypeHandler(Class<? extends org.apache.ibatis.type.TypeHandler<?>> typeHandler)

    • mappingJdbcType

      public static String mappingJdbcType(org.apache.ibatis.type.JdbcType jdbcType)

    • mappingNumericScale

      public static String mappingNumericScale(Integer numericScale)

    • convertParamMapping

      public static String convertParamMapping(Class<? extends org.apache.ibatis.type.TypeHandler<?>> typeHandler, org.apache.ibatis.type.JdbcType jdbcType, Integer numericScale)