| Home >> All >> org >> apache >> taglibs >> dbtags |
| | org.apache.taglibs.dbtags.connection.* (8) | | org.apache.taglibs.dbtags.preparedstatement.* (5) |
| | org.apache.taglibs.dbtags.resultset.* (15) | | org.apache.taglibs.dbtags.statement.* (6) |
Package Samples:
org.apache.taglibs.dbtags.connection
org.apache.taglibs.dbtags.preparedstatement
org.apache.taglibs.dbtags.resultset
org.apache.taglibs.dbtags.statement
Classes:
GetTimestampTag: Translates a java.sql.Timestamp to a readable String. JSP Tag Lib Descriptor <tag> <name>getTimestamp</name> <tagclass>org.apache.taglibs.dbtags.resultset.GetTimestampTag</tagclass> <teiclass>org.apache.taglibs.dbtags.resultset.BaseGetterTEI</teiclass> <bodycontent>empty</bodycontent> <info> Similar to getColumn, but provides more precise control over java.sql.Timestamp formatting. The required "format" attribute can be either a pattern as accepted by SimpleDateFormat or a style: "FULL", "LONG", "MEDIUM" or "SHORT". It can also can be a comma separated list of two ...
GetNumberTag: Translates any SQL number to a readable String. JSP Tag Lib Descriptor <tag> <name>getNumber</name> <tagclass>org.apache.taglibs.dbtags.resultset.GetNumberTag</tagclass> <teiclass>org.apache.taglibs.dbtags.resultset.BaseGetterTEI</teiclass> <bodycontent>empty</bodycontent> <info> Similar to getColumn, but provides more precise control over number formatting. The "format" attribute can be either a pattern as accepted by the DecimalFormat constructor or a style: "CURRENCY", "PERCENT" or "NUMBER". The "locale" attribute can have one to three components as accepted by ...
GetTimeTag: Translates a java.sql.Time to a readable String. JSP Tag Lib Descriptor <tag> <name>getTime</name> <tagclass>org.apache.taglibs.dbtags.resultset.GetTimeTag</tagclass> <teiclass>org.apache.taglibs.dbtags.resultset.BaseGetterTEI</teiclass> <bodycontent>empty</bodycontent> <info> Similar to getColumn, but provides more precise control over java.sql.Time formatting. The "format" attribute can be either a pattern as accepted by SimpleDateFormat or a style: "FULL", "LONG", "MEDIUM" or "SHORT". The "locale" attribute can have one to three components as accepted by the Locale ...
ResultSetTag: JSP tag resultSet, executes the query and loops through the results for the enclosing statement or preparedstatement tag. The body of this tag is executed once per row in the resultset. The optional "loop" attribute, which default to true, specifies whether to execute the tag body once per row "true", or to simply assign the ResultSet to the page attribute specified by "id". The optional "name" and "scope" attributes can be used to retrieve a resultset (or rowset) from context. JSP Tag Lib Descriptor <name>resultSet</name> <tagclass>org.apache.taglibs.dbtags.resultset.ResultSetTag</tagclass> ...
GetDateTag: Translates a java.sql.Date to a readable String. JSP Tag Lib Descriptor <tag> <name>getDate</name> <tagclass>org.apache.taglibs.dbtags.resultset.GetDateTag</tagclass> <teiclass>org.apache.taglibs.dbtags.resultset.BaseGetterTEI</teiclass> <bodycontent>empty</bodycontent> <info> Similar to getColumn, but provides more precise control over java.sql.Date formatting. The "format" attribute can be either a pattern as accepted by SimpleDateFormat or a style: "FULL", "LONG", "MEDIUM" or "SHORT". The "locale" attribute can have one to three components as accepted by the Locale ...
GetColumnTag: Get the value of a database column as a String. JSP Tag Lib Descriptor <name>getString</name> <tagclass>org.apache.taglibs.dbtags.resultset.GetStringTag</tagclass> <bodycontent>empty</bodycontent> <info>Gets the value, as a String, of a coulmn in the enclosing resultset. Either set the column number via the "position" attribute, or set the column name with the "colName" attribute. You can optionally set the value, as a String, to a serlvet attribute instead of the tag body with the "to" attribute. The scope of the servlet attribute is specified by the "scope" XML attribute ...
PreparedStatementImplTag: JSP tag preparedstatement. According to the TEI, the preparedstatemnt object specified in the "id" attribute is available within the scope of the preparedstatement tags. However, this is not quite the case. Technically, the object is not added to the page context until after the query tag is executed, because PreparedStatement objects cannot be instantiated without a query. JSP Tag Lib Descriptor <name>preparedStatement</name> <tagclass>org.apache.taglibs.dbtags.preparedstatement.PreparedStatementImplTag</tagclass> <teiclass>org.apache.taglibs.dbtags.connection.PreparedStatementTEI</teiclass> ...
UserIdTag: JSP tag userid, sets the database user id for the enclosing connection tag. This tag is optional if the user name has been encoded inside the database URL, or if the database does not require a user name. The user name is read from the indicated initParameter, if the attribute is set, or from the body of the tag if it is not. The tag body will be trimmed. JSP Tag Lib Descriptor <name>userId</name> <tagclass>org.apache.taglibs.dbtags.connection.UserIdTag</tagclass> <bodycontent>JSP</bodycontent> <info>JSP tag userid, sets the database user id for the enclosing connection tag. ...
ConnectionTag: JSP tag connection, used to get a java.sql.Connection object from the DriverManager. JSP Tag Lib Descriptor <name>connection</name> <tagclass>org.apache.taglibs.dbtags.connection.ConnectionTag</tagclass> <bodycontent>JSP</bodycontent> <teiclass>org.apache.taglibs.dbtags.connection.ConnectionTEI</teiclass> <info>Opens a connection based on either a url in the body of the tag or by using the "datasource" tag attribute to reference to a javax.sql.DataSource page attribute. driver (optional), userid (optional), and password (optional) are also set in the body of the tag.</info> ...
PasswordTag: JSP tag password, sets the password for the enclosing connection tag. This tag is optional if the password has been encoded inside the database URL, or if the database does not require a password. The password is read from the indicated initParameter, if the parameter is set, or from the body of the tag if it is not. JSP Tag Lib Descriptor <name>password</name> <tagclass>org.apache.taglibs.dbtags.connection.PasswordTag</tagclass> <bodycontent>JSP</bodycontent> <info>JSP tag password, sets the password for the enclosing connection tag. This tag is optional if the password has ...
StatementImplTag: JSP tag statement. According to the TEI, the java.sql.Statement object specified in the "id" attribute is available within the scope of the statement tags. JSP Tag Lib Descriptor <name>statement</name> <tagclass>org.apache.taglibs.dbtags.statement.StatementImplTag</tagclass> <teiclass>org.apache.taglibs.dbtags.connection.StatementTEI</teiclass> <bodycontent>JSP</bodycontent> <info>JSP tag statement, uses the enclosed query and resultset/execute tags to perform a database operation.</info> <attribute> <name>id</name> <required>true</required> <rtexprvalue>false</rtexprvalue> ...
WasEmptyTag: Executes its body if the last ResultSet tag received 0 rows from the database. You must be after a ResultSet tag and inside a StatementTag or PreparedStatementTag, or an error will be generated. The subclass WasNotEmpty sets the "value" property to false, and therefore executes its tag body is the ResultSet contained greater than 0 rows. JSP Tag Lib Descriptor <name>wasEmpty</name> <tagclass>org.apache.taglibs.dbtags.statement.WasEmptyTag</tagclass> <bodycontent>JSP</bodycontent> <info> Executes its body if the last ResultSet tag received 0 rows from the database. You must ...
JndiNameTag: JSP tag jndiname, sets the jndi named javax.sql.DataSource for the enclosing connection tag. The jndiname is read from the indicated initParameter, if the parameter is set, or from the body of the tag if it is not. JSP Tag Lib Descriptor <name>jndiName</name> <tagclass>org.apache.taglibs.dbtags.connection.JndiNameTag</tagclass> <bodycontent>JSP</bodycontent> <info>Sets the jndi named javax.sql.DataSource for the enclosing connection tag according to the initParameter, if specified, or the body of the tag. The tag body will be trimmed.</info> <attribute> <name>initParameter</name> ...
WasNullTag: Executes its body if the last getColumn tag received a null value from the database. You must be inside a resultset tag and there must be a previous getColumn tag, or an error will be generated. The subclass WasNotNull sets the "value" property to false, and therefore executes its tag body is the last column was not null. JSP Tag Lib Descriptor <name>wasNull</name> <tagclass>org.apache.taglibs.dbtags.resultset.WasNullTag</tagclass> <bodycontent>JSP</bodycontent> <info>Executes its body if the last getColumn tag received a null value from the database. You must be inside a resultset ...
DriverTag: JSP tag driver, sets the java.sql.Driver class name for the enclosing connection tag. The driver name is read from the indicated initParameter, if the parameter is set, or from the body of the tag if it is not. JSP Tag Lib Descriptor <name>driver</name> <tagclass>org.apache.taglibs.dbtags.connection.DriverTag</tagclass> <bodycontent>JSP</bodycontent> <info>Sets the java.sql.Driver class name for the enclosing connection tag according to the initParameter, if specified, or the body of the tag. The tag body will be trimmed.</info> <attribute> <name>initParameter</name> ...
RowCountTag: Prints out the number of rows retrieved from the database. It can be used inside a ResultSet tag to provide a running count of rows retreived, or after the ResultSet tag to display the total number. Using the tag before the ResultSet will produce an error. JSP Tag Lib Descriptor <name>rowCount</name> <tagclass>org.apache.taglibs.dbtags.statement.RowCountTag</tagclass> <bodycontent>empty</bodycontent> <info>Prints out the number of rows retrieved from the database. It can be used inside a ResultSet tag to provide a running count of rows retreived, or after the ResultSet tag ...
DatabaseURLTag: JSP tag url, sets the database URL for the enclosing connection tag. The URL is read from the indicated initParameter, if the parameter is set, or from the body of the tag if it is not. JSP Tag Lib Descriptor <name>url</name> <tagclass>org.apache.taglibs.dbtags.connection.DatabaseURLTag</tagclass> <bodycontent>JSP</bodycontent> <info>Sets the database URL of the enclosing connection tag according to the initParameter, if specified, or the body of the tag. The tag body will be trimmed.</info> <attribute> <name>initParameter</name> <required>false</required> ...
ExecuteTag: JSP tag execute, executes the query for the enclosing statement or preparedstatement tag. Setting the "ignoreErrors" atttibute to true will instruct the page to continue in the event of a SQLException, otherwise by default exceptions will throw a JspTagException. JSP Tag Lib Descriptor <name>execute</name> <tagclass>org.apache.taglibs.dbtags.statement.ExecuteTag</tagclass> <bodycontent>JSP</bodycontent> <info>Executes the query for the enclosing statement or preparedstatement tag.</info> <attribute> <name>ignoreErrors</name> <required>false</required> <rtexprvalue>true</rtexprvalue> ...
WasNotEmptyTag: Executes its body if the last ResultSet tag received more than 0 rows from the database. You must be after a ResultSet tag and inside a StatementTag or PreparedStatementTag, or an error will be generated. JSP Tag Lib Descriptor <name>wasNotEmpty</name> <tagclass>org.apache.taglibs.dbtags.statement.WasNotEmptyTag</tagclass> <bodycontent>JSP</bodycontent> <info> Executes its body if the last ResultSet tag received more than 0 rows from the database. You must be after a ResultSet tag and inside a StatementTag or PreparedStatementTag, or an error will be generated. </info>
SetColumnTag: Setter for the enclosing preparedstatement tag. Set the value inside the tag body. Body content will not be trimmed. JSP Tag Lib Descriptor <name>setColumn</name> <tagclass>org.apache.taglibs.dbtags.preparedstatement.SetColumnTag</tagclass> <bodycontent>JSP</bodycontent> <info>Setter for the enclosing preparedstatement tag. Set the value inside the tag body. Body content will not be trimmed.</info> <attribute> <name>position</name> <required>true</required> <rtexprvalue>false</rtexprvalue> </attribute>
WasNotNullTag: Executes its body if the last getColumn tag did not receive a null from the database. You must be inside a resultset tag and there must be a previous getColumn tag, or an error will be generated. JSP Tag Lib Descriptor <name>wasNotNull</name> <tagclass>org.apache.taglibs.dbtags.resultset.WasNotNullTag</tagclass> <bodycontent>JSP</bodycontent> <info>Executes its body if the last getColumn tag did not receive a null value from the database. You must be inside a resultset tag and there must be a previous getColumn tag, or an error will be generated.</info>
CloseConnectionTag: JSP tag closeconnection, used to close the specified java.sql.Connection. JSP Tag Lib Descriptor <name>closeConnection</name> <tagclass>org.apache.taglibs.dbtags.connection.CloseConnectionTag</tagclass> <bodycontent>empty</bodycontent> <info>Close the specified connection. The "conn" attribute is the name of a connection object in the page context.</info> <attribute> <name>conn</name> <required>true</required> <rtexprvalue>false</rtexprvalue> </attribute>
PreparedStatementTEI: TagExtraInfo for the preparedstatement tag. This TagExtraInfo specifies that the PreparedStatementImplTag assigns a java.sql.PreparedStatement object to the "id" attribute within the begin and end tags. However, see PreparedStatementImplTag for more details.
EscapeSQLTag: JSP tag escapesql, replaces each single quote in the tag body with a pair of single quotes. JSP Tag Lib Descriptor <name>escapeSql</name> <tagclass>org.apache.taglibs.dbtags.statement.EscapeSQLTag</tagclass> <bodycontent>JSP</bodycontent> <info>Replaces each single quote in the tag body with a pair of single quotes. Body content will not be trimmed.</info>
QueryTag: JSP tag query, sets the SQL query for the enclosing statement or preparedstatement tag. JSP Tag Lib Descriptor <name>query</name> <tagclass>org.apache.taglibs.dbtags.statement.QueryTag</tagclass> <bodycontent>JSP</bodycontent> <info>Sets the SQL query for the enclosing statement or preparedstatement tag.</info>
| Home | Contact Us | Privacy Policy | Terms of Service |