springboot和mysql怎么交互_Springboot--与数据库交互

1.目录结构

图片.png

2.代码

2.1 启动类-Demo

@SpringBootApplication

@MapperScan(value = "com.may.project.dao")

@ComponentScan(basePackages = {"com.may.project.action","com.may.project.service.impl"})

public class Demo {

public static void main(String[] args) {

SpringApplication.run(Demo.class, args);

}

}

2.2 Action-SendMessageController

@Slf4j

@RequestMapping("/send")

@RestController

public class SendMessageController {

@Autowired

private IUserTestService userTestService;

@RequestMapping(value="/getbymemberid", method= RequestMethod.POST)

public UserTest getByMember(HttpServletRequest request, @RequestBody Map param) throws Exception {

log.info("/send/getbymemberid"+ param);

String id = (String) param.get("id");

log.info("id ="+id);

UserTest userTest = userTestService.findNameByid(id);

log.info("userTest ="+userTest);

return userTest;

}

}

2.3 DAO-IUserTestDAO

@Mapper

public interface IUserTestDAO {

UserTest findNameByid(@Param("id") String id);

}

2.4 实体-UserTest

@Data

public class UserTest {

private String id;

private String userName;

private String phone;

private String birthday;

private Date createTime;

}

2.5 service

@Component

public class UserTestServiceImpl implements IUserTestService{

@Autowired

private IUserTestDAO userTestDAO;

@Override

public UserTest findNameByid(String id) {

return userTestDAO.findNameByid(id);

}

}

public interface IUserTestService{

UserTest findNameByid(String id);

}

2.6 mapping-UserTestDAO.xml

select *

from t_user

where id =#{id}

2.6 配置文件-application.properties

#应用名称

spring.application.name=test-project

#访问端口号

server.port=8749

#编码格式

server.tomcat.uri-encoding=utf-8

#数据库相关配置

spring.datasource.url=jdbc:mysql://localhost:3306/sql_test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true

spring.datasource.username=root

spring.datasource.password=***

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.max-idle=10

spring.datasource.max-wait=10000

spring.datasource.min-idle=5

spring.datasource.initial-size=5

#session生命周期

server.servlet.session.timeout=30m

mybatis.mapper-locations=classpath*:mapping/**/*.xml