package com.renren.util;
import java.sql.ResultSet;
import java.sql.Date;
import java.sql.SQLException;
import java.util.ArrayList;
import com.renren.dao.UserDao;
import com.renren.dao.impl.BlogDaoImpl;
import com.renren.dao.impl.TalkDaoImpl;
import com.renren.dao.impl.UserDaoImpl;
import com.renren.entity.Blog;
import com.renren.entity.BlogBack;
import com.renren.entity.Fresh;
import com.renren.entity.Talk;
import com.renren.entity.TalkBack;
import com.renren.entity.User;
import com.renren.entity.UserImage;
public class BeanUtil {
public static User toUser(ResultSet resultSet) throws Exception {
User user ;
if(resultSet.next()){
user = new User();
user.setUserId(resultSet.getInt(1));
user.setUserName(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
user.setNickName(resultSet.getString(4));
user.setBirth(resultSet.getString(5));
user.setSex(resultSet.getString(6));
user.setStage(resultSet.getString(7));
user.setSchool(resultSet.getString(8));
user.setHeadImg(resultSet.getString(9));
user.setRegDate(resultSet.getDate(10));
return user;
}
return null;
}
public static User toUser(String userName,String password,String nickName,String birth,String sex,String stage,String school,String headImg,Date regDate){
User user = new User();
user.setUserName(userName);
user.setPassword(password);
user.setNickName(nickName);
user.setBirth(birth);
user.setSex(sex);
user.setStage(stage);
user.setSchool(school);
user.setHeadImg(headImg);
user.setRegDate(regDate);
return user;
}
public static Blog toBlog(int blogId,int userId,String title,String content,Date addDate){
Blog blog = new Blog();
blog.setBlogId(blogId);
blog.setUserId(userId);
blog.setTitle(title);
blog.setContent(content);
blog.setAddDate(addDate);
return blog;
}
public static Talk toTalk(int talkId,int userId,String content,Date addDate){
Talk talk = new Talk();
talk.setTalkId(talkId);
talk.setUserId(userId);
talk.setContent(content);
talk.setAddDate(addDate);
return talk;
}
public static Talk toTalk(ResultSet resultSet) throws Exception {
Talk talk ;
if(resultSet.next()){
talk = new Talk();
talk.setTalkId(resultSet.getInt(1));
talk.setUserId(resultSet.getInt(2));
talk.setContent(resultSet.getString(3));
talk.setAddDate(resultSet.getDate(4));
return talk;
}
return null;
}
public static Blog toBlog(ResultSet resultSet) throws Exception {
Blog blog ;
if(resultSet.next()){
blog = new Blog();
blog.setBlogId(resultSet.getInt(1));
blog.setUserId(resultSet.getInt(2));
blog.setTitle(resultSet.getString(3));
blog.setContent(resultSet.getString(4));
blog.setAddDate(resultSet.getDate(5));
return blog;
}
return null;
}
public static ArrayList<Blog> toBlogList(ResultSet resultSet) throws Exception {
ArrayList<Blog> blogList = new ArrayList<Blog>();
while(resultSet.next()){
int blogId = resultSet.getInt(1);
int userId = resultSet.getInt(2);
String title = resultSet.getString(3);
String content = resultSet.getString(4);
Date addDate =resultSet.getDate(5);
blogList.add(toBlog(blogId,userId, title, content, addDate));
}
return blogList;
}
public static ArrayList<Talk> toTalkList(ResultSet resultSet) throws SQLException {
ArrayList<Talk> talkList = new ArrayList<Talk>();
while(resultSet.next()){
int talkId = resultSet.getInt(1);
int userId = resultSet.getInt(2);
String content = resultSet.getString(3);
Date addDate =resultSet.getDate(4);
talkList.add(toTalk(talkId,userId, content, addDate));
}
return talkList;
}
public static ArrayList<BlogBack> toBlogBackList(ResultSet resultSet) throws SQLException {
ArrayList<BlogBack> blogBackList = new ArrayList<BlogBack>();
while(resultSet.next()){
int blogBackId = resultSet.getInt(1);
int blogId = resultSet.getInt(2);
String back = resultSet.getString(3);
int friendId = resultSet.getInt(4);
Date backDate =resultSet.getDate(5);
UserDao userDao = new UserDaoImpl();
User user = userDao.getUser(friendId);
blogBackList.add(toBlogBack(blogBackId,blogId, back, friendId,backDate,user));
}
return blogBackList;
}
public static ArrayList<TalkBack> toTalkBackList(ResultSet resultSet) throws SQLException {
ArrayList<TalkBack> talkBackList = new ArrayList<TalkBack>();
while(resultSet.next()){
int talkBackId = resultSet.getInt(1);
int talkId = resultSet.getInt(2);
String back = resultSet.getString(3);
int friendId = resultSet.getInt(4);
Date backDate =resultSet.getDate(5);
UserDao userDao = new UserDaoImpl();
User user = userDao.getUser(friendId);
talkBackList.add(toTalkBack(talkBackId,talkId, back, friendId,backDate,user));
}
return talkBackList;
}
public static BlogBack toBlogBack(int blogBackId, int blogId, String back,
int friendId,Date backDate,User user) {
BlogBack blogBack = new BlogBack();
blogBack.setBlogBackId(blogBackId);
blogBack.setBlogId(blogId);
blogBack.setFriendId(friendId);
blogBack.setBack(back);
blogBack.setBackDate(backDate);
blogBack.setUser(user);
return blogBack;
}
public static TalkBack toTalkBack(int talkBackId, int talkId, String back,
int friendId,Date backDate,User user) {
TalkBack talkBack = new TalkBack();
talkBack.setTalkBackId(talkBackId);
talkBack.setTalkId(talkId);
talkBack.setFriendId(friendId);
talkBack.setBack(back);
talkBack.setBackDate(backDate);
talkBack.setUser(user);
return talkBack;
}
public static ArrayList<User> toUserList(ResultSet resultSet) throws SQLException {
ArrayList<User> userList = new ArrayList<User>();
while(resultSet.next()){
int friendId = resultSet.getInt(3);
UserDao userDao = new UserDaoImpl();
User user =userDao.getUser(friendId);
userList.add(user);
}
return userList;
}
public static ArrayList<Fresh> toFreshList(ResultSet resultSet) throws SQLException {
ArrayList<Fresh> freshList = new ArrayList<Fresh>();
while(resultSet.next()){
Fresh fresh = new Fresh();
int userId = resultSet.getInt(2);
UserDaoImpl userDao = new UserDaoImpl();
fresh.setUser(userDao.getUser(userId));
fresh.setUserId(userId);
int operate = resultSet.getInt(3);
fresh.setOperate(operate);
int freshId =resultSet.getInt(4);
fresh.setFreshId(freshId);
Date addDate = resultSet.getDate(5);
String title = resultSet.getString(6);
fresh.setAddDate(addDate);
fresh.setTitle(title);
String type;
BlogDaoImpl blogDao = new BlogDaoImpl();
TalkDaoImpl talkDao = new TalkDaoImpl();
switch(operate){
case 1:
type="发表了日志";
fresh.setType(type);
fresh.setBlog(blogDao.getBlogById(freshId));
break;
case 2:
type="更新了日志";
fresh.setType(type);
fresh.setBlog(blogDao.getBlogById(freshId));
break;
case 3:
type="发表了说说";
fresh.setType(type);
fresh.setTalk(talkDao.getTalkById(freshId));
break;
case 4:
type="上传了图片";
fresh.setType(type);
break;
}
freshList.add(fresh);
}
return freshList;
}
public static ArrayList<User> toFriendList(ResultSet resultSet) throws SQLException {
ArrayList<User> friendList = new ArrayList<User>();
while(resultSet.next()){
User friend = new User();
friend.setUserId(resultSet.getInt(1));
friend.setNickName(resultSet.getString(2));
friend.setBirth(resultSet.getString(3));
friend.setSex(resultSet.getString(4));
friend.setStage(resultSet.getString(5));
friend.setSchool(resultSet.getString(6));
friend.setHeadImg(resultSet.getString(7));
friend.setRegDate(resultSet.getDate(8));
friendList.add(friend);
}
return friendList;
}
p
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
本科毕业设计,在线交友网站,JSP+Servlet+Mysql的仿人人网站,没有使用框架,界面美观,根目录下有数据库文件,加载即可运行。
资源详情
资源评论
资源推荐
收起资源包目录
renren.zip_java 毕业设计_renren_servlet_毕业设计 mysql (230个子文件)
BeanUtil.class 9KB
UserDaoImpl.class 7KB
UserImageDaoImpl.class 5KB
BlogDaoImpl.class 5KB
TalkDaoImpl.class 4KB
AddUserImageServlet.class 4KB
FreshDaoImpl.class 4KB
UpdateMyInfoServlet.class 4KB
TalkBackDaoImpl.class 3KB
BlogBackDaoImpl.class 3KB
UpdateBlogServlet.class 3KB
AddTalkServlet.class 3KB
User.class 3KB
RegisterServlet.class 3KB
AddBlogServlet.class 3KB
BlogBackServlet.class 3KB
PagingUserImageServlet.class 3KB
PagingTalkServlet.class 3KB
PagingBlogServlet.class 3KB
PagingFriendServlet.class 3KB
TalkBackServlet.class 2KB
FriendServlet.class 2KB
AddFriendServlet.class 2KB
Fresh.class 2KB
LoginServlet.class 2KB
DeleteTalkServlet.class 2KB
DeleteBlogServlet.class 2KB
ShowBlogServlet.class 2KB
ShowTalkServlet.class 2KB
UserServiceImpl.class 2KB
SearchFriendServlet.class 2KB
ShowFreshServlet.class 2KB
DeleteUserImageServlet.class 2KB
ShowUserImageServlet.class 2KB
DeleteFriendServlet.class 2KB
DBUtil.class 2KB
EditBlogServlet.class 2KB
BlogBack.class 2KB
TalkBack.class 2KB
UserImage.class 2KB
EncodeFilter.class 2KB
UserImageServiceImpl.class 1KB
BlogServiceImpl.class 1KB
TalkServiceImpl.class 1KB
Blog.class 1KB
FreshServiceImpl.class 1KB
ExitServlet.class 1KB
Test.class 1KB
Talk.class 1KB
TalkBackServiceImpl.class 1KB
BlogBackServiceImpl.class 1KB
UserService.class 766B
UserDao.class 754B
UserImageService.class 538B
UserImageDao.class 526B
BlogService.class 489B
BlogDao.class 477B
TalkService.class 468B
TalkDao.class 456B
FreshService.class 443B
FreshDao.class 431B
TalkBackService.class 351B
BlogBackService.class 351B
TalkBackDao.class 339B
BlogBackDao.class 339B
.classpath 1KB
org.eclipse.wst.jsdt.ui.superType.container 49B
blue_large.gif 2KB
matter-logo2.gif 908B
popup_plus.gif 817B
Vipdraw.gif 624B
L075439863530HUA.gif 615B
L074547241570HUA.gif 613B
blog.gif 596B
L979177294353SJS.gif 589B
mention.gif 419B
LJjvJ228m018153.gif 380B
LmkKV204b018153.gif 370B
corner.gif 309B
L1u6T231n018153.gif 243B
across.gif 219B
account.gif 216B
edit_profile.gif 159B
matter-logo.gif 127B
a.gif 43B
freemarker-2.3.19.jar 909KB
struts2-core-2.3.4.1.jar 765KB
mysql-connector-java-5.1.13-bin.jar 750KB
xwork-core-2.3.4.1.jar 614KB
javassist-3.11.0.GA.jar 600KB
commons-lang3-3.1.jar 308KB
ognl-3.0.5.jar 222KB
commons-io-2.0.1.jar 156KB
commons-fileupload-1.2.2.jar 58KB
asm-3.3.jar 43KB
asm-commons-3.3.jar 37KB
asm-tree-3.3.jar 21KB
BeanUtil.java 9KB
UserDaoImpl.java 7KB
UserImageDaoImpl.java 5KB
共 230 条
- 1
- 2
- 3
weixin_42653672
- 粉丝: 93
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1