MyBatis框架思维导图笔记总结

CH01_MyBatis框架概述//映射器接口：定义对持久化对象的增删改查操作的抽象方法public interface UserMapper { List findAllUsers();}

select * from user

CH02_MyBatis的CRUD操作

select id, user_name userName, password from user

insert into user(id,username,password) values(#{id},#{userName},#{password})

insert into user(id,username,password) values(#{id},#{userName},#{password}) select last_insert_id()

select * from user where id = #{id}

select * from user where user_name like "%"#{name}"%"

update user set user_name=#{userName}, password=#{password} where id=#{id}

delete from user where id=#{id}

CH03_MyBatis关联映射一对一

select * from shopping_cart where user_id = #{user_id}

insert into shopping_cart(cart_id,price,user_id) values(#{id},#{price},#{})

select id, user_name userName, password from user

insert into user(id,username,password) values(#{id},#{userName},#{password})

insert into user(id,username,password) values(#{id},#{userName},#{password}) select last_insert_id()

select * from user where id = #{id}

select * from user where user_name like "%"#{name}"%"

update user set user_name=#{userName}, password=#{password} where id=#{id}

delete from user where id=#{id}

javaType="ngCart" resultMap="p">

select ,_name,rd,_id, from user u left outer join shopping_cart s on = _id where = #{id}

select="oppingCartByUserId" column="{user_id=id}"> select * from user where id=#{id}

select="oppingCartByUserId" column="{user_id=id}" fetchType="lazy"> select * from user where user_name=#{name}

一对多

select order_id,price

from orders

where user_id = #{uId}

select id, user_name userName, password from user

insert into user(id,username,password) values(#{id},#{userName},#{password})

insert into user(id,username,password) values(#{id},#{userName},#{password}) select last_insert_id()

select * from user where id = #{id}

select * from user where user_name like "%"#{name}"%"

update user set user_name=#{userName}, password=#{password} where id=#{id}

delete from user where id=#{id}

映射集合类型的属性，ofType指定集合中元素的类型

ofType="" resultMap="ap">

select ,_name,rd,_id, from user u left outer join orders o on _id = where =#{n}

ofType="" select="ders" column="{uId=id}" fetchType="lazy">

select * from user u where =#{n}

多对多继承映射

CH04_动态ckage ;import ;import ;import ;import ;//映射器接口：定义对持久化对象的增删改查操作的抽象方法public interface UserMapper { List findAllUsers();

//方法中有多个参数，需要使用@Param注解指定SQL参数名称 User findUserByNameAndPassword(@Param("username")String name, @Param("psw")String password);

//方法参数是Map类型，map对象中的key的值就是SQL参数名称 User findUserByMap(Map map);

List findUserByNameOrAge(@Param("name")String name,

@Param("age")int age);

int updateUserById(User u);

int insertUser(User u);

List findUserByIds(Integer[] ids);

//批量插入 int insertUsers(List u);

int updateUserByMap(Map map);}

select * from user

select * from user where user_name =#{username} and password=#{psw}

select * from user where user_name =#{username} and password=#{psw}

select * from user where 1=1 and user_name=#{name} and age=#{age}

select * from user and user_name=#{name} and age=#{age}

update user set user_name=#{userName}, password=#{password}, age=#{age}, id = #{id} where id = #{id}

update user

user_name=#{userName}, password=#{password}, age=#{age}, where id = #{id}

update user

user_name=#{userName}, password=#{password}, age=#{age},

where id = #{id}

insert into user(user_name,password ,age ) values(#{userName},#{password} ,#{age} )

select * from user and user_name=#{name} and age=#{age} and age > 18

select * from user and user_name=#{name} and age=#{age} and age > 18

select * from user where id in

open="(" close=")" separator=","> #{n}

insert into user(user_name,password,age) values

(#{me},#{rd},#{})

update user set ${k} = #{v} where id = #{id}

简答对MyBatis的理解

传参方式

#{}与${}的异同