19.1 SSM框架整合所需JAR包
1、spring下required中的所有jar
2、mybatis下所有的依赖包和核心包
3、aoplliance-1.0.jar
4、aspectjweaver-1.9.2.jar
5、数据库连接池的jar,commons-dbcp2-2.2.0.jar,commons-pool2-2.5.0.jar
5、spring和mybatis的中间jar:mybatis-spring-1.3.1.jar
19.2 SSM框架整合应用测试
1、导入相关JAR包
2、创建信息输入页面
WebContent目录下创建input.jsp页面:
<body>
<form action="${pageContext.request.contextPath }/select" method="post">
<p>输入用户名:</p>
<input type="text" name="uname" /><br />
<input type="submit" value="提交">
</form>
</body>
3、创建持久化类
con.poxia创建MyUser:
private Integer uid;
private String uname;
private String usex;
4、创建Dao层
com.dao包下创建UserDao的接口,注意要使用@Mapper注解自动装配为MyBatis的映射接口,具体代码如下:
@Repository("usreDao")
@Mapper
public interface UserDao {
public List<MyUser> selectUserByUname(MyUser user);
}
5、创建Service层
com.service包下创建UserService的接口和他的实现类UserServiceImpl:
UserServiceImpl代码如下:
@Service("userService")
@Transactional
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public List<MyUser> selectUserByUname(MyUser user) {
return userDao.selectUserByUname(user);
}
}
6、创建Controller层
com.controller包下创建UserController的控制器类:
public class UserController {
@Autowired
private UserDao userDao;
@RequestMapping("/select")
public String select(MyUser user,Model model){
List<MyUser> list = userDao.selectUserByUname(user);
model.addAttribute("userList",list);
return "userList";
}
}
7、创建用户信息显示页面
WEB-INF目录下创建文件夹JSP,的userList.jsp代码如下:
<body>
<p>用户信息</p>
<c:forEach item="${userList }" var="user">
${user.uid } ;
${user.uname } ;
${user.usex };<br />
</c:forEach>
</body>
8、创建相关配置文件
1、web.xml中实例化ApplicationContext容器,启动Spring容器,配置DispatcherServlet以及配置字符编码过滤器
<!-- 实例化ApplicationContext容器 -->
<context-param>
<!-- 加载src目录下的applicationContext.xml文件 -->
<param-name>contextConfigLocation</param-name>
<param-value>
classpath:applicationContext.xml
</param-value>
</context-param>
<!-- 指定以ContextLoaderListtener方式启动Spring容器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置DispatcherServlet -->
<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/springmvc-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 避免中文乱码 -->
<filter>
<filter-name>characterEncodingFilter</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>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
2、spring-servlet.xml,配置控制器扫描包和视图解析器:
<!-- 扫描路径 -->
<context:component-scan base-package="controller"></context:component-scan>
<!-- 使注释生效 -->
<mvc:annotation-driven></mvc:annotation-driven>
<!-- 配置视图解析器 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver"
id="internalResourceViewResolver">
<!-- 前缀 -->
<property name="prefix" value="/WEB-INF/jsp/"></property>
<!-- 后缀 -->
<property name="suffix" value=".jsp"></property>
</bean>
3、log4j.properties
在src目录下创建MyBatis的日志文件log4j.properties,代码如下:
# Global logging configuration**
log4j.rootLogger=ERROR, stdout
**# MyBatis logging configuration...**
log4j.logger.com.mybatis=DEBUG
**# 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
4、applicationContext.xml
在src目录下的applicationContext.xml中配置数据源,添加事务支持,开启事务注解,配置mybatis工厂,进行Mapper代理开发以及制定扫描包,代码如下:
<!-- 指定需要扫描的包,使注解生效 -->
<context:component-scan base-package="com.service"></context:component-scan>
<context:property-placeholder location="classpath:db.properties" />
<!-- 配置数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="username" value="${user}"></property>
<property name="password" value="${password}"></property>
<property name="driverClassName" value="${driverclass}"></property>
<property name="url" value="${jdbcurl}"></property>
<!-- 配置最大连接数 -->
<property name="maxTotal" value="30"></property>
<!-- 最大空间连接数 -->
<property name="maxIdle" value="10"></property>
<!-- 初始化连接数 -->
<property name="initialSize" value="5"></property>
</bean>
<!-- 添加事务支持 -->
<bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 开启事务注解 -->
<tx:annotation-driven transaction-manager="txManager" />
<!-- 配置MyBatis工厂,同时指定数据源,并与MyBatis完美整合 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- configLocation的属性值为MyBatis的核心配置 -->
<property name="configLocation" value="classpath:com/mybatis/mybatis-config.xml"></property>
</bean>
<!-- Mapper 代理开发,使用Spring自动扫描MyBatis的接口并装配 Spring将指定包中所有被 @Mapper注解标注的接口自动装配为MyBatis的映射接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.dao"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
5、创建mybatis的核心配置文件和SQL映射文件
在src目录下创建com.mybatis文件夹,并创建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>
<mappers>
<mapper resource="com/mybatis/UserMapper.xml" />
</mappers>
</configuration>
6、在此文件夹下创建SQL映射文件UserMapper.xml,代码如下:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.UserDao">
<!-- 查询用户信息,id的值对应dao的接口方法 -->
<select id="selectUserByUname" resultType="com.po.MyUser"
parameterType="com.po.MyUser">
select * from user where 1=1
<if test="uname!=null and uname!=''">
and uname like concat('%',${uname},'%')
</if>
</select>
</mapper>