连接ssms实现MVC

最新推荐文章于 2024-07-13 13:55:40 发布

王+1

最新推荐文章于 2024-07-13 13:55:40 发布

阅读量63

点赞数

文章标签： java sql 数据库

本文链接：https://blog.csdn.net/m0_65372388/article/details/130353124

版权

完成本周任务需要弄清楚的有：

1.实现增加数据的功能需要弄清楚数据提交的顺序

在我们增加一个数据的时候我们首先提交数据发送到HeroAddServlet然后提交到HeroListServlet最后展现在listhero.jsp页面上

数据库表的 id 设置为自增长，那么，写sql语句的时候，就不能写成

String sql = "insert into hero values(null,?,?,?)";

应该写成

String sql = "insert into hero values(?,?,?)";

3.实现编辑功能

点击edit按钮实现HeroEditServlet跳转edit.jsp提交数据后交给在HeroUpdateServlet更新后在list.jsp展现

HeroListServlet

package servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.Hero;
import dao.HeroDao;
@WebServlet("/b")
public class HeroListServlet extends HttpServlet {

	 protected void doGet(HttpServletRequest request, HttpServletResponse response)
	            throws ServletException, IOException {
	    List<Hero> heros = new HeroDao().list();
	        request.setAttribute("heros", heros);
	        request.getRequestDispatcher("listHero.jsp").forward(request, response);
	 
	    }
}

HeroUpdateServlet

package servlet;

import bean.Hero;
import dao.HeroDao;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/c")


public class HeroUpdateServlet extends HttpServlet {

    protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String name = request.getParameter("name");
        int hp  = Integer.parseInt(request.getParameter("hp"));
        int id  = Integer.parseInt(request.getParameter("id"));
        int damage  = Integer.parseInt(request.getParameter("damage"));
        Hero hero = new Hero();
        hero.setName(name);
        hero.setHp(hp);
        hero.setId(id);
        hero.setDamage(damage);
        new HeroDao().update(hero);

        response.sendRedirect("b");

    }
}

HeroEditServlet

package servlet;
 
import bean.Hero;
import dao.HeroDao;
 
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
 
@WebServlet("/HeroEditServlet")
public class HeroEditServlet extends HttpServlet {
 
    protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        int id = Integer.parseInt(request.getParameter("id"));
        Hero hero =new HeroDao().get(id);
        request.setAttribute("hero", hero);
        request.getRequestDispatcher("editHero.jsp").forward(request, response);
    }
}

HeroDeleteServlet

package servlet;
 
import dao.HeroDao;
 
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
 
@WebServlet("/HeroDeleteServlet")
public class HeroDeleteServlet extends HttpServlet {
 
    protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        int id = Integer.parseInt(request.getParameter("id"));
        new HeroDao().delete(id);
 
        response.sendRedirect("b");
 
    }
}

listHero.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
 <%@ page import="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<table align='center' border='1' cellspacing='0'>
    <tr>
        <td>id</td>
        <td>name</td>
        <td>hp</td>
        <td>damage</td>
        <td>edit</td>
        <td>delete</td>
    </tr>
    <c:forEach items="${heros}" var="hero" varStatus="st">
        <tr>
            <td>${hero.id}</td>
            <td>${hero.name}</td>
            <td>${hero.hp}</td>
            <td>${hero.damage}</td>
            <td><a href="HeroEditServlet?id=${hero.id}">edit</a></td>
            <td><a href="HeroDeleteServlet?id=${hero.id}">delete</a></td>
        </tr>
    </c:forEach>
    
<div style="margin:50px auto; width:300px">
    <form action="a" method="post">
        name:&nbsp;&nbsp;<input name="name"> <br><br>
        hp:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="hp"><br><br>
        damage:&nbsp;&nbsp;<input name="damage"> <br><br>
        <br>
        <input type="submit" value="提交">
    </form>
 
</div>
</table>
</body>
</html>

editHero.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8" import="java.util.*"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>


<div style="margin:50px auto; width:300px">
    <form action="c" method=""post">
        name:&nbsp;&nbsp;<input name="name" value="${hero.name}"> <br><br>
        hp:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="hp" value="${hero.hp}"><br><br>
        damage:&nbsp;&nbsp;<input name="damage" value="${hero.damage}"> <br>
        <br>

        <input type="hidden" name = "id" value="${hero.id}">
        <input type="submit" value="提交">
    </form>

</div>

王+1

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
2
评论
连接ssms实现MVC

在我们增加一个数据的时候我们首先提交数据发送到HeroAddServlet然后提交到HeroListServlet最后展现在listhero.jsp页面上。点击edit按钮实现HeroEditServlet跳转edit.jsp提交数据后交给在HeroUpdateServlet更新后在list.jsp展现。数据库表的 id 设置为自增长，那么，写sql语句的时候，就不能写成。1.实现增加数据的功能需要弄清楚数据提交的顺序。
复制链接

扫一扫