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.