dao注解

 1 /**
 2      * 增SQL语句
 3      */
 4     final String ADD = "INSERT INTO user VALUES(userID,#{userName,jdbcType=VARCHAR},#{password,jdbcType=VARCHAR},#{updateTime,jdbcType=VARCHAR},#{roleID,jdbcType=INTEGER})";
 5 
 6     /**
 7      * 删SQL语句
 8      */
 9     final String DELETE = "delete from user where userID=#{userID}";
10 
11     /**
12      * 改SQL语句
13      */
14     final String UPDATE = "update user set userName=#{userName},password=#{password},updateTime=#{updateTime},roleID=#{roleID} where userID=#{userID}";
15 
16     /**
17      * 单查SQL语句
18      */
19     final String FINDUSERBYID = "select userID,userName,password,updateTime,roleID from user where userID=#{userID,jdbcType=INTEGER}";
20 
21     /**
22      * 全查，模糊查询，分页SQL语句
23      */
24     final String FINDALL = 
25             "<script>" + "select userID,userName,password,updateTime,roleID from user" 
26             + "<where>"
27             + "<if test='userName!=null'>" 
28             + " and userName like #{userName,jdbcType=VARCHAR}" 
29             + "</if>"
30             + "<if test='updateTime!=null'>" 
31             + " and updateTime like #{updateTime,jdbcType=VARCHAR}" 
32             + "</if>"
33             + "</where>" 
34             + " limit #{start,jdbcType=INTEGER},#{size,jdbcType=INTEGER}"
35             + "</script>";
36 
37     @Insert(ADD)
38     public int save(User user);
39 
40     @Delete(DELETE)
41     public int delete(int userID);
42 
43     @Update(UPDATE)
44     public int update(User user);
45 
46     @Select(FINDALL)
47     public List<User> findAll(Map<String, Object> map);
48 
49     @Select(FINDUSERBYID)
50     public User findByID(int userID);

 

转载于:https://www.cnblogs.com/blogs-of-chg/p/9868814.html