reward_punish.java

一个学生课绩管理系统

package control;

import java.io.*;
import java.sql.*;
import database.sqlBean;
import javax.servlet.*;
import javax.servlet.http.*;

public class reward_punish extends HttpServlet {

	public void doPost(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {

		String message = null;
		String id = null;
		id = req.getParameter("id");
		HttpSession session = req.getSession(true);
		session.setAttribute("id", String.valueOf(id));
		String reward = null;
		reward = req.getParameter("reward");

		String punish = null;
		punish = req.getParameter("punish");
		if (reward != "") {
			sqlBean db = new sqlBean();
			String sql = "insert into reward value(" + id + "," + reward + ")";
			db.executeUpdate(sql);
		}
		if (punish != "") {
			sqlBean db = new sqlBean();
			String sql = "insert into punish value(" + id + "," + punish + ")";
			db.executeUpdate(sql);
		}
		RequestDispatcher rd = getServletContext().getRequestDispatcher(
				"/reward_punish.jsp");
		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 void doGet(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		doGet(req,res);
	}

}