package com.fgkj.dao.impl;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import com.fgkj.actions.ActionUtil;
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dao.CallBack;
|
import com.fgkj.dao.DAOHelper;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.db.IDatabaseName;
|
import com.fgkj.dto.Batt_maintenance_inf;
|
import com.fgkj.dto.Batttestdata_inf;
|
import com.mysql.fabric.xmlrpc.base.Array;
|
|
public class Batt_maintenance_infDAOImpl implements BaseDAO {
|
private SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
|
// private SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
|
public boolean add(Object obj) {
|
return false;
|
}
|
|
public boolean update(Object obj) {
|
return false;
|
}
|
|
public boolean del(Object obj) {
|
return false;
|
}
|
|
public List searchAll() {
|
String sql = "select num,BattGroupId,mon_num,fault_type,fault_time,maintenance_type,maintenance_man,maintenance_time,remark from db_battinf.tb_batt_maintenance_inf";
|
return DAOHelper.executeQuery(sql,
|
DBUtil.getConn(), null, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while (rs.next()) {
|
Batt_maintenance_inf bmi = new Batt_maintenance_inf();
|
bmi.setNum(rs.getInt("num"));
|
bmi.setBattGroupId(rs.getInt("BattGroupId"));
|
bmi.setMon_num(rs.getString("mon_num"));
|
bmi.setFault_type(rs.getString("fault_type"));
|
bmi.setFault_time(sdf.parse(rs
|
.getString("fault_time")));
|
bmi.setMaintenance_type(rs
|
.getString("maintenance_type"));
|
bmi.setMaintenance_man(rs
|
.getString("maintenance_man"));
|
bmi.setMaintenance_time(sdf.parse(rs
|
.getString("maintenance_time")));
|
bmi.setRemark(rs.getString("remark"));
|
list.add(bmi);
|
}
|
// System.out.println(list);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
}
|
|
//根据battgroupid查故障信息
|
public List serchByCondition(Object obj) {
|
Batt_maintenance_inf binf=(Batt_maintenance_inf) obj;
|
String sql=null;
|
List list=null;
|
//System.out.println(binf);
|
sql="select battgroupid,fault_type,maintenance_time from db_battinf.tb_batt_maintenance_inf where battgroupid=? and to_days(maintenance_time)>=to_days(?) and to_days(maintenance_time)<=to_days(?)";
|
list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),binf.getMaintenance_time(),binf.getMaintenance_time1()}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
Batt_maintenance_inf bminf=new Batt_maintenance_inf();
|
|
bminf.setBattGroupId(rs.getInt("BattGroupId"));
|
bminf.setFault_type(rs.getString("fault_type"));
|
bminf.setMaintenance_time(rs.getTimestamp("maintenance_time"));
|
|
list.add(bminf) ;
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
|
return list;
|
}
|
|
|
public List serchByInfo(Object obj) {
|
return null;
|
}
|
|
public static void main(String[] args) throws ParseException {
|
Batttestdata_inf bdata=new Batttestdata_inf();
|
bdata.setBattGroupId(1000001);
|
|
//bdata.setTest_type(2000);
|
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
|
Date date1= sdf.parse("2017-07-14");
|
Date date2= sdf.parse("2017-07-14");
|
bdata.setRecord_time(ActionUtil.getSimpDate(date1));
|
bdata.setRecord_time1(ActionUtil.getSimpDate(date2));
|
Batttestdata_infDAOImpl b=new Batttestdata_infDAOImpl();
|
/*List<Batttestdata_inf> list=b.serchByCondition(binf);
|
for(Batttestdata_inf bd:list){
|
System.out.println(bd);
|
}*/
|
//List<Batttestdata_inf> list=b.serchByDataNew(bdata);
|
List<Batttestdata_inf> list=b.serchByTestType3(bdata);
|
for(Batttestdata_inf bd:list){
|
System.out.println(bd);
|
}
|
System.out.println(list.size());
|
}
|
|
}
|
