destinatiiSqlJFrame

package destinatiiJFrame;

import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;

import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JTextField;

import com.mysql.jdbc.Statement;



class Fereastra extends JFrame{

	public Fereastra(String titlu){
		super(titlu);
		Toolkit t=Toolkit.getDefaultToolkit();
		Dimension d=t.getScreenSize();
		int h=d.height;
		int w=d.width;
		setSize(w/4,h/2);
		setLocation(w/4,h/4);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
}

public class destinatii {

	public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub

		String url="jdbc:mysql://localhost:3306/test";
		Statement sql;
		ResultSet rs,ts;
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		Connection con=DriverManager.getConnection(url,"root","root");
		sql=(Statement) con.createStatement();


		JFrame f = new Fereastra("Statiuni");
		f.getContentPane().setLayout(new GridLayout(8,1));

		JPanel p1 = new JPanel();
		JTextField txtAdaugare = new JTextField(40);
		p1.add(txtAdaugare);

		JPanel p2 = new JPanel();
		DefaultListModel<String> model = new DefaultListModel<>();
		JList<String> txtList = new JList<>(model);
		p2.add(txtList);

		BufferedReader fr = new BufferedReader(new InputStreamReader(System.in));
		rs=sql.executeQuery("select * from destinatii_turistice");

		while (rs.next())
			model.addElement(rs.getString("tara") + " " + rs.getString("statiune") + " "
					+ rs.getInt("nr_obiective"));

		JPanel p3 = new JPanel();
		JButton butonStergere = new JButton("Stergere statiune");
		p3.add(butonStergere);


		f.getContentPane().add(p1);
		f.getContentPane().add(p2);
		f.getContentPane().add(p3);

		f.setVisible(true);
	}
}