* @param messageId int
* @return Mail
*/
private Mail load0(int messageId)
{
Mail mail = null;
Connection con = null;
PreparedStatement statement = null;
ResultSet rset = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(RESTORE_MAIL);
statement.setInt(1, messageId);
rset = statement.executeQuery();
if (rset.next())
{
mail = new Mail();
mail.setMessageId(messageId);
mail.setSenderId(rset.getInt(1));
mail.setSenderName(rset.getString(2));
mail.setReceiverId(rset.getInt(3));
mail.setReceiverName(rset.getString(4));
mail.setExpireTime(rset.getInt(5));
mail.setTopic(rset.getString(6));
mail.setBody(rset.getString(7));
mail.setPrice(rset.getLong(8));
mail.setType(Mail.SenderType.VALUES[rset.getInt(9)]);
mail.setUnread(rset.getBoolean(10));
mail.setReturnable(rset.getBoolean(11));
mail.setSystemMsg1(rset.getInt(12));
mail.setSystemMsg2(rset.getInt(13));
DbUtils.close(statement, rset);
statement = con.prepareStatement(RESTORE_MAIL_ATTACHMENTS);
statement.setInt(1, messageId);
rset = statement.executeQuery();
ItemInstance item;
int objectId;
while (rset.next())
{
objectId = rset.getInt(1);
item = ItemsDAO.getInstance().load(objectId);
if (item != null)
{
mail.addAttachment(item);
}
}
}
}
catch (SQLException e)