Java-2 – YO2015 – Hafta – 6
import java.awt.event.*;
import javax.swing.*;
import java.awt.*;
import java.sql.*;
public class ornek1 implements ActionListener {
JList[] jls;
DefaultListModel<String>[] dlm_str; // ad ve tip
DefaultListModel<Integer>[] dlm_int;// sayilar(gunduz, tutar,..)
JTextField jtf_ad,jtf_gunduz,jtf_puant,jtf_gece;
JComboBox<String> jcb;
DefaultListModel<Integer> cid,mid; // cid:combodan secilen tip bilgisine ait id (idfiyat)
// mid: silmek icin musteri id (idmusteri)
public ornek1() {
dlm_str=new DefaultListModel[2];
dlm_int=new DefaultListModel[5];
jls = new JList[7];
JFrame jfrm = new JFrame("Elekrik sayac tarifesi");
jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jfrm.setLayout(new GridLayout(1,7));
jfrm.setSize(750,250);
JPanel jpn = new JPanel();
JLabel jlab = new JLabel("Müşteri Adı");
dlm_str[0]= new DefaultListModel<String>(); // musteri isimleri
jls[0]= new JList<String>(dlm_str[0]);
JScrollPane jsp = new JScrollPane(jls[0]);
jsp.setPreferredSize(new Dimension(80,150));
jtf_ad= new JTextField();
jtf_ad.setPreferredSize(new Dimension(80,20));
JButton jbtn = new JButton("Ekle");
jbtn.addActionListener(this);
jbtn.setActionCommand("ekle");
jpn.add(jlab);
jpn.add(jsp);
jpn.add(jtf_ad);
jpn.add(jbtn);
jfrm.add(jpn);
jpn = new JPanel();
jlab = new JLabel("Tarife");
dlm_str[1]= new DefaultListModel<String>();
jls[1]= new JList<String>(dlm_str[1]);
jsp = new JScrollPane(jls[1]);
jsp.setPreferredSize(new Dimension(80,150));
jcb= new JComboBox<String>();
jcb.setPreferredSize(new Dimension(100,20));
jbtn = new JButton("Sil");
jbtn.addActionListener(this);
jbtn.setActionCommand("sil");
jpn.add(jlab);
jpn.add(jsp);
jpn.add(jcb);
jpn.add(jbtn);
jfrm.add(jpn);
jpn = new JPanel();
jlab = new JLabel("Gündüz");
dlm_int[0]= new DefaultListModel<Integer>();
jls[2]= new JList<Integer>(dlm_int[0]);
jsp = new JScrollPane(jls[2]);
jsp.setPreferredSize(new Dimension(80,150));
jtf_gunduz= new JTextField();
jtf_gunduz.setPreferredSize(new Dimension(80,20));
jbtn = new JButton("Güncelle");
jbtn.addActionListener(this);
jbtn.setActionCommand("guncelle");
jpn.add(jlab);
jpn.add(jsp);
jpn.add(jtf_gunduz);
jpn.add(jbtn);
jfrm.add(jpn);
jpn = new JPanel();
jlab = new JLabel("Puant");
dlm_int[1]= new DefaultListModel<Integer>();
jls[3]= new JList<Integer>(dlm_int[1]);
jsp = new JScrollPane(jls[3]);
jsp.setPreferredSize(new Dimension(80,150));
jtf_puant= new JTextField();
jtf_puant.setPreferredSize(new Dimension(80,20));
jpn.add(jlab);
jpn.add(jsp);
jpn.add(jtf_puant);
jfrm.add(jpn);
jpn = new JPanel();
jlab = new JLabel("Gece");
dlm_int[2]= new DefaultListModel<Integer>();
jls[4]= new JList<Integer>(dlm_int[2]);
jsp = new JScrollPane(jls[4]);
jsp.setPreferredSize(new Dimension(80,150));
jtf_gece= new JTextField();
jtf_gece.setPreferredSize(new Dimension(80,20));
jpn.add(jlab);
jpn.add(jsp);
jpn.add(jtf_gece);
jfrm.add(jpn);
jpn = new JPanel();
jlab = new JLabel("Tek Zamanlı");
dlm_int[3]= new DefaultListModel<Integer>();
jls[5]= new JList<Integer>(dlm_int[3]);
jsp = new JScrollPane(jls[5]);
jsp.setPreferredSize(new Dimension(80,150));
jpn.add(jlab);
jpn.add(jsp);
jfrm.add(jpn);
jpn = new JPanel();
jlab = new JLabel("Üç Zamanlı");
dlm_int[4]= new DefaultListModel<Integer>();
jls[6]= new JList<Integer>(dlm_int[4]);
jsp = new JScrollPane(jls[6]);
jsp.setPreferredSize(new Dimension(80,150));
jpn.add(jlab);
jpn.add(jsp);
jfrm.add(jpn);
verigetir();
jfrm.setVisible(true);
}
private void verigetir()
{
Connection conn = baglan();
try{
//temizlik
for(int i=0;i<dlm_str.length;i++)
dlm_str[i].removeAllElements();
for(int i=0;i<dlm_int.length;i++)
dlm_int[i].removeAllElements();
String sql_combo="select idfiyat,tip from fiyat;";
Statement st = conn.createStatement();
ResultSet rs =st.executeQuery(sql_combo);
cid= new DefaultListModel<Integer>();
jcb.removeAllItems(); // listeyi temizle
jcb.addItem("Seçiniz");
while(rs.next())
{
cid.addElement(rs.getInt("idfiyat")); // ekleme kisminda kullanilacak
jcb.addItem(rs.getString("tip"));
}
String sql_list="select idmusteri,adi,hgunduz,hpuant,hgece,tip," +
"(hgunduz+hpuant+hgece)*tekzamanli/100 as tutar1," +
"(hgunduz*gunduz+hpuant*puant+hgece*gece)/100 as tutar2" +
" from musteri inner join fiyat on tipid=idfiyat;";
mid= new DefaultListModel<Integer>(); // silmek icin kullanilacak
rs =st.executeQuery(sql_list);
while(rs.next())
{
int tutar1=rs.getInt("tutar1");
int tutar2=rs.getInt("tutar2");
mid.addElement(rs.getInt("idmusteri"));
dlm_str[0].addElement(rs.getString("adi"));
dlm_str[1].addElement(rs.getString("tip"));
dlm_int[0].addElement(rs.getInt("hgunduz"));
dlm_int[1].addElement(rs.getInt("hpuant"));
dlm_int[2].addElement(rs.getInt("hgece"));
dlm_int[3].addElement(tutar1);
dlm_int[4].addElement(tutar2);
}
}catch(Exception ex)
{
}
try{
conn.close();
}
catch(Exception ex)
{
}
}
public Connection baglan()
{
Connection conn=null;
try{
Class.forName("org.sqlite.JDBC");
conn=DriverManager.getConnection("jdbc:sqlite:ornek1.db");
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"Bağlantı Yapılamadı!","Hata",0);
}
return conn;
}
@Override
public void actionPerformed(ActionEvent ae) {
Connection conn = baglan();
if(ae.getActionCommand().equals("ekle"))
{
try{
int gunduz =Integer.parseInt(jtf_gunduz.getText());
int puant =Integer.parseInt(jtf_puant.getText());
int gece =Integer.parseInt(jtf_gece.getText());
if(jtf_ad.getText().length()>0 && jcb.getSelectedIndex()>0)
{
String sql= "insert into musteri(adi,tipid,hgunduz,hpuant,hgece)" +
" values(?,?,?,?,?);";
int tipid=cid.get(jcb.getSelectedIndex()-1);
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, jtf_ad.getText());
ps.setInt(2, tipid);
ps.setInt(3, gunduz);
ps.setInt(4, puant);
ps.setInt(5, gece);
ps.executeUpdate();
jtf_ad.setText("");
jtf_gunduz.setText("");
jtf_puant.setText("");
jtf_gece.setText("");
}
}catch(Exception ex)
{
}
}
if(ae.getActionCommand().equals("sil"))
{
try{
String sql ="delete from musteri where idmusteri=?";
int secilen=jls[0].getSelectedIndex();
if(secilen>-1)
{
int silinecek_id=mid.get(secilen); // silinecek musterinin id
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, silinecek_id);
ps.executeUpdate();
}
}catch(Exception ex)
{
}
}
if(ae.getActionCommand().equals("guncelle"))
{
try
{
int gunduz =Integer.parseInt(jtf_gunduz.getText());
int puant =Integer.parseInt(jtf_puant.getText());
int gece =Integer.parseInt(jtf_gece.getText());
int listeden_sec=jls[0].getSelectedIndex();
if(listeden_sec>-1 && jtf_ad.getText().length()>0 && jcb.getSelectedIndex()>0)
{
String sql ="update musteri set adi=?,tipid=?" +
",hgunduz=?,hpuant=?,hgece=? where idmusteri=?;";
int tipid=cid.get(jcb.getSelectedIndex()-1);
int musteri_id=mid.get(listeden_sec);
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, jtf_ad.getText());
ps.setInt(2, tipid);
ps.setInt(3, gunduz);
ps.setInt(4, puant);
ps.setInt(5, gece);
ps.setInt(6, musteri_id);
ps.executeUpdate();
jtf_ad.setText("");
jtf_gunduz.setText("");
jtf_puant.setText("");
jtf_gece.setText("");
}
}catch(Exception ex)
{
}
}
verigetir();
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
new ornek1();
}
}
