JTextField – oflazoglu.org

Etiket: JTextField

Java-2 2016 Hafta-8 Örnek-1

Posted on 31 Mart 2016 by

caglar Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi — Henüz Yorum Yapılmadı ↓

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

public class gelirvergisi implements ActionListener {

	JList[] jl;
	DefaultListModel[] dlm;
	JComboBox jcb;
	JTextField jtf_gelirtop,jtf_yenigelir;
	JRadioButton jrb_ocak,jrb_temmuz;
	
	public gelirvergisi() {
		
		JFrame jfrm = new JFrame("Gelir Vergisi - 2016");
		jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		jfrm.setLayout(new GridLayout(1,5));
		jfrm.setSize(500, 250);
		
		JPanel[] jpn = new JPanel[5];
		jl= new JList[5];
		dlm=new DefaultListModel[5];
		String[] baslik={"İsim","Gelir Top.","Yeni Gelir","Dönem","Vergi"};
		
		for(int i =0; i<jpn.length;i++)
		{
			jpn[i]= new JPanel();
			jpn[i].setPreferredSize(new Dimension(95, 295));
			dlm[i]= new DefaultListModel();
			jl[i]=new JList(dlm[i]);
			JScrollPane jscp= new JScrollPane(jl[i]);
			jscp.setPreferredSize(new Dimension(90,160));
			JLabel jlab = new JLabel(baslik[i]);
			jpn[i].add(jlab);
			jpn[i].add(jscp); // jlist panele eklendi
			
			jfrm.add(jpn[i]);
		}
		
		//1. sutun eklemeleri
		String[] isimler ={"Seçiniz","Ahmet","Mustafa","Metin","Ayse","Fatma"};
		jcb= new JComboBox(isimler);
		jcb.setPreferredSize(new Dimension(90,25));
		jpn[0].add(jcb);
		JButton jbtn1= new JButton("Ekle");
		jbtn1.addActionListener(this);
		jbtn1.setActionCommand("ekle"); // buton etiketi
		jbtn1.setPreferredSize(new Dimension(90,25));
		jpn[0].add(jbtn1);
		
		//2. sutun
		jtf_gelirtop= new JTextField();
		jtf_gelirtop.setPreferredSize(new Dimension(90,25));
		jpn[1].add(jtf_gelirtop);
		JButton jbtn2= new JButton("Sil");
		jbtn2.addActionListener(this);
		jbtn2.setPreferredSize(new Dimension(90,25));
		jpn[1].add(jbtn2);
		
		//3.sutun
		jtf_yenigelir= new JTextField();
		jtf_yenigelir.setPreferredSize(new Dimension(90,25));
		jpn[2].add(jtf_yenigelir);
		
		//4. sutun
		ButtonGroup bg = new ButtonGroup();
		jrb_ocak = new JRadioButton("Ocak");
		jrb_ocak.setSelected(true);
		jrb_temmuz = new JRadioButton("Temmuz");
		bg.add(jrb_ocak);
		bg.add(jrb_temmuz);
		JPanel jpn4_1 = new JPanel();
		JPanel jpn4_2 = new JPanel();
		jpn4_1.setLayout(new FlowLayout(FlowLayout.LEFT));
		jpn4_2.setLayout(new FlowLayout(FlowLayout.LEFT));
		jpn4_1.setPreferredSize(new Dimension(90,25));
		jpn4_2.setPreferredSize(new Dimension(90,25));
		jpn4_1.add(jrb_ocak);
		jpn4_2.add(jrb_temmuz);
		jpn[3].add(jpn4_1);
		jpn[3].add(jpn4_2);
		jfrm.setVisible(true);
	}
	@Override
	public void actionPerformed(ActionEvent ae) {
		if(ae.getActionCommand().equals("ekle"))
		{
			// ekle
			int secilen_isim = jcb.getSelectedIndex();
			int donem=0;
			if(jrb_temmuz.isSelected())
				donem=1;
			
			double mevcutgelir,yenigelir;
			try{
				if(secilen_isim>0 && jtf_gelirtop.getText().length()>0 && 
						jtf_yenigelir.getText().length()>0 ){
					
				mevcutgelir=Double.parseDouble(jtf_gelirtop.getText());
				yenigelir=Double.parseDouble(jtf_yenigelir.getText());
				
				String[] donemler={"Ocak","Temmuz"};
				double vergi=vergihesapla(mevcutgelir, yenigelir, donem);
				
				dlm[0].addElement(jcb.getSelectedItem()); // isim
				dlm[1].addElement(mevcutgelir); // gelir top.
				dlm[2].addElement(yenigelir); // yeni gelir
				dlm[3].addElement(donemler[donem]); // donem
				dlm[4].addElement(vergi); // vergi
				
				jcb.setSelectedIndex(0);
				jtf_gelirtop.setText("");
				jtf_yenigelir.setText("");
				jrb_ocak.setSelected(true);
				}	
			}catch(Exception ex)
			{
				
			}
		}
		else
		{
			int secilen = jl[0].getSelectedIndex();
			if(secilen>-1)
			{
				for(int i=0;i<dlm.length;i++)
				{
					dlm[i].remove(secilen);
				}	
			}	
		}
	}

	private double vergihesapla(double mevcutgelir,double yenigelir, int donem)
	{
		double toplamvergi=0;
		double[] oranlar={0.15,0.2,0.27,0.35};
		double[] ocak={12600,30000,110000};
		double[] temmuz={13000,31000,120000}; // henuz belirlenmedi degerler farazi
		double[] donemsiniri; // kullanilacak doneme ait sinirlar
		
		donemsiniri=ocak;
		if(donem==1)
			donemsiniri=temmuz;
		
		double anapara=mevcutgelir;
		double kalan = yenigelir;
		
		do{
		
		int onceki=oranbul(anapara,donemsiniri);
		int sonraki=oranbul(anapara+kalan,donemsiniri);
		
		
		if(onceki==sonraki)
		{	// durum1 : tamamini vergilendir
			toplamvergi+=kalan*oranlar[onceki];
			kalan=0;
		}
		else
		{ 
			// durum2 : sinir ustunde devam etmeli 
			double vergilendirilecek=donemsiniri[onceki]-anapara;
			toplamvergi+=vergilendirilecek*oranlar[onceki];
			anapara+=vergilendirilecek;
			kalan-=vergilendirilecek;
		}
		
		
		
		}while(kalan>0);
		
		
		return toplamvergi;
	}
	
	private int oranbul(double gelir,double[] sinirlar)
	{
		for(int i=0;i<sinirlar.length;i++)
		{
			if(gelir < sinirlar[i])
				return i;
		}
		return sinirlar.length;
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new gelirvergisi();
	}

}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

public class gelirvergisi implements ActionListener {

JList[] jl;

DefaultListModel[] dlm;

JComboBox jcb;

JTextField jtf_gelirtop,jtf_yenigelir;

JRadioButton jrb_ocak,jrb_temmuz;

public gelirvergisi() {

JFrame jfrm = new JFrame("Gelir Vergisi - 2016");

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new GridLayout(1,5));

jfrm.setSize(500, 250);

JPanel[] jpn = new JPanel[5];

jl= new JList[5];

dlm=new DefaultListModel[5];

String[] baslik={"İsim","Gelir Top.","Yeni Gelir","Dönem","Vergi"};

for(int i =0; i<jpn.length;i++)

{

jpn[i]= new JPanel();

jpn[i].setPreferredSize(new Dimension(95, 295));

dlm[i]= new DefaultListModel();

jl[i]=new JList(dlm[i]);

JScrollPane jscp= new JScrollPane(jl[i]);

jscp.setPreferredSize(new Dimension(90,160));

JLabel jlab = new JLabel(baslik[i]);

jpn[i].add(jlab);

jpn[i].add(jscp); // jlist panele eklendi

jfrm.add(jpn[i]);

}

//1. sutun eklemeleri

String[] isimler ={"Seçiniz","Ahmet","Mustafa","Metin","Ayse","Fatma"};

jcb= new JComboBox(isimler);

jcb.setPreferredSize(new Dimension(90,25));

jpn[0].add(jcb);

JButton jbtn1= new JButton("Ekle");

jbtn1.addActionListener(this);

jbtn1.setActionCommand("ekle"); // buton etiketi

jbtn1.setPreferredSize(new Dimension(90,25));

jpn[0].add(jbtn1);

//2. sutun

jtf_gelirtop= new JTextField();

jtf_gelirtop.setPreferredSize(new Dimension(90,25));

jpn[1].add(jtf_gelirtop);

JButton jbtn2= new JButton("Sil");

jbtn2.addActionListener(this);

jbtn2.setPreferredSize(new Dimension(90,25));

jpn[1].add(jbtn2);

//3.sutun

jtf_yenigelir= new JTextField();

jtf_yenigelir.setPreferredSize(new Dimension(90,25));

jpn[2].add(jtf_yenigelir);

//4. sutun

ButtonGroup bg = new ButtonGroup();

jrb_ocak = new JRadioButton("Ocak");

jrb_ocak.setSelected(true);

jrb_temmuz = new JRadioButton("Temmuz");

bg.add(jrb_ocak);

bg.add(jrb_temmuz);

JPanel jpn4_1 = new JPanel();

JPanel jpn4_2 = new JPanel();

jpn4_1.setLayout(new FlowLayout(FlowLayout.LEFT));

jpn4_2.setLayout(new FlowLayout(FlowLayout.LEFT));

jpn4_1.setPreferredSize(new Dimension(90,25));

jpn4_2.setPreferredSize(new Dimension(90,25));

jpn4_1.add(jrb_ocak);

jpn4_2.add(jrb_temmuz);

jpn[3].add(jpn4_1);

jpn[3].add(jpn4_2);

jfrm.setVisible(true);

}

@Override

public void actionPerformed(ActionEvent ae) {

if(ae.getActionCommand().equals("ekle"))

{

// ekle

int secilen_isim = jcb.getSelectedIndex();

int donem=0;

if(jrb_temmuz.isSelected())

donem=1;

double mevcutgelir,yenigelir;

try{

if(secilen_isim>0 && jtf_gelirtop.getText().length()>0 &&

jtf_yenigelir.getText().length()>0 ){

mevcutgelir=Double.parseDouble(jtf_gelirtop.getText());

yenigelir=Double.parseDouble(jtf_yenigelir.getText());

String[] donemler={"Ocak","Temmuz"};

double vergi=vergihesapla(mevcutgelir, yenigelir, donem);

dlm[0].addElement(jcb.getSelectedItem()); // isim

dlm[1].addElement(mevcutgelir); // gelir top.

dlm[2].addElement(yenigelir); // yeni gelir

dlm[3].addElement(donemler[donem]); // donem

dlm[4].addElement(vergi); // vergi

jcb.setSelectedIndex(0);

jtf_gelirtop.setText("");

jtf_yenigelir.setText("");

jrb_ocak.setSelected(true);

}

}catch(Exception ex)

{

}

else

{

int secilen = jl[0].getSelectedIndex();

if(secilen>-1)

{

for(int i=0;i<dlm.length;i++)

{

dlm[i].remove(secilen);

}

private double vergihesapla(double mevcutgelir,double yenigelir, int donem)

{

double toplamvergi=0;

double[] oranlar={0.15,0.2,0.27,0.35};

double[] ocak={12600,30000,110000};

double[] temmuz={13000,31000,120000}; // henuz belirlenmedi degerler farazi

double[] donemsiniri; // kullanilacak doneme ait sinirlar

donemsiniri=ocak;

if(donem==1)

donemsiniri=temmuz;

double anapara=mevcutgelir;

double kalan = yenigelir;

do{

int onceki=oranbul(anapara,donemsiniri);

int sonraki=oranbul(anapara+kalan,donemsiniri);

if(onceki==sonraki)

{ // durum1 : tamamini vergilendir

toplamvergi+=kalan*oranlar[onceki];

kalan=0;

}

else

{

// durum2 : sinir ustunde devam etmeli

double vergilendirilecek=donemsiniri[onceki]-anapara;

toplamvergi+=vergilendirilecek*oranlar[onceki];

anapara+=vergilendirilecek;

kalan-=vergilendirilecek;

}

}while(kalan>0);

return toplamvergi;

}

private int oranbul(double gelir,double[] sinirlar)

{

for(int i=0;i<sinirlar.length;i++)

{

if(gelir < sinirlar[i])

return i;

}

return sinirlar.length;

}

/**

* @param args

public static void main(String[] args) {

new gelirvergisi();

}

Etiketler: DefaultListModel, Dimension, FlowLayout, gelir vergisi, hesaplama, java, JComboBox, JLabel, JList, JRadioButton, JTextField, setPreferredSize, swing

Java-2 – 2016 – Hafta – 4 – 1

Posted on 8 Mart 2016 by

caglar Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi — Henüz Yorum Yapılmadı ↓

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

public class nothesaplama implements ActionListener
{
JLabel jlab_sonuc;
JTextField jtf_vize, jtf_final; 
public nothesaplama()
{
JFrame jfrm = new JFrame("Not Hesaplama");
jfrm.setSize(130,120);
jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jfrm.setLayout(new FlowLayout());

JLabel jlab1= new JLabel("Vize:");
jtf_vize = new JTextField(5);

JLabel jlab2= new JLabel("Final:");
jtf_final = new JTextField(5);

JButton jbtn = new JButton("Hesapla");
jbtn.addActionListener(this); // butonun tiklama olayini izle
jlab_sonuc= new JLabel();

jfrm.add(jlab1);
jfrm.add(jtf_vize);
jfrm.add(jlab2);
jfrm.add(jtf_final);
jfrm.add(jbtn);
jfrm.add(jlab_sonuc);

jfrm.setVisible(true);
}

public void actionPerformed(ActionEvent ae)
{
// hesaplama kodu
int vize_notu=kontrol(jtf_vize.getText());
int final_notu=kontrol(jtf_final.getText());
if(vize_notu>-1 && final_notu>-1)
{
	String harf= "FF";
	String sonuc="";
	if(final_notu>29)
	{
		int ort=(int)Math.round(vize_notu*0.4+final_notu*0.6);
		String[] harfler={"AA","BA","BB","CB","CC","DC","DD","FD"};
		int[] sinirlar={90,80,70,60,50,40,35,30};
		for(int i=0;i<sinirlar.length;i++)
		{
			if(ort>=sinirlar[i])
			{
				harf=harfler[i];
				break;
			}
		}
		sonuc="Ort: "+ort+" Harf: "+harf;
	}
	else
		sonuc="Harf: FF (final<30)";	
	jlab_sonuc.setText(sonuc);
}
}

public int kontrol(String str)
{
	try
	{
		int not=Integer.parseInt(str);
		if(not>=0 && not<=100)
			return not;
		return -1;
	}
	catch(Exception ex)
	{
	}
	return -1;	
}

public static void main(String[] adsd)
{
	new nothesaplama();
}

}

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

public class nothesaplama implements ActionListener

{

JLabel jlab_sonuc;

JTextField jtf_vize, jtf_final;

public nothesaplama()

{

JFrame jfrm = new JFrame("Not Hesaplama");

jfrm.setSize(130,120);

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new FlowLayout());

JLabel jlab1= new JLabel("Vize:");

jtf_vize = new JTextField(5);

JLabel jlab2= new JLabel("Final:");

jtf_final = new JTextField(5);

JButton jbtn = new JButton("Hesapla");

jbtn.addActionListener(this); // butonun tiklama olayini izle

jlab_sonuc= new JLabel();

jfrm.add(jlab1);

jfrm.add(jtf_vize);

jfrm.add(jlab2);

jfrm.add(jtf_final);

jfrm.add(jbtn);

jfrm.add(jlab_sonuc);

jfrm.setVisible(true);

}

public void actionPerformed(ActionEvent ae)

{

// hesaplama kodu

int vize_notu=kontrol(jtf_vize.getText());

int final_notu=kontrol(jtf_final.getText());

if(vize_notu>-1 && final_notu>-1)

{

String harf= "FF";

String sonuc="";

if(final_notu>29)

{

int ort=(int)Math.round(vize_notu*0.4+final_notu*0.6);

String[] harfler={"AA","BA","BB","CB","CC","DC","DD","FD"};

int[] sinirlar={90,80,70,60,50,40,35,30};

for(int i=0;i<sinirlar.length;i++)

{

if(ort>=sinirlar[i])

{

harf=harfler[i];

break;

}

sonuc="Ort: "+ort+" Harf: "+harf;

}

else

sonuc="Harf: FF (final<30)";

jlab_sonuc.setText(sonuc);

}

public int kontrol(String str)

{

try

{

int not=Integer.parseInt(str);

if(not>=0 && not<=100)

return not;

return -1;

}

catch(Exception ex)

{

}

return -1;

}

public static void main(String[] adsd)

{

new nothesaplama();

}

Etiketler: awt, java, JButton, JLabel, JTextField, not hesaplama, swing

Java-2 – YO2015 – Hafta – 6

Posted on 14 Ağustos 2015 by

caglar Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi — Henüz Yorum Yapılmadı ↓

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();
	}

}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

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();

}

JAVA-2 YO2015 6. Hafta Uygulamaları

Etiketler: DefaultListModel, java, java-2 uygulamaları, java2, JButton, JComboBox, JDBC, JList, JScrollPane, JTextField, sqlite, sqlite-jdbc.jar, swing

Java-2 – YO2015 – Hafta – 5

Posted on 4 Ağustos 2015 by

caglar Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi — 2 Yorum ↓

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

public class ornek1 implements ActionListener {

	JTextField jtf;
	DefaultListModel<String> lm;

	public ornek1() {

		JFrame jfrm = new JFrame("ornek-1 veritabani");
		jfrm.setSize(180, 200);
		jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		jfrm.setLayout(new FlowLayout());
		lm = new DefaultListModel<String>();

		JList<String> jlist = new JList<String>(lm);
		JScrollPane jscp = new JScrollPane(jlist);
		jscp.setPreferredSize(new Dimension(150, 120));
		jfrm.add(jscp);

		jtf = new JTextField();
		jtf.setPreferredSize(new Dimension(150, 20));
		jfrm.add(jtf);

		JButton jbtn = new JButton("Ekle");
		jbtn.addActionListener(this);
		jbtn.setPreferredSize(new Dimension(150, 30));
		jfrm.add(jbtn);

		verigetir();

		jfrm.setVisible(true);
	}

	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;
	}

	public void verigetir() {
		Connection conn = baglan();

		String sql = "select id,ad from liste;";

		try {
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);

			lm.clear();

			while (rs.next()) {
				lm.addElement(rs.getString("ad"));
			}

		} catch (Exception ex) {
		}

		try {
			conn.close();
		} catch (Exception ex) {

		}

	}

	@Override
	public void actionPerformed(ActionEvent arg0) {

		if (jtf.getText().length() > 0) {
			String sql = "insert into liste(ad) values(?)";

			Connection conn = baglan();

			try {

				PreparedStatement ps = conn.prepareStatement(sql);
				ps.setString(1, jtf.getText());
				ps.executeUpdate();
			} catch (Exception ex) {
			}

			try {
				conn.close();
			} catch (Exception ex) {
			}

			jtf.setText("");
		}

		verigetir();

	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new ornek1();
	}

}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

import java.awt.event.*;

import javax.swing.*;

import java.awt.*;

import java.sql.*;

public class ornek1 implements ActionListener {

JTextField jtf;

DefaultListModel<String> lm;

public ornek1() {

JFrame jfrm = new JFrame("ornek-1 veritabani");

jfrm.setSize(180, 200);

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new FlowLayout());

lm = new DefaultListModel<String>();

JList<String> jlist = new JList<String>(lm);

JScrollPane jscp = new JScrollPane(jlist);

jscp.setPreferredSize(new Dimension(150, 120));

jfrm.add(jscp);

jtf = new JTextField();

jtf.setPreferredSize(new Dimension(150, 20));

jfrm.add(jtf);

JButton jbtn = new JButton("Ekle");

jbtn.addActionListener(this);

jbtn.setPreferredSize(new Dimension(150, 30));

jfrm.add(jbtn);

verigetir();

jfrm.setVisible(true);

}

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;

}

public void verigetir() {

Connection conn = baglan();

String sql = "select id,ad from liste;";

try {

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

lm.clear();

while (rs.next()) {

lm.addElement(rs.getString("ad"));

}

} catch (Exception ex) {

}

try {

conn.close();

} catch (Exception ex) {

}

@Override

public void actionPerformed(ActionEvent arg0) {

if (jtf.getText().length() > 0) {

String sql = "insert into liste(ad) values(?)";

Connection conn = baglan();

try {

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, jtf.getText());

ps.executeUpdate();

} catch (Exception ex) {

}

try {

conn.close();

} catch (Exception ex) {

}

jtf.setText("");

}

verigetir();

}

/**

* @param args

public static void main(String[] args) {

new ornek1();

}

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

public class ornek2 implements ActionListener {

	JList<String> jl1, jl2, jl3;
	DefaultListModel<String> lm1, lm2, lm3;
	DefaultListModel<Integer> lmid;
	JTextField jtf1, jtf2;

	public ornek2() {

		JFrame jfrm = new JFrame("ornek-2 veritabani");
		jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		jfrm.setLayout(new GridLayout(1, 3));
		jfrm.setSize(200, 220);
		JPanel jpn = new JPanel();

		lm1 = new DefaultListModel<String>();
		jl1 = new JList<String>(lm1);
		jtf1 = new JTextField();
		jtf1.setPreferredSize(new Dimension(55, 20));
		JScrollPane jscp = new JScrollPane(jl1);
		jscp.setPreferredSize(new Dimension(55, 150));
		JButton jbtn1 = new JButton("Ekle");
		jbtn1.addActionListener(this);
		jbtn1.setActionCommand("ekle");
		jpn.add(jscp);
		jpn.add(jtf1);
		jpn.add(jbtn1);
		jfrm.add(jpn);

		jpn = new JPanel();
		lm2 = new DefaultListModel<String>();
		jl2 = new JList<String>(lm2);
		jtf2 = new JTextField();
		jtf2.setPreferredSize(new Dimension(55, 20));
		jscp = new JScrollPane(jl2);
		jscp.setPreferredSize(new Dimension(55, 150));
		JButton jbtn2 = new JButton("Sil");
		jbtn2.addActionListener(this);
		jpn.add(jscp);
		jpn.add(jtf2);
		jpn.add(jbtn2);
		jfrm.add(jpn);

		jpn = new JPanel();
		lm3 = new DefaultListModel<String>();
		jl3 = new JList<String>(lm3);
		jscp = new JScrollPane(jl3);
		jscp.setPreferredSize(new Dimension(55, 150));
		jpn.add(jscp);
		jfrm.add(jpn);
		verigetir();
		jfrm.setVisible(true);
	}

	private void verigetir() {

		Connection conn = baglan();

		try {
			String sql = "select idnot,no,ort from notlistesi;";

			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);

			lm1.clear();
			lm2.clear();
			lm3.clear();
			lmid = new DefaultListModel<Integer>();

			while (rs.next()) {
				lmid.addElement(rs.getInt("idnot")); // int, silmek icin
				lm1.addElement(rs.getString("no"));
				lm2.addElement(rs.getString("ort"));
				int ort = rs.getInt("ort");
				lm3.addElement(harfgetir(ort));

			}
		} catch (Exception ex) {

		}

		try {

			conn.close();

		} catch (Exception ex) {
		}

	}

	public String harfgetir(int ort) {
		String[] harfler = { "AA", "BA", "BB", "CB", "CC", "DC", "DD", "FD" };
		int[] sinir = { 90, 80, 70, 60, 50, 40, 35, 30 };

		for (int i = 0; i < harfler.length; i++) {
			if (ort >= sinir[i])
				return harfler[i];
		}

		return "FF";
	}

	public Connection baglan() {
		Connection conn = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:ornek2.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 {

				if (jtf1.getText().length() > 0 && jtf2.getText().length() > 0) {
					int ort = Integer.parseInt(jtf2.getText());
					String sql = "insert into notlistesi(no,ort) values(?,?);";
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setString(1, jtf1.getText());
					ps.setInt(2, ort);
					ps.executeUpdate();

					jtf1.setText("");
					jtf2.setText("");

				}
			} catch (Exception ex) {
			}
		} else {

			if (jl1.getSelectedIndex() > -1) {

				try {
					int secilen = lmid.get(jl1.getSelectedIndex()); // idnot
																	// karsiligi
					String sql = "delete from notlistesi where idnot=?;";

					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setInt(1, secilen);
					ps.executeUpdate();
				} catch (Exception ex) {
				}

			}

		}

		try {
			conn.close();
		} catch (Exception ex) {
		}

		verigetir();

	}

	public static void main(String[] args) {

		new ornek2();

	}

}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

import java.awt.event.*;

import java.awt.*;

import javax.swing.*;

import java.sql.*;

public class ornek2 implements ActionListener {

JList<String> jl1, jl2, jl3;

DefaultListModel<String> lm1, lm2, lm3;

DefaultListModel<Integer> lmid;

JTextField jtf1, jtf2;

public ornek2() {

JFrame jfrm = new JFrame("ornek-2 veritabani");

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new GridLayout(1, 3));

jfrm.setSize(200, 220);

JPanel jpn = new JPanel();

lm1 = new DefaultListModel<String>();

jl1 = new JList<String>(lm1);

jtf1 = new JTextField();

jtf1.setPreferredSize(new Dimension(55, 20));

JScrollPane jscp = new JScrollPane(jl1);

jscp.setPreferredSize(new Dimension(55, 150));

JButton jbtn1 = new JButton("Ekle");

jbtn1.addActionListener(this);

jbtn1.setActionCommand("ekle");

jpn.add(jscp);

jpn.add(jtf1);

jpn.add(jbtn1);

jfrm.add(jpn);

jpn = new JPanel();

lm2 = new DefaultListModel<String>();

jl2 = new JList<String>(lm2);

jtf2 = new JTextField();

jtf2.setPreferredSize(new Dimension(55, 20));

jscp = new JScrollPane(jl2);

jscp.setPreferredSize(new Dimension(55, 150));

JButton jbtn2 = new JButton("Sil");

jbtn2.addActionListener(this);

jpn.add(jscp);

jpn.add(jtf2);

jpn.add(jbtn2);

jfrm.add(jpn);

jpn = new JPanel();

lm3 = new DefaultListModel<String>();

jl3 = new JList<String>(lm3);

jscp = new JScrollPane(jl3);

jscp.setPreferredSize(new Dimension(55, 150));

jpn.add(jscp);

jfrm.add(jpn);

verigetir();

jfrm.setVisible(true);

}

private void verigetir() {

Connection conn = baglan();

try {

String sql = "select idnot,no,ort from notlistesi;";

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

lm1.clear();

lm2.clear();

lm3.clear();

lmid = new DefaultListModel<Integer>();

while (rs.next()) {

lmid.addElement(rs.getInt("idnot")); // int, silmek icin

lm1.addElement(rs.getString("no"));

lm2.addElement(rs.getString("ort"));

int ort = rs.getInt("ort");

lm3.addElement(harfgetir(ort));

}

} catch (Exception ex) {

}

try {

conn.close();

} catch (Exception ex) {

}

public String harfgetir(int ort) {

String[] harfler = { "AA", "BA", "BB", "CB", "CC", "DC", "DD", "FD" };

int[] sinir = { 90, 80, 70, 60, 50, 40, 35, 30 };

for (int i = 0; i < harfler.length; i++) {

if (ort >= sinir[i])

return harfler[i];

}

return "FF";

}

public Connection baglan() {

Connection conn = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:ornek2.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 {

if (jtf1.getText().length() > 0 && jtf2.getText().length() > 0) {

int ort = Integer.parseInt(jtf2.getText());

String sql = "insert into notlistesi(no,ort) values(?,?);";

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, jtf1.getText());

ps.setInt(2, ort);

ps.executeUpdate();

jtf1.setText("");

jtf2.setText("");

}

} catch (Exception ex) {

}

} else {

if (jl1.getSelectedIndex() > -1) {

try {

int secilen = lmid.get(jl1.getSelectedIndex()); // idnot

// karsiligi

String sql = "delete from notlistesi where idnot=?;";

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1, secilen);

ps.executeUpdate();

} catch (Exception ex) {

}

try {

conn.close();

} catch (Exception ex) {

}

verigetir();

}

public static void main(String[] args) {

new ornek2();

}

JAVA-2 YO2015 5. Hafta Uygulamaları

Etiketler: DefaultListModel, java, java-2 uygulamaları, java2, JButton, JDBC, JList, JTextField, sqlite, sqlite-jdbc.jar, swing