package test;

import java.io.*;
import javax.servlet.http.*;
import javax.servlet.ServletException;
import javax.sql.DataSource;
import javax.naming.*;
import java.sql.*;
import java.util.*;

public class Student_sub extends HttpServlet
{
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException, IOException
      {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html;charset=gb2312");
		DbBean dbBean = (DbBean)request.getSession().getAttribute("DbBean");
		String sid = request.getSession().getAttribute("g_sid").toString();
			String sql;
			int count = Integer.parseInt(request.getSession().getAttribute("course_subnum").toString());

			try
			{
				for (int i = 0; i < count; i++)
				{
					if (request.getParameter("box"+i) != null)
					{
						sql = "delete from course_student where sid = '" + sid + "' and cid = '" + request.getSession().getAttribute("scid" + i).toString() + "'";
						dbBean.Update(sql);
					}
				}
			}
			catch (Exception e)
			{
			}
			response.sendRedirect("sselect.jsp");
		
	}

	public void doGet(HttpServletRequest request,HttpServletResponse response)
	throws ServletException, IOException
       {
			doPost(request,response);
	}
}