《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》,点击传送门,即可获取!
@Test
public void testInsertUser() {
UserDao userDao = new UserDaoImpl();
User user = new User();
user.setUsername(“张飞1111”);
user.setSex(“2”);
user.setBirthday(new Date());
user.setAddress(“深圳黑马”);
userDao.insertUser(user);
}
通过动态代理的方式有实现类但是不需要自己手动去写
1、创建UserMapper接口
package com.itzheng.mybatis.mapper;
import java.util.List;
import com.itzheng.mybatis.pojo.User;
public interface UserMapper {
// 根据用户ID查询用户信息
/*
- 用户信息持化接口
*/
User getUserByid(Integer id);
// 根据用户名查找用户列表
List getUserByUserName(String userName);
// 添加用户
void insertUser(User user);
}
2、创建UserMapper.xml
<select id=“getUserByid” parameterType=“int”
resultType=“com.itzheng.mybatis.pojo.User”>
SELECT * FROM USER WHERE id = #{id1}
<select id=“getUserByUserName” parameterType=“string”
resultType=“com.itzheng.mybatis.pojo.User”>
SELECT id,username,birthday,sex,address FROM user
WHERE username LIKE
‘%${value}%’
<insert id=“insertUser”
parameterType=“com.itzheng.mybatis.pojo.User” useGeneratedKeys=“true”
keyProperty=“id”>
INSERT INTO USER
(username
,
birthday
,
sex
,
address
)
VALUES (#{username},
#{birthday},
#{sex},
#{address});
3、修改SqlMapConfig.xml当中添加映射文件
4、创建单元测试
(1)根据ID查询用户
@Test
public void testGetUserById() {
SqlSession openSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
// 获取接口的代理实现类
UserMapper userMapper = openSession.getMapper(UserMapper.class);
User user = userMapper.getUserByid(30);
System.out.println(user);
openSession.close();
}
(2)根据name查询用户
@Test
public void testGetUserByUserName() {
SqlSession openSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
// 获取接口的代理实现类
UserMapper userMapper = openSession.getMapper(UserMapper.class);
List list = userMapper.getUserByUserName(“张”);
for (User user : list) {
System.out.println(user);
}
openSession.close();
}
(3)插入用户
@Test
public void testInsertUser() {
SqlSession openSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession(true);
// 获取接口的代理实现类
UserMapper userMapper = openSession.getMapper(UserMapper.class);
User user = new User();
user.setUsername(“张飞1111”);
user.setSex(“2”);
user.setBirthday(new Date());
user.setAddress(“深圳黑马”);
userMapper.insertUser(user);
openSession.close();
}
、
1、创建jdbc.properties
2、修改SqlMapConfig.xml,在SqlMapConfig.xml当中引入jdbc.properties
别名的作用将复杂的数据用其他的名称简单的代替
1、mybatis支持的别名:
2、自定义别名:方式一,配置对应的类的别名
(1)修改SqlMapConfig.xml
(2)修改UserMapper.xml,在UserMapper.xml当中引用别名:别名不区分大小写
<select id=“getUserByUserName” parameterType=“string”
resultType=“user”>
SELECT id,username,birthday,sex,address FROM user
WHERE username LIKE
‘%${value}%’
3、自定义别名:方式二,配置包别名,默认别名就是类名称不区分大小写
(1)修改SqlMapConfig.xml:别名包扫描器:别名是类的全称,不区大小写
(2)UserMapper.xml当中直接使用类名就OK
Mapper配置的几种方式:
1、将UserMapper.xml复制到mapper文件下
2、修改SqlMapConfig.xml:方式一:类配置
读者福利
由于篇幅过长,就不展示所有面试题了,感兴趣的小伙伴
更多笔记分享
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》,点击传送门,即可获取!
g-blog.csdnimg.cn/20210131164854901.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzU3MDM0,size_16,color_FFFFFF,t_70)
1、将UserMapper.xml复制到mapper文件下
2、修改SqlMapConfig.xml:方式一:类配置
读者福利
由于篇幅过长,就不展示所有面试题了,感兴趣的小伙伴
[外链图片转存中…(img-Jk6ukU7G-1714708339950)]
[外链图片转存中…(img-yeD2B1cx-1714708339950)]
[外链图片转存中…(img-atxohu78-1714708339950)]
更多笔记分享
[外链图片转存中…(img-DIZak5nL-1714708339951)]
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》,点击传送门,即可获取!