springmvc增删改查！

项目的包结构
jar包


com.fasterxml.jackson.core
jackson-databind
2.8.8.1


junit
junit
3.8.1
test


javax.servlet
javax.servlet-api
3.1.0
provided



org.springframework
spring-webmvc
4.3.6.RELEASE

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context-support</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-web</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>

<!-- 为了方便进行单元测试，添加spring-test包 -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-test</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-aspects</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-expression</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-orm</artifactId>
  <version>4.3.6.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.aspectj</groupId>
  <artifactId>aspectjweaver</artifactId>
  <version>1.8.5</version>
</dependency>
<!-- jstl -->
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
</dependency>
<dependency>
  <groupId>org.apache.tomcat.embed</groupId>
  <artifactId>tomcat-embed-core</artifactId>
  <version>8.5.29</version>
</dependency>
<!--spring 整合mybatis -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.3.0</version>
</dependency>
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.46</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-beanutils/commons-beanutils -->
<dependency>
  <groupId>commons-beanutils</groupId>
  <artifactId>commons-beanutils</artifactId>
  <version>1.8.0</version>
</dependency>
<dependency>
  <groupId>log4j</groupId>
  <artifactId>log4j</artifactId>
  <version>1.2.12</version>
</dependency>
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.2.3</version>
</dependency>
<dependency>
  <groupId>c3p0</groupId>
  <artifactId>c3p0</artifactId>
  <version>0.9.1.2</version>
</dependency>
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.3.0</version>
</dependency>

<dependency>
  <groupId>commons-fileupload</groupId>
  <artifactId>commons-fileupload</artifactId>
  <version>1.3.1</version>
</dependency>

<!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
<dependency>
  <groupId>commons-io</groupId>
  <artifactId>commons-io</artifactId>
  <version>2.4</version>
</dependency>

**controller中的方法** package com.qf.controller;

import com.qf.domain.User;
import com.qf.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

/**

• Created by Administrator on 2019/5/23.
  */
  @Controller
  @RequestMapping("/user")
  public class UserController {
  @Autowired
  private UserService userService;
  @RequestMapping("/selectAll")
  public ModelAndView selectAll(){
  //调用service层拿到数据库的结果集
  List users = userService.selectAll();
  System.out.println(users);
  ModelAndView md = new ModelAndView();
  md.setViewName(“user”);
  md.addObject(“users”,users);
  return md;
  }
  @RequestMapping("/deleteById/{id}")
  public String deleteById(@PathVariable(value = “id”)int id){
  userService.deleteById(id);
  return “forward:/user/selectAll”;
  }
  @RequestMapping(value = “/save”,method = RequestMethod.POST)
  public String update(User user){
  userService.update(user);
  return “forward:/user/selectAll”;
  }
  @RequestMapping("/insert")
  public String insert(User user){
  userService.insert(user);
  return “forward:/user/selectAll”;
  }
  @RequestMapping("/select/{id}")
  public ModelAndView select(@PathVariable(value = “id”)int id){
  User user = userService.selectById(id);
  ModelAndView modelAndView = new ModelAndView();
  modelAndView.setViewName(“update”);
  modelAndView.addObject(“user”,user);
  return modelAndView;
  }
  }
  

<?xml version="1.0" encoding="UTF-8" ?>

<resultMap id="userResult" type="com.qf.domain.User">
    <id column="id" property="id"></id>
    <result column="user_name" property="name"></result>
    <result column="age" property="age"></result>
    <result column="sex" property="sex"></result>
    <result column="address" property="address"></result>
</resultMap>
<select id="selectAll"  resultMap="userResult">
    select * from user
</select>
<select id="selectById" resultMap="userResult">
    select * from user where id = #{id}
</select>
<delete id="deleteById" parameterType="Integer">
     delete from user where id =#{id}
</delete>
<insert id="insert" parameterType="com.qf.domain.User">
    insert into user(id,user_name,age,sex,address) VALUES(#{id},#{name},#{age},#{sex},#{address})
</insert>
<update id="update" parameterType="com.qf.domain.User">
    update user set user_name=#{name},age=#{age},sex=#{sex},address=#{address} where id= #{id}
</update>

**jsp**