增删改查中的查
/**
* 根据用户名和流程编号,去个性流程表查询*
* @param username
* 用户名
* @param flowId
* 流程编号
* @return 流程对象
*/
public FlowVo findPersonalityRule(String username, String flowId) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
FlowVo fv = new FlowVo();
try {
conn = DBUtil.getConnection();
String sql = "select * from SMS_MAIL_SINGLETON_FLOW where username=? and id=?";
ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, flowId);
rs = ps.executeQuery();
if (rs.next()) {
fv.setId(rs.getString("id"));
fv.setUsername(rs.getString("username"));
fv.setAdminname(rs.getString("adminname"));
fv.setWeekandtiem(rs.getString("weekandtiem"));
fv.setHolidays(rs.getString("holidays"));
fv.setSpecialday(rs.getString("specialday"));
fv.setOvertime(rs.getString("overtime"));
// fv.setPhonename(rs.getString("phonename"));
// fv.setEmail(rs.getString("email"));
fv.setPhonecontent(rs.getString("phonecontent"));
fv.setEmailcontent(rs.getString("emailcontent"));
fv.setSms(rs.getString("sms"));
fv.setMail(rs.getString("mail"));
}
} catch (Exception e) {
e.printStackTrace();
logger.error("个性规则表查询异常", e);
}
return fv;
}
/**
* 查询所有工单对象
*
* @return
*/
public List<Works> findAllWorks() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Works> list = new ArrayList<Works>();
try {
conn = DBUtil.getConnection();
// 查询工单表
String sql = "select * from bomc.works";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
Works works = new Works();
works.setUuid(rs.getString("uuid"));
works.setWorknumber(rs.getString("worknumber"));
works.setPerson(rs.getString("person"));
works.setArrivalTime(rs.getString("arrivalTime"));
works.setFlowId(rs.getString("flowId"));
list.add(works);
}
} catch (Exception e) {
e.printStackTrace();
logger.error("查询所有工单对象异常", e);
}
return list;
}