5、spring+SpringMVC+MyBatis+PageHelper+ajax+idea+maven
1、项目结构如下
2、编辑pom.xml文件配置依赖
1 <?xml version="1.0" encoding="UTF-8"?> 2 3 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <modelVersion>4.0.0</modelVersion> 6 7 <groupId>com</groupId> 8 <artifactId>ssm_xml_page_ajax_day47</artifactId> 9 <version>1.0-SNAPSHOT</version> 10 <packaging>war</packaging> 11 12 <name>ssm_xml_page_ajax_day47 Maven Webapp</name> 13 <!-- FIXME change it to the project's website --> 14 <url>http://www.example.com</url> 15 16 <properties> 17 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> 18 <maven.compiler.source>1.7</maven.compiler.source> 19 <maven.compiler.target>1.7</maven.compiler.target> 20 </properties> 21 22 <dependencies> 23 <dependency> 24 <groupId>junit</groupId> 25 <artifactId>junit</artifactId> 26 <version>4.12</version> 27 </dependency> 28 29 30 <!--1 https://mvnrepository.com/artifact/org.springframework/spring-beans --> 31 <dependency> 32 <groupId>org.springframework</groupId> 33 <artifactId>spring-beans</artifactId> 34 <version>4.3.6.RELEASE</version> 35 </dependency> 36 37 38 <!--2 https://mvnrepository.com/artifact/org.springframework/spring-context --> 39 <dependency> 40 <groupId>org.springframework</groupId> 41 <artifactId>spring-context</artifactId> 42 <version>4.3.6.RELEASE</version> 43 </dependency> 44 45 46 <!-- 3https://mvnrepository.com/artifact/org.springframework/spring-core --> 47 <dependency> 48 <groupId>org.springframework</groupId> 49 <artifactId>spring-core</artifactId> 50 <version>4.3.6.RELEASE</version> 51 </dependency> 52 53 54 <!--4 https://mvnrepository.com/artifact/org.springframework/spring-expression --> 55 <dependency> 56 <groupId>org.springframework</groupId> 57 <artifactId>spring-expression</artifactId> 58 <version>4.3.6.RELEASE</version> 59 </dependency> 60 61 62 <!--5 https://mvnrepository.com/artifact/org.springframework/spring-aop --> 63 <dependency> 64 <groupId>org.springframework</groupId> 65 <artifactId>spring-aop</artifactId> 66 <version>4.3.6.RELEASE</version> 67 </dependency> 68 69 70 <!--6 https://mvnrepository.com/artifact/aopalliance/aopalliance --> 71 <dependency> 72 <groupId>aopalliance</groupId> 73 <artifactId>aopalliance</artifactId> 74 <version>1.0</version> 75 </dependency> 76 77 78 <!--7 https://mvnrepository.com/artifact/org.aspectj/aspectjweaver --> 79 <dependency> 80 <groupId>org.aspectj</groupId> 81 <artifactId>aspectjweaver</artifactId> 82 <version>1.8.10</version> 83 </dependency> 84 85 86 <!--8 https://mvnrepository.com/artifact/log4j/log4j --> 87 <dependency> 88 <groupId>log4j</groupId> 89 <artifactId>log4j</artifactId> 90 <version>1.2.17</version> 91 </dependency> 92 93 94 <!--9 https://mvnrepository.com/artifact/commons-logging/commons-logging --> 95 <dependency> 96 <groupId>commons-logging</groupId> 97 <artifactId>commons-logging</artifactId> 98 <version>1.2</version> 99 </dependency> 100 101 102 <!--10 https://mvnrepository.com/artifact/org.springframework/spring-jdbc --> 103 <dependency> 104 <groupId>org.springframework</groupId> 105 <artifactId>spring-jdbc</artifactId> 106 <version>4.3.6.RELEASE</version> 107 </dependency> 108 109 110 <!--11 https://mvnrepository.com/artifact/org.springframework/spring-orm --> 111 <dependency> 112 <groupId>org.springframework</groupId> 113 <artifactId>spring-orm</artifactId> 114 <version>4.3.6.RELEASE</version> 115 </dependency> 116 117 118 <!--12 https://mvnrepository.com/artifact/org.springframework/spring-tx --> 119 <dependency> 120 <groupId>org.springframework</groupId> 121 <artifactId>spring-tx</artifactId> 122 <version>4.3.6.RELEASE</version> 123 </dependency> 124 125 126 <!--13 https://mvnrepository.com/artifact/org.springframework/spring-web --> 127 <dependency> 128 <groupId>org.springframework</groupId> 129 <artifactId>spring-web</artifactId> 130 <version>4.3.6.RELEASE</version> 131 </dependency> 132 133 134 <!--14 https://mvnrepository.com/artifact/org.springframework/spring-webmvc --> 135 <dependency> 136 <groupId>org.springframework</groupId> 137 <artifactId>spring-webmvc</artifactId> 138 <version>4.3.6.RELEASE</version> 139 </dependency> 140 141 142 <!--15 https://mvnrepository.com/artifact/org.mybatis/mybatis --> 143 <dependency> 144 <groupId>org.mybatis</groupId> 145 <artifactId>mybatis</artifactId> 146 <version>3.4.6</version> 147 </dependency> 148 149 150 <!--16 https://mvnrepository.com/artifact/mysql/mysql-connector-java --> 151 <dependency> 152 <groupId>mysql</groupId> 153 <artifactId>mysql-connector-java</artifactId> 154 <version>5.1.38</version> 155 </dependency> 156 157 158 <!--17 https://mvnrepository.com/artifact/org.mybatis/mybatis-spring --> 159 <dependency> 160 <groupId>org.mybatis</groupId> 161 <artifactId>mybatis-spring</artifactId> 162 <version>1.3.2</version> 163 </dependency> 164 165 <!--18 https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api --> 166 <dependency> 167 <groupId>javax.servlet</groupId> 168 <artifactId>javax.servlet-api</artifactId> 169 <version>3.1.0</version> 170 </dependency> 171 172 <!--19 https://mvnrepository.com/artifact/javax.servlet/jstl --> 173 <dependency> 174 <groupId>javax.servlet</groupId> 175 <artifactId>jstl</artifactId> 176 <version>1.2</version> 177 </dependency> 178 179 180 <!--20 https://mvnrepository.com/artifact/taglibs/standard --> 181 <dependency> 182 <groupId>taglibs</groupId> 183 <artifactId>standard</artifactId> 184 <version>1.1.2</version> 185 </dependency> 186 187 <!--文件上传使用的jar--> 188 <!--21 https://mvnrepository.com/artifact/commons-io/commons-io --> 189 <dependency> 190 <groupId>commons-io</groupId> 191 <artifactId>commons-io</artifactId> 192 <version>2.4</version> 193 </dependency> 194 <!--22--> 195 <dependency> 196 <groupId>commons-fileupload</groupId> 197 <artifactId>commons-fileupload</artifactId> 198 <version>1.3.3</version> 199 </dependency> 200 201 <!--23 下载ajax封装数据json格式交互的jar--> 202 <dependency> 203 <groupId>com.fasterxml.jackson.core</groupId> 204 <artifactId>jackson-databind</artifactId> 205 <version>2.9.6</version> 206 </dependency> 207 208 <dependency> 209 <groupId>com.fasterxml.jackson.core</groupId> 210 <artifactId>jackson-core</artifactId> 211 <version>2.9.6</version> 212 </dependency> 213 214 <dependency> 215 <groupId>com.fasterxml.jackson.core</groupId> 216 <artifactId>jackson-annotations</artifactId> 217 <version>2.9.6</version> 218 </dependency> 219 220 <!--使用4的版本否则springmvc的xml--> 221 <dependency> 222 <groupId>com.github.pagehelper</groupId> 223 <artifactId>pagehelper</artifactId> 224 <version>4.1.6</version> 225 </dependency> 226 </dependencies> 227 228 </project>
3、在java目录下的com.pojo包下创建Dept.java和Emp.java持久化类
1 package com.pojo; 2 import org.springframework.stereotype.Component; 3 4 import java.io.Serializable; 5 import java.util.List; 6 /** 7 * 一方引用多方list集合 8 */ 9 @Component 10 public class Dept implements Serializable { 11 private Integer deptno ; 12 private String dname ; 13 private String loc ; 14 15 public Dept() { 16 } 17 18 public Dept(Integer deptno, String dname, String loc) { 19 this.deptno = deptno; 20 this.dname = dname; 21 this.loc = loc; 22 } 23 24 public Integer getDeptno() { 25 return deptno; 26 } 27 28 public void setDeptno(Integer deptno) { 29 this.deptno = deptno; 30 } 31 32 33 public String getDname() { 34 return dname; 35 } 36 37 public void setDname(String dname) { 38 this.dname = dname; 39 } 40 41 42 public String getLoc() { 43 return loc; 44 } 45 46 public void setLoc(String loc) { 47 this.loc = loc; 48 } 49 50 @Override 51 public String toString() { 52 return "Dept{" + 53 "deptno=" + deptno + 54 ", dname='" + dname + '\'' + 55 ", loc='" + loc + '\'' + 56 '}'; 57 } 58 }
1 package com.pojo; 2 3 import org.springframework.stereotype.Component; 4 5 import java.io.Serializable; 6 7 /** 8 * 多方引用一方对象 9 */ 10 @Component 11 public class Emp implements Serializable{ 12 private Integer empno ; 13 private String ename ; 14 private String job ; 15 private Integer mgr ; 16 private String hiredate ; 17 private Double sal ; 18 private Double comm ; 19 private Dept dept; 20 21 22 public Emp() { 23 } 24 25 public Emp(Integer empno, String ename, String job, Integer mgr, String hiredate, Double sal, Double comm, Dept dept) { 26 this.empno = empno; 27 this.ename = ename; 28 this.job = job; 29 this.mgr = mgr; 30 this.hiredate = hiredate; 31 this.sal = sal; 32 this.comm = comm; 33 this.dept = dept; 34 } 35 36 public Integer getEmpno() { 37 return empno; 38 } 39 40 public void setEmpno(Integer empno) { 41 this.empno = empno; 42 } 43 44 45 public String getEname() { 46 return ename; 47 } 48 49 public void setEname(String ename) { 50 this.ename = ename; 51 } 52 53 54 public String getJob() { 55 return job; 56 } 57 58 public void setJob(String job) { 59 this.job = job; 60 } 61 62 63 public Integer getMgr() { 64 return mgr; 65 } 66 67 public void setMgr(Integer mgr) { 68 this.mgr = mgr; 69 } 70 71 72 public String getHiredate() { 73 return hiredate; 74 } 75 76 public void setHiredate(String hiredate) { 77 this.hiredate = hiredate; 78 } 79 80 81 public Double getSal() { 82 return sal; 83 } 84 85 public void setSal(Double sal) { 86 this.sal = sal; 87 } 88 89 90 public Double getComm() { 91 return comm; 92 } 93 94 public void setComm(Double comm) { 95 this.comm = comm; 96 } 97 98 public Dept getDept() { 99 return dept; 100 } 101 102 public void setDept(Dept dept) { 103 this.dept = dept; 104 } 105 106 @Override 107 public String toString() { 108 return "Emp{" + 109 "empno=" + empno + 110 ", ename='" + ename + '\'' + 111 ", job='" + job + '\'' + 112 ", mgr=" + mgr + 113 ", hiredate='" + hiredate + '\'' + 114 ", sal=" + sal + 115 ", comm=" + comm + 116 ", dept=" + dept + 117 '}'; 118 } 119 }
4、在java目录下的com.mapper包下创建DeptMapper.java和EmpMapper.java映射接口
1 package com.mapper; 2 import com.pojo.Dept; 3 import org.springframework.stereotype.Repository; 4 import org.springframework.stereotype.Service; 5 6 import java.util.List; 7 @Repository 8 public interface DeptMapper { 9 List<Dept> selectAllDept(); 10 }
1 package com.mapper; 2 import com.pojo.Emp; 3 import org.springframework.stereotype.Repository; 4 5 import java.util.List; 6 @Repository 7 public interface EmpMapper { 8 List<Emp> selectEmp(Emp emp); 9 int insertEmp(Emp emp); 10 int updateEmp(Emp emp); 11 int deleteEmp(Emp emp); 12 }
5、在resouces目录下的mapper包下创建DeptMapper.xml和EmpMapper.xml映射文件
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 3 <!--配置规则：--> 4 <!--有代理的namespace值必须是映射接口全路径，sql节点的id值必须是映射接口中的方法名--> 5 <!--无代理的namespace值和sql节点的id值是任意的，但一般情况下和和有代理的原则一样--> 6 <mapper namespace="com.mapper.DeptMapper"> 7 <select id="selectAllDept" resultType="Dept"> 8 select * from dept 9 </select> 10 </mapper>
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 3 <mapper namespace="com.mapper.EmpMapper"> 4 <!-- 案例：select * from emp where empno=#{empno} or ename=#{ename} and job=#{job} 5 如果select节点中是以上sql语句，parameterType是Emp类型，则此情况可以使用where标签, 6 where标签的作用是如果if条件不满足则执行，如果满足if条件将会忽略where关键字后的 7 第一个or或and 8 select * from emp 9 <where> 10 <if test="empno!=null"> 11 empno=#{empno} 12 </if> 13 <if test="ename!=null"> 14 or ename=#{ename} 15 </if> 16 <if test="job!=null"> 17 and job=#{job} 18 </if> 19 </where> 20 --> 21 <!--if或when的test条件中的属性判断，必须从参数对象的第一层属性判断起，--> 22 <!--如果Emp类中有empno属性，有dept对象属性，则要判断empno值和dept中deptno的值，--> 23 <!--则写法是empno！=null，dept！=null && dept.deptno!=null--> 24 <select id="selectEmp" resultMap="empmap" parameterType="Emp"> 25 select d.dname,d.loc,e.* from emp e,dept d where e.deptno=d.deptno 26 <if test="empno!=null"> 27 and e.empno=#{empno} 28 </if> 29 <if test="ename!=null"> 30 and e.ename=#{ename} 31 </if> 32 <if test="job!=null"> 33 and e.job=#{job} 34 </if> 35 <if test="dept!=null and dept.deptno!=null and dept.deptno!=-1"> 36 and e.deptno=#{dept.deptno} 37 </if> 38 </select> 39 40 <resultMap id="empmap" type="Emp"> 41 <!--因为当前多方配置，因此在resultMap中先配置多方的主键和普通列的映射--> 42 <id column="EMPNO" property="empno"/> 43 <result column="ENAME" property="ename"/> 44 <result column="JOB " property="job"/> 45 <result column="MGR" property="mgr"/> 46 <result column="HIREDATE" property="hiredate"/> 47 <result column="SAL" property="sal"/> 48 <result column="COMM" property="comm"/> 49 50 <!--因为在多方引用了一方的对象，因此在引用一方对象属性的地方配置association节点--> 51 <!--association节点的property属性对应的多方引用一方的对象属性名,--> 52 <!--javaType是多方引用一方的类类型即配置类的全路径--> 53 <!--column是多方关联一方的外键列的列名--> 54 <association property="dept" javaType="Dept" column="DEPTNO"> 55 <!--由于多方引用的了一方对象，因此在association对象节点下配置一方的主键和普通字段--> 56 <id column="DEPTNO" property="deptno"/> 57 <result column="DNAME" property="dname"/> 58 <result column="LOC" property="loc"/> 59 </association> 60 </resultMap> 61 62 <insert id="insertEmp" parameterType="Emp"> 63 INSERT INTO emp(empno, ename, job, mgr, hiredate, sal, comm, deptno) VALUES(#{empno},#{ename},#{job},#{mgr},#{hiredate},#{sal},#{comm},#{dept.deptno}) 64 </insert> 65 66 <!--set标签的结束标签要在where条件之前--> 67 <update id="updateEmp" parameterType="Emp"> 68 UPDATE emp 69 <set> 70 <if test="ename!=null"> 71 ename=#{ename} , 72 </if> 73 <if test="job!=null"> 74 job=#{job} , 75 </if> 76 <if test="mgr!=null"> 77 mgr=#{mgr} , 78 </if> 79 <if test="hiredate!=null"> 80 hiredate=#{hiredate} , 81 </if> 82 <if test="sal!=null"> 83 sal=#{sal}, 84 </if> 85 <if test="comm!=null"> 86 comm=#{comm}, 87 </if> 88 <if test="dept!=null and dept.deptno!=null"> 89 deptno=#{dept.deptno} , 90 </if> 91 </set> 92 <include refid="wherecondition"/> 93 </update> 94 95 <delete id="deleteEmp" parameterType="Emp"> 96 delete from emp 97 <include refid="wherecondition"/> 98 </delete> 99 100 <!--定义公共的sql片段--> 101 <sql id="wherecondition"> 102 <where> 103 <if test="empno!=null"> 104 empno=#{empno} 105 </if> 106 </where> 107 </sql> 108 109 </mapper>
6、在resouces目录下创建log4j.properties日志文件
1 log4j.rootLogger=DEBUG, Console 2 #Console 3 log4j.appender.Console=org.apache.log4j.ConsoleAppender 4 log4j.appender.Console.layout=org.apache.log4j.PatternLayout 5 log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n 6 7 log4j.logger.org.apache=INFO 8 log4j.logger.java.sql.ResultSet=INFO 9 log4j.logger.java.sql.Connection=DEBUG 10 log4j.logger.java.sql.Statement=DEBUG 11 log4j.logger.java.sql.PreparedStatement=DEBUG
7、在java目录下的com.service包下创建业务层接口和实现类
1 package com.service; 2 3 import com.pojo.Dept; 4 5 import java.util.List; 6 7 public interface DeptService { 8 List<Dept> downOption(); 9 }
1 package com.service; 2 3 import com.mapper.DeptMapper; 4 import com.pojo.Dept; 5 import org.springframework.beans.factory.annotation.Autowired; 6 import org.springframework.stereotype.Service; 7 8 import java.util.List; 9 @Service 10 public class DeptServiceImpl implements DeptService{ 11 @Autowired 12 private DeptMapper deptMapper; 13 14 15 @Override 16 public List<Dept> downOption() { 17 return deptMapper.selectAllDept(); 18 } 19 }
1 package com.service; 2 3 import com.github.pagehelper.PageInfo; 4 import com.pojo.Emp; 5 6 import java.util.List; 7 8 public interface EmpService { 9 List<Emp> show(Emp emp); 10 PageInfo<Emp> showPage(Integer pageno,Integer pagesize,Emp emp); 11 int add(Emp emp); 12 int edit(Emp emp); 13 int del(Emp emp); 14 }
1 package com.service; 2 3 import com.github.pagehelper.Page; 4 import com.github.pagehelper.PageHelper; 5 import com.github.pagehelper.PageInfo; 6 import com.mapper.EmpMapper; 7 import com.pojo.Emp; 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.stereotype.Service; 10 import org.springframework.transaction.annotation.Transactional; 11 12 import javax.annotation.Resource; 13 import java.util.List; 14 /* 15 @Service的功能等同于代理对象在spring的xml文件中动态添加bean节点, 16 如果不指定名称，则底层代理在构建bean节点的时候id是类的第一个首字母小写 17 <bean id="empServiceImpl" class="com.service.EmpServiceImpl"/> 18 @Service(value = "empse")的功能等同于代理对象在spring的xml文件中动态添加id值为empse的bean节点 19 <bean id="empse" class="com.service.EmpServiceImpl"/> 20 */ 21 @Service 22 @Transactional 23 public class EmpServiceImpl implements EmpService { 24 /* 25 @Autowired是spring的资源包下注解，按照对象的类型进行自动注入， 26 和对象名称无关，只要类型是匹配的，代理就会在你需要的时候给你注入对象值 27 @Resource是javax包下的注解，按照对象属性名进行注入， 28 和对象名称关系密切，如果对象名称不匹配，则不能完成注入，会报错 29 总结：相比而言，使用@Resource的出错记录更大，因此我们常规选择使用@Autowired 30 */ 31 @Autowired 32 private EmpMapper empMapper; 33 34 // ★★★★ 35 @Override 36 public PageInfo<Emp> showPage(Integer pageno, Integer pagesize, Emp emp) { 37 //封装分页参数值 38 PageHelper.startPage(pageno,pagesize); 39 //查询所有 40 List<Emp> empList=empMapper.selectEmp(emp); 41 //返回根据分页集合对象再进行分页 42 return new PageInfo<Emp>(empList); 43 } 44 45 @Override 46 public List<Emp> show(Emp emp) { 47 return empMapper.selectEmp(emp); 48 } 49 50 @Override 51 public int add(Emp emp) { 52 return empMapper.insertEmp(emp); 53 } 54 55 @Override 56 public int edit(Emp emp) { 57 return empMapper.updateEmp(emp); 58 } 59 60 @Override 61 public int del(Emp emp) { 62 return empMapper.deleteEmp(emp); 63 } 64 }
8、在java目录下的com.controller包下创建控制类CenterController.java
1 package com.controller; 2 3 import com.github.pagehelper.PageInfo; 4 import com.pojo.Dept; 5 import com.pojo.Emp; 6 import com.service.DeptService; 7 import com.service.EmpService; 8 import org.apache.ibatis.annotations.Param; 9 import org.springframework.beans.factory.annotation.Autowired; 10 import org.springframework.stereotype.Controller; 11 import org.springframework.ui.Model; 12 import org.springframework.web.bind.annotation.RequestMapping; 13 import org.springframework.web.bind.annotation.ResponseBody; 14 15 import javax.servlet.http.HttpServletRequest; 16 import javax.servlet.http.HttpServletResponse; 17 import javax.servlet.http.HttpSession; 18 import java.util.HashMap; 19 import java.util.List; 20 import java.util.Map; 21 22 @Controller 23 public class CenterController { 24 @Autowired 25 private DeptService deptService; 26 27 @Autowired 28 private EmpService empService; 29 30 /** 31 * ★★★★★ajax异步请求， 32 * 如果ajax回调时，返回多个不同类型的对象或变量，则返回值类型用Map<String，Object> 33 * 如果ajax回调时，只返回一个类型的对象或变量，则返回值用具体的对象或变量的类型 34 * @param pageno 分页的页码 35 * @param emp 异步请求时使用对象接受前台多个参数值，前提是ajax参数名和对象的第一层属性名一致 36 * @return ajax回调的数据结果 37 */ 38 @RequestMapping("/page.do") 39 @ResponseBody 40 public PageInfo<Emp> showPage(Integer pageno,Emp emp){ 41 //定义map集合用来封装ajax回调的数据 42 Map<String,Object> map=new HashMap<String,Object>(); 43 PageInfo<Emp> pageInfo=empService.showPage(pageno,3,emp); 44 map.put("pageInfo",pageInfo); 45 return pageInfo; 46 } 47 48 @RequestMapping("/option.do") 49 public String showData(HttpSession session, Model model){ 50 List<Dept> deptlist=deptService.downOption(); 51 session.setAttribute("deptlist",deptlist); 52 //默认跳转使用转发 53 return "main.jsp"; 54 } 55 56 @RequestMapping("/info.do") 57 public String showInfo(Emp emp,Model model){ 58 //根据主键编号查询只有一条数据 59 Emp emp2=empService.show(emp).get(0); 60 // 功能等同于request.setAttribute(key，value) 61 model.addAttribute("emp2",emp2); 62 //默认跳转使用转发 63 return "edit.jsp"; 64 } 65 @RequestMapping("/edit.do") 66 public String edit(Emp emp){ 67 //根据主键编号查询只有一条数据 68 System.out.println(empService.edit(emp)>0?"edit success":"edit fail");; 69 //使用重定向跳转 70 return "redirect:/main.jsp"; 71 } 72 73 @RequestMapping("/add.do") 74 public String add(Emp emp){ 75 System.out.println("add controller:"+emp); 76 //根据主键编号查询只有一条数据 77 System.out.println(empService.add(emp)>0?"add success":"add fail");; 78 //使用重定向跳转 79 return "redirect:/main.jsp"; 80 } 81 82 @RequestMapping("/del.do") 83 public String del(Emp emp){ 84 //根据主键编号查询只有一条数据 85 System.out.println(empService.del(emp)>0?"del success":"del fail");; 86 //使用重定向跳转 87 return "redirect:/main.jsp"; 88 } 89 }
9、在webapp目录下的WEB-INF文件夹下创建springmvc-servlet.xml核心配置文件，和web.xml文件
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xmlns:aop="http://www.springframework.org/schema/aop" 5 xmlns:context="http://www.springframework.org/schema/context" 6 xmlns:tx="http://www.springframework.org/schema/tx" 7 xmlns:mvc="http://www.springframework.org/schema/mvc" 8 xsi:schemaLocation="http://www.springframework.org/schema/beans 9 http://www.springframework.org/schema/beans/spring-beans.xsd 10 http://www.springframework.org/schema/aop 11 http://www.springframework.org/schema/aop/spring-aop.xsd 12 http://www.springframework.org/schema/context 13 http://www.springframework.org/schema/context/spring-context.xsd 14 http://www.springframework.org/schema/tx 15 http://www.springframework.org/schema/tx/spring-tx.xsd 16 http://www.springframework.org/schema/mvc 17 http://www.springframework.org/schema/mvc/spring-mvc.xsd 18 "> 19 <!--1.mvc注解驱动--> 20 <mvc:annotation-driven/> 21 <!--2.全局扫描包--> 22 <context:component-scan base-package="com"/> 23 <!--3.驱动管理数据源--> 24 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 25 <property name="driverClassName" value="com.mysql.jdbc.Driver"/> 26 <property name="url" value="jdbc:mysql://localhost:3306/ar"/> 27 <property name="username" value="root"/> 28 <property name="password" value="123456"/> 29 </bean> 30 <!--4.数据源事务管理--> 31 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 32 <property name="dataSource" ref="dataSource"/> 33 </bean> 34 <!--5.事务注解驱动--> 35 <tx:annotation-driven transaction-manager="transactionManager"/> 36 <!--6.sqlsessionfacotrybean--> 37 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 38 <property name="dataSource" ref="dataSource"/> 39 <property name="typeAliasesPackage" value="com.pojo"/> 40 <property name="mapperLocations" value="classpath:mapper/*.xml"/> 41 <!--分页插件的配置，配置的目的是告诉底层应该使用什么类型的数据库分页语句--> 42 <property name="plugins"> 43 <array> 44 <bean class="com.github.pagehelper.PageHelper"> 45 <property name="properties" value="mysql"/> 46 </bean> 47 </array> 48 </property> 49 </bean> 50 <!--7.映射扫描参数--> 51 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 52 <property name="basePackage" value="com.mapper"/> 53 </bean> 54 </beans>
1 <!DOCTYPE web-app PUBLIC 2 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" 3 "http://java.sun.com/dtd/web-app_2_3.dtd" > 4 5 <web-app> 6 <filter> 7 <filter-name>Character</filter-name> 8 <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> 9 <init-param> 10 <param-name>encoding</param-name> 11 <param-value>UTF-8</param-value> 12 </init-param> 13 </filter> 14 <filter-mapping> 15 <filter-name>Character</filter-name> 16 <url-pattern>/*</url-pattern> 17 </filter-mapping> 18 <servlet> 19 <servlet-name>springmvc</servlet-name> 20 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 21 </servlet> 22 <servlet-mapping> 23 <servlet-name>springmvc</servlet-name> 24 <url-pattern>*.do</url-pattern> 25 </servlet-mapping> 26 <welcome-file-list> 27 <welcome-file>option.do</welcome-file> 28 </welcome-file-list> 29 </web-app>
10、在webapp目录下创建js目录，且将jquery的库文件jquery-1.8.3.js拷贝进去
11、在webapp目录下创建main.jsp文件
1 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 2 <%@ page contentType="text/html;charset=UTF-8" language="java" %> 3 <%@ page isELIgnored="false" %> 4 <html> 5 <head> 6 <title>首页</title> 7 <script type="text/javascript" src="js/jquery-1.8.3.js"></script> 8 <script type="text/javascript" src="js/show.js"></script> 9 </head> 10 <body> 11 <a href="add.jsp">添加</a> 12 <p> 13 <span>部门：</span> 14 <select name="dept.deptno" id="depto"> 15 <option value="-1">--请选择--</option> 16 <c:forEach var="i" items="${deptlist}"> 17 <option value="${i.deptno}">${i.dname}</option> 18 </c:forEach> 19 </select> 20 <input type="button" value="查询"> 21 </p> 22 <table></table> 23 <p id="pageroot"></p> 24 </body> 25 </html>
12、在webapp目录的js目录下创建show.js文件
1 $(function () { 2 //初始化查询所有 3 initData(1,-1); 4 //下拉列表条件查 5 $("[type=button]").click(function () { 6 var depto=$("#depto").val(); 7 initData(1,depto); 8 }); 9 10 }); 11 12 function initData(pageno,deptno) { 13 $.ajax({ 14 url:"page.do", 15 type:"post", 16 dataType:"json", 17 data:{"pageno":pageno,"dept.deptno":deptno}, 18 async:true, 19 success:function (obj) { 20 //将值打印在控制台 21 console.log(obj); 22 //为了防止频繁发送请求重复拼接问题，因此在拼接数据之前，先清楚原有的数据内容 23 $("table").html(" "); 24 var str=" <tr>"; 25 str+=" <th>员工编号</th>"; 26 str+=" <th>员工姓名</th>"; 27 str+=" <th>员工工资</th>"; 28 str+=" <th>部门名称</th>"; 29 str+=" <th>操作</th>"; 30 str+=" </tr>"; 31 for(var i=0;i<obj.list.length;i++){ 32 str+="<tr>"; 33 str+="<td>"+obj.list[i].empno +"</td>"; 34 str+="<td>"+obj.list[i].ename +"</td>"; 35 str+="<td>"+obj.list[i].sal +"</td>"; 36 str+="<td>"+obj.list[i].dept.dname+"</td>"; 37 str+="<td>" + 38 "<a href='info.do?empno="+obj.list[i].empno+"'>修改</a>" + 39 "|" + 40 "<a href='del.do?empno="+obj.list[i].empno+"'>删除</a>" + 41 "</td>"; 42 str+="</tr>"; 43 } 44 $("table").append(str); 45 46 var pagestr="第"+obj.pageNum+"/"+obj.pages+"页"; 47 pagestr+=" "; 48 if(pageno>1){ 49 pagestr+="<a href='javascript:void(0);' onclick='pageData(1)'>首页</a>"; 50 pagestr+=" "; 51 pagestr+="<a href='javascript:void(0);' onclick='pageData("+obj.prePage+")'>上一页</a>"; 52 pagestr+=" "; 53 }else{ 54 pagestr+="<a href='javascript:alert(\"已经是第一页！\");'>首页</a>"; 55 pagestr+=" "; 56 pagestr+="<a href='javascript:alert(\"已经是第一页,无上一页！\");'>上一页</a>"; 57 pagestr+=" "; 58 } 59 if(pageno<obj.pages){ 60 pagestr+="<a href='javascript:void(0);' onclick='pageData("+obj.nextPage+")'>下一页</a>"; 61 pagestr+=" "; 62 pagestr+="<a href='javascript:void(0);' onclick='pageData("+obj.pages+")'>末页</a>"; 63 pagestr+=" "; 64 }else{ 65 pagestr+="<a href='javascript:alert(\"已经是最后一页！\");'>下一页</a>"; 66 pagestr+=" "; 67 pagestr+="<a href='javascript:alert(\"已经是最后一页,无下一页！\");'>末页</a>"; 68 pagestr+=" "; 69 } 70 pagestr+="共"+obj.total+"条"; 71 72 $("#pageroot").html(pagestr); 73 }, 74 error:function () { 75 alert("get data error"); 76 } 77 }); 78 } 79 function pageData(pageno) { 80 //获取下列列表的条件 81 var depto=$("#depto").val(); 82 initData(pageno,depto); 83 }
13、在webapp目录下创建add.jsp文件
1 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 2 <%@ page contentType="text/html;charset=UTF-8" language="java" %> 3 <%@ page isELIgnored="false" %> 4 <html> 5 <head> 6 <title>添加信息</title> 7 </head> 8 <body> 9 <fieldset> 10 <legend>添加员工信息</legend> 11 <form action="add.do" method="post"> 12 <table> 13 <tr> 14 <th>部门名称：</th> 15 <td> 16 <select name="dept.deptno"> 17 <option value="-1">--请选择--</option> 18 <c:forEach var="i" items="${deptlist}"> 19 <option value="${i.deptno}">${i.dname}</option> 20 </c:forEach> 21 </select> 22 </td> 23 </tr> 24 <tr> 25 <th>员工编号：</th> 26 <td><input type="text" name="empno"/></td> 27 </tr> 28 <tr> 29 <th>员工姓名：</th> 30 <td><input type="text" name="ename" /></td> 31 </tr> 32 <tr> 33 <th>员工薪资：</th> 34 <td><input type="text" name="sal" /></td> 35 </tr> 36 <tr> 37 <td colspan="2" align="center"> 38 <input type="submit" value="提交"/> 39 <input type="reset" value="重置"/> 40 </td> 41 </tr> 42 </table> 43 </form> 44 </fieldset> 45 </body> 46 </html>
14、在webapp目录下创建edit.jsp文件
1 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 2 <%@ page contentType="text/html;charset=UTF-8" language="java" %> 3 <%@ page isELIgnored="false" %> 4 <html> 5 <head> 6 <title>编辑信息</title> 7 </head> 8 <body> 9 <fieldset> 10 <legend>编辑员工信息</legend> 11 <form action="edit.do?empno=${emp2.empno}" method="post"> 12 <table> 13 <tr> 14 <th>部门名称：</th> 15 <td> 16 <select name="dept.deptno"> 17 <option value="-1">--请选择--</option> 18 <c:forEach var="i" items="${deptlist}"> 19 <c:choose> 20 <c:when test="${emp2.dept.deptno eq i.deptno}"> 21 <option value="${i.deptno}" selected="selected">${i.dname}</option> 22 </c:when> 23 <c:otherwise> 24 <option value="${i.deptno}">${i.dname}</option> 25 </c:otherwise> 26 </c:choose> 27 </c:forEach> 28 </select> 29 </td> 30 </tr> 31 <tr> 32 <th>员工姓名：</th> 33 <td><input type="text" name="ename" value="${emp2.ename}"/></td> 34 </tr> 35 <tr> 36 <th>员工薪资：</th> 37 <td><input type="text" name="sal" value="${emp2.sal}"/></td> 38 </tr> 39 <tr> 40 <td colspan="2" align="center"> 41 <input type="submit" value="提交"/> 42 <input type="reset" value="重置"/> 43 </td> 44 </tr> 45 </table> 46 </form> 47 </fieldset> 48 49 </body> 50 </html>
15、部署启动运行
此文章为原创，转载请注明出处！需要本案例源码，理论讲解视频，代码操作视频的，请私信联系作者！
