jsp、servlet前后端交互對數(shù)據(jù)處理及展示的簡單實現(xiàn)

更新時間：2023年12月07日 10:59:46 作者：奮斗著，享受著

Servlet和JSP是Java Web開發(fā)中的兩個重要概念,在Servlet和JSP中前后端交互可以通過一些方式來實現(xiàn),這篇文章主要給大家介紹了關(guān)于jsp、servlet前后端交互對數(shù)據(jù)處理及展示的簡單實現(xiàn),需要的朋友可以參考下

代碼框架介紹：

后端部分：

beans：實體類，存放各個數(shù)據(jù)庫表單的實體類；
dao:接口部分：創(chuàng)建對實體類對象的增刪改查的方法接口。
impl部分：具體實現(xiàn)接口的方法，方便調(diào)用。
servlet: 接受處理前端頁面?zhèn)鱽淼臄?shù)據(jù)，并在處理結(jié)束后響應(yīng)前端頁面。
test:負責(zé)后端代碼測試。
utis工具模塊:由于JDBC連接及數(shù)據(jù)處理存在大量重復(fù)，故提取其中重復(fù)部分代碼封裝作為工具類被impl中的類調(diào)用以簡化代碼。

前端部分：

lib:存放前端及jsp、servlet所需jar包；
web.xml：用來指定默認首頁及建立后端servlet與前端代碼之間的映射連接；
index.jsp:默認首頁（內(nèi)含登錄（還未實現(xiàn)），注冊，數(shù)據(jù)展示功能）;
register.jsp：注冊頁面，填寫相關(guān)信息點擊注冊，跳轉(zhuǎn)到數(shù)據(jù)展示頁面，完成注冊。
StudentList.jsp：數(shù)據(jù)展示，將表中所有數(shù)據(jù)讀取并展示到頁面。（內(nèi)含數(shù)據(jù)修改和刪除功能）
updatestu.jsp:數(shù)據(jù)修改更新，在數(shù)據(jù)展示頁面點擊修改自動跳轉(zhuǎn)到此頁面，根據(jù)學(xué)號修改相關(guān)信息，修改后提交繼續(xù)跳轉(zhuǎn)到數(shù)據(jù)展示頁面展示更新后的數(shù)據(jù)并同步到數(shù)據(jù)庫。

代碼展示：（以Student為例）

后端：

實體類：

package com.openlab.beans;
//也可使用limbok插件簡化代碼，通過注解省略get set方法的書寫
public class Student {
    private  String StudentNo  ;
    private  String LoginPwd   ;
    private  String StudentName;
    private  String Sex        ;
    private  Integer GradeId    ;
    private  String Phone      ;
    private  String Address    ;
    private  String BornDate   ;
    private  String Email      ;
 
    public Student() {
    }
 
    public Student(String studentNo,  String loginPwd, String studentName, String sex, Integer gradeId, String phone, String address, String bornDate, String email) {
        StudentNo = studentNo;
        LoginPwd = loginPwd;
        StudentName = studentName;
        Sex = sex;
        GradeId = gradeId;
        Phone = phone;
        Address = address;
        BornDate = bornDate;
        Email = email;
    }
 
    public String getStudentNo() {
        return StudentNo;
    }
 
    public void setStudentNo(String studentNo) {
        StudentNo = studentNo;
    }
 
    public String getLoginPwd() {
        return LoginPwd;
    }
 
    public void setLoginPwd(String loginPwd) {
        LoginPwd = loginPwd;
    }
 
    public String getStudentName() {
        return StudentName;
    }
 
    public void setStudentName(String studentName) {
        StudentName = studentName;
    }
 
    public String getSex() {
        return Sex;
    }
 
    public void setSex(String sex) {
        Sex = sex;
    }
 
    public Integer getGradeId() {
        return GradeId;
    }
 
    public void setGradeId(Integer gradeId) {
        GradeId = gradeId;
    }
 
    public String getPhone() {
        return Phone;
    }
 
    public void setPhone(String phone) {
        Phone = phone;
    }
 
    public String getAddress() {
        return Address;
    }
 
    public void setAddress(String address) {
        Address = address;
    }
 
    public String getBornDate() {
        return BornDate;
    }
 
    public void setBornDate(String bornDate) {
        BornDate = bornDate;
    }
 
    public String getEmail() {
        return Email;
    }
 
    public void setEmail(String email) {
        Email = email;
    }
 
    @Override
    public String toString() {
        return "Student{" +
                "StudentNo='" + StudentNo + '\'' +
                ", LoginPwd='" + LoginPwd + '\'' +
                ", StudentName='" + StudentName + '\'' +
                ", Sex='" + Sex + '\'' +
                ", GradeId=" + GradeId +
                ", Phone='" + Phone + '\'' +
                ", Address='" + Address + '\'' +
                ", BornDate='" + BornDate + '\'' +
                ", Email='" + Email + '\'' +
                '}';
    }
}

接口類：

package com.openlab.dao;
 
import com.openlab.beans.Student;
 
import java.util.List;
 
public interface StudentDao {
    public  int save(Student student);//插入學(xué)生信息
    public  int update(Student student);//更新學(xué)生信息（通過學(xué)生學(xué)號）
    public int delete(String stuid);//通過學(xué)號刪除學(xué)生信息
    public List<Student> getAll();//獲取所有學(xué)生信息
    public  Student findById(String stuid);//通過id查找指定學(xué)生信息
}

工具類:

package com.openlab.utils;
 
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
 
public class JDBCUtils {
    static Properties properties = new Properties();
    static DataSource dataSource = null;
 
    static {
        InputStream inputStream = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
 
        try {
            properties.load(inputStream);
            dataSource = DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
    public Connection getConnection() throws Exception {
        try {
 
            Connection connection = dataSource.getConnection();
 
            return connection;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
 
    //新增成功后返回新增的主鍵
    public int save(String sql, Object... params) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet rs = null;
        int id = -1;
        try {
            connection = getConnection();
            preparedStatement = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            setParameter(preparedStatement, params);
            preparedStatement.executeUpdate();
            rs = preparedStatement.getGeneratedKeys();
            if (rs.next()) {
                Object obj = rs.getObject(1);
                id = Integer.parseInt(obj.toString());
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            close(connection, preparedStatement, rs);
        }
        return id;
    }
 
    public int executeUpdate(String sql, Object... params) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        try {
            connection = getConnection();
            preparedStatement = connection.prepareStatement(sql);
            setParameter(preparedStatement, params);
//            System.out.println(sql);
            int rows = preparedStatement.executeUpdate();
            return rows;
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            close(connection, preparedStatement, null);
        }
        return -1;
    }
 
    public <T> T findOneById(Class<T> tClass, String sql, Object... params) {
        List<T> list = executeQuery(tClass, sql, params);
        if (list != null && list.size() > 0) {
            return list.get(0);
        } else {
            return null;
        }
    }
 
    public <T> List<T> executeQuery(Class<T> tClass, String sql, Object... params) {
        List<T> list = new ArrayList<>();
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet rs = null;
        try {
            connection = getConnection();
            preparedStatement = connection.prepareStatement(sql);
            setParameter(preparedStatement, params);
            rs = preparedStatement.executeQuery();
            while (rs.next()) {
                T t = tClass.newInstance();
                ResultSetMetaData rsmd = rs.getMetaData();
                int count = rsmd.getColumnCount();
                for (int i = 1; i <= count; i++) {
                    String label = rsmd.getColumnLabel(i);
                    Object v = rs.getObject(label);
                    //
//                    String fieldname = change(label);
                    String fieldname = label;
                    Field field = tClass.getDeclaredField(fieldname);
                    field.setAccessible(true);
                    field.set(t, v);
                }
                list.add(t);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            close(connection, preparedStatement, rs);
        }
 
        return list;
    }
 
    /**
     * 如果表中的列是全部小寫的 empid --->empid
     * _        emp_id--->empId
     * EMPID--->empid
     *
     * @param label
     * @return
     */
    private static String change(String label) {
        int index = label.indexOf("_");
        String fieldname = "";
        if (index != -1) {
            fieldname = label.substring(0, index) + label.substring(index + 1, index + 2).toUpperCase() + label.substring(index + 2);
 
        } else {//沒找到
            fieldname = label.toLowerCase();
        }
        return fieldname;
    }
 
    private void setParameter(PreparedStatement preparedStatement, Object... params) {
        try {
            if (params != null && params.length > 0) {
                for (int i = 0; i < params.length; i++) {
//                    System.out.println(params[i]);
                    preparedStatement.setObject(i + 1, params[i]);
                }
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
 
 
    public void close(Connection connection, Statement statement, ResultSet rs) {
        try {
            if (rs != null) {
                rs.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

實現(xiàn)類：

package com.openlab.dao.impl;
 
import com.openlab.beans.Student;
import com.openlab.utils.JDBCUtils;
 
import java.util.List;
 
public class StudentDao implements com.openlab.dao.StudentDao {
    @Override
    public int save(Student student) {
        return new JDBCUtils().save("insert into student values(?,?,?,?,?,?,?,?,?)",student.getStudentNo(),student.getLoginPwd(),student.getStudentName(),student.getSex(),student.getGradeId(),student.getPhone(),student.getAddress(),student.getBornDate(),student.getEmail());
    }
 
    @Override
    public int update(Student student) {
//        System.out.println(student.getStudentName()+student.getLoginPwd()+student.getSex()+student.getGradeId()+student.getPhone()+student.getAddress()+student.getBornDate()+student.getEmail()+student.getStudentNo());
        return new JDBCUtils().executeUpdate("update student set StudentName = ?,LoginPwd = ? ,Sex = ?, GradeId = ?, Phone = ?, Address = ?, BornDate = ?, Email = ? where StudentNo = ?" ,student.getStudentName(),student.getLoginPwd(),student.getSex(),student.getGradeId(),student.getPhone(),student.getAddress(),student.getBornDate(),student.getEmail(),student.getStudentNo());
    }
 
    @Override
    public int delete(String stuid) {
        return new JDBCUtils().executeUpdate("delete from student where StudentNo = ?",stuid);
    }
 
    @Override
    public List<Student> getAll() {
        return new JDBCUtils().executeQuery(Student.class,"select * from student");
    }
 
    @Override
    public Student findById(String stuid) {
        return new JDBCUtils().findOneById(Student.class,"select * from student where StudentNo = ? ",stuid);
    }
}

servlet類：

增加：

package com.openlab.sevlet;
 
import com.openlab.beans.Student;
import com.openlab.dao.impl.StudentDao;
 
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
 
@WebServlet(name = "Servlet", value = "/Servlet")
public class addStudentServlet extends HttpServlet {
    StudentDao studentDao = new StudentDao();
 
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        //獲取參數(shù)
//        System.out.println(request.getParameter("StudentNo"));
        String studentNo = request.getParameter("StudentNo");
        String loginPwd = request.getParameter("LoginPwd");
        String studentName = request.getParameter("StudentName");
        String sex = request.getParameter("sex");
        if(sex.equals("f")){
            sex = "女";
        }else {
            sex = "男";
        }
        String gradeId = request.getParameter("GradeId");
        String phone = request.getParameter("Phone");
        String address = request.getParameter("Address");
        String bornDate = request.getParameter("BornDate");
        String email = request.getParameter("Email");
        Student student = new Student(studentNo,loginPwd,studentName,sex,Integer.valueOf(gradeId),phone,address,bornDate,email);
        //插入數(shù)據(jù)
        studentDao.save(student);
//        System.out.println(update);
        //響應(yīng)頁面
        response.sendRedirect("Studentlist.jsp");
 
    }
}

刪除：

package com.openlab.sevlet;
 
import com.openlab.dao.impl.StudentDao;
 
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
 
@WebServlet(name = "Servlet2", value = "/Servlet2")
public class deleteStudentServlet extends HttpServlet {
 
StudentDao studentDao = new StudentDao();
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        //獲取參數(shù)
        String studentNo = request.getParameter("stuid");
        //刪除數(shù)據(jù)
        studentDao.delete(studentNo);
        //響應(yīng)頁面
        response.sendRedirect("Studentlist.jsp");
 
    }
}

修改：

package com.openlab.sevlet;
 
import com.openlab.beans.Student;
import com.openlab.dao.impl.StudentDao;
 
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
 
@WebServlet(name = "updateStudentServlet", value = "/updateStudentServlet")
public class updateStudentServlet extends HttpServlet {
    StudentDao studentDao = new StudentDao();
 
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        //獲取參數(shù)
        String studentNo = request.getParameter("StudentNo");
        String selecttext = request.getParameter("selecttext");
        Student student = studentDao.findById(studentNo);
        String selectid = request.getParameter("selectid");
        switch (selectid){
            case "1": student.setLoginPwd(selecttext);break;
            case "2":student.setStudentName(selecttext);break;
            case "3":student.setSex(selecttext);break;
            case "4":student.setGradeId(Integer.parseInt(selecttext));break;
            case "5":student.setPhone(selecttext);break;
            case "6":student.setAddress(selecttext);break;
            case "7":student.setBornDate(selecttext);break;
            case "8":student.setEmail(selecttext);break;
            default:
                System.out.println("輸入id有誤?。?！");
        }
        //插入數(shù)據(jù)
        studentDao.update(student);
        //響應(yīng)頁面
        response.sendRedirect("Studentlist.jsp");
    }
}

前端：

web.xml：

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
     <!--默認首頁-->
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
<!--建立映射-->
    <servlet>
        <servlet-name>addStudentServlet</servlet-name>
        <servlet-class>com.openlab.sevlet.addStudentServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>addStudentServlet</servlet-name>
        <url-pattern>/addstu.do</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>deleteStudentServlet</servlet-name>
        <servlet-class>com.openlab.sevlet.deleteStudentServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>deleteStudentServlet</servlet-name>
        <url-pattern>/delestu.do</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>updateStudentServlet</servlet-name>
        <servlet-class>com.openlab.sevlet.updateStudentServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>updateStudentServlet</servlet-name>
        <url-pattern>/updatestu.do</url-pattern>
    </servlet-mapping>
</web-app>

首頁：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>首頁</title>
  </head>
  <body>
  <p>登錄</p>
  <p><a href="register.jsp" rel="external nofollow" >注冊</a></p>
  <p><a href="Studentlist.jsp" rel="external nofollow" >數(shù)據(jù)展示</a></p>
 
  </body>
</html>

注冊頁面：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>注冊</title>
</head>
<body>
<form action="addstu.do" method="post">
    <p>學(xué)號：<input type="text" name="StudentNo"></p>
    <p>密碼：<input type="text" name="LoginPwd"></p>
    <p>姓名：<input type="text" name="StudentName"></p>
    <p>性別：<input type="radio" name="sex" value="m">男
            <input type="radio" name="sex" value="f">女
    </p>
    <p>年級：<input type="text" name="GradeId"></p>
    <p>電話：<input type="text" name="Phone"></p>
    <p>住址：<textarea rows="5" cols="50" name="Address"></textarea></p>
    <p>生日：<input type="text" name="BornDate"></p>
    <p>郵箱：<input type="text" name="Email"></p>
    <p><input type="submit" value="注冊"/> </p>
</form>
</body>
</html>

數(shù)據(jù)展示：

<%@ page import="java.util.ArrayList" %>
<%@ page import="com.openlab.beans.Student" %>
<%@ page import="java.util.List" %>
<%@ page import="com.openlab.dao.impl.StudentDao" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>展示</title>
</head>
<body>
<%
    List<Student> list = new ArrayList<>();
    StudentDao studentDao = new StudentDao();
    List<Student> all = studentDao.getAll();
    for (Student student : all) {
        list.add(student);
    }
%>
<table border="1" width="600" cellspacing="0" style="color: red">
    <tr align="center">
        <td>學(xué)號</td>
        <td>密碼</td>
        <td>姓名</td>
        <td>性別</td>
        <td>年級</td>
        <td>電話</td>
        <td>住址</td>
        <td>生日</td>
        <td>郵件</td>
        <td colspan="2">操作</td>
    </tr>
    <%
        for (Student student : list){
    %>
    <tr align="center">
        <td><%= student.getStudentNo()%></td>
        <td><%= student.getLoginPwd()%></td>
        <td><%= student.getStudentName()%></td>
        <td><%= student.getSex()%></td>
        <td><%= student.getGradeId()%></td>
        <td><%= student.getPhone()%></td>
        <td><%= student.getAddress()%></td>
        <td><%= student.getBornDate()%></td>
        <td><%= student.getEmail()%></td>
        <td>
            <a href="updatestu.jsp?stuid=<%=student.getStudentNo()%>" rel="external nofollow" >修改</a>
        </td>
        <td>
            <a href="delestu.do?stuid=<%=student.getStudentNo()%>" rel="external nofollow" >刪除</a>
        </td>
 
    </tr>
    <%
        }
    %>
</table>
</body>
</html>

數(shù)據(jù)修改：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>更新</title>
</head>
<body>
<form action="updatestu.do?StudentNo=<%=request.getParameter("stuid")%>" method="post">
  <p>修改的學(xué)生學(xué)號：<%=request.getParameter("stuid")%></p>
  <p>請輸入你要修改的字段<input type="text" name="selectid"></p>
  <p>請輸入修改后的字段內(nèi)容<input type="text" name="selecttext"></p>
  <p>密碼：1</p>
  <p>姓名：2</p>
  <p>性別：3</p>
  <p>年級：4</p>
  <p>電話：5</p>
  <p>住址：6</p>
  <p>生日：7</p>
  <p>郵箱：8</p>
  <p><input type="submit" value="確認修改"/> </p>
</form>
</body>
</html>

效果展示：

首頁（稍顯簡陋，可后期修飾）：

（登錄還未實現(xiàn)）

注冊：

填寫信息點擊注冊跳轉(zhuǎn)到數(shù)據(jù)展示頁面（孫悟空已添加）：

點擊修改：（修改zhaosi名字為趙四）

可以看到趙四修改成功；

點擊刪除：（點擊刪除”九點“，刪除成功）

總結(jié)

到此這篇關(guān)于jsp、servlet前后端交互對數(shù)據(jù)處理及展示的簡單實現(xiàn)的文章就介紹到這了,更多相關(guān)jsp、servlet前后端交互數(shù)據(jù)處理內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: