Spring中的IOC控制Mybatis案例

小咪咪 2023-07-20 10:55 1阅读 0赞

我们之前的案例都是基于单独的Mybatis练习，本次案例结合Spring的IOC管理Bean的方式来调用Mybatis中的数据库操作。这次案例中我们可以通过2种方式运行你的Mybatis.  
1 通过Srping的bean在junit完成测试  
2 通过Web应用程序上下文，监听方式来加载Mybatis和Spring管理  
一 我们先来看看数据库个结构，很简单就一个表  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 1]  
二 通过idea工具下的Maven创建项目的结构。我们依然使用Maven的聚合方式来管理项目结构  
![在这里插入图片描述][20200401113754661.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 2]  
1 父项目的pom文件内容；这里面定义项目整体会用到的JAR包。通过《dependency》方式引入JAR包

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>com.zxf</groupId>
      <artifactId>SpringProject</artifactId>
      <packaging>pom</packaging>
      <version>1.0-SNAPSHOT</version>
      <modules>
        <module>Spring-web1</module>
      </modules>
        
        <properties>
            <junit.version>4.12</junit.version>
            <mybatis.version>3.2.8</mybatis.version>
            <mysql.version>5.1.32</mysql.version>
            <jstl.version>1.2</jstl.version>
            <servlet.version>3.1.0</servlet.version>
            <jsp.version>2.0</jsp.version>
            <log4j.version>1.2.17</log4j.version>
    
            <spring-aop.version>4.1.6.RELEASE</spring-aop.version>
            <spring-aspects.version>4.1.6.RELEASE</spring-aspects.version>
            <spring-beans.version>4.1.6.RELEASE</spring-beans.version>
            <spring-context.version>4.1.6.RELEASE</spring-context.version>
            <spring-context-support.version>4.1.6.RELEASE</spring-context-support.version>
            <spring-core.version>4.1.6.RELEASE</spring-core.version>
            <spring-expression.version>4.1.6.RELEASE</spring-expression.version>
            <spring-instrument.version>4.1.6.RELEASE</spring-instrument.version>
            <spring-instrument-tomcat.version>4.1.6.RELEASE</spring-instrument-tomcat.version>
            <spring-jdbc.version>4.1.6.RELEASE</spring-jdbc.version>
            <spring-jms.version>4.1.6.RELEASE</spring-jms.version>
            <spring-messaging.version>4.1.6.RELEASE</spring-messaging.version>
            <spring-orm.version>4.1.6.RELEASE</spring-orm.version>
            <spring-oxm.version>4.1.6.RELEASE</spring-oxm.version>
            <spring-test.version>4.1.6.RELEASE</spring-test.version>
            <spring-tx.version>4.1.6.RELEASE</spring-tx.version>
            <spring-webmvc.version>4.1.6.RELEASE</spring-webmvc.version>
            <spring-web.version>4.1.6.RELEASE</spring-web.version>
            <spring-webmvc-portlet.version>4.1.6.RELEASE</spring-webmvc-portlet.version>
            <spring-websocket.version>4.1.6.RELEASE</spring-websocket.version>
            <commons-logging.version>1.1.3</commons-logging.version>
            <asm.version>3.3.1</asm.version>
            <cglib.version>2.2.2</cglib.version>
            <javassist.version>3.17.1-GA</javassist.version>
            <mybatis-spring.version>1.2.3</mybatis-spring.version>
            <standard.version>1.1.2</standard.version>
        </properties>
        <dependencyManagement>
            <dependencies>
                <dependency>
                    <groupId>junit</groupId>
                    <artifactId>junit</artifactId>
                    <version>${ junit.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.mybatis</groupId>
                    <artifactId>mybatis</artifactId>
                    <version>${ mybatis.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>${ mysql.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>jstl</groupId>
                    <artifactId>jstl</artifactId>
                    <version>${ jstl.version}</version>
                </dependency>
            
                <dependency>
                    <groupId>javax.servlet</groupId>
                    <artifactId>javax.servlet-api</artifactId>
                    <version>${ servlet.version}</version>
                    <scope>provided</scope>
                </dependency>
                <dependency>
                    <groupId>javax.servlet</groupId>
                    <artifactId>jsp-api</artifactId>
                    <version>${ jsp.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>log4j</groupId>
                    <artifactId>log4j</artifactId>
                    <version>${ log4j.version}</version>
                </dependency>
                
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-aop</artifactId>
                    <version>${ spring-aop.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-aspects</artifactId>
                    <version>${ spring-aspects.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-beans</artifactId>
                    <version>${ spring-beans.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-context</artifactId>
                    <version>${ spring-context.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-context-support</artifactId>
                    <version>${ spring-context-support.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-core</artifactId>
                    <version>${ spring-core.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-expression</artifactId>
                    <version>${ spring-expression.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-instrument</artifactId>
                    <version>${ spring-instrument.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-instrument-tomcat</artifactId>
                    <version>${ spring-instrument-tomcat.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-jdbc</artifactId>
                    <version>${ spring-jdbc.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-jms</artifactId>
                    <version>${ spring-jms.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-messaging</artifactId>
                    <version>${ spring-messaging.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-orm</artifactId>
                    <version>${ spring-orm.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-oxm</artifactId>
                    <version>${ spring-oxm.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-test</artifactId>
                    <version>${ spring-test.version}</version>
                    <scope>test</scope>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-tx</artifactId>
                    <version>${ spring-tx.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-web</artifactId>
                    <version>${ spring-web.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-webmvc</artifactId>
                    <version>${ spring-webmvc.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-webmvc-portlet</artifactId>
                    <version>${ spring-webmvc-portlet.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-websocket</artifactId>
                    <version>${ spring-websocket.version}</version>
                </dependency>
                
                
                <dependency>
                    <groupId>commons-logging</groupId>
                    <artifactId>commons-logging</artifactId>
                    <version>${ commons-logging.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>asm</groupId>
                    <artifactId>asm</artifactId>
                    <version>${ asm.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>cglib</groupId>
                    <artifactId>cglib</artifactId>
                    <version>${ cglib.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.javassist</groupId>
                    <artifactId>javassist</artifactId>
                    <version>${ javassist.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.mybatis</groupId>
                    <artifactId>mybatis-spring</artifactId>
                    <version>${ mybatis-spring.version}</version>
                </dependency>
            </dependencies>
        </dependencyManagement>
       <build>
           <resources>
               <resource>
                   <directory>src/main/java</directory>
                   <includes>
                       <include>**/*.xml</include> </includes> </resource> <resource> <directory>src/main/resouces</directory> <includes> <include>**/*.xml</include>
                       <include>**/*.properties</include> </includes> </resource> </resources> <plugins> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <configuration> <path>/</path> <port>9090</port> </configuration> </plugin> </plugins> </build> </project>

2 子项目引入父项目的JAR包

3 开始编写pojo层实体类

package com.zxf.web.pojo;
    
    public class Flower { 
        private  int id;
        private String name;
        private float price;
        private String production;
    
        public int getId() { 
            return id;
        }
    
        public void setId(int id) { 
            this.id = id;
        }
    
        public String getName() { 
            return name;
        }
    
        public void setName(String name) { 
            this.name = name;
        }
    
        public float getPrice() { 
            return price;
        }
    
        public void setPrice(float price) { 
            this.price = price;
        }
    
        public String getProduction() { 
            return production;
        }
    
        public void setProduction(String production) { 
            this.production = production;
        }
    }

4 编写Mybatis的Mapper,这次使用的是注解方式。

package com.zxf.web.mapper;
    
    import com.zxf.web.pojo.Flower;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    public interface FlowerMapper { 
        @Select("select * from flower")
        List<Flower> getAll();
    }

5 编写Service层，后面我们会把Service交给Spring容器来管理

package com.zxf.web.service;
    
    import com.zxf.web.pojo.Flower;
    
    import java.util.List;
    
    public interface FlowerService { 
        List<Flower> show();
    }

package com.zxf.web.service.impl;
    
    import com.zxf.web.mapper.FlowerMapper;
    import com.zxf.web.pojo.Flower;
    import com.zxf.web.service.FlowerService;
    
    import java.util.List;
    
    public class FlowerServiceImpl implements FlowerService { 
        private FlowerMapper flowerMapper;
    
        public FlowerMapper getFlowerMapper() { 
            return flowerMapper;
        }
    
        public void setFlowerMapper(FlowerMapper flowerMapper) { 
            this.flowerMapper = flowerMapper;
        }
    
        public List<Flower> show() { 
            return  flowerMapper.getAll();
        }
    }

6 编写Spring配置文件，它负责加载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"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd">
        
        <bean id="dataSouce" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
            <property name="url" value="jdbc:mysql://192.168.0.148:3306/test"></property>
            <property name="username" value="root"></property>
            <property name="password" value="abc123"></property>
        </bean>
        
        <bean id="factory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSouce"></property>
        </bean>
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.zxf.web.mapper"></property>
            
            <property name="sqlSessionFactory" ref="factory"></property>
        </bean>
        
        <bean id="flowerSerivce" class="com.zxf.web.service.impl.FlowerServiceImpl">
            <property name="flowerMapper" ref="flowerMapper"></property>
        </bean>
    </beans>

7 以上都编写好以后，我们先用junit来测试一下，各个资源资源直接是否正常

package com.zxf.web.test;
    
    import com.zxf.web.pojo.Flower;
    import com.zxf.web.service.impl.FlowerServiceImpl;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import java.util.List;
    
    public class Test1 { 
        @Test
        public void test1(){ 
            ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
            FlowerServiceImpl flowerService=ac.getBean("flowerSerivce",FlowerServiceImpl.class);
            List<Flower> show = flowerService.show();
            for(Flower f:show){ 
                System.out.println(f.getProduction());
            }
    
        }
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 3]  
8 编写Servlet类，也是采用注解的方式建立Servlet

package com.zxf.web.servlet;
    
    import com.zxf.web.service.FlowerService;
    import com.zxf.web.service.impl.FlowerServiceImpl;
    import org.springframework.context.ApplicationContext;
    import org.springframework.web.context.support.WebApplicationContextUtils;
    
    import javax.servlet.ServletException;
    import javax.servlet.ServletRequest;
    import javax.servlet.ServletResponse;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import java.io.IOException;
    
    @WebServlet("/flowerServlet")
    public class FlowerServlet extends HttpServlet { 
        private FlowerService flowerService;
        @Override
        public void init() throws ServletException { 
            ApplicationContext ac= WebApplicationContextUtils.getRequiredWebApplicationContext(getServletContext());
            flowerService=ac.getBean("flowerSerivce", FlowerServiceImpl.class);
        }
        @Override
        public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { 
            req.setAttribute("list",flowerService.show());
            req.getRequestDispatcher("showFlower.jsp").forward(req,res);
        }
    }

9 这个时候我们用web.xml方式加载配置文件  
web.xml文件内容

<!DOCTYPE web-app PUBLIC
     "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
     "http://java.sun.com/dtd/web-app_2_3.dtd" >
    
    <web-app>
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath*:applicationContext.xml</param-value>
      </context-param>
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
    </web-app>

这样我们在Servlet中就可以直接调用Spring中定义的标签的Service了  
我们使用Maven的打包工具 把当前的web工程打WAR包  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 4]  
到这里把你的WAR包拷贝的tomcat中的webapps  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 5]  
最后在WEB层运行的结果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 6]  
如果对你有帮助，请记得点个赞哦！！！！！！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70]: /images/20230528/83b6dc520f474f9481cb3cc5f1b41a36.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 1]: /images/20230528/fc5365f815eb4da19bed76f411e545a4.png
[20200401113754661.png]: /images/20230528/13f2408e27124c8db6730c1d4d717990.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 2]: /images/20230528/e13f5c01f3874b2791561d9a81729561.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 3]: /images/20230528/cf467446f84f4c1aa66b35101794e5f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 4]: /images/20230528/53ea2e9fcc1642e0b1385c29d21549cd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 5]: /images/20230528/8a96acd4c27d417ab5ff91b38aec1a71.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nNjEzMjMyNg_size_16_color_FFFFFF_t_70 6]: /images/20230528/4c835f607c694a42819d6f0b214efa65.png