package lab9;

import java.awt.BorderLayout;
import java.awt.Button;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.JToolBar;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

class Frame extends JFrame implements ActionListener{
	private JLabel IDLabel = new JLabel("ID");
	private JTextField IDText = new JTextField();

	private JLabel NumeLabel = new JLabel("Nume");
	private JTextField NumeText = new JTextField();

	private JLabel VarstaLabel = new JLabel("Varsta");
	private JTextField VarstaText = new JTextField();

	private JTextField txtAfis=new JTextField();
	public Frame(){
		super("Tabelul MySQL - persoane");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(400, 400);
		getContentPane().setLayout(new BorderLayout());
		JToolBar myBar = new JToolBar();
		getContentPane().add(myBar,BorderLayout.NORTH);
		JButton btnFirst = new JButton();
		JButton btnPrevious = new JButton();
		JButton btnNext = new JButton();
		JButton btnLast = new JButton();

		JButton btnAdd = new JButton();
		JButton btnEdit = new JButton();
		JButton btnDelete = new JButton();
		JButton btnSearch = new JButton();

		JButton btnSave = new JButton();
		JButton btnUndo = new JButton();

		btnFirst.setIcon(new ImageIcon("MoveFirst.png"));
		btnFirst.addActionListener(this);
		btnPrevious.setIcon(new ImageIcon("MovePrevious.png"));
		btnPrevious.addActionListener(this);
		btnNext.setIcon(new ImageIcon("MoveNext.png"));
		btnNext.addActionListener(this);
		btnLast.setIcon(new ImageIcon("MoveLast.png"));
		btnLast.addActionListener(this);

		btnAdd.setIcon(new ImageIcon("Add.png"));
		btnAdd.addActionListener(this);
		btnEdit.setIcon(new ImageIcon("Edit.png"));
		btnEdit.addActionListener(this);
		btnDelete.setIcon(new ImageIcon("Delete.png"));
		btnDelete.addActionListener(this);
		btnSearch.setIcon(new ImageIcon("find.jpg"));
		btnSearch.addActionListener(this);

		btnSave.setIcon(new ImageIcon("save.jpg"));
		btnSave.addActionListener(this);
		btnUndo.setIcon(new ImageIcon("undo.jpg"));
		btnUndo.addActionListener(this);
		myBar.add(btnFirst);
		myBar.add(btnPrevious);
		myBar.add(txtAfis);
		myBar.add(btnNext);
		myBar.add(btnLast);

		myBar.add(btnAdd);
		myBar.add(btnEdit);
		myBar.add(btnDelete);
		myBar.add(btnSearch);
		myBar.add(btnSave);
		myBar.add(btnUndo);

		JPanel myPanel1 = new JPanel();

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

		myPanel1.setLayout(new GridLayout(10, 3));


		myPanel1.add(IDLabel);
		myPanel1.add(IDText);

		myPanel1.add(NumeLabel);
		myPanel1.add(NumeText);

		myPanel1.add(VarstaLabel);
		myPanel1.add(VarstaText);
	}

	@Override
	public void actionPerformed(ActionEvent arg0) {
		// TODO Auto-generated method stub
		JButton source = (JButton) arg0.getSource();

		if(source.toString().contains("MoveFirst"))
		{
			try {
				this.afisFirst();
			} catch (InstantiationException | IllegalAccessException
					| ClassNotFoundException | SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else
			if(source.toString().contains("MovePrevious"))
			{

			}
			else
				if(source.toString().contains("MoveNext"))
				{

				}
				else
					if(source.toString().contains("MoveLast"))
					{
						try {
							afisLast();
						} catch (InstantiationException
								| IllegalAccessException
								| ClassNotFoundException | SQLException e) {
							// TODO Auto-generated catch block
							e.printStackTrace();
						}
					}
					else
						if(source.toString().contains("Add"))
						{

						}
						else
							if(source.toString().contains("Edit"))
							{

							}
							else
								if(source.toString().contains("Delete"))
								{

								}
								else
									if(source.toString().contains("find"))
									{

									}
									else
										if(source.toString().contains("save"))
										{

										}
										else
											if(source.toString().contains("undo"))
											{

											}
	}

	public void afisFirst() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
	{
		String url = "jdbc:mysql://localhost:3306/Lab9";
		Statement sql;
		ResultSet rs;
		Class.forName ("com.mysql.jdbc.Driver").newInstance ();
		Connection con = (Connection) DriverManager.getConnection (url, "root", "root");
		sql = (Statement) con.createStatement();
		rs = sql.executeQuery("select * from persoane");
		rs.last();
		int count = rs.getRow();
		rs.first();
		int current = rs.getInt("Id");
		txtAfis.setText(current + "/" + count);

		IDText.setText(rs.getString("Id"));
		NumeText.setText(rs.getString("nume"));
		VarstaText.setText(rs.getString("Varsta"));
		//System.out.println("id="+rs.getInt("Id")+", nume= " + rs.getString("nume")+ ", varsta="+rs.getInt(3));
		con.close();
		sql.close();
		rs.close();
	}

	public void afisLast() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
	{
		String url = "jdbc:mysql://localhost:3306/Lab9";
		Statement sql;
		ResultSet rs;
		Class.forName ("com.mysql.jdbc.Driver").newInstance ();
		Connection con = (Connection) DriverManager.getConnection (url, "root", "root");
		sql = (Statement) con.createStatement();
		rs = sql.executeQuery("select * from persoane");
		rs.last();
		int count = rs.getRow();
		int current = rs.getInt("Id");
		txtAfis.setText(current + "/" + count);

		rs.last();
		IDText.setText(rs.getString("Id"));
		NumeText.setText(rs.getString("nume"));
		VarstaText.setText(rs.getString("Varsta"));
		//System.out.println("id="+rs.getInt("Id")+", nume= " + rs.getString("nume")+ ", varsta="+rs.getInt(3));
		con.close();
		sql.close();
		rs.close();
	}
}

public class Lab9 {

	public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {
		// TODO Auto-generated method stub
//borderlayout jframe
		//nord bara de unelte
		//center panel flowlayout

		Frame myFrame = new Frame();
		myFrame.setVisible(true);

	}

}