CDATA format to XML only.CDATA format to XML only.XmlElement for a required name and add it to children.XmlElement for a required name and add it to children.HtmlList.getBody().addElement(CharSequence) HtmlList.getHead().addElement(CharSequence) IllegalArgumentException exception only.hash() and equals() can be customized for all the Map.HashMapfor ( ; ; )
Supported SQL statements are: INSERT, UPDATE, DELETE .PreparedStatement.executeUpdate() .true if the first item equals the value
assertEquals("TEST" , MsgFormatter.format("TE{}T", "S"));
assertEquals("TE, S, T", MsgFormatter.format("TE", "S", "T"));
assertEquals("TES{}" , MsgFormatter.format("TE{}{}", "S"));
assertEquals("TEST" , MsgFormatter.format("TE{}T", "S"));
assertEquals("TE, S, T", MsgFormatter.format("TE", "S", "T"));
assertEquals("TES{}" , MsgFormatter.format("TE{}{}", "S"));
assertEquals("TEST" , MsgFormatter.format("TE{}T", "S"));
assertEquals("TE, S, T", MsgFormatter.format("TE", "S", "T"));
assertEquals("TES{}" , MsgFormatter.format("TE{}{}", "S"));
'?'.null.null.null.null.null.null.null.null.null.null.null.null.
final HtmlElement html = new HtmlElement("Test");
html.getBody().addElement("div")
.addText("Hello word!")null.null.null.null.null.null.null.null.null.null.null.null.false.false.false.null.null.true.true.true.
JdbcBuilder sql = new JdbcBuilder()
.write("SELECT")
.column("t.id")
.column("t.name")
.write("FROM testTable t WHERE")
.andCondition("t.name", "=", "Test")
.andCondition("t.created", ">=", someDate);
for (ResultSet rs : sql.executeSelect(dbConnection)) {
int id = rs.getInt(1);
String name = rs.getString(2);
}
How to use a INSERT
JdbcBuilder sql = new JdbcBuilder()
.write("INSERT INTO testTable (")
.columnInsert("id", 10)
.columnInsert("name", "Test")
.columnInsert("date", someDate)
.write(")");
sql.executeUpdate(dbConnection);
How to use a UPDATE
JdbcBuilder sql = new JdbcBuilder()
.write("UPDATE testTable SET")
.columnUpdate("name", "Test")
.columnUpdate("date", SOME_DATE)
.write("WHERE")
.andCondition("id", "IN", 10, 20, 30)
.andCondition("created = (?)"Iterator is suitable for use in the for ( ; ; ) statement.Locale.ENGLISH{} characters.null.null.null valuetrue.{} characters.Copyright 2019-2022, Pavel Ponec