requestcategory.java

provide a room booking system

/*
 * RequestCategory.java
 *
 * Created on January 26, 2007, 2:40 PM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package Wearnes;

/**
 *
 * @author dongliang.guo
 */
import java.util.*;
public class RequestCategory {
    public String category="";
    public String description="";
    public String item="";
    public String refLink="";
    public String estimateCost="";
    public String defaultAcctMgr="";
    
    
    /** Creates a new instance of RequestCategory */
    public RequestCategory() {
    }
    public static String getDefaultAccountManager(String category)
    {
        String actMgr="Melody.Shieh";
        try{
         String sql="select accountManager from requestCategory where category='"+category.trim()+"'";
         WearnesDB db=new WearnesDB((new CommonUtility()).getConnectionURL());
         java.sql.ResultSet rs=db.select(sql);
         if(rs.next())
         {
             actMgr=rs.getString("accountManager");
         }
         }catch(Exception e)
         {
         }
        return actMgr;
    }
     public static String getDefaultEngineer(String category)
    {
        String engineer="";
        try{
         String sql="select engineer from requestCategory where category='"+category.trim()+"'";
         WearnesDB db=new WearnesDB((new CommonUtility()).getConnectionURL());
         java.sql.ResultSet rs=db.select(sql);
         if(rs.next())
         {
             engineer=rs.getString("engineer");
         }
         }catch(Exception e)
         {
         }
        return engineer;
    }
    public static Vector getAllCategory()
    {
        Vector arr=new Vector();
        
        
        try{
         String sql="select * from requestCategory";
         WearnesDB db=new WearnesDB((new CommonUtility()).getConnectionURL());
         java.sql.ResultSet rs=db.select(sql);
         String tmp="";
         while(rs.next())
         {
             tmp=rs.getString("category");
             arr.add(tmp);
         }
         }catch(Exception e)
         {
              arr.add("wrong");
         }
        
        return arr;
    }
    
}