增删改查ssm

最新推荐文章于 2024-06-16 09:46:44 发布

ご　せい　こう　き

最新推荐文章于 2024-06-16 09:46:44 发布

阅读量50

点赞数

文章标签： java mybatis sql

本文链接：https://blog.csdn.net/m0_74772114/article/details/129303861

版权

dao

public int  del(int id)throws SQLException;

public int  up (Student student)throws SQLException;

public int add(Student student) throws SQLException;

public int  sel(int id)throws SQLException;

UserService

public class UserServiceImpl implements UserService {

    @RequestMapping("/del")
    @Override
    public int  del(int id) throws SQLException {
        int del = userMapper.del(id);
        return del;
    }


    @Override
    public int up(Student student) throws SQLException {
        int up =userMapper.up(student);
        return  up;
    }

    @RequestMapping("/del")
    @Override
    public int add(Student student) throws SQLException {
        int add = userMapper.add(student);
        return add;
    }


    @RequestMapping("/sel")
    @Override
    public int sel(int id) throws SQLException {
        int sel = userMapper.sel(id);
        return sel;
    }

mapper

<delete id="del">
    delete from lzj_tb_Student where id=#{id}
</delete>


<update id="up">
    update lzj_tb_Student set name=#{name},age=#{age} where id=#{id}
</update>


<insert id="add">
    insert into lzj_tb_Student (name,age)values(#{name},#{age})
</insert>

<select id="sel" resultType="java.lang.Integer">
    select * from lzj_tb_Student where id =#{id}
</select>

前台

--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%--删除--%>
<form action="${pageContext.request.contextPath}/user/del" method="get">
    删除那一条：<input type="text" name="id"/><br>
    <input type="submit" value="提交" />
    ${msg}
</form>

<%--修改--%>
<form action="${pageContext.request.contextPath}/user/up" method="get">

    修改姓名：<input type="text" name="name"/><br>
    修改年龄：<input type="text" name="age"/><br>
    修改哪一条：<input type="text" name="id"/><br>
    <input type="submit" value="提交" />
    ${msg}
</form>

<%--添加--%>
<form action="${pageContext.request.contextPath}/user/add" method="get">
    添加姓名：<input type="text" name="name" /><br>
    添加年龄：<input type="text" name="age" /><br>
    <input type="submit" value="提交" />
    ${msg}
</form>

<%--查--%>
<form action="${pageContext.request.contextPath}/user/sel" method="get">
    查询：<input type="text" name="id"/><br>
    <input type="submit" value="提交" />
    ${msg}
</form>




</body>
</html>