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();
}
}
bbs.rar_BBS论坛
版权申诉
152 浏览量
2022-09-14
19:32:07
上传
评论
收藏 4.21MB RAR 举报
bbs.rar_BBS论坛 （741个子文件） 
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共 741 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
