Cafe otomasyon

import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Calistir extends JFrame implements ActionListener,ListSelectionListener{
        
		JList<String>[] jlist;
        DefaultListModel<String>[] dlm;
        DefaultListModel<Integer>[] id;
        DefaultListModel<Double> fiyat;
        JTextField jtmiktar;
        JComboBox<String>[] jcb;
        String[] jlb_text= {"Masalar","Ürünler","Miktar","Fiyat","Tutar"};
        String[] btn_isim= {"Ekle","Sil","Güncelle","Adisyon","Göster"};
        Connection baglanti;
        public Calistir() {
		 this.setTitle("Cafe Otomasyon");
		 this.setSize(750, 750);
		 this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		 this.setLayout(new FlowLayout());
		 
		 JPanel main_jpn=new JPanel();
		 main_jpn.setPreferredSize(new Dimension(700,700));
		 main_jpn.setLayout(new FlowLayout());

		dlm=new DefaultListModel[jlb_text.length];
		jlist=new JList[dlm.length];
		jcb=new JComboBox[2];//
		id=new DefaultListModel[3];
		fiyat=new DefaultListModel<Double>();
		for(int i=0;i<dlm.length;i++)
		{    
			JPanel jpn=new JPanel();
			jpn.setPreferredSize(new Dimension(100,600));
			JLabel jlb=new JLabel(jlb_text[i]);
			jlb.setPreferredSize(new Dimension(100,25));
			dlm[i]=new DefaultListModel<String>();
			jlist[i]=new JList<String>(dlm[i]);
			jlist[i].addListSelectionListener(this);
			JScrollPane  jscp=new JScrollPane(jlist[i]);
			jscp.setPreferredSize(new Dimension(100,350));
			JButton jbtn=new JButton(btn_isim[i]);
			jbtn.setPreferredSize(new Dimension(100,25));
			jbtn.addActionListener(this);
			jbtn.setActionCommand(btn_isim[i]);
			jpn.add(jlb);
			jpn.add(jscp);
			if(i<jcb.length)
			{   id[i]=new DefaultListModel<Integer>();
				jcb[i]=new JComboBox<String>();
				jcb[i].setPreferredSize(new Dimension(100,25));
				jpn.add(jcb[i]);
			}
			if(i==jcb.length)
			{    id[i]=new DefaultListModel<Integer>();
				jtmiktar=new JTextField();
				jtmiktar.setPreferredSize(new Dimension(100,25));
				jpn.add(jtmiktar);
			}
			if(i>jcb.length)
			{
				JPanel bosjpn=new JPanel();
				bosjpn.setPreferredSize(new Dimension(100,25));
				jpn.add(bosjpn);
			}
			jpn.add(jbtn);
			main_jpn.add(jpn);
		}
		 combodoldur();
		 listedoldur();
		 this.add(main_jpn);
		 this.setVisible(true);
	}
  public static void main(String[] arg) {
	  new Calistir();
  }
@Override
public void actionPerformed(ActionEvent arg0) {
	switch(arg0.getActionCommand()) {
	case "Ekle":ekle();break;
	case "Sil":sil();break;
	case "Güncelle":guncelle();break;
	case "Adisyon":adisyon();break;
	case "Göster":goster();break;
	}
	
}
public void ekle() {
	int secilen_masa=jcb[0].getSelectedIndex();
	int secilen_urun=jcb[1].getSelectedIndex();
	if(secilen_masa>-1&&secilen_urun>-1&&jtmiktar.getText().length()>0) {
	try {
		double miktar=Double.parseDouble(jtmiktar.getText());
		int masa_id=id[0].getElementAt(secilen_masa);
		int urun_id=id[1].getElementAt(secilen_urun);
	   	   if(baglanti.isClosed())
			  baglan();
		   PreparedStatement sorgu=baglanti.prepareStatement("insert into Adisyon(MasaID,UrunID,Miktar) values(?,?,?)");
		   sorgu.setInt(1, masa_id);
		   sorgu.setInt(2, urun_id);
		   sorgu.setDouble(3, miktar);
		   sorgu.executeUpdate();
		   baglanti.close();
		   jtmiktar.setText("");
		   jcb[0].setSelectedIndex(0);
		   jcb[1].setSelectedIndex(0);
		   listedoldur();
	}catch(Exception ex)
	{
		JOptionPane.showMessageDialog(this, ex.getMessage());
	}
	}
}
public void sil() {
	int secilen=jlist[0].getSelectedIndex();
	if(secilen>-1) {
 	try {
 		if(baglanti.isClosed())
 			baglan();
         PreparedStatement sorgu=baglanti.prepareStatement("delete from Adisyon where ID=?");
         sorgu.setInt(1, id[2].getElementAt(secilen));
         sorgu.executeUpdate();
         baglanti.close();
         listedoldur();
	}
	catch(Exception ex)
	{
		JOptionPane.showMessageDialog(this, ex.getMessage());
	}
}
}
public void guncelle() {
	int secilen=jlist[0].getSelectedIndex();
	int secilen_masa=jcb[0].getSelectedIndex();
	int secilen_urun=jcb[1].getSelectedIndex();
	if(secilen>-1&&secilen_masa>-1&&secilen_urun>-1) {
	
		try {
			double miktar=Double.parseDouble(jtmiktar.getText());
			
			if(baglanti.isClosed())
				baglan();
		    int masa_id=id[0].getElementAt(secilen_masa);
			int urun_id=id[1].getElementAt(secilen_urun);
			int adisyon_id=id[2].getElementAt(secilen);//liste adisyon idler
		    PreparedStatement sorgu=baglanti.prepareStatement("update Adisyon set MasaID=?,UrunID=?,Miktar=? where ID=?");
			sorgu.setInt(1, masa_id);
			sorgu.setInt(2, urun_id);
			sorgu.setDouble(3, miktar);
			sorgu.setInt(4, adisyon_id);
            sorgu.executeUpdate();
            baglanti.close();
            listedoldur();
            jtmiktar.setText("");
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(this, ex.getMessage());
		}
	}	
}
public void adisyon() {
	 int secilen=jcb[0].getSelectedIndex();
		if(secilen>-1) {
		try {
			if(baglanti.isClosed())
				baglan();
	       PreparedStatement sorgu=baglanti.prepareStatement("delete from Adisyon where MasaID=?");
		   sorgu.setInt(1, id[0].getElementAt(secilen));
		   sorgu.executeUpdate();
		   baglanti.close();
		  listedoldur();
		} catch (Exception e) {
			JOptionPane.showMessageDialog(this, e.getMessage());
		}
	    
		}
    }
public void goster() {
	 int secilen=jcb[0].getSelectedIndex();
		if(secilen>-1) {
		try {
			if(baglanti.isClosed())
				baglan();
	       PreparedStatement sorgu=baglanti.prepareStatement("select u.UrunAd as 'UrunAd',(u.UrunFiyat*a.Miktar) as 'Tutar' from Adisyon a inner join Urunler u  on u.ID=a.UrunID where a.MasaID=?");
		   sorgu.setInt(1, id[0].getElementAt(secilen));
		   int sayac=0;
		   ResultSet veri=sorgu.executeQuery();
		  String urunler="";
		  double tutar=0.0;
		   while(veri.next())
		   {
			   if(urunler.length()>0)
				   urunler+=",";
			   urunler+=veri.getString("UrunAd");
			   tutar+=veri.getDouble("Tutar");
		   sayac++;
		   }
		   veri.close();
		   baglanti.close();
		   JOptionPane.showMessageDialog(this,"Ürün Sayısı="+sayac+" "+urunler+" Toplam Tutar="+tutar);
		} catch (Exception e) {
			JOptionPane.showMessageDialog(this, e.getMessage());	
			}
		}
}
public void baglan(){
 
	try {
	baglanti=DriverManager.getConnection("jdbc:sqlite:otomasyon.db");
} catch (Exception e) {
	JOptionPane.showMessageDialog(this, e.getMessage());
}	
}
public void combodoldur(){
	PreparedStatement sorgu=null;
	ResultSet veri=null;
try {
	baglan();
	sorgu=baglanti.prepareStatement("select ID,UrunAd,UrunFiyat from Urunler");
	veri=sorgu.executeQuery();
    for(int i=0;i<jcb.length;i++)
    {
    	jcb[i].removeAllItems();
    	id[i].clear();
    }
     fiyat=new DefaultListModel<Double>();
	while(veri.next())
	{
	     jcb[1].addItem(veri.getString("UrunAd"));	
	     id[1].addElement(veri.getInt("ID"));
	     fiyat.addElement(veri.getDouble("UrunFiyat"));
	}
     veri.close();
     sorgu=baglanti.prepareStatement("select ID,MasaAdi from Masalar");
     veri=sorgu.executeQuery();
     while(veri.next())
     {
    	 jcb[0].addItem(veri.getString("MasaAdi"));
    	 id[0].addElement(veri.getInt("ID"));
     }
} catch (Exception e) {
	JOptionPane.showMessageDialog(this, e.getMessage());
}
}
public void listedoldur() {
	try {
		baglan();
		String sql="select a.ID as 'ID',m.MasaAdi as 'MasaAdi',u.UrunAd as 'UrunAd',a.Miktar as 'Miktar',u.UrunFiyat as 'Fiyat',u.UrunFiyat*a.Miktar as 'Tutar'  from Masalar m inner join Adisyon  a on m.ID=a.MasaID inner join Urunler u on u.ID=a.UrunID"; 
		PreparedStatement sorgu=baglanti.prepareStatement(sql);
		for(int i=0;i<dlm.length;i++)
			dlm[i].clear();
		id[2].clear();
		ResultSet veri=sorgu.executeQuery();
		while(veri.next())
		{   id[2].addElement(veri.getInt("ID"));
			dlm[0].addElement(veri.getString("MasaAdi"));
			dlm[1].addElement(veri.getString("UrunAd"));
			double miktar=veri.getDouble("Miktar");
			dlm[2].addElement(miktar+"");
			double fiyat=veri.getDouble("Fiyat");
			dlm[3].addElement(fiyat+"");	
			double tutar=fiyat*miktar;
			dlm[4].addElement(""+tutar);
		}
		veri.close();
		baglanti.close();
	} catch (Exception e) {
		JOptionPane.showMessageDialog(this, e.getMessage());
	}
	
}
@Override
public void valueChanged(ListSelectionEvent e) {
	JList secilen=(JList)e.getSource();
	for(int i=0;i<jlist.length;i++)
		 jlist[i].setSelectedIndex(secilen.getSelectedIndex());
	
}
}