/*
* 根据制定用户的分享记录
*/
public static List<SharedList> getSharedList(String wechatId) {
List<SharedList> list = new ArrayList<SharedList>();
String sql = "select * from shared_list where wechat_id = ?";
Connection conn = new DBUtil().getConn();
try {
ps = conn.prepareStatement(sql);
ps.setString(1, wechatId);
rs = ps.executeQuery();
while (rs.next()) {
SharedList shared = new SharedList();
shared.setFirendWechatId(rs.getString("friend_wechat_id"));
shared.setWechatId(rs.getString("wechat_id"));
shared.setGoodsId(rs.getInt("goods_id"));
list.add(shared);
}
} catch (SQLException e) {
e.printStackTrace();
return null;
} finally {
clearUp(conn);
}
return list;
}
