Fork me on GitHub

MyBatis日记(二): MyBatis Say Hello

首先在Eclipse中创建一个maven工程:

在maven工程下的pom.xml文件中添加MyBatis、MySQL、Junit依赖:

 1 <project xmlns="http://maven.apache.org/POM/4.0.0"
 2     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 3     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
 4     <modelVersion>4.0.0</modelVersion>
 5     <groupId>com.Aiden</groupId>
 6     <artifactId>MyBatisByRe</artifactId>
 7     <version>0.0.1-SNAPSHOT</version>
 8     <dependencies>
 9         <dependency>
10             <groupId>org.mybatis</groupId>
11             <artifactId>mybatis</artifactId>
12             <version>3.5.1</version>
13         </dependency>
14         <dependency>
15             <groupId>mysql</groupId>
16             <artifactId>mysql-connector-java</artifactId>
17             <version>8.0.15</version>
18         </dependency>
19         <dependency>
20             <groupId>junit</groupId>
21             <artifactId>junit</artifactId>
22             <version>4.12</version>
23             <scope>test</scope>
24         </dependency>
25     </dependencies>
26 </project>

在MySQL中创建数据库——db_mbre,并建立一个t_student表:

1 CREATE TABLE `t_student` (
2   `id` int(11) NOT NULL AUTO_INCREMENT,
3   `name` varchar(50) DEFAULT NULL,
4   `age` int(10) DEFAULT NULL,
5   PRIMARY KEY (`id`)
6 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

在src文件夹下创建MySQL数据库链接的配置文件——jdbc.properties:

1 jdbc.driverClassName=com.mysql.jdbc.Driver
2 jdbc.url=jdbc:mysql://localhost:3306/db_mbre
3 jdbc.username=root
4 jdbc.password=123456

在src文件夹下创建MyBatis的配置文件——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     <properties resource="jdbc.properties" />
 7     <typeAliases>
 8         <typeAlias alias="Student" type="com.Aiden.domain.Student" />
 9     </typeAliases>
10     <environments default="development">
11         <environment id="development">
12             <transactionManager type="JDBC" />
13             <dataSource type="POOLED">
14                 <property name="driver" value="${jdbc.driverClassName}" />
15                 <property name="url" value="${jdbc.url}" />
16                 <property name="username" value="${jdbc.username}" />
17                 <property name="password" value="${jdbc.password}" />
18             </dataSource>
19         </environment>
20     </environments>
21     <mappers>
22         <mapper resource="com/Aiden/dao/StudentMapper.xml" />
23     </mappers>
24 </configuration>

在src目录下创建com.Aiden.dao、com.Aiden.domain、com.Aiden.service、com.Aiden.util四个包。

在com.Aiden.domain包下创建Student实体文件——Student.java:

 1 package com.Aiden.doamin;
 2 public class Student {
 3     private Integer id;
 4     private String name;
 5     private Integer age;
 6     public Student() {
 7         super();
 8     }
 9     public Student(String name, Integer age) {
10         super();
11         this.name = name;
12         this.age = age;
13     }
14     public Student(Integer id, String name, Integer age) {
15         super();
16         this.id = id;
17         this.name = name;
18         this.age = age;
19     }
20     public Integer getId() {
21         return id;
22     }
23     public void setId(Integer id) {
24         this.id = id;
25     }
26     public String getName() {
27         return name;
28     }
29     public void setName(String name) {
30         this.name = name;
31     }
32     public Integer getAge() {
33         return age;
34     }
35     public void setAge(Integer age) {
36         this.age = age;
37     }
38     @Override
39     public String toString() {
40         return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";
41     }
42     
43 }

在com.Aiden.dao包下创建student的映射接口(StudentMapper.java)以及映射文件(StudentMapper.xml):

1 package com.Aiden.dao;
2 import com.Aiden.doamin.Student;
3 public interface StudentMapper {
4     public int addStudent(Student student);
5 }
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="com.Aiden.dao.StudentMapper">
6     <insert id="addStudent" parameterType="Student">
7         insert into t_student values(null,#{name},#{age})
8     </insert>
9 </mapper>

在com.Aiden.util包下创建SqlSession工具类——SqlSessionFactoryUtil.java:

 1 package com.Aiden.util;
 2 
 3 import java.io.IOException;
 4 import java.io.InputStream;
 5 import org.apache.ibatis.io.Resources;
 6 import org.apache.ibatis.session.SqlSession;
 7 import org.apache.ibatis.session.SqlSessionFactory;
 8 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 9 
10 public class SqlSessionFactoryUtil {
11     public static SqlSessionFactory sqlSessionFactory;
12     public static SqlSessionFactory getSqlSessionFactory() {
13         if(sqlSessionFactory==null) {
14             InputStream inputStream=null;
15             try {
16                 inputStream=Resources.getResourceAsStream("mybatis-config.xml");
17                 sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
18             } catch (IOException e) {
19                 // TODO Auto-generated catch block
20                 e.printStackTrace();
21             }
22         }
23         return sqlSessionFactory;
24     }
25     public static SqlSession openSession() {
26         return getSqlSessionFactory().openSession();
27     }
28 }

在com.Aiden.service包下创建Junit测试类——MybatisDemo01.java:

 1 package com.Aiden.service;
 2 
 3 import org.apache.ibatis.session.SqlSession;
 4 import org.junit.After;
 5 import org.junit.Before;
 6 import org.junit.Test;
 7 
 8 import com.Aiden.dao.StudentMapper;
 9 import com.Aiden.domain.Student;
10 import com.Aiden.util.SqlSessionFactoryUtil;
11 
12 public class MybatisDemo02 {
13     private static SqlSession sqlSession=null;
14     private static StudentMapper studentMapper=null;
15 
16     @Before
17     public void setUp() throws Exception {
18         sqlSession=SqlSessionFactoryUtil.openSession();
19         studentMapper=sqlSession.getMapper(StudentMapper.class); 
20     }
21 
22     @After
23     public void tearDown() throws Exception {
24         sqlSession.close();
25     }
26 
27     @Test
28     public void testAddStudent() {
29         Student student=new Student("苍井空", 26);
30         studentMapper.addStudent(student);
31         sqlSession.commit();
32     }
33 
34 }

运行测试方法testAddStudent。插入数据成功。

posted @ 2019-04-29 10:30  Aiden郭祥跃  阅读(165)  评论(0编辑  收藏  举报
";