Nesne Tabanlı Programlama-2 (Bahar-2016) Hafta-6/1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class veritabani extends JFrame implements ActionListener { DefaultListModel<String> dlm; public veritabani() { this.setTitle("Veritabanina Giris:Sqlite"); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setSize(150,300); this.setLayout(new FlowLayout()); JPanel jpn_main= new JPanel(); jpn_main.setPreferredSize(new Dimension(140, 290)); dlm = new DefaultListModel<String>(); JList<String> jl = new JList<String>(dlm); JScrollPane jscp = new JScrollPane(jl); jscp.setPreferredSize(new Dimension(130, 250)); JButton jbtn = new JButton("Göster"); jbtn.setPreferredSize(new Dimension(130, 30)); jbtn.addActionListener(this); jpn_main.add(jscp); jpn_main.add(jbtn); this.add(jpn_main); this.setVisible(true); } @Override public void actionPerformed(ActionEvent arg0) { Connection conn = baglan(); if(conn!=null) { dlm.clear(); try{ String sql = "select isim from kisiler;"; Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); while(rs.next()) { dlm.addElement(rs.getString("isim")); } }catch(Exception ex) { JOptionPane.showMessageDialog(this, ex.getMessage()); } } } public Connection baglan() { Connection conn=null; try{ Class.forName("org.sqlite.JDBC"); conn=DriverManager.getConnection("jdbc:sqlite:orgun1hafta6.db"); }catch(Exception ex) { JOptionPane.showMessageDialog(this, "Baglanti Hatasi!"); } return conn; } /** * @param args */ public static void main(String[] args) { new veritabani(); } } |
NTP2 (Bahar-2016) Hafta-6/1
sqlite-jdbc