資源簡介
北大青鳥學士后java工程師第二單元項目源代碼web項目
代碼片段和文件信息
package?com.next.SuperMarket.Dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?javax.naming.Context;
import?javax.naming.InitialContext;
import?javax.naming.NamingException;
import?javax.sql.DataSource;
public?class?baseDao?{
protected?Connection?conn;
protected?PreparedStatement?stmt;
protected?ResultSet?rs;
private?static?DataSource?ds?=?null;
/**
?*?錕斤拷錕斤拷錕皆達拷幕錕餃≈伙拷錕餃∫伙拷錕?
?*/
static{
//錕斤拷取錕斤拷錕斤拷錕斤拷
Context?context?=?null;
try?{
context?=?new?InitialContext（）;
//通錕斤拷錕斤拷錕斤拷錕僥伙拷取錕斤拷錕皆?
ds?=?（DataSource）?context.lookup（“java:comp/env/jdbc/supermarket“）;
}?catch?（NamingException?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}
}
/**
?*?錕斤拷取錕斤拷菘錕斤拷錕斤拷錕?
?*?@return
?*/
public?Connection?getConnection（）{
try?{
conn?=?ds.getConnection（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
return?conn;
}
/**
?*?錕截憋拷錕斤拷菘錕斤拷錕皆?
?*?@param?rs
?*?@param?stmt
?*?@param?conn
?*/
public?void?closeAll（）{
if（rs!=null）{
try?{
rs.close（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
}
if（stmt!=null）{
try?{
stmt.close（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
}
if（conn!=null）{
try?{
conn.close（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
}
}
/**
?*?錕斤拷裝一錕斤拷錕斤拷錕矯的詫拷詢錕斤拷錕斤拷
?*?錕斤拷錕斤拷resultSet然錕斤拷錕繳碉拷錕矯鳳拷錕皆鹼拷去錕斤拷裝錕斤拷錕斤拷應錕斤拷List錕斤拷錕斤拷
?*?@return
?*/
public?ResultSet?query（String?sqlobject[]?parms）{
getConnection（）;
try?{
stmt?=?conn.prepareStatement（sql）;
if（parms!=null）{
for（int?i=0;iject（i+1?parms[i]）;
}
}
return?stmt.executeQuery（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
return?null;
}
public?ResultSet?query1（String?sqlString[]?parms）{
getConnection（）;
try?{
stmt?=?conn.prepareStatement（sql）;
if（parms!=null）{
for（int?i=0;i
stmt.setString（i+1?parms[i]）;
}else{
stmt.setString（i+1?（“%“+parms[i]+“%“））;
}
}
}
return?stmt.executeQuery（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
return?null;
}
public?ResultSet?query2（String?sqlString[]?parms）{
getConnection（）;
try?{
stmt?=?conn.prepareStatement（sql）;
if（parms!=null）{
for（int?i=0;i
if（parms[i]==““）{
stmt.setString（i+1?parms[i]）;
}else{
stmt.setString（i+1?（“%“+parms[i]+“%“））;
}
}
}
return?stmt.executeQuery（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
return?null;
}
/**
?*?錕斤拷錕鉸ｏ拷錕斤拷刪錕僥ｏ拷
?*?@return
?*/
public?int?update（String?sqlobject[]?parms）{
getConnection（）;
tr ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\
?????文件?????????529??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\.classpath
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\.myeclipse\
?????文件?????????306??2014-06-29?22:58??周榮技第二單元項目更新\SuperMarket\.myme
?????文件????????1754??2014-06-29?09:13??周榮技第二單元項目更新\SuperMarket\.project
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\.settings\
?????文件?????????500??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\.settings\.jsdtscope
?????文件????????1009??2014-06-29?14:17??周榮技第二單元項目更新\SuperMarket\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????229??2014-07-01?23:10??周榮技第二單元項目更新\SuperMarket\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\.settings\org.eclipse.jdt.core.prefs
?????文件?????????471??2014-06-29?14:17??周榮技第二單元項目更新\SuperMarket\.settings\org.eclipse.wst.common.component
?????文件?????????252??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\me
?????文件??????????36??2014-06-29?08:35??周榮技第二單元項目更新\SuperMarket\WebRoot\me
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\Dao\
?????文件????????3202??2014-07-10?07:10??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\Dao\ba
?????文件????????6347??2014-07-10?07:10??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\Dao\BillInfoDao.class
?????文件????????5311??2014-07-10?07:10??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\Dao\ProviderInfoDao.class
?????文件????????6160??2014-07-10?07:10??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\Dao\UserInfoDao.class
?????目錄???????????0??2014-07-10?08:27??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\entity\
?????文件????????2658??2014-07-10?07:10??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\entity\BillInfo.class
?????文件????????2097??2014-07-10?07:10??周榮技第二單元項目更新\SuperMarket\WebRoot\WEB-INF\classes\com\next\SuperMarket\entity\ProviderInfo.class
............此處省略79個文件信息
- 上一篇：android SQLite開發
- 下一篇：北京郵電大學計算機實習報告
評論
共有 條評論
川公網安備 51152502000135號