newuserdao.java

网上书城 购物车 创建SESSION等 具体网上书城 类库

package com.wl.db.dao;
import java.util.*;
import java.sql.*;

import com.wl.db.*;
import com.wl.db.vo.*;

public class NewUserDAO {
	public NewUserDAO(){};
	public void add_User(NewUser user) throws SQLException, ClassNotFoundException{
		DBManager db=new DBManager();
		String sql="insert into T_userinfo values(?,?,?,?,?,?,?,?,?,?,?)";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setString(1,user.getUerName());
		pt.setString(2,user.getPwd());
		pt.setString(3,user.getEmail());
		pt.setString(4,user.getRealName());
		pt.setBoolean(5,user.isSex());
		pt.setString(6,user.getQuestion());
		pt.setString(7,user.getAnswer());
		pt.setString(8,user.getPhone());
		pt.setString(9,user.getMypage());
		pt.setString(10,user.getHobbies());
		pt.setString(11,user.getSelfinforo());
		pt.executeUpdate();
		db.closeConnection();
	}
	public void dele_User(int id) throws SQLException, ClassNotFoundException{
		DBManager db=new DBManager();
		String sql="delete from T_userinfo where UserID=?";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setInt(1,id);
		pt.executeUpdate();
		db.closeConnection();
	}
	public void change_User(NewUser user) throws SQLException, ClassNotFoundException{
		DBManager db=new DBManager();
		String sql="update T_userinfo set UerName=?,Pwd=?,Email=?,RealName=?,Sex=?,Question=?," +
				"Answer=?,Phone=?,Mypage=?,Hobbies=?,Selfinforo=?";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setString(1,user.getUerName());
		pt.setString(2,user.getPwd());
		pt.setString(3,user.getEmail());
		pt.setString(4,user.getRealName());
		pt.setBoolean(5,user.isSex());
		pt.setString(6,user.getQuestion());
		pt.setString(7,user.getAnswer());
		pt.setString(8,user.getPhone());
		pt.setString(9,user.getMypage());
		pt.setString(10,user.getHobbies());
		pt.setString(11,user.getSelfinforo());
		pt.executeUpdate();
		db.closeConnection();
	}
	public NewUser sele_User1(String username) throws SQLException, ClassNotFoundException{
		DBManager db=new DBManager();
		NewUser user=null;
		ResultSet rs=null;
		String sql="select * from T_userinfo where UerName='"+username+"'";
		rs=db.executeQuery(sql);
		while(rs.next()){
			user=new NewUser();
			user.setUserID(rs.getInt("UserID"));
			user.setUerName(rs.getString("UerName"));
			user.setPwd(rs.getString("Pwd"));
			user.setEmail(rs.getString("Email"));
			user.setRealName(rs.getString("RealName"));
			user.setSex(rs.getBoolean("Sex"));
			user.setQuestion(rs.getString("Question"));
			user.setAnswer(rs.getString("Answer"));
			user.setPhone(rs.getString("Phone"));
			user.setMypage(rs.getString("Mypage"));
			user.setHobbies(rs.getString("Hobbies"));
			user.setSelfinforo(rs.getString("Selfinforo"));
			return user;
		}
		return null;
	}
}