package?com.action;

import?java.io.IOException;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?javax.servlet.RequestDispatcher;
import?javax.servlet.ServletConfig;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.dao.DB;
import?com.orm.TQianfei;
import?com.orm.TUser;
import?com.orm.TXuesheng;
import?com.service.GetListService;
import?com.util.DateUtils;

public?class?cwc_servlet?extends?HttpServlet
{
	public?void?service（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException?
	{
????????String?type=req.getParameter（“type“）;
		
????????if（type.endsWith（“xueshengList“））
????????{
????????	xueshengList（req?res）;
????????}
????????if（type.endsWith（“l(fā)xqr“））
????????{
????????	lxqr（req?res）;
????????}
????????if（type.endsWith（“cwctj“））
????????{
????????	cwctj（req?res）;
????????}???
????????
????????if（type.endsWith（“qianfeiAdd“））
????????{
????????	qianfeiAdd（req?res）;
????????}
????????if（type.endsWith（“qianfei_cwc“））
????????{
????????	qianfei_cwc（req?res）;
????????}
????????if（type.endsWith（“qianfei_xuesheng“））
????????{
????????	qianfei_xuesheng（req?res）;
????????}????????
	}
	
	public?void?cwctj（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		TUser?user?=?（TUser）req.getSession（）.getAttribute（“user“）;
		String?sql=“select?*?from?t_queren?where?user_id=“+user.getId（）;
		
		GetListService?gl?=?new?GetListService（）;

		req.setAttribute（“querenList“?gl.getQuerenList（sql））;
		req.getRequestDispatcher（“admin/tsg/tsgtj.jsp“）.forward（req?res）;
	}?	
	
	public?void?lxqr（HttpServletRequest?reqHttpServletResponse?res）
	{
		TUser?user?=?（TUser）req.getSession（）.getAttribute（“user“）;
		int?userType?=?（Integer）req.getSession（）.getAttribute（“userType“）;
		String?xuesheng_id?=?req.getParameter（“xuesheng_id“）;
		String?shijian?=?DateUtils.formatDate2Str（new?Date（）?“yyyy-MM-dd“）;
		
		DB?mydb=new?DB（）;
		
		String?sql=“insert?into?t_queren?（xuesheng_iduser_idshijianlx）?“?+
				???“values（????）“;
		object[]?params={xuesheng_iduser.getId（）shijianuserType};
		mydb.doPstm（sql?params）;
		
		sql?=?“update?t_xuesheng?set?zt_cwc=1?where?id=?“;
		object[]?params1={xuesheng_id};
		mydb.doPstm（sql?params1）;
		
		mydb.closed（）;
		
		req.setAttribute（“message“?“操作成功“）;
		req.setAttribute（“path“?“cwc?type=cwctj“）;
		
		String?targetURL?=?“/common/success.jsp“;
		dispatch（targetURL?req?res）;
		
	}	
	
	public?void?xueshengList（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		String?sql=“select?*?from?t_xuesheng?where?zt_cwc=0“;
		
		GetListService?gl?=?new?GetListService（）;

		req.setAttribute（“xueshengList“?gl.getXueshengList（sql））;
		req.getRequestDispa