userlogin_1.java

provide a room booking system

package Wearnes;
import java.sql.*; 
import java.util.*; 
public class UserLogin_1 {
	private Employee employee=null;
	public boolean CheckUserID(String username,String password)
	{
		boolean b=false;
		 if(username==null)
			 username="";
		 else
		 {
			WearnesDB db=new WearnesDB();
			String sql="select * from employee where name='"+username+"' and password='"+password+"'";
			
			try{
						ResultSet rs =db.select(sql);		
						if(rs.next())
					   {	//String uid,String p,String d,String r,String e,String s,String t
						//String pwd=rs.getString("password");
	//						employee=new Employee(rs.getString("name"),rs.getString("password"),rs.getString("department"),rs.getString("reportTo"),rs.getString("email"),rs.getString("securityLevel"),rs.getString("telephone"),rs.getString("fullname"));
						    b=true;
							
						}
						else
						{ System.out.println("Wrong userID or password!");
						}
				   
			   }catch(Exception e)
			   {
				   System.out.println(" Database Err");
			   }
		}
	
		return b;
	}
	public String getEmail(String username)
	{
		String email="";
		 if(username==null)
			 username="";
		 else
		 {
			WearnesDB db=new WearnesDB();
			String sql="select name,password,email,fullname from employee where name='"+username+"'";
			
			try{
					ResultSet rs =db.select(sql);		
					if(rs.next())
				   {	
						email=rs.getString("email");
						 
				   }
			   }catch(Exception e)
			   {
				   System.out.println(" Database Err");
			   }
		}
	
		return email;
	}
	public Employee getEmployee()
	{
		return employee;
	}

}