Spring-SpringMVC-MyBatis整合
创建实体类：
1 package com.neuedu.ssm.entity; 2 3 public class Employee { 4 5 private Integer id; 6 private String lastName; 7 private boolean gender; 8 private String email; 9 public Employee() { 10 super(); 11 // TODO Auto-generated constructor stub 12 } 13 public Employee(Integer id, String lastName, boolean gender, String email) { 14 super(); 15 this.id = id; 16 this.lastName = lastName; 17 this.gender = gender; 18 this.email = email; 19 } 20 public Integer getId() { 21 return id; 22 } 23 public void setId(Integer id) { 24 this.id = id; 25 } 26 public String getLastName() { 27 return lastName; 28 } 29 public void setLastName(String lastName) { 30 this.lastName = lastName; 31 } 32 public boolean isGender() { 33 return gender; 34 } 35 public void setGender(boolean gender) { 36 this.gender = gender; 37 } 38 public String getEmail() { 39 return email; 40 } 41 public void setEmail(String email) { 42 this.email = email; 43 } 44 @Override 45 public String toString() { 46 return "Employee [id=" + id + ", lastName=" + lastName + ", gender=" 47 + gender + ", email=" + email + "]"; 48 } 49 50 51 52 }
创建service层：
1 package com.neuedu.ssm.service; 2 3 import java.util.List; 4 5 import org.springframework.beans.factory.annotation.Autowired; 6 import org.springframework.stereotype.Service; 7 8 import com.neuedu.ssm.entity.Employee; 9 import com.neuedu.ssm.mapper.EmployeeMapper; 10 11 @Service 12 public class EmployeeService { 13 14 @Autowired 15 private EmployeeMapper mapper; 16 17 public List<Employee> getList(){ 18 19 return mapper.getList(); 20 21 } 22 }
创建mapper接口：
1 package com.neuedu.ssm.mapper; 2 3 import java.util.List; 4 5 import com.neuedu.ssm.entity.Employee; 6 7 public interface EmployeeMapper { 8 9 public List<Employee> getList(); 10 11 12 }
创建controller层：
1 package com.neuedu.ssm.controller; 2 3 import java.util.List; 4 import java.util.Map; 5 6 import org.springframework.beans.factory.annotation.Autowired; 7 import org.springframework.stereotype.Controller; 8 import org.springframework.web.bind.annotation.RequestMapping; 9 10 import com.neuedu.ssm.entity.Employee; 11 import com.neuedu.ssm.service.EmployeeService; 12 13 @Controller 14 public class EmployeeController { 15 16 @Autowired 17 private EmployeeService service; 18 19 @RequestMapping("/getList") 20 public String getList(Map<String, Object> map){ 21 List<Employee> list = service.getList(); 22 map.put("list", list); 23 for (Employee employee : list) { 24 System.out.println(employee); 25 } 26 return "success"; 27 } 28 }
创建jdbc.properties文件：
1 jdbc.jdbcUrl=jdbc:mysql://localhost:3306/mybatis 2 jdbc.driverClass=com.mysql.jdbc.Driver 3 jdbc.user=root 4 jdbc.password=root
创建applicationContext.xml：
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xmlns:p="http://www.springframework.org/schema/p" 5 xmlns:tx="http://www.springframework.org/schema/tx" 6 xmlns:context="http://www.springframework.org/schema/context" 7 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd 8 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd 9 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"> 10 11 <!-- 配置扫描包 --> 12 <context:component-scan base-package="com.neuedu.ssm"> 13 <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> 14 <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/> 15 </context:component-scan> 16 17 <!-- 加载外部文件 --> 18 <context:property-placeholder location="classpath:jdbc.properties"/> 19 20 <!-- 配置数据库连接池 c3p0--> <!-- ComboPooledDataSource存储数据源接口池 --> 21 <bean id="comboPooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> 22 <property name="user" value="${jdbc.user}"></property> 23 <property name="password" value="${jdbc.password}"></property> 24 <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> 25 <property name="driverClass" value="${jdbc.driverClass}"></property> 26 </bean> 27 28 29 <!-- 配置事务管理器 --> 30 <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 31 <constructor-arg name="dataSource" ref="comboPooledDataSource"/> 32 </bean> 33 34 <!-- 开启基于注解的事务 --> 35 <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/> 36 37 38 <!-- 配置 SqlSessionFactory --> 39 <bean class="org.mybatis.spring.SqlSessionFactoryBean"> 40 <property name="dataSource" ref="comboPooledDataSource"></property> 41 <!-- 配置 mybatis 配置文件的位置和名称 --> 42 <property name="configLocation" value="classpath:mybatis-config.xml"></property> 43 </bean> 44 45 <!-- 配置mapper接口扫描包 --> 46 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 47 <property name="basePackage" value="com.neuedu.ssm.mapper"></property> 48 </bean> 49 50 </beans>
创建springMVC.xml：
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xmlns:context="http://www.springframework.org/schema/context" 5 xmlns:mvc="http://www.springframework.org/schema/mvc" 6 xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd 7 http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd 8 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd"> 9 <!-- 配置扫描包，以完成Bean创建和自动依赖注入的功能 --> 10 <context:component-scan base-package="com.neuedu.ssm" use-default-filters="false" > 11 <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/> 12 <context:include-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/> 13 </context:component-scan> 14 15 <!-- 配置springMVC视图解析器,将逻辑视图转换成物理视图 --> 16 <!--(转发) 对转向页面的路径解析。prefix(前缀)+returnVal(方法的返回值)+ suffix(后缀) --> 17 <!-- /WEB-INF/views/+success+.jsp --> 18 <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 19 <property name="prefix" value="/WEB-INF/views/"></property> 20 <property name="suffix" value=".jsp"></property> 21 </bean> 22 23 24 <!-- 如果当前路径是/.. 则交给相应的视图解析器直接解析为视图,不用经过handler方法直接到达目标页面 --> 25 <!-- path="/.."随便指定路径，访问该路径时都可以得到视图： /WEB-INF/views/success.jsp --> 26 <mvc:view-controller path="/" view-name="success"/> 27 28 <!--相当于注册了DefaultAnnotationHandlerMapping和AnnotationMethodHandlerAdapter两个bean， 29 配置一些messageconverter。即解决了@Controller注解的使用前提配置 --> 30 <mvc:annotation-driven/> 31 32 <!-- 对于静态资源文件如【js/css/图片】的访问,需要在spingmvc配置文件中配置一个标签 --> 33 <!--springMVC DispatcherServlet拦截了所有请求，因此需要配置mvc:default-servlet-handler，可以映射静态资源的访问请求 --> 34 <mvc:default-servlet-handler/> 35 </beans>
创建mybatis-config.xml：
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE configuration 3 PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 4 "http://mybatis.org/dtd/mybatis-3-config.dtd"> 5 <configuration> 6 7 <!-- settings标签用于对mybatis的属性设置 8 mapUnderscoreToCamelCase：可以将数据库中下划线分隔的字段转化为 9 JavaBean对象驼峰式命名的属性 10 --> 11 <settings> 12 <!-- 下划线转驼峰式命名 --> 13 <setting name="mapUnderscoreToCamelCase" value="true"/> 14 15 <!-- 开启懒加载机制 ,默认值为true--> 16 <setting name="lazyLoadingEnabled" value="true"/> 17 <!-- 开启的话，每个属性都会直接全部加载出来；禁用的话，只会按需加载出来 --> 18 <setting name="aggressiveLazyLoading" value="false"/> 19 </settings> 20 21 22 </configuration>
web.xml配置：
1 <?xml version="1.0" encoding="UTF-8"?> 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"> 3 <display-name>ssm-integration</display-name> 4 <welcome-file-list> 5 <welcome-file>index.html</welcome-file> 6 <welcome-file>index.htm</welcome-file> 7 <welcome-file>index.jsp</welcome-file> 8 <welcome-file>default.html</welcome-file> 9 <welcome-file>default.htm</welcome-file> 10 <welcome-file>default.jsp</welcome-file> 11 </welcome-file-list> 12 13 <!-- spring IOC容器 --> 14 <context-param> 15 <param-name>contextConfigLocation</param-name> 16 <param-value>classpath:applicationContext.xml</param-value> 17 </context-param> 18 19 <!--spring监听器 框架自带，创建IOC容器 --> 20 <listener> 21 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 22 </listener> 23 24 25 26 <!-- springMVC前端控制器 创建springMVC的IOC容器--> 27 <servlet> 28 <servlet-name>DispatcherServlet</servlet-name> 29 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 30 <init-param> 31 <param-name>contextConfigLocation</param-name> 32 <param-value>classpath:springMVC.xml</param-value> 33 </init-param> 34 <load-on-startup>1</load-on-startup> 35 </servlet> 36 37 <!-- Map all requests to the DispatcherServlet for handling --> 38 <servlet-mapping> 39 <servlet-name>DispatcherServlet</servlet-name> 40 <url-pattern>/</url-pattern> 41 </servlet-mapping> 42 43 44 <!-- 针对POST请求乱码的处理：CharacterEncodingFilter --> 45 <filter> 46 <filter-name>CharacterEncodingFilter</filter-name> 47 <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> 48 <init-param> 49 <param-name>encoding</param-name> 50 <param-value>utf-8</param-value> 51 </init-param> 52 </filter> 53 <filter-mapping> 54 <filter-name>CharacterEncodingFilter</filter-name> 55 <url-pattern>/*</url-pattern> 56 </filter-mapping> 57 58 59 <!--HiddenHttpMethodFilter过滤器：浏览器form表单只支持GET与POST请求，而DELETE、PUT等method并不支持， 60 spring3.0添加了一个过滤器，可以将这些请求转换为标准的http方法，使得支持GET、POST、PUT与DELETE请求 --> 61 <filter> 62 <filter-name>HiddenHttpMethodFilter</filter-name> 63 <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class> 64 </filter> 65 <filter-mapping> 66 <filter-name>HiddenHttpMethodFilter</filter-name> 67 <url-pattern>/*</url-pattern> 68 </filter-mapping> 69 70 </web-app>
pom.xml配置：
1 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 2 <modelVersion>4.0.0</modelVersion> 3 <groupId>com.neuedu.ssm</groupId> 4 <artifactId>ssm-integration</artifactId> 5 <version>0.0.1-SNAPSHOT</version> 6 <packaging>war</packaging> 7 8 <dependencies> 9 <!-- SPRING IOC --> 10 <dependency> 11 <groupId>org.springframework</groupId> 12 <artifactId>spring-beans</artifactId> 13 <version>4.0.0.RELEASE</version> 14 </dependency> 15 16 <dependency> 17 <groupId>org.springframework</groupId> 18 <artifactId>spring-core</artifactId> 19 <version>4.0.0.RELEASE</version> 20 </dependency> 21 22 <dependency> 23 <groupId>org.springframework</groupId> 24 <artifactId>spring-context</artifactId> 25 <version>4.0.0.RELEASE</version> 26 </dependency> 27 28 <dependency> 29 <groupId>org.springframework</groupId> 30 <artifactId>spring-expression</artifactId> 31 <version>4.0.0.RELEASE</version> 32 </dependency> 33 34 <dependency> 35 <groupId>org.springframework</groupId> 36 <artifactId>spring-aspects</artifactId> 37 <version>4.0.0.RELEASE</version> 38 </dependency> 39 <!-- mysql --> 40 <dependency> 41 <groupId>mysql</groupId> 42 <artifactId>mysql-connector-java</artifactId> 43 <version>5.1.37</version> 44 </dependency> 45 <!-- C3P0 --> 46 <dependency> 47 <groupId>com.mchange</groupId> 48 <artifactId>c3p0</artifactId> 49 <version>0.9.5.2</version> 50 </dependency> 51 52 <dependency> 53 <groupId>junit</groupId> 54 <artifactId>junit</artifactId> 55 <version>4.9</version> 56 </dependency> 57 <!-- aop AND Transaction --> 58 <dependency> 59 <groupId>net.sourceforge.cglib</groupId> 60 <artifactId>com.springsource.net.sf.cglib</artifactId> 61 <version>2.2.0</version> 62 </dependency> 63 64 <dependency> 65 <groupId>org.aspectj</groupId> 66 <artifactId>aspectjweaver</artifactId> 67 <version>1.6.8</version> 68 </dependency> 69 70 71 <!-- JDBCTemplate and Transaction --> 72 <dependency> 73 <groupId>org.springframework</groupId> 74 <artifactId>spring-jdbc</artifactId> 75 <version>4.0.0.RELEASE</version> 76 </dependency> 77 <dependency> 78 <groupId>org.springframework</groupId> 79 <artifactId>spring-orm</artifactId> 80 <version>4.0.0.RELEASE</version> 81 </dependency> 82 <dependency> 83 <groupId>org.springframework</groupId> 84 <artifactId>spring-web</artifactId> 85 <version>4.0.0.RELEASE</version> 86 </dependency> 87 <!-- springmvc --> 88 <dependency> 89 <groupId>org.springframework</groupId> 90 <artifactId>spring-webmvc</artifactId> 91 <version>4.0.0.RELEASE</version> 92 </dependency> 93 <!-- upload --> 94 <dependency> 95 <groupId>commons-fileupload</groupId> 96 <artifactId>commons-fileupload</artifactId> 97 <version>1.3.1</version> 98 </dependency> 99 <!-- JSTL --> 100 <dependency> 101 <groupId>org.apache.taglibs</groupId> 102 <artifactId>taglibs-standard-impl</artifactId> 103 <version>1.2.1</version> 104 </dependency> 105 <dependency> 106 <groupId>org.apache.taglibs</groupId> 107 <artifactId>taglibs-standard-spec</artifactId> 108 <version>1.2.1</version> 109 </dependency> 110 111 112 <!--JSON --> 113 <dependency> 114 <groupId>com.fasterxml.jackson.core</groupId> 115 <artifactId>jackson-annotations</artifactId> 116 <version>2.1.5</version> 117 </dependency> 118 119 <dependency> 120 <groupId>com.fasterxml.jackson.core</groupId> 121 <artifactId>jackson-databind</artifactId> 122 <version>2.1.5</version> 123 </dependency> 124 125 <dependency> 126 <groupId>com.fasterxml.jackson.core</groupId> 127 <artifactId>jackson-core</artifactId> 128 <version>2.1.5</version> 129 </dependency> 130 131 132 <!-- jsp-servlet --> 133 <dependency> 134 <groupId>javax.servlet</groupId> 135 <artifactId>servlet-api</artifactId> 136 <version>2.5</version> 137 <scope>provided</scope> 138 </dependency> 139 <dependency> 140 <groupId>javax.servlet</groupId> 141 <artifactId>jsp-api</artifactId> 142 <version>2.0</version> 143 <scope>provided</scope> 144 </dependency> 145 146 147 <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --> 148 <dependency> 149 <groupId>org.mybatis</groupId> 150 <artifactId>mybatis</artifactId> 151 <version>3.4.1</version> 152 </dependency> 153 154 <!-- mybatis-spring整合 --> 155 <dependency> 156 <groupId>org.mybatis</groupId> 157 <artifactId>mybatis-spring</artifactId> 158 <version>1.3.0</version> 159 </dependency> 160 161 162 <!--mysql驱动 --> 163 <dependency> 164 <groupId>mysql</groupId> 165 <artifactId>mysql-connector-java</artifactId> 166 <version>5.1.37</version> 167 </dependency> 168 <!-- oracle驱动 --> 169 <dependency> 170 <groupId>ojdbc</groupId> 171 <artifactId>ojdbc</artifactId> 172 <version>6</version> 173 </dependency> 174 <!-- https://mvnrepository.com/artifact/log4j/log4j --> 175 <dependency> 176 <groupId>log4j</groupId> 177 <artifactId>log4j</artifactId> 178 <version>1.2.17</version> 179 </dependency> 180 181 </dependencies> 182 183 <!--tomcat7插件 --> 184 <build> 185 <plugins> 186 <plugin> 187 <groupId>org.apache.tomcat.maven</groupId> 188 <artifactId>tomcat7-maven-plugin</artifactId> 189 <version>2.2</version> 190 <configuration> 191 <path>/ssm-integration</path> 192 <port>8080</port> 193 </configuration> 194 </plugin> 195 </plugins> 196 </build> 197 198 199 </project>
运行结果：
884
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
