?? connectiontag.java
字號:
//聲明本類所在的包
package examples.jsp.tagext.sql;
//聲明本類引入的其它包
import java.io.*;
import java.sql.*;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
/**
*Creates a JDBC connection.
*/
public class ConnectionTag extends BodyTagSupport {
private static final String DRIVER = "weblogic.jdbc.pool.Driver";
private static final String POOLPREFIX = "jdbc:weblogic:pool:";
Connection conn;
String poolName = null;
public void setPool_name(String name) { this.poolName = name; }
public String getPool_name() { return poolName; }
public Connection getConnection() { return conn; }
//實現doStartTag方法
public int doStartTag() throws javax.servlet.jsp.JspException {
// 創建基于連接池的JDBC連接
if (poolName == null) {
throw new JspException("poolName attribute not defined in connection tag");
}
try {
Class.forName(DRIVER).newInstance();
conn =
DriverManager.getConnection(POOLPREFIX+poolName, null);
return EVAL_BODY_TAG;
} catch(Exception e) {
throw new JspException("Failed to load JDBC driver: "+DRIVER);
}
}
//實現doAfterBody方法
public int doAfterBody() throws javax.servlet.jsp.JspException
{
try {
getBodyContent().writeOut(getPreviousOut());
} catch(java.io.IOException ioe) {
throw new JspException("Failed to write body content");
}
return SKIP_BODY;
}
//實現doEndTag方法
public int doEndTag() throws javax.servlet.jsp.JspException
{
if (conn != null) {
try {
conn.close();
} catch(Exception e) {
throw new JspException("Failed to close statement");
}
}
return EVAL_PAGE;
}
//釋放資源
public void release() {
super.release();
conn = null;
poolName = null;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -