Skip to main content
Version: 7.2405.x.x LTS

sql

sql:date

java.sql.Date sql:date(java.util.Date)

Converts a Java date to an SQL date.

#{sql:date(xml:date(in.user.values.ctlModDat))}

sql:select

List<Map<String, Object>> sql:select(DataSource dataSource, String query)

Executes an SQL query on a DataSource and returns the result set as a list of records. Every record consists of a map of column names and the corresponding data value.

#{sql:select(ds, 'select * from TAB')[2].COLUMN_NAME}
#{sql:select(ds, 'select MAX(ID)+1 NEXT_ID from TAB')[0].NEXT_ID}

sql:time

java.sql.Time sql:time(java.util.Date)

Converts a Java date to an SQL time.

#{sql:time(xml:date(in.user.values.ctlModDat))}

sql:timestamp

java.sql.Timestap sql:timestamp(java.util.Date)

Converts a Java date to an SQL timestamp.

#{sql:timestamp(xml:date(in.user.values.ctlModDat))}