JDBC Uygulamasi - Javax ile DB'den Dokum Alimi
- Sevdanur GENC

- Jul 7, 2011
- 1 min read
import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
public class personel implements WindowListener
{
private JFrame f;
private JLabel etiket;
private JTextArea alanicerik;
private JScrollPane pano;
public String liste="";
int kayitindeks;
int toplamkayitsayisi;
public personel(String baslik)
{
f = new JFrame(baslik);
etiket = new JLabel(".... personel dokumu.... ");
alanicerik = new JTextArea(5,27);
pano = new JScrollPane(alanicerik);
}
public void pencereyigoster()
{
Container cnt = f.getContentPane();
f.setSize(420,170);
f.setLocation(400,300);
cnt.setLayout(new FlowLayout());
cnt.add(etiket);
cnt.add(pano);
f.addWindowListener(this);
f.setVisible(true);
}
public void baglan() throws Exception
{
kayitindeks = 0;
System.out.println("program personel veritabanina baglaniyor... ");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection baglanti = java.sql.DriverManager.getConnection("jdbc:odbc:personel_java","","");
java.sql.Statement sorgulama = baglanti.createStatement();
java.sql.ResultSet sonucveriler = sorgulama.executeQuery("select * from elemanlar");
System.out.println("baglanti saglandi...");
liste="";
while (sonucveriler.next())
{
liste = liste + sonucveriler.getString("ad") + " " + sonucveriler.getString("soyad") + "\t" + sonucveriler.getString("gorev") + "\n";
kayitindeks++;
}
alanicerik.setText(liste);
sonucveriler.close();
baglanti.close();
toplamkayitsayisi = kayitindeks;
System.out.println("Toplam : " + toplamkayitsayisi + " adet kayit bulundu...");
kayitindeks=0;
}
public static void main(String[] args) throws Exception
{
personel pen = new personel("personel veritabani programi");
pen.baglan();
pen.pencereyigoster();
}
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
public void windowClosed(WindowEvent e) {} public void windowActivated(WindowEvent e) {} public void windowDeactivated(WindowEvent e) {} public void windowIconified(WindowEvent e) {} public void windowDeiconified(WindowEvent e) {} public void windowOpened(WindowEvent e) {}
}
Comments