package abc;

import java.awt.BorderLayout;
import java.awt.FlowLayout;

import javax.swing.*;

import com.mysql.jdbc.Statement;

import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MyFrame extends JFrame implements ActionListener {
	public MyFrame() {
		super("Tabelul MySQL - persoane");
		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 btn5=new JButton();
		JButton btn6=new JButton();
		JButton btn7=new JButton();
		JButton btn8=new JButton();
		JButton btn9=new JButton();
		JButton btn10=new JButton();

		JPanel p = new JPanel();
		p.setLayout(new FlowLayout());
		getContentPane().add(p,BorderLayout.CENTER);

		JTextField txtAfis=new JTextField();
		JTextField txtId=new JTextField(10);
		txtId.setHorizontalAlignment(JLabel.CENTER);
		JTextField txtNume=new JTextField(10);
		txtNume.setHorizontalAlignment(JLabel.CENTER);
		JTextField txtVarsta=new JTextField(10);
		txtVarsta.setHorizontalAlignment(JLabel.CENTER);
		JLabel lblId = new JLabel("Id");
		JLabel lblNume = new JLabel("Nume");
		JLabel lblVarsta = new JLabel("Varsta");
		p.add(lblId);
		p.add(txtId);
		p.add(lblNume);
		p.add(txtNume);
		p.add(lblVarsta);
		p.add(txtVarsta);

		btnFirst.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\MoveFirst.png"));
		btnPrevious.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\MovePrevious.png"));
		btnNext.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\MoveNext.png"));
		btnLast.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\MoveLast.png"));
		btn5.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\Add.png"));
		btn6.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\Edit.png"));
		btn7.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\Delete.png"));
		btn8.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\find.jpg"));
		btn9.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\save.jpg"));
		btn10.setIcon(new ImageIcon("C:\\Users\\student\\Downloads\\Imagini\\Imagini\\undo.jpg"));


		myBar.add(btnFirst);
		myBar.add(btnPrevious);
		myBar.add(txtAfis);
		myBar.add(btnNext);
		myBar.add(btnLast);
		myBar.add(btn5);
		myBar.add(btn6);
		myBar.add(btn7);
		myBar.add(btn8);
		myBar.add(btn9);
		myBar.add(btn10);

		btnFirst.addActionListener(this);
		btnPrevious.addActionListener(this);
		btnNext.addActionListener(this);
		btnLast.addActionListener(this);
		btn5.addActionListener(this);
		btn6.addActionListener(this);
		btn7.addActionListener(this);
		btn8.addActionListener(this);
		btn9.addActionListener(this);
		btn10.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e){
		JButton source = (JButton) e.getSource();
		JTextField source2 = (JTextField) e.getSource();

		String url ="jdbc:mysql://localhost:3306/test";
		Statement sql = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance ();
		} catch (InstantiationException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		} catch (IllegalAccessException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		Connection con = null;
		try {
			con = DriverManager.getConnection(url,"root","root");
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			sql =  (Statement) con.createStatement();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			rs = sql.executeQuery("select * from persoane");
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		//try {
			//while(rs.next())
				//System.out.println("id="+rs.getInt(1)+", nume= "+ rs.getString(2)+ ",  varsta="+rs.getInt(3));
		//} catch (SQLException e1) {
	//		// TODO Auto-generated catch block
	//		e1.printStackTrace();
	//	}
		try {
			source2.setText(rs.getString("id")+" / "+ 4);
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
	}
	protected String getClassName(Object o) {
		String classString = o.getClass().getName();
		int dotIndex = classString.lastIndexOf(".");
		return classString.substring(dotIndex+1);
	}
}
package abc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;

public class L7 {
	public static void main(String[] args) throws SQLException, InstantiationException,IllegalAccessException, ClassNotFoundException{
		// TODO Auto-generated method stub
		MyFrame frm=new MyFrame();
		frm.setVisible(true);
		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();
	}

}