jdbctemplate mysql_spring boot 使用 jdbcTemplate 连接 mysql

spring boot + mysql

spring boot 访问mysql主要有几种方式

方式一 ：spring boot+jdbcTemplate

方式二：spring data jpa

方式三：spring boot + mybaits

一 :

spring boot+jdbcTemplate

1.引入jar包：

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-starter-test

test

org.springframework.boot

spring-boot-starter-jdbc

mysql

mysql-connector-java

配置数据库参数：

spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

spring.datasource.username=root

spring.datasource.password=root

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

3.编写entity dao service controller：

public class User {

private Long id;

private String name;

private int age;

private String sex;

public Long getId() {

return id;

}

public void setId(Long id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

public String getSex() {

return sex;

}

public void setSex(String sex) {

this.sex = sex;

}

}

@Repository

public class UserDao {

@Autowired

JdbcTemplate jdbcTemplate;

public User getUserById(long id){

List list = jdbcTemplate.query("select * from user where id = ?", new Object[]{id}, new BeanPropertyRowMapper(User.class));

if(list!=null && list.size()>0){

User account = list.get(0);

return account;

}else{

return null;

}

}

public int save(User user){

return jdbcTemplate.update("insert into user (id,name,age,sex) values (?,?,?,?)", user.getId(),user.getName(),user.getAge(),user.getSex());

}

public int update(User user){

return jdbcTemplate.update("update user set name = ? ,age = ? ,sex = ? where id = ?", user.getName(),user.getAge(),user.getSex(),user.getId());

}

}

@Service

public class UserService {

@Autowired

UserDao userDao;

public int add(User user){

return userDao.save(user);

}

public int update(User user){

return userDao.update(user);

}

public User getById(long id){

return userDao.getUserById(id);

}

}

@RestController

@RequestMapping("/user")

public class UserController {

@Autowired

UserService userService;

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

public int addUser(@RequestBody User user){

return userService.add(user);

}

@RequestMapping(value = "/update",method = RequestMethod.PUT)

public int updateUser(@RequestBody User user){

return userService.update(user);

}

@RequestMapping(value = "/find",method = RequestMethod.GET)

public User updateUser(long id){

return userService.getById(id);

}

}

最后启动项目