Pemrograman Visual

PINJAMAN

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

class Peminjaman

{

                public Peminjaman()

                {

                                try

                                {

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

                                }

                                catch (Exception e)

                                {

                                                System.out.println("Tedapat Kesalahan pada Koneksi ODBC Anda:"+e);

                                }

                               

                                final JFrame frame=new JFrame("Transaksi Peminjaman");

                                JLabel lNoAnggota=new JLabel("No Anggota           :");

                                JLabel lNama=new JLabel("Nama                     :");

                                JLabel lKodeBuku=new JLabel("Kode Buku           :");

                                JLabel lJudul=new JLabel("Judul                    :");

                                JLabel lTglPinjam=new JLabel("Tgl Pinjam         :");

                                JLabel lTglKembali=new JLabel("Tgl Kembali       :");

                                final JTextField NoAnggota=new JTextField(5);

                                final JTextField Nama=new JTextField(15);

        final JTextField KodeBuku=new JTextField(5);

        final JTextArea Judul=new JTextArea(5,15);

              JScrollPane Scroll=new JScrollPane(Judul,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

        final JTextField TglPinjam=new JTextField(15);

        final JTextField TglKembali=new JTextField(15);

       

        JButton Save=new JButton("Save");

        Save.setMnemonic('S');

        Save.addActionListener(new ActionListener()

        {

          public void actionPerformed(ActionEvent ae)

                {

                String sql="insert into Peminjaman values('"+NoAnggota.getText()+"','"+KodeBuku.getText()+"','"+Judul.getText()+"','"+TglPinjam.getText()+"','"+TglKembali.getText()+"')";

                if(NoAnggota.getText().trim().equals("")||Nama.getText().trim().equals("") 

                ||KodeBuku.getText().trim().equals("")||Judul.getText().trim().equals("")

                ||TglPinjam.getText().trim().equals("")||TglKembali.getText().trim().equals(""))

            {

                JOptionPane.showMessageDialog(frame,"Data Belum Lengkap!Silahkan Lengkapi",

                "Save Data",JOptionPane.WARNING_MESSAGE);

                NoAnggota.requestFocus();

            }

            else

            {

                try

                {

                Connection connection=DriverManager.getConnection("JDBC:sqlite:datapinjam.db","","");

                Statement statement=connection.createStatement();

                statement.executeUpdate(sql);

                JOptionPane.showMessageDialog(frame,"Data Sudah Tersimpan",

                "Save Data",JOptionPane.WARNING_MESSAGE);

               

                NoAnggota.setText("");

                Nama.setText("");

                KodeBuku.setText("");

                Judul.setText("");

                TglPinjam.setText("");

                TglKembali.setText("");

                NoAnggota.requestFocus();

                statement.close();

                connection.close();

                }

            catch(Exception e)

                {

                System.out.println("Kesalahan pada Database Anda:"+e);

                }

            }

            }

        });

       

        JButton Browse=new JButton("Browse");

        Browse.setMnemonic('B');

        Browse.addActionListener(new ActionListener()

        {

          public void actionPerformed(ActionEvent ae)

                {

                String sql="select * from Peminjaman where NoAnggota='"+NoAnggota.getText()+"'";

            try

            {

            Connection con=DriverManager.getConnection("JDBC:sqlite:datapinjam.db","","");

                Statement statement=con.createStatement();

            ResultSet rs=statement.executeQuery(sql);

            if(rs.next())

            { 

                NoAnggota.setText(rs.getString(1));

                Nama.setText(rs.getString(2));

                KodeBuku.setText(rs.getString(3));

                Judul.setText(rs.getString(4));

                TglPinjam.setText(rs.getString(5));

                TglKembali.setText(rs.getString(6));

                NoAnggota.requestFocus();

            }

            else

            {

                NoAnggota.setText("");

                Nama.setText("");

                KodeBuku.setText("");

                Judul.setText("");

                TglPinjam.setText("");

                TglKembali.setText("");

                JOptionPane.showMessageDialog(frame,"No Anngota tidak Ada","Browse Data",JOptionPane.WARNING_MESSAGE);

                NoAnggota.requestFocus();

            }

            statement.close();

            con.close();

            } 

            catch(Exception exc)

                {

                System.out.println("Kesalahan pada Database Anda:"+exc);

                }

            }

          });

       

        JButton Delete=new JButton("Delete");

        Delete.setMnemonic('D');

        Delete.addActionListener(new ActionListener()

            {

            public void actionPerformed(ActionEvent ae)

                {

                NoAnggota.setText("");

                Nama.setText("");

                KodeBuku.setText("");

                Judul.setText("");

                TglPinjam.setText("");

                TglKembali.setText("");

                NoAnggota.requestFocus();

                }

            }); 

               

        JButton Exit=new JButton("Exit");

        Exit.setMnemonic('E');

        Exit.addActionListener((new ActionListener()

            {

            public void actionPerformed(ActionEvent e)

               {

               frame.setVisible(false);

               }

            }));                 

 

        JPanel panel1=new JPanel();

        JPanel panel2=new JPanel();

        JPanel panel3=new JPanel();

        JPanel panel4=new JPanel();

        JPanel panel5=new JPanel();

        JPanel panel6=new JPanel();

        JPanel panel7=new JPanel();

       

        panel1.setLayout(new FlowLayout());

        panel2.setLayout(new FlowLayout());

        panel3.setLayout(new FlowLayout());

        panel4.setLayout(new FlowLayout());

        panel5.setLayout(new FlowLayout());

        panel6.setLayout(new FlowLayout());

        panel7.setLayout(new FlowLayout());

       

        panel1.add(lNoAnggota);

        panel1.add(NoAnggota);

        panel2.add(lNama);

        panel2.add(Nama);

        panel3.add(lKodeBuku);

        panel3.add(KodeBuku);

        panel4.add(lJudul);

        panel4.add(Judul);

        panel4.add(Scroll);

        panel5.add(lTglPinjam);

        panel5.add(TglPinjam);

        panel6.add(lTglKembali);

        panel6.add(TglKembali);

        panel7.add(Save);

        panel7.add(Browse);

        panel7.add(Delete);

        panel7.add(Exit);

        

       

       

        Container konten;

        konten=frame.getContentPane();

        konten.setLayout(new GridBagLayout());

        GridBagConstraints pos=new GridBagConstraints();

        pos.anchor=GridBagConstraints.WEST;

        pos.gridx=1;

        pos.gridy=1;

       

        konten.add(panel1,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        konten.add(panel2,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        konten.add(panel3,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        konten.add(panel4,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        konten.add(panel5,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        konten.add(panel6,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        konten.add(panel7,pos);

        pos.gridx++;

        pos.gridy++;

        pos.gridx=1;

       

        frame.pack();

        frame.setVisible(true);

        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

                }

    public static void main(String args[])

                {

                                Peminjaman frmPeminjaman = new Peminjaman();

                } }