MyBatis Basics-Getting Started program 3

Environment and other related references first article
http://blog.csdn.net/gao36951/article/details/50423750 Modify Member

configuring modifications in the mapping file statement

Program Writing

The data before executing the procedure is as follows

Post-implementation data are as follows
Query individual member information

configuring queries in a mapping file individual member statement

Program Writing

Query results are as follows
Fuzzy Query multiple member information

Configure a fuzzy query in the mapping file to return multiple members statement

Program Writing

Query results are as follows
Attention

#{} represents an ID in a placeholder #{id,jdbctype=varchar} that accepts input parameters, the parameter
name is ID, and if the input parameter is a simple type, then the parameter name in #{} can be arbitrary, can be value or other name
#{} Receives the value of the Pojo object, reads the properties in the object by OGNL, and gets the property value of the object by using the attribute. Property. Attribute
${} is a concatenation of our SQL strings, and the accepted parameters are not decorated in SQL
using ${} Stitching SQL may cause SQL injection
${value} to accept input parameters, and if the input parameter is a simple type, only value
${} can receive Pojo object values in ${}, and the properties in the object are read by OGNL. Gets the property value of the object through the property. property.