package UnimapDBConsole;

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

public class db
{
	//declarations

		public static String classname;
		public static String constring;
		Connection con;
		ResultSet rs;
		PreparedStatement st;
		String sql;
		String fullname;
		db()
		{
			classname="com.mysql.jdbc.Driver";
			constring="jdbc:mysql://10.2.17.217/unimap?user=root&password=password";
		}
		public void init()
		{
			try
			{
				Class.forName(classname);
				con=DriverManager.getConnection(constring);
				System.out.println("Connection established");
			}
			catch(Exception e)
			{System.err.println(e);}
		}
		public boolean validate(String username, String password)
		{
			try
			{
				sql = "Select fullname from users where";
				sql = sql + " username=? and password =?";
				st = con.prepareStatement(sql);
				st.setString(1, username);
				st.setString(2, password);
				rs = st.executeQuery();

				if(rs.next())
				{
					fullname = rs.getString("fullname");
					return true;
				}

				else
				{
					return false;
				}
			}

			catch (Exception e)
			{
				e.printStackTrace();
				return false;
			}
		}
}