mybatis-springMVC

最新推荐文章于 2021-10-11 17:29:19 发布

pzmyg

最新推荐文章于 2021-10-11 17:29:19 发布

阅读量118

点赞数

分类专栏：后端

本文链接：https://blog.csdn.net/pzmyg/article/details/80941597

版权

后端专栏收录该内容

13 篇文章 0 订阅

订阅专栏

参照网上的各种demo，搞了好久，实现的功能就是mybatis,springMVC的整合。最开始使用注解实现bean，后来测试基于xml配置的实现方式，故代码中有些注解被注释掉。

1、新建web工程，导入jar包

对知识点不熟悉，此项目中jar包比较乱，排错时出现缺少jar包就会下载导入，下面贴出项目中的依赖包
这里写图片描述

2、配置web.xml

主要配置日志，监听，servlet控制器

<?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>SSM</display-name>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>

    <context-param>
        <description>加载日志文件</description>
        <param-name>log4jConfigLocation</param-name>
        <param-value>classpath:log4j.properties</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    </listener>

    <context-param>
        <description>设置Spring容器加载所有的配置文件的路径</description>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>

    <filter>
        <description>字符编码过滤器</description>
        <filter-name>encodingFilter</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>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <listener>
        <description>spring监听器</description>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <listener>
        <description>防止spring内存溢出监听器</description>
        <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
    </listener>

    <servlet>
        <description>配置SpringMVC核心控制器</description>
        <servlet-name>springMvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <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>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>

    <!-- session的保存时间 -->
    <session-config>
        <session-timeout>30</session-timeout>
    </session-config>
</web-app>

3、配置applicationContext.xml

配置自动扫描包，数据连接池，mybatis配置文件，事务管理器等

<?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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="  
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd  
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd  
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd  
            http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd  
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"
    default-autowire="byName" default-lazy-init="false">

    <!-- 自动扫描（自动注入） -->
    <context:component-scan base-package="com.htp.service" />

    <!-- <context:component-scan base-package="com.htp.serviceImpl" /> -->
    <bean id="userServiceImpl" class="com.htp.serviceImpl.UserServiceImpl"></bean>

    <!-- <context:component-scan base-package="com.htp.dao" /> -->
    <!-- <bean id="userMapper" class="com.htp.dao.UserMapper"></bean> -->


    <!-- <context:component-scan base-package="com.htp.bean" /> -->
    <bean id="user" class="com.htp.bean.User"></bean>

    <context:property-placeholder location="classpath:jdbc_property"></context:property-placeholder>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <!-- <property name="driverClassName" value="${jdbc.driver}" /> <property 
            name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.user}" 
            /> <property name="password" value="${jdbc.password}" /> -->
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/demo?useSSL=true" />
        <property name="username" value="root" />
        <property name="password" value="root" />
    </bean>

    <!-- 加载mybatis文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <!-- mybatis配置文件 -->
        <property name="configLocation" value="classpath:mybatisconfig.xml"></property>

        <!-- 自动扫描里的配置文件 -->
        <!-- <property name="mapperLocations" value="classpath:com/htp/dao/*.xml"></property> -->
    </bean>

    <!-- mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer sqlSessionFactory 
        basePackage:指定sql映射文件/接口所在的包（自动扫描） -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.htp.dao"></property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

    <!-- 配置事务管理器 -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>

    <!-- 使用声明式事务 transaction-manager：引用上面定义的事务管理器 -->
    <tx:annotation-driven transaction-manager="transactionManager" />

    <!-- mybatis+spring <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
        dataSource属性指定要用到的连接池 <property name="dataSource" ref="dataSource" /> configLocation属性指定mybatis的核心配置文件 
        <property name="configLocation" value="mybatisconfig.xml" /> </bean> <bean 
        id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"> sqlSessionFactory属性指定要用到的SqlSessionFactory实例 
        <property name="sqlSessionFactory" ref="sqlSessionFactory" /> mapperInterface属性指定映射器接口，用于实现此接口并生成映射器对象 
        <property name="mapperInterface" value="com.htp.mapper.UserMapper" /> </bean> -->
</beans>

4、配置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/context
    http://www.springframework.org/schema/context/spring-context-4.0.xsd
    http://www.springframework.org/schema/mvc
    http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

    <!-- 注解扫描包 -->
    <context:component-scan base-package="com.htp.controller" />

    <!-- 开启注解 -->
    <mvc:annotation-driven />

    <!-- 定义跳转的文件的前后缀 ，视图模式配置 -->
    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->
        <property name="prefix" value="/" />
        <property name="suffix" value=".jsp" />
    </bean>
</beans>

5、mybatisconfig,log4j.properties,jdbc_property此处不列详细配置，和之前项目配置类似

6、mapper映射文件及实现接口类

<?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.htp.dao.UserMapper">

    <resultMap id="usersMap" type="java.util.Map">
        <id column="name" property="name" jdbcType="VARCHAR" />
        <id column="address" property="address" jdbcType="VARCHAR" />
    </resultMap>

    <resultMap id="usersMapById" type="java.util.Map">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="address" property="address" />
    </resultMap>

    <select id="getUsers" resultMap="usersMap">
        select name,address from user
    </select>

    <select id="getUserById" resultType="com.htp.bean.User">
        select id,name,address from user
        where 1=1
        <if test="id != null or id !=''">
            and id = #{id}
        </if>

    </select>

</mapper>

package com.htp.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import com.htp.bean.User;

//@Repository 基于注解实现bean
public interface UserMapper {

    public List<Map<String, String>> getUsers();


//  public List<Map<String,String>> getUserById(@Param("id")Integer id);

    public List<User> getUserById(@Param("id")Integer id);
}

7、service接口及实现类

package com.htp.serviceImpl;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

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

import com.htp.bean.User;
import com.htp.dao.UserMapper;
import com.htp.service.IUserSevice;

//@Service
public class UserServiceImpl implements IUserSevice {

    @Autowired
    UserMapper userMapper;

    @Override
    public List<Map<String, String>> getUsers() {
        // TODO Auto-generated method stub
        return userMapper.getUsers();
    }

    @Override
    public List<User> getUserById(Integer id) {
        // TODO Auto-generated method stub
        return userMapper.getUserById(id);
    }

/*  @Override
    public List<Map<String, String>> getUserById(Integer id) {

        // TODO Auto-generated method stub
        return userMapper.getUserById(id);
    }*/

}

package com.htp.service;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.htp.bean.User;

@Repository
public interface IUserSevice {
    public List<Map<String, String>> getUsers();

//  public List<Map<String,String>> getUserById(Integer  id);

    public List<User> getUserById(Integer  id);
}

8、controller实现

package com.htp.controller;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.htp.bean.User;
import com.htp.serviceImpl.UserServiceImpl;

@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserServiceImpl userService;


    @RequestMapping("/getUsers")
    public List<Map<String,String>> getUsers(){
        /*List<Map<String,String>> rst = new ArrayList<Map<String,String>>();
        rst = userService.getUsers();*/
        //上述使用步骤会存在多占内存问题
        List<Map<String,String>> rst = userService.getUsers();
//      rst = getSqlSession().selectList("getUsers");
        for(int i = 0; i < rst.size(); i++){
            System.out.println("i："+i+" name:"+i+ rst.get(i).get("name"));
        }
        return rst;
    }

    @RequestMapping("/getUserById")
    public List<User> getUserById(Integer id){
     /*   if(Integer.valueOf(id) <= 0){
            System.out.println("error...");
            return null;
        }*/
        System.out.println("test>>>>>>");
//      List<Map<String,String>>  rst = userService.getUserById(id);
        List<User>  rst = userService.getUserById(id);
        for(int i = 0; i < rst.size(); i++){
            System.out.println("i："+i+">>>name:"+ rst.get(i).getName());
        }
        return rst;

    }

}

项目代码结构如下图
这里写图片描述

启动tomcat后，浏览器框中输入对应的url【http://localhost:8080/DemoSpringMVC/user/getUsers.do】，运行成功
这里写图片描述

总结【基于注解方式实现】：
该项目中，web.xml中配置了mvc的控制器配置，在mvc配置文件中配置了控制器类的自动扫描，在控制器类上引用注解，指明controller。
application配置文件中，配置bean的自动扫描，在mapper，service中使用注解指明自己是bean。
controller中使用注解引用service，service中使用mapper。并使用requestmapping注解最终实现controller。