?? portleteo.java
字號:
package book.portal.table;
import java.sql.ResultSet;
import java.sql.SQLException;
import book.portal.DbManager;
public class PortletEO {
protected int id;//代表數(shù)據(jù)庫中portlet_id列;
protected String displayName;//代表數(shù)據(jù)庫中display_name列;
protected String javaClassName;//代表數(shù)據(jù)庫中java_class_name列;
protected String activeStatus="Y";//代表數(shù)據(jù)庫中active_status列;
public PortletEO() {//無參的構造方法
this.id = -1;
}
public PortletEO(int id) {//有參的構造方法,參數(shù)為portlet_id
this.id = id;
if (!FromDb())//如果有找到該id的porlet
this.id = -1;
}
public boolean FromDb() {//從數(shù)據(jù)庫中讀出,并更新bean
int row = -1;
//讀記錄的sql語句
String sql = "select * from ajax_portlet where portlet_id=" + this.id
+ " and active_status='Y'";
ResultSet rs = DbManager.getResultSet(sql);//執(zhí)行sql語句并返回ResultSet
try {
rs.last();//移動到最后一行
row = rs.getRow();//得到總記錄數(shù)
if (row == 1) {//如果只查詢到一條記錄,則代表該記錄存在并更新該類的屬性
this.displayName = rs.getString("DISPLAY_NAME");
this.javaClassName = rs.getString("JAVA_CLASS_NAME");
this.activeStatus = rs.getString("ACTIVE_STATUS");
return true;
} else
return false;
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
try {//最后關閉ResutltSet,Statement.并釋放連接
if (rs != null)
rs.close();
if (rs.getStatement() != null)
rs.getStatement().close();
DbManager.releaseConnection();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public boolean ToDb() {//更新數(shù)據(jù)庫,并重新設置bean
if (getId() == -1)//如果此時id為-1
{
return false;
} else {
//更新該記錄的sql語句
String sql = "update ajax_portlet set display_name=" + getDisplayName()
+ ",java_class_name='" + getJavaClassName()
+ "',active_status='"
+ getActiveStatus() + "' where portlet_id=" + getId();
DbManager.excute(sql);//執(zhí)行sql語句
return FromDb();//重新讀出bean的屬性
}
}
public String getActiveStatus() {//
return activeStatus;
}
public void setActiveStatus(String activeStatus) {
this.activeStatus = activeStatus;
}
public String getDisplayName() {
return displayName;
}
public void setDisplayName(String displayName) {
this.displayName = displayName;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getJavaClassName() {
return javaClassName;
}
public void setJavaClassName(String javaClassName) {
this.javaClassName = javaClassName;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -