web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0"
metadata-complete="true">
<!-- Spring和mybatis的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring-mybatis.xml</param-value>
</context-param>
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<async-supported>true</async-supported>
<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>
<!-- Spring监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 防止Spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!-- Spring MVC servlet -->
<servlet>
<servlet-name>SpringMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>
**
核心配置文件 spring-mybatis.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-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd ">
<!--支持注解的方式-->
<context:annotation-config/>
<!-- 自动扫描的方式将service 和respository(dao)读取到spring上下文中 -->
<context:component-scan base-package="com" use-default-filters="false" >
<context:include-filter type="annotation" expression="org.springframework.stereotype.Repository"/>
<context:include-filter type="annotation" expression="org.springframework.stereotype.Service"/>
</context:component-scan>
<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://127.0.0.1:3306/user_manage" />
<property name="username" value="root" />
<property name="password" value="1" />
</bean>
<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="configLocation" value="classpath:MyBatisConfig.xml"></property>
</bean>
<!--配置模版类sqlSessionTempalte 这是spring和mybatis集成的核心配置-->
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate" scope="prototype">
<constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
</bean>
<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!--使用注解处理事务,处理spring Service中的 @Transactional注解-->
<tx:annotation-driven proxy-target-class="true" transaction-manager="transactionManager"/>
<!-- 启用自动扫描的方式创建mapper bean -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.learn.chapter2.mapper" />
<property name="sqlSessionTemplateBeanName" value="sqlSessionTemplate"></property>
<property name="annotationClass" value="org.springframework.stereotype.Repository"></property>
</bean>
</beans>
springmvc的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:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/beans/spring-aop-4.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/context/spring-tx-4.0.xsd ">
<mvc:annotation-driven />
<context:component-scan base-package="com.*" />
<!-- 定义跳转的文件的前后缀 ,视图模式配置-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀,变成一个 可用的url地址 -->
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>
</beans>
mybatisConfig.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"/>
<setting name="useGeneratedKeys" value="true"/>
<setting name="defaultExecutorType" value="REUSE"/>
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="defaultStatementTimeout" value="25000"/>
</settings>
<typeAliases>
<typeAlias type="com.learn.chapter2.po.Role" alias="role"/>
</typeAliases>
<!-- 对事务的管理和连接池的配置
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="root" />
<property name="password" value="1" />
</dataSource>
</environment>
</environments>
-->
<mappers>
<mapper resource="com/learn/chapter2/mapper/roleMapper.xml" />
</mappers>
</configuration>
log4j配置文件
log4j.rootLogger=DEBUG,Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d[%t]%-5p[%c]-%m%n
log4j.appender.logfile.File=jbit.log
log4j.logger.com.ibatis=DEBUG
log4j.logger.java.sql.Connection=DEBUGs
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
文件的目录
service和mapper中都定义了方法,类似,实现类如下
@Service
public class RoleServiceImpl implements RoleService{
@Autowired
private RoleMapper roleMapper;
@Transactional(propagation=Propagation.SUPPORTS)
public Role getRole(Long id) {
// TODO Auto-generated method stub
return this.roleMapper.getRole(id);
}
@Transactional(propagation=Propagation.REQUIRED)
public int deleteRole(Long id) {
// TODO Auto-generated method stub
return this.roleMapper.deleteRole(id);
}
@Transactional(propagation=Propagation.REQUIRED)
public int insertRole(Role role) {
// TODO Auto-generated method stub
return this.roleMapper.insertRole(role);
}
@Transactional(propagation=Propagation.SUPPORTS)
public int countFirstName(String firstname) {
// TODO Auto-generated method stub
return this.roleMapper.countFirstName(firstname);
}
@Transactional(propagation=Propagation.SUPPORTS)
public List<Role> findRoleByMap(String roleName, String note) {
// TODO Auto-generated method stub
return this.roleMapper.findRoleByMap(roleName, note);
}
@Transactional(propagation=Propagation.SUPPORTS)
public List<Role> findRoles(String roleName) {
// TODO Auto-generated method stub
return this.roleMapper.findRoles(roleName);
}
@Transactional(propagation=Propagation.REQUIRED)
public void updateRole(String roleName, String note, Long id) {
// TODO Auto-generated method stub
this.roleMapper.updateRole(roleName, note, id);
}
@Transactional(propagation=Propagation.SUPPORTS)
public List<Role> findAll() {
// TODO Auto-generated method stub
return this.roleMapper.findAll();
}
}