mybatis

• Mapper XML Files
• select
• <select>
• id
• parameterType
• parameterMap
• resultType
• resultMap
• flushCache
• useCache
• timeout
• fetchSize
• statementType
• resultSetType
• databaseId
• resultOrdered
• resultSets
• affectData
• insert, update and delete
• <insert>
• id
• parameterType
• parameterMap
• flushCache
• timeout
• statementType
• useGeneratedKeys
• keyProperty
• keyColumn
• databaseId
• <update>
• id
• parameterType
• parameterMap
• flushCache
• timeout
• statementType
• useGeneratedKeys
• keyProperty
• keyColumn
• databaseId
• <delete>
• id
• parameterType
• parameterMap
• flushCache
• timeout
• statementType
• databaseId
• <selectKey>
• keyProperty
• keyColumn
• resultType
• order
• statementType
• sql
• <sql>
• <include>
• <include/>
• Parameters
• #{}
• ${}
• Result Maps
• <resultMap>
• id
• type
• autoMapping
• <id>
• property
• column
• javaType
• jdbcType
• typeHandler
• <result>
• property
• column
• javaType
• jdbcType
• typeHandler
• Supported JDBC Types
• BIT
• FLOAT
• CHAR
• TIMESTAMP
• OTHER
• UNDEFINED
• TINYINT
• REAL
• VARCHAR
• BINARY
• BLOB
• NVARCHAR
• SMALLINT
• DOUBLE
• LONGVARCHAR
• VARBINARY
• CLOB
• NCHAR
• INTEGER
• NUMERIC
• DATE
• LONGVARBINARY
• BOOLEAN
• NCLOB
• BIGINT
• DECIMAL
• TIME
• NULL
• CURSOR
• ARRAY
• <constructor>
• <idArg>
• <arg >
• column
• javaType
• jdbcType
• typeHandler
• select
• resultMap
• name
• <association>
• property
• javaType
• jdbcType
• typeHandler
• <association/> - Nested Select for Association
• column
• select
• fetchType
• <association/> - Nested Results for Association
• resultMap
• columnPrefix
• notNullColumn
• autoMapping
• <association> - Multiple ResultSets for Association
• column
• foreignColumn
• resultSet
• <collection>
• <collection/> - Nested Select for Collection
• <collection/> - Nested Results for Collection
• <collection> - Multiple ResultSets for Collection
• <discriminator>
• Auto-mapping
• cache
• <cache/>
• <cache-ref/>
• Dynamic SQL
• <if>
• <choose>
• <when>
• <otherwise>
• <trim>
• <where>
• <set>
• <foreach>
• <script>
• <bind>

 

 

 

 

 

 

 

 

test

 ' " " ' (o)
" ' ' " (x)

 

 

 

 

 

 

 

 

 

 

Alias	Mapped Type
_byte	byte
_char (since 3.5.10)	char
_character (since 3.5.10)	char
_long	long
_short	short
_int	int
_integer	int
_double	double
_float	float
_boolean	boolean
string	String
byte	Byte
char (since 3.5.10)	Character
character (since 3.5.10)	Character
long	Long
short	Short
int	Integer
integer	Integer
double	Double
float	Float
boolean	Boolean
date	Date
decimal	BigDecimal
bigdecimal	BigDecimal
biginteger	BigInteger
object	Object
date[]	Date[]
decimal[]	BigDecimal[]
bigdecimal[]	BigDecimal[]
biginteger[]	BigInteger[]
object[]	Object[]
map	Map
hashmap	HashMap
list	List
arraylist	ArrayList
collection	Collection
iterator	Iterator

Dynamic SQL, https://mybatis.org/mybatis-3/dynamic-sql.html
Mapper XML Files, https://mybatis.org/mybatis-3/sqlmap-xml.html
Type, https://mybatis.org/mybatis-3/configuration.html