springboot--集成jdbctemplate

springboot–集成jdbctemplate

添加依赖

<!-- 引入jdbc支持x -->
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-jdbc</artifactId>
	<version>${spring.boot}</version>
</dependency>
<!-- 引入MySQL连接依赖包 -->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.41</version>
	<scope>runtime</scope>
</dependency>

配置文件

##mysql
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/cc3?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456

controller

@RestController
@RequestMapping("/user")
public class UserController {
	@Autowired
    private UserService userService;

	@RequestMapping("/login")
    public Map<String, Object> login() {
        Sys_users user = new Sys_users();
        user.setId("1");
        user.setName("cc");
        user.setCompanyid("1001");
        user.setPwd("123456");
        user.setStatus("0");
		userService.insert(user);
        return null;
    }
}

service接口及serviceImpl

public interface UserService {
	public void insert(Sys_users user);
}

@Service
public class UserServiceImpl implements UserService {
	@Autowired
    private UserDao userDao;

	public void insert(Sys_users user) {
		// TODO Auto-generated method stub
		userDao.insert(user);
	}
}

dao

@Repository
public class UserDao {
	@Autowired
	private JdbcTemplate jdbcTemplate;
	public void insert(Sys_users user) {
		// TODO Auto-generated method stub
		String sql = "insert into sys_users(id, name, companyid, pwd, status) values(?,?,?,?,?)";
        jdbcTemplate.update(sql, user.getId(),user.getName(),user.getCompanyid(),user.getPwd(),user.getStatus());
	}

}