SpringBoot入门教程
以连接Oracle为例
1、创建sp项目
1.1、配置和选项
1.2、修改Oracle版本
修改默认的依赖为自己mvn仓库的依赖
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.1.0</version>
</dependency>
1.3、改名application.properties为application.yml
然后输入以下内容,即可创建好连接
spring:
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@192.168.221.205:1521:orcl
username: xym
password: xym
2、写逻辑业务
写好实体类entity之后,三步骤:dao–>services–>controller
2.1、实体类
public class Users {
private int userid;
private String username;
private Date birthday;
private float userhigh;
//getter setter
}
2.2、dao
public interface UsersDAO {
@Select("select userid,username,birthday,userhigh from users")
List<Users> findAll();
@Select("select userid,username,birthday,userhigh from users where username like '%${name}%' ")
List<Users> findUserSameName(String name);
}
2.3、services
@Service
public class UsersService {
@Autowired
private UsersDAO udao;//这个类没人帮我new,告诉位置即可
public List<Users> searchAll(){
return udao.findAll();
}
public List<Users> sameName(String name){
return udao.findUserSameName(name);
}
}
2.4、controller
在类的头上加一个@RequestMapping("/users")
注解,即为模块,和下面的RequestMapping是层级关系,在后续的接口暴露上,要输入以下格式才行http://localhost:8080/users/all
,本例未用,此处只是说一下。
@RestController
public class InitCtrl {
@Autowired
private UsersService usersService;
@RequestMapping("/all")
public List<Users> init(){
return usersService.searchAll();
}
//localhost:8080/same?name=传参
@RequestMapping("/same")
public List<Users> same(String name){
return usersService.sameName(name);
}
}
2.5、执行application
@SpringBootApplication
@MapperScan("cn.kgc.myspboacle.dao")
public class MyspboacleApplication {
public static void main(String[] args) {
SpringApplication.run(MyspboacleApplication.class, args);
}
}
2.6、暴露出的接口
打开浏览器,输入RequestMapping的后缀
http://localhost:8080/all
http://localhost:8080/same?name=d
3、接口测试
安装小飞人postman,打开,不用注册直接skip
创建Collections
创建工程,在里面右击新建request,输入Get的链接,点击Send,即可进行测试
4、接口文档案例