搭建SSM（SpringMVC+Spring+Mybatis）架构

浅浅的花香味﹌ 2022-04-10 01:26 132阅读 0赞

## 1.导入jar包 ##

<dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.11</version>
          <scope>test</scope>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-webmvc</artifactId>
          <version>5.0.8.RELEASE</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.aspectj</groupId>
          <artifactId>aspectjweaver</artifactId>
          <version>1.9.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.aspectj</groupId>
          <artifactId>aspectjrt</artifactId>
          <version>1.9.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>aopalliance</groupId>
          <artifactId>aopalliance</artifactId>
          <version>1.0</version>
        </dependency>
    
        
        <dependency>
          <groupId>commons-logging</groupId>
          <artifactId>commons-logging</artifactId>
          <version>1.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>commons-dbcp</groupId>
          <artifactId>commons-dbcp</artifactId>
          <version>1.4</version>
        </dependency>
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.46</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>5.0.8.RELEASE</version>
        </dependency>
        
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-api</artifactId>
          <version>1.7.25</version>
        </dependency>
    
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-log4j12</artifactId>
          <version>1.7.12</version>
        </dependency>
    
        <dependency>
          <groupId>org.apache.logging.log4j</groupId>
          <artifactId>log4j-core</artifactId>
          <version>2.10.0</version>
        </dependency>
    
        
        <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>fastjson</artifactId>
          <version>1.2.47</version>
        </dependency>
    
        
        <dependency>
          <groupId>commons-fileupload</groupId>
          <artifactId>commons-fileupload</artifactId>
          <version>1.3.3</version>
        </dependency>
    
        
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>3.1.0</version>
          <scope>provided</scope>
        </dependency>
    
        <dependency>
          <groupId>com.aliyun</groupId>
          <artifactId>aliyun-java-sdk-core</artifactId>
          <version>4.0.6</version>
        </dependency>
    
        <dependency>
          <groupId>com.aliyun</groupId>
          <artifactId>aliyun-java-sdk-dysmsapi</artifactId>
          <version>1.1.0</version>
        </dependency>
    
    
        
        <dependency>
          <groupId>com.oracle</groupId>
          <artifactId>ojdbc6</artifactId>
          <version>11.1.0.6.0</version>
          <scope>system</scope>
          <systemPath>${basedir}/web/WEB-INF/lib/ojdbc6-11.1.0.6.0.jar</systemPath>
        </dependency>
    
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.4.5</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.3.1</version>
        </dependency>

## 2.手动导入Oracle的jar包 ##

![20181219144634378.png][]

3.完成resources目录下xml文件的配置

![2018121914481363.png][]

### db.properties ###

mysql.driverClassName=com.mysql.jdbc.Driver
    mysql.url=jdbc:mysql://localhost:3306/forage?useSSL=true
    mysql.username=root
    mysql.password=970817
    mysql.maxIdle=100
    mysql.initialSize=5
    
    oracle.driverClassName=oracle.jdbc.OracleDriver
    oracle.url=jdbc:oracle:thin:@localhost:1521:orcl
    oracle.username=scott
    oracle.password=tiger
    oracle.maxIdle=100
    oracle.initialSize=5

### log4j2.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <Configuration status="trace">
        <Appenders>
            <Console name="Console" target="SYSTEM_OUT">
                <PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n"/>
            </Console>
        </Appenders>
        <Loggers>
            <Root level="trace">
                <AppenderRef ref="Console"/>
            </Root>
            <Logger name="com.qy.mapper" level="trace" additivity="false">
                <AppenderRef ref="Console"/>
            </Logger>
    
        </Loggers>
    </Configuration>

### 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>
        <settings>
            
            <setting name="cacheEnabled" value="false"/>
            
            <setting name="lazyLoadingEnabled" value="true"/>
            
            <setting name="logImpl" value="LOG4J2"/>
            <setting name="multipleResultSetsEnabled" value="true"/>
            <setting name="useColumnLabel" value="true"/>
            <setting name="useGeneratedKeys" value="true"/>
            <setting name="autoMappingBehavior" value="PARTIAL"/>
            <setting name="autoMappingUnknownColumnBehavior" value="WARNING"/>
            <setting name="defaultExecutorType" value="SIMPLE"/>
            <setting name="defaultStatementTimeout" value="25"/>
            <setting name="defaultFetchSize" value="100"/>
            <setting name="safeRowBoundsEnabled" value="false"/>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            <setting name="localCacheScope" value="SESSION"/>
            <setting name="jdbcTypeForNull" value="OTHER"/>
            <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
        </settings>
    
        <typeAliases>
            
            
            
           
            <package name="com.jie.domain"></package>
        </typeAliases>
    
    </configuration>

### spring.xml ###

### springmvc-servlet.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:mvc="http://www.springframework.org/schema/mvc"
           xmlns:context="http://www.springframework.org/schema/context"
           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/mvc
    		        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    
    
    
        
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
            
            
        </bean>
    
        
        <mvc:annotation-driven></mvc:annotation-driven>
    
        
        <mvc:annotation-driven>
            <mvc:message-converters register-defaults="true">
                
                <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                    <property name="supportedMediaTypes">
                        <list>
                            <value>text/html;charset=UTF-8</value>
                            <value>application/json;charset=UTF-8</value>
                        </list>
                    </property>
                </bean>
    
               
                <bean id="fastJsonHttpMessageConverter" class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
                    <property name="supportedMediaTypes">
                        <list>
                            <value>text/json;charset=UTF-8</value>
                            <value>text/html;charset=UTF-8</value>
                        </list>
                    </property>
                </bean>
    
            </mvc:message-converters>
        </mvc:annotation-driven>
    
    
        
        <context:component-scan base-package="com.jie.controller"></context:component-scan>
    
        
        <mvc:default-servlet-handler></mvc:default-servlet-handler>
    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
            
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
            
        
        
        <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
            
            <property name="maxUploadSize">
                <value>10485760</value>
            </property>
        </bean>
    
     </beans>

## 3.测试 ##

![20181219145328451.png][]

这部分和SSH几乎一样

### 实体类 ###

package com.jie.domain;
    
    import java.util.List;
    
    public class Dept {
        private int deptno;
        private String dname;
        private String loc;
        //一对多
        private List<Emp>empList;
    
        public List<Emp> getEmpList() {
            return empList;
        }
    
        public void setEmpList(List<Emp> empList) {
            this.empList = empList;
        }
    
        public int getDeptno() {
            return deptno;
        }
    
        public void setDeptno(int deptno) {
            this.deptno = deptno;
        }
    
        public String getDname() {
            return dname;
        }
    
        public void setDname(String dname) {
            this.dname = dname;
        }
    
        public String getLoc() {
            return loc;
        }
    
        public void setLoc(String loc) {
            this.loc = loc;
        }
    }

package com.jie.domain;
    
    import java.sql.Date;
    
    public class Emp {
        private int empno;
        private String ename;
        private String job;
        private int mgr;
        private Date hiredate;
        private double sal;
        private double comm;
        private int deptno;
        //多对一关联
        private Dept dept;
    
        public int getEmpno() {
            return empno;
        }
    
        public void setEmpno(int empno) {
            this.empno = empno;
        }
    
        public String getEname() {
            return ename;
        }
    
        public void setEname(String ename) {
            this.ename = ename;
        }
    
        public String getJob() {
            return job;
        }
    
        public void setJob(String job) {
            this.job = job;
        }
    
        public int getMgr() {
            return mgr;
        }
    
        public void setMgr(int mgr) {
            this.mgr = mgr;
        }
    
        public Date getHiredate() {
            return hiredate;
        }
    
        public void setHiredate(Date hiredate) {
            this.hiredate = hiredate;
        }
    
        public double getSal() {
            return sal;
        }
    
        public void setSal(double sal) {
            this.sal = sal;
        }
    
        public double getComm() {
            return comm;
        }
    
        public void setComm(double comm) {
            this.comm = comm;
        }
    
        public int getDeptno() {
            return deptno;
        }
    
        public void setDeptno(int deptno) {
            this.deptno = deptno;
        }
    
        public Dept getDept() {
            return dept;
        }
    
        public void setDept(Dept dept) {
            this.dept = dept;
        }
    }

### mapper ###

@Repository这个注解放在了mapper的接口上

package com.jie.mapper;
    
    import com.jie.domain.Dept;
    import org.apache.ibatis.annotations.Param;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    @Repository(value = "deptMapper")
    public interface DeptMapper {
        //查询一个
        public Dept selectBreed(int id);
        //查询所有
        public List<Dept>selectAll();
        //添加分类
        public void insertDept(Dept dept);
        //多条件查询+分页
        public List<Dept> findDepts(@Param("dept") Dept dept, @Param("offset") Integer offset, @Param("limit") Integer limit);
        public List<Dept> findDeptList();
        public List<Dept> findDeptList1();
        public List<Dept> findDept(List list);
        //更新
        public void updateDept(@Param("dept") Dept dept);
    }

package com.jie.mapper;
    
    import com.jie.domain.Emp;
    import org.apache.ibatis.annotations.Param;
    import org.springframework.stereotype.Repository;
    
    import java.util.HashMap;
    import java.util.List;
    
    @Repository(value = "empMapper")
    public interface EmpMapper {
        public List<HashMap<String,Object>> findEmpList();
        public List<Emp> findEmpList1();
        public List<Emp> findEmp(@Param("emp") Emp emp);
     }

### service ###

接口忽略，同mapper接口一样（不带注解）

实现类

package com.jie.service.impl;
    
    import com.jie.domain.Dept;
    import com.jie.mapper.DeptMapper;
    import com.jie.service.DeptService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    import java.util.List;
    
    @Service(value = "deptService")
    public class DeptServiceImpl implements DeptService {
        @Autowired
        private DeptMapper deptMapper;
    
        @Override
        public Dept selectBreed(int id) {
            return null;
        }
    
        @Override
        public List<Dept> selectAll() {
            List list=deptMapper.selectAll();
            return list;
        }
    
        @Override
        public void insertDept(Dept dept) {
            deptMapper.insertDept(dept);
        }
    
        @Override
        public List<Dept> findDepts(Dept dept, Integer offset, Integer limit) {
            List list=deptMapper.findDepts(dept,offset,limit);
            return list;
        }
    
        @Override
        public List<Dept> findDeptList() {
            List list = deptMapper.findDeptList();
            return list;
        }
    
        @Override
        public List<Dept> findDeptList1() {
            List list=deptMapper.findDeptList1();
            return list;
        }
    
        @Override
        public List<Dept> findDept(List list) {
            List list1=deptMapper.findDept(list);
            return list1;
        }
    
        @Override
        public void updateDept(Dept dept) {
            deptMapper.updateDept(dept);
        }
    }

package com.jie.service.impl;
    
    import com.jie.domain.Emp;
    import com.jie.mapper.EmpMapper;
    import com.jie.service.EmpService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    import java.util.HashMap;
    import java.util.List;
    
    @Service(value = "empService")
    public class EmpServiceImpl implements EmpService {
        @Autowired
        private EmpMapper empMapper;
    
    
        @Override
        public List<HashMap<String, Object>> findEmpList() {
            List<HashMap<String,Object>>list=empMapper.findEmpList();
            return list;
        }
    
        @Override
        public List<Emp> findEmpList1() {
            List list=empMapper.findEmpList1();
            return list;
        }
    
        @Override
        public List<Emp> findEmp(Emp emp) {
            List list=empMapper.findEmp(emp);
            return list;
        }
    }

### mapper.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="com.jie.mapper.DeptMapper">
        
        <select id="selectDept" resultType="Dept">
           select * from dept where id = #{id}
       </select>
        
        <select id="selectAll" resultType="Dept">
            select * from dept
        </select>
    
        <insert id="insertDept" parameterType="Dept">
            insert into dept(deptno,dname,loc)
            values (seq_u_id.nextval,#{dname},#{loc})
        </insert>
    
        <select id="findDepts" resultType="Dept">
            
            <bind name="dname" value="'%'+dept.dname+'%'"></bind>
            <bind name="loc" value="'%'+dept.loc+'%'"></bind>
            select d.deptno,d.dname,d.loc from
            (select rownum rn,dept.* from dept
            <where>
                <if test="dept!=null and dept.dname!=null">
                    and dname like #{dname}
    
                </if>
                <if test="dept!=null and dept.loc!=null">
                    and loc like #{loc}
                </if>
            </where>
            )d where d.rn between #{offset} and #{limit}
        </select>
    
    
        <select id="findDeptList" resultMap="deptMap">
           select dept.*,emp.*
           from dept join emp
           on dept.deptno = emp.deptno
        </select>
    
        <resultMap id="deptMap" type="Dept" autoMapping="true">
            
            <collection property="empList" ofType="Emp" column="deptno"  autoMapping="true">
    
            </collection>
        </resultMap>
    
        
        <select id="findDeptList1" resultMap="deptMap2">
           select * from dept
        </select>
    
        <resultMap id="deptMap2" type="Dept" autoMapping="true">
            
            <collection property="empList" ofType="Emp" column="deptno"  autoMapping="true" select="getEmpList">
    
            </collection>
        </resultMap>
        <select id="getEmpList" parameterType="java.lang.Integer" resultType="Emp">
            select * from emp where deptno=#{deptno}
        </select>
    
        <select id="findDept" resultType="Dept">
            select * from dept where deptno in
            <foreach item="item" index="index" collection="list"
                     open="(" separator="," close=")">
                #{item}
            </foreach>
        </select>
    
        <update id="updateDept">
            update dept
            <set>
                <if test="dept!=null and dept.dname != null">dept.dname=#{dept.dname},</if>
                <if test="dept!=null and dept.loc != null">dept.loc=#{dept.loc},</if>
            </set>
            where deptno=#{dept.deptno}
        </update>
    
    
    </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.jie.mapper.EmpMapper">
        <select id="findEmpList" resultType="HashMap">
            select emp.*,dept.dname,dept.loc
            from emp join dept
            on emp.deptno=dept.deptno
        </select>
    
        <select id="findEmpList1" resultMap="empMap" >
            select emp.*,dept.*
            from emp ,dept
            where emp.deptno = dept.deptno
        </select>
        
        <resultMap id="empMap" type="Emp" autoMapping="true">
            <id property="empno" column="empno"></id>
            
            <association property="dept" column="deptno" javaType="Dept" autoMapping="true">
                <id property="deptno" column="deptno"></id>
            </association>
        </resultMap>
    
        <select id="findEmp" resultType="Emp">
            <bind name="ename" value="'%'+emp.ename+'%'"></bind>
            <bind name="job" value="'%'+emp.job+'%'"></bind>
            select * from emp where 1=1
            <choose>
                <when test="emp!=null and emp.ename != null">
                    AND emp.ename like #{ename}
                </when>
                <when test="emp!=null and emp.job != null">
                    AND emp.job like #{job}
                </when>
                <otherwise>
                    AND featured = 1
                </otherwise>
            </choose>
        </select>
    
    </mapper>

### controller层 ###

package com.jie.controller;
    
    import com.alibaba.fastjson.JSON;
    import com.jie.service.DeptService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.util.ArrayList;
    import java.util.List;
    
    @Controller
    @RequestMapping("/dept")
    public class DeptController {
        @Autowired
        private DeptService deptService;
    
        @RequestMapping("/selectAll")
        @ResponseBody
        public String selectAll(){
            List list=deptService.selectAll();
            return JSON.toJSONString(list);
        }
    
        @RequestMapping("/findDeptList")
        @ResponseBody
        public String findDeptList(){
            List list=deptService.findDeptList();
            return JSON.toJSONString(list);
        }
    
        @RequestMapping("/findDeptList1")
        @ResponseBody
        public String findDeptList1(){
            List list=deptService.findDeptList1();
            return JSON.toJSONString(list);
        }
    
        @RequestMapping("/findDept")
        @ResponseBody
        public String findDept(){
            List list1=new ArrayList();
            list1.add(5);
            list1.add(10);
            List list=deptService.findDept(list1);
            return JSON.toJSONString(list);
        }
    
    }

package com.jie.controller;
    
    import com.alibaba.fastjson.JSON;
    import com.jie.service.EmpService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    import java.util.List;
    
    @Controller
    @RequestMapping("/emp")
    public class EmpController {
        @Autowired
        private EmpService empService;
    
        @RequestMapping("/findEmpList")
        @ResponseBody
        public String findEmpList(){
    
            List list=empService.findEmpList();
            return JSON.toJSONString(list);
        }
    
        @RequestMapping("/findEmpList1")
        @ResponseBody
        public String findEmpList1(){
            List list=empService.findEmpList1();
            return JSON.toJSONString(list);
        }
    
    }

排序有点问题，将就着看吧！

[20181219144634378.png]: /images/20220404/4a81dc3dc2894c238e2f670d45108eb3.png
[2018121914481363.png]: /images/20220404/df0d3dd0f296499e996690e93c9647c7.png
[20181219145328451.png]: /images/20220404/894b8dae4828441c8971e499d5478c3e.png