使用ssm框架实现用户账户邮箱激活功能（二）

    在上一篇中完成了一些准备性的工作，在这一篇中来记录一下框架整合的工作。

    首先是准备所需要的jar包，由于没有使用maven，所以所需要的jar包就提前下载好了，其中黄色的jar包是和邮件发送相关的包，其他的则是框架相关的包。

    主要的配置文件如图

    web.xml文件的掌管着整个项目的主要配置：

<?xml version="1.0" encoding="UTF-8"?>
<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_3_0.xsd" metadata-complete="true" version="3.0">
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring/spring-config.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <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-mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcher</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>
  <filter>
  	<filter-name>CharFilter</filter-name>
  	<filter-class>me.reg.filter.CharFilter</filter-class>
  	<init-param>
  		<param-name>charEncoding</param-name>
  		<param-value>utf-8</param-value>
  	</init-param>
  </filter>
  <filter-mapping>
  	<filter-name>CharFilter</filter-name>
  	<url-pattern>*.do</url-pattern>
  </filter-mapping>
  
  <session-config>
    <session-timeout>30</session-timeout>
  </session-config>
</web-app>

    spring-config.xml中数据源、sqlSessionFactory、事务管理等：

<?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:aop="http://www.springframework.org/schema/aop"
    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/tx
		http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
        

	<context:component-scan base-package="me.reg"/>

<tx:annotation-driven transaction-manager="txManager"/>
	<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
	    <property name="locations" value="classpath:jdbc.properties"/>
	</bean>
	
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${driver}"/>
		<property name="url" value="${url}"/>
		<property name="username" value="${username}"/>
		<property name="password" value="${password}"/>
	</bean>
	
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	  <property name="dataSource" ref="dataSource" />
	  <property name="mapperLocations" value="classpath*:mybatis/mapper/**/*.xml" />
	  <property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/>
	</bean>
	
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	  <property name="basePackage" value="me/reg/mapper" />
	  <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
	</bean>
	
	<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"/>
	</bean>
	
	
	
</beans>

spring-mvc.xml则配置了controller：

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    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
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
 
    <context:component-scan base-package="me.reg.controller"/>
   
    <mvc:annotation-driven/>
    </beans>

mybatis-config.xml配置了domain的别名：

<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

	<typeAliases>
		<typeAlias type="me.reg.domain.User" alias="user"/>
	</typeAliases>
	
</configuration>

UserMapper.xml保存了对user表操作的语句：

<?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="me.reg.mapper.UserMapper">
	<resultMap id="UserResultMapper" type="User">
		<id property="id" column="id"/>
		<result property="username" column="username"/>
		<result property="password" column="password"/>
		<result property="email" column="email"/>
		<result property="state" column="state"/>
		<result property="code" column="code"/>
	</resultMap>
	<select id="queryUser" parameterType="String" resultMap="UserResultMapper">
		select id,username,password,email,state,code from user where code = #{code};
	</select>
	<select id="queryUserByName" parameterType="String" resultMap="UserResultMapper">
		select id,username,password,email,state,code from user where username = #{username};
	</select>
	<insert id="createUSeer" parameterType="User" useGeneratedKeys="true" keyProperty="id">
		insert into user(username,password,email,state,code) values(#{username},#{password},#{email},#{state},#{code});
	</insert>
	<update id="modifyUser" parameterType="User">
		update user 
		<set>
			<if test="username!=null">
				username = #{username},
			</if>
			<if test="password!=null">
				password = #{password},
			</if>
			<if test="email!=null">
				email = #{email},
			</if>
			<if test="state!=null">
				state = #{state},
			</if>
			<if test="code!=null">
				code = #{code}
			</if>
		</set>
		where code=#{code}
	</update>
	
	</mapper>

jdbc.properties则是保存了连接数据库的信息：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/res?userUnicode=true&characterEncoding=UTF8&useSSL=false
username=root
password=123456

至此，项目的架子就搭建好了