?? tbean.java
字號:
package ServletApi;
import java.io.*;
import java.sql.*;
public class TBean {
protected Connection conn = null;
protected Statement stmt = null;
protected java.sql.ResultSet Result;
public TBean() {
super();
}
public void execute() {
try {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
conn = DriverManager.getConnection("jdbc:db2:sample", "administrator", "");
stmt = conn.createStatement();
String sql = "SELECT * FROM STAFF WHERE DEPT=20";
ResultSet rs = stmt.executeQuery(sql);
setResult(rs);
} catch (SQLException e) {
} catch (IllegalAccessException e2) {
} catch (ClassNotFoundException e3) {
} catch (InstantiationException e4) {
}
}
public java.sql.ResultSet getResult() {
return Result;
}
public void setResult(java.sql.ResultSet newResult) {
Result = newResult;
}
public void Sqlclose() {
try {
conn.close();
stmt.close();
} catch (SQLException e) {
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -