java中数据持久层查询操作

来源：互联网发布：js树状结构编辑：程序博客网时间：2024/04/24 10:35

增删改查中的查

/**

   * 根据用户名和流程编号，去个性流程表查询
   *
   * @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;
   }

0 0