package TrgovinaProjekt;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class InventurnaLista extends JFrame implements ActionListener{
	JFrame frame = new JFrame("Inventurna lista");
	JPanel pnl=new JPanel();
	public static JLabel[][] labels;
	public static String [][] results;
	public static int nCounter=0;
	private Statement statement;
	private ResultSet resultSet;

	//Nebitno za sad
	public static void SetTheLayout() {
		for(int i=0;i<nCounter;i++) {
			for(int j=0;j<5;j++) {
				//label[i][j].setSize(100,100);
				//labels[i][j].setText(results[i][j]);
			}
		}
	}

	public InventurnaLista() {
		frame.setSize(600,400);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frame.setResizable(false);
		//Database connection
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = null;
			conn = DriverManager.getConnection("jdbc:mysql://localhost/trgovinadoo","root", "");
			System.out.print("Database is connected!\n");
			statement=conn.createStatement();
			resultSet=statement.executeQuery("SELECT * FROM prodavaci");
			while(resultSet.next()) {
				nCounter++;
				//System.out.println(resultSet.getString(1) + " " + resultSet.getString(2) + " " + resultSet.getString(3) + " " + resultSet.getString(4));
			}
			System.out.print(nCounter);

			labels=new JLabel[nCounter][5];
			results=new String[nCounter][5];
			int i=0;
			resultSet=statement.executeQuery("SELECT * FROM prodavaci");
			while(resultSet.next()) {
				labels[i][0].setText(resultSet.getString(1));
				labels[i][1].setText(resultSet.getString(2));
				labels[i][2].setText(resultSet.getString(3));
				labels[i][3].setText(resultSet.getString(4));
				i++;
			}
			conn.close();
		}
		catch(Exception e)
		{
			System.out.print("Do not connect to DB - Error:"+e);
		}

		frame.setVisible(true);
		frame.setLocationRelativeTo(null);
	}

	//Za edit buttone
	public void actionPerformed(ActionEvent event) {

	}

	public static void main(String[] args) {
		InventurnaLista inventurnaLista=new InventurnaLista();

	}
}