SpringBoot版本:2.1.1
目录
准备工作
今天偷闲来更新一下,哈哈哈~
1、建表
先来简单建个表,sql贴下面了。
create table DEPT
(
deptno NUMBER(2) not null,
dname VARCHAR2(50),
loc VARCHAR2(50)
)
-- Add comments to the columns
comment on column DEPT.deptno
is '部门id';
comment on column DEPT.dname
is '部门名称';
comment on column DEPT.loc
is '地区';
insert into dept (DEPTNO, DNAME, LOC)
values (10, 'ACCOUNTING', 'NEW YORK');
insert into dept (DEPTNO, DNAME, LOC)
values (20, 'RESEARCH', 'DALLAS');
insert into dept (DEPTNO, DNAME, LOC)
values (30, 'SALES', 'CHICAGO');
insert into dept (DEPTNO, DNAME, LOC)
values (40, 'OPERATIONS', 'BOSTON');
2、建立项目
再来建个Maven项目:SpringBoot_Jdbc,pom文件内容如下,提一下,免得有人有点懵,我这里子工程,spring-boot-starter-parent写在父pom里了:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
</dependencies>
配置文件application.properties里添加数据源配置。
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
spring.datasource.username=scott
spring.datasource.password=tiger
spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
然后建个实体类Dept.java.
public class Dept {
private Integer deptno;
private String dname;
private String location;
//省略getset方法....
public Dept(Integer deptno, String dname, String location) {
super();
this.deptno = deptno;
this.dname = dname;
this.location = location;
}
public Dept() {
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "Dept [deptno=" + deptno +