getsqlstring.java

农业银行ATM对帐查询系统后台类包的源代码,实现了FTP,数据库管理等等功能

package boco.transmonitor.tranmonitor;

//******************************************************************************
//:功能:据输入的数据参数,返回相应的SQL语句
//:时间:2002-07
//:作者:王建宾
//:特殊描述::test:为DEBUG时启用
//:程序描述:
//     返回条件查询的SQL语句:区分数字型与非数字型数据
//******************************************************************************

import java.util.*;
import java.sql.*;

public class getSQLstring {
  //定义变量
  int i,len;
  String sql;
  String tmpSql;
  ChineseTransfer C2A = new ChineseTransfer();
  //构造函数，初始化变量
  public getSQLstring() {
    sql="";
    tmpSql="";
    i = 0;
    len = 0;
  }
  //查询选中业务种类SQL语句
  public String getQueryString(Vector Con){
    String FieldValue="";
    sql="Select uaoptrnno,trancode,accnum1,trnamt,retcode,tpetrndate,tpetrntime,tpetrnno,vchno,procode,branch,accnum2,revresult,revjrnno,revvchno,trntype,reqid,reqtype,tradetype from transdetect";
    tmpSql = "";
    String tSql = " order by transid desc ";
    len = Con.size();
    //返回查询所有业务的SQL语句
    if(len==0){
      sql = sql + " " + "order by transid desc ";
    }
    //返回查询相关业务的SQL语句
    else{
      for(i=0;i<len;i++)
      {
        FieldValue = Con.elementAt(i).toString().trim();
        //处理最后一个值
        if(i == len-1){
          tmpSql = tmpSql + " tradetype = " + "'" + FieldValue + "'";
        }
        else{
          tmpSql = tmpSql + "tradetype = " + "'" + FieldValue + "'" + " or ";
        }
      }
      sql = sql + " where " + tmpSql + tSql;
    }
     //:test:System.out.println("query SQL:"+sql);
     return sql;
  }

    //测试主程序
    public static void main(String[] args){
      getSQLstring ql = new getSQLstring();
      Vector FName = new Vector();
      //FName.addElement("aaaa");
      //FName.addElement("bbbb");
      //FName.addElement("cccc");
      //FName.addElement("dddd");
      //FName.addElement("eeee");
      String sql=ql.getQueryString(FName);
      System.out.println("mySql:"+sql);
    }
}