/** 检查数据库中是否只剩下一条此类型的图片数据信息 true--只剩下一条,false--不只有一条 */
  public boolean onlyOne(LEDPicSchema tLEDPicSchema) {
    ExeSQL mExeSQL = new ExeSQL();
    String sql = "select * from ledpic where typecode= ? ";
    String[] param1 = {"String", tLEDPicSchema.getTypecode()};
    ArrayList<String[]> sqlParamList = new ArrayList<String[]>();
    sqlParamList.add(param1);

    SSRS tSSRS = mExeSQL.execSQL(sql, sqlParamList);
    if (tSSRS == null || tSSRS.MaxRow <= 1) {
      return true;
    }
    return false;
  }
  /**
   * 新增图片信息
   *
   * @param LEDPicSchema
   * @return boolean
   */
  public boolean add(LEDPicSchema tLEDPicSchema) {
    ExeSQL mExeSQL = new ExeSQL();
    StringBuffer sqlbuf = new StringBuffer();
    sqlbuf.append("insert into ledpic values(");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?,");
    sqlbuf.append("?)");

    ArrayList<String[]> list = new ArrayList<String[]>();
    String[] arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getPicCode();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getName();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getTypecode();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getUseFlag();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getField1();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getField2();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getField3();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getMakeDate();
    list.add(arr);

    arr = new String[2];
    arr[0] = "String";
    arr[1] = tLEDPicSchema.getMakeTime();
    list.add(arr);

    if (!mExeSQL.execUpdateSQL(sqlbuf.toString(), list)) {
      System.out.println("图片保存过程出现错误!");
      return false;
    }
    System.out.println("图片保存成功!");
    return true;
  }