| | |
| | | @PostMapping({"getDzListByAdmin.do"}) |
| | | public Result getDzListByAdmin(@RequestParam(value = "pageNum", defaultValue = "1") int pageNum, |
| | | @RequestParam(value = "pageSize", defaultValue = "5") int pageSize, |
| | | @RequestParam(value = "keywords")String keywords) { |
| | | @RequestParam(value = "keywords", required = false)String keywords) { |
| | | return stockDzService.getDzListByAdmin(pageNum, pageSize, keywords); |
| | | } |
| | | |
| | |
| | | <mapper namespace="com.yami.trading.dao.dz.StockDzMapper"> |
| | | |
| | | |
| | | <select id="findStockTypeDz" resultType="java.util.HashMap" parameterType="map"> |
| | | <select id="findStockTypeDz" resultType="com.yami.trading.bean.dz.StockDz" parameterType="map"> |
| | | SELECT |
| | | * |
| | | FROM stock_dz |
| | | FROM t_stock_dz |
| | | |
| | | WHERE start_time < #{formatDate} AND end_time > #{formatDate} |
| | | |
| | |
| | | <select id="getDzListByAdmin" resultType="java.util.HashMap" parameterType="map"> |
| | | SELECT |
| | | * |
| | | FROM stock_dz |
| | | FROM t_stock_dz |
| | | WHERE 1=1 |
| | | <if test="keyWords != null and keyWords != '' "> |
| | | AND (stock_code LIKE #{keyWords} OR stock_name LIKE #{keyWords}) |