MyBatis Demo

第一步 准备

　　1.1 下载MyBatis：https://github.com/mybatis/mybatis-3/releases ，jar包和源码

　　1.2 下载MySQL驱动：https://dev.mysql.com/downloads/connector/j/ ，jar包

　　1.3 新建 Dynamic Web Project，将上述jar包引入 /WebContent/WEB-INF/lib 中

 

第二步 配置

　　2.1 在 /src 下新建xml文件mybatis.xml，如下所示：　　

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
 3 <configuration>
 4     <environments default="default">
 5         <environment id="default">
 6             <transactionManager type="JDBC"></transactionManager>
 7             <dataSource type="POOLED">
 8                 <property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
 9                 <property name="url"
10                     value="jdbc:mysql://localhost:3306/ssm?useSSL=false&amp;characterEncoding=utf8&amp;serverTimezone=Asia/Shanghai"></property>
11                 <property name="username" value="root"></property>
12                 <property name="password" value="123456"></property>
13             </dataSource>
14         </environment>
15     </environments>
16 </configuration>
mybatis.xml

　　2.2 在 /src 下新建package：org.istong.pojo，并新建类Animal.java，如下：

 1 package org.istong.pojo;
 2 
 3 public class Animal {
 4 
 5     private String name;
 6     private int species;
 7 
 8     public String getName() {
 9         return name;
10     }
11 
12     public void setName(String name) {
13         this.name = name;
14     }
15 
16     public int getSpecies() {
17         return species;
18     }
19 
20     public void setSpecies(int species) {
21         this.species = species;
22     }
23 
24     @Override
25     public String toString() {
26         return "Animal [name=" + name + ", species=" + species + "]";
27     }
28 
29 }
Animal.java

　　2.3 在 /src 下新建package：org.istong.mapper，并新建xml文件Animal.xml，如下：

1 <?xml version="1.0" encoding="UTF-8"?>
2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
3 <mapper namespace="org.istong.animal">
4     <select id="getAll" resultType="org.istong.pojo.Animal">
5         select * from animal
6     </select>
7 </mapper>
Animal.xml

　　2.4 将Animal.xml的映射添加至mybatis，如下：

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
 3 <configuration>
 4     <environments default="default">
 5         <environment id="default">
 6             <transactionManager type="JDBC"></transactionManager>
 7             <dataSource type="POOLED">
 8                 <property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
 9                 <property name="url"
10                     value="jdbc:mysql://localhost:3306/ssm?useSSL=false&amp;characterEncoding=utf8&amp;serverTimezone=Asia/Shanghai"></property>
11                 <property name="username" value="root"></property>
12                 <property name="password" value="123456"></property>
13             </dataSource>
14         </environment>
15     </environments>
16     <mappers>
17         <mapper resource="org/istong/mapper/Animal.xml" />
18     </mappers>
19 </configuration>
mybatis.xml

 

第三步 测试

　　3.1 在 /src 下新建package：org.istong.test，并新建类MyBatisTest.java，如下：

 1 package org.istong.test;
 2 
 3 import java.io.InputStream;
 4 import java.util.List;
 5 
 6 import org.apache.ibatis.io.Resources;
 7 import org.apache.ibatis.session.SqlSession;
 8 import org.apache.ibatis.session.SqlSessionFactory;
 9 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
10 import org.istong.pojo.Animal;
11 
12 public class MyBatisTest {
13 
14     public static void main(String[] args) throws Exception {
15         InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
16         SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
17         SqlSession session = factory.openSession();
18 
19         List<Animal> animals = session.selectList("org.istong.animal.getAll");
20         for (Animal animal : animals) {
21             System.out.println(animal.toString());
22         }
23 
24         session.close();
25     }
26 
27 }
MyBatisTest.java

　　3.2 结果如下所示：

 

posted on 2021-01-01 15:30  庭前花满留晚照  阅读(87)  评论(0)  编辑  收藏  举报

导航