資源簡介
資源包括myeclipse開發(fā)的源代碼(親測可用,這學期才做的),課程設計文檔,UML圖,需求分析,軟件測試報告,數(shù)據(jù)庫設計。
開發(fā)平臺:myeclipse+MySQL+tomcat
總體思路:1)前端采用了ACE框架,該框架的有點就是UI設計非常具有美感
2)后臺使用了javaweb,主要是jsp+mvc+servlet分層思想實現(xiàn),每一個功能都是通過javabean獲取前臺頁面的數(shù)據(jù),傳遞給servlet,然后進一步通過service層與dao數(shù)據(jù)庫層的交互進行功能數(shù)據(jù)的處理,處理結(jié)果通過bean返回給jsp頁面進行顯示,在顯示時還結(jié)合使用了jstl和el表達式。
3)最后使用tomcat服務器和Google瀏覽器進行web工程的部署和前端頁面的調(diào)試,而后臺設計思想是通過myeclipse編碼調(diào)試,分別為dao層、damain層、exception層、formbean層、service層、utils工具層、controler層、ui層及junit層。
4)其他細節(jié):數(shù)據(jù)庫連接使用了配置文件jdbc.properties,前后臺數(shù)據(jù)的顯示使用了json進行傳輸。

代碼片段和文件信息
package?cbf.dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?cbf.domain.AirInfo;
import?cbf.exception.DaoException;
import?cbf.utils.JdbcUtils;
public?class?AirInfoDao?{
//?添加AirInfo
public?boolean?save(AirInfo?airInfo)?{
Connection?conn?=?null;
PreparedStatement?pstmt?=?null;
ResultSet?rs?=?null;
try?{
conn?=?JdbcUtils.getConnection();
String?sql?=?“insert?into?airinfo?(airidstartplaceendplacedatatimepriceticketnum)“
+?“?values(??????)“;
//?編譯sql
pstmt?=?conn.prepareStatement(sql);
//?替換占位符
pstmt.setString(1?airInfo.getAirid());
pstmt.setString(2?airInfo.getStartplace());
pstmt.setString(3?airInfo.getEndplace());
pstmt.setString(4?airInfo.getDatatime());
pstmt.setString(5?airInfo.getPrice());
pstmt.setInt(6?airInfo.getTicketnum());
int?num?=?pstmt.executeUpdate();
if?(num?>?0)
return?true;
return?false;
}?catch?(SQLException?e)?{
throw?new?DaoException(e);
}?finally?{
JdbcUtils.release(conn?pstmt?rs);
}
}
//?刪除一個AirInfo
public?boolean?delete(String?airid)?{
Connection?conn?=?null;
PreparedStatement?pstmt?=?null;
ResultSet?rs?=?null;
try?{
conn?=?JdbcUtils.getConnection();
String?sql?=?“delete?from?airinfo?where?airid=?“;
pstmt?=?conn.prepareStatement(sql);
pstmt.setString(1?airid);
//?發(fā)送sql
int?num?=?pstmt.executeUpdate();
if(num>0)
return?true;
return?false;
}?catch?(SQLException?e)?{
throw?new?DaoException(e);
}?finally?{
JdbcUtils.release(conn?pstmt?rs);
}
}
//?修改一個AirInfo信息
public?boolean?update(AirInfo?airInfo)?{
Connection?conn?=?null;
PreparedStatement?pstmt?=?null;
ResultSet?rs?=?null;
try?{
conn?=?JdbcUtils.getConnection();
String?sql?=?“update?airinfo?set?startplace=?endplace=?datatime=?price=?ticketnum=??where?airid=?“;
pstmt?=?conn.prepareStatement(sql);
pstmt.setString(1?airInfo.getStartplace());
pstmt.setString(2?airInfo.getEndplace());
pstmt.setString(3?airInfo.getDatatime());
pstmt.setString(4?airInfo.getPrice());
pstmt.setInt(5?airInfo.getTicketnum());
pstmt.setString(6?airInfo.getAirid());
//?發(fā)送sql
int?num?=?pstmt.executeUpdate();
if(num>0)
return?true;
return?false;
}?catch?(SQLException?e)?{
throw?new?DaoException(e);
}?finally?{
JdbcUtils.release(conn?pstmt?rs);
}
}
//?根據(jù)航班號查找AirInfo
public?AirInfo?find(String?airid)?{
Connection?conn?=?null;
PreparedStatement?pstmt?=?null;
ResultSet?rs?=?null;
try?{
conn?=?JdbcUtils.getConnection();
String?sql?=?“select?*?from?airinfo?where?airid=?“;//or?name=?“;
pstmt?=?conn.prep
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-07?23:56??民航訂票系統(tǒng)\
?????目錄???????????0??2017-10-25?16:56??民航訂票系統(tǒng)\AirTicketingSystem\
?????文件????????1171??2017-10-25?21:09??民航訂票系統(tǒng)\AirTicketingSystem\.classpath
?????文件????????1343??2017-10-25?15:21??民航訂票系統(tǒng)\AirTicketingSystem\.project
?????目錄???????????0??2017-10-25?16:33??民航訂票系統(tǒng)\AirTicketingSystem\.settings\
?????文件?????????522??2017-10-25?10:44??民航訂票系統(tǒng)\AirTicketingSystem\.settings\.jsdtscope
?????文件?????????120??2017-10-27?01:59??民航訂票系統(tǒng)\AirTicketingSystem\.settings\com.genuitec.eclipse.core.prefs
?????文件????????1009??2017-10-25?16:33??民航訂票系統(tǒng)\AirTicketingSystem\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件??????????57??2017-10-25?16:33??民航訂票系統(tǒng)\AirTicketingSystem\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-10-25?10:44??民航訂票系統(tǒng)\AirTicketingSystem\.settings\org.eclipse.jdt.core.prefs
?????文件?????????514??2017-10-25?16:33??民航訂票系統(tǒng)\AirTicketingSystem\.settings\org.eclipse.wst.common.component
?????文件?????????414??2017-10-25?10:44??民航訂票系統(tǒng)\AirTicketingSystem\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2017-10-25?10:44??民航訂票系統(tǒng)\AirTicketingSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-10-25?10:44??民航訂票系統(tǒng)\AirTicketingSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-10-27?16:15??民航訂票系統(tǒng)\AirTicketingSystem\src\
?????目錄???????????0??2017-10-27?01:06??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\
?????目錄???????????0??2017-10-25?18:46??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\dao\
?????文件????????4816??2017-10-25?22:58??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\dao\AirInfoDao.java
?????文件????????4072??2017-10-25?18:23??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\dao\UserDao.java
?????文件????????6838??2017-10-25?23:19??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\dao\UserOrderAirDao.java
?????目錄???????????0??2017-10-25?16:55??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\domain\
?????文件?????????992??2017-10-25?16:39??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\domain\AirInfo.java
?????文件?????????651??2017-10-25?17:00??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\domain\User.java
?????文件????????1350??2017-10-25?21:03??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\domain\UserOrderAir.java
?????目錄???????????0??2017-10-25?16:57??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\exception\
?????文件?????????507??2017-06-06?18:16??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\exception\DaoException.java
?????文件?????????507??2017-06-08?17:12??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\exception\WebException.java
?????目錄???????????0??2017-10-27?01:06??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\formbean\
?????文件?????????504??2017-10-27?01:38??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\formbean\PersonFormBean.java
?????文件????????1877??2017-10-27?01:51??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\formbean\PersonPwd.java
?????文件????????2175??2017-10-27?01:12??民航訂票系統(tǒng)\AirTicketingSystem\src\cbf\formbean\RegisterFormBean.java
............此處省略316個文件信息
評論
共有 條評論