最簡單的jsp+servlet的增刪改查代碼，jspservlet

最簡單的jsp+servlet的增刪改查代碼，jspservlet

package ceet.ac.cn.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import ceet.ac.cn.model.Admin;

public class AdminDao {
    public List<Admin> getAllAdmin(){  //查詢所有信息
        List<Admin> list = new ArrayList<Admin>();  //創建集合
        Connection conn = DbHelper.getConnection();
        String sql  = "select * from admin";  //SQL查詢語句
        try {
            PreparedStatement pst = conn.prepareStatement(sql);
            ResultSet rst = pst.executeQuery();
            while (rst.next()) {
                Admin admin = new Admin();
                admin.setId(rst.getInt("id"));  //得到ID
                admin.setUsername(rst.getString("username"));
                admin.setUserpwd(rst.getString("userpwd"));
                list.add(admin);
            }
            rst.close();  //關閉
            pst.close();  //關閉
        } catch (SQLException e) {
            e.printStackTrace();  //拋出異常
        }
        return list;  //返回一個集合
    }
    
    public boolean addAdmin(Admin admin){  //添加信息
        String sql = "INSERT INTO `admin`(`id`,`username`,`userpwd`) VALUES (?,?,?)";  //添加的SQL語句
        Connection conn = DbHelper.getConnection();
        try {
            PreparedStatement pst = conn.prepareStatement(sql);
            pst.setInt(1, admin.getId());
            pst.setString(2, admin.getUsername());
            pst.setString(3, admin.getUserpwd());
            int count = pst.executeUpdate();
            pst.close();
            return count>0?true:false;  //是否添加的判斷
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }
    
    public boolean updateAdmin(Admin admin){  //修改
        String sql = "UPDATE `admin` SET `username`=?,`userpwd`=? WHERE `id` = ?";  //修改的SQL語句，根據ID修改
        Connection conn = DbHelper.getConnection();
        try {
            PreparedStatement pst = conn.prepareStatement(sql);
            pst.setString(1, admin.getUsername());
            pst.setString(2, admin.getUserpwd());
            pst.setInt(3, admin.getId());  //根據的ID
            int count = pst.executeUpdate();
            pst.close();  //關閉
            return count>0?true:false;  //是否修改的判斷
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }
    
    public boolean deleteAdmin(int id){  //刪除
        String sql = "delete from admin where id = ?";  //刪除的SQL語句，根據ID刪除
        Connection conn = DbHelper.getConnection();
        try {
            PreparedStatement pst = conn.prepareStatement(sql);
            pst.setInt(1, id);
            int count = pst.executeUpdate();
            pst.close();
            return count>0?true:false;  //是否刪除的判斷
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }
    
    public Admin selectAdminById(int id){  //根據ID進行查詢
        Connection conn = DbHelper.getConnection();
        String sql  = "select * from admin where id = "+id;
        Admin admin = null;
        try {
            PreparedStatement pst = conn.prepareStatement(sql);
            ResultSet rst = pst.executeQuery();
            while (rst.next()) {
                admin = new Admin();
                admin.setId(rst.getInt("id"));
                admin.setUsername(rst.getString("username"));
                admin.setUserpwd(rst.getString("userpwd"));
            }
            rst.close();
            pst.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return admin;  //返回
    }
}

package ceet.ac.cn.dao;

import java.sql.Connection;
import java.sql.DriverManager;
/**
 * 連接數據庫
 * @author 畫船聽雨眠
 *
 */
public class DbHelper {
    private static String url = "jdbc:mysql://localhost:3306/admin";  //數據庫地址
    private static String userName = "root";  //數據庫用戶名
    private static String passWord = "359129127";  //數據庫密碼
    private static Connection conn = null;
    
    private DbHelper(){
        
    }
    
    public static Connection getConnection(){
        if(null == conn){
            try {
                Class.forName("com.mysql.jdbc.Driver");
                conn = DriverManager.getConnection(url, userName, passWord);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        return conn;
    }
    
    public static void main(String[] args) {  //測試數據庫是否連通
        System.err.println(getConnection());
    }
}

package ceet.ac.cn.model;

import java.io.Serializable;

public class Admin implements Serializable{  //數據封裝類
    
    private static final long serialVersionUID = 1L;
    
    private int id;
    private String username;
    private String userpwd;
    
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getUserpwd() {
        return userpwd;
    }
    public void setUserpwd(String userpwd) {
        this.userpwd = userpwd;
    }
    

}

package ceet.ac.cn.servlet;

import java.io.IOException;

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

import ceet.ac.cn.dao.AdminDao;
import ceet.ac.cn.model.Admin;

public class AddServlet extends HttpServlet{  //添加數據
    private static final long serialVersionUID = 1L;

    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        this.doPost(req, resp);
    }

    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        String username = req.getParameter("username");
        String userpwd = req.getParameter("userpwd");
        Admin admin = new Admin();
        admin.setUsername(new String(username.getBytes("ISO-8859-1"),"UTF-8"));  //轉值，中文需要轉換為utf-8
        admin.setUserpwd(new String(userpwd.getBytes("ISO-8859-1"),"UTF-8"));
        AdminDao dao = new AdminDao();
        dao.addAdmin(admin);
        req.getRequestDispatcher("ShowServlet").forward(req, resp);
    }    
}

package ceet.ac.cn.servlet;

import java.io.IOException;

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

import ceet.ac.cn.dao.AdminDao;

public class DeleteServlet extends HttpServlet{  //刪除數據

    private static final long serialVersionUID = 1L;

    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        this.doPost(req, resp);
    }

    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        String idStr = req.getParameter("id");  //刪除數據的ID，根據ID刪除
        if(idStr != null && !idStr.equals("")){
            int id = Integer.valueOf(idStr);
            AdminDao dao = new AdminDao();
            dao.deleteAdmin(id);
        }
        req.getRequestDispatcher("ShowServlet").forward(req, resp);
    }
    
    

}

package ceet.ac.cn.servlet;

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

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

import ceet.ac.cn.dao.AdminDao;
import ceet.ac.cn.model.Admin;

public class ShowServlet  extends HttpServlet{  //顯示全部數據

    private static final long serialVersionUID = 1L;

    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        this.doPost(req, resp);
    }

    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        AdminDao dao = new AdminDao();
        List<Admin> list = dao.getAllAdmin();
        req.setAttribute("list", list);
        req.getRequestDispatcher("index.jsp").forward(req, resp);
    }    
}

package ceet.ac.cn.servlet;

import java.io.IOException;

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

import ceet.ac.cn.dao.AdminDao;
import ceet.ac.cn.model.Admin;

public class UpdateServlet extends HttpServlet{  //修改

    private static final long serialVersionUID = 1L;

    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {  //查詢到選中ID的值所對應的數據
        String idStr = req.getParameter("id");
        if(idStr != null && !idStr.equals("")){
            int id = Integer.valueOf(idStr);
            AdminDao dao = new AdminDao();
            Admin admin = dao.selectAdminById(id);
            req.setAttribute("admin", admin);
        }
        req.getRequestDispatcher("update.jsp").forward(req, resp);
        
    }

    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {  //根據此ID對數據的值進行修改
        String username = req.getParameter("username");
        String userpwd = req.getParameter("userpwd");
        String idStr = req.getParameter("id");
        Admin admin = new Admin();
        admin.setId(Integer.valueOf(idStr));
        admin.setUsername(new String(username.getBytes("ISO-8859-1"),"UTF-8"));
        admin.setUserpwd(new String(userpwd.getBytes("ISO-8859-1"),"UTF-8"));
        AdminDao dao = new AdminDao();
        dao.updateAdmin(admin);
        req.getRequestDispatcher("ShowServlet").forward(req, resp);
    }
    
    

}

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>    
    <title>添加</title>
    <link rel="stylesheet" href="css/index.css" type="text/css" />
  </head>

  <body>
  <form action="AddServlet" method="post">
    <table border="1" class="t1">
        <tr>
            <td colspan="2"><h1>添加管理員</h1></td>
        </tr>
        <tr>
            <td>管理員帳號:</td>
            <td><input  type="text" name="username"/></td>
        </tr>
        <tr>
            <td>管理員密碼:</td>
            <td><input  type="password" name="userpwd"/></td>
        </tr>
        <tr>
            <td colspan="2">
                <input  type="submit" value="提交"/>
                <input  type="reset" value="清空"/>
            </td>
        </tr>
    </table>
   </form>
  </body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>顯示</title>
    <style type="text/css">
            table {
                border: 1px solid pink;
                margin: 0 auto;
            }
            
            td{
                width: 150px;
                border: 1px solid pink;
                text-align: center;
            }
    </style>
</head>
<body>
    <table>
        <tr>
            <td>編號</td>
            <td>帳號</td>
            <td>密碼</td>
            <td>操作</td>
        </tr>
        <c:forEach items="${list}" var="item">
            <tr>
                <td>${item.id }</td>
                <td>${item.username }</td>
                <td>${item.userpwd }</td>
                <td><a href="DeleteServlet?id=${item.id }">刪除</a>|<a href="UpdateServlet?id=${item.id }">修改</a></td>
            </tr>
        </c:forEach>
        <tr>
            <td colspan="6"><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>    
    <title>修改</title>
    <link rel="stylesheet" href="css/index.css" type="text/css" />
  </head>
  
  <body>
    <form action="UpdateServlet" method="post">
    <table border="1" class="t1">
        <tr>
            <td colspan="2"><h1>修改管理員信息</h1></td>
        </tr>
        <tr>
            <td>編號:</td>
            <td><input  type="text" name="id" value="${admin.id}" readonly="readonly"/></td>
        </tr>
        
        <tr>
            <td>管理員帳號:</td>
            <td><input  type="text" name="username" value="${admin.username}"/></td>
        </tr>
        <tr>
            <td>管理員密碼:</td>
            <td><input  type="text" name="userpwd" value="${admin.userpwd}"/></td>
        </tr>
        <tr>
            <td colspan="2">
                <input  type="submit" value="提交"/>
                <input  type="button" value="返回" onclick="history.go(-1)"/>
            </td>
        </tr>
    </table>
   </form>
  </body>
</html>

@CHARSET "UTF-8";
        table.t1 {
            margin-top:10px;
            margin-left:20px;
            margin-right:20px;
            margin-bottom:5px;
            #background-color: #FFF;
            #background:#EEF4F9;
            #border: none;
            border: 1;
            #color:#003755;
            border-collapse:collapse;
            font: 14px  "宋體";
            text-align: center;
        }

        table.t1 th{
                background:#7CB8E2;
                color:#fff;
                padding:6px 4px;
                text-align:center;
        }

        table.t1 td{
                background:#C7DDEE none repeat-x scroll center left;
                color:#000;
                padding:4px 2px;
        }

        table.t1 a{
                text-decoration:none;
                height:1em;
        }

        table.t1 a:link, table.t1  a:visited{
                color:#3366CC;
        }

        table.t1  a:hover{
                color:#B50000;
                text-decoration:underline;
        }
        

        

最簡單的jsp+servlet的增刪改查代碼。寫的很清楚，就這樣了。

實現原理： 
每行數據後面加一個編輯和刪除按鈕，按鈕提交到後台並且帶有此行數據的主要參數。 
點擊編輯按鈕，通過servlet操作jsp將此行的每一列替換為一個文本框並把已有的值帶進去，後面一個提交按鈕通過submit提交數據並將文本框重新變為表格的單元格。 
新增，就像編輯一樣，添加一行，全部是文本框。。。 

版權聲明：本文為博主原創文章，未經博主允許不得轉載。