package com.fgkj.dao.impl;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
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.User_task_batt_template;
|
|
public class User_task_batt_templateImpl implements BaseDAO,CallBack{
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_task_batt_template ute=new User_task_batt_template();
|
ute.setTemplate_id(rs.getInt("template_id"));
|
ute.setTemplate_name(rs.getString("template_name"));
|
ute.setTask_batt_check_en(rs.getInt("task_batt_check_en"));
|
ute.setTask_batt_lazha_test_en(rs.getInt("task_batt_lazha_test_en"));
|
ute.setTask_batt_cap40_test_en(rs.getInt("task_batt_cap40_test_en"));
|
ute.setTask_batt_cap80_test_en(rs.getInt("task_batt_cap80_test_en"));
|
ute.setTask_param_id(rs.getInt("task_param_id"));
|
ute.setTask_battgroup_quyu_index(rs.getInt("task_battgroup_quyu_index"));
|
ute.setTask_exe_usr_selmode(rs.getInt("task_exe_usr_selmode"));
|
ute.setTask_exe_usrlunliu_count(rs.getInt("task_exe_usrlunliu_count"));
|
ute.setTask_create_mode(rs.getInt("task_create_mode"));
|
list.add(ute);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
//4.4 作业模板管理(新建模板)
|
public boolean add(Object obj) {
|
User_task_batt_template utem=(User_task_batt_template) obj;
|
String sql="insert into db_user.tb_user_task_batt_template(template_name,task_batt_check_en,task_batt_lazha_test_en," +
|
"task_batt_cap40_test_en,task_batt_cap80_test_en,task_param_id,task_battgroup_quyu_index,task_exe_usr_selmode," +
|
"task_exe_usrlunliu_count,task_create_mode) values(?,?,?,?,?,?,?,?,?,?)";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{utem.getTemplate_name(),utem.getTask_batt_check_en(),
|
utem.getTask_batt_lazha_test_en(),utem.getTask_batt_cap40_test_en(),utem.getTask_batt_cap80_test_en(),utem.getTask_param_id(),
|
utem.getTask_battgroup_quyu_index(),utem.getTask_exe_usr_selmode(),utem.getTask_exe_usrlunliu_count(),utem.getTask_create_mode()});
|
return bl;
|
}
|
//4.4 作业模板管理(修改模板/重命名)
|
public boolean update(Object obj) {
|
User_task_batt_template utem=(User_task_batt_template) obj;
|
String sql="update db_user.tb_user_task_batt_template set template_name=?,task_batt_check_en=?,task_batt_lazha_test_en=?," +
|
"task_batt_cap40_test_en=?,task_batt_cap80_test_en=?,task_param_id=?,task_battgroup_quyu_index=?,task_exe_usr_selmode=?," +
|
"task_exe_usrlunliu_count=?,task_create_mode=? where template_id=?";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{utem.getTemplate_name(),utem.getTask_batt_check_en(),
|
utem.getTask_batt_lazha_test_en(),utem.getTask_batt_cap40_test_en(),utem.getTask_batt_cap80_test_en(),utem.getTask_param_id(),
|
utem.getTask_battgroup_quyu_index(),utem.getTask_exe_usr_selmode(),utem.getTask_exe_usrlunliu_count(),utem.getTask_create_mode(),
|
utem.getTemplate_id()});
|
return bl;
|
}
|
|
//4.4 作业模板管理(修改模板/重命名)<多条修改>
|
public String updatePro(Object obj){
|
User_task_batt_template utem=(User_task_batt_template) obj;
|
String sql="update db_user.tb_user_task_batt_template set " +
|
"template_name='"+utem.getTemplate_name()+"'"+
|
",task_batt_check_en="+utem.getTask_batt_check_en()+
|
",task_batt_lazha_test_en="+utem.getTask_batt_lazha_test_en()+
|
",task_batt_cap40_test_en="+utem.getTask_batt_cap40_test_en()+
|
",task_batt_cap80_test_en="+utem.getTask_batt_cap80_test_en()+
|
",task_param_id="+utem.getTask_param_id()+
|
",task_battgroup_quyu_index="+utem.getTask_battgroup_quyu_index()+
|
",task_exe_usr_selmode="+utem.getTask_exe_usr_selmode()+
|
",task_exe_usrlunliu_count="+utem.getTask_exe_usrlunliu_count()+
|
",task_create_mode="+utem.getTask_create_mode()+
|
" where template_id="+utem.getTemplate_id();
|
//System.out.println(sql);
|
return sql;
|
}
|
|
//4.4 作业模板管理(删除)
|
public boolean del(Object obj) {
|
User_task_batt_template utem=(User_task_batt_template) obj;
|
String sql="delete from db_user.tb_user_task_batt_template where template_id=?";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{utem.getTemplate_id()});
|
return bl;
|
}
|
|
//4.4查询所有的模板
|
public List searchAll() {
|
String sql="select template_id,template_name,task_batt_check_en,task_batt_lazha_test_en," +
|
"task_batt_cap40_test_en,task_batt_cap80_test_en,task_param_id,task_battgroup_quyu_index,task_exe_usr_selmode," +
|
"task_exe_usrlunliu_count,task_create_mode from db_user.tb_user_task_batt_template";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new User_task_batt_templateImpl());
|
return list;
|
}
|
//4.4根据模板id查询模板的信息
|
public List serchByCondition(Object obj) {
|
User_task_batt_template utem=(User_task_batt_template) obj;
|
String sql="select template_id,template_name,task_batt_check_en,task_batt_lazha_test_en," +
|
"task_batt_cap40_test_en,task_batt_cap80_test_en,task_param_id,task_battgroup_quyu_index,task_exe_usr_selmode," +
|
"task_exe_usrlunliu_count,task_create_mode from db_user.tb_user_task_batt_template where template_id=?";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{utem.getTemplate_id()}, new User_task_batt_templateImpl());
|
return list;
|
}
|
|
public List serchByInfo(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
public static void main(String[] args) {
|
User_task_batt_templateImpl ut=new User_task_batt_templateImpl();
|
User_task_batt_template u=new User_task_batt_template();
|
u.setTemplate_id(100001);
|
List<User_task_batt_template> list=ut.serchByCondition(u);
|
for(User_task_batt_template uu:list){
|
System.out.println(uu);
|
}
|
/*List<User_task_batt_template> list=ut.searchAll();
|
for(User_task_batt_template uu:list){
|
System.out.println(uu);
|
}*/
|
}
|
|
}
|
