package com.niit.bbs.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import com.niit.bbs.entity.User;
public class UserDao extends AbstractDao {
public String checkAccount(String account) {
Connection connection = getConnection();
PreparedStatement ps = null;
ResultSet set = null;
String aount = null;
String sql = "select account from t_register where account = ?";
try {
ps = connection.prepareStatement(sql);
ps.setString(1, account);
set = ps.executeQuery();
while (set.next()) {
aount = set.getString(1);
}
return aount;
} catch (SQLException e) {
e.printStackTrace();
}
finally {
close(connection, ps, set);
}
return null;
}
public User save(User user) {
Connection connection = getConnection();
PreparedStatement ps = null;
ResultSet set = null;
String sql = "insert into t_register(account,password,name,sex,enjoy,contryarea,email,phonenum,qqnum,question,answer,birthday) values (?,?,?,?,?,?,?,?,?,?,?,?)";
try {
ps = connection.prepareStatement(sql,
Statement.RETURN_GENERATED_KEYS);
ps.setString(1, user.getAccount());
ps.setString(2, user.getPassword());
ps.setString(3, user.getName());
ps.setString(4, user.getSex());
ps.setString(5, user.getEnjoy());
ps.setString(6, user.getCountryArea());
ps.setString(7, user.getEmail());
ps.setString(8, user.getPhoneNum());
ps.setString(9, user.getQqNum());
ps.setString(10, user.getQuestion());
ps.setString(11, user.getAnswer());
ps.setDate(12, new java.sql.Date(user.getBirthday().getTime()));
ps.executeUpdate();
set = ps.getGeneratedKeys();
if (set.next()) {
int id = set.getInt(1);
user.setId(id);
}
} catch (SQLException e) {
e.printStackTrace();
}
finally {
close(connection, ps, set);
}
return user;
}
public User isExist(User user) {
Connection connection = getConnection();
PreparedStatement ps = null;
ResultSet set = null;
User u = null;
String sql = "select id,account,password from t_register where account = ? and password = ?";
try {
ps = connection.prepareStatement(sql);
ps.setString(1, user.getAccount());
ps.setString(2, user.getPassword());
set = ps.executeQuery();
while (set.next()) {
int id = set.getInt(1);
String account = set.getString(2);
String password = set.getString(3);
u = new User();
u.setId(id);
u.setAccount(account);
u.setPassword(password);
}
return u;
} catch (SQLException e) {
e.printStackTrace();
}
finally {
close(connection, ps, set);
}
return null;
}
public List<User> listAll() {
Connection connection = getConnection();
PreparedStatement ps = null;
ResultSet set = null;
List<User> lists = new ArrayList<User>();
String sql = "select id,account,name,sex,email,birthday from t_register";
try {
ps = connection.prepareStatement(sql);
set = ps.executeQuery();
while (set.next()) {
int id = set.getInt(1);
String account = set.getString(2);
String name = set.getString(3);
String sex = set.getString(4);
String email = set.getString(5);
Date birthday = set.getDate(6);
User user = new User();
user.setId(id);
user.setAccount(account);
user.setName(name);
user.setSex(sex);
user.setEmail(email);
user.setBirthday(birthday);
lists.add(user);
}
return lists;
} catch (SQLException e) {
e.printStackTrace();
}
finally {
close(connection, ps, set);
}
return null;
}
public User listDetail(User user) {
Connection connection = getConnection();
PreparedStatement ps = null;
ResultSet set = null;
User u = new User();
String sql = "select account,password,name,sex,enjoy,contryarea,email,phonenum,qqnum,question,answer,birthday from t_register where id = ?";
try {
ps = connection.prepareStatement(sql);
ps.setInt(1, user.getId());
set = ps.executeQuery();
while (set.next()) {
String account = set.getString(1);
String password = set.getString(2);
String name = set.getString(3);
String sex = set.getString(4);
String enjoy = set.getString(5);
String contryarea = set.getString(6);
String email = set.getString(7);
String phonenum = set.getString(8);
String qqnum = set.getString(9);
String question = set.getString(10);
String answer = set.getString(11);
Date birthday = set.getDate(12);
u.setAccount(account);
u.setPassword(password);
u.setName(name);
u.setSex(sex);
u.setEnjoy(enjoy);
u.setCountryArea(contryarea);
u.setEmail(email);
u.setPhoneNum(phonenum);
u.setQqNum(qqnum);
u.setQuestion(question);
u.setAnswer(answer);
u.setBirthday(birthday);
}
return u;
} catch (SQLException e) {
e.printStackTrace();
}
finally {
close(connection, ps, set);
}
return null;
}
public boolean delete(User user) {
Connection connection = getConnection();
PreparedStatement ps = null;
String sql = "delete from t_register where id = ?";
try {
ps = connection.prepareStatement(sql);
ps.setInt(1, user.getId());
ps.executeUpdate();
return true;
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(connection, ps, null);
}
return false;
}
public void updatePassword(User user) {
Connection connection = getConnection();
PreparedStatement ps = null;
String sql = "update t_register set password = ? where id = ?";
try {
ps = connection.prepareStatement(sql);
ps.setString(1, user.getPassword());
ps.setInt(2, user.getId());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(connection, ps, null);
}
}
}
bbs.zip_BBS用户注册_DEMO_发帖 （252个子文件） 
all-wcprops 2KB all-wcprops 2KB all-wcprops 1KB all-wcprops 730B all-wcprops 730B all-wcprops 652B all-wcprops 598B all-wcprops 598B all-wcprops 516B all-wcprops 516B all-wcprops 402B all-wcprops 366B all-wcprops 366B all-wcprops 349B all-wcprops 349B all-wcprops 292B all-wcprops 224B all-wcprops 224B all-wcprops 214B all-wcprops 210B all-wcprops 200B all-wcprops 194B all-wcprops 96B all-wcprops 93B all-wcprops 93B all-wcprops 89B all-wcprops 89B all-wcprops 84B all-wcprops 84B all-wcprops 80B all-wcprops 80B UserDao.class 7KB BBSDao.class 5KB BBSContentDao.class 5KB PageTag.class 4KB AddServlet.class 4KB BbsDetailServlet.class 3KB AddBbsContentServlet.class 3KB AddBbsServlet.class 3KB User.class 3KB LoginServlet.class 3KB MySqlDB.class 3KB AbstractPageBean.class 2KB ListServlet.class 2KB WelcomeServlet.class 2KB DeleteServlet.class 2KB ListbbsServlet.class 2KB ListDetailServlet.class 2KB BBSContent.class 2KB UserService.class 2KB BBS.class 2KB BBSContentService.class 2KB AdminFilter.class 2KB BBSService.class 2KB LoginFilter.class 2KB ExitServlet.class 1KB EncodingFilter.class 1KB SaveServlet.class 1KB LeadServlet.class 1KB AbstractDao.class 1KB JAddBbsServlet.class 1KB RegisterServlet.class 1KB DateUtil.class 1016B UserBean.class 933B WelcomeTag.class 927B PageBean.class 908B .classpath 490B user.css 301B entries 3KB entries 3KB entries 2KB entries 1003B entries 973B entries 973B entries 811B entries 811B entries 679B entries 679B entries 636B entries 549B entries 518B entries 518B entries 510B entries 510B entries 391B entries 357B entries 357B entries 353B entries 349B entries 342B entries 283B entries 283B entries 206B entries 206B entries 203B entries 202B entries 202B entries 197B entries 197B UserDao.java 8KB共 252 条
- 1
- 2
- 3
评论0