项目的包结构
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;
}
}
<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** ![在这里插入图片描述](https://img-blog.csdnimg.cn/20190524195250777.png) ![在这里插入图片描述](https://img-blog.csdnimg.cn/20190524195317290.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1JheWtpZXVf,size_16,color_FFFFFF,t_70)![在这里插入图片描述](https://img-blog.csdnimg.cn/20190524195344571.png)