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; }