对应的 曾删改查 都有对应的提示
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>
<a href="QueryStudentpage?page=<%=pa.getCurrentpage()+1 %>">下一页</a>
<a href="QueryStudentpage?page=<%=pa.getTotalpage()%>">尾页</a>
<%
}else{
%>
<a href="QueryStudentpage?page=1">首页</a>
<a href="QueryStudentpage?page=<%=pa.getCurrentpage()-1 %>">上一页</a>
<a href="QueryStudentpage?page=<%=pa.getCurrentpage()+1 %>">下一页</a>
<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> <input type="submit" value="提交">
<input type="reset" value="重置">
<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>