SpringMVC+Spring+Mybatis整合注解模式

项目结构

[学习记录]SSM框架整合，注解，简洁_xml

打????的地方是我测试用的，怕混淆所以????了

开始项目

环境Eclipse，jdk1.8，spring4.3，Myba3.5

jar包准备

[学习记录]SSM框架整合，注解，简洁_spring_02

springMVC和spring的jar都在一起下载，Mybatis包可去官网下载​

数据库配置文件jdbc.properties

database.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull
database.username=root
database.password=root
database.driverClassName=com.mysql.jdbc.Driver

编写spring配置文件spring-config.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.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd
       ">

  <!-- 加载配置文件 -->
  <context:property-placeholder
    location="classpath:jdbc.properties" />

  <!-- 配置数据源 -->
  <bean id="dataSource"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName"
      value="${database.driverClassName}" />
    <property name="url" value="${database.url}" />
    <property name="username" value="${database.username}" />
    <property name="password" value="${database.password}" />
  </bean>

  <!-- sqlSessionFactory -->
  <bean id="sqlSessionFactory"
    class="org.mybatis.spring.SqlSessionFactoryBean">
    <!-- 加载 MyBatis 的配置文件 -->
    <property name="configLocation"
      value="classpath:mybatis-config.xml" />
    <!-- 数据源 -->
    <property name="dataSource" ref="dataSource" />
  </bean>
<context:component-scan
    base-package="com.org" /> <!-- 注解扫描 -->
  <!-- 定义事务管理器 -->
  <bean id="transactionManager"
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
  </bean>
  <bean id="testDao" class="com.org.dao.impl.TestDaoImpl">
    <property name="sqlSessionFactory" ref="sqlSessionFactory" />
  </bean>

</beans>

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>

  <typeAliases>
    <package name="com.org.entity" />
  </typeAliases>

  <mappers>
    <mapper resource="com/org/entity/User.xml" />
  </mappers>
</configuration>

Mybatis映射文件以及其他文件

User实体类
package com.org.entity;

public class User {
  private Integer id;
  private String name;
  private String password;
  public Integer getId() {
    return id;
  }
  public void setId(Integer id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public String getPassword() {
    return password;
  }
  public void setPassword(String password) {
    this.password = password;
  }
  @Override
  public String toString() {
    return "User [id=" + id + ", name=" + name + ", password=" + password + "]";
  }
}
User.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="user">
  <select id="findUser" resultType="User">
    select * from user
  </select>
  <insert id="insertUser" parameterType="User">
    insert into user
    (name,password) values (#{name},#{password})
  </insert>
  <update id="updateUser" parameterType="User">
    update user set name = #{name} ,password = #{password} where id = #{id}
  </update>

  <delete id="deleteUser" parameterType="_int">
      delete  from user where id = #{id}
  </delete>

</mapper>

编写dao层

接口类TestDao

package com.org.dao;

import java.util.List;
import com.org.entity.User;

public interface TestDao {
  List<User> findUser() ;
  void updateUser(User user) ;
  void insertUser(User user);
  void deleteUserById(Integer id);
}

实现类TestDaoImpl

package com.org.dao.impl;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.stereotype.Repository;

import com.org.dao.TestDao;
import com.org.entity.User;
import com.org.utils.MyBasisUtils;

public class TestDaoImpl extends SqlSessionDaoSupport implements TestDao {


//  @Test

  @Override
  public void insertUser(User user) {
    SqlSession session = this.getSqlSession();
    session.insert("user.insertUser", user);  //此处的user.insertUser，user对应User.xml中的命名空间
    session.commit();
    session.close();

  }

  @Override
  public void updateUser(User user) {
    SqlSession session = this.getSqlSession();
    session.delete("user.updateUser", user);
    session.commit();
    session.close();
  }

  @Override
  public List<User> findUser() {
//    SqlSession session = MyBasisUtils.openSession();
    SqlSession session = this.getSqlSession();
    List<User> userList = session.selectList("user.findUser");
    return userList;
  }

  @Override
  public void deleteUserById(Integer id) {
    // TODO Auto-generated method stub
    SqlSession session = this.getSqlSession();
    session.delete("user.deleteUser", id);
    session.commit();
    session.close();
  }
}

编写service层

接口类TestService

package com.org.service;

import java.util.List;

import com.org.entity.User;

public interface TestService {
  List<User> findUser() ;
  void updateUser(User user) ;
  void insertUser(User user);
  void deleteUserById(Integer id);
}

实现类TestServiceImpl

package com.org.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.org.dao.TestDao;
import com.org.entity.User;
import com.org.service.TestService;

@Service
@Transactional
public class TestServiceImpl implements TestService {
  @Autowired
  private TestDao testDao;

  @Override
  public List<User> findUser() {
    // TODO Auto-generated method stub
    return testDao.findUser();
  }

  @Override
  public void updateUser(User user) {
    // TODO Auto-generated method stub
    testDao.updateUser(user);
  }

  @Override
  public void insertUser(User user) {
    // TODO Auto-generated method stub
    testDao.insertUser(user);
  }

  @Override
  public void deleteUserById(Integer id) {
    // TODO Auto-generated method stub
    testDao.deleteUserById(id);
  }

}

controller层

TestController

package com.org.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import com.org.entity.User;
import com.org.service.TestService;

@Controller
public class TestContorller {

  @Autowired
  private TestService testService;

  @RequestMapping(value = "hello")
  public ModelAndView helAndViewlo() {
    List<User> findUser = testService.findUser();

    ModelAndView mav = new ModelAndView();
    mav.addObject("msg", findUser);
    mav.setViewName("index");
    return mav;
  }
}

springMVC配置文件spring-mvc.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:mvc="http://www.springframework.org/schema/mvc"
  xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/mvc
         http://www.springframework.org/schema/mvc/spring-mvc.xsd 
       http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd">

  <context:component-scan
    base-package="com.org.controller" />
  <bean
    class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="prefix" value="/" />
    <property name="suffix" value=".jsp" />
  </bean>
</beans>

配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
  id="WebApp_ID" version="3.1">
  <display-name>Test</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>

  <!-- 加载spring相关配置 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath*:spring-config.xml</param-value>
  </context-param>
  <!--Spring的ApplicationContext 载入 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <!-- 编码过滤器，以UTF8编码 -->
  <filter>
    <filter-name>encodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF8</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <!-- 配置SpringMVC -->
  <servlet>
    <servlet-name>springmvc</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <!-- 指定加载外部的spring-mvc配置文件 -->
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath*:spring-mvc.xml</param-value>
    </init-param>
    <!-- 这个可以不配，可以省略 -->
    <load-on-startup>1</load-on-startup>
  </servlet>

  <servlet-mapping>
    <servlet-name>springmvc</servlet-name>
    <!-- 拦截所有的请求，除了jsp。  /xx.html js css 会 -->
    <url-pattern>/</url-pattern>
  </servlet-mapping>


</web-app>

index.jsp

<body>
  ${msg}
</body>

在浏览器中输入

[学习记录]SSM框架整合，注解，简洁_spring_03