SpringMvc+Spring+Mybatis简易搭建

最新推荐文章于 2021-07-28 10:31:58 发布

博风

最新推荐文章于 2021-07-28 10:31:58 发布

阅读量199

点赞数

分类专栏：笔记文章标签： springmvc spring mybatis j2ee

本文链接：https://blog.csdn.net/Bof_jangle/article/details/80751721

版权

笔记同时被 2 个专栏收录

93 篇文章 0 订阅

订阅专栏

服务端

13 篇文章 0 订阅

订阅专栏

用到的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" id="WebApp_ID" version="3.0">
  <display-name>WebApp</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 IOC 容器的 Listener -->  
    <!-- needed for ContextLoaderListener -->  
    <context-param>  
        <param-name>contextConfigLocation</param-name>  
        <param-value>classpath:spring.xml</param-value>  
    </context-param>  
  
    <!-- Bootstraps the root web application context before servlet initialization -->  
    <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>
      <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springmvc-servlet.xml</param-value>
      </init-param>
         <load-on-startup>1</load-on-startup> 
  </servlet>

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

springmvc-servlet.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>WebApp</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 IOC 容器的 Listener -->  
    <!-- needed for ContextLoaderListener -->  
    <context-param>  
        <param-name>contextConfigLocation</param-name>  
        <param-value>classpath:spring.xml</param-value>  
    </context-param>  
  
    <!-- Bootstraps the root web application context before servlet initialization -->  
    <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>
      <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springmvc-servlet.xml</param-value>
      </init-param>
         <load-on-startup>1</load-on-startup> 
  </servlet>

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

spring.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-4.3.xsd
            http://www.springframework.org/schema/tx  
        	http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">  
      
        <context:component-scan base-package="xyz.jangle.service">  
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>  
            <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>  
        </context:component-scan>  
      
        <!-- 配置数据源, 整合其他框架, 事务等. -->  
        
        
        <!-- 1. 数据源 : DriverManagerDataSource -->  
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />  
        <property name="url" value="jdbc:mysql://127.0.0.1:3307/test" />  
        <property name="username" value="yonghu" />  
        <property name="password" value="mima" />  
    </bean>  
  
    <!--  
        2. mybatis的SqlSession的工厂: SqlSessionFactoryBean dataSource:引用数据源  
  
        MyBatis定义数据源,同意加载配置  
    -->  
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource"></property>  
        <property name="configLocation" value="classpath:mybatis-config.xml" />
        <!-- 此处定义mapper映射文件，以通配符的形式定义整个包底下的所有mapper文件。那么mybatis-config.xml文件中就不需要再一一配置mapper了 -->
        <!-- <property name="mapperLocations" value="classpath:xyz/jangle/mapper/*.xml" />   -->
    </bean>  
  
    <!--  
        3. mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer sqlSessionFactory  
  
        basePackage:指定sql映射文件/接口所在的包（自动扫描）  
    -->  
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
        <property name="basePackage" value="xyz.jangle.mapper"></property>  
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
    </bean>  
  
    <!-- 
        4. 事务管理 : DataSourceTransactionManager dataSource:引用上面定义的数据源 
    -->  
    <bean id="txManager"  
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
        <property name="dataSource" ref="dataSource"></property>  
    </bean>  
  
    <!-- 5. 使用声明式事务  
         transaction-manager：引用上面定义的事务管理器  
     -->  
    <tx:annotation-driven transaction-manager="txManager" />  
      
    </beans>

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>  
            <typeAlias alias="User" type="xyz.jangle.model.User" />
            <!-- 扫描包下的所有实体类并映射其类名为别名，如此就不需要一一配置别名了 -->
            <!-- <package name="xyz.jangle.model" />     -->
        </typeAliases>  
        <!-- 实体接口映射资源 -->  
        <!-- 
            说明：如果xxMapper.xml配置文件放在和xxMapper.java统一目录下，mappers也可以省略，因为org.mybatis.spring.mapper.MapperFactoryBean默认会去查找与xxMapper.java相同目录和名称的xxMapper.xml 
        -->  
        <mappers>  
            <mapper resource="xyz/jangle/mapper/UserMapper.xml" />  
        </mappers>  
      
    </configuration>

MvcController.java :

package xyz.jangle.action;

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

import xyz.jangle.service.UserService;

@Controller
@RequestMapping("/mvc")
public class MvcController {
	
	@Autowired
	private UserService userService;
	
	@RequestMapping("/hello")
	public String hello(){
		
		System.out.println("hello,哇塞，我被执行到了");
		
		return userService.getUser();
	}

}

service是相关的业务处理逻辑。

mapper是相关的持久层逻辑。UserMapper.java是接口，UserMapper.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">  
    <!--   
        namespace：必须与对应的接口全类名一致  
        id:必须与对应接口的某个对应的方法名一致  
     -->  
    <mapper namespace="xyz.jangle.mapper.UserMapper">  
          
          <!-- 暂不可用 -->
        <insert id="save" parameterType="User">  
            insert into table_name(name,age) values(#{userName},#{userAge})  
        </insert>  
          
          <!-- 暂不可用 -->
        <update id="update" parameterType="User">  
            update table_name set name=#{userName},age=#{userAge} where id=#{id}  
        </update>  
          
          <!-- 暂不可用 -->
        <delete id="delete" parameterType="int">  
            delete from table_name where id=#{id}  
        </delete>  
          
         <!-- mybsits_config中配置的alias类别名,也可直接配置resultType为类路径 -->    
        <select id="findById" parameterType="int" resultType="User">  
            select id userId,name userName from c_tenant where id=#{id}  
        </select>  
          
        <select id="findAll" resultType="User">  
            select id userId,name userName from c_tenant
        </select>  
          
    </mapper>

项目资源下载地址：https://download.csdn.net/download/bof_jangle/10489085