userinfocontrol.java

提供房屋出租信息

package cwnu.com.userData;

import java.sql.*;
import java.util.*;

import javax.sound.midi.MidiDevice.Info;
import javax.swing.JOptionPane;

import cwnu.com.dbconnect.conn;

public class userInfoControl {
	
	private Connection myconnection =null;
	private Statement myst=null;
	private ResultSet myrs=null;
	private conn myconn=null;
	private userInfoVo myInfoVo=null;
	public userInfoControl()
	{
		myconn = new conn();
	}
	
	//会员登陆验证   返回登陆者的信息对象
	public boolean isInsider(String userName,String passWord)
	{
		boolean isinsider = false;
		boolean isPwdFalse = false;
		try
		{		
		    myconnection = myconn.getConn();
		    myst = myconnection.createStatement();
		    myrs = myst.executeQuery("select * from UserInfo");
		    while(myrs.next())
		    {
		    	if(userName.equals(myrs.getString(2)))
		    	{
		    		if(passWord.equals(myrs.getString(3)))
		    		{
		    		     myInfoVo = new userInfoVo();
		    		     myInfoVo.setID(myrs.getString(1));
		    		     myInfoVo.setUserName(myrs.getString(2));
		    		     myInfoVo.setPassWord(myrs.getString(3));
		    		     myInfoVo.setPassWordQuestion(myrs.getString(4));
		    		     myInfoVo.setPassWordAnswer(myrs.getString(5));
		    		     myInfoVo.setTrueName(myrs.getString(6));
		    		     myInfoVo.setGender(myrs.getString(7));
		    		     myInfoVo.setAddress(myrs.getString(8));
		    		     myInfoVo.setTelephoneNumber(myrs.getString(9));
		    		     myInfoVo.setEmail(myrs.getString(10));
		    		     myInfoVo.setCreditCard(myrs.getString(11));
		    		     myInfoVo.setCardType(myrs.getString(12));
		    		     myInfoVo.setBirthday(myrs.getString(13));
		    		     isinsider = true;
		    		     break;
		    		}else
		    		{		    			
		    			JOptionPane.showMessageDialog(null, "密码不正确！");
		    			isPwdFalse = true;
		    			break;
		    		}
		    	}		    	

		    }
		    
		    if(!isinsider&&!isPwdFalse)
		    {
		    	JOptionPane.showMessageDialog(null, "用户名不存在");
		    }
		    myrs.close();
		    myst.close();
		    myconnection.close();
		}catch (Exception e) {
			System.out.println();
		}				
		return isinsider;
	}
	
	
	public userInfoVo reUIvo()
	{
		return myInfoVo;
	}

	public boolean checkUser(String userName)
	{
		boolean isinsider = false;
		try
		{		
		    myconnection = myconn.getConn();
		    myst = myconnection.createStatement();
		    myrs = myst.executeQuery("select * from UserInfo");
		    while(myrs.next())
		    {
		    	if(userName.equals(myrs.getString(2)))
		    	{
		    		System.out.println(myrs.getString(2));
		    		isinsider = true;
		    		break;
		    	}
		    }		    
		    myrs.close();
		    myst.close();
		    myconnection.close();
		}catch (Exception e) {
			System.out.println();
		}
		System.out.println(userName+"    "+isinsider);
		return isinsider;
	}


}