package problema;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import com.mysql.jdbc.Statement;
public class MainApp {

	//public static void main(String[] args) {
	// TODO Auto-generated method stub

	public static void main(String[]args) throws SQLException, InstantiationException,IllegalAccessException, ClassNotFoundException{
		String url = "jdbc:mysql://localhost:3306/test";
		Statement sql;
		ResultSet rs;
		Class.forName ("com.mysql.jdbc.Driver").newInstance ();
		Connection con = DriverManager.getConnection (url, "root", "root");
		sql = (Statement) con.createStatement();
		rs = sql.executeQuery("select * from persoane");
		while (rs.next())
			System.out.println("id="+rs.getInt("Id")+", nume= " + rs.getString("nume")+ ",varsta="+rs.getInt(3));
		con.close();
		sql.close();
		rs.close();

		MyFrame3 frm=new MyFrame3();
		frm.setVisible(true);
	}
}

class MyFrame3 extends JFrame{
	public MyFrame3(){
		super("JMeniu");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(300, 300);
		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 btnDelete=new JButton();
		JButton btnAdd=new JButton();
		JButton btnEdit=new JButton();
		JButton btnSave=new JButton();
		JButton btnFind=new JButton();
		JButton btnUndo=new JButton();
		JTextField 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"));
		btnDelete.setIcon(new ImageIcon("Delete.png"));
		btnSave.setIcon(new ImageIcon("save.jpg"));
		btnUndo.setIcon(new ImageIcon("undo.jpg"));
		btnAdd.setIcon(new ImageIcon("Add.png"));
		btnFind.setIcon(new ImageIcon("find.jpg"));
		btnEdit.setIcon(new ImageIcon("Edit.png"));

		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(btnFind);
		myBar.add(btnSave);
		myBar.add(btnUndo);



	}
}