import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import com.bw.bean.City;
import com.bw.bean.FL;
import com.bw.bean.Mc;
import com.bw.service.McService;
import com.bw.utils.FilesUtils;
import com.bw.utils.PageUtil;
@Controller
public class McController {
@Autowired
private McService ms;
//列表
@RequestMapping("list")
public String mlist(HttpServletRequest request,String page,String mohu){
mohu=mohu==null?"":mohu;
int count=ms.count(mohu);
PageUtil pu=new PageUtil(page, 2, count);
List<Mc> list=ms.mlist(mohu,pu);
request.setAttribute("list", list);
request.setAttribute("mohu", mohu);
request.setAttribute("pu", pu);
return "list";
}
//跳转添加页面
/**
* <p>Title: toadd</p>
* <p>Description: </p>
* @author TF
* @date 2018-4-9 上午10:58:26
* @return String
*/
@RequestMapping("toadd")
public String toadd(HttpServletRequest request,Mc m){
List<FL> flist = ms.flist();
request.setAttribute("flist", flist);
return "add";
}
@RequestMapping("doadd")
public String doadd(HttpServletRequest request,Mc m,MultipartFile file){
String path = FilesUtils.FilesUpload_Spring(request, file, "\\image");
int i = path.indexOf("image");
String string = path.substring(i);
m.setTp(string);
ms.doadd(m);
return "redirect:list.do";
}
//批量删除
@RequestMapping("del")
public String del(HttpServletRequest request,String ids){
ms.del(ids);
return "redirect:list.do";
}
//三级联动
@RequestMapping("cityList")
@ResponseBody
public List<City> cityList(HttpServletRequest request,Integer pid){
List<City> clist = ms.cityList(pid);
return clist;
}
/**
* <p>Title: down</p>
* <p>Description: 下载</p>
* @author TF
* @date 2018年5月3日 下午1:56:26
* @return void
*/
@RequestMapping("down")
public void down(HttpServletRequest request,HttpServletResponse response,String tp){
FilesUtils.FilesDownload(request, response, tp);
}
}
//列表
<td><img src="${u.tp}" height="30px" width="30px">
<a href="down?tp=${u.tp}"><input type="button" value="下载"></a> </td>
//三级联动加上传
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'list.jsp' starting page</title>
<script type="text/javascript" src="<%=path %>/js/jquery-1.8.3.js"></script>
<link rel="stylesheet" href="<%=path %>/js/css.css" type="text/css"></link>
<script type="text/javascript">
//三级联动
$(function(){
var sheng = "";
var shi = "";
var qu = "";
$.ajax({
url : "cityList.do",
type : "get",
dataType : "json",
data : {
pid : 0
},
success : function(obj) {
for ( var i in obj) {
$("#sheng").append("<option value=" + obj[i].id + ">" + obj[i].name+ "</option>");
}
}
});
$("#sheng").change(
function() {
sheng = $("#sheng option:selected").text();
$("#s").val(sheng);
$("#shi").empty();
$("#shi").append("<option>请选择</option>");
$("#qu").empty();
$("#qu").append("<option>请选择</option>");
var pid = $("#sheng option:selected").val();
$.ajax({
url : "cityList.do",
type : "get",
dataType : "json",
data : {
pid : pid
},
success : function(obj) {
for ( var i in obj) {
$("#shi").append(
"<option value=" + obj[i].id + ">"+ obj[i].name + "</option>");
}
}
});
});
$("#shi").change(
function() {
shi = $("#shi option:selected").text();
$("#c").val(shi);
$("#qu").empty();
$("#qu").append("<option>请选择</option>");
var pid = $("#shi option:selected").val();
$.ajax({
url : "cityList.do",
type : "get",
dataType : "json",
data : {
pid : pid
},
success : function(obj) {
for ( var i in obj) {
$("#qu").append(
"<option value=" + obj[i].id + ">"+ obj[i].name + "</option>");
}
}
});
});
$("#qu").change(function() {
qu = $("#qu option:selected").text();
$("#x").val(qu);
});
});
</script>
</head>
<body>
<form action="doadd.do" method="post" enctype="multipart/form-data">
<table>
<tr>
<td>商品名称</td>
<td><input type="text" name="mname"></td>
</tr>
<tr>
<td>描述</td>
<td><input type="text" name="msc"></td>
</tr>
<tr>
<td>商品分类</td>
<td>
<select name="fid">
<c:forEach items="${flist }" var="f">
<option value="${f.fid }">${f.fname }</option>
</c:forEach>
</select>
</td>
</tr>
<tr>
<td>单价</td>
<td>
<input type="text" name="jiage" >
</td>
</tr>
<tr>
<td>创建日期</td>
<td>
<input type="text" name="cr" >
</td>
</tr>
<tr>
<td>更新日期</td>
<td>
<input type="text" name="gr" >
</td>
</tr>
<tr>
<td>发布状态</td>
<td>
<input type="text" name="fz" >
</td>
</tr>
<tr>
<td>图片上传</td>
<td>
<input type="file" name="file" >
</td>
</tr>
<tr>
<td>省/市: <input type="hidden" id="s" name="sheng">
<input type="hidden" id="c" name="shi">
<input type="hidden" id="x" name="xian"></td>
<td><select id="sheng">
<option>--请选择--</option>
</select>
</td>
<tr>
<tr>
<td>市/区:</td>
<td>
<select id="shi">
<option>--请选择--</option>
</select>
</td>
<tr>
<tr>
<td>区/县:</td>
<td>
<select id="qu">
<option>--请选择--</option>
</select>
</td>
<tr>
<tr>
<td></td>
<td>
<input type="submit" value="确认添加" >
</td>
</tr>
</table>
</form>
</body>
</html>