【MyBatis】配置Mybatis项目

一、maven中添加依赖

 1 <dependencies>
 2         <dependency>
 3             <groupId>org.mybatis</groupId>
 4             <artifactId>mybatis</artifactId>
 5             <version>3.5.2</version>
 6         </dependency>
 7         <dependency>
 8             <groupId>mysql</groupId>
 9             <artifactId>mysql-connector-java</artifactId>
10             <version>8.0.11</version>
11         </dependency>
12         <dependency>
13             <groupId>junit</groupId>
14             <artifactId>junit</artifactId>
15             <version>4.12</version>
16             <!--               <scope>test</scope>-->
17             <scope>compile</scope>
18         </dependency>
19     </dependencies>
20     <build>
21         <resources>
22             <resource>
23                 <directory>src/main/java</directory>
24                 <includes>
25                     <include>**/*.properties</include>
26                     <include>**/*.xml</include>
27                 </includes>
28                 <filtering>true</filtering>
29             </resource>
30         </resources>
31     </build>

二、添加配置资源文件

src/mian/resources文件夹下手动添加db.properties和mybatis-config.xml以及添加文件夹mapper。
db.properties中添加内容：

1 //数据库驱动
2 mysql.driver=com.mysql.cj.jdbc.Driver
3 //数据库链接地址
4 mysql.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
5 //数据库用户名
6 mysql.username=root
7 //数据库密码
8 mysql.password=1234

mybatis-config.xml中添加内容：

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 <!DOCTYPE configuration
 3         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 4         "http://mybatis.org/dtd/mybatis-3-config.dtd">
 5 <configuration>
 6     <!-- 环境配置 -->
 7     <!-- 加载类路径下的属性文件 -->
 8     <properties resource="db.properties"/>
 9     <!--类路径别名-->
10     <typeAliases>
11         <typeAlias type="com.baidu.pojo.User" alias="User"/>
12     </typeAliases>
13     <environments default="development">
14         <environment id="development">
15             <transactionManager type="JDBC"/>
16             <!-- 数据库连接相关配置 ,db.properties文件中的内容-->
17             <dataSource type="POOLED">
18                 <property name="driver" value="${mysql.driver}"/>
19                 <property name="url" value="${mysql.url}"/>
20                 <property name="username" value="${mysql.username}"/>
21                 <property name="password" value="${mysql.password}"/>
22             </dataSource>
23         </environment>
24     </environments>
25     <!-- mapping文件路径配置 -->
26     <mappers>
27         <mapper resource="mapper/UserMapper.xml"/>
28     </mappers>
29 
30 </configuration>

mapper文件夹下添加文件UserMapper.xml

UserMapper.xml中添加内容

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper
 3         PUBLIC "-//mybatis.org//DTD mapper 3.0//EN"
 4         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 5 <mapper namespace="User">
 6     <!-- 查询 -->
 7     <select id="findById" parameterType="int" resultType="User">
 8         select * from users where uid = #{id}
 9     </select>
10     <!-- 插入 -->
11     <insert id="add" parameterType="User">
12         insert into users(uname,uage) values(#{uname},#{uage})
13     </insert>
14     <!-- 更改 -->
15     <update id="edit" parameterType="User">
16         update users set uname=#{uname},uage=#{uage} where uid=#{uid}
17     </update>
18     <!-- 删除 -->
19     <delete id="del" parameterType="int">
20         delete from users where uid=#{id}
21     </delete>
22 </mapper>