概述
实现从数据库获取用户信息
步骤如下:
1、添加pom.xml相关定义
<!-- spring-ioc -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<!-- spring-mvc -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- mybatis-spring -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.2.2</version>
</dependency>
<!-- dao-mysql -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- spring 热启动 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
2、添加相关数据库配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver //配置数据库驱动
spring.datasource.url=jdbc:mysql://esadb.mysql.rds.aliyuncs.com:3306/hekijia?autoReconnect=true&useUnicode=true&characterEncoding=utf8&useSSL=false&failOverReadOnly=false //配置数据库连接
spring.datasource.username=heko //配置数据库访问用户名
spring.datasource.password=hekouyijia1 //配置数据库访问密码
3、编写实体类、dao/controller
dao: //这个采用注解sql,只需要在对应的接口上使用对应的注解查询语句即可
public interface UserDao {
@Select("SELECT * FROM c_user_info where user_id = #{userId} and state = 1")
public UserInfo getUserInfo(Map<String,Object> map);
}
controller:
@RestController
public class Testcontroller extends BaseController{
@Autowired
private UserDao dao;//注入dao
@RequestMapping(value = "/get", method = RequestMethod.POST)
public Map<String, Object> get(String type) {
Map<String, Object> map = new HashMap<String, Object>();
Map<String, Object> rspmap = new HashMap<String, Object>();
map.put("userId", "180628000020");
rspmap.put("user", dao.getUserInfo(map));
return rspmap;
}
}
4、在启动类上添加Mapper接口扫描注解即可
/**
* 主启动类
* */
@SpringBootApplication
@MapperScan(basePackages={"com.boot.crk.index.dao"}) //扫描接口所在的路径
public class MyBootApplication {
public static void main(String[] args) {
// TODO Auto-generated method stub
SpringApplication.run(MyBootApplication.class, args);
}
}
5、运行启动,访问http://localhost:8888/index/get.do
最后
以上就是寂寞小懒虫为你收集整理的springboot入门实例(一)的全部内容,希望文章能够帮你解决springboot入门实例(一)所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复