0. Data Preparation /*Table structure for table `user` */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL auto_increment, `username` varchar(32) NOT NULL, `birthday` datetime default NULL, `sex` varchar(10) default NULL, `address` varchar(256) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table Read more
1. If <select id="findActiveBlogWithTitleLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = ‘ACTIVE’ <if test="title != null"> AND title like #{title} </if> </select> 2. Choose, When, Otherwise <select id="findActiveBlogLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = ‘ACTIVE’ <choose> # choose only one case among many options <when test="title != Read more
Six Attributes collection: There are three formats: list, array, and map, according to the type of parameter passed. item: the parameter name of the set of objects in the tag. separator: the separator at the end of each sub-loop, usually “,”. open: start character, often “(“. close: end character, often Read more
When using mybatis as a persistence layer, insert, update, delete, sql statements do not return the primary key of the record being operated on by default, but rather the number of records being operated on. When we want to get the primary key automatically generated for the inserted data, we Read more