eclipse+maven+springboot+mybatis+jsp实现增删改查web项目的详细步骤

本文详细介绍了如何利用Eclipse搭建环境,创建Maven项目,结合SpringBoot、Mybatis和JSP实现一个包含增删改查功能的Web应用。步骤包括环境配置、项目新建、代码和框架结构搭建,以及最终的访问地址和展示结果。
摘要由CSDN通过智能技术生成

1、搭建环境

(1)、搭建环境准备工作

a、官网下载eclipse
b、官网下载maven,并配置maven环境,和本地仓库路径
c、eclipse配置maven
在这里插入图片描述
在这里插入图片描述

(2)、新建项目

(1)file—》new—》maven project
在这里插入图片描述
(2)点击next
在这里插入图片描述
(3)next
在这里插入图片描述
(4)finish完成
(5)哈哈到此环境就搭建完了

2、代码和框架构架

在这里插入图片描述
(1)、dao

@Mapper
public interface UserDAO extends BaseMapper<User> {
   

	List<User> selectUser();

	List<User> selectByUserId(String userId);

	User selectOneById(String userId);

	void addUser(User user);

	void updateUser(User user);

	void deleteByUserId(String userId);
}

(2)、server

public interface UserService {
   
	List<User> getUser();

	void addUser(User user);

	List<User> selectByUserId(String userId);

	void updateUser(User user);

	void deleteByUserId(String userId);

	User selectOneById(String userId);
}

(3)、serverimpl

@Service("userService")
public class UserServiceImpl implements UserService {
   

	@Autowired
	private UserDAO userDao;

	@Override
	public List<User> getUser() {
   
		return userDao.selectUser();
	}

	@Override
	public void addUser(User user) {
   
		userDao.addUser(user);
	}

	@Override
	public List<User> selectByUserId(String userId) {
   
		List<User> selectByUserId = userDao.selectByUserId(userId);
		return selectByUserId;
	}

	@Override
	public void updateUser(User user) {
   
		userDao.updateUser(user);
	}

	@Override
	public void deleteByUserId(String userId) {
   
		userDao.deleteByUserId(userId);
	}

	@Override
	public User selectOneById(String userId) {
   
		return userDao.selectOneById(userId);
	}

}

(4)、entity

public class User {
   

	  private String userId ;
	  private String userCode ;
	  private String userName;
		public String getUserId() {
   
			return userId;
		}
		public void setUserId(String userId) {
   
			this.userId = userId;
		}
		public String getUserCode() {
   
			return userCode;
		}
		public void setUserCode(String userCode) {
   
			this.userCode = userCode;
		}
		public String getUserName() {
   
			return userName;
		}
		public void setUserName(String userName) {
   
			this.userName = userName;
		}
		@Override
		public String toString() {
   
			return "User [userId=" + userId + ", userCode=" + userCode + ", userName=" + userName + "]";
		}
		  
	}

(5)、application.properties

server.port=8081
context-path:/demoWeb

spring.application.name=demoWeb
server.tomcat.uri-encoding=utf-8
 
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/mysql?setUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5
 
server.servlet.session.timeout=30m
mybatis.typeAliasesPackage=com.springboot.entity
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

spring.thymeleaf.content-type: text/html 
spring.thymeleaf.cache: false
spring.thymeleaf.mode: LEGACYHTML5

spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp

(6)、mapper

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.springboot.dao.UserDAO">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.springboot.entity.User">
        <id column="userId" property="userId" />
        <result column="userCode" property="userCode" />
        <result column="userName" property="userName" />
    </resultMap>
	<select id="selectUser"  resultType="com.springboot.entity.User">
        SELECT * FROM userstu
    </select>
    <select id="selectByUserId"  resultType="com.springboot.entity.User" parameterType="String">
        SELECT * FROM userstu where userId=#{
   userId}
    </select>
    
    <select id="selectOneById"  resultType="com.springboot.entity.User" parameterType="String">
        SELECT * FROM userstu where userId=#{
   userId}
    </select>
    
    <insert id="addUser" parameterType="com.springboot.entity.User">
    	insert into userstu(userId,userCode,userName)values(#{
   userId},#{
   userCode},#{
   userName})
    </insert>
    
    <update id="updateUser" parameterType="com.springboot.entity.User">
    	update userstu set userCode = #{
   userCode},userName = #{
   userName} where userId = #{
   userId}
    </update>
    
    <delete id="deleteByUserId" parameterType="String">
    	delete from userstu where userId = #{
   userId}
    </delete>
</mapper>

(7)、controller

@Controller
@RequestMapping("test")
public class UserController {
   

	@Autowired
	private UserService userService;

	@ApiOperation(value = "获取用户列表")
	@RequestMapping("index")
	public ModelAndView select() {
   
		ModelAndView mv = new ModelAndView();
		List<User> user = userService.getUser();
		mv.addObject("user", user);
		mv.setViewName("index");
		return mv;
	}

	// 通过id删除学生信息
	@RequestMapping("/deleteStudentById")
	public String deleteStudent(String id) {
   
		userService.deleteByUserId(id);
		return "redirect:index";
	}

	// 通过id查询学生的信息
	@RequestMappi
  • 2
    点赞
  • 19
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值