m_url = m_url.substring(idxPos); // get substring                    Debug.println("after trimed m_url="+m_url);                    int sepPos = m_url.indexOf("::");                    sepPos = (sepPos<0 ? m_url.length() : sepPos);                    String progValue = m_url.substring(0,sepPos);                    String[] value = (new CerpSAM()).getSysAndProgCode(progValue,companyCode);                    String mm_sys_code = value[0];                    String mm_prog_code = value[1];                    // check if it exists already                    sql = "select 1 from sam_user_favor_v "                        + " where company_code='" + companyCode                        + "' and user_unique_no='" + userUniqueNo                        + "' and sys_code='" + mm_sys_code                        + "' and prog_code='" + mm_prog_code+ "'";                    Debug.println(sql);                    ResultSet rs = pageQuery.getData(sql);                    if (rs !=null && rs.next())                    {                        outFlag = "0";                    }else                    {                        sql = "select " + prog_name                            + " from scg_program "                            + " where company_code='" + companyCode                            + "' and sys_code='" + mm_sys_code                            + "' and prog_code='" + mm_prog_code + "'" ;                        Debug.println("mm_sys_code="+mm_sys_code+",mm_prog_code="+mm_prog_code);                        Debug.println(sql);                        rs = pageQuery.getData(sql);                        if (rs != null && rs.next())                        {                            String m_favor_name = rs.getString(1);                            request.setAttribute("m_favor_name",m_favor_name);                            request.setAttribute("mm_sys_code",mm_sys_code);                            request.setAttribute("mm_prog_code",mm_prog_code);                        }else                        {                            outFlag = "0";                        }                    }                }                vct = new Vector();            }            else if (opFlag.equalsIgnoreCase("insert"))            {                // insert                String mm_sys_code = request.getParameter("mm_sys_code");                String mm_prog_code = request.getParameter("mm_prog_code");                String m_favor_name = request.getParameter("m_favor_name");                String favor_type = request.getParameter("favor_type");                Debug.println("mm_sys_code="+mm_sys_code+",mm_prog_code="+mm_prog_code+",m_favor_name="+m_favor_name);                String favor_index = "0";                mm_sys_code = (mm_sys_code==null ? "" : mm_sys_code.trim());                mm_prog_code = (mm_prog_code==null ? "" : mm_prog_code.trim());                favor_type = (favor_type==null ? "" : favor_type.trim());                m_favor_name = (m_favor_name==null ? "" : m_favor_name.trim());                sql = "select 1 from sam_user_favor "                    + " where company_code='" + companyCode                    + "' and user_unique_no='" + userUniqueNo                    + "' and sys_code='" + mm_sys_code                    + "' and prog_code='" + mm_prog_code + "'";                Debug.println("sql=" + sql);                ResultSet rs = pageQuery.getData(sql);                if (rs != null && rs.next())                {                    outFlag = "0";                }else                {                    sql = "insert into sam_user_favor(company_code,user_unique_no,sys_code,prog_code,favor_name_cn,favor_name_en,favor_name_tw,favor_type,favor_index) "                        + " select '" + companyCode + "','" + userUniqueNo + "','"                        + mm_sys_code + "','" + mm_prog_code + "',prog_name_cn,prog_name_en,prog_name_tw,'" + favor_type + "'," + favor_index                        + " from scg_program where company_code='" +companyCode+ "' and sys_code='" + mm_sys_code + "' and prog_code='" + mm_prog_code + "'";                    Debug.println("sql=" + sql);                    boolean bFlag = pageQuery.simpleUpdate(sql);                    if  (bFlag)                    {                        sql = "update sam_user_favor set " + favor_name + "='" + m_favor_name                            + "' where company_code='" + companyCode + "' and user_unique_no='" + userUniqueNo                            + "' and sys_code='" + mm_sys_code + "' and prog_code='" + mm_prog_code + "'";                        Debug.println("sql=" + sql);                        bFlag = pageQuery.simpleUpdate(sql);                        outFlag = (bFlag ? "1" : "0");                    }else                    {                        outFlag = "0";                    }                }                if (outFlag.equals("1"))                {                    // show data                    String strFields =  "sys_code,prog_code," + favor_name + ",favor_type" ;                    String strConditions = null;                    if (condition.length()<1)                    {                        strConditions = " company_code='"+companyCode                            + "' and user_unique_no='"+userUniqueNo                            + "' order by favor_type,favor_index ";                    }else                    {                        strConditions = condition + " and (company_code='"+companyCode                            + "' and user_unique_no='"+userUniqueNo                            + "') order by favor_type,favor_index ";                    }                    String strTables = "sam_user_favor_v";                    pageQuery.getData(strFields,strTables,strConditions,pageSize);                    pageCount = pageQuery.pageCount;                    pageCount = (pageCount < 1 ? 1 : pageCount);                    currentPage = (currentPage > pageCount ? pageCount : currentPage);                    vct = pageQuery.dividePage(currentPage,pageSize);                }else                {                    vct = new Vector();                }            }            else if (opFlag.equalsIgnoreCase("update"))            {                // update                String mm_sys_code = request.getParameter("mm_sys_code");                String mm_prog_code = request.getParameter("mm_prog_code");                String m_favor_name = request.getParameter("m_favor_name");                String favor_type = request.getParameter("favor_type");                mm_sys_code = (mm_sys_code==null ? "" : mm_sys_code.trim());                mm_prog_code = (mm_prog_code==null ? "" : mm_prog_code.trim());                favor_type = (favor_type==null ? "" : favor_type.trim());                m_favor_name = (m_favor_name==null ? "" : m_favor_name.trim());                sql = "update sam_user_favor "                    + " set " + favor_name + "='" + m_favor_name                    + "',favor_type='" + favor_type                    + "' where company_code='" + companyCode                    + "' and user_unique_no='" + userUniqueNo                    + "' and sys_code='" + mm_sys_code                    + "' and prog_code='" + mm_prog_code + "'";                boolean bFlag = pageQuery.simpleUpdate(sql);                outFlag = (bFlag ? "1" : "0");                // show data                String strFields =  "sys_code,prog_code," + favor_name + ",favor_type" ;                String strConditions = null;                if (condition.length()<1)                {                    strConditions = " company_code='"+companyCode                        + "' and user_unique_no='"+userUniqueNo                        + "' order by favor_type,favor_index ";                }else                {                    strConditions = condition + " and (company_code='"+companyCode                        + "' and user_unique_no='"+userUniqueNo                        + "') order by favor_type,favor_index ";                }                String strTables = "sam_user_favor_v";                pageQuery.getData(strFields,strTables,strConditions,pageSize);                pageCount = pageQuery.pageCount;                pageCount = (pageCount < 1 ? 1 : pageCount);                currentPage = (currentPage > pageCount ? pageCount : currentPage);                vct = pageQuery.dividePage(currentPage,pageSize);            }            else // unknown situation            {                vct = new Vector();            }            request.setAttribute("vct",vct);            request.setAttribute("opFlag",opFlag);            request.setAttribute("outFlag",outFlag);            request.setAttribute("pageCount",pageCount+"");            request.setAttribute("currentPage",currentPage+"");            request.setAttribute("selectAll",selectAll);        }        catch(Exception e)        {        }        return null;    }}