@Override public List<CcnFile> listAllCcnFiles(long accountId) throws DbException { String sql = "select accountId, ccnName, time, filePath, type, size from ccnFile " + " where accountId =? or type=? order by time desc"; List<CcnFile> ret = new ArrayList<CcnFile>(); Connection conn = null; try { conn = openConnection(); PreparedStatement stmt = conn.prepareStatement(sql); stmt.setLong(1, accountId); stmt.setInt(2, CcnFile.TYPE_PUBLIC); ResultSet rs = stmt.executeQuery(); while (rs.next()) { long id = rs.getLong(1); String ccnName = rs.getString(2); java.util.Date time = new java.util.Date(rs.getTimestamp(3).getTime()); String filePath = rs.getString(4); int type = rs.getInt(5); long size = rs.getLong(6); CcnFile ccnFile = new CcnFile(); ccnFile.setAccountId(id); ccnFile.setCcnname(ccnName); ccnFile.setFilePath(filePath); ccnFile.setTime(time); ccnFile.setType(type); ccnFile.setSize(size); ret.add(ccnFile); } return ret; } catch (Exception e) { throw new DbException("listAllCcnFiles failed,accountId=" + accountId, e); } finally { if (conn != null) { closeConnection(conn); } } }
@Override public void saveCcnFile(CcnFile ccnFile) throws DbException { String sql = "replace ccnFile(accountId,ccnName,time,filePath,type,size) " + "values(?,?,?,?,?,?)"; Connection conn = null; try { conn = openConnection(); PreparedStatement stmt = conn.prepareStatement(sql); stmt.setLong(1, ccnFile.getAccountId()); stmt.setString(2, ccnFile.getCcnname()); stmt.setTimestamp(3, new Timestamp(ccnFile.getTime().getTime())); stmt.setString(4, ccnFile.getFilePath()); stmt.setInt(5, ccnFile.getType()); stmt.setLong(6, ccnFile.getSize()); stmt.executeUpdate(); } catch (Exception e) { throw new DbException("saveCcnFile failed!,ccnFile=" + ccnFile, e); } finally { closeConnection(conn); } }