参考：https://blog.csdn.net/Javascript_tsj/article/details/126324531
提前说明：本人电脑已经安装好mybatis插件的情况
第一步：添加maven依赖（mybatis、数据库驱动）
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<!-- MySQL驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.3</version>
</dependency>
2：创建一个数据库链接配置类，和数据库建立起链接
<?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>
<!--设置连接数据库的环境-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/test? serverTimezone=UTC"/>
<property name="username" value="root"/>
<property name="password" value="xxxxxx"/>
</dataSource>
</environment>
</environments>
<!--引入映射文件-->
<mappers>
<mapper resource="mappers/UserMapper.xml"/>
</mappers>
</configuration>
3：数据库链接好后，新增一个mapper.xml文件，里面主要填写需要执行的sql语句信息，注意namespace是接口调用此sql的接口的路径
<?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="Mapper.UserMapper">
<!--int insertUser();-->
<insert id="insertUser"> insert into user values(222,'张三','123',23,'女','11111@qq.com') </insert>
</mapper>
4：最后，我们写一个类去动态代理调用一下接口这个接口
public class AddUser {
public void test() throws IOException{
//读取核心配置文件
InputStream is = Resources.getResourceAsStream("mybatis_config.xml");
//创建SqlSessionFactoryBuilder对象
SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
//生产SqlSession对象
SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
//创建SqlSession对象
SqlSession sqlSession = sqlSessionFactory.openSession(true);
//通过代理模式创建UserMapper接口的代理实现类对象
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int result = userMapper.insertUser();
System.out.println(result);
}
}
此时候，控制层直接去创建这个类然后调用这个方法即可
结合上一篇帖子，一个简单的SSM框架基础便结束