提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
文章目录
前言
mybatis学习记录
03. MyBatis 参数获取
提示:以下是本篇文章正文内容,下面案例可供参考
一、SqlSessionUtils封装
可以将SqlSessionUtils进行封装,后面只需要调用即可。
public class SqlSessionUtils {
public static SqlSession getSqlSession() {
SqlSession sqlSession = null;
try {
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
sqlSession = sqlSessionFactory.openSession(true);
} catch (IOException e) {
e.printStackTrace();
}
return sqlSession;
}
}
二、MyBatis获取参数值的两种方式:${}和#{}
${}的本质就是字符串拼接,若为字符串类型或日期类型的字段进行赋值时,需要手动加单引号;#{}的本质就是占位符赋值,可自动添加引号。
1.mapper接口方法参数为单个字面量类型
测试方法:
@Test
public void testGetUserByUsername(){
SqlSession sqlSession = SqlSessionUtils.getSqlSession();
ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
User user = mapper.getUserByUsername("邓一");
System.out.println(user);
}
mapper接口:
public interface ParameterMapper {
User getUserByUsername(String username);
}
映射文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="study.mapper.ParameterMapper">
<!-- User getUserByUsername(String username);-->
<select id="getUserByUsername" resultType="User">
select * from t_user where username = #{username}
</select>
</mapper>
2.mapper接口方法参数为多个
a>此时MyBatis将这些参数放在一个map集合中,以两种方式存储:以arg0,arg1…为键,以参数为值;或以param1,param2…为键,以参数为值
测试方法:
@Test
public void testCheckLogin(){
SqlSession sqlSession = SqlSessionUtils.getSqlSession();
ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
User user = mapper.checkLogin("邓一","123456");
System.out.println(user);
}
mapper接口:
public interface ParameterMapper {
User checkLogin(String username,String password);
}
映射文件:
<!-- User checkLogin(String username,String password);-->
<select id="checkLogin" resultType="User">
select * from t_user where username = #{param1} and password = #{param2}
</select>
b>手动将这些参数放在一个map中通过${}和#{}以键的方式访问值即可
测试方法:
@Test
public void testCheckLoginByMap(){
SqlSession sqlSession = SqlSessionUtils.getSqlSession();
ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
Map<String,Object> map = new HashMap<>();
map.put("username","邓一");
map.put("password","123456");
User user = mapper.checkLoginByMap(map);
System.out.println(user);
}
mapper接口:
public interface ParameterMapper {
User checkLoginByMap(Map<String,Object> map);
}
映射文件:
<!-- User checkLoginByMap(Map<String,Object> map);-->
<select id="checkLoginByMap" resultType="User">
select * from t_user where username = #{username} and password = #{password}
</select>
常 用 类 型 一 \color{red}{常用类型一} 常用类型一
3.mapper接口方法参数为实体类类型通过${}和#{}以属性的方式访问值
测试方法:
@Test
public void testInsertUser(){
SqlSession sqlSession = SqlSessionUtils.getSqlSession();
ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
mapper.insertUser(new User(null,"admin","147258",32,"男","17356981245"));
}
mapper接口:
public interface ParameterMapper {
int insertUser(User user);
}
映射文件:
<!-- int insertUser(User user);-->
<insert id="insertUser">
insert into t_user values(null,#{username},#{password},#{age},#{sex},#{phone})
</insert>
常 用 类 型 二 \color{red}{常用类型二} 常用类型二
4.使用@param注解命名参数(类比2,a>arg0…更改为以@param的值为键)
测试方法:
@Test
public void testCheckLoginByParam(){
SqlSession sqlSession = SqlSessionUtils.getSqlSession();
ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
User user = mapper.checkLoginByParam("邓一","123456");
System.out.println(user);
}
mapper接口:
public interface ParameterMapper {
User checkLoginByParam(@Param("username") String username, @Param("password") String password);
}
映射文件:
<!--@param访问:User checkLoginByParam(@Param("username") String username, @Param("password") String password);-->
<select id="checkLoginByParam" resultType="User">
select * from t_user where username = #{username} and password = #{password}
</select>
总结
MyBatis获取参数值的两种方式:${}和#{}
${}的本质就是字符串拼接,若为字符串类型或日期类型的字段进行赋值时,需要手动加单引号;#{}的本质就是占位符赋值,可自动添加引号。1.mapper接口方法参数为单个字面量类型
2.mapper接口方法参数为多个
a>此时MyBatis将这些参数放在一个map集合中,以两种方式存储以arg0,arg1…为键,以参数为值;或以param1,param2…为键,以参数为值
b>手动将这些参数放在一个map中通过${}和#{}以键的方式访问值即可3.mapper接口方法参数为实体类类型通过${}和#{}以属性的方式访问值
4.使用@param注解命名参数(类比2,a>arg0…更改为以@param的值为键)