后端mvc框架基于springmvc ~~~ /** * controller示例 * * 統一繼承AppController * */ @RestController @RequestMapping("/example") public class ExampleController extends AppController { @Resource(name = "exampleService") private ExampleService exampleService; /** * 查詢示例 * * inParam：map結構，將request.getParameter("xx")能取到的參數存入其中 * pagination：接收分頁參數 */ @RequestMapping(value = "/queryList") public Object queryList(InParam<String, Object> inParam, Pagination pagination) { return exampleService.queryList(inParam, pagination); } } ~~~ ``` /** * service示例 * */ @Service("exampleService") public class ExampleService extends AppService { @Resource(name = "sqlSessionDao") private BaseSqlSessionDao dao; /** * 查詢示例 * * @param param * @param pagination */ @SuppressWarnings( { "serial", "unchecked" }) @ICacheable(cacheSeconds = "100")//可指定緩存時間，單位秒，此值也可從屬性文件中讀取，例如：@ICacheable(cacheSeconds = "${cacheSeconds}") public PageData queryNameList(IData<String, Object> param, Pagination pagination) { return dao.selectList("NameListSQL.queryNameList", param, pagination); } } ``` ``` <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="NameListSQL"> <select id="queryNameList" resultType="com.walk.example.mvc.entity.TfNList"> SELECT A.* FROM TF_N_LIST A <where> <if test="listId != null and listId != ''"> AND A.LIST_ID = #{listId} </if> <if test="listName != null and listName != ''"> AND A.LIST_NAME LIKE #{listName} || '%' </if> <if test="custType != null and custType != ''"> AND A.CUST_TYPE = #{custType} </if> <if test="subCustType != null and subCustType != ''"> AND A.SUB_CUST_TYPE = #{subCustType} </if> </where> </select> </mapper> ```