zscom_func.java

实现oracle查询数据集分页

            if(str.charAt(i) < '0' || str.charAt(i) > '9')
            {
              JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的经度度数值错误", null, JOptionPane.INFORMATION_MESSAGE);
              return "";
            }
          }
          strLongigude = str;
        }

        int nLongitude = StringToInt(strLongigude);
        if(nLongitude < 60 || nLongitude > 180)
        {
          showWarningMessageDlg("您输入的经度值太大", "错误报告");
          return "";
        }

        if(str.charAt(0) != 'e' && str.charAt(0) != 'E')
        {
          String strTmp = "E" + str;
          str = strTmp;
        }
        else if(str.charAt(0) == 'e')
        {
          str = str.replace('e', 'E');
        }

        return str;
      }

      // 获取纬度度数值
      public static String getLatitudeDegree(String str)
      {
        int nLen = str.length();
        int i;
        String strLatitude;

        if(nLen < 2 || ((str.charAt(0) == 'n' || str.charAt(0) == 'N') && nLen < 3))
        {
          JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的纬度度数值错误", null, JOptionPane.INFORMATION_MESSAGE);
          return "";
        }

        if(str.charAt(0) == 'n' || str.charAt(0) == 'N')
        {
          for(i=1; i<nLen; i++)
          {

            if(str.charAt(i) < '0' || str.charAt(i) > '9')
            {
              JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的纬度度数值错误", null, JOptionPane.INFORMATION_MESSAGE);
              return "";
            }
          }
          strLatitude = str.substring(1);
        }
        else
        {
          for(i=0; i<nLen; i++)
          {
            if(str.charAt(i) < '0' || str.charAt(i) > '9')
            {
              JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的纬度度数值错误", null, JOptionPane.INFORMATION_MESSAGE);
              return "";
            }
          }
          strLatitude = str;
        }

        int nLatitude = StringToInt(strLatitude);
        if(nLatitude < 10 || nLatitude > 80)
        {
          showWarningMessageDlg("您输入的纬度值太大", "错误报告");
          return "";
        }

          if(str.charAt(0) != 'n' && str.charAt(0) != 'N')
          {
            String strTmp = "N" + str;
            str = strTmp;
          }
          else if(str.charAt(0) == 'n')
          {
            str = str.replace('n', 'N');
          }

        return str;
      }

      // 获取经度或纬度的分数值
      public static String getMinute(String str)
      {
        int nLen = str.length();

        if(nLen == 0)
        {
          JOptionPane.showMessageDialog(C_Parent_Frame, "您忘记输入分数值", null, JOptionPane.INFORMATION_MESSAGE);
          return "";
        }

        for(int i=0; i<nLen; i++)
        {
          if(str.charAt(i) < '0' || str.charAt(i) > '9')
          {
            JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的分数值有错", null, JOptionPane.INFORMATION_MESSAGE);
            return "";
          }
        }

        if(StringToInt(str) > 60)
        {

          showErrorMessageDlg("您输入的分数值太大(范围应在：00-60)", "错误报告");
          return "";
        }

        if(nLen == 1)
        {
          String strTmp = "0" + str;
          str = strTmp;
        }

        return str;
      }

      // 获取经度或纬度的秒数值
      public static String getSecond(String str)
      {
        int nLen = str.length();
        boolean bError = false;

        if(nLen == 0)
        {
          JOptionPane.showMessageDialog(C_Parent_Frame, "您忘记输入秒数值", null, JOptionPane.INFORMATION_MESSAGE);
        }

        for(int i=0; i<nLen; i++)
        {
          if(str.charAt(i) < '0' || str.charAt(i) > '9')
          {
            JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的秒数值有错", null, JOptionPane.INFORMATION_MESSAGE);
            bError = true;
            break;
          }
        }

        if(StringToInt(str) > 60)
        {
          showErrorMessageDlg("您输入的秒数值太大(范围应在：00-60)", "错误报告");
          return "";
        }

        if(bError)
        {
          str = "";
        }
        else if(nLen == 1)
        {
          String strTmp = "0" + str;
          str = strTmp;
        }

        return str;
      }

      // 获取经度或纬度的秒数值
      public static String getCentiSecond(String str)
      {
        int nLen = str.length();
        boolean bError = false;

        if(nLen == 0)
        {
          JOptionPane.showMessageDialog(C_Parent_Frame, "您忘记输入百分之一秒数值", null, JOptionPane.INFORMATION_MESSAGE);
        }

        for(int i=0; i<nLen; i++)
        {
          if(str.charAt(i) < '0' || str.charAt(i) > '9')
          {
            JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的百分之一秒数值有错", null, JOptionPane.INFORMATION_MESSAGE);
            bError = true;
            break;
          }
        }

        if(StringToInt(str) > 99)
        {
          bError = true;
          showErrorMessageDlg("您输入的百分之一秒数值太大(范围应在：00-99)", "错误报告");
        }

        if(bError)
        {
          str = "";
        }
        else if(nLen == 1)
        {
          String strTmp = "0" + str;
          str = strTmp;
        }

        return str;
      }

      /** 验证输入的是否是整数*/
      public static boolean  checkIntValue(String str)
      {
        int nStrLen = str.length();

        for(int i=0; i<nStrLen; i++)
        {
          if((str.charAt(i) < '0' || str.charAt(i) > '9') && (str.charAt(i) != ','))
          {
            showErrorMessageDlg("在该输入数字的地方,您输入了"+str, "错误提示");
            return false;
          }
        }

        return true;
      }

      /** 验证输入的是否是实数*/
      public static  boolean checkDoubleValue(String str)
      {
        int nStrLen = str.length();
        for(int i=0; i<nStrLen; i++)
        {
          if(str.charAt(i) != '.' && (str.charAt(i) < '0' || str.charAt(i) > '9'))
          {
            showErrorMessageDlg("在该输入数字的地方,您输入了"+str, "错误提示");
            return false;
          }
        }

        return true;
      }


      /**判断输入的是否是整数值*/
      public static String getInt(String str)
      {
        int nStrLen = str.length();
        for(int i=0; i<nStrLen; i++)
        {
          if(str.charAt(i) < '0' || str.charAt(i) > '9')
          {
            JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的值有错");
            return "";
          }
        }

        return str;
      }
/**数据类型转换*/
      public static String getDouble(String str)
      {
        int nStrLen = str.length();
        for(int i=0; i<nStrLen; i++)
        {
          if(str.charAt(i) != '.' && (str.charAt(i) < '0' || str.charAt(i) > '9'))
          {
            JOptionPane.showMessageDialog(C_Parent_Frame, "您数据的值有错");
            return "";
          }
        }

        return str;
      }


/**显示窗体*/
      public static void showDlg(JDialog dlg, Dimension dim)
      {
        dlg.setSize(dim);
        Dimension dimDlg = dlg.getSize();
        Dimension dimScreen = Toolkit.getDefaultToolkit().getScreenSize();
        dlg.setLocation((dimScreen.width - dimDlg.width)/2, (dimScreen.height - dimDlg.height)/2);
        dlg.setModal(true);
        dlg.show();
      }
      /*xyy add 非模式对话框 20040401*/
      public static void showNotModalDlg(JDialog dlg, int nWidth, int nHeight)
      {
        dlg.setSize(nWidth, nHeight);
        Dimension dimDlg = dlg.getSize();
        Dimension dimScreen = Toolkit.getDefaultToolkit().getScreenSize();
        dlg.setLocation((dimScreen.width - dimDlg.width)/2, (dimScreen.height - dimDlg.height)/2);
        dlg.setModal(false);
        dlg.show();

      }


      public static void showDlg(JDialog dlg, int nWidth, int nHeight)
      {
        dlg.setSize(nWidth, nHeight);
        Dimension dimDlg = dlg.getSize();
        Dimension dimScreen = Toolkit.getDefaultToolkit().getScreenSize();
        dlg.setLocation((dimScreen.width - dimDlg.width)/2, (dimScreen.height - dimDlg.height)/2);
        dlg.setModal(true);
        dlg.show();
      }

      public static void showMINDlg(JDialog dlg, int nWidth, int nHeight)
      {
        dlg.setSize(nWidth, nHeight);
        Dimension dimDlg = dlg.getSize();
        Dimension dimScreen = Toolkit.getDefaultToolkit().getScreenSize();
        dlg.setLocation((dimScreen.width - dimDlg.width)/2, (dimScreen.height - dimDlg.height)/2);
        dlg.show();
      }

      public static String getAngle(String str)
      {
        int nStrLen = str.length();
        for(int i=0; i<nStrLen; i++)
        {
          if((str.charAt(i) < '0' || str.charAt(i) > '9') && (str.charAt(i) != '.' || str.charAt(i) != '-'))
          {
            JOptionPane.showMessageDialog(C_Parent_Frame, "您输入的值有错");
            return "";
          }
        }

        return str;
      }

      // 显示经度值(文本域)
      public static void showLongitude(JTextField textField0, JTextField textField1, JTextField textField2, JTextField textField3, String str)
      {
        if(str.length() == 10)
        {
          textField0.setText(str.substring(0, 4));
          textField1.setText(str.substring(4, 6));
          textField2.setText(str.substring(6, 8));
          textField3.setText(str.substring(8, 10));
        }
        else if(str.length() == 9)
        {
          textField0.setText(str.substring(0, 3));
          textField1.setText(str.substring(3, 5));
          textField2.setText(str.substring(5, 7));
          textField3.setText(str.substring(7, 9));
        }
        else
        {
          textField0.setText("");
          textField1.setText("");
          textField2.setText("");
          textField3.setText("");
        }
      }

      // 显示经度值(db文本域)
      public static void showLongitude(JdbTextField textField0, JdbTextField textField1, JdbTextField textField2, JdbTextField textField3, String str)
      {
        if(str.length() == 10)
        {
          textField0.setText(str.substring(0, 4));
          textField1.setText(str.substring(4, 6));
          textField2.setText(str.substring(6, 8));
          textField3.setText(str.substring(8, 10));
        }
        else if(str.length() == 9)
        {
          textField0.setText(str.substring(0, 3));
          textField1.setText(str.substring(3, 5));
          textField2.setText(str.substring(5, 7));
          textField3.setText(str.substring(7, 9));
        }
        else
        {
          textField0.setText("");
          textField1.setText("");
          textField2.setText("");
          textField3.setText("");
        }
      }

      // 显示纬度值(文本域)
      public static void showLatitude(JTextField textField0, JTextField textField1, JTextField textField2, JTextField textField3, String str)
      {
        if(str.length() == 9)
        {
          textField0.setText(str.substring(0, 3));
          textField1.setText(str.substring(3, 5));
          textField2.setText(str.substring(5, 7));
          textField3.setText(str.substring(7, 9));
        }
        else
        {
          textField0.setText("");
          textField1.setText("");
          textField2.setText("");
          textField3.setText("");
        }
      }

      // 显示纬度值(db文本域)
      public static void showLatitude(JdbTextField textField0, JdbTextField textField1, JdbTextField textField2, JdbTextField textField3, String str)
      {
        if(str.length() == 9)
        {
          textField0.setText(str.substring(0, 3));
          textField1.setText(str.substring(3, 5));
          textField2.setText(str.substring(5, 7));
          textField3.setText(str.substring(7, 9));
        }
        else
        {
          textField0.setText("");
          textField1.setText("");
          textField2.setText("");
          textField3.setText("");
        }
      }


      public static String getLogitude(String strD, String strM, String strS, String strCentiS)
      {
        if(strD.equals("") || strM.equals("") || strS.equals("") || strCentiS.equals(""))
        {
          return "";
        }

        String strRslt =
            getLongitudeDegree(strD.trim()) +
            getMinute(strM.trim()) +
            getSecond(strS.trim()) +
            getCentiSecond(strCentiS.trim());

        if(strRslt.length() < 9)
        {
          return "";
        }