package com.bbs.service.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletResponse;
import com.bbs.model.User;
import com.bbs.service.UserService;
public class UserServiceImpl implements UserService {
public User userSelectByUserName(Connection con, String userName)
throws Exception {
String sql = "select * from user where userName=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, userName);
ResultSet rs = pstmt.executeQuery();
int id = 0;
String name = "";
int nameFlag = 0;
String email = "";
int emailFlag = 0;
String password = "";
String comeFrom = "";
String job = "";
String description = "";
String sign = "";
String qq = "";
String msn = "";
String image = "";
int score = 0;
int flag = 0;
String regDate;
User user = new User();
if(rs.next()){
id = rs.getInt("id");
name = rs.getString("name");
nameFlag = rs.getInt("nameFlag");
email = rs.getString("email");
emailFlag = rs.getInt("emailFlag");
password = rs.getString("password");
comeFrom = rs.getString("comeFrom");
job = rs.getString("job");
description = rs.getString("description");
sign = rs.getString("sign");
qq = rs.getString("qq");
msn = rs.getString("msn");
image = rs.getString("image");
score = rs.getInt("score");
flag = rs.getInt("flag");
regDate = rs.getString("regDate");
user.setId(id);
user.setUserName(userName);
user.setName(name);
user.setNameFlag(nameFlag);
user.setEmail(email);
user.setEmailFlag(emailFlag);
user.setPassword(password);
user.setComeFrom(comeFrom);
user.setJob(job);
user.setDescription(description);
user.setSign(sign);
user.setQq(qq);
user.setMsn(msn);
user.setImage(image);
user.setScore(score);
user.setFlag(flag);
user.setRegDate(regDate);
}
return user;
}
/*
* 用户注册
*/
public void userAdd(Connection con, String userName, String name,
String nameFlag, String email, String emailFlag, String password,
String comeFrom, String job, String description,
String sign, String qq, String msn, String image) throws Exception {
String sql = "insert into user values(null,?,?,?,?,?,?,?,?,?,?,?,?,?,?,1000,0,now())";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, userName);
pstmt.setString(2, name);
pstmt.setString(3, nameFlag);
pstmt.setString(4, email);
pstmt.setString(5, emailFlag);
pstmt.setString(6, password);
pstmt.setString(7, comeFrom);
pstmt.setString(8, job);
pstmt.setString(10, description);
pstmt.setString(11, sign);
pstmt.setString(12, qq);
pstmt.setString(13, msn);
pstmt.setString(14, image);
pstmt.execute();
}
/*
* 验证用户名是否存在
*/
public boolean userGetByUserName(Connection con, String userName)
throws Exception {
String sql = "select userName from user where userName=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, userName);
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
return true;
}else{
return false;
}
}
/*
* 添加Cookie
*/
public void addCookie(String name,String value,int maxAge,HttpServletResponse response){
Cookie cookie = new Cookie(name,value);
//设置cookie的有效时间(以秒为单位)
cookie.setMaxAge(maxAge);
//将Cookie添加到响应中,带回客户端
response.addCookie(cookie);
}
/*
* 验证用户名和密码是否正确
*/
public boolean userLogin(Connection con, String userName,String password)
throws Exception {
String sql = "select userName from user where userName=? and flag=0 and password=? ";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, userName);
pstmt.setString(2, password);
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
return true;
}else{
return false;
}
}
/*
* 修改用户信息
*/
public void userUpdate(Connection con, String userName, String name,
String nameFlag, String email, String emailFlag, String password,
String comeFrom, String job, String description,
String sign, String qq, String msn) throws Exception {
String sql = "update user set name=?,nameFlag=?,email=?,emailFlag=?,password=?,comeFrom=?,job=?,mainPage=?,description=?,sign=?,qq=?,msn=? where userName=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, nameFlag);
pstmt.setString(3, email);
pstmt.setString(4, emailFlag);
pstmt.setString(5, password);
pstmt.setString(6, comeFrom);
pstmt.setString(7, job);
pstmt.setString(9, description);
pstmt.setString(10, sign);
pstmt.setString(11, qq);
pstmt.setString(12, msn);
pstmt.setString(13, userName);
pstmt.execute();
}
public User userGetById(Connection con, String id) throws Exception {
String sql="select * from user where id=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, id);
ResultSet rs = pstmt.executeQuery();
User user = new User();
if(rs.next()){
String userName = rs.getString("userName");
String name = rs.getString("name");
int nameFlag = rs.getInt("nameFlag");
String email = rs.getString("email");
int emailFlag = rs.getInt("emailFlag");
String password = rs.getString("password");
String comeFrom = rs.getString("comeFrom");
String job = rs.getString("job");
String description = rs.getString("description");
String sign = rs.getString("sign");
String qq = rs.getString("qq");
String msn = rs.getString("msn");
String image = rs.getString("image");
int score = rs.getInt("score");
int flag = rs.getInt("flag");
String regDate = rs.getString("regDate");
user.setUserName(userName);
user.setName(name);
user.setNameFlag(nameFlag);
user.setEmail(email);
user.setEmailFlag(emailFlag);
user.setPassword(password);
user.setComeFrom(comeFrom);
user.setJob(job);
user.setDescription(description);
user.setSign(sign);
user.setQq(qq);
user.setMsn(msn);
user.setImage(image);
user.setScore(score);
user.setFlag(flag);
user.setRegDate(regDate);
}
return user;
}
/*
* 修改user表的image字段
*/
public void imageUpdate(Connection con,String userName,String path) throws Exception{
String sql = "update user set image=? where userName=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, path);
pstmt.setString(2, userName);
pstmt.execute();
}
/*
* 管理员查询user表的username字段
*/
public List selectUserName(Connection con,List list,String flag)throws Exception{
String sql = "select username,id from user where flag=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, flag);
ResultSet rs = pstmt.executeQuery();
String userName = "";
String id ="";
while(rs.next()){
User user = new User();
userName = rs.getString("username");
id = rs.getString("id");
user.setUserName(userName);
user.setId(Integer.parseInt(id));
list.add(user);
}
return list;
}
/*
* 管理员根据id修改user表的flag字段
*/
public void updateFlagByid(Connection con,String flag,String id)throws Exception{
String sql = "update user set flag=? where id=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, flag);
pstmt.setString(2, id);
pstmt.execute();
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
struts+hibernate+spring源码学习:BBS系统(6月13日上传版)
共743个文件
js:171个
gif:143个
java:108个
1星 需积分: 9 15 下载量 113 浏览量
2009-06-13
16:12:47
上传
评论
收藏 4.23MB RAR 举报
温馨提示
struts+hibernate+spring源码学习:BBS系统(6月13日上传版)
资源推荐
资源详情
资源评论
收起资源包目录
struts+hibernate+spring源码学习:BBS系统(6月13日上传版) (743个子文件)
class_upload.asp 7KB
class_upload.asp 7KB
commands.asp 5KB
upload.asp 3KB
connector.asp 3KB
io.asp 2KB
basexml.asp 2KB
config.asp 2KB
config.asp 2KB
util.asp 1KB
io.asp 836B
connector.aspx 1KB
upload.aspx 1KB
struts-config.xml.bak 4KB
error.jsp.bak 3KB
fujiama.bmp 2KB
connector.cfm 11KB
spellchecker.cfm 6KB
upload.cfm 6KB
config.cfm 3KB
config.cfm 3KB
connector.cgi 4KB
ThemeModel.class 9KB
RegisterActionForm.class 8KB
UserServiceImpl.class 7KB
ThemeDaoImpls.class 7KB
BorderModel.class 7KB
UserModel.class 7KB
UserInfoActionForm.class 6KB
BorderDaoImpls.class 5KB
RegisterAction.class 5KB
ReplyModel.class 5KB
ArticleServiceImpl.class 4KB
PlateServiceImpl.class 4KB
ReplyDaoImpls.class 4KB
UserDaoImpls.class 4KB
PICServlet.class 4KB
TopicDisplayAction.class 4KB
UserImageUpdateAction.class 4KB
TopicServiceImpl.class 4KB
SearchThemeRepliesAction.class 4KB
Theme.class 4KB
ThemeModelImpls.class 4KB
User.class 3KB
ArticleReplyActionForm.class 3KB
ArticleDisplayAction.class 3KB
UploadServiceImpl.class 3KB
User.class 3KB
LoginAction.class 3KB
Border.class 3KB
LoginAction.class 3KB
ShowThemeReplyAction.class 3KB
AddReplyAction.class 3KB
SearchAllThemeAction.class 3KB
ThemeAction.class 3KB
UserModelImpls.class 3KB
UserUpdateAction.class 3KB
ArticleReplyAction.class 3KB
FlagChangeAction.class 3KB
Reply.class 3KB
Article.class 3KB
ExitAction.class 3KB
ReplyForm.class 3KB
RegistAction.class 3KB
SearchThemeAction.class 3KB
UserSetAction.class 3KB
ReplyModelImpls.class 3KB
LoginActionForm.class 3KB
ThemeForm.class 3KB
LogExitSessionListener.class 3KB
UserManageAction.class 3KB
DeleteArticleAction.class 2KB
PlateDisplayAction.class 2KB
BorderModelImpls.class 2KB
UserForm.class 2KB
DeleteThemeAction.class 2KB
DeleteReplyAction.class 2KB
AdminLoginAction.class 2KB
SearchAllBorderAction.class 2KB
Plate.class 2KB
RemoveReplyAction.class 2KB
ModelFactory.class 2KB
PageInfo.class 2KB
AdminModel.class 2KB
DaoFactory.class 2KB
DbUtil.class 2KB
SearchBorderAction.class 2KB
BorderForm.class 2KB
LoginOutAction.class 2KB
MainBorderForm.class 2KB
EncodingFilter.class 2KB
PlateDisplayActionForm.class 1KB
CharFilter.class 1KB
Config.class 1KB
UserService.class 1KB
AdminForm.class 1KB
FlagChangeActionForm.class 1KB
NewThemeAction.class 1KB
HibernateUtil.class 1KB
UserInfoAction.class 1KB
共 743 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
- Kealuya2012-05-22程序并不完整,关键的东西没有,而且 找不到spring配置,你确定用到了spring了?
hbyufan
- 粉丝: 358
- 资源: 67
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 3349-VB一款P-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 3344-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 基于matlab车牌识别系统模板匹配方式代码24
- 用于UCAM测试bug
- 以下是一个简单的C++程序,用于生成斐波那契数列的前n项.pdf
- This work (specification and/or software implementation) and the
- python毕设基于协同过滤推荐算法的电影推荐系统源码+数据库.zip
- 基于qt+c++实现ddos小工具可用于网站压测等性能测试+源码(期末大作业&课设&项目开发)
- 该文档针对整车网络进行编写,对汽车传统CAN网络、UDS诊断、OSEK网络管理、汽车以太网、CANFD等进行了一定程度的介绍
- 基于matlab交通限速标志识别系统代码23
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功