总体而言是如此
1、首先创建数据库表。
2、根据数据库表在pojo创建相对应的实体类
3、编写mapper接口和mapper.mxl文件
①、mapper接口
②、mapper.xml的模板
<?xml version="1.0" encoding="UTF8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="对应mapper接口的目录用."> </mapper>
4、编写mybatis-config.xml模板
<?xml version="1.0" encoding="UTF8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <!--configuration核心配置文件--> <configuration> <properties resource="db.properties"/> <settings> <setting name="logImpl" value="LOG4J"/> </settings> <!--environment是开发环境,default是默认开发环境--> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <!--每一个Mapper.xml都与需要在Mybatis核心配置文件中注册 resource中写它的全路径--> <mappers> <mapper resource="对应mapper.xml的路径用/"/> </mappers> </configuration>
5、对应4中的db.properties资源文件中的内容
driver = com.mysql.cj.jdbc.Driver url = jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT username = root password = root