Esempio n. 1
0
  public List<Account> findByCondition(
      String idcardNo, String realName, String loginName, String status, int page, int pageSize)
      throws DAOException {
    // 用来封住查询条件的值
    List<Object> params = new ArrayList<Object>();
    StringBuffer sb = buildFIndSQL(idcardNo, realName, loginName, status, page, pageSize, params);
    List<Account> accs = new ArrayList<Account>();
    Connection conn = DBUtil.getConnection();
    try {
      PreparedStatement pstmt = conn.prepareStatement(sb.toString());
      for (int i = 0; i < params.size(); i++) {
        pstmt.setObject(i + 1, params.get(i));
      }
      ResultSet rs = pstmt.executeQuery();
      while (rs.next()) {
        Account a = createAccount(rs);
        accs.add(a);
      }
    } catch (Exception e) {
      e.printStackTrace();
      throw new DAOException("查询账务账户失败", e);
    } finally {
      DBUtil.closeConnection();
    }

    return accs;
  }
Esempio n. 2
0
 public Account findById(int id) throws DAOException {
   String sql = "select * from account where id=?";
   Connection conn = DBUtil.getConnection();
   try {
     PreparedStatement pstmt = conn.prepareStatement(sql);
     pstmt.setInt(1, id);
     ResultSet rs = pstmt.executeQuery();
     if (rs.next()) {
       return createAccount(rs);
     }
   } catch (Exception e) {
     e.printStackTrace();
     throw new DAOException("根据id查询账务账号信息失败!", e);
   } finally {
     DBUtil.closeConnection();
   }
   return null;
 }
Esempio n. 3
0
 public void pauseAccount(int id) throws DAOException {
   String sql = "update account set status='1',pause_date=sysdate where id=?";
   Connection conn = DBUtil.getConnection();
   try {
     conn.setAutoCommit(false);
     PreparedStatement pstmt = conn.prepareStatement(sql);
     pstmt.setInt(1, id);
     pstmt.executeUpdate();
     conn.commit();
   } catch (SQLException e) {
     e.printStackTrace();
     try {
       conn.rollback();
     } catch (SQLException e1) {
       e1.printStackTrace();
     }
     throw new DAOException("暂停账务账号失败!", e);
   } finally {
     DBUtil.closeConnection();
   }
 }
Esempio n. 4
0
  public Account findByIdcardNo(String idcardNo) throws DAOException {
    if (idcardNo == null) {
      return null;
    }
    String sql = "select * from account where idcard_no=?";
    Connection conn = DBUtil.getConnection();
    PreparedStatement pstmt;
    try {
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, idcardNo);
      ResultSet rs = pstmt.executeQuery();
      if (rs.next()) {
        return createAccount(rs);
      }
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      DBUtil.closeConnection();
    }

    return null;
  }