inuserdao.java

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

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

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

public class InUserDAO {

	public InUserDAO() {
		// TODO Auto-generated constructor stub
	}
	public NewUser getuser(String user,String pwd) throws SQLException, ClassNotFoundException{
		
		System.out.println("xixi");
		DBManager db=new DBManager();
		ResultSet rs=null;
			String sql="select * from T_userinfo where UerName='"+user+"' and Pwd='"+pwd+"'";
			rs=db.executeQuery(sql);
			System.out.println("dd");
			NewUser user1=null;
			if(rs.next()){
				System.out.println("ee");
				user1=new NewUser();
				user1.setUerName(rs.getString("UerName"));
				user1.setPwd(rs.getString("Pwd"));
				user1.setEmail(rs.getString("Email"));
				user1.setRealName(rs.getString("RealName"));
				user1.setSex(rs.getBoolean("Sex"));
				user1.setQuestion(rs.getString("Question"));
				user1.setAnswer(rs.getString("Answer"));
				user1.setPhone(rs.getString("Phone"));
				user1.setMypage(rs.getString("Mypage"));
				user1.setHobbies(rs.getString("Hobbies"));
				user1.setSelfinforo(rs.getString("Selfinforo"));
			}
		db.closeConnection();
		return user1;
	}
public NewUser getuser1(String user) throws SQLException, ClassNotFoundException{
		
		System.out.println("xixi");
		DBManager db=new DBManager();
		ResultSet rs=null;
			String sql="select * from T_userinfo where UerName='"+user+"'";
			rs=db.executeQuery(sql);
			System.out.println("dd");
			NewUser user1=null;
			if(rs.next()){
				System.out.println("ee");
				user1=new NewUser();
				user1.setUerName(rs.getString("UerName"));
				user1.setPwd(rs.getString("Pwd"));
				user1.setEmail(rs.getString("Email"));
				user1.setRealName(rs.getString("RealName"));
				user1.setSex(rs.getBoolean("Sex"));
				user1.setQuestion(rs.getString("Question"));
				user1.setAnswer(rs.getString("Answer"));
				user1.setPhone(rs.getString("Phone"));
				user1.setMypage(rs.getString("Mypage"));
				user1.setHobbies(rs.getString("Hobbies"));
				user1.setSelfinforo(rs.getString("Selfinforo"));
			}
		db.closeConnection();
		return user1;
	}
		public NewUser showSelecteduser(String username) throws ClassNotFoundException, SQLException{
			DBManager db=new DBManager();
			String sql="select * from T_userinfo where UerName="+username+"";
			NewUser user1=new NewUser();
			ResultSet rs=db.executeQuery(sql);
			while(rs.next()){
				user1=new NewUser();
				user1.setUerName(rs.getString("UerName"));
				user1.setPwd(rs.getString("Pwd"));
				user1.setEmail(rs.getString("Email"));
				user1.setRealName(rs.getString("RealName"));
				user1.setSex(rs.getBoolean("Sex"));
				user1.setQuestion(rs.getString("Question"));
				user1.setAnswer(rs.getString("Answer"));
				user1.setPhone(rs.getString("Phone"));
				user1.setMypage(rs.getString("Mypage"));
				user1.setHobbies(rs.getString("Hobbies"));
				user1.setSelfinforo(rs.getString("Selfinforo"));
			}
			return user1;
		}
		public void Updata_user(String username,String Email,String RealName,
				boolean Sex,String Phone,String Mypage,String Selfinforo) 
		throws ClassNotFoundException, SQLException{
			DBManager db=new DBManager();
			String sql="update T_userinfo set UerName=?,Email=?,RealName=?,Sex=?," +
					"Phone=?,Mypage=?,Selfinforo=?"+
					" where UerName='"+username+"'";
			PreparedStatement pt=db.getCallableStatement(sql);
			pt.setString(1,username);
			pt.setString(2,Email );
			pt.setString(3,RealName);
			pt.setBoolean(4,Sex);
			pt.setString(5,Phone);
			pt.setString(6,Mypage);
			pt.setString(7,Selfinforo );
			pt.executeUpdate();
			db.closeConnection();
		}
		public void Updata_pwd(String username,String pwd) 
		throws ClassNotFoundException, SQLException{
			DBManager db=new DBManager();
			String sql="update T_userinfo set Pwd=?"+
					" where UerName='"+username+"'";
			PreparedStatement pt=db.getCallableStatement(sql);
			pt.setString(1,pwd);
			pt.executeUpdate();
			db.closeConnection();
		}
}