src/com/servlet/chengjiServlet.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 chengjiServlet 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 yh=(String)request.getParameter("yh");//用户
String km=(String)request.getParameter("km");//科目
String cj=(String)request.getParameter("cj");//成绩
String sj=(String)request.getParameter("sj");//时间

		response.setCharacterEncoding("gb2312");
 		sql="insert into chengji(yh,km,cj,sj) values('"+yh+"','"+km+"','"+cj+"','"+sj+"')";
;//成绩SQL 语句
		int row=1;
		try {
			row=db.update(sql);//执行sql语句 insert语句
			if(row==1){
			request.setAttribute("flag", "操作成功"); 
			}else{
			request.setAttribute("flag", "操作失败"); 
			}
			
			
			request.getRequestDispatcher("chengji/chengjiadd.jsp").forward(request, response);