package com.dut.logic.logic;

import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import com.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.db.Tousen;
import com.dut.logic.util.StringUtil;
import com.mysql.jdbc.ResultSet;

public class TousenLogic {
	
	static StringUtil U2=new StringUtil();//Date Turn Method		
	
	static SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd");
	
	public static ResultSet T_select(String sq)
	{
		BatchDBConnectionUtil BU1=new BatchDBConnectionUtil();//Date Lianjie
		ResultSet rs=(ResultSet) BU1.executeQuery(sq);
		return rs;
	}
	
	public static void T_Data(String sq)
	{
		BatchDBConnectionUtil BU1=new BatchDBConnectionUtil();//Date Lianjie
		BU1.executeUpdate(sq);
	}
	
	public static ArrayList A_Search(String sq)
	{
		BatchDBConnectionUtil BU1=new BatchDBConnectionUtil();//Date Lianjie
		ResultSet rs=(ResultSet) BU1.executeQuery(sq);
		ArrayList A1=new ArrayList();
		try {
			while(rs.next())
			{
				System.out.println("333333333333333333");
				int  Tou_year=rs.getInt("nen");
				System.out.println("Tou_year"+Tou_year);
				int Tou_yeshu_id=rs.getInt("hagaki_id");
				int Tou_dengji_id=rs.getInt("toukyu_id");
				String sq1="select hagaki_mei from hagakicd where Hagaki_id="+Tou_yeshu_id;
				String sq2="select toukyu_mei from toukyucd where Toukyu_id="+Tou_dengji_id;	
				String yeshu_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq1));
				String dengji_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq2));
				String Tou_no=rs.getString("tousen_no");
				Date Tou_insert_date=rs.getDate("insert_date");
				Date Tou_update_date=rs.getDate("update_date");	

				
				Tousen tou= new Tousen();
				
				tou.setNen(Tou_year);
				tou.setHagaki_id(Tou_yeshu_id);
				tou.setHagaki_mei(yeshu_values);
				tou.setToukyu_id(Tou_dengji_id);
				tou.setToukyu_mei(dengji_values);
				tou.setTousen_no(Tou_no);
				tou.setInsert_date(Tou_insert_date);//util date
				tou.setUpdate_date(Tou_update_date);//util date
				
				A1.add(tou);
				
			}
			BU1.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return A1;
		
	}//Wai kuo hao
	
	public static ArrayList A_D(String sq)
	{
		BatchDBConnectionUtil BU1=new BatchDBConnectionUtil();//Date Lianjie
		ResultSet rs=(ResultSet)BU1.executeQuery(sq);
		ArrayList A_Cof=new ArrayList();
		try {
			while(rs.next())
			{
				System.out.println("333333333333333333");
				int  Tou_year=rs.getInt("nen");
				int Tou_yeshu_id=rs.getInt("hagaki_id");
				int Tou_dengji_id=rs.getInt("toukyu_id");
				String sq1="select hagaki_mei from hagakicd where Hagaki_id="+Tou_yeshu_id;
				String sq2="select toukyu_mei from toukyucd where Toukyu_id="+Tou_dengji_id;	
				String yeshu_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq1));
				String dengji_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq2));
				String Tou_no=rs.getString("tousen_no");
				Date Tou_insert_date=rs.getDate("insert_date");
				Date Tou_update_date=rs.getDate("update_date");	

				
				Tousen tou= new Tousen();
				
				tou.setNen(Tou_year);
				tou.setHagaki_id(Tou_yeshu_id);
				tou.setHagaki_mei(yeshu_values);
				tou.setToukyu_id(Tou_dengji_id);
				tou.setToukyu_mei(dengji_values);
				tou.setTousen_no(Tou_no);
				tou.setInsert_date(Tou_insert_date);//util date
				tou.setUpdate_date(Tou_update_date);//util date
				
				A_Cof.add(tou);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return A_Cof;
	}

}