import java.sql.*;
import
java.util.logging.Level;
import
java.util.logging.Logger;
public class VeriTabani2
extends javax.swing.JFrame {
public VeriTabani2() {
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jButton1 = new javax.swing.JButton();
jScrollPane1 = new
javax.swing.JScrollPane();
jTextArea1 = new
javax.swing.JTextArea();
jLabel1 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jButton1.setText("LİSTELE");
jButton1.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jTextArea1.setColumns(20);
jTextArea1.setRows(5);
jScrollPane1.setViewportView(jTextArea1);
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 364,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(40, 40, 40)
.addComponent(jLabel1))
.addGroup(layout.createSequentialGroup()
.addGap(104, 104, 104)
.addComponent(jButton1)))
.addContainerGap(26,
Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(44, 44, 44)
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1,
javax.swing.GroupLayout.PREFERRED_SIZE, 133,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 40,
Short.MAX_VALUE)
.addComponent(jButton1)
.addGap(54, 54, 54))
);
jScrollPane1.getAccessibleContext().setAccessibleParent(jTextArea1);
pack();
}// </editor-fold>
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch
(ClassNotFoundException ex) {
Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null,
ex);
}
java.sql.Connection
baglanti = null;
try {
baglanti =
java.sql.DriverManager.getConnection("jdbc:odbc:Personel",
"", "");
} catch (SQLException
ex) {
Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null,
ex);
}
java.sql.Statement
sorgulama = null;
try {
sorgulama =
baglanti.createStatement();
} catch (SQLException
ex) {
Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null,
ex);
}
java.sql.ResultSet SonucVeriler =
sorgulama.executeQuery("SELECT * FROM Elemanlar");
jLabel1.setText("Personel Veri Tabanı Elemanlar Listesi");
while
(SonucVeriler.next()) {
jTextArea1.append(SonucVeriler.getString("Sicil")+"\t");
jTextArea1.append(SonucVeriler.getString("Adi")+"\t");
jTextArea1.append(SonucVeriler.getString("Soyadi")+"\t");
jTextArea1.append(SonucVeriler.getString("Gorevi")+"\t");
jTextArea1.append(SonucVeriler.getString("Departmani")+"\n");
}
} catch (SQLException ex)
{
Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null,
ex);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new
Runnable() {
public void run() {
new
VeriTabani2().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JScrollPane
jScrollPane1;
private javax.swing.JTextArea jTextArea1;
// End of variables declaration
}
Hiç yorum yok:
Yorum Gönder