怎么使用springboot暴露oracle数据接口的问题(oracle数据,springboot,开发技术)

springboot是什么

springboot一种全新的编程规范，其设计目的是用来简化新Spring应用的初始搭建以及开发过程，SpringBoot也是一个服务于框架的框架，服务范围是简化配置文件。

新建一个Spring Initializr项目

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

原来的：

现在的：

<dependency><groupId>com.oracle</groupId><artifactId>ojdbc6</artifactId><version>11.2.0.1.0</version></dependency>

3.编辑application.yml

spring:datasource:driver-class-name:oracle.jdbc.driver.OracleDriverurl:jdbc:oracle:thin:@192.168.21.200:1521:orclusername:alisapassword:alisa

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

packagecn.alisa.myspboracle.entity;importjava.util.Date;publicclassUserinfos{privateintuserid;privateStringusername;privateDatebirthyear;privatefloatuserhight;publicintgetUserid(){returnuserid;}publicvoidsetUserid(intuserid){this.userid=userid;}publicStringgetUsername(){returnusername;}publicvoidsetUsername(Stringusername){this.username=username;}publicDategetBirthyear(){returnbirthyear;}publicvoidsetBirthyear(Datebirthyear){this.birthyear=birthyear;}publicfloatgetUserhight(){returnuserhight;}publicvoidsetUserhight(floatuserhight){this.userhight=userhight;}}

创建接口类——UserinfosDAO.java

packagecn.alisa.myspboracle.dao;importcn.alisa.myspboracle.entity.Userinfos;importorg.apache.ibatis.annotations.Select;importjava.util.List;publicinterfaceUserinfosDAO{@Select("selectuserid,username,birthyear,userhightfromuserinfos")publicList<Userinfos>findAll();@Select("selectuserid,username,birthyear,userhightfromuserinfoswhereusernamelike'%${name}%'")publicList<Userinfos>findUserSameName(Stringname);}

创建服务类——UserinfosService.java

packagecn.alisa.myspboracle.service;importcn.alisa.myspboracle.dao.UserinfosDAO;importcn.alisa.myspboracle.entity.Userinfos;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importjava.util.List;@ServicepublicclassUserinfosService{@AutowiredprivateUserinfosDAOudao;publicList<Userinfos>searchAll(){returnudao.findAll();}publicList<Userinfos>sameName(Stringname){returnudao.findUserSameName(name);}}

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

packagecn.alisa.myspboracle.ctrl;importcn.alisa.myspboracle.entity.Userinfos;importcn.alisa.myspboracle.service.UserinfosService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RestController;importjava.util.List;@RestControllerpublicclassInitCtrl{@AutowiredprivateUserinfosServiceuserinfosService;@RequestMapping("/all")publicList<Userinfos>init(){returnuserinfosService.searchAll();}@RequestMapping("/same")publicList<Userinfos>same(Stringname){returnuserinfosService.sameName(name);}}

编辑MyspboracleApplication.java类：

packagecn.alisa.myspboracle;importorg.mybatis.spring.annotation.MapperScan;importorg.springframework.boot.SpringApplication;importorg.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication@MapperScan("cn.alisa.myspboracle.dao")publicclassMyspboracleApplication{publicstaticvoidmain(String[]args){SpringApplication.run(MyspboracleApplication.class,args);}}

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