public class MainApp extends JFrame{
	/**
	 *
	 */
	private static final long serialVersionUID = 1L;
	private Connection con;
	private Statement sql;
	private ResultSet rs;
	private int rowCount;

	private JToolBar myBar;
	private JButton btnFirst;
	private JButton btnPrevious;
	private JButton btnNext;
	private JButton btnLast;
	private JButton add;
	private JButton edit;
	private JButton delete;
	private JButton find;
	private JButton save;
	private JButton undo;
	private JTextField txtAfis;

	private JTextField id;
	private JTextField nume;
	private JTextField varsta;

	public MainApp() throws Exception {
		super("JMeniu");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(400, 250);
		getContentPane().setLayout(new BorderLayout());
		connectDatabase();

		myBar = new JToolBar();

		getContentPane().add(myBar,BorderLayout.NORTH);
		btnFirst = new JButton();
		btnPrevious = new JButton();
		btnNext = new JButton();
		btnLast = new JButton();
		add = new JButton();
		edit = new JButton();
		delete = new JButton();
		find = new JButton();
		save = new JButton();
		undo = new JButton();
		txtAfis = new JTextField();
		btnFirst.setIcon(new ImageIcon("MoveFirst.png"));
		btnPrevious.setIcon(new ImageIcon("MovePrevious.png"));
		btnNext.setIcon(new ImageIcon("MoveNext.png"));
		btnLast.setIcon(new ImageIcon("MoveLast.png"));
		add.setIcon(new ImageIcon("Add.png"));
		edit.setIcon(new ImageIcon("Edit.png"));
		delete.setIcon(new ImageIcon("Delete.png"));
		find.setIcon(new ImageIcon("find.JPG"));
		save.setIcon(new ImageIcon("save.JPG"));
		undo.setIcon(new ImageIcon("undo.JPG"));
		myBar.add(btnFirst);
		myBar.add(btnPrevious);
		myBar.add(txtAfis);
		myBar.add(btnNext);
		myBar.add(btnLast);
		myBar.add(add);
		myBar.add(edit);
		myBar.add(delete);
		myBar.add(find);
		myBar.add(save);
		myBar.add(undo);

		Panel panel = new Panel();
		panel.setLayout(new FlowLayout());

		Panel panelSt = new Panel();
		panelSt.setLayout(new BoxLayout(panelSt, BoxLayout.Y_AXIS));
		panelSt.add(new JLabel("Id"));
		panelSt.add(new JLabel("Nume"));
		panelSt.add(new JLabel("Varsta"));
		panel.add(panelSt, BorderLayout.WEST);

		id = new JTextField(10);
		nume = new JTextField(10);
		varsta = new JTextField(10);

		Panel panelDr = new Panel();
		panelDr.setLayout(new BoxLayout(panelDr, BoxLayout.Y_AXIS));
		panelDr.add(id);
		panelDr.add(nume);
		panelDr.add(varsta);
		panel.add(panelDr, BorderLayout.EAST);

		rs = sql.executeQuery("select * from persoane");
		rs.last();
		rowCount = rs.getRow();
		rs.first();
		id.setText(String.valueOf(rs.getInt("Id")));
		nume.setText(String.valueOf(rs.getString("nume")));
		varsta.setText(String.valueOf(rs.getInt(3)));
		changeEditTextEnable(false);
		btnFirst.setEnabled(false);
		btnPrevious.setEnabled(false);
		save.setEnabled(false);
		undo.setEnabled(false);
		txtAfis.setText(id.getText() + " / " + rowCount);

		getContentPane().add(panel,BorderLayout.CENTER);




		btnFirst.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0){
				try
				{
					rs.first();
					id.setText(String.valueOf(rs.getInt("Id")));
					nume.setText(String.valueOf(rs.getString("nume")));
					varsta.setText(String.valueOf(rs.getInt(3)));
					btnFirst.setEnabled(false);
					btnPrevious.setEnabled(false);
					btnLast.setEnabled(true);
					btnNext.setEnabled(true);
					txtAfis.setText(id.getText() + " / " + rowCount);
				}
				catch(Exception e)
				{
					System.out.println(e.toString());
				}
			}
		});
		btnPrevious.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0){
				try
				{
					rs.previous();
					id.setText(String.valueOf(rs.getInt("Id")));
					nume.setText(String.valueOf(rs.getString("nume")));
					varsta.setText(String.valueOf(rs.getInt(3)));
					if(rs.getInt("Id") == 1)
					{
						btnFirst.setEnabled(false);
						btnPrevious.setEnabled(false);
					}
					if(rs.getInt("Id") == (rowCount - 1))
					{
						btnLast.setEnabled(true);
						btnNext.setEnabled(true);
					}
					txtAfis.setText(id.getText() + " / " + rowCount);
				}
				catch(Exception e)
				{
					System.out.println(e.toString());
				}
			}
		});
		btnNext.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0){
				try
				{
					rs.next();
					id.setText(String.valueOf(rs.getInt("Id")));
					nume.setText(String.valueOf(rs.getString("nume")));
					varsta.setText(String.valueOf(rs.getInt(3)));
					if(rs.getInt("Id") == 2)
					{
						btnFirst.setEnabled(true);
						btnPrevious.setEnabled(true);
					}
					if(rs.getInt("Id") == rowCount)
					{
						btnLast.setEnabled(false);
						btnNext.setEnabled(false);
					}
					txtAfis.setText(id.getText() + " / " + rowCount);
				}
				catch(Exception e)
				{
					System.out.println(e.toString());
				}
			}
		});
		btnLast.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0){
				try
				{
					rs.last();
					id.setText(String.valueOf(rs.getInt("Id")));
					nume.setText(String.valueOf(rs.getString("nume")));
					varsta.setText(String.valueOf(rs.getInt(3)));
					btnFirst.setEnabled(true);
					btnPrevious.setEnabled(true);
					btnLast.setEnabled(false);
					btnNext.setEnabled(false);
					txtAfis.setText(id.getText() + " / " + rowCount);
				}
				catch(Exception e)
				{
					System.out.println(e.toString());
				}
			}
		});

	}


	private void connectDatabase() {
		try
		{
			String url = "jdbc:mysql://localhost:3306/test";
			Class.forName ("com.mysql.jdbc.Driver").newInstance ();
			con = DriverManager.getConnection (url, "root", "root");
			sql = (Statement) con.createStatement();
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
	}

	private void changeEditTextEnable(boolean enable)
	{
		id.setEnabled(enable);
		nume.setEnabled(enable);
		varsta.setEnabled(enable);
	}

	public static void main(String[]args) {
		/*con.close();
		sql.close();
		rs.close();*/

		try
		{
			MainApp frm = new MainApp();
			frm.setVisible(true);
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
	}
}