SSM(Spring,SpringMVC,Mybatis)项目整合配置与应用

项目视图：

1.配置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" id="WebApp_ID" version="3.0">
<display-name>Sport</display-name>
<!-- 加载spring容器 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/applicationContext-*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<!-- springmvc前端控制器 -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- contextConfigLocation配置springmvc加载的配置文件 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/springmvc.xml</param-value>
</init-param>
</servlet>

<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>*.action</url-pattern>
</servlet-mapping>
</web-app>

2.
（1）配置springmvc.xml

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
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-3.2.xsd 
 http://www.springframework.org/schema/mvc 
 http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
 http://www.springframework.org/schema/context 
 http://www.springframework.org/schema/context/spring-context-3.2.xsd 
 http://www.springframework.org/schema/aop 
 http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
 http://www.springframework.org/schema/tx 
 http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">

<!-- 扫描controller注解,多个包中间使用半角逗号分隔 -->
<context:component-scan base-package="com.sport.controller" />
<!-- 注解驱动器，配置后，可以扫描注解 -->
<mvc:annotation-driven />
<!-- ViewResolver -->
<bean
 class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass"
value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/" />
<property name="suffix" value=".jsp" />
</bean> 
</beans>

（2）配置mybatis所需的文件：
1.db.properties:

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/数据库名
jdbc.username=用户名
jdbc.password=密码

2.配置sqlMapConfig.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="lazyLoadingEnabled" value="false" />
</settings>
<!--自定义别名-->
<typeAliases>
<package name="com.sport.po" />
</typeAliases>
</configuration>

3.在Spring容器中整合Mybatis：
配置所需的数据源，数据连接池，mapper扫描器

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

<!--加载mybatis所需的db.properties-->
<context:property-placeholder location="classpath:mybatis/db.properties" />
<!-- 配置数据源 ，dbcp -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive" value="30" />
<property name="maxIdle" value="5" />
</bean>
<!-- sqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 数据库连接池 -->
<property name="dataSource" ref="dataSource" />
<!-- 加载mybatis的全局配置文件 -->
<property name="configLocation" value="classpath:mybatis/sqlMapConfig.xml" />
</bean>
<bean id="sqlTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<!-- mapper扫描器 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.sport.mapper"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>
</beans>

4.Spring中配置Service层：

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
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-3.2.xsd 
 http://www.springframework.org/schema/mvc 
 http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
 http://www.springframework.org/schema/context 
 http://www.springframework.org/schema/context/spring-context-3.2.xsd 
 http://www.springframework.org/schema/aop 
 http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
 http://www.springframework.org/schema/tx 
 http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
<!-- 会自动扫描注解 -->
<context:component-scan base-package="com.sport.service" />
</beans>

登录测试Demo:

登录成功跳转页面：

1：mapper层
通过用户名和密码，查询数据库中是否存在。

public interface AccountMapper {
//用户名和管理员登录
public User userLogin(User user);
public Manager managerLogin(Manager manager);   
}

注意:
mapper.xml的namespace就是mapper接口的完成路径。mapper.xml中的id和mapper接口的方法名相对应，接受参数和返回参数的类型，都一一对应。

<mapper namespace="com.sport.mapper.AccountMapper">
    <select id="userLogin" resultType="com.sport.po.User" parameterType="com.sport.po.User">
select * from user where username=#{username} and password=#{password}
    </select>

    <select id="managerLogin" resultType="com.sport.po.Manager" parameterType="com.sport.po.Manager">
select * from manager where loginname=#{loginname} and password=#{password}
    </select>

2.Service层：

@Service
//@Service标识这是一个service层，相当于配置文件中的<context:component-scan base-package="com.sport.service" />
public class AccountService {
@Autowired//自动将这个mapper接口注入
private AccountMapper accountMapper;

public User userLogin(User user){
return accountMapper.userLogin(user);
    }

public Manager managerLogin(Manager manager){
return accountMapper.managerLogin(manager);
    }   
}

如果这里将注解去掉 如：

public class AccountService {

private AccountMapper accountMapper;

public User userLogin(User user){
return accountMapper.userLogin(user);
    }

public Manager managerLogin(Manager manager){
return accountMapper.managerLogin(manager);
    }   
}

在配置文件中，将
<context:component-scan base-package="com.sport.service" />替换成

<bean id="accountService" class="com.sport.service.AccountService">
        <property name="accountMapper" ref="accountMapper"></property>
    </bean>

3.Controller层:

@Controller
public class AccountAction {

    @Autowired
private AccountService accountService;
//登录
//表示通过LoginAction.action能访问到这个方法
    @RequestMapping("/LoginAction.action")
//从jsp接受的参数，注意这里和jsp标签的name应该一一对应。
public String login(String login_name,String password,String role,HttpSession session){
if(role.equalsIgnoreCase("user")){
            User user=new User();
            user.setPassword(password);
            user.setUsername(login_name);
            System.out.println(user);
            user=accountService.userLogin(user);
            System.out.println("login:"+user);
if(user!=null){
                session.setAttribute("user", user);
return "User1";
//返回的值表示所要返回的页面，这里指登录成功后的跳转
            }
        }else if(role.equalsIgnoreCase("manager")){
            Manager manager=new Manager();
            manager.setLoginname(login_name);
            manager.setPassword(password);
            System.out.println(manager);
            manager=accountService.managerLogin(manager);
            System.out.println("login:"+manager);
if(manager!=null){
                session.setAttribute("manager", manager);
return "manager";
            }
        }
return null;
    }
    }