spring boot+Spring+Spring MVC+Mybatis+Thymeleaf+Druid开发简单用户增删改查实例

简单的框架，Thymeleaf是3,0的 ，2.0的话标签必须闭合，3.0不需要，所以集成了3.0，数据连接池是阿里的Druid,监控界面是http://localhost:8080/druid/login.html 账号root ，密码123

这是userMapper.java  采用注解的方式

/**

 * Created by beyondLi on 2017/6/19.

 */

@Mapper // 声明是一个Mapper,与springbootApplication中的@MapperScan二选一写上即可

@Repository

public interface UserMapper {



@Insert("insert into user(username,age,time) values (#{username},#{age},#{time})")

public void addUser(User user);



@Select("select * from user where id = #{id}")

public User selectUserById(int id);

@Select("select * from user")

public List<User> selectUserAll();



@Update("update user set username=#{userName},age=#{age},time=#{time} where id=#{id}")

public void updateUser(User user);



@Delete("delete from user where id=#{id}")

public void deleteUser(int id);



}