public List<TradeMx> getJFAddMX(String uid, int page, int pageSize) {
List<TradeMx> tradeMxList = new ArrayList<TradeMx>();
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = DBUtil.getConnection();
String sql =
"select * from `ssyh_main`.`trade_mx_"
+ uid.substring(0, 1)
+ "` where `uid`=? and type in (1,2,3) limit ?,?";
ps = conn.prepareStatement(sql);
ps.setString(1, uid);
ps.setInt(2, (pageSize * (page - 1)));
ps.setInt(3, pageSize);
rs = ps.executeQuery();
while (rs.next()) {
TradeMx tradeMx = new TradeMx();
tradeMx.setDescription(rs.getString("description"));
tradeMx.setId(rs.getInt("id"));
tradeMx.setInsert_time(StringUtil.timestamp2datetime(rs.getTimestamp("insert_time")));
tradeMx.setJf_num(rs.getInt("jf_num"));
tradeMx.setStatus(rs.getInt("status"));
tradeMx.setTrade_id(rs.getString("trade_id"));
tradeMx.setType(rs.getInt("type"));
tradeMx.setUid(uid);
tradeMx.setIcon(
"http://gi2.md.alicdn.com/bao/uploaded/i2/TB1ypNbHXXXXXc1XpXXXXXXXXXX_!!0-item_pic.jpg_430x430q90.jpg");
tradeMxList.add(tradeMx);
}
} catch (SQLException e) {
logger.error("error stack", e);
} finally {
DBUtil.close(rs, ps, conn);
}
return tradeMxList;
}
