获取配置文件的内容并显示
第一种方法
yml文件
#对象的配置 person: name: zhangsan age: 18 addr: beijing
回显
package com.itheima.controller; import org.springframework.beans.factory.annotation.Value; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Configuration; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; @Controller @ConfigurationProperties(prefix = "person")//自动去找Person开头的匹配 public class Quick3Controller { private String name; public String getName() { return name; } public void setName(String name) { this.name = name; } public String getAddr() { return addr; } public void setAddr(String addr) { this.addr = addr; } private String addr; @RequestMapping("/quick3") @ResponseBody public String quick3(){ //获得配置文件的信息 System.out.println(name); return "name:"+name+",addr="+addr; } }
结果
第二种方法
.java
@Value("${projectStatusBegin}") private int projectStatusBegin;
整合Mybatis
添加起步依赖
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> 添加数据库驱动坐标 <!--MySQL连接驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency>
添加数据库连接信息
#数据库连接信息 spring.datasource.driver.driverClassName=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/e3mall?useUnicode=true&characterEncoding=utf8 spring.datasource.username=e3mall spring.datasource.password=123456
创建User表
-- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('1', 'zhangsan', '123', '张三'); INSERT INTO `user` VALUES ('2', 'lisi', '123', '李四');
创建实体Bean
package com.itheima.domain; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; @Entity public class User { public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getName() { return name; } public void setName(String name) { this.name = name; } // 主键 @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; // 用户名 private String username; // 密码 private String password; // 姓名 private String name; @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", password='" + password + '\'' + ", name='" + name + '\'' + '}'; } }
编写Mapper
<?xmlversion="1.0"encoding="utf-8"?> <!DOCTYPEmapperPUBLIC"-//mybatis.org//DTDMapper3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mappernamespace="com.itheima.mapper.UserMapper"> <selectid="queryUserList"resultType="user"> select*fromuser </select> </mapper>
在application.properties中添加mybatis配置,配置Mapper映射文件
#spring集成Mybatis环境 #pojo别名扫描包 mybatis.type-aliases-package=com.itheima.domain #加载Mybatis映射文件 mybatis.mapper-locations=classpath:mapper/*Mapper.xml
报错The server time zone value ' й ʱ ' is unrecognized or represents more than one time zone. 解决方案:修改jdbc:mysql://127.0.0.1:3306/e3mall?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
编写测试Controller
@Controller publicclassMybatisController{ @Autowired privateUserMapperuserMapper; @RequestMapping("/query") @ResponseBody publicList<User>queryUserList(){ List<User>users=userMapper.queryUserList(); returnusers; } }
运行结果