| Methods Summary |
|---|
| public void | addValue(Value value)Adds a value. This method is called by value tags in the
action body.
if (values == null) {
values = new Vector();
}
values.addElement(value);
|
| public int | doAfterBody()Sets the SQL statement to the contents of the element's
body.
sqlValue = bodyContent.getString();
return SKIP_BODY;
|
| public int | doEndTag()If the action is included in the body of a tag,
gets the connection from the tag. If not,
gets the DataSource from the application scope and asks for a Connection.
Executes the SQL query defined in the action element's body, and saves the
result as a Vector with Row objects in the specified scope under the
specified name.
Connection conn = getConnection();
sqlCommandBean.setConnection(conn);
sqlCommandBean.setSqlValue(sqlValue);
sqlCommandBean.setValues(values);
Object result = null;
try {
result = execute(sqlCommandBean);
}
catch (SQLException e) {
try {
isExceptionThrown = true;
conn.rollback();
}
catch (SQLException se) {} // Ignore, probably a result of the main exception
throw new JspException("SQL error: " + e.getMessage());
}
catch (UnsupportedTypeException e) {
try {
isExceptionThrown = true;
conn.rollback();
}
catch (SQLException se) {} // Ignore, probably caused by the main exception
throw new JspException("Query result error: " + e.getMessage());
}
finally {
try {
if (isPartOfTransaction && isExceptionThrown) {
// Reset auto commit in case the connection is pooled
// before it's returned to the pool by close
conn.setAutoCommit(true);
conn.close();
}
else if (!isPartOfTransaction) {
// If we're not part of a transaction, the connection
// is in auto commit mode so we only close it
conn.close();
}
}
catch (SQLException e) {
e.printStackTrace(System.err);
}
}
// Save the result with the specified id in the specified scope
if (id != null) {
pageContext.setAttribute(id, result, scope);
}
return EVAL_PAGE;
|
| public int | doStartTag()Override the default implementation to reset the
per-use state set by nested elements.
values = null;
isExceptionThrown = false;
isPartOfTransaction = false;
return EVAL_BODY_TAG;
|
| protected abstract java.lang.Object | execute(SQLCommandBean sqlCommandBean)Must be implemented by subclass to perform the appropriate
processing.
|
| private java.sql.Connection | getConnection()Gets the Connection either from a transaction parent or from
the DataSource specified for the action.
Connection conn = null;
TransactionTag transactionTag = (TransactionTag)
findAncestorWithClass(this, TransactionTag.class);
if (transactionTag != null) {
conn = transactionTag.getConnection();
isPartOfTransaction = true;
if (dataSourceName != null) {
throw new JspException("A dataSource must not be specified " +
"when the action is part of a transaction");
}
}
else {
DataSource dataSource = (DataSource)
pageContext.getAttribute(dataSourceName, PageContext.APPLICATION_SCOPE);
if (dataSource == null) {
throw new JspException("dataSource " + dataSourceName + " not found");
}
try {
conn = dataSource.getConnection();
}
catch (SQLException e) {
throw new JspException("SQL error: " + e.getMessage());
}
}
return conn;
|
| public void | release()Releases all instance variables.
dataSourceName = null;
id = null;
scope = PageContext.PAGE_SCOPE;
sqlValue = null;
values = null;
isExceptionThrown = false;
isPartOfTransaction = false;
super.release();
|
| public void | setDataSource(java.lang.String dataSourceName)Sets the dataSource attribute.
this.dataSourceName = dataSourceName;
|
| public void | setId(java.lang.String id)Sets the id attribute.
this.id = id;
|
| public void | setScope(java.lang.String scopeName)Sets the scope attribute.
if ("page".equals(scopeName)) {
scope = PageContext.PAGE_SCOPE;
}
else if ("request".equals(scopeName)) {
scope = PageContext.REQUEST_SCOPE;
}
else if ("session".equals(scopeName)) {
scope = PageContext.SESSION_SCOPE;
}
else if ("application".equals(scopeName)) {
scope = PageContext.APPLICATION_SCOPE;
}
|
