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 javax.swing.text.StyledEditorKit.BoldAction;
|
|
import com.fgkj.actions.ActionUtil;
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dao.CallBack;
|
import com.fgkj.dao.DAOHelper;
|
import com.fgkj.dao.UinfDaoFactory;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.dto.Avoid_plan;
|
import com.fgkj.dto.BattDischarge_plan;
|
import com.fgkj.dto.User_log;
|
import com.fgkj.services.User_logService;
|
|
public class Avoid_planImpl implements BaseDAO,CallBack{
|
|
public List getResults(ResultSet rs) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
public boolean add(Object obj) {
|
return false;
|
}
|
//添加规避时间
|
public boolean addPro(Object obj){
|
List<Avoid_plan> list=(List<Avoid_plan>) obj;
|
ArrayList<String> sql_str=new ArrayList<String>();
|
List<User_log> listU=new ArrayList<User_log>();//存放user_log
|
if(list!=null&&list.size()>0){
|
for(int i=0;i<list.size();i++){
|
Avoid_plan avo=list.get(i);
|
avo.setStart_month(ActionUtil.getDateMonth(avo.getStart_time()));
|
avo.setStart_day(ActionUtil.getDateday(avo.getStart_time()));
|
avo.setStop_month(ActionUtil.getDateMonth(avo.getStop_time()));
|
avo.setStop_day(ActionUtil.getDateday(avo.getStop_time()));
|
String sql="insert into web_site.tb_avoid_plan(start_time,start_month,start_day,stop_time,stop_month,stop_day) " +
|
" values("
|
+"'"+DAOHelper.sdf.format(avo.getStart_time())+"',"
|
+avo.getStart_month()+","
|
+avo.getStart_day()+","
|
+"'"+DAOHelper.sdf.format(avo.getStop_time())+"',"
|
+avo.getStop_month()+","
|
+avo.getStop_day()
|
+")";
|
sql_str.add(sql);
|
{
|
String msg="添加规避日期";
|
User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Increase, msg);
|
listU.add(ulog);
|
}
|
}
|
}
|
Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);
|
(new User_logService()).addPro(listU);//将用户的操作记录下来
|
return bl;
|
}
|
|
|
public boolean update(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
//修改规避时间
|
public boolean updatePro(Object obj) {
|
List<Avoid_plan> list=(List<Avoid_plan>) obj;
|
ArrayList<String> sql_str=new ArrayList<String>();
|
List<User_log> listU=new ArrayList<User_log>();//存放user_log
|
if(list!=null&&list.size()>0){
|
for(int i=0;i<list.size();i++){
|
Avoid_plan avo=list.get(i);
|
avo.setStart_month(ActionUtil.getDateMonth(avo.getStart_time()));
|
avo.setStart_day(ActionUtil.getDateday(avo.getStart_time()));
|
avo.setStop_month(ActionUtil.getDateMonth(avo.getStop_time()));
|
avo.setStop_day(ActionUtil.getDateday(avo.getStop_time()));
|
String sql="update web_site.tb_avoid_plan set start_time='"+DAOHelper.sdf.format(avo.getStart_time())+"',start_month="+avo.getStart_month()+",start_day="+avo.getStart_day()+" "
|
+ ",stop_time='"+DAOHelper.sdf.format(avo.getStop_time())+"',stop_month="+avo.getStop_month()+",stop_day="+avo.getStop_day()+") " ;
|
sql_str.add(sql);
|
{
|
String msg="修改规避日期";
|
User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg);
|
listU.add(ulog);
|
}
|
}
|
}
|
Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);
|
(new User_logService()).addPro(listU);//将用户的操作记录下来
|
return bl;
|
}
|
public boolean del(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
//删除规避时间
|
public boolean delPro(Object obj) {
|
List<Avoid_plan> list=(List<Avoid_plan>) obj;
|
ArrayList<String> sql_str=new ArrayList<String>();
|
List<User_log> listU=new ArrayList<User_log>();//存放user_log
|
if(list!=null&&list.size()>0){
|
for(int i=0;i<list.size();i++){
|
Avoid_plan avo=list.get(i);
|
avo.setStart_month(ActionUtil.getDateMonth(avo.getStart_time()));
|
avo.setStart_day(ActionUtil.getDateday(avo.getStart_time()));
|
avo.setStop_month(ActionUtil.getDateMonth(avo.getStop_time()));
|
avo.setStop_day(ActionUtil.getDateday(avo.getStop_time()));
|
String sql="delete from web_site.tb_avoid_plan where num="+avo.getNum() ;
|
sql_str.add(sql);
|
{
|
String msg="删除规避日期";
|
User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Delete, msg);
|
listU.add(ulog);
|
}
|
}
|
}
|
Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);
|
(new User_logService()).addPro(listU);//将用户的操作记录下来
|
return bl;
|
}
|
//显示所有
|
public List searchAll() {
|
String sql=" select * from web_site.tb_avoid_plan order by num asc ";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
Avoid_plan avo=new Avoid_plan();
|
avo.setNum(rs.getInt("num"));
|
avo.setStart_time(rs.getTimestamp("start_time"));
|
avo.setStart_month(rs.getInt("start_month"));
|
avo.setStart_day(rs.getInt("start_day"));
|
avo.setStop_time(rs.getTimestamp("stop_time"));
|
avo.setStop_month(rs.getInt("stop_month"));
|
avo.setStop_day(rs.getInt("stop_day"));
|
list.add(avo);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
public List serchByCondition(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
public List serchByInfo(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
public static void main(String[] args) throws ParseException {
|
Avoid_planImpl aipml=new Avoid_planImpl();
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date1 = sdf.parse("2000-01-01");
|
Date date2 = sdf.parse("2020-01-01");
|
|
Avoid_plan a1=new Avoid_plan();
|
a1.setStart_time(ActionUtil.getSimpDate(date1));
|
a1.setStop_time(ActionUtil.getSimpDate(date2));
|
//System.out.println(a1);
|
List list=new ArrayList();
|
list.add(a1);
|
Boolean bl=aipml.addPro(list);
|
System.out.println(bl);
|
}
|
}
|
