📄 teachersvlt.java
字号:
package com.course;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TeacherSvlt extends HttpServlet{
// 响应get请求
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
//获得教师ID
String tea_id =req.getParameter("id");
int success = 0;
// 获取请求中的参数
String action = action = req.getParameter("action");
teacher tea = null;
String message="";
// 如果请求中包含新建教师参数
if ("new".equalsIgnoreCase(action)) {
// 调用新建教师方法
tea = doNew(req,res);
// 并将新建教师存储在request上下文中,然后转向getteacher.jsp页面
sendBean(req, res, tea, "/getteacher.jsp");
}
//如果请求中包含更新教师参数
if ("update".equalsIgnoreCase(action)) {
try{
//调用更新教师方法
tea = doUpdate(req,res, tea_id);
//并将更新教师存储在request上下文中,然后转向getteacher.jsp页面
sendBean(req,res,tea,"/getteacher.jsp");
}
catch(SQLException e){}
}
//如果请求中包含删除教师参数
if ("delete".equalsIgnoreCase(action)) {
try{
//调用删除教师方法
success = doDelete(tea_id);
}
catch(SQLException e){}
if (success != 1) {
doError(req, res, "TeacherSvlt: Delete unsuccessful. Rows affected: " + success);
} else {
res.sendRedirect("http://localhost:8080/test/getteacher.jsp");
}
}}
//新建教师方法定义
public teacher doNew(HttpServletRequest req,HttpServletResponse res )
throws ServletException,IOException{
teacher tea= new teacher();
String tea_id=req.getParameter("id");
String name=new String(req.getParameter("name").getBytes("ISO8859_1"));
String password= req.getParameter("password");
String title=new String (req.getParameter("title").getBytes("ISO8859_1"));
if(isTrue(req,res,tea_id,name,password) && hasLogin(req,res,tea_id)){
tea.setId(tea_id);
tea.setName(name);
tea.setPassword(password);
tea.setTitle(title);
tea.addTeacher();
}
return tea;
}
//更新教师信息方法
public teacher doUpdate(HttpServletRequest req,HttpServletResponse res , String id)
throws ServletException,IOException,SQLException {
teacher tea = new teacher();
String name=new String(req.getParameter("name").getBytes("ISO8859_1"));
String password = req.getParameter("password");
String title = new String(req.getParameter("title").getBytes("ISO8859_1"));
if(isTrue(req,res,id,name,password)){
tea.setId(id);
tea.setName(name);
tea.setPassword(password);
tea.setTitle(title);
tea.update();
}
return tea;
}
//删除教师
public int doDelete(String id) throws SQLException {
int num=0;
teacher tea=new teacher();
num=tea.delete(id);
return num;
}
// 保存教师信息的JavaBean到request上下文中
public void sendBean(HttpServletRequest req, HttpServletResponse res,
teacher tea, String target)
throws ServletException, IOException {
req.setAttribute("tea", tea);
RequestDispatcher rd = getServletContext().getRequestDispatcher(target);
rd.forward(req, res);
}
//错误处理方法
public void doError(HttpServletRequest req,
HttpServletResponse res,
String str)
throws ServletException, IOException {
req.setAttribute("problem", str);
RequestDispatcher rd = getServletContext().getRequestDispatcher("/errorpage.jsp");
rd.forward(req, res);
}
//判断教师是否被注册过
public boolean hasLogin(HttpServletRequest req, HttpServletResponse res,String id)
throws ServletException, IOException{
boolean f=true;
String message="对不起,该教师号已经被注册过了!";
teacher tea= new teacher();
f= tea.hasLogin(id);
if(f==false){
doError(req,res,message);
}
return f;
}
//判断教师注册是否成功
public boolean isTrue(HttpServletRequest req, HttpServletResponse res,
String id,String name,String password)
throws ServletException, IOException {
boolean f=true;
String message ="";
if(id==null || id.equals("")) {
f=false;
message="错误,教师号不能为空!";
doError(req,res,message); }
if(name==null || name.equals("")) {
f=false;
message="教师姓名不能为空,请重新填写!";
doError(req,res,message); }
if(password==null || password.equals("")) {
f=false;
message="密码不能为空,请重新填写!";
doError(req,res,message); }
return f;
}
//响应post请求
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
doGet(req, res);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -