MyBatis的基本使用方式，防止平时要写个小工具用到mybatis时想不起来

1、引入依赖

<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency>

2、编写MyBatis工具类

public class MybatisUtils { private static SqlSessionFactory sqlSessionFactory; static { try { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { e.printStackTrace(); } } public static SqlSession getSession() { return sqlSessionFactory.openSession(); } }

3、编写MyBatis配置文件

注意点：

最重要的一点：不懂就查官方文档<properties>、<typeAliases>、<environments>等标签是有顺序的 <?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> <!-- 通过外部properties文件配置数据源--> <properties resource="druid.properties" /> <!-- 起别名--> <typeAliases> <typeAlias type="bean.DrbRqTestDmzgz" alias="DrbRqTestDmzgz" /> </typeAliases> <!-- 可配置多个环境 default属性指定用那个环境--> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driverClassName}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <!-- 挂载具体的mapper --> <mappers> <mapper resource="mappers/map.xml"/> </mappers> </configuration>

4、编写Bean、接口和xml

编写Bean

编写一个和数据库表对应的bean（当然有可能用不到）

编写接口

public interface DrbRqTestDmzgzMapper { List<DrbRqTestDmzgz> selectDmzgz(); int insertDmzgz(DrbRqTestDmzgz drbRqTestDmzgz); }

编写xml

注意点：

namespace指向所写的接口SQL的id是接口中的方法名称 <?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.DrbRqTestDmzgzMapper"> <select id="selectDmzgz" resultType="DrbRqTestDmzgz"> select * from DRB_RQTEST_DMZGZ </select> <insert id="insertDmzgz" parameterType="DrbRqTestDmzgz"> insert into DRB_RQTEST_DMZGZ (name, dmxz, dmz, sjfzl, zgzfssdxl, rksj, clsjxl, lx) values (#{name}, #{dmxz}, #{dmz}, #{sjfzl}, #{zgzfssdxl}, #{rksj}, #{clsjxl}, #{lx}) </insert> </mapper>

5、使用MyBatisUtil工具类操作SQL查询

// 获取会话 SqlSession sqlSession = MybatisUtils.getSession(); // 获取接口 DrbRqTestDmzgzMapper mapper = sqlSession.getMapper(DrbRqTestDmzgzMapper.class); // 执行查询 List<DrbRqTestDmzgz> list = mapper.selectDmzgz(); // 如果是增、删、改，则需要提交事务 // sqlSession.commit() // 关闭会话 sqlSession.close();