教师信息管理

于 2020-02-12 13:16:47 发布
阅读量530 收藏
点赞数
分类专栏： jsp
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_43819419/article/details/104277222
版权

first.jsp 显示页面

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta charset="utf-8">
<title>login UI</title>
    <link rel="stylesheet" href="css/index2.css" type="text/css">
	<style>
		body{
		    margin:0;
		    padding: 0;
		    font-family: sans-serif;
		    background: lightgray;
		    background-size: cover;
		}
		.box
		{
		    position: absolute;
		    top: 50%;
		    left: 50%;
		    transform: translate(-50%,-50%);
		    width:400px;
		 	padding: 40px;
		    background:gray;
			box-sizing:border-box;
			box-shadow:0 15px 25px rgba(0,0,0,.5);
			border-radius: 10px;/*登录窗口边角圆滑*/
			
		}
		.box h2
		{
			margin:0 0 30px;
			padding:0;
			color:#fff;
			text-align:center;
			}
			.box .inputBox
			{
				position:relative;
			}
		.box .inputBox input
		{
			width: 100%;
			padding: 10px 0;
			font-side:16px;
			color: #fff;
			letter-spacing: 1px;
			margin-bottom:30px;/*输入框设置*/
			border:none;
			border-bottom:1px solid #fff;
			outline:none;
			background:transparent;
		}
		.box .inputBox label
		{
		    position: absolute;
		    top: 0;
		    left: 0;
		    padding: 10px 0;
		    font-size: 16px;
		    color: #fff;
		    pointer-events: none;
		    transition: .5s;
		}
		.box .inputBox input:focus ~ label,
		.box .inputBox input:valid ~ label
		{
		    top: -18px;
			left: 0;
			color: #03a9f4;
			font-size: 12px;
		}
		.box  input[type="submit"] 
		{
			background: transparent;
			border: none;
			outline: none;
			color: #fff;
			background: #778899;
			padding: 10px 20px;
			cursor: pointer;
			border-radius: 5px;
		}
		
		
		a{
			color: white;
			text-decoration: none;
			position: absolute;
			margin-top: -5px;
			margin-left: 260px;
			font-size: 15px;
		}
	</style>
</head>
<body>
	
    <div class="box">
            <h2>管理员登陆</h2>
  <form method = "post" action = "ShowServlet">
    <div class="inputBox">
      <input type="text" name="id" required="">
      <label>用户名</label>
    </div>
    <div class="inputBox">
		<input type="password" name="password" required="">
		<label>密码</label>
    </div>
	<div class="inputBox">
		<input type="submit" name="" value="登录">
	 </div>
	  </form>
	</div>
    </body>
</html>

add.jsp 添加数据库

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>login UI</title>
    <style type="text/css">
    	body{
    margin:0;
    padding: 0;
    font-family: sans-serif;
    background: lightgray;
    background-size: cover;
}
.box
{
    position: absolute;
    top: 50%;
    left: 50%;
    transform: translate(-50%,-50%);
    width:400px;
 	padding: 40px;
    background:gray;
	box-sizing:border-box;
	box-shadow:0 15px 25px rgba(0,0,0,.5);
	border-radius: 10px;/*登录窗口边角圆滑*/
	
}
.box h2
{
	margin:0 0 30px;
	padding:0;
	color:#fff;
	text-align:center;
	}
	.box .inputBox
	{
		position:relative;
	}
.box .inputBox input
{
	width: 100%;
	padding: 10px 0;
	font-side:16px;
	color: #fff;
	letter-spacing: 1px;
	margin-bottom:30px;/*输入框设置*/
	border:none;
	border-bottom:1px solid #fff;
	outline:none;
	background:transparent;
}
.box .inputBox label
{
    position: absolute;
    top: 0;
    left: 0;
    padding: 10px 0;
    font-size: 16px;
    color: #fff;
    pointer-events: none;
    transition: .5s;
}
.box .inputBox input:focus ~ label,
.box .inputBox input:valid ~ label
{
    top: -18px;
	left: 0;
	color: #03a9f4;
	font-size: 12px;
}
.box  input[type="submit"] 
{
	background: transparent;
	border: none;
	outline: none;
	color: #fff;
	background: #778899;
	padding: 10px 20px;
	cursor: pointer;
	border-radius: 5px;
}
    	
    </style>
</head>
<body>
    <div class="box">
            <h2>教师信息添加</h2>
  <form action="AddServlet" method="post">
    <div class="inputBox">
      <input type="text" name="id" required="">
      <label>ID</label>
    </div>
    <div class="inputBox">
		<input type="text" name="name" required="">
		<label>姓名</label>
    </div>
	<div class="inputBox">
		<input type="text" name="gender" required="">
		<label>性别</label>
	</div>
	<div class="inputBox">
		<input type="text" name="age" required="">
		<label>年龄</label>
	</div>
	<div class="inputBox">
		<input type="text" name="profession" required="">
		<label>职称</label>
	</div>
    <input type="submit" name="" value="登记"> 
	</form>
	</div>
    </body>
</html>

index.jsp 首页

<%@ 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">
<link rel="stylesheet"  href="css/bootstrap.min.css"/>
<style type="text/css">
    		a{
    			text-decoration: none;
    			color: gray;
				font-weight: bold;
				font-family: STFangsong;
    		}
    		a:hover{
    			text-decoration: none;
    		}
            #fi{
            	width: 80%;
            	margin:auto;
            	margin-top: 20px;
            }
            td{
               
                text-align: center;
                color: dimgray;
				font-weight: bold;
				font-family: STFangsong;
            }
            .hu td{
           		text-align: center;
            	color: black;
				font-weight: bold;
				font-family: STFangsong;
            }
    </style>
<title>显示</title>
    
</head>
<body>
    <table class="table table-striped" id="fi">
        <tr class="hu">
            <td>ID</td>
            <td>姓名</td>
            <td>性别</td>
            <td>年龄</td>
            <td>职称</td>
            <td>其他</td>
        </tr>
        <c:forEach items="${list}" var="item">
            <tr>
                <td>${item.id }</td>
                <td>${item.name }</td>
                <td>${item.gender }</td>
                <td>${item.age }</td>
                <td>${item.profession }</td>
                <td><a href="DeleteServlet?id=${item.id }">删除</a>|<a href="UpdateServlet?id=${item.id }">修改</a></td>
            </tr>
        </c:forEach>
        <tr>
            <td colspan="6" style="text-align: right; font: red;"><a href="add.jsp">添加教师信息&nbsp;&nbsp;&nbsp;&nbsp;</a></td>
        </tr>
    </table>
</body>
</html>

update.jsp 更新数据库

<%@page import="lyq.com.bean.Teacher"%>
<%@ 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>
<html>
<head>
<meta charset="utf-8">
<title>login UI</title>
    <style type="text/css">
    	body{
    margin:0;
    padding: 0;
    font-family: sans-serif;
    background: lightgray;
    background-size: cover;
}
.box
{
    position: absolute;
    top: 50%;
    left: 50%;
    transform: translate(-50%,-50%);
    width:400px;
 	padding: 40px;
    background:gray;
	box-sizing:border-box;
	box-shadow:0 15px 25px rgba(0,0,0,.5);
	border-radius: 10px;/*登录窗口边角圆滑*/
	
}
.box h2
{
	margin:0 0 30px;
	padding:0;
	color:#fff;
	text-align:center;
	}
	.box .inputBox
	{
		position:relative;
	}
.box .inputBox input
{
	width: 100%;
	padding: 10px 0;
	font-side:16px;
	color: #fff;
	letter-spacing: 1px;
	margin-bottom:30px;/*输入框设置*/
	border:none;
	border-bottom:1px solid #fff;
	outline:none;
	background:transparent;
}
.box .inputBox label
{
    position: absolute;
    top: 0;
    left: 0;
    padding: 10px 0;
    font-size: 16px;
    color: #fff;
    pointer-events: none;
    transition: .5s;
}
.box .inputBox input:focus ~ label,
.box .inputBox input:valid ~ label
{
    top: -18px;
	left: 0;
	color: #03a9f4;
	font-size: 12px;
}
.box  input[type="submit"] 
{
	background: transparent;
	border: none;
	outline: none;
	color: #fff;
	background: #778899;
	padding: 10px 20px;
	cursor: pointer;
	border-radius: 5px;
}
    	
    </style>
</head>
<body>
    <div class="box">
            <h2>修改信息</h2>
  <form action="UpdateServlet" method="post">
   <div class="inputBox">
		<input type="text" name="id" value=${ t.id}>
		<label>姓名</label>
    </div>
    <div class="inputBox">
		<input type="text" name="name" value=${ t.name}>
		<label>姓名</label>
    </div>
	<div class="inputBox">
		<input type="text" name="gender" value=${ t.gender}>
		<label>性别</label>
	</div>
	<div class="inputBox">
		<input type="text" name="age" value=${ t.age}>
		<label>年龄</label>
	</div>
	<div class="inputBox">
		<input type="text" name="profession" value=${ t.profession}>
		<label>职称</label>
	</div>
    <input type="submit" name="" value="修改"> 
	</form>
	</div>
    </body>
</html>

teacher.jsp

package lyq.com.bean;

public class Teacher {
	
	private String id;
	private String name;
	private String gender;
	private int age;
	private String profession;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public String getProfession() {
		return profession;
	}
	public void setProfession(String profession) {
		this.profession = profession;
	}
//	public Teacher(String id, String name, String gender, int age, String profession) {
//		super();
//		this.id = id;
//		this.name = name;
//		this.gender = gender;
//		this.age = age;
//		this.profession = profession;
//		// TODO Auto-generated constructor stub
//	}
	
}

AdminDao.java

package lyq.com.dao;

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

import lyq.com.bean.Teacher;

public class AdminDao {
	
	public List<Teacher> getAllAdmin(){
		
		List<Teacher> list = new ArrayList<Teacher>();
		Connection conn = DbConn.getConnection();
		String sql = "select * from t";
		try{
			PreparedStatement pst = conn.prepareStatement(sql);
			ResultSet rst = pst.executeQuery();
			while(rst.next()) {
				Teacher t = new Teacher();
				t.setId(rst.getString(1));
				t.setName(rst.getString(2));
				t.setGender(rst.getString(3));
				t.setAge(rst.getInt(4));
				t.setProfession(rst.getString(5));
				list.add(t);
			}
			rst.close();
			pst.close();
		}catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		
		return list;
	}
	
	public boolean addAdmin(Teacher t) { // 添加信息
		String sql = "insert into t(id,name,gender,age,profession) VALUES (?,?,?,?,?)"; // 添加的SQL语句
		Connection conn = DbConn.getConnection();
		try {
			PreparedStatement pst = conn.prepareStatement(sql);
			pst.setString(1, t.getId());
			pst.setString(2, t.getName());
			pst.setString(3, t.getGender());
			pst.setInt(4, t.getAge());
			pst.setString(5, t.getProfession());
			int count = pst.executeUpdate();
			pst.close();
			return count > 0 ? true : false; // 是否添加的判断
		} catch (Exception e) {
			e.printStackTrace();
		}
		return false;
	}
 
	public boolean updateAdmin(Teacher t) { // 修改
		String sql = "update t set name=?, gender=?, age=?, profession=? where id=?"; // 修改的SQL语句，根据ID修改
		Connection conn = DbConn.getConnection();
		try {
			PreparedStatement pst = conn.prepareStatement(sql);
			
			pst.setString(1, t.getName());
			pst.setString(2, t.getGender());
			pst.setInt(3, t.getAge());
			pst.setString(4, t.getProfession());
			pst.setString(5, t.getId());
			int count = pst.executeUpdate();
			pst.close(); // 关闭
			return count > 0 ? true : false; // 是否修改的判断
		} catch (Exception e) {
			e.printStackTrace();
		}
		return false;
	}
 
	public boolean deleteAdmin(String id) { // 删除
		String sql = "delete from t where id = ?"; // 删除的SQL语句，根据ID删除
		Connection conn = DbConn.getConnection();
		try {
			PreparedStatement pst = conn.prepareStatement(sql);
			pst.setString(1, id);
			int count = pst.executeUpdate();
			pst.close();
			return count > 0 ? true : false; // 是否删除的判断
		} catch (Exception e) {
			e.printStackTrace();
		}
		return false;
	}
	
	
	public Teacher selectAdminById(String id) { // 根据ID进行查询
		Connection conn = DbConn.getConnection();
		String sql = "select * from t where id = '" + id +"'";
		Teacher t = null;
		try {
			PreparedStatement pst = conn.prepareStatement(sql);
			ResultSet rst = pst.executeQuery();
			while (rst.next()) {
				t = new Teacher();
				t.setId(rst.getString(1));
				t.setName(rst.getString(2));
				t.setGender(rst.getString(3));
				t.setAge(rst.getInt(4));
				t.setProfession(rst.getString(5));
			}
			rst.close();
			pst.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return t; // 返回
	}


	
	public static void main(String[] args) {
		AdminDao a = new AdminDao();
//		List l = a.getAllAdmin();
//		for(int i=0; i<l.size(); i++) {
//			System.out.println(l.get(i).toString());
//		}
		
		Teacher t = new Teacher();
//		t.setId("1234");
//		t.setName("li");
//		t.setGender("男");
//		t.setAge(18);
//		t.setProfession("学生");
//		if(a.addAdmin(t)) {
//			System.out.println("ke");
//		}else {
//			System.out.println("bu");
//		}
		if(a.deleteAdmin("1234")) {
			System.out.println("ke");
		}else {
			System.out.println("bu");
		}
	}
	
}

DbConn.java

package lyq.com.dao;

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

public class DbConn {
	private static String url = "jdbc:mysql://localhost:3306/Teacher"; // 数据库地址
	private static String userName = "root"; // 数据库用户名
	private static String passWord = "0522"; // 数据库密码
	private static Connection conn = null;
	
	public static Connection getConnection() {
		if(conn == null) {
			try {
				Class.forName("com.mysql.jdbc.Driver");
				conn = DriverManager.getConnection(url, userName, passWord);
				//System.out.println("连接成功");
			}catch (Exception e) {
				// TODO: handle exception
				System.out.println("连接失败");
			}
		}
		return conn;
	}
	public static void main(String[] args) {
		System.err.println(getConnection());
	}
}

Addservlet.java

package lyq.com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import lyq.com.bean.Teacher;
import lyq.com.dao.AdminDao;

/**
 * Servlet implementation class AddServlet
 */
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AddServlet() {
        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());
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("UTF-8"); 
		String id = request.getParameter("id");
		String name = request.getParameter("name");
		String gender = request.getParameter("gender");
		String a = request.getParameter("age");
		int age  = Integer.parseInt(a);
		String profession = request.getParameter("profession");
		Teacher t = new Teacher();
		t.setId(id);
		t.setName(name);
		t.setGender(gender);
		t.setAge(age);
		t.setProfession(profession);
		//System.out.println(t.toString());
		System.out.println(id+" "+name+" "+gender+" "+age);
		AdminDao dao = new AdminDao();
		dao.addAdmin(t);
		request.getRequestDispatcher("ShowServlet").forward(request, response);
	}

}

DeleteServlet.java

package lyq.com.servlet;

import java.io.IOException;

import javax.security.auth.message.callback.PrivateKeyCallback.Request;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import lyq.com.dao.AdminDao;

/**
 * Servlet implementation class DeleteServlet
 */
@WebServlet("/DeleteServlet")
public class DeleteServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DeleteServlet() {
        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
		this.doPost(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		String id = request.getParameter("id");
		System.out.println(id);
		AdminDao dao = new AdminDao();
		dao.deleteAdmin(id);
		request.getRequestDispatcher("ShowServlet").forward(request, response);
	}
}

ShowServlet.java

package lyq.com.servlet;

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

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

import lyq.com.bean.Teacher;
import lyq.com.dao.AdminDao;

/**
 * Servlet implementation class ShowServlet
 */
@WebServlet("/ShowServlet")
public class ShowServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ShowServlet() {
        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
		this.doPost(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		AdminDao dao = new AdminDao();
		List<Teacher> list = dao.getAllAdmin();
		request.setAttribute("list", list);
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}

}

UpdateServlet.java

package lyq.com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import lyq.com.bean.Teacher;
import lyq.com.dao.AdminDao;

/**
 * Servlet implementation class UpdateServlet
 */
@WebServlet("/UpdateServlet")
public class UpdateServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public UpdateServlet() {
        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
		request.setCharacterEncoding("UTF-8"); 
		String id = request.getParameter("id");
		if (id != null && !id.equals("")) {
			AdminDao dao = new AdminDao();
			Teacher t = dao.selectAdminById(id);
			request.setAttribute("t", t);
		}
		request.getRequestDispatcher("update.jsp").forward(request, response);

	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("UTF-8"); 
		String id = request.getParameter("id");
		String name = request.getParameter("name");
		String gender = request.getParameter("gender");
		String a = request.getParameter("age");
		int age  = Integer.parseInt(a);
		String profession = request.getParameter("profession");
		Teacher t = new Teacher();
		t.setId(id);
		t.setName(name);
		t.setGender(gender);
		t.setAge(age);
		t.setProfession(profession);
		AdminDao dao = new AdminDao();
		dao.updateAdmin(t);
		request.getRequestDispatcher("ShowServlet").forward(request, response);
	}

}
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值