userdatabean.java

来自「采用j2ee架构做的bbs」· Java 代码 · 共 175 行

/*
 * 创建日期 2006-6-10
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.icefish.bean;

import java.sql.*;
import net.icefish.bean.Conn;
import net.icefish.bean.UserBean;
import net.icefish.bean.AdminBean;
/**
 * @author LittleChild
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class UserDataBean {
	
	private Connection conn;	
	
	public UserDataBean(){
		this.conn=Conn.connection();
	}
	
	//注册时验证用户是否已存在
	public boolean checkUser(UserBean userBean){
		boolean flag=false;
		String user_name=userBean.getUser_Name();
		Statement stmt=null;
		try{
			stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery("select * from icefish_user where user_name='"+user_name+"'");
			if(!rs.next()){
	    		flag=true;
			}else{
				flag=false;
			}
    		rs.close();
    		stmt.close();
    	//	conn.close();
		}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
		return flag;		
	}
	
	//登陆时验证用户名与密码是否能通过
	public boolean loginUser(UserBean userBean){
		boolean flag=false;
		
		String user_name=userBean.getUser_Name();
		String user_password=userBean.getUser_Password();
		Statement stmt=null;
		try{
			stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery("select * from icefish_user where user_name='"+user_name+"' and user_password='"+user_password+"'");
			if(!rs.next()){
	    		flag=false;
			}else{
//				while(rs.next()){
//					String QQ=rs.getString("user_QQ");
//					userBean.setUser_Admin(rs.getBoolean("user_admin"));
//					userBean.setUser_Age(rs.getString("user_age"));
//					userBean.setUser_Birthday(rs.getString("user_birthday"));
//					userBean.setUser_Delnum(rs.getString("user_delnum"));
//					userBean.setUser_Email(rs.getString("user_Email"));
//					userBean.setUser_Face(rs.getString("user_face"));
//					userBean.setUser_Friends(rs.getString("user_friends"));
//					userBean.setUser_Grade(rs.getString("user_grade"));
//					userBean.setUser_Group(rs.getString("user_group"));
//					userBean.setUser_ID(rs.getInt("user_id"));
//					userBean.setUser_LastIP(rs.getString("user_lastip"));
//					userBean.setUser_Lasttime(rs.getString("user_lasttime"));
//					userBean.setUser_Locked(rs.getBoolean("user_locked"));
//					userBean.setUser_Mark(rs.getString("user_mark"));
//					userBean.setUser_Password_a(rs.getString("user_password_a"));
//					userBean.setUser_Password_q(rs.getString("user_password_q"));
//					userBean.setUser_Post(rs.getString("user_post"));
//					userBean.setUser_QQ(QQ);
//					userBean.setUser_Regtime(rs.getString("user_regtime"));
//					userBean.setUser_Sex(rs.getString("user_sex"));
//					userBean.setUser_Sign(rs.getString("user_sign"));
//					userBean.setUser_Tel(rs.getString("user_tel"));
//					userBean.setUser_Topic(rs.getString("user_topic"));
//					userBean.setUser_Wealth(rs.getString("user_wealth"));
//					
//				}
				flag=true;
			}
    		rs.close();
    		stmt.close();
    		conn.close();
   		}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
		
		return flag;
		
	}
	
	
	//后台管理登陆验证
	public boolean adminLogin(AdminBean adminBean){
		boolean flag=false;
		String admin_name=adminBean.getAdmin_Name();
		String admin_password=adminBean.getAdmin_Password();
		String admin_user=adminBean.getAdmin_User();
		Statement stmt=null;
		try{
			stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery("select * from icefish_admin where admin_name='"+admin_name+"' and admin_password='"+admin_password+"' and admin_user='"+admin_user+"'");
			if(!rs.next()){
	    		flag=false;
			}else{
				flag=true;
			}
    		rs.close();
    		stmt.close();
    		conn.close();
		}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
    	
		return flag;		
	}
	
	
	
	//新用户注册
	public boolean addUser(UserBean userBean){
		boolean flag=false;
        
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("insert into icefish_user(user_name,user_password,user_password_q,user_password_a,user_sex,user_Email,user_mark,user_topic,user_wealth,user_post,user_delnum,user_regtime) values(?,?,?,?,?,?,?,?,?,?,?,now())");
    		pstmt1.setString(1, userBean.getUser_Name());
    		pstmt1.setString(2, userBean.getUser_Password());
    		pstmt1.setString(3, userBean.getUser_Password_q());
    		pstmt1.setString(4, userBean.getUser_Password_a());
    		pstmt1.setString(5, userBean.getUser_Sex());
    		pstmt1.setString(6, userBean.getUser_Email());
    		pstmt1.setInt(7, 0);
    		pstmt1.setInt(8, 0);
    		pstmt1.setInt(9, 0);
    		pstmt1.setInt(10, 0);
    		pstmt1.setInt(11, 0);
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
                flag = true;
            }
            else{
                flag = false;
            }
    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
    	
        return flag;
	}

}