教师管理系统-CSDN博客

增加和查询界面：

<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>Insert title here</title>
</head>
<body>

             <table border="1" cellpadding="0" cellspacing="0" width="700" align="center" >
             <tr height="20"><td colspan="7" rowspan="2" width="700"><center><h2>教师信息表</h2></center></td> </tr>
            <tr height="20"></tr>
            
             <tr height="20" align="center">
             <td width="100">TNO</td>
             <td width="100">TNAME</td>
             <td width="100">TSEX</td>
             <td width="100">TBIRTHDAY</td>
             <td width="100">PROF</td>
             <td width="100">DEPART</td>
             <td width="100">操作</td>
             </tr>             
             </table>
<%

try {
    //连接数据库
    Class.forName("oracle.jdbc.driver.OracleDriver");    
    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","test","test");

    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from teacher");
    
    if(rs!=null)
    {
         while(rs.next())
            {
             SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
              %>
             <table border="1" cellpadding="0" cellspacing="0" width="700" align="center" >          
             
             <tr height="30" align="center">
             <td width="100"><%=rs.getString("tno") %></td>
             <td width="100"><%=rs.getString("tname") %></td>
             <td width="100"><%=rs.getString("tsex") %></td>
             <td width="100"><%=sdf.format(rs.getDate("tbirthday"))%></td>
             <td width="100"><%=rs.getString("prof") %></td>
             <td width="100"><%=rs.getString("depart") %></td>
             <td width="100"><a href='UpdateT.jsp?tno=<%=rs.getString("tno") %>'>修改</a> <a href='DeleteTeacher?tno=<%=rs.getString("tno") %>'>删除</a></td>
             </tr>             
             </table>
              
              
              
              
              <%      
            }
    }
 
    
    con.close();
    st.close();
    rs.close();
    
    
    
    
} catch (Exception e) {
    // TODO 自动生成的 catch 块
    e.printStackTrace();
}

%>


<br><b>添加教师信息</b><br>
<form action="SaveTeacher" method="post">
<table cellpadding="0" cellspacing="0" >
<tr>
<td>编号：</td>
<td><input type="text" name="tno"></td>
</tr>

<tr>
<td>姓名：</td>
<td><input type="text" name="tname"></td>
</tr>

<tr>
<td>性别：</td>
<td><input type="text" name="tsex"></td>
</tr>

<tr>
<td>生日：</td>
<td><input type="text" name="tbirthday"></td>
</tr>

<tr>
<td>职称：</td>
<td><input type="text" name="prof"></td>
</tr>

<tr>
<td>系别：</td>
<td><input type="text" name="depart"></td>
</tr>
<tr>
<td><input type="submit" value="提交"></td>
</tr>
</table>
</form>
</body>
</html>

删除功能，servlet

package com.hanqi.web;

import java.io.IOException;
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;

/**
 * Servlet implementation class DeleteTeacher
 */
public class DeleteTeacher extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DeleteTeacher() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        //response.getWriter().append("Served at: ").append(request.getContextPath());
        String tno=request.getParameter("tno");
        if(tno!=null&&tno.trim().length()!=0)
        {
            try{
                //处理，即保存
                //连接数据库
                //1.加载驱动
                Class.forName("oracle.jdbc.driver.OracleDriver");
                //2.得到连接
                Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","test","test");

                //插入数据
                PreparedStatement ps=con.prepareStatement(
                        "delete teacher where "+"tno=?");
                
                
                
                ps.setString(1, tno);
                
                ps.executeUpdate();
                ps.close();
                con.close();
                
                //跳转页面
                
                
                response.getWriter().write("删除成功！");
                response.setHeader("refresh", "3;teacher.jsp");
            }catch (Exception e)
            {
                e.printStackTrace();
                
                response.getWriter().write("删除失败！");
                response.setHeader("refresh", "3;teacher.jsp");
                
                
            }
        }
        else
        {
            response.getWriter().write("请正确提交数据！");
            response.setHeader("refresh", "3;teacher.jsp");
        }
    
    
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

更新：

<%@page import="java.text.*"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>Insert title here</title>
</head>
<body>
<%
//接收主键，从数据库中读取最新数据
String tno=request.getParameter("tno");
String tname="";
String tsex="";
String tbirthday="";
String prof="";
String depart="";

if(tno!=null&&tno.trim().length()>0)
{
    //读取最新数据
    
            try{
            //处理，即保存
            //连接数据库
            //1.加载驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //2.得到连接
            Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","test","test");

            PreparedStatement ps=con.prepareStatement("select * from teacher where tno = ?");
            ps.setString(1, tno);
            
            ResultSet rs=ps.executeQuery();
            
            if(rs!=null&&rs.next())
            {
                tname=rs.getString("tname");
                tsex=rs.getString("tsex");
                SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
                
                tbirthday=sdf.format(rs.getDate("tbirthday"));
                prof=rs.getString("prof");
                depart=rs.getString("depart");
                
                
            }else
            {
                out.print("未查询到数据");
            }
            
            rs.close();
            ps.close();
            con.close();
            
            
            
            
            
            
            }catch (Exception e)
            {
                e.printStackTrace();
                
                response.getWriter().write("保存失败！");
                response.setHeader("refresh", "3;teacher.jsp");
            }
    
    
    
    }else
    {
        out.print("请正确访问");
    }


%>
<br><b>修改教师信息</b><br>
<form action="SaveTeacher" method="post">
<table cellpadding="0" cellspacing="0" >
<tr>
<td>编号：</td>
<td><input type="text" name="tno" value="<%=tno %>" readonly="readonly"></td>
</tr>

<tr>
<td>姓名：</td>
<td><input type="text" name="tname" value="<%=tname %>"></td>
</tr>

<tr>
<td>性别：</td>
<td><input type="text" name="tsex" value="<%=tsex %>"></td>
</tr>

<tr>
<td>生日：</td>
<td><input type="text" name="tbirthday" value="<%=tbirthday %>"></td>
</tr>

<tr>
<td>职称：</td>
<td><input type="text" name="prof" value="<%=prof %>"></td>
</tr>

<tr>
<td>系别：</td>
<td><input type="text" name="depart" value="<%=depart %>"></td>
</tr>
<tr>
<td><input type="submit" value="提交"></td>
<td><input type="hidden" name="isupdate" value="1"></td>
</tr>

</table>
</form>


</body>
</html>

保存：

package com.hanqi.web;

import java.io.IOException;
import java.sql.*;
import java.text.SimpleDateFormat;

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

/**
 * Servlet implementation class SaveTeacher
 */
public class SaveTeacher extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public SaveTeacher() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        //response.getWriter().append("Served at: ").append(request.getContextPath());
    
    
        String tno=request.getParameter("tno");
        String tname=request.getParameter("tname");
        String tsex=request.getParameter("tsex");
        String tbirthday=request.getParameter("tbirthday");
        String prof=request.getParameter("prof");
        String depart=request.getParameter("depart");
        String isupdate=request.getParameter("isupdate");
        
        if(tno!=null&&tno.trim().length()!=0)
        {
        
        try {
            //连接数据库
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","test","test");
            
            PreparedStatement ps=con.prepareStatement(
                    "insert into teacher (tname,tsex,tbirthday,prof,depart,tno)"+" values (?,?,?,?,?,?)");
            
            if(isupdate!=null&&isupdate.equals("1"))
            {
                ps=con.prepareStatement(
                        "update teacher set tname=?,tsex=?,tbirthday=?,prof=?,depart=? where "+"tno=?");
            }
            
            
            
            
            SimpleDateFormat adf=new SimpleDateFormat("yyyy-MM-dd");
            java.util.Date bir =adf.parse(tbirthday);
            //使用long型的时间构造sql.Date
            Date sqlBir=new Date(bir.getTime());
            
            ps.setString(1, tname);
            ps.setString(2, tsex);
            ps.setDate(3 ,sqlBir);
            ps.setString(4, prof);
            ps.setString(5, depart);
            ps.setString(6, tno);
            
            
            ps.executeUpdate();
            
            ps.close();
            con.close();
            
            
            response.getWriter().write("保存成功！");
            response.setHeader("refresh", "3;teacher.jsp");
            
    
        } catch (Exception e) {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
            response.getWriter().write("保存失败！");
            response.setHeader("refresh", "3;teacher.jsp");
        }
    
    
        
    
    }else
    {
        response.getWriter().write("请正确提交数据！");
        response.setHeader("refresh", "3;teacher.jsp");
    }
    
    
    
    
    
    
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}