tbean.java

Java程序设计 Jsp/Servlet开发

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) {
}
}
}