src/com/servlet/shenqingServlet.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.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 javax.servlet.http.HttpSession;

import com.util.*;
import java.util.List;
import java.sql.ResultSet;

public class shenqingServlet extends HttpServlet  {
	public void service(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		request.setCharacterEncoding("gb2312");
		System.out.println("method"+request.getParameter("method"));
		String method=(String)request.getParameter("method");
		if(method.equals("insert")){//申请添加
			insertM(request, response);
		}else if(method.equals("list")){//申请列表
			ListM(request, response);
		}else if(method.equals("delete")){//申请删除
			deleteM(request, response);
		}else if(method.equals("modifyindex")){//申请修改页面
			modifyIndex(request, response);
		}
		else if(method.equals("modify")){//申请修改
			modifyM(request, response);
		}else if(method.equals("detail")){//申请详细信息
			detailM(request, response);
		}else if(method.equals("Plist")){//申请列表信息
			PListM(request, response);
		}
	}
	private void insertM(HttpServletRequest request, HttpServletResponse response){//申请添加
		DBO db=new DBO();//初始化数据链接基础类
		String sql="";//sql语句初始化
			String keyid =(String)request.getParameter("keyid");//申请表主键
String xs=(String)request.getParameter("xs");//学生
String sqbt=(String)request.getParameter("sqbt");//申请标题
String sqnr=(String)request.getParameter("sqnr");//申请内容
String sj=(String)request.getParameter("sj");//时间
String jf=(String)request.getParameter("jf");//加分
String zt=(String)request.getParameter("zt");//状态

		response.setCharacterEncoding("gb2312");
 		sql="insert into shenqing(xs,sqbt,sqnr,sj,jf,zt) values('"+xs+"','"+sqbt+"','"+sqnr+"','"+sj+"','"+jf+"','"+zt+"')";
;//申请SQL 语句
		int row=1;
		try {
			row=db.update(sql);//执行sql语句 insert语句
			if(row==1){
			request.setAttribute("flag", "操作成功"); 
			}else{
			request.setAttribute("flag", "操作失败"); 
			}