MyBatis
1.步骤
- 添加pom文件 坐标 创建实体类 ----->对应数据库
- 编写核心配置文件 ----->连接数据库 ,扫包
- 编写mapper 接口 和映射配置文件----> 两个文件层级需要一一对应
- Mapper接口的名称要和映射配置文件名称一致,并且将Mapper接口和SQL映射文件放置在同一目录下
- 设置SQL映射文件的namespace属性为Mapper接口全限定名
- 映射文件中sql语句的id要和mapper接口的方法名一致,并保持参数类型和返回值类型一致
- 编写测试类
官网地址: https://mybatis.org/mybatis-3/zh/index.html
注意
- 参数占位符:
1)#{}:执行SQL时,会将#{}占位符替换为?,将来自动设置参数值
2)${}:拼SQL。会存在SQL注入问题
3)使用时机:
* 参数传递,都使用#{}
* 如果要对表名、列名进行动态设置,只能使用${}进行sql拼接。 - parameterType:用于设置参数类型,该参数可以省略
2.实操
2.1实体类
package com.itheima.pojo;
public class User {
private Integer id; //防止数据库中有NULL数据
private String username;
private String password;
private String gender;
private String addr;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getAddr() {
return addr;
}
public void setAddr(String addr) {
this.addr = addr;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
", gender=" + gender +
", addr='" + addr + '\'' +
'}';
}
}
2.2mapper接口
package com.itheima.mapper;
import com.itheima.pojo.User;
import java.util.List;
public interface UserMapper {
// @Select("select * from tb_user ")
public List<User> selectAll();
/**
*
* @param id
* @return
*/
User selectById(int id);
/**
*
* @param user
* @return
*/
int insert(User user);
/**
* 修改数据
*/
void update(User user);
void deleteById(int id);
}
2.3核心配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--这里有七个参数 ,看情况自己设置-->
<typeAliases>
<package name="com.itheima"/> <!--取别名 映射文件 参数类型就可以省略不写-->
</typeAliases>
<!-- 默认使用的环境 ID(比如:default="development")。
每个 environment 元素定义的环境 ID(比如:id="development")。
事务管理器的配置(比如:type="JDBC")。
数据源的配置(比如:type="POOLED")。-->
<environments default="development"> <!--可以多环境配置 看default 的值是哪个-->
<environment id="development">
<transactionManager type="JDBC"/> <!--事务管理器 type="JDBC"表示开启事务,
(也就是 type="MANAGED"表示不开启事务 ): -->
<dataSource type="POOLED"> <!--mybatis 内置的数据库连接池-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!--加载配置文件 简称扫包 扫描com.itheima 同级别下所有的 看情况设置-->
<mappers>
<package name="com.itheima"/>
</mappers>
</configuration>
2.4映射配置文件
<?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="com.itheima.mapper.UserMapper">
<!--查询所有-->
<select id="selectAll" resultType="User">
select *
from tb_user;
</select>
<!--根据id查询User selectById()-->
<select id="selectById" resultType="user" parameterType="int">
select *
from tb_user
where id = #{id};
</select>
<!--添加数据int insert(User user);-->
<insert id="insert" parameterType="user">
insert into tb_user
values (null, #{username}, #{password}, #{gender}, #{addr})
</insert>
<!-- 修改数据 void update(User user);-->
<update id="update" parameterType="user">
update tb_user
set username=#{username}
where id = #{id}
</update>
<!-- deleteById(Int id);-->
<delete id="deleteById" parameterType="int">
delete
from tb_user
where id = #{id};
</delete>
</mapper>
2.5测试类
package com.itheima;
import com.itheima.mapper.UserMapper;
import com.itheima.pojo.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class test {
@Test
public void SelectAllTest() throws IOException {
//1 加载核心配置文件,获取 SqlSessionFactory对象,mybatis官网复制即可
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
//4 执行方法,获取结果
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> list = userMapper.selectAll();
//5 处理结果,释放资源
list.forEach(user -> System.out.println(user));
sqlSession.close();
}
@Test
public void selectById() throws IOException {
//1 加载核心配置文件,获取 SqlSessionFactory对象,mybatis官网复制即可
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
//4 执行方法,获取结果
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
System.out.println(userMapper.selectById(2));
sqlSession.close();
}
/**
* 添加数据
*
* @throws IOException
*/
@Test
public void insert() throws IOException {
//1 加载核心配置文件,获取 SqlSessionFactory对象,mybatis官网复制即可
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
//4 执行方法,获取结果
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User();
user.setUsername("虞333姬");
user.setPassword("123456");
user.setGender("女");
user.setAddr("不同时空");
int insert = userMapper.insert(user);
sqlSession.commit();
sqlSession.close();
}
/**
* @throws IOException
*/
@Test
public void update() throws IOException {
//1 加载核心配置文件,获取 SqlSessionFactory对象,mybatis官网复制即可
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
//4 执行方法,获取结果
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User();
user.setId(7);
user.setUsername("虞hkhk姬");
userMapper.update(user);
sqlSession.commit();
sqlSession.close();
}
@Test
public void delete() throws IOException {
//1 加载核心配置文件,获取 SqlSessionFactory对象,mybatis官网复制即可
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
//4 执行方法,获取结果
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
userMapper.deleteById(8);
sqlSession.commit();
sqlSession.close();
}
}