主要用于后期回头再学习,因为后面要用springboot来开发项目,之前的知识可能会有所淡忘。
我主要使用IDEA开发,所以在开发前先把基本的东西先配置好。如下图:
文件结构图
一、首先配置mybatis+spring的整合
1. 配置web.xml
<!--解决编码问题-->
<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>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--配置spring-mybatis的配置-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/spring-*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
2. 配置spring-mybatis.xml文件
<mvc:property-placeholder location="classpath:db.properties"></mvc:property-placeholder>
<!--配置Druid线程池-->
<bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
<property name="username" value="${mysql.username}"></property>
<property name="password" value="${mysql.password}"></property>
<property name="url" value="${mysql.url}"></property>
<property name="initialSize" value="${mysql.initialSize}"></property>
<property name="minIdle" value="${mysql.minIdle}"></property>
<property name="maxActive" value="${mysql.maxActive}"></property>
<property name="maxWait" value="${mysql.maxWait}"></property>
<!--连接池最小生命周期-->
<property name="minEvictableIdleTimeMillis" value="${mysql.minEvictableIdleTimeMillis}"></property>
</bean>
<!--配置SqlsessionFactory 并扫描mapper的xml文件-->
<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactory">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatisConfig.xml"></property>
<property name="typeAliasesPackage" value="cn.spring.po"></property>
<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
</bean>
<!--引用sqlsessionfactory 并扫描接口-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
<property name="basePackage" value="cn.spring.dao"></property>
</bean>
<!--事务-->
<bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--高级处理-->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="insert*" propagation="REQUIRED"/>
<tx:method name="update*" propagation="REQUIRED"/>
<tx:method name="delete*" propagation="REQUIRED"/>
<tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
</tx:attributes>
</tx:advice>
<!--aop设置-->
<aop:config>
<aop:advisor advice-ref="txAdvice" pointcut="execution(* cn.spring.service.*.*(..))"></aop:advisor>
</aop:config>
3. 配置UserMapper.xml文件和UserMapper接口
接口:
public interface UserMapper {
public List<User> selectAll()throws Exception;
}
xml文件:
<mapper namespace="cn.spring.dao.UserMapper">
<resultMap id="selectAllMap" type="user">
<id column="id" property="id"></id>
<result column="username" property="userName"></result>
<result column="sex" property="sex"></result>
<result column="birthday" property="birthday"></result>
<result column="address" property="address"></result>
</resultMap>
<select id="selectAll" resultMap="selectAllMap">
SELECT * FROM user
</select>
</mapper>
4. 配置pojo类
package cn.spring.po;
import java.util.Date;
/**
* @author:
* @date:2018/1/12 20:26
* @version:
* @copyright:
*/
public class User {
private int id;
private String userName;
private String sex;
private Date birthday;
private String address;
@Override
public String toString() {
return "User{" +
"id=" + id +
", userName='" + userName + '\'' +
", sex='" + sex + '\'' +
", birthday=" + birthday +
", address='" + address + '\'' +
'}';
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
5. 测试
@Test
public void test1() throws Exception {
ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("spring/spring-mybatis.xml");
UserMapper userMapper = (UserMapper)context.getBean("userMapper");
List<User> users = userMapper.selectAll();
for(User user:users){
System.out.println(user);
}
}
6. 测试结果图
二、整合springmvc,成ssm框架
- 配置完整的web.xml文件
<!--解决编码问题-->
<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>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--配置spring-mybatis的配置-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/spring-*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--配置前端控制器 restful-->
<servlet>
<servlet-name>DispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/springmvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>DispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
- 编写自定义异常类
@Component
public class CustomExceptionResolver implements HandlerExceptionResolver{
@Override
public ModelAndView resolveException(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse,
Object o, Exception e) {
ModelAndView mv = new ModelAndView();
CustomException ex = null;
if(e instanceof CustomException){
ex = (CustomException)e;
}else{
ex = new CustomException("未知异常");
}
mv.addObject("error",ex.getMessage());
mv.setViewName("error");
return mv;
}
}
- 编写自定义解析日期类
public class CustomDateConverter implements Converter<String,Date> {
@Override
public Date convert(String s) {
try {
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
Date date = sf.parse(s);
return date;
} catch (ParseException e) {
e.printStackTrace();
}
return null;
}
}
- 编写springmvc.xml配置文件
<!--组件扫描-->
<context:component-scan base-package="cn.spring"/>
<!--这里可以自动加载多种配置,像映射处理器等-->
<mvc:annotation-driven conversion-service="conversionService"/>
<mvc:resources mapping="/WEB-INF/**" location="/WEB-INF/"/>
<!--要设置id不然会出错-->
<bean id="conversionService" class="org.springframework.format.support.FormattingConversionServiceFactoryBean">
<property name="converters">
<list>
<bean class="cn.spring.converter.CustomDateConverter"></bean>
</list>
</property>
</bean>
<!--视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!--这里要设置id不然找不到 文件上传配置-->
<bean class="org.springframework.web.multipart.commons.CommonsMultipartResolver" id="multipartResolver">
<property name="maxUploadSize" value="52428800"></property>
</bean>
- 编写service
@Service
public class UserService implements IUserService {
@Autowired
UserMapper userMapper;
@Override
public List<User> findAllUsers() throws Exception {
List<User> list = userMapper.selectAll();
return list;
}
}
- 编写controller
@Controller
public class IndexController {
@Autowired
IUserService userService;
@RequestMapping(value = "/")
public String index(Model model) throws Exception {
List<User> users = userService.findAllUsers();
model.addAttribute("users",users);
return "index";
}
}
- 编写index.jsp页面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<c:forEach var="item" items="${requestScope.users}">
<p>${item.id} ${item.userName} ${item.sex} ${item.birthday} ${item.address}</p>
</c:forEach>
</body>
</html>
- 测试
以上完成了整合,还有许多功能没写上,因为时间关系下次有时间补上,比如文件监听上传,实现进度条的上传等。这里完成了一个简单的demo,用于以后复习。