package mydbconsoleapp;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

public class executer
{
	private BufferedReader reader;
	private users user;
	private int choice;
	public executer()
	{
		reader=new BufferedReader(new InputStreamReader(System.in));
		user=new users();
		login();
		choice=0;
	}
	public void login()
	{
		while(true)
		{
			try
			{
				clearscreen();
				System.out.println("Enter User Name");
				String username = reader.readLine();
				System.out.println("Enter Password");
				String password = reader.readLine();
				user.init();
				user.opencon();
				if(user.validate(username, password))
				{
					menu();
				}
				else
				{
					System.out.println("not validated");
					dummyinput();
				}

			}
			catch(IOException e)
			{
				e.printStackTrace();
				user.closecon();
			}
			finally
			{
				user.closecon();
			}

		}
	}
	public void menu()
	{
		do
		{
			clearscreen();
			System.out.println("Welcome !");
			System.out.println("1. Add User");
			System.out.println("2. Edit User");
			System.out.println("0. Exit");
			try
			{
				choice=Integer.parseInt(reader.readLine());
				if(choice==0)
				{
					System.out.println("Exiting...");
					dummyinput();
					break;
				}
				else if(choice==1)
				{
					adduser();
				}
				else if(choice==2)
				{

				}
				else
				{
					System.out.println("Invalid choice");
					dummyinput();
					menu();
				}
			}
			catch(Exception e)
			{
				System.out.println("Invalid choice");
				dummyinput();
			}
		}
		while(choice!=0);
	}
	public void adduser()
	{
		try
		{
			String username,password,fullname;
			clearscreen();
			System.out.println("Adding New User...");
			System.out.println("Enter User Name");
			username=reader.readLine();
			System.out.println("Enter Password");
			password=reader.readLine();
			System.out.println("Enter Fullname");
			user.init();
			user.opencon();
			fullname=reader.readLine();
			if(user.adduser(username, password, fullname))
			{
				System.out.println("User inserted..");
				dummyinput();
			}
			else
			{
				System.out.println("User insert failed..");
			}
		}
		catch(Exception e)
		{
			System.out.println("Input Error");
			dummyinput();
		}
		finally
		{
			user.closecon();
		}
	}
	public void clearscreen()
	{
		for(int k=0;k<10;k++)
		{
			System.out.println("\n");
		}
	}
	public void dummyinput()
	{
		try
		{
			reader.readLine();
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
	public static void main(String args[])
	{
		new executer();
	}
}


package mydbconsoleapp;

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

public class users extends db
{
	String sql;
	ResultSet rs;
	PreparedStatement st;
	public users()
	{
		sql=null;
		rs=null;
		st=null;
	}
	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())
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
			return false;
		}
	}
	public boolean adduser(String username, String password, String fullname) {
		try
		{
			sql="insert into users(username,password,fullname)";
			sql=sql+" values(?,?,?)";
			st=con.prepareStatement(sql);
			st.setString(1,username);
			st.setString(2,password);
			st.setString(3,fullname);
			if(st.executeUpdate()==1)
				return true;
			else
				return false;

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

}