cellpadding is not supported in HTML 5.cellspacing is not supported in HTML 5.ApiElement rather.CDATA format to XML only.CDATA format to XML only.XmlElement for a required name and add it to children.XmlBuilder for a required name and add it to children.XmlModel for a required name and add it to children.IllegalArgumentException exception only.null itemshash() and equals() can be customized for all the Map.HashMap#equals(java.lang.Object) method.for ( ; ; )
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"));
'?'."text/html"null valuenull valueString.valueOf(value)null.null.null.null.null.null.null.null.null.null.null.null.
MockServletResponse response = new MockServletResponse();
try (HtmlElement html = HtmlElement.of(response)) {
html.addBody().addHeading("Hello!")falsefalsenull.null.null.null.null.null.null.null.null.null.null.null.false.false.null.true.true.T.
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 BETWEEN ?Iterator is suitable for use in the for ( ; ; ) statement.Locale.ENGLISH{} characters.#getName()null.null.null without exception..Stream.forEach() Element.setAttribute(java.lang.String, java.lang.Object).ApiElement.setAttribute(java.lang.String, java.lang.Object) rather.null valuefalseString.valueOf(value)
SqlBuilder sql = new SqlBuilder()
.select("t.id", "t.name")
.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
SqlBuilder sql = new SqlBuilder()
.insert("testTable")
.write("(")
.columnInsert("id", 10)
.columnInsert("name", "Test")
.columnInsert("date", someDate)
.super.write(")");
sql.executeUpdate(dbConnection);
How to use a UPDATE
SqlBuilder sql = new SqlBuilder()
.update("testTable")
.columnUpdate("name", "Test")
.columnUpdate("date", SOME_DATE)
.where()
.andCondition("id", "IN", 10, 20, 30)
.andCondition("created BETWEEN ?true.null value{} characters.hash(), equals() and compareTo() methods
Usage:
Person p1 = new Person(1, "A"); Person p2 = new Person(1, "B"); Wrapper<Person> w1 = Wrapper.of(p1, Person::getId, Person::getName); Wrapper<Person> w2 = w1.wrap(p2); assertTrue(w1.compareTo(w2) < 0);
XmlModel rather.Copyright 2019-2022, Pavel Ponec