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"/>
<!-- 配置默認執(zhí)行器 Reuse 重用預處理語句 -->
<setting name="defaultExecutorType" value="REUSE"/>
<!-- 全局啟用延遲加載 -->
<setting name="lazyLoadingEnabled" value="true"/>
<!-- 設置超時時間,決定驅動等待一個數(shù)據(jù)庫相應的時間 -->
<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.導入數(shù)據(jù)庫相關參數(shù)properties的屬性 -->
<context:property-placeholder location="classpath:jdbcMysql.properties"/>
<!-- 2.設置數(shù)據(jù)庫信息等 -->
<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">
<!-- 注入數(shù)據(jù)庫連接池 -->
<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" />
<!-- 事務管理器配置數(shù)據(jù)源事務 -->
<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 />
<!-- 靜態(tài)資源映射,用于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">