在之前已经对spring，spring-mvc，mybatis等框架有了了解，spring整合mybatis也进行了练习，ssm框架就是这三种框架的简称，那么我们如何使用这三种框架来设计web项目呢？

今天就简单的使用ssm框架搭建web项目，实现增删改查等基本操作：

导入需要使用的依赖文件：

              
               
                   
        
         org.springframework
                    
        
         spring-web
                    
        
         5.1.8.RELEASE
                
               
                   
        
         org.springframework
                    
        
         spring-webmvc
                    
        
         5.1.8.RELEASE
                
               
               
                   
        
         org.springframework
                    
        
         spring-jdbc
                    
        
         5.1.8.RELEASE
                
               
                   
        
         com.alibaba
                    
        
         druid
                    
        
         1.1.10
                
               
                   
        
         mysql
                    
        
         mysql-connector-java
                    
        
         5.1.45
                
               
                   
        
         org.mybatis
                    
        
         mybatis-spring
                    
        
         2.0.2
                
               
                   
        
         org.mybatis
                    
        
         mybatis
                    
        
         3.4.6
                
               
               
                   
        
         org.springframework
                    
        
         spring-tx
                    
        
         5.1.8.RELEASE
                
               
                   
        
         jstl
                    
        
         jstl
                    
        
         1.2
                
               
                   
        
         javax.servlet
                    
        
         servlet-api
                    
        
         2.5
                
           
      

创建数据库，实体;

package com.zs.entity;import org.springframework.format.annotation.DateTimeFormat;import java.util.Date;public class Emp {    private int empno;    private String ename;    private String job;    private int deptno;    private double sal;    @DateTimeFormat(pattern = "yyyy-MM-dd")    private Date hiredate;    public Emp() {    }    public Emp(int empno, String ename, String job, int deptno, double sal, Date hiredate) {        this.empno = empno;        this.ename = ename;        this.job = job;        this.deptno = deptno;        this.sal = sal;        this.hiredate = hiredate;    }    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 getDeptno() {        return deptno;    }    public void setDeptno(int deptno) {        this.deptno = deptno;    }    public double getSal() {        return sal;    }    public void setSal(double sal) {        this.sal = sal;    }    public Date getHiredate() {        return hiredate;    }    public void setHiredate(Date hiredate) {        this.hiredate = hiredate;    }    @Override    public String toString() {        return "Emp{" +                "empno=" + empno +                ", ename='" + ename + '\'' +                ", job='" + job + '\'' +                ", deptno=" + deptno +                ", sal=" + sal +                ", hiredate=" + hiredate +                '}';    }}

dao层：

package com.zs.dao;import com.zs.entity.Emp;import org.apache.ibatis.annotations.Param;import java.util.List;public interface IEmpDao {    /**     * 查询员工，条件查询/所有     * @return     */    List
      
        listEmp(@Param("empno") Integer empno);    /**     * 插入     * @param emp     * @return     */    int insertEmp(Emp emp);    /**     * 修改     * @param emp     * @return     */    int updateEmp(Emp emp);    /**     * 删除     * @param empno     * @return     */    int deleteEmp(int empno);}
      

mapper文件：

          
               select * from emp                                    and empno=#{empno}                            
       
                insert into emp(ename,job,deptno,sal,hiredate) value(#{ename},#{job},#{deptno},#{sal},#{hiredate})    
           
       
                update emp set ename=#{ename},job=#{job},deptno=#{deptno},sal=#{sal},hiredate=#{hiredate} where empno=#{empno}    
           
       
                delete from emp where empno=#{empno}    
       
      

以上的文件都可以采用mybatis插件自动生成

service接口及实现类

package com.zs.service;import com.zs.entity.Emp;import org.springframework.stereotype.Service;import java.util.List;public interface EmpService {    /**     * 查询所有     * @return     */    List
      
        listEmp(Integer empno);    /**     * 插入     * @param emp     * @return     */    boolean insertEmp(Emp emp);    /**     * 修改     * @param emp     * @return     */    boolean updateEmp(Emp emp);    /**     * 删除     * @param empno     * @return     */    boolean deleteEmp(int empno);}
      

package com.zs.service;import com.zs.dao.IEmpDao;import com.zs.entity.Emp;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;@Servicepublic class EmpServiceImpl implements EmpService {    @Autowired    private IEmpDao empDao;    @Override    public List
      
        listEmp(Integer empno) {        return empDao.listEmp(empno);    }    @Override    public boolean insertEmp(Emp emp) {        return empDao.insertEmp(emp)>0;    }    @Override    public boolean updateEmp(Emp emp) {        return empDao.updateEmp(emp)>0;    }    @Override    public boolean deleteEmp(int empno) {        return empDao.deleteEmp(empno) > 0;    }}
      

控制器：

package com.zs.controller;import com.zs.entity.Emp;import com.zs.service.EmpService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import java.util.List;@Controllerpublic class EmpController {    @Autowired    private EmpService empService;    @RequestMapping("/list.action")    private String show(Model model) {        List
      
        emps = empService.listEmp(null);        model.addAttribute("emps", emps);        return "listEmp";    }    @RequestMapping("/insert.action")    private String insert(Emp emp) {        boolean b = empService.insertEmp(emp);        return "redirect:/list.action";    }    @RequestMapping("/getEmp.action")    public String getByEmpno(int empno,Model model) {        List
       
         emps = empService.listEmp(empno);        model.addAttribute("emp", emps.get(0));        return "update";    }    @RequestMapping("/update.action")    private String update(Emp emp) {        boolean b = empService.updateEmp(emp);        return "redirect:/list.action";    }    @RequestMapping("/delete.action")    private String delete(int empno) {        boolean b = empService.deleteEmp(empno);        return "redirect:/list.action";    }    @RequestMapping("/add.action")    public String insert() {        return "insert";    }}
       
      

配置文件：

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql:///test?characterEncoding=utf-8jdbc.username=rootjdbc.password=123456

      
          
           
               
        
         org.springframework.web.context.ContextLoaderListener
            
           
               
        
         contextConfigLocation
                
        
         classpath:applicationContext.xml
            
           
           
               
        
         spring-mvc
                
        
         org.springframework.web.servlet.DispatcherServlet
                
                    
         
          contextConfigLocation
                     
         
          classpath:spring-mvc.xml
                 
            
           
               
        
         spring-mvc
                
        
         *.action
            
           
           
               
        
         CharacterEncoding
                
        
         org.springframework.web.filter.CharacterEncodingFilter
                
                    
         
          encoding
                     
         
          UTF-8
                 
            
           
               
        
         CharacterEncoding
                
        
         /*
            
       
      

页面：

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@ taglib prefix="fm" uri="http://java.sun.com/jsp/jstl/fmt" %><%--  Created by IntelliJ IDEA.  User: Administrator  Date: 2019/8/7  Time: 15:58  To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %>    
              
      
      
           
        
                 
编号
                 
姓名
                 
工作
                 
部门
                 
工资
                 
入职日期
                 
操作
            
           
       
            
                     
${i.count}
                     
${emp.ename}
                     
${emp.job}
                     
${emp.deptno}
                     
${emp.sal}
                     
          
                     
                修改                删除                插入            
                
               
      

<%@ taglib prefix="fm" uri="http://java.sun.com/jsp/jstl/fmt" %><%--  Created by IntelliJ IDEA.  User: Administrator  Date: 2019/8/7  Time: 16:32  To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %>    
      
    
           姓名
       
       
    工作
       
       
    部门
       
       
    工资
       
       
    入职日期
       " name="hiredate"/>
       
    
       
      

运行tomcat测试