jsp简单增删改查

最新推荐文章于 2024-05-27 12:05:55 发布

落晚_

最新推荐文章于 2024-05-27 12:05:55 发布

阅读量1k

点赞数 2

文章标签： servlet html 前端 java 开发语言

本文链接：https://blog.csdn.net/m0_46536704/article/details/129131383

版权

insert

   <form action="insert1.jsp">
       <table>
           <tr>
               <td>请输入要增加的学号:</td>
               <td><input type="text" name="id"></td></br>
           </tr>
           <tr>
               <td>请输入要增加的姓名: </td>
               <td><input type="text" name="name"></td>
           </tr>
           <tr>
              <input type="submit" value="提交">
           </tr>
       </table>
   </form>
   <td><a href="index.jsp">返回主页</a></td></br>

insert1

<%
    Class.forName("com.mysql.jdbc.Driver");
    Connection root = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "123456");
    Statement statement = root.createStatement();
    Scanner sc = new Scanner(System.in);
    String id1 = request.getParameter("id");
    String name1 = request.getParameter("name");
    String in = "insert into student (id,name) values (" + id1 + ",'" + name1 + "')";
    statement.executeUpdate(in);
%>

delete

<form action="delete1.jsp">
    <table>
        <tr>
            <td>请输入要删除的学号:</td>
            <td><input type="text" name="id"></td></br>
        </tr>
        <tr>
            <td>请输入要删除的姓名: </td>
            <td><input type="text" name="name"></td>
        </tr>
        <tr>
            <input type="submit" value="提交">
        </tr>
    </table>
</form>

delete1

<%
    Class.forName("com.mysql.jdbc.Driver");
    Connection root = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "123456");
    Statement statement = root.createStatement();
    Scanner sc = new Scanner(System.in);
    String id1 = request.getParameter("id");
    String name1 = request.getParameter("name");
    String de = "delete  from student where id = "+id1;
    statement.executeUpdate(de);
%>
<body>
<p>您已经删除成功</p>
<td><a href="delete.jsp">返回上一页</a></td></br>
</body>

updata

<form action="updata1.jsp">
    <table>
        <tr>
            <td>请输入要修改的学号:</td>
            <td><input type="text" name="uid"></td></br>
        </tr>
        <tr>
            <td>请输入修改的学号:</td>
            <td><input type="text" name="nid"></td></br>
        </tr>
        <tr>
            <td>请输入修改的姓名: </td>
            <td><input type="text" name="name"></td>
        </tr>
        <tr>
            <input type="submit" value="提交">
        </tr>
    </table>
</form>
<td><a href="index.jsp">返回主页</a></td></br>

updata1

<%
    Class.forName("com.mysql.jdbc.Driver");
    Connection root = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "123456");
    Statement statement = root.createStatement();
    Scanner sc = new Scanner(System.in);
    String uid = request.getParameter("uid");
    String nid = request.getParameter("nid");
    String name = request.getParameter("name");
    // updata student set name='name',id=nid where id=uid;
    String up = "update student set name='"+name+"',id="+nid+" where id="+uid;
    statement.executeUpdate(up);
%>
<body>
<p>您已经修改成功</p>

selete

  <%
    Class.forName("com.mysql.jdbc.Driver");
    Connection root = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "123456");
    Statement statement = root.createStatement();
    String select = "select * from student";
    ResultSet resultSet = statement.executeQuery(select);
  %>
<body>
  <table border="2px">
    <%for (; resultSet.next(); ) {%>
    <tr>
      <td><%=resultSet.getString("id")%></td>
      <td><%=resultSet.getString("name")%></td>
    </tr>
    <%}%>
  </table>
  <td><a href="index.jsp">返回主页</a></td></br>
</body>