The Weird and The Wonderful

Select field1,field2,field3
From table1
Where type="EDU"

If(field1=cond1 and field2=con4 and Active=true)
 do something
else If(field1=cond1 and field2=con2 and Active=true)
do something
else If(field3=cond10 and field2=con2 and Active=true)
do something else

Select field1,field2,field3
From table1
Where type="EDU" AND Active=True

tecgoblin wrote:

It's surprising how many people try to create their own solutions to problems which already have established and well-behaving solution :S.

public class DBConst {
  public static String SELECT = "SELECT";
  public static String WHERE = "WHERE";
  public static String AND = "AND"
  etc
}

public interface SQLFactory {
  public String createSQL(String[] selectors, String[] whereClauses);
}

public interface MyTable {
  public static String TABLE_NAME = "MyTable";
  public static String COL_1 = "Col1";
  public static String COL_2 = "Col2";
}

public class MyTableDao {
  public MyObject selectObject(String selector) {
    // list the columns to select
    String[] columns = {MyTable.COL_1, MyTable.COL_2);
    Object[] types = {DbTypes.DATE, DbTypes.INTEGER};

    // list the selector(s) for the statement "WHERE COL_1 = ?"
    String[] whereClause = {MyTable.COL_1};
    Object[] whereValues = {selector};

    MySqlFactory sqlFactory = new MySqlFactory();
    String sql = sqlFactory.createSql(columns, whereClause);

    PreparedStatement ps = connect.prepareStatement(sql)

    // this might have been a generic utility actually. Overridden 
    // for complex requirements maybe?
    MySqlInjector.injectValues(ps, new Object[] {selector});

    // get the resulting data and create objects from it
    ResultSet rs = stmt.executeQuery(query);
    MyObject[] objs = MyObjectFactory.getObjects(rs, columns, types);

}

sb.append(DbConsts.SELECT).append(" ").append(COL).append(,) ...

if(type[0]==DbTypes.INTEGER) rs.getInt(); // or whatever

sb.append(DbConsts.WHERE).append(" ").append(clauses[0]...