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\.mymetadata
?????文件????????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.xml
?????文件??????????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\meta-INF\
?????文件??????????36??2017-08-10?05:30??DiGui-master\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????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個文件信息