parameterservlet.java

this is java package for system parament

package com.talent.system.parameter;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.rmi.*;
import javax.sql.*;
import javax.ejb.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.transaction.UserTransaction;
import sun.jdbc.rowset.*;
import com.talent.publics.GetFormBean;
import com.talent.publics.GetSqlBean;

public class ParameterServlet extends HttpServlet {
  static final private String CONTENT_TYPE = "text/html; charset=GBK";
  //Initialize global variables
  public void init() throws ServletException {
  }
  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doPost(request,response);
  }
  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String         key            = request.getParameter("NO_key");
    String         flag           = request.getParameter("NO_flag");;
    String         supId          = request.getParameter("supid");;
    String         sql            = "";
    String         id             = "";
    String         targetJsp      = "";
    Hashtable      env            = new Hashtable();
    Context        context        = null;
    ParameterHome  parameterHome  = null;
    Parameter      parameter      = null;
    boolean        result         = false;
    ResultSet      resultSet      = null;
    ServletContext servletContext = getServletContext();
    GetFormBean    getFormBean    = new GetFormBean();
    try{
      context       = new InitialContext(env);
      Object obj    = context.lookup("Parameter");
      parameterHome = (ParameterHome)PortableRemoteObject.narrow(obj,ParameterHome.class);
      parameter     = parameterHome.create();
    }catch(Exception e){
      System.out.println("EJB连接错");
    }
System.out.println("key========="+key);
//插入
    if (key.equals("insert")){
      try{
        sql = getFormBean.getInsertSql(request);
System.out.println("departsql============"+sql);
System.out.println("supid========="+supId);
        result = parameter.parameterInsert(sql,supId);
       if (result){
         resultSet = parameter.parameterSelect("INSERT");
         request.setAttribute("SelectResult",resultSet);
         RequestDispatcher dispatcher = request.getRequestDispatcher("./jsp/parameter/parameterlist.jsp");
         dispatcher.forward(request, response);
       }else{
         RequestDispatcher dispatcher = request.getRequestDispatcher("./error/error.jsp?key='0001'");
         dispatcher.forward(request, response);
       }
      }catch(Exception ex){
        System.out.println("插入数据操作错！");
      }
    }
//修改记录
    if (key.equals("update")){
    try{
      sql = getFormBean.getUpdateSql(request);
System.out.println("sql==========="+sql);
      id = request.getParameter("wheresystemid");
System.out.println("id======"+id);
      result = parameter.parameterUpdate(sql);
      System.out.println("888888888888");
      if (result){
        resultSet = parameter.parameterSelect("SYSTEMID ='"+id+"'");
        request.setAttribute("SelectResult",resultSet);
        RequestDispatcher dispatcher = request.getRequestDispatcher("./jsp/parameter/parameterlist.jsp");
        dispatcher.forward(request, response);
      }else{
        RequestDispatcher dispatcher = request.getRequestDispatcher("./error/error.jsp?key='0002'");
        dispatcher.forward(request, response);
      }
    }catch(Exception ex){
      System.out.println("修改记录操作错！");
    }
  }
//查询记录
    if (key.equals("select")){
      try{
        if (flag.equals("all")){
          resultSet = parameter.parameterSelect("");
          targetJsp = "./jsp/parameter/parameterlist.jsp";
        }else if (flag.equals("display")){
          id = request.getParameter("wheresystemid");
          resultSet = parameter.parameterSelect("SYSTEMID ='"+id+"'");
          targetJsp = "./jsp/parameter/parameterdisplay.jsp";
        }else if (flag.equals("update")){
          id = request.getParameter("wheresystemid");
          resultSet = parameter.parameterSelect("SYSTEMID ='"+id+"'");
          targetJsp = "./jsp/parameter/parameterupdate.jsp";
        }else if (flag.equals("select")){
          String condition = request.getParameter("condition");
          String content   = request.getParameter("content");
          resultSet = parameter.parameterSelect(condition+" like '%"+content+"%'");
          targetJsp = "./jsp/parameter/parameterlist.jsp";
        }
        if (resultSet != null){
          request.setAttribute("SelectResult",resultSet);
          RequestDispatcher dispatcher = request.getRequestDispatcher(targetJsp);
          dispatcher.forward(request, response);
        }else{
          RequestDispatcher dispatcher = request.getRequestDispatcher("./error/error.jsp?key='0004'");
          dispatcher.forward(request, response);
        }
      }catch(Exception ex){
        System.out.println("查询记录操作错！");
      }
    }
//删除记录
    if (key.equals("delete")){
      try{
        id = request.getParameter("wheresystemid");
        result = parameter.parameterDelete("'"+id+"'");
        resultSet = parameter.parameterSelect("");
        if (resultSet != null){
          request.setAttribute("SelectResult",resultSet);
          RequestDispatcher dispatcher = request.getRequestDispatcher("./jsp/parameter/parameterlist.jsp");
          dispatcher.forward(request, response);
        }else{
          RequestDispatcher dispatcher = request.getRequestDispatcher("./error/error.jsp?key='0003'");
          dispatcher.forward(request, response);
        }
      }catch(Exception ex){
      }
    }
  }
//Clean up resources
  public void destroy() {
  }
}