接著上次的實現, 添加 mybatis 查詢 orcale 數據庫
第一步: 新建幾個必須的包, 結果如下
第二步: 在service包下新建personservice.java 根據名字查person方法接口
|
1
2
3
4
5
|
package com.example.first.service;import com.example.first.entity.person;public interface personservice { person querypersonbyname(string name);} |
第三步: 在serviceimpl包下新建personserviceimpl.java 實現personservice.java接口
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
package com.example.first.serviceimpl;import com.example.first.persondao.personmapperdao;import com.example.first.entity.person;import com.example.first.service.personservice;import org.springframework.beans.factory.annotation.autowired;import org.springframework.stereotype.service;import org.springframework.transaction.annotation.transactional;@service@transactionalpublic class personserviceimpl implements personservice { @autowired personmapperdao personmapperdao; @override public person querypersonbyname(string name) { person person = personmapperdao.findbyname(name); return person; }} |
第四步: persondao下新建personmapperdao.java 有一個查詢person的方法
|
1
2
3
4
5
6
7
|
package com.example.first.persondao;import com.example.first.entity.person;import org.apache.ibatis.annotations.mapper;@mapperpublic interface personmapperdao { person findbyname(string name);} |
第五步: 在resource下新建personmapper.xml
|
1
2
3
4
5
6
7
8
9
10
11
|
<?xml version="1.0" encoding="utf-8" ?><!doctype mapper public "-//mybatis.org//dtd mapper 3.0//en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.example.first.persondao.personmapperdao"> <resultmap id="findperson" type="com.example.first.entity.person"> <result property="name" column="name"/> <result property="age" column="age"/> </resultmap> <select id="findbyname" resultmap="findperson"> select name,age from person where name = #{name} </select></mapper> |
第六步: 在application.properties 中添加數據源 , mapper文件路徑 和實體路徑
|
1
2
3
4
5
6
7
8
9
10
11
|
spring.jpa.database=oraclespring.datasource.driver-class-name=oracle.jdbc.driver.oracledriverspring.datasource.url=jdbc:oracle:thin:@//192.168.3.177:1521/orclspring.datasource.username=liguang_devspring.datasource.password=123456spring.jpa.hibernate.ddl-auto=updatemybatis.mapperlocations=classpath:/mapper/*.xmlmybatis.typealiasespackag= com.example.first.entityspring.thymeleaf.prefix=classpath:/templates/spring.thymeleaf.suffix=.htmlspring.thymeleaf.mode = html5 |
第七步: 在pom文件中添加依賴
|
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
|
<?xml version="1.0" encoding="utf-8"?><project xmlns="http://maven.apache.org/pom/4.0.0" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://maven.apache.org/pom/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelversion>4.0.0</modelversion> <groupid>com.example.first</groupid> <artifactid>springboot</artifactid> <version>0.0.1-snapshot</version> <packaging>jar</packaging> <name>springboot</name> <description>demo project for spring boot</description> <parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version>1.5.6.release</version> <relativepath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceencoding>utf-8</project.build.sourceencoding> <project.reporting.outputencoding>utf-8</project.reporting.outputencoding> <java.version>1.8</java.version> </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-thymeleaf</artifactid> </dependency> <!--orcale數據庫依賴--> <dependency> <groupid>oracle</groupid> <artifactid>ojdbc7</artifactid> <version>1.0.0.1</version> </dependency> <!--mybatis依賴--> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version>1.1.1</version> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-jdbc</artifactid> </dependency> </dependencies> <build> <plugins> <plugin> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> </plugin> </plugins> </build></project> |
第八步:瀏覽器輸入http://localhost:8080/person/show?name=zhang
總結
以上所述是小編給大家介紹的spring boot + mybatis + orcale實現步驟實例代碼講解，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對服務器之家網站的支持！
原文鏈接：http://www.cnblogs.com/gczmn/archive/2017/12/15/8043105.html
