jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatisdemo
jdbc.username=root
jdbc.password=

# Global logging configuration，建议开发环境要用debug
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

items.name LIKE '%${itemsCustom.name}%'SELECT items.* FROM items

public interface ItemsMapperCustom {//商品查询列表public List findItemsList(ItemsQueryVo itemsQueryVo) throws Exception;
}

package joanna.yan.ssm.service;import java.util.List;import joanna.yan.ssm.po.ItemsCustom;import joanna.yan.ssm.po.ItemsQueryVo;public interface ItemsService {//商品查询列表public List findItemsList(ItemsQueryVo itemsQueryVo) throws Exception;
}

package joanna.yan.ssm.service.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import joanna.yan.ssm.mapper.ItemsMapperCustom;import joanna.yan.ssm.po.ItemsCustom;import joanna.yan.ssm.po.ItemsQueryVo;import joanna.yan.ssm.service.ItemsService;public class ItemsServiceImpl implements ItemsService{
    
    @Autowiredprivate ItemsMapperCustom itemsMapperCustom;

    @Overridepublic List findItemsList(ItemsQueryVo itemsQueryVo)throws Exception {//通过ItemsMapperCustom查询数据库return itemsMapperCustom.findItemsList(itemsQueryVo);
    }
}

  SpringMVC_MyBatis
  index.jsp
  

  
    springmvc  org.springframework.web.servlet.DispatcherServlet      contextConfigLocation  classpath:spring/springmvc.xml      1
  
  
    springmvc    *.action
  
  

@Controllerpublic class ItemsController {
    
    @Autowiredprivate ItemsService itemsService;//商品查询http://localhost:8080/SpringMVC_MyBatis/queryItems.action@RequestMapping("/queryItems")public ModelAndView queryItems() throws Exception{//调用service查找数据库，查询商品列表List itemsList=itemsService.findItemsList(null);        //返回ModelAndViewModelAndView modelAndView=new ModelAndView();
        modelAndView.addObject("itemsList", itemsList);//指定视图//        modelAndView.setViewName("/WEB-INF/jsp/items/itemsList.jsp");//下边的路径，如果在视图解析器中配置jsp路径的前缀和jsp路径的后缀，修改为modelAndView.setViewName("items/itemsList");return modelAndView;
    }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@ taglib uri="" prefix="c" %><%@ taglib uri=""  prefix="fmt"%> 
查询条件：商品列表：
商品名称
商品价格
生产日期
商品描述
操作
${item.name }
${item.price }
${item.detail }
修改

  
    contextConfigLocation  /WEB-INF/classes/spring/applicationContext-*.xml
  
    org.springframework.web.context.ContextLoaderListener