package com.fgkj.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.text.ParseException; import java.util.ArrayList; import java.util.List; 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.Limit; import com.fgkj.dto.User_jiejiari; public class User_jiejiariImpl implements BaseDAO,CallBack{ public List getResults(ResultSet rs) { List list=new ArrayList(); try { while(rs.next()){ User_jiejiari ujiejiari=new User_jiejiari(); ujiejiari.setNum(rs.getInt("num")); ujiejiari.setJiejiari_type(rs.getInt("jiejiari_type")); ujiejiari.setJiejiari_date(rs.getTimestamp("jiejiari_date")); ujiejiari.setNote(rs.getString("note")); list.add(ujiejiari); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } //4.3节假日管理(增加) public boolean add(Object obj) { User_jiejiari ujjr=(User_jiejiari) obj; String sql="insert into db_user.tb_user_jiejiari(jiejiari_type,jiejiari_date,note) values(?,?,?)"; Boolean bl = DAOHelper .executeUpdate( DBUtil.getConn(), sql, new Object[] {ujjr.getJiejiari_type(),ujjr.getJiejiari_date(),ujjr.getNote()}); return bl; } //4.3节假日管理(修改) public boolean update(Object obj) { User_jiejiari ujjr=(User_jiejiari) obj; String sql="update db_user.tb_user_jiejiari set jiejiari_type=?,jiejiari_date=?,note=? where num=?"; Boolean bl = DAOHelper .executeUpdate( DBUtil.getConn(), sql, new Object[] {ujjr.getJiejiari_type(),ujjr.getJiejiari_date(),ujjr.getNote(),ujjr.getNum()}); return bl; } //4.3节假日管理(删除) public boolean del(Object obj) { User_jiejiari ujjr=(User_jiejiari) obj; String sql="delete from db_user.tb_user_jiejiari where num=?"; Boolean bl = DAOHelper .executeUpdate( DBUtil.getConn(), sql, new Object[] {ujjr.getNum()}); return bl; } //查询所有的节假日 public List searchAll() { String sql="select num,jiejiari_type,jiejiari_date,note from db_user.tb_user_jiejiari"; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new User_jiejiariImpl()); return list; } //4.3根据节假日类型查询 /*0:公历 *1:农历*/ public List serchByCondition(Object obj) { User_jiejiari ujjr=(User_jiejiari) obj; String sql=""; String baseSqlT="select num,jiejiari_type,jiejiari_date,note from db_user.tb_user_jiejiari where jiejiari_type!=? order by (jiejiari_date)"; String baseSqlF="select num,jiejiari_type,jiejiari_date,note from db_user.tb_user_jiejiari where jiejiari_type=? order by (jiejiari_date)"; if(ujjr.getJiejiari_type()==100){//全部为100 sql=baseSqlT; }else{ sql=baseSqlF; } List list = DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {ujjr.getJiejiari_type()}, new User_jiejiariImpl()); return list; } public List serchByInfo(Object obj) { // TODO Auto-generated method stub return null; } public static void main(String[] args) throws ParseException { /*List list=new User_jiejiariImpl().searchAll(); for(User_jiejiari u:list){ System.out.println(u); }*/ User_jiejiari u=new User_jiejiari(); u.setJiejiari_type(0); /*u.setJiejiari_date(DAOHelper.sdf.parse("2015-10-04 00:00:00")); u.setNote("国庆节");*/ //Boolean bl=new User_jiejiariImpl().update(u); //System.out.println(bl); List list=new User_jiejiariImpl().serchByCondition(u); for(User_jiejiari uuu:list){ System.out.println(uuu); } } }