2.26

我终于完成了增删改查这个东西，周六日两天我都没怎么玩，我速度太慢了，但我这是自己写的，从空白到成功，以前都是改别人的，自己不写自己的东西，以前的小孩都会，现在我进步了，我决定多写，因为报错太多了，我只能求助别人。

下面我把这个增删改查代码整理下

 

package Dao;
import util.dbutil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;



public class dao {

    
    
     public void tianjia(String name,String id,String age,String banji,String xuehao ) throws Exception
     {
         Connection connection = dbutil.getConnection();
         PreparedStatement preparedStatement=null;       
         try {
             //hubie,housetype,houseS,home,name,id,sex,minzu,edu;
             String sql = "insert into xuesheng () values (?,?,?,?,?)";
             preparedStatement=connection.prepareStatement(sql);
             preparedStatement.setString(1,name);
             preparedStatement.setString(2,id);
             preparedStatement.setString(3,age);
             preparedStatement.setString(4,banji);
             preparedStatement.setString(5,xuehao);
            
         
             preparedStatement.executeUpdate();
             //System.out.println("添加成功");
             
         } catch (SQLException  e) {
             e.printStackTrace();
         }finally{
            
         }
         
     }
    
     public void delete(String xuehao) throws Exception
          {
               Connection connection = dbutil.getConnection();
               PreparedStatement preparedStatement=null;       
              try {
                   String sql = "delete from xuesheng where xuehao = ?";
                   preparedStatement=connection.prepareStatement(sql);
                   preparedStatement.setString(1,xuehao);
                   preparedStatement.executeUpdate();
                   //System.out.println("删除成功");
                  
               } catch (SQLException  e) {
                   e.printStackTrace();
               }finally{
                  
               }
           }
     public boolean isSame(String s) throws Exception
     {
         Connection connection = dbutil.getConnection();
         PreparedStatement preparedStatement=null; 
         ResultSet rs=null;
         try {
             String sql = "select * from xuesheng";
             preparedStatement=connection.prepareStatement(sql);
             rs=preparedStatement.executeQuery();
             while(rs.next()){
                 if(s.equals(rs.getObject(5)))
                         return true;
             }
             //preparedStatement.executeUpdate();
             
         } catch (SQLException  e) {
             e.printStackTrace();
         }finally{
           /*  close(rs);
             close(preparedStatement);
             close(connection);*/
         }
         return false;
     }
   //修改
       public void revisedata(String xuehao,String name, String id, String age, String banji ) throws Exception
       {
           Connection connection =dbutil. getConnection();
           PreparedStatement preparedStatement=null;       
           try {
               //身份证号码、性别、民族、受教育程度
               String sql = "update xuesheng set name=?,id=?, age=?, banji=? where xuehao=?";
               preparedStatement=connection.prepareStatement(sql);
               preparedStatement.setString(1,name);
               preparedStatement.setString(2,id);
               preparedStatement.setString(3,age);
               preparedStatement.setString(4,banji);
               preparedStatement.setString(5,xuehao);
             
               preparedStatement.executeUpdate();
              
           } catch (SQLException  e) {
               e.printStackTrace();
           }finally{
              /* close(preparedStatement);
               close(connection);*/
           }
       }
    
    
    
    
    
    
}

package util;

import java.sql.Connection;
import java.sql.DriverManager;

public class dbutil {

    public static Connection getConnection() throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/j?useSSL=false", "root", "1234");
        return con;
    
    }    
    
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="add1.jsp" method="get">
<p style="text-align:center;color: green; font-family: 黑体; font-size: 20px">
姓名：<input type="text" name="name"><br>
学号：<input type="text" name="id"><br>
年龄：<input type="text" name="age"><br>
班级：<input type="text" name="banji"><br>
分数：<input type="text" name="xuehao"><br>

<input type="submit" value="提交" /> 
        <input type="reset" value="重置" />


</p>
</form>
</body>
</html>

 

 

package Bean;

public class bean {

    
    private String name;
    private String id;
    private String age;
    private String banji;
    private String xuehao;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    public String getBanji() {
        return banji;
    }
    public void setBanji(String banji) {
        this.banji = banji;
    }
    public String getXuehao() {
        return xuehao;
    }
    public void setXuehao(String xuehao) {
        this.xuehao = xuehao;
    }
    

    
    
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%

String name=(String)request.getParameter("name");
String id=(String)request.getParameter("id");
String age=(String)request.getParameter("age");
String banji=(String)request.getParameter("banji");
String xuehao=(String)request.getParameter("xuehao");
Dao.tianjia(name,id,age,banji,xuehao);
out.print("<script language='javaScript'> alert('添加成功');</script>");
response.setHeader("refresh", "0;url=show.jsp");%>





%>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="addInput.jsp" method="get">
    <p style="text-align:center;color:blue;font-family:小四; font-size:20px">
          菜单
            
            <br> 选择功能： <input type="button" value="增加" onclick="location.href='add.jsp'" />
                <input type="button" value="删除" onclick="location.href='shanchu.jsp'" />
                <input type="button" value="修改"onclick="location.href='xiugai.jsp'" />
                <input type="button" value="查询" onclick="location.href='chaxun.jsp'" />
                <input type="button" value="浏览" onclick="location.href='show.jsp'" />
            <br>
    </p>
    
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="chaxun2.jsp" method="get">
<p style="text-align:center;color: red; font-family: 黑体; font-size: 20px">
输入查询的学号
<br> <input type="text" name="xuehao" /> <br>
    <br><input type="submit" value="提交" /> 
        <input type="reset" value="重置" />  <br>
    <br> <input type="button" value="返回菜单" onclick="location.href='menu.jsp'" /> <br>
    </p>
</form>
</body>
</html>

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
        <%@ page import="util.dbutil"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
style="text-align:center">
查询结果
<p>
<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%
String xuehao=(String)request.getParameter("xuehao");
if(xuehao==""){
    out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
}
else 
{
    %>
    <table border="1"style="text-align:center;">
                <tr>
                <td align="center" width=6%>姓名</td>
                <td align="center" width=3%>ID</td>
                <td align="center" width=10>年龄</td>
                <td align="center" width=10%>班级</td>
                </tr>
    <% 
        int i=0;
        Connection connection = dbutil.getConnection();
        PreparedStatement preparedStatement=null; 
        ResultSet rs=null;
        try {
            String sql= " select * from xuesheng where name like ? or id like ? or age like ? or banji like ? ";
            preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+xuehao+"%");
            preparedStatement.setString(2,"%"+xuehao+"%");
            preparedStatement.setString(3,"%"+xuehao+"%");
            preparedStatement.setString(4,"%"+xuehao+"%");
            rs=preparedStatement.executeQuery();
            while(rs.next())
            {
                i++;
                %>
                <tr>
                <td align="center"><a style="color:blue" href='chaxun3.jsp?xuehao=<%=rs.getObject(5) %>'><%=rs.getObject(1) %></a> </td>
                <td align="center"><%=rs.getObject(2) %></td>
                <td align="center"><%=rs.getObject(3) %></td>
                 <td align="center"><%=rs.getObject(4) %></td>
                </tr>
                <%   
            }
            if(i==0)
            {
                out.print("<script language='javaScript'> alert('没有查询到有关信息'); window.history.back(-1); </script>");
            }
        } catch (SQLException  e) {
            e.printStackTrace();

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
            <%@ page import="util.dbutil"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
        
        <%
        String xuehao = (String)request.getParameter("xuehao");
        Connection connection = dbutil.getConnection();
        PreparedStatement preparedStatement=null; 
        ResultSet rs=null;
        try {
            String sql = "select * from xuesheng";
            preparedStatement=connection.prepareStatement(sql);
            rs=preparedStatement.executeQuery();
            while(rs.next()){
                if(xuehao.equals(rs.getObject(5)))
                {
                %>
                <table border="1"style="text-align:center;">
                <tr>
                <td align="center" width=6%>姓名</td>
                <td align="center" width=8%>ID</td>
                <td align="center" width=10%>年龄</td>
                <td align="center" width=10%>班级</td>
                <td align="center" width=6%>学号</td>
       

                </tr>
                <tr>
                <td align="center"><%=rs.getObject(1) %></td>
                <td align="center"><%=rs.getObject(2) %></td>
                <td align="center"><%=rs.getObject(3) %></td>
                <td align="center"><%=rs.getObject(4) %></td>
                <td align="center"><%=rs.getObject(5) %></td>

   
                </tr>
                <%
                }
            }
        } catch (SQLException  e) {
            e.printStackTrace();
        }finally{
                  }
        %>
        </table>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
<input type="button" name="back" onclick="javascript:window.history.back(-1);" value=返回上一页>
<input type="button" value="返回菜单" onclick="location.href='caidan.jsp'" /> <br>
</p>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="shanchu2.jsp" method="get">
<p style="text-align:center;color: red; font-family: 黑体; font-size: 20px">

删除请输入学号：<input type="text" name="xuehao"><br>
<input type="submit" value="提交" /> 
  <input type="reset" value="重置" />  <br>

</p>
</form>
</body>
</html>

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="util.dbutil"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>

<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%
    String xuehao=(String)request.getParameter("xuehao");
    if(xuehao==""){
        out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
    }
    else if(!Dao.isSame(xuehao))
    {
        out.print("<script language='javaScript'> alert('该学号学生不存在'); window.history.back(-1); </script>");
    }
    else{
        %>
        <table border="1"style="text-align:center;">
        <tr>
        <td align="center" width=6%>学号</td>
        <td align="center" width=8%>姓名</td>
        <td align="center" width=10%>班级</td>
        <td align="center" width=10%>课程</td>
        <td align="center" width=6%>分数</td>
        <td align="center" width=3%>删除</td>
        </tr>
        <%
        Connection connection = dbutil.getConnection();
        PreparedStatement preparedStatement=null; 
        ResultSet rs=null;
        try {
            String sql = "select * from xuesheng";
            preparedStatement=connection.prepareStatement(sql);
            rs=preparedStatement.executeQuery();
            while(rs.next()){
                if(xuehao.equals(rs.getObject(5)))
                {
                %>
                <tr>
                <td align="center"><%=rs.getObject(1) %></td>
                <td align="center"><%=rs.getObject(2) %></td>
                <td align="center"><%=rs.getObject(3) %></td>
                <td align="center"><%=rs.getObject(4) %></td>
                <td align="center"><%=rs.getObject(5) %></td>
                
                <td align="center"><a style="color:blue" href='shanchu3.jsp?xuehao=<%=rs.getObject(5) %>' onclick="javascript:return del()">删除</a> </td>
                </tr>
                
                <%
            }
            }     
        } catch (SQLException  e) {
            e.printStackTrace();
        }finally{
            //util.close(rs);
            //util.close(preparedStatement);
            //util.close(connection);
        }
        %>
        </table>
        <%
    }
%>

<script>
    function del(){
        var r = confirm("确定要删除吗？")
        if (r == true) {
             return true; 
        } else {
            return false;
        }
    } 
</script>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <br> <input type="button" value="返回菜单" onclick="location.href='shanchu.jsp'" /> <br>
</p>
</body>
</html>

 

        }finally{
           
        }  
}
    %>
</table>

<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <br> <input type="button" value="返回菜单" onclick="location.href='caidan.jsp'" /> <br>
</p>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<input type="button" onclick="openResult()" value="删除"/>
<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%
String xuehao=(String)request.getParameter("xuehao");
Dao.delete(xuehao);
out.print("<script language='javaScript'> alert('删除成功');</script>");
response.setHeader("refresh", "0;url=shanchu.jsp");
%>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <br> <input type="button" value="返回菜单" onclick="location.href='shanchu.jsp'" /> <br>
</p>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="util.dbutil"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">

<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<table border="1"style="text-align:center;">
 <tr>
                <td align="center" width=6%>姓名</td>
                <td align="center" width=8%>学号</td>
                <td align="center" width=10%>年龄</td>
                <td align="center" width=10%>班级</td>
                <td align="center" width=6%>分数</td>
<%
Connection connection = dbutil.getConnection();
PreparedStatement preparedStatement=null; 
ResultSet rs=null;
try {
    String sql = "select * from xuesheng";
    preparedStatement=connection.prepareStatement(sql);
    rs=preparedStatement.executeQuery();
    while(rs.next()){
%>
        <tr>
        <td align="center"><%=rs.getObject(1) %></td>
        <td align="center"><%=rs.getObject(2) %></td>
        <td align="center"><%=rs.getObject(3) %></td>
        <td align="center"><%=rs.getObject(4) %></td>
        <td align="center"><%=rs.getObject(5) %></td>

        </tr>
<%
    }
} catch (SQLException  e) {
    e.printStackTrace();
}finally{
    //util.close(rs);
    //util.close(preparedStatement);
   // util.close(connection);
}
%>
</tr>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="xiugai1.jsp" method="get">
<p style="text-align:center;color: red; font-family: 黑体; font-size: 20px">

修改请输入学号：<input type="text" name="xuehao"><br>
<input type="submit" value="提交" /> 
  <input type="reset" value="重置" />  <br>

</p>
</form>
</body>
</html>

<%@ page language="java"  import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="util.dbutil"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%
    String xuehao=(String)request.getParameter("xuehao");
    if(xuehao==""){
        out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
    }
    else if(!Dao.isSame(xuehao))
    {
        out.print("<script language='javaScript'> alert('主题不存在'); window.history.back(-1); </script>");
    }
    else{
        %>
        <table border="1"style="text-align:center;">
        <tr>
         <td align="center" width=6%>姓名</td>
         <td align="center" width=8%>ID</td>
         <td align="center" width=10%>年龄</td>
         <td align="center" width=10%>班级</td>
         <td align="center" width=10%>学号</td>
         <td align="center" width=3%>修改</td>
        </tr>
        <%
        Connection connection = dbutil.getConnection();
        PreparedStatement preparedStatement=null; 
        ResultSet rs=null;
        try {
            String sql = "select * from xuesheng";
            preparedStatement=connection.prepareStatement(sql);
            rs=preparedStatement.executeQuery();
            while(rs.next()){
                if(xuehao.equals(rs.getObject(5)))
                {
                %>
                <tr>
                <td align="center"><%=rs.getObject(1) %></td>
                <td align="center"><%=rs.getObject(2) %></td>
                <td align="center"><%=rs.getObject(3) %></td>
                <td align="center"><%=rs.getObject(4) %></td>
                <td align="center"><%=rs.getObject(5) %></td>
     

               <td align="center"><a style="color:blue" href='xiugai2.jsp?xuehao=<%=rs.getObject(5) %>'>修改</a> </td>
                </tr>
                <%
            }
            }     
        } catch (SQLException  e) {
            e.printStackTrace();
        }finally{
          /*  util.close(rs);
            util.close(preparedStatement);
            util.close(connection);*/
        }
        %>
        </table>
        <%
    }
%>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <br> <input type="button" value="返回菜单" onclick="location.href='caidan.jsp'" /> <br>
</p>
</body>
</html>

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="util.dbutil"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%
    String xuehao=(String)request.getParameter("xuehao");
    session.setAttribute("xuehao",xuehao);
    %>
    <table border="1"style="text-align:center;">
    <tr>
    <td align="center" width=6%>姓名</td>
    <td align="center" width=8%>ID</td>
    <td align="center" width=10%>年龄</td>
    <td align="center" width=10%>班级</td>
    <td align="center" width=10%>学号</td>

    </tr>
    <%
    Connection connection = dbutil.getConnection();
    PreparedStatement preparedStatement=null; 
    ResultSet rs=null;
    try {
        String sql = "select * from xuesheng";
        preparedStatement=connection.prepareStatement(sql);
        rs=preparedStatement.executeQuery();
        while(rs.next()){
            if(xuehao.equals(rs.getObject(1)))
            {
            %>
            <tr>
            <td align="center"><%=rs.getObject(1) %></td>
            <td align="center"><%=rs.getObject(2) %></td>
            <td align="center"><%=rs.getObject(3) %></td>
            <td align="center"><%=rs.getObject(4) %></td>
            <td align="center"><%=rs.getObject(5) %></td>
       
            </tr>
            <%
        }
        }   
    } catch (SQLException  e) {
        e.printStackTrace();
    }finally{
       /* util.close(rs);
        util.close(preparedStatement);
        util.close(connection);*/
    }
    %>
    </table>
    
    <form action="xiugai3.jsp" method="get">
    <p style="text-align:center;color: orange; font-family: 黑体; font-size: 20px">
    <br>
    <br>
    修改

    <br> 姓名 <input type="text" name="name" size="30"/><br>
   
    <br> ID <input type="text" name="id"/><br>
     <br> 年龄 <input type="text" name="age"/><br>
  
            <br> 班级 <input type="text" name="banji"/><br>
       
    
   
    <br><input type="submit" value="提交" /> 
        <input type="reset" value="重置" />  <br>
    <br> <input type="button" value="返回菜单" onclick="location.href='caidan.jsp'" /> <br>
</p>
</form>
</body>
</html>

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
            <%@ page import="util.dbutil"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<jsp:useBean id="Dao" class="Dao.dao" scope="page" />
<%
String xuehao=(String)session.getAttribute("xuehao");
String name=(String)request.getParameter("name");
String id=(String)request.getParameter("id");
String age=(String)request.getParameter("age");
String banji=(String)request.getParameter("banji");

if(name==""||id==""||age==""||banji=="")
{
    out.print("<script language='javaScript'> alert('输入为空');window.history.back(-1);</script>");
}
else
{
    Dao.revisedata(xuehao,name,id,age,banji);
    out.print("<script language='javaScript'> alert('修改成功');</script>");
    response.setHeader("refresh", "0;url=xiugai.jsp");
}
%>
<p style="text-align:center;color: yellow; font-family: 宋体; font-size: 20px">
    <br> <input type="button" value="返回菜单" onclick="location.href='menu.jsp'" /> <br>
</p>
</body>
</html>