赞
踩
XHR:XMLHttpRequest在后台与服务器交换数据。
当前启动的哪个Tomcat,就去看对应的运行日志?Run面板。
log4j.properties 日志的名字
类头注释
*/
xml映射文件:
- <?xml version="1.0" encoding="UTF-8" ?>
- <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://www.mybatis.org/dtd/mybatis-3-mapper.dtd" >
- <mapper namespace="com.crm.mapper.CustomerDao">
-
- <!--查询到的数据的条数-->
- <select id="customCount" parameterType="QueryVo" resultType="Integer">
- select count(1) from customer
- <where>
- <if test="custName!=null and custName!=''">
- cust_name like "%"#{custName}"%"
- </if>
- <if test="custSource!=null and custSource!=''">
- and cust_source = #{custSource}
- </if>
- <if test="custIndustry!=null and custIndustry!=''">
- and cust_industry = #{custIndustry}
- </if>
- <if test="custLevel!=null and custLevel!=''">
- and cust_level = #{custLevel}
- </if>
- </where>
- </select>
-
- <!--通过id查询用户信息-->
- <select id="selectCustomerById" parameterType="Integer" resultType="com.crm.pojo.Customer">
- select * from customer where cust_id=#{id}
- </select>
-
- <update id="updateCustomerById" parameterType="Customer">
- update customer set cust_name=#{cust_name} where cust_id=#{cust_id};
- </update>
-
- <delete id="deleteCustomer" parameterType="Integer">
- delete from customer where cust_id=#{id}
- </delete>
- </mapper>
Controller层代码:
- package com.crm.controller;
-
- import com.crm.pojo.BaseDict;
- import com.crm.pojo.Customer;
- import com.crm.pojo.QueryVo;
- import com.crm.service.BaseCustomerService;
- import com.crm.utils.Page;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.beans.factory.annotation.Value;
- import org.springframework.stereotype.Controller;
- import org.springframework.ui.Model;
- import org.springframework.web.bind.annotation.RequestMapping;
- import org.springframework.web.bind.annotation.RequestMethod;
- import org.springframework.web.bind.annotation.ResponseBody;
-
- import java.util.List;
-
- /**
- * describe:用戶管理控制器
- *
- * @author chenrushui
- * @date 2018/06/14
- */
- @Controller
- @RequestMapping(value = "/customer")
- public class CustomerController {
- //注入成为成员变量:需要被加载的资源文件需要放到spring-mvc配置文件中。
- //这种方式特别好用,不需要通过ResourceBundle进行读取。
- @Value("${fromType.code}")
- private String fromTypeCode;
- @Value("${industryType.code}")
- private String industryTypeCode;
- @Value("${levelType.code}")
- private String levelTypeCode;
-
- @Autowired
- private BaseCustomerService mBaseCustomerService;
-
- /**
- * 展示前端页面
- *
- * @return
- */
- @RequestMapping(value = "/list")
- public String getCustomerList(QueryVo vo, Model model) {
- //特別注意:如何解决硬编码问题?通过注入成员变量的方式进行解决
- List<BaseDict> fromType = mBaseCustomerService.selectCustomerByCode(fromTypeCode);
- List<BaseDict> industryType = mBaseCustomerService.selectCustomerByCode(industryTypeCode);
- List<BaseDict> levelType = mBaseCustomerService.selectCustomerByCode(levelTypeCode);
- //特別注意:键的名称要和jsp页面中获取的一样。
- model.addAttribute("fromType", fromType);
- model.addAttribute("industryType", industryType);
- model.addAttribute("levelType", levelType);
-
- //填充结果数据
- Page<Customer> page = mBaseCustomerService.selectCustomerByQueryVo(vo);
- model.addAttribute("page", page);
-
- //实现数据回显(把数据返回)
- model.addAttribute("custName", vo.getCustName());
- model.addAttribute("custSource", vo.getCustSource());
- model.addAttribute("custIndustry", vo.getCustIndustry());
- model.addAttribute("custLevel", vo.getCustLevel());
- //model内部是通过request域实现的,通过el表达式获取的是哪个变量的值,控件的name属性名
- return "customer";
- }
-
- /**
- * 編輯用戶信息
- *
- * @param id
- * @return
- */
- @RequestMapping(value = "/edit.action", method = RequestMethod.GET)
- @ResponseBody
- public Customer changeCustomerInfo(Integer id) {
- return mBaseCustomerService.selectCustomerById(id);
- }
-
- /**
- * 保存修改的用户信息
- *
- * @param customer
- * @return
- */
- @RequestMapping(value = "/update.action", method = RequestMethod.POST)
- @ResponseBody
- public String updateCustomer(Customer customer) {
- Integer row = mBaseCustomerService.updateCustomerById(customer);
- System.out.print(row + "");
- return "ok";
- }
-
- @RequestMapping(value = "/delete.action", method = RequestMethod.POST)
- @ResponseBody
- public String deleteCustomer(Integer id) {
- Integer row = mBaseCustomerService.deleteCustomer(id);
- System.out.print(row + "受影响的行数");
- return "ok";
- }
- }
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。