資源簡介
此代碼用于java web 開發,把 對應的包加入后,可以自動生成dao層代碼。

代碼片段和文件信息
package?com.amtium.cms.dao.bean;
import?com.amtium.cms.dao.model.*;
import?java.sql.*;
import?java.util.*;
/**
?*?該文件是通過數據庫表結構由DBFilesGen自動生成的。請不要修改文件內容!
?*?根據單個表結構生成對應的數據訪問對象(DAO)文件
?*?DataFilesGen?Impl版本:?Revision:?1.1??
?*/
public?class?Bol_adminBean{
public?Bol_adminBean(){
}
/**
*添加記錄
*@param?conn?Connection?
*@param?model?Bol_adminModel
*/
public?void?addBol_adminModel(Connection?connBol_adminModel?model)?throws?SQLException?{
String?sql?=?“insert?into?Bol_admin(ADMIN_ID?ADMINNAME?ADMINPASSWORD?ADMINLEVEL?ADMINEMAIL?ADMINPHONE)?values(??????)“;
PreparedStatement?ps?=?null;
try?{
ps?=?conn.prepareStatement(sql);
ps.setString(1?model.getADMIN_ID());
ps.setString(2?model.getADMINNAME());
ps.setString(3?model.getADMINPASSWORD());
ps.setString(4?model.getADMINLEVEL());
ps.setString(5?model.getADMINEMAIL());
ps.setInt(6?model.getADMINPHONE());
ps.executeUpdate();
return;
}
catch?(SQLException?ex)?{
System.out.println(“?在?Bol_adminBean?中執行數據庫操作時出錯?SQL語句為?-->sql?=“?+?sql+?“\n“?+?ex.getMessage());
throw?ex;
}
/**
*?關閉所有資源
*/
finally?{
if?(ps?!=?null)?{
ps.close();
}
}
}
/**
*根據主鍵獲取模型
*@param?conn?Connection?
*@param?admin_id?String
*@return??model?Bol_adminModel
*/
public?Bol_adminModel?getModelByPK(Connection?connString?admin_id)?throws?SQLException?{
String?sql?=?“select?*?from??Bol_admin?where??ADMIN_ID?=??“;
Bol_adminModel?model?=?null;
PreparedStatement?ps?=?null;
ResultSet?rt?=?null;
try{
ps?=?conn.prepareStatement(sql);
ps.setString(1?admin_id);
rt?=?ps.executeQuery();
if(rt.next()){
model?=?new?Bol_adminModel();
model.setADMIN_ID(rt.getString(1));
model.setADMINNAME(rt.getString(2));
model.setADMINPASSWORD(rt.getString(3));
model.setADMINLEVEL(rt.getString(4));
model.setADMINEMAIL(rt.getString(5));
model.setADMINPHONE(rt.getInt(6));
}
}catch?(SQLException?ex){
System.out.println(“?在?Bol_adminBean?中執行數據庫操作時出錯?SQL語句為?-->sql?=“?+?sql+?“\n“?+?ex.getMessage());
throw?ex;
}finally{
if(rt!=null)
rt.close();
if?(ps?!=?null)?
ps.close();
}
return?model;
}
/**
*修改記錄
*@param?conn?Connection?
*@param?model?Bol_adminModel
*/
public?void?updateBol_adminModel(Connection?connBol_adminModel?model)?throws?SQLException?{
String?sql?=?“update?Bol_admin?set?ADMIN_ID=??ADMINNAME=??ADMINPASSWORD=??ADMINLEVEL=??ADMINEMAIL=??ADMINPHONE=??where?ADMIN_ID=??“;
PreparedStatement?ps?=?null;
try?{
ps?=?conn.prepareStatement(sql);
ps.setString(1?model.getADMIN_ID());
ps.setString(2?model.getADMINNAME());
ps.setString(3?model.getADMINPASSWORD());
ps.setString(4?model.getADMINLEVEL());
ps.setString(5?model.getADMINEMAIL());
ps.setInt(6?model.getADMINPHONE());
ps.setString(7?model.getADMIN_ID());
ps.executeUpdate();
return;
}
catch?(S
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-01?11:25??自動生成DAO\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\
?????文件?????????773??2012-05-16?17:51??自動生成DAO\JavaProject\.classpath
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\.myeclipse\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\.myeclipse\profiler\
?????文件????????1419??2012-06-05?09:55??自動生成DAO\JavaProject\.myeclipse\profiler\ConnectionUsage.xm
?????文件?????????603??2012-05-17?22:48??自動生成DAO\JavaProject\.project
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\.settings\
?????文件?????????629??2011-06-27?14:13??自動生成DAO\JavaProject\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\com\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\com\amtium\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\com\amtium\cms\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\
?????文件????????8563??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_adminBean.class
?????文件????????9543??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_bugBean.class
?????文件????????7830??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_bugstateBean.class
?????文件????????8811??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_companyBean.class
?????文件????????8039??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_imei_userBean.class
?????文件????????7676??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_osBean.class
?????文件????????7833??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_phoneimeiBean.class
?????文件????????9370??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_programBean.class
?????文件????????7958??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_programst
?????文件????????8671??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_useralipayBean.class
?????文件????????8682??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bol_userBean.class
?????文件????????8260??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\Bug_buglogBean.class
?????文件????????8148??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\bean\TesttableBean.class
?????目錄???????????0??2012-06-22?21:49??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\model\
?????文件????????1634??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\model\Bol_adminModel.class
?????文件????????2679??2012-05-23?10:19??自動生成DAO\JavaProject\bin\com\amtium\cms\dao\model\Bol_bugModel.class
............此處省略96個文件信息
評論
共有 條評論