基于javaweb+mysql的springboot超市订单管理系统(java+springboot+jsp+mybatis+maven+mysql)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot超市订单管理系统(java+springboot+jsp+mybatis+maven+mysql)
项目介绍
该超市订单管理毕业设计基于jdk8版本开发,在部署时需要使用jdk8以上的版本。使用了目前流行的框架组合springboot+mybatis的框架技术, 实现了供应商管理对供应商实现增删改查、订单管理对超市订单实现增删改查、用户管理等功能,适用于小型超市的使用,通过学习该超市订单管理,对于springboot+mybatis框架的组合能够有更深层次的理解。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本;
6.是否Maven项目: 是
技术栈
-
后端:springboot MyBatis
-
前端:JSP+css+javascript
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,配置tomcat,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行成功后,访问http://localhost:8080/ 到登录页面
currentPageNo = 1;
}else if(currentPageNo > totalPageCount){
currentPageNo = totalPageCount;
}
userList = userService.getUserList(queryUserName,queryUserRole,currentPageNo, pageSize);
System.out.println("----------> "+userList.get(0).getAge());
request.setAttribute("userList", userList);
List<Role> roleList = null;
System.out.println(userList.get(0).getRole().getRoleName());
roleList = roleService.getRoleList();
System.out.println("===== "+roleList.get(0).getRoleCode()+"--------roleList:"+roleList.get(0).getRoleName());
request.setAttribute("roleList", roleList);
request.setAttribute("queryUserName", queryUserName);
request.setAttribute("queryUserRole", queryUserRole);
request.setAttribute("totalPageCount", totalPageCount);
request.setAttribute("totalCount", totalCount);
request.setAttribute("currentPageNo", currentPageNo);
return "userlist";
}
private String add(HttpServletRequest request, HttpServletResponse response, User user, BindingResult bindingResult, HttpSession session)
throws ServletException, IOException {
if(bindingResult.hasErrors()){
System.out.println("输入错误");
return "useradd";
}System.out.println("111");
user.setCreatedBy(((User)session.getAttribute(Constants.USER_SESSION)).getId());System.out.println("222");
user.setCreationDate(new Date());System.out.println("333");
if(userService.add(user)){return "redirect:/user.do?method=query";}System.out.println("444");
return "useradd";
}
}
if(!StringUtils.isNullOrEmpty(id)){
Bill bill = null;
bill = billService.getBillById(id);
System.out.println("bill================> "+bill);
request.setAttribute("bill", bill);
return url;
// request.getRequestDispatcher(url).forward(request, response);
}
return "error";
}
private String modify(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
System.out.println("modify===============");
String id = request.getParameter("id");
String productName = request.getParameter("productName");
String productDesc = request.getParameter("productDesc");
String productUnit = request.getParameter("productUnit");
String productCount = request.getParameter("productCount");
String totalPrice = request.getParameter("totalPrice");
String providerId = request.getParameter("providerId");
String isPayment = request.getParameter("isPayment");
Bill bill = new Bill();
bill.setId(Integer.valueOf(id));
bill.setProductName(productName);
bill.setProductDesc(productDesc);
bill.setProductUnit(productUnit);
bill.setProductCount(new BigDecimal(productCount).setScale(2,BigDecimal.ROUND_DOWN));
bill.setIsPayment(Integer.parseInt(isPayment));
bill.setTotalPrice(new BigDecimal(totalPrice).setScale(2,BigDecimal.ROUND_DOWN));
bill.setProviderId(Integer.parseInt(providerId));
bill.setModifyBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
bill.setModifyDate(new Date());
boolean flag = false;
flag = billService.modify(bill);
if(flag){
return "redirect:/bill.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/bill.do?method=query");
}else{
return "billmodify";
// request.getRequestDispatcher("billmodify.jsp").forward(request, response);
}
}
private void delBill(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
public class LoginServlet{
@Autowired
UserServiceImpl userService;
@Autowired
RoleServiceImpl roleService;
@Autowired
ProviderServiceImpl providerService;
@Autowired
BillServiceImpl billService;
@RequestMapping(value="/login.do",method = {RequestMethod.POST, RequestMethod.GET})
public String doPost(HttpServletRequest request, HttpServletResponse response, Model model){
System.out.println("login ============ " );
//获取用户名和密码
String userCode = request.getParameter("userCode");
String userPassword = request.getParameter("userPassword");
System.out.println(userCode+" "+userPassword);
//调用service方法,进行用户匹配
User user = userService.login(userCode,userPassword);
System.out.println(user);
if(null != user){//登录成功
//放入session
request.getSession().setAttribute(Constants.USER_SESSION, user);
//页面跳转(frame.jsp)
return "frame";
}else{
//页面跳转(login.jsp)带出提示信息--转发
model.addAttribute("error", "用户名或密码不正确");
return "login";
//.forward(request, response);
}
}
}
public class SysFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
// TODO Auto-generated method stub
provider.setModifyBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
provider.setModifyDate(new Date());
boolean flag = false;
flag = providerService.modify(provider);
System.out.println("--------flag="+flag);
if(flag){
return "redirect:/provider.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/provider.do?method=query");
}else{
return "providermodify";
// request.getRequestDispatcher("providermodify.jsp").forward(request, response);
}
}
private String getProviderById(HttpServletRequest request, HttpServletResponse response, String url)
throws ServletException, IOException {
String id = request.getParameter("proid");
System.out.println("-------------"+id);
if(!StringUtils.isNullOrEmpty(id)){
Provider provider = null;
provider = providerService.getProviderById(id);
request.setAttribute("provider", provider);
System.out.println("-------------"+id);
return url;
// request.getRequestDispatcher(url).forward(request, response);
}
return "error";
}
private String add(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String proCode = request.getParameter("proCode");
String proName = request.getParameter("proName");
String proContact = request.getParameter("proContact");
String proPhone = request.getParameter("proPhone");
String proAddress = request.getParameter("proAddress");
String proFax = request.getParameter("proFax");
String proDesc = request.getParameter("proDesc");
Provider provider = new Provider();
provider.setProCode(proCode);
provider.setProName(proName);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProFax(proFax);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
provider.setCreatedBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
}else if(StringUtils.isNullOrEmpty(oldpassword)){//旧密码输入为空
resultMap.put("result", "error");
}else{
String sessionPwd = ((User)o).getUserPassword();
if(oldpassword.equals(sessionPwd)){
resultMap.put("result", "true");
}else{//旧密码输入不正确
resultMap.put("result", "false");
}
}
// response.setContentType("application/json");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter outPrintWriter = response.getWriter();
outPrintWriter.write(JSONArray.toJSONString(resultMap));
outPrintWriter.flush();
outPrintWriter.close();
}
private String modify(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String id = request.getParameter("uid");
String userName = request.getParameter("userName");
String gender = request.getParameter("gender");
String birthday = request.getParameter("birthday");
String phone = request.getParameter("phone");
String address = request.getParameter("address");
String userRole = request.getParameter("userRole");
User user = new User();
user.setId(Integer.valueOf(id));
user.setUserName(userName);
user.setGender(Integer.valueOf(gender));
try {
user.setBirthday(new SimpleDateFormat("yyyy-MM-dd").parse(birthday));
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
user.setPhone(phone);
user.setAddress(address);
user.setUserRole(Integer.valueOf(userRole));
user.setModifyBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
user.setModifyDate(new Date());
if(userService.modify(user)){
return "redirect:/user.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/user.do?method=query");
}else{
return "usermodify";
// request.getRequestDispatcher("usermodify.jsp").forward(request, response);
}
}else{
resultMap.put("delResult", "notexit");
}
//把resultMap转换成json对象输出
// response.setContentType("application/json");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter outPrintWriter = response.getWriter();
outPrintWriter.write(JSONArray.toJSONString(resultMap));
outPrintWriter.flush();
outPrintWriter.close();
}
private String add(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String billCode = request.getParameter("billCode");
String productName = request.getParameter("productName");
String productDesc = request.getParameter("productDesc");
String productUnit = request.getParameter("productUnit");
String productCount = request.getParameter("productCount");
String totalPrice = request.getParameter("totalPrice");
String providerId = request.getParameter("providerId");
String isPayment = request.getParameter("isPayment");
Bill bill = new Bill();
bill.setBillCode(billCode);
bill.setProductName(productName);
bill.setProductDesc(productDesc);
bill.setProductUnit(productUnit);
bill.setProductCount(new BigDecimal(productCount).setScale(2,BigDecimal.ROUND_DOWN));
bill.setIsPayment(Integer.parseInt(isPayment));
bill.setTotalPrice(new BigDecimal(totalPrice).setScale(2,BigDecimal.ROUND_DOWN));
bill.setProviderId(Integer.parseInt(providerId));
bill.setCreatedBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
bill.setCreationDate(new Date());
boolean flag = false;
flag = billService.add(bill);
System.out.println("add flag -- > " + flag);
if(flag){
return "redirect:/bill.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/bill.do?method=query");
}else{
return "billadd";
// request.getRequestDispatcher("billadd.jsp").forward(request, response);
}
}
private String query(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
System.out.println("=======================");
List<Provider> providerList = new ArrayList<Provider>();
providerList = providerService.getProviderList("","");
request.setAttribute("providerList", providerList);
public String pwdmodify(){
return "pwdmodify";
}
@RequestMapping(value="/provideradd",method = {RequestMethod.POST, RequestMethod.GET})
public String provideradd(){
return "provideradd";
}
@RequestMapping(value="/useradd",method = {RequestMethod.POST, RequestMethod.GET})
public String useradd(Model model){
model.addAttribute("user", new User());//这里给视图层提供了数据的对象,用来数据绑定
return "useradd";
}
/*@RequestMapping(value="/pwdmodify.do",method = {RequestMethod.POST,RequestMethod.GET})
public String index(){
return "pwdmodify";
}
@RequestMapping(value="/pwdmodify.do",method = {RequestMethod.POST,RequestMethod.GET})
public String index(){
return "pwdmodify";
}
@RequestMapping(value="/pwdmodify.do",method = {RequestMethod.POST,RequestMethod.GET})
public String index(){
return "pwdmodify";
}
@RequestMapping(value="/pwdmodify.do",method = {RequestMethod.POST,RequestMethod.GET})
public String index(){
return "pwdmodify";
}
@RequestMapping(value="/pwdmodify.do",method = {RequestMethod.POST,RequestMethod.GET})
public String index(){
return "pwdmodify";
}*/
//@RequestMapping(value="/test2",method = {RequestMethod.POST,RequestMethod.GET})
/* @RequestMapping(value="/index1")
public ModelAndView index1(@RequestParam(value="username",required = false) String username){
ModelAndView mav= new ModelAndView();
mav.addObject("username",username);
mav.setViewName("index");
return mav;
}
@RequestMapping(value="/index2")
public String index2(@RequestParam(value="username",required = false) String username, Model model){
System.out.println(new BigDecimal("23.235").setScale(2,BigDecimal.ROUND_HALF_DOWN));
}
}
@Controller
public class ProviderServlet {
@Autowired
BillServiceImpl billService;
@Autowired
ProviderServiceImpl providerService;
@Autowired
UserServiceImpl userService;
@RequestMapping(value="/provider.do",method = {RequestMethod.POST, RequestMethod.GET})
public String doPost(HttpServletRequest request, HttpServletResponse response, @RequestParam(value="method",required = false) String method)
throws ServletException, IOException {
if(method != null && method.equals("query")){
return this.query(request,response);
}else if(method != null && method.equals("add")){
return this.add(request,response);
}else if(method != null && method.equals("view")){
return this.getProviderById(request,response,"providerview");
}else if(method != null && method.equals("modify")){
return this.getProviderById(request,response,"providermodify");
}
private String add(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String billCode = request.getParameter("billCode");
String productName = request.getParameter("productName");
String productDesc = request.getParameter("productDesc");
String productUnit = request.getParameter("productUnit");
String productCount = request.getParameter("productCount");
String totalPrice = request.getParameter("totalPrice");
String providerId = request.getParameter("providerId");
String isPayment = request.getParameter("isPayment");
Bill bill = new Bill();
bill.setBillCode(billCode);
bill.setProductName(productName);
bill.setProductDesc(productDesc);
bill.setProductUnit(productUnit);
bill.setProductCount(new BigDecimal(productCount).setScale(2,BigDecimal.ROUND_DOWN));
bill.setIsPayment(Integer.parseInt(isPayment));
bill.setTotalPrice(new BigDecimal(totalPrice).setScale(2,BigDecimal.ROUND_DOWN));
bill.setProviderId(Integer.parseInt(providerId));
bill.setCreatedBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
bill.setCreationDate(new Date());
boolean flag = false;
flag = billService.add(bill);
System.out.println("add flag -- > " + flag);
if(flag){
return "redirect:/bill.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/bill.do?method=query");
}else{
return "billadd";
// request.getRequestDispatcher("billadd.jsp").forward(request, response);
}
}
private String query(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
System.out.println("=======================");
List<Provider> providerList = new ArrayList<Provider>();
providerList = providerService.getProviderList("","");
request.setAttribute("providerList", providerList);
String queryProductName = request.getParameter("queryProductName");
String queryProviderId = request.getParameter("queryProviderId");
String queryIsPayment = request.getParameter("queryIsPayment");
if(StringUtils.isNullOrEmpty(queryProductName)){
queryProductName = "";
}
List<Bill> billList = new ArrayList<Bill>();
outPrintWriter.flush();
outPrintWriter.close();
}
private String modify(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String proContact = request.getParameter("proContact");
String proPhone = request.getParameter("proPhone");
String proAddress = request.getParameter("proAddress");
String proFax = request.getParameter("proFax");
String proDesc = request.getParameter("proDesc");
String id = request.getParameter("id");
Provider provider = new Provider();
provider.setId(Integer.valueOf(id));
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProFax(proFax);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
provider.setModifyBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
provider.setModifyDate(new Date());
boolean flag = false;
flag = providerService.modify(provider);
System.out.println("--------flag="+flag);
if(flag){
return "redirect:/provider.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/provider.do?method=query");
}else{
return "providermodify";
// request.getRequestDispatcher("providermodify.jsp").forward(request, response);
}
}
private String getProviderById(HttpServletRequest request, HttpServletResponse response, String url)
throws ServletException, IOException {
String id = request.getParameter("proid");
System.out.println("-------------"+id);
if(!StringUtils.isNullOrEmpty(id)){
Provider provider = null;
provider = providerService.getProviderById(id);
request.setAttribute("provider", provider);
System.out.println("-------------"+id);
return url;
// request.getRequestDispatcher(url).forward(request, response);
}
return "error";
}
//把resultMap转换成json对象输出
// response.setContentType("application/json");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter outPrintWriter = response.getWriter();
outPrintWriter.write(JSONArray.toJSONString(resultMap));
outPrintWriter.flush();
outPrintWriter.close();
}
private String modify(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String proContact = request.getParameter("proContact");
String proPhone = request.getParameter("proPhone");
String proAddress = request.getParameter("proAddress");
String proFax = request.getParameter("proFax");
String proDesc = request.getParameter("proDesc");
String id = request.getParameter("id");
Provider provider = new Provider();
provider.setId(Integer.valueOf(id));
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProFax(proFax);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
provider.setModifyBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
provider.setModifyDate(new Date());
boolean flag = false;
flag = providerService.modify(provider);
System.out.println("--------flag="+flag);
if(flag){
return "redirect:/provider.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/provider.do?method=query");
}else{
return "providermodify";
// request.getRequestDispatcher("providermodify.jsp").forward(request, response);
}
}
private String getProviderById(HttpServletRequest request, HttpServletResponse response, String url)
throws ServletException, IOException {
String id = request.getParameter("proid");
System.out.println("-------------"+id);
if(!StringUtils.isNullOrEmpty(id)){
Provider provider = null;
provider = providerService.getProviderById(id);
request.setAttribute("provider", provider);
System.out.println("-------------"+id);
return url;
// request.getRequestDispatcher(url).forward(request, response);
}
return "error";
}
private String add(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String proCode = request.getParameter("proCode");
String proName = request.getParameter("proName");
String proContact = request.getParameter("proContact");
String proPhone = request.getParameter("proPhone");
String proAddress = request.getParameter("proAddress");
String proFax = request.getParameter("proFax");
String proDesc = request.getParameter("proDesc");
Provider provider = new Provider();
provider.setProCode(proCode);
provider.setProName(proName);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProFax(proFax);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
provider.setCreatedBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId());
provider.setCreationDate(new Date());
boolean flag = false;
flag = providerService.add(provider);
if(flag){
return "redirect:/provider.do?method=query";
// response.sendRedirect(request.getContextPath()+"/jsp/provider.do?method=query");
}else{
return "provideradd";
// request.getRequestDispatcher("provideradd.jsp").forward(request, response);
model.addAttribute("error", "用户名或密码不正确");
return "login";
//.forward(request, response);
}
}
}
public class SysFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
// TODO Auto-generated method stub
// System.out.println("TestFilter init()===========");
}
@Override
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
// TODO Auto-generated method stub
System.out.println("SysFilter doFilter()===========");
HttpServletRequest rq = (HttpServletRequest)request;
HttpServletResponse rp = (HttpServletResponse)response;
User userSession = (User)rq.getSession().getAttribute("userSession");
if(null == userSession){
rp.sendRedirect("/SMBMS/error.jsp");
}else{
chain.doFilter(request, response);
}
}
@Override
public void destroy() {
// TODO Auto-generated method stub
// System.out.println("TestFilter destroy()===========");
}
}
PageSupport pages=new PageSupport();
pages.setCurrentPageNo(currentPageNo);
pages.setPageSize(pageSize);
pages.setTotalCount(totalCount);
int totalPageCount = pages.getTotalPageCount();
//控制首页和尾页
if(currentPageNo < 1){
currentPageNo = 1;
}else if(currentPageNo > totalPageCount){
currentPageNo = totalPageCount;
}
userList = userService.getUserList(queryUserName,queryUserRole,currentPageNo, pageSize);
System.out.println("----------> "+userList.get(0).getAge());
request.setAttribute("userList", userList);
List<Role> roleList = null;
System.out.println(userList.get(0).getRole().getRoleName());
roleList = roleService.getRoleList();
System.out.println("===== "+roleList.get(0).getRoleCode()+"--------roleList:"+roleList.get(0).getRoleName());
request.setAttribute("roleList", roleList);
request.setAttribute("queryUserName", queryUserName);
request.setAttribute("queryUserRole", queryUserRole);
request.setAttribute("totalPageCount", totalPageCount);
request.setAttribute("totalCount", totalCount);
request.setAttribute("currentPageNo", currentPageNo);
return "userlist";
}
private String add(HttpServletRequest request, HttpServletResponse response, User user, BindingResult bindingResult, HttpSession session)
throws ServletException, IOException {
if(bindingResult.hasErrors()){
System.out.println("输入错误");
return "useradd";
}System.out.println("111");
user.setCreatedBy(((User)session.getAttribute(Constants.USER_SESSION)).getId());System.out.println("222");
user.setCreationDate(new Date());System.out.println("333");
if(userService.add(user)){return "redirect:/user.do?method=query";}System.out.println("444");
return "useradd";
}
}
}
//把resultMap转换成json对象输出
// response.setContentType("application/json");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter outPrintWriter = response.getWriter();
outPrintWriter.write(JSONArray.toJSONString(resultMap));
outPrintWriter.flush();
outPrintWriter.close();
}
private void userCodeExist(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//判断用户账号是否可用
String userCode = request.getParameter("userCode");
HashMap<String, String> resultMap = new HashMap<String, String>();
if(StringUtils.isNullOrEmpty(userCode)){
//userCode == null || userCode.equals("")
resultMap.put("userCode", "exist");
}else{
User user = userService.selectUserCodeExist(userCode);
if(null != user){
resultMap.put("userCode","exist");
}else{
resultMap.put("userCode", "notexist");
}
}
//把resultMap转为json字符串以json的形式输出
//配置上下文的输出类型
// response.setContentType("application/json");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
//从response对象中获取往外输出的writer对象
PrintWriter outPrintWriter = response.getWriter();
//把resultMap转为json字符串 输出
outPrintWriter.write(JSONArray.toJSONString(resultMap));
outPrintWriter.flush();//刷新
outPrintWriter.close();//关闭流
}
private void getRoleList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
List<Role> roleList = null;
@Controller
public class ProviderServlet {
@Autowired
BillServiceImpl billService;
@Autowired
ProviderServiceImpl providerService;
@Autowired
UserServiceImpl userService;
@RequestMapping(value="/provider.do",method = {RequestMethod.POST, RequestMethod.GET})
public String doPost(HttpServletRequest request, HttpServletResponse response, @RequestParam(value="method",required = false) String method)
throws ServletException, IOException {
if(method != null && method.equals("query")){
return this.query(request,response);
}else if(method != null && method.equals("add")){
return this.add(request,response);
}else if(method != null && method.equals("view")){
return this.getProviderById(request,response,"providerview");
}else if(method != null && method.equals("modify")){
return this.getProviderById(request,response,"providermodify");
}else if(method != null && method.equals("modifysave")){
return this.modify(request,response);
}else if(method != null && method.equals("delprovider")){
this.delProvider(request,response);
}
return "error";
}
private void delProvider(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String id = request.getParameter("proid");
HashMap<String, String> resultMap = new HashMap<String, String>();
if(!StringUtils.isNullOrEmpty(id)){
int flag = providerService.deleteProviderById(id);
if(flag == 0){//删除成功
resultMap.put("delResult", "true");
}else if(flag == -1){//删除失败
resultMap.put("delResult", "false");
}else if(flag > 0){//该供应商下有订单,不能删除,返回订单数
resultMap.put("delResult", String.valueOf(flag));
}
}else{
resultMap.put("delResult", "notexit");
}
String temp = request.getParameter("queryUserRole");
String pageIndex = request.getParameter("pageIndex");
int queryUserRole = 0;
List<User> userList = null;
//设置页面容量
int pageSize = Constants.pageSize;
//当前页码
int currentPageNo = 1;
System.out.println("queryUserName servlet--------"+queryUserName);
System.out.println("queryUserRole servlet--------"+queryUserRole);
System.out.println("query pageIndex--------- > " + pageIndex);
if(queryUserName == null){
queryUserName = "";
}
if(temp != null && !temp.equals("")){
queryUserRole = Integer.parseInt(temp);
}
if(pageIndex != null){
try{
currentPageNo = Integer.valueOf(pageIndex);
}catch(NumberFormatException e){
return "error";
}
}
//总数量(表)
int totalCount = userService.getUserCount(queryUserName,queryUserRole);
//总页数
PageSupport pages=new PageSupport();
pages.setCurrentPageNo(currentPageNo);
pages.setPageSize(pageSize);
pages.setTotalCount(totalCount);
int totalPageCount = pages.getTotalPageCount();
//控制首页和尾页
if(currentPageNo < 1){
currentPageNo = 1;
}else if(currentPageNo > totalPageCount){
currentPageNo = totalPageCount;
}
userList = userService.getUserList(queryUserName,queryUserRole,currentPageNo, pageSize);