模糊查询,注意他的使用方法,其他基本一致
具体的xml配置文件如下
01 | <? xml version = "1.0" encoding = "UTF-8" ?> |
02 | <!-- 该文件代表的是user类和user表的映射关系,关于user表的sql语句等等写在这里 --> |
03 | <!DOCTYPE mapper |
04 | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
06 | < mapper namespace = "dao.UserDao" > |
07 | <!-- #{}代表占位符?,表示mybatis框架会接收输入的参数并赋值到sql语句当中 |
08 | 关于简单类型(int,String,date。long)可以使用value来代表参数名 |
09 |
10 | --> |
11 | < select id = "findUserById" parameterType = "java.lang.Integer" resultType = "user" > |
12 | select * from users where user_id=#{id} |
13 | </ select > |
14 |
15 | <!-- ${}代表字符串拼接 --> |
16 | < select id = "findUserByName" parameterType = "java.lang.String" resultType = "model.User" > |
17 | select * from users where uname like '%${value}%' |
18 | </ select > |
19 |
20 | <!-- 插入的时候可以使用主键回填的策略,LAST_INSERT_ID() --> |
21 | < insert id = "addUser" parameterType = "model.User" > |
22 | < selectKey order = "AFTER" keyProperty = "id" resultType = "int" > |
23 | select LAST_INSERT_ID() |
24 | </ selectKey > |
25 | // |
26 | insert into users values (null,#{uname},null,#{age},null,null) |
27 | </ insert > |
28 |
29 |
30 | < update id = "updateUser" parameterType = "model.User" > |
31 | update users set uname=#{uname},age=#{age} where id=#{id} |
32 | </ update > |
33 |
34 | < delete id = "deleteUser" parameterType = "int" > |
35 | delete from users where id=#{value} |
36 | </ delete > |
37 | </ mapper > |
0则评论给“[大数据]mybatis 框架讲解(二) 增删改查配置”