springboot整合mybatis對數據庫進行訪問，本實例采用注解的方式，如下：
pom.xml文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
<parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version>2.0.5.release</version> </parent> <properties> <project.build.sourceencoding>utf-8</project.build.sourceencoding> <maven.compiler.source>1.8</maven.compiler.source> <maven.compiler.target>1.8</maven.compiler.target> </properties> <dependencies> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-test</artifactid> <scope>test</scope> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <version>5.1.45</version> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-jdbc</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-configuration-processor</artifactid> <optional>true</optional> </dependency> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version>1.3.1</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> </plugin> </plugins> </build></project> |
domain類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
package com.rookie.bigdata.domain; /** * @author * @date 2018/10/9 */public class student { private long stuno; private string name; private integer age; public student() { } public student(string name, integer age) { this.name = name; this.age = age; } public student(long stuno, string name, integer age) { this.stuno = stuno; this.name = name; this.age = age; } public long getstuno() { return stuno; } public void setstuno(long stuno) { this.stuno = stuno; } public string getname() { return name; } public void setname(string name) { this.name = name; } public integer getage() { return age; } public void setage(integer age) { this.age = age; } @override public boolean equals(object o) { if (this == o) return true; if (o == null || getclass() != o.getclass()) return false; student student = (student) o; if (stuno != null ? !stuno.equals(student.stuno) : student.stuno != null) return false; if (name != null ? !name.equals(student.name) : student.name != null) return false; return age != null ? age.equals(student.age) : student.age == null; } @override public int hashcode() { int result = stuno != null ? stuno.hashcode() : 0; result = 31 * result + (name != null ? name.hashcode() : 0); result = 31 * result + (age != null ? age.hashcode() : 0); return result; } @override public string tostring() { return "student{" + "stuno=" + stuno + ", name='" + name + '\'' + ", age=" + age + '}'; }} |
studentmapper類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
package com.rookie.bigdata.mapper;import com.rookie.bigdata.domain.student;import org.apache.ibatis.annotations.*;import java.util.list;import java.util.map;/** * @author * @date 2018/10/9 */@mapperpublic interface studentmapper { @select("select * from student where name = #{name}") student findbyname(@param("name") string name); @results({ @result(property = "name", column = "name"), @result(property = "age", column = "age") }) @select("select name, age from student") list<student> findall(); @insert("insert into student(name, age) values(#{name}, #{age})") int insert(@param("name") string name, @param("age") integer age); @update("update student set age=#{age} where name=#{name}") void update(student student); @delete("delete from student where id =#{id}") void delete(long id); @insert("insert into student(name, age) values(#{name}, #{age})") int insertbyuser(student student); @insert("insert into student(name, age) values(#{name,jdbctype=varchar}, #{age,jdbctype=integer})") int insertbymap(map<string, object> map); } |
測試類如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
package com.rookie.bigdata.mapper;import org.junit.test;import org.junit.runner.runwith;import org.springframework.beans.factory.annotation.autowired;import org.springframework.boot.test.context.springboottest;import org.springframework.test.context.junit4.springrunner;import org.springframework.transaction.annotation.transactional;import static org.junit.assert.*;/** * @author * @date 2018/10/10 */@runwith(springrunner.class)@springboottestpublic class studentmappertest { @autowired private studentmapper studentmapper; @test public void findbyname() throws exception { system.out.println(studentmapper.findbyname("zhangsan")); } @test public void findall() throws exception { system.out.println(studentmapper.findbyname("zhangsan")); } @test public void insert() throws exception { system.out.println( studentmapper.insert("zhangsan", 20)); } @test public void update() throws exception { } @test public void delete() throws exception { } @test public void insertbyuser() throws exception { } @test public void insertbymap() throws exception { }} |
大家可以自己編寫測試類進行測試一下，后續會更新xml的配置方式和mybatis采用多數據源進行配置的方式
