?? tousenlogic.java
字號(hào):
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;
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -