package connect;
 
import java.sql.*;
 
public class Connect 
{ 
	private static Connection con=null;
 
	public static Connection getConnection()
	 {
    try
       {
    	Class.forName("org.gjt.mm.mysql.Driver").newInstance();	
        con =DriverManager.getConnection("jdbc:mysql://localhost:3306/rsdatabase","root","root"); 
 
	   System.out.println("Connection Established");
       return con;
       }
       catch(Exception e)
       {
    	   System.out.println("Error Loading Driver" +e);
       }
       return con;
    }	
}

package services;
import java.sql.*;
import java.io.*;
import java.util.*;
import connect.Connect;
public class login1
		{
			Vector v=null,v1=null,v2=null,v3=null,v4=null,v5=null,v6=null,v7=null,v8=null;
			Connection con=null;
	   		Statement stmt=null,stmt1=null,stmt2=null;
			ResultSet rs=null,rs1=null,rs2=null;
			PreparedStatement ps=null,ps1=null,ps2=null;
			public login1() {
				try {
					con=Connect.getConnection();			
					}
				catch(Exception e)
					{
						System.out.println("Exception:"+e);
					} 
				}	
		public boolean logincheck(String username,String password) {
			try{
					String aa="Select * from user_pass where UserName=(?) and password=(?)";
					ps=con.prepareStatement(aa);
					ps.setString(1,username);
					ps.setString(2,password);
					rs=ps.executeQuery();
					if(rs.next()){
					return true;
					}
						}
			catch(Exception s)	{
			System.out.println("Error" +s);
			}
			return false;
		}	
			public String getType(String username,String password) {
				try{
					String aa="Select * from user_pass where UserName=(?) and password=(?)";
					ps=con.prepareStatement(aa);
					ps.setString(1,username);
					ps.setString(2,password);
					rs=ps.executeQuery();
					if(rs.next()){
					return rs.getString("AccessType");
					}
						}
			catch(Exception s)	{
			System.out.println("Error" +s);
			}
			return "-";
		}
		public static void main(String args[])		{
		login1 ll=new login1();
		boolean b=ll.logincheck("admin","admin");
		System.out.println(b);
		}
		}