web.xml
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1" metadata-complete="true">
<display-name>Archetype Created Web Application</display-name>
<!-- 配置DispatchServlet -->
<!-- servlet-name : dispatcher 即找到/WEB-INF/dispatcher-servlet.xml载入Web工程 -->
<servlet>
<servlet-name>dispatcher</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/spring-*.xml</param-value>
</init-param>
<!-- 使DispatchServlet在服务器启动的时候就初始化 -->
<load-on-startup>2</load-on-startup>
</servlet>
<!-- Servlet 拦截配置 -->
<servlet-mapping>
<servlet-name>dispatcher</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
mybatis-config.xml
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 全局映射器启用缓存 -->
<setting name="cacheEnabled" value="true"/>
<!-- 允许JDBC支持生成的键 -->
<setting name="useGeneratedKeys" value="true"/>
<!-- 配置默认执行器 Reuse 重用预处理语句 -->
<setting name="defaultExecutorType" value="REUSE"/>
<!-- 全局启用延迟加载 -->
<setting name="lazyLoadingEnabled" value="true"/>
<!-- 设置超时时间,决定驱动等待一个数据库相应的时间 -->
<setting name="defaultStatementTimeout" value="2500"/>
</settings>
</configuration>
spring文件夹下三个xml配置文件,spring-dao.xml,spring-service.xml,spring-mvc.xml
spring-dao.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 存放 spring整合mybatis过程 -->
<!-- 1.导入数据库相关参数properties的属性 -->
<context:property-placeholder location="classpath:jdbcMysql.properties"/>
<!-- 2.设置数据库信息等 -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
</bean>
<!-- 3.配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入数据库连接池 -->
<property name="dataSource" ref="dataSource"/>
<!-- 导入mybatis的配置文件:mybatis-config.xml -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!-- 设置一下两个属性,则不用在mabatis-config.xml中再设置别名和mapper的为止 -->
<!-- 扫描pojo包 使用别名-->
<property name="typeAliasesPackage" value="com.shpun.pojo"/>
<!-- 扫描sql配置文件:mapper需要的xml文件-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!-- 4.自动扫描配置Mapper的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 指定Spring扫描的包 -->
<property name="basePackage" value="com.shpun.dao"/>
<!-- 指定Spring中SqlSessionFactory的Bean的名称 -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!-- 指定类被注解标识才扫描 @Repository -->
<property name="annotationClass" value="org.springframework.stereotype.Repository"/>
</bean>
</beans>
spring-service.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 扫描service包下所有使用注解的类型 -->
<context:component-scan base-package="com.shpun.service" />
<!-- 事务管理器配置数据源事务 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 启用注解的声明式事务 -->
<tx:annotation-driven transaction-manager="transactionManager" />
</beans>
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 配置SpringMVC 即以前的 dispatch-servlet.xml -->
<!-- 使用注解驱动 -->
<mvc:annotation-driven />
<!-- 静态资源映射,用于css,js,png等 -->
<mvc:resources location="/WEB-INF/js/" mapping="/js/**"/>
<mvc:resources location="/WEB-INF/css/" mapping="/css/**"/>
<!-- 扫描包下注解 -->
<context:component-scan base-package="com.shpun.controller" />
<!-- 定义视图解析器 -->
<!-- 找到/WEB-INF/jsp文件夹下,且文件后缀为.jsp的文件座位映射 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>
</beans>
Controller
HomeController
package com.shpun.controller;
@Controller
@RequestMapping("/home")
public class HomeController {
@Autowired
private CustomerService customerService = null;
@RequestMapping(value = "/get",method = RequestMethod.GET)
public ModelAndView getHome(){
List<Customer> customerList = customerService.selectAllCustomer();
ModelAndView mv = new ModelAndView();
mv.setViewName("Home");
mv.addObject("customerList",customerList);
return mv;
}
}
CustomerController
package com.shpun.controller;
@Controller
@RequestMapping("/customer")
public class CustomerController {
@Autowired
private CustomerService customerService = null;
// 跳转到添加Customer的jsp
@RequestMapping(value = "/add",method = RequestMethod.GET)
public ModelAndView addCustomer(){
System.out.println("to AddCustomer.jsp");
ModelAndView mv = new ModelAndView();
mv.setViewName("AddCustomer");
return mv;
}
// 添加完Customer后重定向到home的jsp
@RequestMapping(value = "/toAdd",method = RequestMethod.POST)
public String toAddCustomer(Customer customer){
System.out.println("to insert customer:"+customer);
customerService.insertCustomer(customer);
System.out.println("to insert over customer:"+customer);
return "redirect:/home/get";
}
// 删除完Customer后重定向到home的jsp
@RequestMapping(value = "/toDelete",method = RequestMethod.GET)
public String toDeleteCustomer(@RequestParam("id")String id){
System.out.println("to delete customer id :"+id);
customerService.deleteCustomer(id);
System.out.println("to delete over customer id :"+id);
return "redirect:/home/get";
}
// 跳转到更新Customer的jsp
@RequestMapping(value = "/edit",method = RequestMethod.GET)
public ModelAndView editCustomer(@RequestParam("id")String id){
System.out.println("to EditCustomer.jsp :");
Customer customer = customerService.selectCustomer(id);
ModelAndView mv = new ModelAndView();
mv.setViewName("EditCustomer");
mv.addObject("customer",customer);
return mv;
}
// 更新完Customer后重定向到home的jsp
@RequestMapping(value = "/toEdit",method = RequestMethod.POST)
public String toUpdateCustomer(Customer customer){
System.out.println("to update customer :"+customer);
customerService.updateCustomer(customer);
System.out.println("to update over customer :"+customer);
return "redirect:/home/get";
}
// 跳转到查询Customer页面
@RequestMapping(value = "/search",method = RequestMethod.GET)
public ModelAndView searchCustomer(){
System.out.println("to SearchCustomer.jsp :");
ModelAndView mv = new ModelAndView();
mv.setViewName("SearchCustomer");
return mv;
}
// 跳转到查询Customer页面
@RequestMapping(value = "/toSearch",method = RequestMethod.POST)
public ModelAndView toSearchCustomer(Customer customer){
System.out.println("to search");
List<Customer> customerList = customerService.searchCustomers(customer);
ModelAndView mv = new ModelAndView();
mv.setViewName("SearchCustomerResult");
mv.addObject("customerList",customerList);
return mv;
}
}
PS:
springMVC传值到jsp失败,可能是忘记修改web.xml的webapp
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1" metadata-complete="true">
网友评论