admininfo.java

提供房屋出租信息

package cwnu.com.admin;

import java.sql.*;

import javax.swing.JOptionPane;

import cwnu.com.dbconnect.conn;
import cwnu.com.userData.userInfoVo;

public class adminInfo {

	
	private Connection myconnection =null;
	private Statement myst=null;
	private ResultSet myrs=null;
	private conn myconn=null;
	private String id=null;
	
	
	public adminInfo()
	{
		myconn = new conn();
	}
	
	public String reid()
	{
		return id;
	}
	public boolean isadmin(String userName,String passWord)
	{
		boolean isadmin = false;
		boolean isPwdFalse = false;
		try
		{		
		    myconnection = myconn.getConn();
		    myst = myconnection.createStatement();
		    myrs = myst.executeQuery("select * from AdminInfo");
		    while(myrs.next())
		    {
		    	if(userName.equals(myrs.getString(2)))
		    	{
		    		if(passWord.equals(myrs.getString(3)))
		    		{
		    		     isadmin = true;
		    		     id = myrs.getString(1);
		    		     break;
		    		}else
		    		{		    			
		    			JOptionPane.showMessageDialog(null, "密码不正确！");
		    			isPwdFalse = true;
		    			break;
		    		}
		    	}
		    	
		    	

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