服务器之家:专注于服务器技术及软件下载分享
分类导航

Mysql|Sql Server|Oracle|Redis|MongoDB|PostgreSQL|Sqlite|DB2|mariadb|Access|数据库技术|

服务器之家 - 数据库 - Oracle - 使用springboot暴露oracle数据接口的问题

使用springboot暴露oracle数据接口的问题

2021-06-20 18:29榴芒姐姐 Oracle

这篇文章主要介绍了使用springboot暴露oracle数据接口的问题,本文通过图文实例相结合给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下

新建一个Spring Initializr项目

使用springboot暴露oracle数据接口的问题

使用springboot暴露oracle数据接口的问题

使用springboot暴露oracle数据接口的问题

使用springboot暴露oracle数据接口的问题

2.把pom.xml文件中的oracle依赖换成自己的oracle版本依赖:

原来的:

使用springboot暴露oracle数据接口的问题

现在的:

?
1
2
3
4
5
<dependency>
           <groupId>com.oracle</groupId>
           <artifactId>ojdbc6</artifactId>
           <version>11.2.0.1.0</version>
       </dependency>

3.编辑application.yml

?
1
2
3
4
5
6
spring:
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@192.168.21.200:1521:orcl
    username: alisa
    password: alisa

4.创建实例类——Userinfos.java:

?
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
package cn.alisa.myspboracle.entity;
 
import java.util.Date;
 
public class Userinfos {
    private int userid;
    private String username;
    private Date birthyear;
    private float userhight;
 
    public int getUserid() {
        return userid;
    }
 
    public void setUserid(int userid) {
        this.userid = userid;
    }
 
    public String getUsername() {
        return username;
    }
 
    public void setUsername(String username) {
        this.username = username;
    }
 
    public Date getBirthyear() {
        return birthyear;
    }
 
    public void setBirthyear(Date birthyear) {
        this.birthyear = birthyear;
    }
 
    public float getUserhight() {
        return userhight;
    }
 
    public void setUserhight(float userhight) {
        this.userhight = userhight;
    }
}

创建接口类——UserinfosDAO.java

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
package cn.alisa.myspboracle.dao;
 
import cn.alisa.myspboracle.entity.Userinfos;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface UserinfosDAO {
    @Select("select userid,username,birthyear,userhight from userinfos")
    public List<Userinfos>findAll();
 
    @Select("select userid,username,birthyear,userhight from userinfos where username like '%${name}%'")
    public List<Userinfos>findUserSameName(String name);
}

创建服务类——UserinfosService.java

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
package cn.alisa.myspboracle.service;
 
import cn.alisa.myspboracle.dao.UserinfosDAO;
import cn.alisa.myspboracle.entity.Userinfos;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@Service
public class UserinfosService {
    @Autowired
    private UserinfosDAO udao;
 
    public List<Userinfos>searchAll(){
        return udao.findAll();
    }
 
    public List<Userinfos>sameName(String name){
        return udao.findUserSameName(name);
    }
}

创建控制层类——InitCtrl.java:

?
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
package cn.alisa.myspboracle.ctrl;
 
import cn.alisa.myspboracle.entity.Userinfos;
import cn.alisa.myspboracle.service.UserinfosService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
 
import java.util.List;
 
@RestController
public class InitCtrl {
    @Autowired
    private UserinfosService userinfosService;
 
    @RequestMapping("/all")
    public List<Userinfos>init(){
        return userinfosService.searchAll();
    }
 
    @RequestMapping("/same")
    public List<Userinfos>same(String name){
        return userinfosService.sameName(name);
    }
}

编辑MyspboracleApplication.java类:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
package cn.alisa.myspboracle;
 
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
 
@SpringBootApplication
@MapperScan("cn.alisa.myspboracle.dao")
public class MyspboracleApplication {
 
    public static void main(String[] args) {
 
        SpringApplication.run(MyspboracleApplication.class, args);
    }
 
}

运行此类(MyspboracleApplication.java),在浏览器中输入"http://localhost:8080/all"或者"http://localhost:8080/same?name=l"即可看到想要的结果。

到此这篇关于使用springboot暴露oracle数据接口的文章就介绍到这了,更多相关springboot oracle数据接口内容请搜索服务器之家以前的文章或继续浏览下面的相关文章希望大家以后多多支持服务器之家!

原文链接:https://blog.csdn.net/alisa_Ge/article/details/116453773

延伸 · 阅读

精彩推荐