SpringBoot三层架构Demo

package com.test.dao; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import com.test.domain.User; @Repository public class UserDaoImpl implements UserDao { @Autowired private JdbcTemplate jdbcTemplate; @Override public int insert(User user) { // TODO Auto-generated method stub String sql="insert user (userName) values('"+user.getUserName()+"')"; System.out.println("-------------------------:"+sql); int res=jdbcTemplate.update(sql); return res; } @Override public User queryById(int userId) { // TODO Auto-generated method stub User user=null; RowMapper <User>rowMapper= new BeanPropertyRowMapper<User>(User.class); user=jdbcTemplate.queryForObject("select * from user where userId=?", rowMapper,userId); return user; } }