public ResultSet excuteQuery() {
    ResultSet resultSet = null;
    String sql = builder.toString();
    clear();
    try {
      resultSet = excutor.excuteQuery(sql);
    } catch (SQLException e) {
      // TODO: handle exception
      System.out.println("SQL语句有问题");
      System.out.println(sql);
      e.printStackTrace();
    }

    return resultSet;
  }
  public boolean excute() {

    String sql = builder.toString();
    clear();
    try {
      excutor.excute(sql);
      return true;
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      System.out.println("SQL语句有问题");
      System.out.println(sql);
      e.printStackTrace();
      return false;
    }
  }
  public static void main(String[] args) {
    SQLBuilder sqlBuilder = new SQLBuilder();
    // sqlBuilder.Select("T.account","T.balance").From("account").AS("T")
    // .Where("Balance").EQUALS(150).AND("Income").EQUALS(200);
    // System.out.println(sqlBuilder.getSQL());
    //
    // sqlBuilder.clear();
    // sqlBuilder.InsertInto("account",
    // "(balance,name,income)").Values("(15,100,'test')");
    // System.out.println(sqlBuilder.getSQL());
    //
    sqlBuilder.clear();
    sqlBuilder.InsertInto("account").Values(15, 100, "test");
    System.out.println(sqlBuilder.getSQL());
    //
    sqlBuilder.clear();
    sqlBuilder
        .Update("account")
        .Set("Name")
        .Assign("账户1")
        .Comma("balance")
        .Assign(12321.5)
        .Where("Income")
        .EQUALS(12345);
    System.out.println(sqlBuilder.getSQL());
    //
    // sqlBuilder.clear();
    // sqlBuilder.Update("account").Set("Name = '账户1'").Comma("balance = 12233")
    // .Where("Income = 12345");
    // System.out.println(sqlBuilder.toString());
    //
    //
    sqlBuilder.clear();
    // sqlBuilder.DeleteFrom("account").Where("Name").EQUALS("账户1");
    // System.out.println(sqlBuilder.getSQL());
    sqlBuilder.handleString("2015-11-01");
    System.out.println(sqlBuilder.getSQL());
    sqlBuilder.clear();
    sqlBuilder.handleString("2015-11-01 22:15:1");
    System.out.println(sqlBuilder.getSQL());
    sqlBuilder.clear();
    Calendar calendar = Calendar.getInstance();
    calendar.set(2015, 11, 11);

    sqlBuilder
        .Select("*")
        .From("stockoutorder")
        .Where("ins_id")
        .EQUALS("00110")
        .AND("time")
        .Between(calendar)
        .AND(calendar);

    System.out.println(sqlBuilder.toString());
    sqlBuilder.clear();

    sqlBuilder
        .InsertInto(
            PaymentListTable.tableName,
            PaymentListTable.paymentListID_col,
            PaymentListTable.total_col,
            PaymentListTable.payer_col,
            PaymentListTable.date_col,
            PaymentListTable.passed_col)
        .Values("11111", 50.3, "小春", Calendar.getInstance(), 0);
    System.out.println(sqlBuilder.toString());

    sqlBuilder.clear();
    sqlBuilder
        .Select("*")
        .From("billorder")
        .Where("time")
        .EQUALS("2015-11-26")
        .AND("order_id")
        .LIKE("0010001%");
    System.out.println(sqlBuilder);
    sqlBuilder.clear();
  }