4月2日 JavaWeb 周一

百科知识2025-04-261

网页列表增删改代码

展示的JSP页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<span><<span>title</span>></span>My JSP 'show.jsp' starting page<span></<span>title</span>></span>

<span><<span>meta</span> <span>http-equiv</span>=<span>"pragma"</span> <span>content</span>=<span>"no-cache"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"cache-control"</span> <span>content</span>=<span>"no-cache"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"expires"</span> <span>content</span>=<span>"0"</span>></span>    
<span><<span>meta</span> <span>http-equiv</span>=<span>"keywords"</span> <span>content</span>=<span>"keyword1,keyword2,keyword3"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"description"</span> <span>content</span>=<span>"This is my page"</span>></span>
<span><!-- <link rel="stylesheet" type="text/css" href="https://www.miaokee.com/styles.css"> --></span>

</head>

<body>
<center>
<h2>这是一个展示列表的页面</h2>
<table bordercolor="red" border="2px">
<tr>
<th>编号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>院系</th>
<th>住址</th>
<th><a href="/demo09_exam/add.jsp">增加</a>(<a href="/demo09_exam/upd.jsp">修改</a>)</th>
</tr>
<c:forEach var="li" items="${list00}">
<tr>
<td>
${li.id}
</td>
<td>
${li.name}
</td>
<td>
${li.sex}
</td>
<td>
${li.birth}
</td>
<td>
${li.department}
</td>
<td>
${li.address}
</td>
<td>
<a href="/demo09_exam/del?w=${li.id}" >删除</a>
</td>
</tr>
</c:forEach>
</table>
</center>
</body>
</html>

展示的Servlet代码

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

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

import com.mysql.jdbc.Driver;

public class ShowServlet extends HttpServlet {

<span>public</span> <span>void</span> <span>doGet</span>(HttpServletRequest request, HttpServletResponse response)
        <span>throws</span> ServletException, IOException {

    List list = <span>new</span> ArrayList();
    <span>try</span> {
        <span>//驱动</span>
        Class.forName(<span>"com.mysql.jdbc.Driver"</span>);
        <span>//连接</span>
        Connection con = DriverManager.getConnection(<span>"jdbc:mysql://localhost:3306/login"</span>,<span>"root"</span>,<span>"root"</span>);
        <span>//sql语句</span>
        String sql = <span>"select * from t_user ;"</span>;
        <span>//执行sql语句</span>
        PreparedStatement pst = con.prepareStatement(sql);
        <span>//结果集取值</span>
        ResultSet rs = pst.executeQuery();

        <span>while</span>(rs.next()){
            String ids = rs.getString(<span>1</span>);
            String names = rs.getString(<span>2</span>);
            String sexs = rs.getString(<span>3</span>);
            String bis = rs.getString(<span>4</span>);
            String des = rs.getString(<span>5</span>);
            String ads = rs.getString(<span>6</span>);

            Elep el = <span>new</span> Elep(ids,names,sexs,bis,des,ads);
            list.add(el);
        }

        request.setAttribute(<span>"list00"</span>, list);
        request.getRequestDispatcher(<span>"show.jsp"</span>).forward(request, response);

    } <span>catch</span> (Exception e) {
        <span>// TODO Auto-generated catch block</span>
        e.printStackTrace();
    }
    <span>//</span>
}

<span>public</span> <span>void</span> <span>doPost</span>(HttpServletRequest request, HttpServletResponse response)
        <span>throws</span> ServletException, IOException {

    doGet(request, response);
}

}

增加的JSP页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<span><<span>title</span>></span>My JSP 'add.jsp' starting page<span></<span>title</span>></span>

<span><<span>meta</span> <span>http-equiv</span>=<span>"pragma"</span> <span>content</span>=<span>"no-cache"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"cache-control"</span> <span>content</span>=<span>"no-cache"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"expires"</span> <span>content</span>=<span>"0"</span>></span>    
<span><<span>meta</span> <span>http-equiv</span>=<span>"keywords"</span> <span>content</span>=<span>"keyword1,keyword2,keyword3"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"description"</span> <span>content</span>=<span>"This is my page"</span>></span>
<span><!-- <link rel="stylesheet" type="text/css" href="https://www.miaokee.com/styles.css"> --></span>

</head>

<body>
<center>
<form action="/demo09_exam/add" method="post">
编号:<input type="text" name="bian"><br>
姓名:<input type="text" name="xing"><br>
性别:<input type="text" name="bie"><br>
年龄:<input type="text" name="nian"><br>
院系:<input type="text" name="yuan"><br>
住址:<input type="text" name="zhu"><br>
<input type="submit" value="提交">
</form>
</center>
</body>
</html>

增加的Servlet代码

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

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

import com.mysql.jdbc.Driver;

public class AddServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    //处理乱码
    request<span>.setCharacterEncoding</span>(<span>"utf-8"</span>)<span>;</span>
    response<span>.setCharacterEncoding</span>(<span>"utf-8"</span>)<span>;</span>
    response<span>.setContentType</span>(<span>"text/html;"</span>)<span>;</span>

    String bians = request<span>.getParameter</span>(<span>"bian"</span>)<span>;</span>
    String xings = request<span>.getParameter</span>(<span>"xing"</span>)<span>;</span>
    String bies = request<span>.getParameter</span>(<span>"bie"</span>)<span>;</span>
    String nians = request<span>.getParameter</span>(<span>"nian"</span>)<span>;</span>
    String yuans = request<span>.getParameter</span>(<span>"yuan"</span>)<span>;</span>
    String zhus = request<span>.getParameter</span>(<span>"zhu"</span>)<span>;</span>

    //JDBC
    try {
        Class<span>.forName</span>(<span>"com.mysql.jdbc.Driver"</span>)<span>;</span>
        Connection con = DriverManager<span>.getConnection</span>(<span>"jdbc:mysql://localhost:3306/login"</span>,<span>"root"</span>,<span>"root"</span>)<span>;</span>
        String sql = <span>"insert into t_user values(?,?,?,?,?,?);"</span><span>;</span>
        PreparedStatement pst = con<span>.prepareStatement</span>(sql)<span>;</span>

        pst<span>.setString</span>(<span>1</span>, bians)<span>;</span>
        pst<span>.setString</span>(<span>2</span>, xings)<span>;</span>
        pst<span>.setString</span>(<span>3</span>, bies)<span>;</span>
        pst<span>.setString</span>(<span>4</span>, nians)<span>;</span>
        pst<span>.setString</span>(<span>5</span>, yuans)<span>;</span>
        pst<span>.setString</span>(<span>6</span>, zhus)<span>;</span>

        int <span>x</span> = pst<span>.executeUpdate</span>()<span>;</span>

        if(<span>x</span>><span>0</span>){
            response<span>.sendRedirect</span>(<span>"/demo09_exam/show"</span>)<span>;</span>
        }
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e<span>.printStackTrace</span>()<span>;</span>
    }

}

public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    doGet(request, response)<span>;</span>
}

}

删除的Servlet代码

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

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

public class DelServlet extends HttpServlet {

<span>public</span> <span>void</span> <span>doGet</span>(HttpServletRequest request, HttpServletResponse response)
        <span>throws</span> ServletException, IOException {

    String w = request.getParameter(<span>"w"</span>);

    <span>try</span> {
        Class.forName(<span>"com.mysql.jdbc.Driver"</span>);
        Connection con = DriverManager.getConnection(<span>"jdbc:mysql://localhost:3306/login"</span>,<span>"root"</span>,<span>"root"</span>);
        String sql = <span>"delete from t_user where id=?;"</span>;
        PreparedStatement pst = con.prepareStatement(sql);
        pst.setString(<span>1</span>, w);
        <span>int</span> x = pst.executeUpdate();

        <span>if</span>(x><span>0</span>){
            response.sendRedirect(<span>"/demo09_exam/show"</span>);
        }
    } <span>catch</span> (Exception e) {
        <span>// TODO Auto-generated catch block</span>
        e.printStackTrace();
    }
}

<span>public</span> <span>void</span> <span>doPost</span>(HttpServletRequest request, HttpServletResponse response)
        <span>throws</span> ServletException, IOException {

    doGet(request, response);
}

}

修改的JSP页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<span><<span>title</span>></span>My JSP 'upd.jsp' starting page<span></<span>title</span>></span>

<span><<span>meta</span> <span>http-equiv</span>=<span>"pragma"</span> <span>content</span>=<span>"no-cache"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"cache-control"</span> <span>content</span>=<span>"no-cache"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"expires"</span> <span>content</span>=<span>"0"</span>></span>    
<span><<span>meta</span> <span>http-equiv</span>=<span>"keywords"</span> <span>content</span>=<span>"keyword1,keyword2,keyword3"</span>></span>
<span><<span>meta</span> <span>http-equiv</span>=<span>"description"</span> <span>content</span>=<span>"This is my page"</span>></span>
<span><!-- <link rel="stylesheet" type="text/css" href="https://www.miaokee.com/styles.css"> --></span>

</head>

<body>
<center>
<form action="/demo09_exam/update" method="post">
编号:<input type="text" name="bian"><br>
姓名:<input type="text" name="xing"><br>
性别:<input type="text" name="bie"><br>
年龄:<input type="text" name="nian"><br>
院系:<input type="text" name="yuan"><br>
住址:<input type="text" name="zhu"><br>
<input type="submit" value="提交">
</form>
</center>
</body>
</html>

修改的Servlet代码

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

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

public class UpdateServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    //处理乱码
    request<span>.setCharacterEncoding</span>(<span>"utf-8"</span>)<span>;</span>
    response<span>.setCharacterEncoding</span>(<span>"utf-8"</span>)<span>;</span>
    response<span>.setContentType</span>(<span>"text/html;charset=utf-8"</span>)<span>;</span>

    String bians = request<span>.getParameter</span>(<span>"bian"</span>)<span>;</span>
    String xings = request<span>.getParameter</span>(<span>"xing"</span>)<span>;</span>
    String bies = request<span>.getParameter</span>(<span>"bie"</span>)<span>;</span>
    String nians = request<span>.getParameter</span>(<span>"nian"</span>)<span>;</span>
    String yuans = request<span>.getParameter</span>(<span>"yuan"</span>)<span>;</span>
    String zhus = request<span>.getParameter</span>(<span>"zhu"</span>)<span>;</span>

    //JDBC
    try {
        Class<span>.forName</span>(<span>"com.mysql.jdbc.Driver"</span>)<span>;</span>
        Connection con = DriverManager<span>.getConnection</span>(<span>"jdbc:mysql://localhost:3306/login"</span>,<span>"root"</span>,<span>"root"</span>)<span>;</span>
        String sql = <span>"update t_user set name=? , sex=? , birth=? , department= ? , address=? where id = ?;"</span><span>;</span>
        PreparedStatement pst = con<span>.prepareStatement</span>(sql)<span>;</span>

        pst<span>.setString</span>(<span>1</span>, xings)<span>;</span>
        pst<span>.setString</span>(<span>2</span>, bies)<span>;</span>
        pst<span>.setString</span>(<span>3</span>, nians)<span>;</span>
        pst<span>.setString</span>(<span>4</span>, yuans)<span>;</span>
        pst<span>.setString</span>(<span>5</span>, zhus)<span>;</span>
        pst<span>.setString</span>(<span>6</span>, bians)<span>;</span>

        int <span>x</span> = pst<span>.executeUpdate</span>()<span>;</span>

        if(<span>x</span>><span>0</span>){
            response<span>.sendRedirect</span>(<span>"/demo09_exam/show"</span>)<span>;</span>
        }
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e<span>.printStackTrace</span>()<span>;</span>
    }

}

public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    doGet(request, response)<span>;</span>

}

}

为集合创建的对象

public class Elep {
String id;
String name;
String sex;
String birth;
String department;
String address;

<span>public</span> <span>Elep</span>(String id, String name, String sex, String birth, String department,
        String address) {
    super();
    <span>this</span>.id = id;
    <span>this</span>.name = name;
    <span>this</span>.sex = sex;
    <span>this</span>.birth = birth;
    <span>this</span>.department = department;
    <span>this</span>.address = address;
}

<span>public</span> String <span>getId</span>() {
    <span>return</span> id;
}

<span>public</span> <span>void</span> <span>setId</span>(String id) {
    <span>this</span>.id = id;
}

<span>public</span> String <span>getName</span>() {
    <span>return</span> name;
}

<span>public</span> <span>void</span> <span>setName</span>(String name) {
    <span>this</span>.name = name;
}

<span>public</span> String <span>getSex</span>() {
    <span>return</span> sex;
}

<span>public</span> <span>void</span> <span>setSex</span>(String sex) {
    <span>this</span>.sex = sex;
}

<span>public</span> String <span>getBirth</span>() {
    <span>return</span> birth;
}

<span>public</span> <span>void</span> <span>setBirth</span>(String birth) {
    <span>this</span>.birth = birth;
}

<span>public</span> String <span>getDepartment</span>() {
    <span>return</span> department;
}

<span>public</span> <span>void</span> <span>setDepartment</span>(String department) {
    <span>this</span>.department = department;
}

<span>public</span> String <span>getAddress</span>() {
    <span>return</span> address;
}

<span>public</span> <span>void</span> <span>setAddress</span>(String address) {
    <span>this</span>.address = address;
}

}

运行项目需要配置好数据库，还需要导入三个jar包。

痛苦来自于对当下的批判：不能心平气和的接受当下，便是制造痛苦的根源。 ——埃克哈特·托利 《当下的力量》

网站标题：源之站
文章标题：4月2日 JavaWeb 周一
文章链接：https://yuanzz.com/post-506.html
© 版权声明
文章内容部分引用互联网信息，如有不实或者带来不适，请联系我们进行下架。
THE END