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<User_jiejiari> 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<User_jiejiari> list=new User_jiejiariImpl().serchByCondition(u);
|
for(User_jiejiari uuu:list){
|
System.out.println(uuu);
|
}
|
}
|
}
|
