入道彌深，所見彌大

1.以maven、springboot為基礎(chǔ)腳手架。
2.新建一個(gè)maven項(xiàng)目
3.前端頁面bootstrap、bootstrap-table、layer、jquery
4.后端mybatis、工具類Guava、參數(shù)校驗(yàn)validation等
5.controller類上必須加@Validate,參數(shù)校驗(yàn)@NotBlank 才能生效。

@RestController
@RequestMapping("/webApi")
@Validated
public class ApiController {
    @GetMapping("allUser")
    public List<AppUser> allUser(@NotBlank String name){
       return null;
    }
  
}

6.mybatis sql 標(biāo)簽的作用

<sql id="dto">
       id,name,phone,email,aboutme,avatar,type,create_time,enable,agency_id
    </sql>
    <select id="getUser" resultType="AppUser">
        SELECT <include refid="dto" />FROM USER order by id desc
    </select>

7.mybatis 模糊查詢 bind 標(biāo)簽的作用可以用來綁定變量，可防止sql 注入

<select id="queryUser" resultType="AppUser">
        select
        <include refid="dto" /> from USER where
        <if test="phone != null and phone != ''">
            <bind name="uphone" value="'%'+phone+'%'"/>
            phone like #{uphone}
        </if>
         <if test="name != null and name != ''">
             <bind name="uname" value="'%'+name+'%'"/>
             and name like #{uname}
         </if>
         order by id desc
    </select>

8.動態(tài)sql 標(biāo)簽，where \ if test=""，這里注意下，在代碼里做了控制，每次只允許用一個(gè)參數(shù)不為空，兩個(gè)為空，所以這里沒加 and

<select id="getUserByEmPhoneName" parameterType="java.util.HashMap" resultType="AppUser">
        select
        <include refid="dto" /> from USER where
         <if test="name !=null and name != ''">
             name = #{name}
         </if>
        <if test="email != null and email != ''">
            email = #{email}
        </if>
        <if test="phone != null and phone != ''">
            phone = #{phone}
        </if>
    </select>

9.新增記錄的時(shí)候主鍵自增、前提數(shù)據(jù)得支持自增，使用useGeneratedKeys屬性

    <insert id="insert" parameterType="AppUser" useGeneratedKeys="true">
        insert into  USER(name,phone,email,passwd,avatar,type,create_time,enable,aboutme)
        values (#{name},#{phone},#{email},#{passwd},#{avatar},#{type},#{createTime},#{enable},#{aboutme})
    </insert>

11.mybatis foreach標(biāo)簽的使用

   <insert id="deleteUser" parameterType="java.util.List">
        UPDATE USER SET enable = '1' where id in
        <foreach item="item" collection="list" separator="," open="(" close=")" index="">
               #{item}
        </foreach>
    </insert>

12.案例完成簡單增刪改查，需求如下：

案例demo下載地址
13.nginx作為本地文件服務(wù)器的配置--readme.txt