分页数据实现

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
对应的 曾删改查 都有对应的提示
在这里插入图片描述

package Org.Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import Org.enrry.Student;
public class DBUtil {
	static Connection conn = null;
	static Statement stat = null;
	static PreparedStatement pstm = null;
	static ResultSet rs = null;
	// 加载驱动
	public static Connection getConnection() throws SQLException {
		try {
			String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
			String user = "scott";
			String password = "tiger";
			Class.forName("oracle.jdbc.driver.OracleDriver");// 加载数据驱动
			conn = DriverManager.getConnection(url, user, password);// 连接数据库
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}

	// 通用增删改
	public static boolean Query(String sql, Object[] params)  {
		int rows = 0;
		try {
			conn = getConnection();
			pstm = conn.prepareStatement(sql);
			for (int i = 0; i < params.length; i++) {
				pstm.setObject(i + 1, params[i]);
			}
			rows = pstm.executeUpdate();
			if (rows > 0) {
				return true;
			} else {
				return false;
			}
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}catch (Exception e) {
			e.printStackTrace();
			return false;
		}finally {
		closeALL(rs, stat, conn);
	}
}

	// 通用查询;(返回一个数组)
	public static List<Student> select(String sql, Object[] params) {
		List<Student> list = new ArrayList<Student>();
		Student student = null;
		try {
			conn = getConnection();

			pstm = conn.prepareStatement(sql);
			rs = pstm.executeQuery();
			while (rs.next()) {
				int id1 = rs.getInt("id");
				String name = rs.getString("name");
				String sex = rs.getString("sex");
				String classname = rs.getString("classname");
				String dormitory = rs.getString("dormitory");
				student = new Student(id1, name, sex, classname, dormitory);
				list.add(student);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

	// 关闭的方法
	public static void closeALL(ResultSet rs, Statement stat, Connection conn) {
		try {
			if (rs != null) {
				rs.close();
			}
			if (stat != null) {
				stat.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}

	}
}
package Org.Dao;
import java.util.List;
import Org.enrry.Student;
public interface Istudao {
	public boolean select(int id);
	// 查询返回学生的一条数据;判断true 或false;
	public Student queyStudent(int id);
	// 添加
	public boolean AddStudent(Student student);
   //删除学生;
	public boolean DeletetStudent(int id);
   //更新
	public boolean UpdateStudent(int id,Student student);
	//查询全部的学生
	public List<Student> QueyALLStudent();
	//查询全部的学生列数总记录数;
	public int selectStudent();
	//分页
	public List<Student> queryStudeng(int page,int pagesizes);
}

package Org.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 Org.enrry.Student;
public class StuDoaimpl implements Istudao {
	Connection conn = null;
	PreparedStatement pastm = null;
	ResultSet Query = null;
	public boolean select(int id) {
		return queyStudent(id) == null ? true : false;//如果反回true 说明 没有数据库数据 则可以添加
	}
	// 查询返回学生的一条数据;判断true 或false;
	public Student queyStudent(int id) {
		Student student = null;
		try {
			int ros = -1;
			conn = DBUtil.getConnection();
			String sql = "SELECT * FROM stu WHERE id = ?";
			pastm = conn.prepareStatement(sql);
			pastm.setInt(1, id);
			Query = pastm.executeQuery();
			while (Query.next()) {
				int id1 = Query.getInt("id");
				String name = Query.getString("name");
				String sex = Query.getString("sex");
				String classname = Query.getString("classname");
				String dormitory = Query.getString("dormitory");
				student = new Student(id1, name, sex, classname, dormitory);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeALL(Query, pastm, conn);
		}
		return student;
	}
	// 添加
	public boolean AddStudent(Student student) {
		String sql = "INSERT  INTO stu (id,name,sex,classname,Dormitory) VALUES(?,?,?,?,?)";
		Object [] params= {student.getId(),student.getName(),student.getSex(), student.getClassname(),student.getDormitory()};
		return DBUtil.Query(sql, params);//返回的ture 或false
	}

//删除学生;
	public boolean DeletetStudent(int id) {
		String sql = "delete FROM stu WHERE id = ?";
		Object [] params= {id};
		return DBUtil.Query(sql, params);//返回的ture 或false
	}
//更新
	public boolean UpdateStudent(int id,Student student) {
		String sql = "update  stu set name=?,Sex=?,Classname=?,Dormitory=? WHERE id = ?";
		Object [] params= {student.getName(),student.getSex(), student.getClassname(),student.getDormitory(),id};
		return DBUtil.Query(sql, params);//返回的ture或false
	}
	
	//查询全部的学生
	public List<Student> QueyALLStudent() {
		List<Student>list  = new ArrayList<Student>();
		Student student = null;
		try {
			conn = DBUtil.getConnection();
			String sql = "SELECT * FROM stu  WHERE  STATUS='0'";
			pastm = conn.prepareStatement(sql);
			Query = pastm.executeQuery();
			while(Query.next()) {
				int id1 = Query.getInt("id");
				String name = Query.getString("name");
				String sex = Query.getString("sex");
				String classname = Query.getString("classname");
				String dormitory = Query.getString("dormitory");
				student = new Student(id1, name, sex, classname, dormitory);
				list.add(student);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeALL(Query, pastm, conn);
		}
		return list;
	}
	//查询全部的学生列数;
	public int selectStudent() {
		int row = 0;
		PreparedStatement pastm3 = pastm;
		try {
			conn = DBUtil.getConnection();
			String sql = " SELECT COUNT(id) FROM stu";
			pastm = conn.prepareStatement(sql);
			Query = pastm.executeQuery();
			if(Query.next()) {
				 row = Query.getInt(1);
			}
		} catch (SQLException e){
			e.printStackTrace();
		}catch (Exception e) {
			e.printStackTrace();
		}
		finally {
			DBUtil.closeALL(Query, pastm3, conn);
		}
		return row;
	}
	//分页查询
	public List<Student> queryStudeng(int page, int pagesizes) {
		List<Student>list  = new ArrayList<Student>();
			try {
				conn = DBUtil.getConnection();
				Student	student =null;
				String sql = "select * from(select a.*,rownum rn from (select * from stu) a where rownum < ?) where rn>?";  
				pastm = conn.prepareStatement(sql);
						pastm.setInt(1, page*pagesizes+1);
						pastm.setInt(2, (page-1)*pagesizes);
						Query = pastm.executeQuery();
						while(Query.next()) {
							int id1 = Query.getInt("id");
							String name = Query.getString("name");
							String sex = Query.getString("sex");
							String classname = Query.getString("classname");
							String dormitory = Query.getString("dormitory");
							student = new Student(id1, name, sex, classname, dormitory);
							list.add(student);
							}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		return list;
	}
	
}

package Org.enrry;
import java.util.List;
public class Page {
private int currentpage;
private int pageSize =8;
private int totalCount;
private int totalpage;
private List<Student>Students;
public int getCurrentpage() {
	return currentpage;
}
public void setCurrentpage(int currentpage) {
	this.currentpage = currentpage;
}
public int getPageSize() {
	return pageSize;
}
public void setPageSize(int pageSize) {
	this.pageSize = pageSize;
}
public int getTotalCount() {
	return totalCount;
}
public void setTotalCount(int totalCount) {
	this.totalCount = totalCount;
}
public int getTotalpage() {
	return totalpage= totalCount%pageSize==0?totalCount/pageSize:totalCount/pageSize+1;
}
public void setTotalpage(int totalpage) {
	this.totalpage=totalpage;
}
public List<Student> getStudents() {
	return Students;
}
public void setStudents(List<Student> students) {
	Students = students;
}
public Page(int currentpage, int pageSize, int totalCount, int totalpage, List<Student> students) {
	super();
	this.currentpage = currentpage;
	this.pageSize = pageSize;
	this.totalCount = totalCount;
	this.totalpage = totalpage;
	Students = students;
}
public Page() {

}
@Override
public String toString() {
	return "Page [currentpage=" + currentpage + ", pageSize=" + pageSize + ", totalCount=" + totalCount + ", totalpage="
			+ totalpage + ", Students=" + Students + "]";
}

}

package Org.enrry;
public class Student {
private int id;
private String name;
private String sex;
private String classname;
private String dormitory;
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public String getSex() {
	return sex;
}
public void setSex(String sex) {
	this.sex = sex;
}
public String getClassname() {
	return classname;
}
public void setClassname(String classname) {
	this.classname = classname;
}
public String getDormitory() {
	return dormitory;
}
public void setDormitory(String dormitory) {
	this.dormitory = dormitory;
}
@Override
public String toString() {
	return "Student [id=" + id + ", name=" + name + ", sex=" + sex + ", classname=" + classname + ", dormitory="
			+ dormitory + "]";
}
public Student(int id, String name, String sex, String classname, String dormitory) {
	super();
	this.id = id;
	this.name = name;
	this.sex = sex;
	this.classname = classname;
	this.dormitory = dormitory;
}
public Student(String name, String sex, String classname, String dormitory) {
	super();
	this.name = name;
	this.sex = sex;
	this.classname = classname;
	this.dormitory = dormitory;
}
}

package Org.service;
import java.util.List;
import Org.enrry.Student;
public interface IStudervice {
	// 删除
	public boolean deleteStu(int id);// 先判断id 是否存在;
	// 更新
	public boolean UpdateStu(int id, Student student);// 先判断id 是否存在;
	// 查询全部
	public List<Student> querAllStu();
	public Student queryStu(int id);
	// 添加
	public boolean addStu(Student student);
     //查询有几条数据
	public int SElectStudent();
	//分页
	public List<Student> queryStudeng(int page, int pagesizes);
}

package Org.service;
import java.util.List;

import Org.Dao.Istudao;
import Org.Dao.StuDoaimpl;
import Org.enrry.Student;

public class Studerviceimpl implements IStudervice {
	Istudao  stu = new StuDoaimpl();
	//删除
	public boolean deleteStu(int id) {//先判断id 是否存在;
		if(!stu.select(id)) {
			return stu.DeletetStudent(id);
		}
			return false;
		}
	//更新
	public boolean UpdateStu(int id,Student student) {//先判断id 是否存在;
		if(!stu.select(id)) {//存在 true;
			return stu.UpdateStudent(id,student);//返回true;
		}
			return false;
		}
	//查询全部
	public List<Student> querAllStu() {
		return stu.QueyALLStudent();
	}
	public Student queryStu(int id) {
		return stu.queyStudent(id);
	}
	//添加
public boolean addStu(Student student) {
	if(stu.select(student.getId())) {
		return	stu.AddStudent(student);
	}
		return false;
}
//查询有几条数据
public int SElectStudent() {
	return	stu.selectStudent();
}
//分页
public List<Student> queryStudeng(int page, int pagesizes){
	return	stu.queryStudeng(page, pagesizes);
}
}

添加的代码

package Org.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Org.enrry.Student;
import Org.service.IStudervice;
import Org.service.Studerviceimpl;
public class addServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html; charset=UTF-8");
	request.setCharacterEncoding("UTF-8");
	int id =Integer.parseInt(request.getParameter("id"));
	String name = request.getParameter("name");
	String sex = request.getParameter("sex");
	String classname = request.getParameter("classname");
	String dormitory = request.getParameter("dormitory");
	Student student = new Student(id, name, sex, classname, dormitory);
	IStudervice stu = new Studerviceimpl();
	boolean addStudent = stu.addStu(student);
	PrintWriter out = response.getWriter();
	/*if(addStudent) {
		request.setAttribute("error", "AddError");
		out.print("<script>alert('添加成功')</script>");
	}else {
		out.print("<script>alert('添加失败')</script>");
	}*/
	if(addStudent) {//如果成功失败 给个提示
		request.setAttribute("right", "AddRiget");
	}else {
		request.setAttribute("right", "AddError");
	}
	//response.sendRedirect("querAllStu");//修改成功访问查询页面;
	request.getRequestDispatcher("QueryStudentpage").forward(request, response);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
	doGet(req, resp);
}
}

删除的代码

package Org.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Org.service.IStudervice;
import Org.service.Studerviceimpl;
public class DeleteServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html; charset=UTF-8");
		request.setCharacterEncoding("UTF-8");
		int id =Integer.parseInt(request.getParameter("id"));
		IStudervice stu = new Studerviceimpl();
		 PrintWriter out = response.getWriter();
		boolean delete = stu.deleteStu(id);//执行这个方法返回的是true 
		if(delete) {
			request.setAttribute("Delright", "DelRiget");
		}else {
			request.setAttribute("Delright", "DelError");
		}
		//response.sendRedirect("querAllStu");//修改成功访问查询页面;
		request.getRequestDispatcher("QueryStudentpage").forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}
}

查询全部

package Org.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 Org.enrry.Student;
import Org.service.IStudervice;
import Org.service.Studerviceimpl;
public class querAllStu extends HttpServlet {
	private static final long serialVersionUID = 1L;
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html; charset=UTF-8");
		request.setCharacterEncoding("UTF-8");
		IStudervice stu = new Studerviceimpl();
		List<Student> st = stu.querAllStu();
	    request.setAttribute("Student", st);
		//转发传数据
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doGet(request, response);
	}
}

根据id进行查询

package Org.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 Org.enrry.Student;
import Org.service.IStudervice;
import Org.service.Studerviceimpl;

//根据id进行查询;
public class queryStu extends HttpServlet {
	private static final long serialVersionUID = 1L;
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html; charset=UTF-8");
		request.setCharacterEncoding("UTF-8");
		int id =Integer.parseInt(request.getParameter("id"));
		IStudervice stu = new Studerviceimpl();
		Student st = stu.queryStu(id);
		request.setAttribute("Student", st);
		request.getRequestDispatcher("update.jsp").forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doGet(request, response);
	}
}

分页查询

package Org.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

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

import Org.enrry.Page;
import Org.enrry.Student;
import Org.service.IStudervice;
import Org.service.Studerviceimpl;
public class QueryStudentpage extends HttpServlet{
	private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html; charset=UTF-8");
	request.setCharacterEncoding("utf-8");
	IStudervice stu = new Studerviceimpl();
	Page pge = new Page();
	String pa = request.getParameter("page");
	if(pa==null) {
		pa="1";
	}
	int count = stu.SElectStudent();//总记录数 
	pge.setTotalCount(count);
	int page =Integer.parseInt(pa);
	if (page>pge.getTotalpage()) {
		page=pge.getTotalpage();//(尾页的下一页)不管你的下一页是第几页 我都让你显示我的尾页
	}
	pge.setCurrentpage(page);//当前页;
	int pagesizes = pge.getPageSize();
	pge.setPageSize(pagesizes);//每页的大小
	List<Student> Students = stu.queryStudeng(page, pagesizes);
	pge.setStudents(Students);//当前页的集合
	request.setAttribute("pge", pge);
	request.getRequestDispatcher("index.jsp").forward(request, response);
}
@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}

更新

package Org.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Org.enrry.Student;
import Org.service.IStudervice;
import Org.service.Studerviceimpl;

public class UpdateStu extends HttpServlet {
	private static final long serialVersionUID = 1L;
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html; charset=UTF-8");
		request.setCharacterEncoding("UTF-8");
		int id =Integer.parseInt(request.getParameter("id"));
		String name = request.getParameter("name");
		String sex = request.getParameter("sex");
		String classname = request.getParameter("classname");
		String dormitory = request.getParameter("dormitory");
		Student stud = new Student( name, sex, classname, dormitory);
		IStudervice stu = new Studerviceimpl();
		boolean update = stu.UpdateStu(id, stud);
		 PrintWriter out = response.getWriter();
		if(update) {
			request.setAttribute("Upright", "UpdaRiget");
		}else {
			request.setAttribute("Upright", "Uperror");
		}
		//response.sendRedirect("querAllStu");//修改成功访问查询页面;
		request.getRequestDispatcher("QueryStudentpage").forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}
}

首页

<%@page import="Org.enrry.Page"%>
<%@page import="Org.enrry.Student"%>
<%@page import="org.apache.jasper.tagplugins.jstl.core.ForEach"%>
<%@page import="java.util.List"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>学生信息表</title>
	<link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css">  
	<script src="https://cdn.staticfile.org/jquery/2.1.1/jquery.min.js"></script>
	<script src="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<%
String right =(String)request.getAttribute("right");
if(right!=null){
if(right.equals("AddRiget")){
	out.print("<script>alert('添加成功');</script>");
}else if(right.equals("AddError")){
	out.print("<script>alert('添加失败');</script>");
}else {}
}
String Upright =(String)request.getAttribute("Upright");
if(Upright!=null){
if(Upright.equals("UpdaRiget")){
	out.print("<script>alert('更新成功');</script>");
}else if(Upright.equals("Uperror")){
	out.print("<script>alert('更新失败');</script>");
}else {}
}
String Delright =(String)request.getAttribute("Delright");
if(Delright!=null){
if(Delright.equals("DelRiget")){
	out.print("<script>alert('删除成功');</script>");
}else if(Delright.equals("DelError")){
	out.print("<script>alert('删除失败');</script>");
}else {}
}
%>
<form>
<table class="table">
	<caption><a href="login.jsp">添加</a></caption>
   <thead>
      <tr>
         <th>id</th>
         <th>姓名</th>
         <th>性别</th>
         <th>班级</th>
         <th>宿舍</th>
         <th>操作</th>
      </tr>
   </thead>
<%
 Page  pa = (Page)request.getAttribute("pge");
for(Student s:pa.getStudents()){
	%>
	<tr>
<td><%=s.getId()%></td>
<td><%=s.getName() %></td>
<td><%=s.getSex() %></td>
<td><%=s.getClassname()%></td>
<td><%=s.getDormitory()%></td>
<td><a href="DeleteServlet?id=<%=s.getId()%>">删除</a>
<a href="queryStu?id=<%=s.getId()%>">更新</a>
</td>
</tr>
	<%	
}
%>
</table>
</form>
<% 
if(pa.getCurrentpage()==1){
	%>
	<a href="QueryStudentpage?page=1">首页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<a href="QueryStudentpage?page=<%=pa.getCurrentpage()+1 %>">下一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<a href="QueryStudentpage?page=<%=pa.getTotalpage()%>">尾页</a>
<% 
}else{
	%>
	<a href="QueryStudentpage?page=1">首页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<a href="QueryStudentpage?page=<%=pa.getCurrentpage()-1 %>">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<a href="QueryStudentpage?page=<%=pa.getCurrentpage()+1 %>">下一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<a href="QueryStudentpage?page=<%=pa.getTotalpage()%>">尾页</a>	
	<% 
}
%>
</body>
</html>
在这里插入代码片

添加的jsp

<%@ 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>
<style type="text/css">
a{
text-decoration:none;
}
</style>
<form action="addServlet"method="post"><br>
<table>
<tr><td>学号:<input type="text" name="id"></td></tr>
<tr><td>姓名:<input type="text" name="name"></td></tr>
<tr><td>性别:<input type="text" name="sex"></td></tr>
<tr><td>班级:<input type="text" name="classname"></td></tr>
<tr><td>宿舍:<input type="text" name="dormitory"></td></tr>
<tr><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="提交">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="reset" value="重置">&nbsp;&nbsp;&nbsp;&nbsp;
<a href="querAllStu">返回</a>
</td></tr>
</table>
</form>
</body>
</html>

更新的


<%@page import="Org.enrry.Student"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>更新</title>
</head>
<body>
<%
Student st =(Student)request.getAttribute("Student");
String name = st.getName();
String Sex = st.getSex();
String Classname = st.getClassname();
String Dormitory = st.getDormitory();
%>
<form action="UpdateStu" method="post">
<table>
<tr><td>学号:<input type="text" name="id" value=<%=st.getId()%> readonly="readonly"></td></tr>
<tr><td>姓名:<input type="text" name="name" value=<%=name %>></td></tr>
<tr><td>性别:<input type="text" name="sex"  value=<%=Sex %>></td></tr>
<tr><td>班级:<input type="text" name="classname"  value=<%=Classname %>></td></tr>
<tr><td>宿舍:<input type="text" name="dormitory" value=<%=Dormitory %>></td></tr>
<tr><td><input type="submit" value="更新"></td></tr>
</table>
</form>
</body>
</html>

web xml 根据自己的 项目进行配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>04-161</display-name>
  <welcome-file-list>
    <welcome-file>QueryStudentpage</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
   <servlet>
   <servlet-name>querAllStu</servlet-name>
  <servlet-class>Org.servlet.querAllStu</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>querAllStu</servlet-name>
  <url-pattern>/querAllStu</url-pattern>
  </servlet-mapping>
  
  <servlet>
   <servlet-name>UpdateStu</servlet-name>
  <servlet-class>Org.servlet.UpdateStu</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>UpdateStu</servlet-name>
  <url-pattern>/UpdateStu</url-pattern>
  </servlet-mapping>
  

  <servlet>
   <servlet-name>addServlet</servlet-name>
  <servlet-class>Org.servlet.addServlet</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>addServlet</servlet-name>
  <url-pattern>/addServlet</url-pattern>
  </servlet-mapping>
  

   <servlet>
   <servlet-name>DeleteServlet</servlet-name>
  <servlet-class>Org.servlet.DeleteServlet</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>DeleteServlet</servlet-name>
  <url-pattern>/DeleteServlet</url-pattern>
  </servlet-mapping>
  
  <servlet>
   <servlet-name>queryStu</servlet-name>
  <servlet-class>Org.servlet.queryStu</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>queryStu</servlet-name>
  <url-pattern>/queryStu</url-pattern>
  </servlet-mapping>
  
  <servlet>
   <servlet-name>QueryStudentpage</servlet-name>
  <servlet-class>Org.servlet.QueryStudentpage</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>QueryStudentpage</servlet-name>
  <url-pattern>/QueryStudentpage</url-pattern>
  </servlet-mapping>
</web-app>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值