sam0040handler.java

哈工大CERP系统Java源码及开发说明.rar 内容十分详尽

                }else
                {
                    sql = "insert into scg_db_config(company_code,sys_code,"
                      + "year,os_code,db_type_code,db_code,db_name,"
                      + "driver_manager,db_url,db_user,db_pass) values('"
                      + companyCode + "','" + sys_code + "','" + year + "','"
                      + os_code + "','" + db_type_code + "','" + db_code
                      + "','" + db_name + "','" + driver_manager + "','"
                      + db_url + "','" + db_user + "','" + db_pass + "')";

                    if (!pageQuery.simpleUpdate(sql))
                      outFlag = "0" ;
                }

                if (opFlag.equals("insert"))
                {
                  pageQuery.getData(strFields,strTables,strConditions,
                    pageSize);
                  pageCount = pageQuery.pageCount ;
                  currentPage =
                    (currentPage>pageCount ? pageCount : currentPage);
                    vct = pageQuery.dividePage(currentPage,pageSize);
                }
            }
            else if (opFlag.equals("modify"))
            {
              String sys_code= request.getParameter("sys_code");
              String year = request.getParameter("year");

              sys_code = Show.getString(sys_code);
              year = Show.getString(year);

              if (sys_code.length()>0 && year.length()>0)
              {
                strFields = "sys_code,year,db_code,db_name,os_code,"
                  + "db_type_code,driver_manager,db_url,db_user,db_pass";

                strTables = "scg_db_config";

                strConditions = "company_code='" + companyCode
                  + "' and sys_code='" + sys_code
                  + "' and year='" + year + "'";

                pageQuery.getData(strFields,strTables,strConditions,1);
                vct = pageQuery.dividePage(1);

              }

              Vector osVct = null;
              Vector dbVct = null;
              Vector drVct = null;

              int vctSize = 100 ;
              pageQuery.getData("os_code,os_name","scg_os_type"
                ,"1=1 order by os_code",vctSize);

              osVct = pageQuery.dividePage(1);

              pageQuery.getData("db_type_code,db_type_name","scg_db_type",
                "1=1 order by db_type_code",vctSize);

              dbVct = pageQuery.dividePage(1);

              pageQuery.getData("driver_manager",
                "scg_driver_manager",
                "1=1 order by driver_manager",vctSize);

              drVct = pageQuery.dividePage(1);

              request.setAttribute("osVct",osVct);
              request.setAttribute("dbVct",dbVct);
              request.setAttribute("drVct",drVct);

            }
            else if (opFlag.equals("update") || opFlag.equals("updMore")) //更新
            {
                String sys_code= request.getParameter("sys_code");
                String year = request.getParameter("year");
                String os_code = request.getParameter("os_code");
                String db_type_code = request.getParameter("db_type_code");
                String db_code = request.getParameter("db_code");
                String db_name = request.getParameter("db_name");
                String driver_manager = request.getParameter("driver_manager");
                String db_url = request.getParameter("db_url");
                String db_user=request.getParameter("db_user");
                String db_pass=request.getParameter("db_pass");

                sys_code = Show.getString(sys_code);
                year = Show.getString(year);
                os_code = Show.getString(os_code);
                db_type_code = Show.getString(db_type_code);
                db_code = Show.getString(db_code);
                db_name = Show.getString(db_name);
                driver_manager = Show.getString(driver_manager);
                db_url = Show.getString(db_url);
                db_user = Show.getString(db_user);
                db_pass = Show.getString(db_pass);
                db_pass = cerp_crypt.get_encoded_pass(db_pass);

                if (sys_code.length()<1 || year.length()<1 )
                {
                    outFlag = "0" ;
                }else
                {
                    sql = "update scg_db_config "
                      + " set os_code='" + os_code
                      + "',db_type_code='" + db_type_code
                      + "',db_code='" + db_code
                      + "',db_name='" + db_name
                      + "',driver_manager='" + driver_manager
                      + "',db_url='" + db_url
                      + "',db_user='" + db_user
                      + "',db_pass='" + db_pass + "' "
                      + " where company_code='" + companyCode
                      + "' and sys_code='" + sys_code
                      + "' and year='" + year + "'" ;

                    if (!pageQuery.simpleUpdate(sql))
                      outFlag = "0" ;
                }

                if (opFlag.equals("update"))
                {
                  pageQuery.getData(strFields,strTables,strConditions,
                    pageSize);
                  pageCount = pageQuery.pageCount ;
                  currentPage = (currentPage>pageCount?pageCount : currentPage);
                  vct = pageQuery.dividePage(currentPage,pageSize);
                }
            }
            else if (opFlag.equals("delete")) //删除
            {
                String sys_code= request.getParameter("sys_code");
                String year = request.getParameter("year");

                sys_code = (sys_code==null ? "" : sys_code.trim());
                year = (year==null ? "" : year.trim());

                if (sys_code.length()>0 && year.length()>0)
                {
                    sql = "delete from scg_db_config "
                          + " where company_code='" + companyCode
                          + "' and sys_code='" + sys_code
                          + "' and year='" + year + "'" ;

                    pageQuery.simpleUpdate(sql);
                }

                //query
                pageQuery.getData(strFields,strTables,strConditions,pageSize);
                pageCount = pageQuery.pageCount ;
                currentPage = (currentPage>pageCount ? pageCount : currentPage);
                vct = pageQuery.dividePage(currentPage,pageSize);
            }
            else if (opFlag.equals("query")) //查询
            {
                pageQuery.getData(strFields,strTables,strConditions,pageSize);
                pageCount = pageQuery.pageCount ;
                currentPage = (currentPage>pageCount ? pageCount : currentPage);
                vct = pageQuery.dividePage(currentPage,pageSize);
            }
            else //刚进入
            {
                //do nothing
                pageCount = 0 ;
                currentPage = 0 ;
            }

            //取得系统代码和名称
            int sysSize = 100; //子系统数目
            sql = "company_code='" + companyCode + "'" ;
            pageQuery.getData("sys_code,sys_name","scg_system",sql,sysSize);
            sysVct = pageQuery.dividePage(1,sysSize);
        }
        catch (Exception e)
        {
            e.printStackTrace();
            outFlag = "0" ;
        }

        vct = (vct==null ? new Vector() : vct);
        sysVct = (sysVct==null ? new Vector() : sysVct);

        request.setAttribute("sysVct",sysVct);
        request.setAttribute("vct",vct);
        request.setAttribute("outFlag",outFlag);
        request.setAttribute("opFlag",opFlag);
        request.setAttribute("querySysCode",querySysCode);
        request.setAttribute("queryType",queryType);
        request.setAttribute("queryValue",queryValue);
        request.setAttribute("currentPage",currentPage+"");
        request.setAttribute("pageCount",pageCount+"");

        Debug.println("process handler over,outFlag="+outFlag);
        return null;
    }
}