資源簡(jiǎn)介
北大青鳥Java學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)
能跑,內(nèi)附Java代碼,Oracle數(shù)據(jù)庫(kù)代碼,數(shù)據(jù)庫(kù)用戶名,數(shù)據(jù)庫(kù)密碼,數(shù)據(jù)庫(kù)創(chuàng)建的表等,如果需要可下載(^U^)ノ~YO

代碼片段和文件信息
package?Dao;
import?java.sql.Connection;
import?java.sql.DriverManager;
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;
import?unit.ConfigManager;
public?class?baseDao?{
protected?Connection?con;
??protected?PreparedStatement?pps;
??protected?Statement?stmt;
??protected?ResultSet?rs;
??
??public?boolean?getConnection()?{
String?driver=ConfigManager.getInstance().getString(“jdbc.driver_class“);
String?url=ConfigManager.getInstance().getString(“jdbc.connection.url“);
String?username=ConfigManager.getInstance().getString(“jdbc.connection.username“);
String?password=ConfigManager.getInstance().getString(“jdbc.connection.password“);
try?{
Class.forName(driver);
con?=?DriverManager.getConnection(url?username?password);
System.out.println(“數(shù)據(jù)庫(kù)已經(jīng)連接“);
}?catch?(ClassNotFoundException?e)?{
e.printStackTrace();
return?false;
}?catch?(SQLException?e)?{
e.printStackTrace();
return?false;
}
return?true;
}
??public?Connection?getConnection2()?{
try?{
Context?cxt=new?InitialContext();
DataSource?ds=(DataSource)cxt.lookup(“java:comp/env/jdbc/orcl“);
con=ds.getConnection();
}?catch?(NamingException?e)?{
e.printStackTrace();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?con;
}
public?int?executeUpdate(String?sql?object[]?params)?{
int?updateRows?=?0;
getConnection2();
//System.out.println(sql);
try?{
pps=con.prepareStatement(sql);
for(int?i=0;i pps.setobject(i+1?params[i]);
}
updateRows=pps.executeUpdate();
System.out.println(updateRows);
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?updateRows;
}
???
public?ResultSet?executeSQL(String?sqlobject[]?params)?{
getConnection();
try?{
pps=con.prepareStatement(sql);
//遍歷這個(gè)集合
for(int?i=0;i pps.setobject(i+1?params[i]);
}
rs=pps.executeQuery();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?rs;
}
//?關(guān)閉各類資源
public?boolean?closeResource()?{
if(rs!=null){
try?{
rs.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
return?false;
}
}
if(pps!=null){
try?{
pps.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
return?false;
}
}
if(stmt!=null){
try?{
stmt.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
return?false;
}
}
if(con!=null){
try?{
con.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
return?false;
}
}
return?true;
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-11-23?20:34??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\
?????文件?????????834??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.classpath
?????文件?????????906??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.project
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\
?????文件?????????567??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\.jsdtscope
?????文件?????????364??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\org.eclipse.jdt.core.prefs
?????文件?????????470??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\org.eclipse.wst.common.component
?????文件?????????345??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-11-10?13:45??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\Dao\
?????文件????????3650??2016-11-19?15:22??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\Dao\ba
?????文件?????????322??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\Dao\BillDao.class
?????文件?????????334??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\Dao\SupplierDao.class
?????文件?????????284??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\Dao\UserDao.class
?????文件?????????180??2016-11-17?09:56??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\databa
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\entity\
?????文件????????2485??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\entity\Bill.class
?????文件????????1783??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\entity\Supplier.class
?????文件????????2024??2016-11-17?16:14??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\entity\User.class
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\impl\
?????文件????????9991??2016-11-23?13:15??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\impl\BillDaoImpl.class
?????文件????????6838??2016-11-20?11:04??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\impl\SupplierDaoImpl.class
?????文件????????6548??2016-11-22?18:25??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\impl\UserDaoImpl.class
?????目錄???????????0??2016-11-23?20:30??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\servlet\
?????文件????????6620??2016-11-23?16:42??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\servlet\Bills.class
?????文件????????2929??2016-11-23?20:27??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\servlet\Login.class
?????文件????????5769??2016-11-23?20:23??北大青鳥學(xué)士后第二單元項(xiàng)目——超市賬單管理系統(tǒng)?\beifen\build\classes\servlet\Suppliers.class
............此處省略83個(gè)文件信息
評(píng)論
共有 條評(píng)論