dicservlet.java

为实现简单的单词在线字典功能.基本的数据单词录入,删除,自定义.

/*
 * Created on Apr 9, 2008
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.test;

import java.io.IOException;
import java.sql.ResultSet;

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

import db.DBcon;

public class DicServlet extends HttpServlet {
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	DBcon con;
	public void init() throws ServletException {
		con=new DBcon();
	}
	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
        request.setCharacterEncoding("gbk");
		//response.setContentType("text/html;charset=gbk");
		
		String Com; // Command
		String word; 
		String def; 
		boolean success = false;
		
		ResultSet rs=null;
		String address="result.jsp";
		
		// Execute action requested
		Com = request.getParameter("Com");
		word = request.getParameter("word");
		def = request.getParameter("def");
		
		if (Com.equals("Emp")){
			success=con.Emp();
		}else if (Com.equals("Ins")){
			success=con.Ins(word, def);
		}else if (Com.equals("Rem")){
			success=con.Rem(word);
		}else if (Com.equals("Lookup")){
			rs=con.getRsByWord(word);
			request.setAttribute("rs", rs);
			address="display.jsp";
		}else{
			rs=con.getRsAll();
			request.setAttribute("rs", rs);
			address="display.jsp";
		}
		
		request.setAttribute("success", success);
		
		RequestDispatcher rd =request.getRequestDispatcher(address);
		rd.forward(request, response);
		
		
	}
	
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		con.closeBean();
	}

}