Jsp+JavaBean+Struts1.2+MySQL5.0购物网

package com.shop.Beans; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Date; import org.apache.struts.action.DynaActionForm; import com.shop.DB.DBConnection; public class UserBean { private Connection conn; public UserBean() { conn = DBConnection.getDBConnection(); } //得到所有注册用户的信息 public ResultSet getAllUsers() { ResultSet rs = null; String sql = "select * from user"; try { Statement stat = conn.createStatement(); rs = stat.executeQuery(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } //根据用户名删除用户信息 public int DeleUser(String username) { int temp = 0; String sql = "delete from user where Username = '"+username+"' "; try { Statement stat = conn.createStatement(); temp = stat.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return temp; } //根据用户名得到用户信息 public ResultSet getUserInfoByName(String name) { ResultSet rs = null; String sql = "select * from user where Username='"+name+"'"; try { Statement stat = conn.createStatement(); rs = stat.executeQuery(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } //添加新用户 public int addUser(DynaActionForm df) { int temp = 0; Date date = new Date(); String sql = "insert into user values(default,?,?,?,?,?,?,?,?,?)"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, (String)df.get("username")); ps.setString(2, (String)df.get("Rname")); ps.setString(3, (String)df.get("password")); ps.setString(4, (String)df.get("email")); ps.setString(5, (String)df.get("address")); ps.setString(6, (String)df.get("photo")); ps.setString(7, (String)df.get("pass")); ps.setString(8, (String)df.get("question")); ps.setString(9, date.toLocaleString()); temp = ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return temp; } //更新用户信息 public int UserUpdate(DynaActionForm df) { int temp = 0; String sql = "update user set Username=?,Userpass=?,Email=?,Address=?,Photo=?,Question=?,Result=?"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, df.getString("username")); ps.setString(2, df.getString("password")); ps.setString(3, df.getString("email")); ps.setString(4, df.getString("address")); ps.setString(5, df.getString("photo")); ps.setString(6, df.getString("pass")); ps.setString(7, df.getString("question")); temp = ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return temp; } //找回密码 public ResultSet GetPass(DynaActionForm df) { ResultSet rs = null; String sql = "select * from user where Username=? and Email=? and Question=? and Result=?"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, df.getString("username")); ps.setString(2, df.getString("email")); ps.setString(3, df.getString("question")); ps.setString(4, df.getString("result")); rs = ps.executeQuery(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } }