作者:小唐永远支持小志 | 来源:互联网 | 2023-10-12 23:06
这篇文章主要介绍了使用springboot暴露oracle数据接口的问题,本文通过图文实例相结合给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,
新建一个Spring Initializr项目
2.把pom.xml文件中的oracle依赖换成自己的oracle版本依赖:
原来的:
现在的:
com.oracle
ojdbc6
11.2.0.1.0
3.编辑application.yml
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:
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
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 ListfindAll();
@Select("select userid,username,birthyear,userhight from userinfos where username like '%${name}%'")
public ListfindUserSameName(String name);
}
创建服务类——UserinfosService.java
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 ListsearchAll(){
return udao.findAll();
}
public ListsameName(String name){
return udao.findUserSameName(name);
}
}
创建控制层类——InitCtrl.java:
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 Listinit(){
return userinfosService.searchAll();
}
@RequestMapping("/same")
public Listsame(String name){
return userinfosService.sameName(name);
}
}
编辑MyspboracleApplication.java类:
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"即可看到想要的结果。