資源簡介
校園快遞代拿系統(eclipse),可實現簡單的增刪改查,界面美觀友好,操作簡單,前后臺管理
數據庫部分缺少

代碼片段和文件信息
package?com.digui.algorithm;
import?java.sql.Connection;
import?java.sql.Date;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.text.DecimalFormat;
import?java.util.ArrayList;
import?com.digui.algorithm.DBConnection;
import?com.digui.algorithm.temp;
public?class?Data?{
Connection?conn;
Statement?stmt;
PreparedStatement?ps;
ResultSet?res;
static?int?user_id;
static?ArrayList?list;
static?String?dData[][]=new?String[100][];
static?Date?last_login_time=null
start_time=null
order_time=null
time=null;//比較兩個時間
static?String?avgtip;//小費
static?int?receive_num;//接單數
static?int?place_num;//下單數
static?String?num;
static?int?complainiscomplained;
static?String?customer_churn;
//先user_info從找到所有的user_id
public?ArrayList?findAllUserID(){
conn=DBConnection.getConnection();
list=new?ArrayList();
String?sql=“select?user_id?from?user_info?where?customer_churn=??or?customer_churn=?“;
try?{
ps?=?conn.prepareStatement(sql);
ps.setString(1?“是“);
ps.setString(2?“否“);
res=ps.executeQuery();
while(res.next()){
list.add(res.getInt(1));
}
conn.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?list;
}
//最后一次登錄時間
public?void?LastLoginTime(int?user_id){
conn=DBConnection.getConnection();
String?sql=“select?last_login_timecomplainiscomplainedcustomer_churn?from?user_info?where?user_id=??“;
try?{
ps=conn.prepareStatement(sql);
ps.setInt(1?user_id);
res=ps.executeQuery();
while(res.next()){
temp?t=new?temp();
t.setLast_login_time(res.getDate(1));
t.setComplain(res.getInt(2));
t.setIscomplained(res.getInt(3));
t.setCustomer_churn(res.getString(4));
last_login_time=t.getLast_login_time();
complain?=?t.getComplain();
iscomplained?=?t.getIscomplained();
customer_churn?=?t.getCustomer_churn();
}
ps.close();
conn.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
//最近一次接單時間
public?void?StartTime(int?user_id){
conn=DBConnection.getConnection();
String?sql=“select?max(start_time)?from?order_info?where?deliver_user_id=?“;//接單者接單
try?{
ps=conn.prepareStatement(sql);
ps.setInt(1?user_id);
res=ps.executeQuery();
while(res.next()){
temp?t=new?temp();
t.setStart_time(res.getDate(1));
start_time=t.getStart_time();
}
ps.close();
conn.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
//最近一次下單時間
public?void?OrderTime(int?user_id){
conn=DBConnection.getConnection();
String?sql=“select?max(start_time)?from?order_info?where?user_id=?“;//用戶下單
try?{
ps=conn.prepareStatement(sql);
ps.setInt(1?user_id);
res=ps.executeQuery();
while(res.next()){
temp?t=new?temp();
t.setOrder_time(res.getDate(1));
order_time=t.getOrder_time();
}
ps.close();
conn.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-08-10?05:30??DiGui-master\
?????文件?????????520??2017-08-10?05:30??DiGui-master\.classpath
?????文件?????????139??2017-08-10?05:30??DiGui-master\.gitignore
?????文件?????????281??2017-08-10?05:30??DiGui-master\.myme
?????文件????????1690??2017-08-10?05:30??DiGui-master\.project
?????目錄???????????0??2017-08-10?05:30??DiGui-master\.settings\
?????文件?????????488??2017-08-10?05:30??DiGui-master\.settings\.jsdtscope
?????文件?????????107??2017-08-10?05:30??DiGui-master\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????387??2017-08-10?05:30??DiGui-master\.settings\org.eclipse.jdt.core.prefs
?????文件?????????444??2017-08-10?05:30??DiGui-master\.settings\org.eclipse.wst.common.component
?????文件?????????245??2017-08-10?05:30??DiGui-master\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2017-08-10?05:30??DiGui-master\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-08-10?05:30??DiGui-master\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????????486??2017-08-10?05:30??DiGui-master\.settings\org.eclipse.wst.validation.prefs
?????文件???????????8??2017-08-10?05:30??DiGui-master\README.md
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\me
?????文件??????????36??2017-08-10?05:30??DiGui-master\WebRoot\me
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\
?????目錄???????????0??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\
?????文件????????1267??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\DBConnection.class
?????文件????????8086??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\Data.class
?????文件????????2941??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\DeTree.class
?????文件????????7078??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\DecisionTree.class
?????文件????????1704??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\TreeNode.class
?????文件????????3769??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\dataPretreatment.class
?????文件????????3604??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\getCustomerChurn.class
?????文件????????2671??2017-08-10?05:30??DiGui-master\WebRoot\WEB-INF\classes\com\digui\algorithm\printResult.class
............此處省略109個文件信息
評論
共有 條評論