1、创建如下所示项目

2、在src下的com.entity包下创建 Emp.java

1 package com.entity; 2 /** 3  *  4  * @author Holly老师 5  * 6  */ 7 public class Emp { 8    private Integer empno; 9    private String ename;10    private double sal;11    private Integer deptno;12    private String dname;13    14 public Integer getEmpno() {15     return empno;16 }17 public void setEmpno(Integer empno) {18     this.empno = empno;19 }20 public String getEname() {21     return ename;22 }23 public void setEname(String ename) {24     this.ename = ename;25 }26 public double getSal() {27     return sal;28 }29 public void setSal(double sal) {30     this.sal = sal;31 }32 public Integer getDeptno() {33     return deptno;34 }35 public void setDeptno(Integer deptno) {36     this.deptno = deptno;37 }38 public String getDname() {39     return dname;40 }41 public void setDname(String dname) {42     this.dname = dname;43 }44 @Override45 public String toString() {46     return "Emp [deptno=" + deptno + ", dname=" + dname + ", empno=" + empno47             + ", ename=" + ename + ", sal=" + sal + "]";48 }49    50 51 }

3、在src下的com.mapper包下创建 EmpMapper.java

1 package com.mapper; 2  3 import java.util.List; 4  5 import com.entity.Emp; 6 /** 7  *  8  * @author Holly老师 9  *10  */11 public interface EmpMapper {12     public List
      
        findAll();13 14 }
      

4、在src下的com.mapper包下创建 EmpMapper.xml

1 
      2 3 
      
       4   
       5     select e.empno,e.ename,e.sal,e.deptno,d.dname from emp e,dept d where e.deptno=d.deptno6   7 
      

5、在src下的com.service包下创建 EmpService.java

1 package com.service; 2  3 import java.util.List; 4  5 import com.entity.Emp; 6  7 /** 8  *  9  * @author Holly老师10  *11  */12 public interface EmpService {13     14     List
      
        findAll();15 16 }
      

6、在src下的com.service.impl包下创建EmpServiceImpl.java

1 package com.service.impl; 2  3 import java.util.List; 4  5  6 import javax.annotation.Resource; 7  8 import org.springframework.stereotype.Service; 9 import org.springframework.transaction.annotation.Transactional;10 11 import com.entity.Emp;12 import com.mapper.EmpMapper;13 import com.service.EmpService;14 /**15  * 16  * @author Holly老师17  *18  */19 @Service20 @Transactional21 public class EmpServiceImpl implements EmpService {22     @Resource23     private EmpMapper empMapper;24 25     public List
      
        findAll() {26        return empMapper.findAll();        27     }28 29 }
      

7、在com.controller包下创建EmpController.java

1 package com.controller; 2 import java.util.List; 3 import javax.annotation.Resource; 4 import javax.servlet.http.HttpServletRequest; 5 import javax.servlet.http.HttpServletResponse; 6 import org.springframework.stereotype.Controller; 7 import org.springframework.web.bind.annotation.RequestMapping; 8 import com.entity.Emp; 9 import com.service.impl.EmpServiceImpl;10 /**11  * 7.控制类12  * @author pc13  *14  */15 @Controller16 public class EmpController {17     @Resource18     private EmpServiceImpl empServiceImpl;19     //方法120     @RequestMapping("/findAll.do")21     public String findAll(HttpServletRequest request,HttpServletResponse response){22         List
      
        list=empServiceImpl.findAll();23         if(list!=null){24             System.out.println("findAll success");25             request.setAttribute("list", list);26         }else{27             System.out.println("findAll error");28             29         }30         return "/index.jsp";31     }32     33 34 }
      

8、在WebRoot下的WEB-INF下创建springmvc-servlet.xml

1 
       2 
      
       19 20 
       21 
       22 23 
       24 
       25 26 
       27 
       
        28   
        29   
        30   
        31   
        32 
       33 34 
       35 
       
        36   
        37 
       38 39 
       40 
       
        41   
        42   
        43 
       44 45 
       46 
       
        47   
        48 
       49 
      

9、在WebRoot下的WEB-INF下创建web.xml

1 
       2 
      
        7     
       
         8       
        
         springmvc
         9       
        
         org.springframework.web.servlet.DispatcherServlet
        10     
       11     
       
        12       
        
         springmvc
        13       
        
         *.do
        14     
       15     
       
        16       
        
         CharacterEncodingFilter
        17       
        
         org.springframework.web.filter.CharacterEncodingFilter
        18       
        
         19         
         
          encoding
         20         
         
          UTF-8
         21       
        22     
       23     
       
        24      
        
         CharacterEncodingFilter
        25       
        
         /*
        26     
       27   
       
        28     
        29   
       30 
      

10、在WebRoot下创建index.jsp

1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> 2 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; 6 %> 7  8  9 10   11     12     13     14     
      15     
      16     
          17     
      18     
      19     
      22   23   24   25       
      
       28         
      
      
       26         
27         
29         30        
       
        
         
员工编号
         
员工姓名
         
工资
         
部门编号
         
部门名称
        
        
         
${i.empno }
         
${i.ename }
         
${i.sal }
         
${i.deptno }
         
${i.dname}
        
       
      
31       32   33 

11、运行效果如下