package ru.lih.laba2;
import java.sql.*;
import java.util.*;
import javax.swing.*;

import ru.lih.laba2.Laba2.eHandler;

import java.awt.*;
import java.awt.event.*;
public class Laba2 extends JFrame{
	static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
	private static final String url="jdbc:mysql://localhost:3306/lohodeev";//подключаемся к БД
	private static final String user="root";
	private static final String password="27021998";

	private static Connection con;
	private static Statement stmt;
	private static ResultSet rs;

	public static ArrayList <String> name=new ArrayList <>();
    public static ArrayList <String> number=new ArrayList <>();
	static String[] nam=new String[name.size()];
	static String[] num=new String[number.size()];

	public static void main(String[] args){
		Laba2 l=new Laba2("Test");
		l.setVisible(true);
		l.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		l.setSize(400,500);
		l.setLocationRelativeTo(null);
	    String zapros="SELECT * FROM lih1";

	try{
		 con=DriverManager.getConnection(url,user,password);

		 stmt=con.createStatement();

		 rs=stmt.executeQuery(zapros);
		 while(rs.next()){
			 name.add(rs.getString(2));
			 number.add(rs.getString(3));
			 System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getInt(3));
		 }
		 System.out.println(name+"\n"+number);

		 int size=name.size();
		 while(size<6){
			 System.out.println("Test");
			 size++;
		 }

	}catch(SQLException sqlex){//закрываем SQL
		 sqlex.printStackTrace();
	 }finally{
		 try{con.close();}catch(SQLException sw){
		 try{stmt.close();}catch(SQLException sr){
		 try{rs.close();}catch(SQLException st){
		 }
		 }
	 }
 }
}
	 eHandler handler=new eHandler();

	    JButton na,nu;
		JTextField res;
		public Laba2(String s){
			super(s);
			setLayout(new FlowLayout());
			JButton na=new JButton("Фамилия");
			JButton nu=new JButton("Номер");
			JTextField res=new JTextField(15);
			add(res);
			add(na);
			add(nu);
			na.addActionListener(handler);
			nu.addActionListener(handler);
		}

	public class eHandler implements ActionListener{
		public void actionPerformed(ActionEvent e) {
			try{
			if(e.getSource()==na){
				res.setText("123");
    	       /*for(int i=0;i<nam.length;i++){
    	    	   res.setText(nam[i]);
    	       }*/
    	    }
			if(e.getSource()==nu){
				for(int i=0;i<num.length;i++){
					res.setText(num[i]);
				}
			}
			}catch(Exception E){};
		}
	}
}