package UnimapDBConsole;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class db
{
	//declarations

		public static String classname;
		public static String constring;
		Connection con;
		ResultSet rs;
		PreparedStatement st;
		String sql,fullname;
		db()
		{
			classname="com.mysql.jdbc.Driver";
			constring="jdbc:mysql://localhost/test?user=root&password=";
		}
		public void init()
		{
			try
			{
				Class.forName(classname);
				con=DriverManager.getConnection(constring);
				System.out.println("Connection established");
			}
			catch(Exception e)
			{System.out.println(e);}
		}
		public boolean validate( String username, String password)
		{
			try
			{
				sql="select fullname from users where";
				sql=sql +" username=? and passwords=?";
				st= con.prepareStatement(sql);
				st.setString(1,username);
				st.setString(2,password);
				rs=st.executeQuery();
				if(rs.next())
				{
					fullname=rs.getString(0);
					return true;
				}
				else
				{
					return false;
				}
			}
			catch (Exception e)
			{
				e.printStackTrace();
				return false;
			}
		}

}