package com.e2open.dbprogram;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class db
{
	private String classname,constring;
	protected Connection con;
	public db()
	{
		classname="com.mysql.jdbc.Driver";
		constring="jdbc:mysql://localhost/e2opendb?user=root&password=&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
	}
	public void init()
	{
		try
		{
			Class.forName(classname);
		}
		catch(ClassNotFoundException e) {e.printStackTrace();}
	}
	public void opencon()
	{
		try
		{
			con=DriverManager.getConnection(constring);
		}
		catch(SQLException e) {e.printStackTrace();}
	}
	public void closecon()
	{
		try
		{
			con.close();
		}
		catch(SQLException e) {e.printStackTrace();}
	}
}

package com.e2open.dbprogram;

public class executer
{
	public static void main(String[] args)
	{
		user u=new user();
		u.init();
		u.opencon();
		if(u.validate("selva", "password"))
			System.out.println("validated");
		else
			System.out.println("not validated");
	}
}

package com.e2open.dbprogram;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class user extends db
{
	String sql;
	ResultSet rs;
	PreparedStatement ps;
	public user()
	{
		sql=null;
		rs=null;
		ps=null;
	}
	public boolean validate(String username,String password)
	{
		try
		{
			sql="select fullname from users where username=? and password=?";
			ps=con.prepareStatement(sql);
			ps.setString(1, username);
			ps.setString(2,password);
			rs=ps.executeQuery();
			if(rs.next())
				return true;
			else
				return false;
		}
		catch(SQLException e)
		{e.printStackTrace();return false;}
		finally
		{
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}