整合SpringBoot结合SpringMVC + Thymeleaf 进行简单的CRUD操作
添加pom依赖启动类org.springframework.boot spring-boot-starter-weborg.springframework.boot spring-boot-starter-thymeleaforg.mybatis.spring.boot mybatis-spring-boot-starterRELEASE mysql mysql-connector-java5.1.41 com.alibaba druid1.1.14 org.springframework.boot spring-boot-devtools
@SpringBootApplication
// 配置扫描mybatis的mapper接口
@MapperScan("com.example.demo.mapper")
public class SpringbootDemoApplication {
public static void main(String[] args) {
SpringApplication.run(SpringbootDemoApplication.class, args);
}
}
配置文件
server.port=8081 spring.freemarker.suffix=.ftl spring.servlet.multipart.enabled=true #设置单个文件上传的大小 spring.servlet.multipart.max-file-size=20MB #设置一次上传文件总的大小 spring.servlet.multipart.max-request-size=20MB #mysql连接配置信息 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasouce.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC spring.datasouce.username=root spring.datasource.password=123456 #连接池配置 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource #mybatis的xml bean路径 mybatis.type-aliases-package=com.example.demo.bean mybatis.mapper-locations=classpath:mapper/*Mapper.xml数据库表和实体bean
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`age` int(3) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@Component
public class User {
private Integer id;
private String name;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public User() {
System.out.println("This is constructor method.");
}
public User(Integer id, String name, Integer age) {
this.id = id;
this.name = name;
this.age = age;
}
}
定义mapper接口UserMapper
public interface UserMapper {
public List query(User user);
}
定义xml映射文件UserMapper.xml
注意:映射文件名字必须和对应的Mapper接口名字一致
业务层Serviceselect * from t_user
public interface IUserService {
public List query(User user);
}
@Service
public class UserServiceImpl implements IUserService {
@Autowired
UserMapper userMapper;
@Override
public List query(User user) {
return userMapper.query(user);
}
}
控制层Controller
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
IUserService userService;
@RequestMapping("query")
public List query() {
return userService.query(null);
}
}



