01 | package com.sxl.controller.admin; |
02 |
03 | import java.util.List; |
04 | import java.util.Map; |
05 |
06 | import javax.servlet.http.HttpServletRequest; |
07 |
08 | import org.springframework.http.ResponseEntity; |
09 | import org.springframework.stereotype.Controller; |
10 | import org.springframework.ui.Model; |
11 | import org.springframework.web.bind.annotation.RequestMapping; |
12 |
13 | import com.sxl.controller.MyController; |
14 |
15 | @Controller ( "bkController" ) |
16 | @RequestMapping (value = "/admin/bk" ) |
17 | public class BkController extends MyController { |
18 | |
19 |
20 | @RequestMapping (value = "/frame" ) |
21 | public String frame(Model model, HttpServletRequest request,String flag) throws Exception { |
22 | return "/admin/bk/frame" ; |
23 | } |
24 | |
25 | @RequestMapping (value = "/list" ) |
26 | public String list(Model model, HttpServletRequest request,String flag,String bkName) throws Exception { |
27 | String sql= "select a.* from t_bk a where 1=1" ; |
28 |
29 |
30 | if (bkName!= null &&! "" .equals(bkName)){ |
31 | sql+= " and bkName like '%" +bkName+ "%'" ; |
32 | } |
33 | sql+= " order by id desc" ; |
34 | List list = db.queryForList(sql); |
35 | request.setAttribute( "list" , list); |
36 | return "/admin/bk/list" ; |
37 | } |
38 | |
39 | @RequestMapping (value = "/editSave" ) |
40 | public ResponseEntity<String> editSave(Model model,HttpServletRequest request,Long id,String flag |
41 | ,String bkName) throws Exception{ |
42 | int result = 0 ; |
43 | if (id!= null ){ |
44 | String sql= "update t_bk set bkName=? where id=?" ; |
45 | result = db.update(sql, new Object[]{bkName,id}); |
46 | } else { |
47 | String sql= "insert into t_bk(bkName) values(?)" ; |
48 | result = db.update(sql, new Object[]{bkName}); |
49 | } |
50 | if (result== 1 ){ |
51 | return renderData( true , "操作成功" , null ); |
52 | } else { |
53 | return renderData( false , "操作失败" , null ); |
54 | } |
55 | } |
56 | |
57 | @RequestMapping (value = "/editDelete" ) |
58 | public ResponseEntity<String> editDelete(Model model,HttpServletRequest request,Long id,String flag) throws Exception { |
59 | |
60 | String sql= "delete from t_bk where id=?" ; |
61 | int result = db.update(sql, new Object[]{id}); |
62 | if (result== 1 ){ |
63 | return renderData( true , "操作成功" , null ); |
64 | } else { |
65 | return renderData( false , "操作失败" , null ); |
66 | } |
67 | |
68 | } |
69 | |
70 | @RequestMapping (value = "/edit" ) |
71 | public String edit(Model model, HttpServletRequest request,Long id,String flag) throws Exception { |
72 | if (id!= null ){ |
73 | //修改 |
74 | String sql= "select * from t_bk where id=?" ; |
75 | Map map = db.queryForMap(sql, new Object[]{id}); |
76 | model.addAttribute( "map" , map); |
77 | }String sql= "" ; |
78 |
79 | return "/admin/bk/edit" ; |
80 | } |
81 | } |