getformbean.java

this is jave package for system parament

package com.talent.publics;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.transaction.UserTransaction;

public class GetFormBean extends HttpServlet{

  public GetFormBean() {
  }
  public String getUpdateSql(HttpServletRequest request){
    String name     = "";
    String value    = "";
    String whereId  = "";
    String sql      = "";
    try{
      Enumeration enumeration=request.getParameterNames();
      while(enumeration.hasMoreElements()){
        name=(String)enumeration.nextElement();
        if (name.substring(0,5).equals("where")){
          whereId = request.getParameter(name);
        }
        if(!name.startsWith("NO_")&&!name.substring(0,5).equals("where")){
          if (!name.substring((name.length()-4),name.length()).equals("date")){
            value="'"+request.getParameter(name)+"'";
          }else{
            value="to_date('"+request.getParameter(name)+"','yyyy-mm-dd')";
          }
          sql = sql + name + "=" + value + ",";
        }
      }
    }catch(Exception e){
    }
    sql = "UPDATE ||tableName|| SET " + sql.substring(0,sql.length()-1) + "  WHERE  ||whereId|| = " + whereId;
    return sql;
  }

  public String getInsertSql(HttpServletRequest request){
    String name     = "";
    String value    = "";
    String sqlName  = "INSERT INTO ||tableName|| ( ";
    String sqlValue = " ) VALUES ( ";
    String sql      = "";
    try{
      Enumeration enumeration=request.getParameterNames();
      while(enumeration.hasMoreElements()){
        name=(String)enumeration.nextElement();
        if(!name.startsWith("NO_")){
          if(name.substring(name.length()-4,name.length()).equals("date")){
            value="to_date('"+request.getParameter(name)+"','yyyy-mm-dd')";
          }else{
            value="'"+request.getParameter(name)+"'";
          }
System.out.println("name====="+name);
System.out.println("value====="+value);
        sqlName  = sqlName + name +",";
        sqlValue = sqlValue + value +",";
        }
      }
    }catch(Exception e){
    }
    sql = sqlName+"||insertId||" + sqlValue +"||insertIdValue||)";
    return sql;
  }
}