public static SQL New(String sql, Class returnClass) { return new SQL(sql, returnClass); } }
public static SQL New(String sql) { return new SQL(sql); }
// Anonymous inner class public String deletePersonSql() { return new SQL() {{ DELETE_FROM("USER"); WHERE("ID = ${id}"); }}.toString(); } // Builder / Fluent style public String insertPersonSql() { String sql = new SQL() .INSERT_INTO("USER"); .VALUES("ID, FIRST_NAME", "${id}, ${firstName}") .VALUES("LAST_NAME", "${lastName}") .toString(); return sql; }
@SelectProvider(type = UserSqlBuilder.class, method = "buildGetUsersByName") List<User> getUsersByName(String name); class UserSqlBuilder { public String buildGetUsersByName(final String name) { return new SQL(){{ SELECT("*"); FROM("users"); if (name != null) { WHERE("name like #{value} || '%'"); } ORDER_BY("id"); }}.toString(); } }
@SelectProvider(type = UserSqlBuilder.class, method = "buildGetUsersByName") List<User> getUsersByName( @Param("name") String name, @Param("orderByColumn") String orderByColumn); class UserSqlBuilder { // If not use @Param, you should be define same arguments with mapper method public String buildGetUsersByName( final String name, final String orderByColumn) { return new SQL(){{ SELECT("*"); FROM("users"); WHERE("name like #{name} || '%'"); ORDER_BY(orderByColumn); }}.toString(); } // If use @Param, you can define only arguments to be used public String buildGetUsersByName(@Param("orderByColumn") final String orderByColumn) { return new SQL(){{ SELECT("*"); FROM("users"); WHERE("name like #{name} || '%'"); ORDER_BY(orderByColumn); }}.toString(); } }
if ((rect != null) && (ell != null)) { con.add(new Connection(rect,ell)); System.out.println("Size of ArrayList <Connection> is:" + con.size()); SQL sql = new SQL(); sql.display(con); }
public static void main(String[] args) { SQL sql = new SQL(); try{ sql.getData();//Error here "Unreported exception Exception; must be caught or declared to be thrown" }catch(Exception e){ e.printStackTrace(); } }
SQL sql = new SQL(); if(sql.tableExists("myTableName")){ // Table Exists! }else{ // Table doesn't exist. }
Database database = new Database(new SQL("host", "port","database", "username","password")); List<tStd_M_lt> bases = database.select(tStd_M_lt.class, new Where(tStd_M_lt.FIELDS.ITEM_ID.getDatabaseFieldName(), OPERATOR.LIKE, "?"), "%Base%"); for (tStd_M_lt base : bases) { List<tShower_Base_Kit> kits = database.selectByForiegnKey(tShower_Base_Kit.class, base); }