actionservlet.java

主要功能是查询

package 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;

public class ActionServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ActionServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=gb2312");
		PrintWriter out = response.getWriter();
		request.setCharacterEncoding("gbk");
		String action = request.getParameter("action");
		// if (action == null) {
		// request.setAttribute("errorMessage", "我处理不了");
		// request.getRequestDispatcher("/error.jsp").forward(request,
		// response);
		// }
		// 普通用户注册
		if (action.equals("zhuce")) {
			String username = request.getParameter("username");
			String passwd = request.getParameter("passwd");
			// String passwd1=request.getParameter("passwd1");
			// request.setAttribute("username", username);
			// request.setAttribute("passwd", passwd);
			// request.setAttribute("passwd1", passwd1);
			bean.sqlBean sql = new bean.sqlBean();
			int rows = sql.getPT(username, passwd);
			if (rows == 1) {
				request.getRequestDispatcher("/success.jsp").forward(request,
						response);
			}
		}
		// 用户登陆
		else if (action.equals("login")) {
			HttpSession session = request.getSession(true);
			String no = request.getParameter("no");
			String shenfen = request.getParameter("shenfen");
			String username = request.getParameter("username");
			if (username == null) {
				username = "";
			}
			String passwd = request.getParameter("passwd");
			if (passwd == null) {
				passwd = "";
			}
			String yanzheng = request.getParameter("yanzheng");
			if (yanzheng == null) {
				yanzheng = "";
			}
			if (no.equals("first")) {
				request.setAttribute("username", username);
				request.setAttribute("passwd", passwd);
				request.getRequestDispatcher("/login.jsp").forward(request,
						response);
			} else if (no.equals("second")) {
				// 普通用户登陆
				if (shenfen != null && shenfen.equals("putong")) {
					bean.sqlBean sql = new bean.sqlBean();
					String[] check = sql.checkUser(username);
					String year1 = (String) session.getAttribute("rand");
					if (check[1].equals(passwd) && year1.equals(yanzheng)) {
						session.setAttribute("username", check[0]);
						request.getRequestDispatcher(
								"ActionServlet?action=query").forward(request,
								response);
						return;
					}
				}
				// 星级用户登陆
				else if (shenfen.equals("star")) {
					bean.sqlBean sql = new bean.sqlBean();
					String[] check = sql.checkUser(username);
					String year1 = (String) session.getAttribute("rand");
					if (check[1].equals(passwd)&&year1.equals(yanzheng)) {
						session.setAttribute("username", check[0]);
						request.getRequestDispatcher(
								"ActionServlet?action=starquery").forward(
								request, response);
						return;
					}
				}
				// 管理员登陆
				else if (shenfen.equals("admini")) {
					bean.sqlBean sql = new bean.sqlBean();
					String[] check1 = sql.checkAdm(username);
					String year = (String) session.getAttribute("rand");
					if (check1[1].equals(passwd)&&year.equals(yanzheng)) {
						session.setAttribute("username", check1[0]);
						request.getRequestDispatcher("/ActionServlet?action=queryadm&tang=first")
								.forward(request, response);
						return;
					}
				}
			}
		}
		// 普通用户查询测试表的功能
		else if (action.equals("query")) {
			String mobiletype = request.getParameter("mobiletype");
			if (mobiletype == null) {
				mobiletype = "";
			}
			String local = request.getParameter("local");
			if (local == null) {
				local = "";
			}
			String result = request.getParameter("result");
			if (result == null) {
				result = "";
			}
			request.setAttribute("mobiletype", mobiletype);
			request.setAttribute("local", local);
			request.setAttribute("result", result);
			bean.sqlBean sql = new bean.sqlBean();
			String[][] normal = sql.getNormal(mobiletype, local, result);
			request.setAttribute("normal", normal);
			request.getRequestDispatcher("/Normal.jsp").forward(request,
					response);
		}
		// 星级用户查询测试表的功能
		else if (action.equals("starquery")) {
			String mobiletype = request.getParameter("mobiletype");
			if (mobiletype == null) {
				mobiletype = "";
			}
			String local = request.getParameter("local");
			if (local == null) {
				local = "";
			}
			String result = request.getParameter("result");
			if (result == null) {
				result = "";
			}
			request.setAttribute("mobiletype", mobiletype);
			request.setAttribute("local", local);
			request.setAttribute("result", result);
			bean.sqlBean sql = new bean.sqlBean();
			String[][] star = sql.getNormal(mobiletype, local, result);
			request.setAttribute("star", star);
			request.getRequestDispatcher("/star/star.jsp").forward(request,
					response);
		}
		// 星级用户向测试表里添加新的测试
		else if (action.equals("addstar")) {
			String time = request.getParameter("time");
			String mobiletype = request.getParameter("mobiletype");
			String ctype = request.getParameter("ctype");
			String local = request.getParameter("local");
			String result = request.getParameter("result");
			if (result == null) {
				result = "";
			}
			String problem = request.getParameter("problem");
			String typeno = request.getParameter("typeno");
			bean.sqlBean sql = new bean.sqlBean();
			int add = sql.getAddStar(time, mobiletype, ctype, local, result,
					problem, typeno);
			if (add == 1) {
				request.getRequestDispatcher("ActionServlet?action=starquery")
						.forward(request, response);
			}
		}
		// 星级用户修改测试表
		else if (action.equals("editstar")) {
			String no = request.getParameter("no");
			String tid = request.getParameter("tid");
			bean.sqlBean sql = new bean.sqlBean();
			if (no.equals("first")) {
				String[][] star = sql.getStar(tid);
				request.setAttribute("tid", tid);
				request.setAttribute("star", star);
				request.getRequestDispatcher("/star/editStar.jsp").forward(
						request, response);
			} else if (no.equals("second")) {
				out.print(".....");
				String time = request.getParameter("time");
				String mobiletype = request.getParameter("mobiletype");
				String ctype = request.getParameter("ctype");
				String local = request.getParameter("local");
				String result = request.getParameter("result");
				String problem = request.getParameter("problem");
				String typeno = request.getParameter("typeno");
				int row = sql.getEditStar(time, mobiletype, ctype, local,
						result, problem, typeno, tid);
				if (row == 1) {
					request.getRequestDispatcher(
							"ActionServlet?action=starquery").forward(request,
							response);
					return;
				}
			}
		}
		// 星级用户删除测试表里测试条
		else if (action.equals("delstar")) {
			String tid = request.getParameter("tid");
			bean.sqlBean sql = new bean.sqlBean();
			int rows = sql.getDelStar(tid);
			if (rows == 1) {
				request.getRequestDispatcher("ActionServlet?action=starquery")
						.forward(request, response);
			}
		}else if(action.equals("queryadm")){
			String no=request.getParameter("no");
			String tang=request.getParameter("tang");
			String[] quan=new String[]{};
			String query=request.getParameter("chaxun");
			String tianjia=request.getParameter("tianjia");
			String edit=request.getParameter("xiugai");
			String del=request.getParameter("shanchu");
			for(int i=0;i<quan.length;i++){
			if(query!=null&&query.equals("y")){
				quan[0]="checked";
			}else if(query!=null&&query.equals("n")){
				quan[1]="checked";
			}
			if(tianjia!=null&&tianjia.equals("y")){
				quan[2]="checked";
			}else if(tianjia!=null&&tianjia.equals("n")){
				quan[3]="checked";
			}
			if(edit!=null&&edit.equals("y")){
				quan[4]="checked";
			}else if(edit!=null&&edit.equals("n")){
				quan[5]="checked";
			}
			if(del!=null&&del.equals("y")){
				quan[6]="checked";
			}else if(del!=null&&del.equals("n")){
				quan[7]="checked";
			}
			}
			bean.sqlBean sql = new bean.sqlBean();
			if(tang.equals("first")){
			String[][] result=sql.getAdm();
			request.setAttribute("result", result);
			request.setAttribute("quan", quan);
			request.getRequestDispatcher("/adm/admlist.jsp").forward(request, response);
			}
			
			if(tang.equals("second")){
			String[][] result=sql.getAdm(no, query, tianjia, edit, del);
			request.setAttribute("result", result);
			request.setAttribute("quan", quan);
			request.getRequestDispatcher("/adm/admlist.jsp").forward(request, response);
		}
	}
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);

	}

	public void init() throws ServletException {
		// Put your code here
	}

}