Apllikasi Sewa sepeda

Aplikasi penyewaan sepeda

Assalamualaikum W.r W.b

Nama : Moh.Alfarisyi

NIM    : 161011400133

Kelas   : 02TPLP001

UntukTugas Kali ini yang inginsayabahasadalahbagaimanamembuat Form AplikasiInput Data Siswa dengan Mysql menggunakan Bahasa Pemrograman Java NetBeans.

Unuk permana Buat Database di http://localhost/phpmyadmin

Buat Database dengan nama “daftar”

Database ini hanya unuk From Daftar dan From Login

Buat Database Kedua/Baru dengan nama “testt”

Selanjutnya buat design Form AplikasiJawa Swing GuipadaNetbeanssebagaiberikut

Jframe Menu

Jframe tampilan

Jframe pencarian

Source code koneksi

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package koneksi;

import com.mysql.jdbc.Driver;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

/**

 *

 * @author testt

 */

public class conek {

    public static Connection koneksi;

    public static Connection GetConnection()throws SQLException {

            if(koneksi==null){

                new Driver();

                koneksi=DriverManager.getConnection("jdbc:mysql://localhost/testt","root","");

            }

            return koneksi;

    }

}

Source sewa

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package proses;

import com.mysql.jdbc.Statement;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JOptionPane;

import koneksi.conek;

import javax.swing.table.DefaultTableModel;

/**

 *

 * @author awien

 */

public class Jsewa extends javax.swing.JFrame {

int jurusan;

    int b;

    int c;

    int z;

    int a;

    /**

     * Creates new form Jsewa

     */

    public Jsewa() {

        initComponents();

    }

    /**

     * This method is called from within the constructor to initialize the form.

     * WARNING: Do NOT modify this code. The content of this method is always

     * regenerated by the Form Editor.

     */

    @SuppressWarnings("unchecked")

    // <editor-fold defaultstate="collapsed" desc="Generated Code">

    private void initComponents() {

        bayar = new javax.swing.JButton();

        check = new javax.swing.JButton();

        exit = new javax.swing.JButton();

        jLabel3 = new javax.swing.JLabel();

        jLabel9 = new javax.swing.JLabel();

        jLabel11 = new javax.swing.JLabel();

        jLabel12 = new javax.swing.JLabel();

        jLabel13 = new javax.swing.JLabel();

        jLabel14 = new javax.swing.JLabel();

        jLabel15 = new javax.swing.JLabel();

        jLabel16 = new javax.swing.JLabel();

        Txt1 = new javax.swing.JTextField();

        Txt2 = new javax.swing.JTextField();

        CB1 = new javax.swing.JComboBox<>();

        Txt3 = new javax.swing.JTextField();

        CB2 = new javax.swing.JComboBox<>();

        Txt4 = new javax.swing.JTextField();

        jLabel1 = new javax.swing.JLabel();

        Txt5 = new javax.swing.JTextField();

        Txt6 = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        bayar.setText("Bayar");

        bayar.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                bayarActionPerformed(evt);

            }

        });

        check.setText("Check");

        check.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                checkActionPerformed(evt);

            }

        });

        exit.setText("Exit");

        exit.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                exitActionPerformed(evt);

            }

        });

        jLabel3.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N

        jLabel3.setText("SEWA BAROKAH");

        jLabel9.setText("Nama");

        jLabel11.setText("No.KTP");

        jLabel12.setText("Kode Sepede");

        jLabel13.setText("Nama Sepeda");

        jLabel14.setText("Lama Sewa");

        jLabel15.setText("Harga");

        jLabel16.setText("Jumlah Sewa");

        CB1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "---- Pilih Kode ----", "1", "2", "3" }));

        CB1.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                CB1ActionPerformed(evt);

            }

        });

        Txt3.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                Txt3ActionPerformed(evt);

            }

        });

        CB2.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "---Pilih Jam---", "1 Jam", "2 Jam", "3 Jam" }));

        CB2.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                CB2ActionPerformed(evt);

            }

        });

        jLabel1.setText("Total");

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

                        .addGap(132, 132, 132)

                        .addComponent(Txt4, javax.swing.GroupLayout.PREFERRED_SIZE, 133, javax.swing.GroupLayout.PREFERRED_SIZE))

                    .addGroup(layout.createSequentialGroup()

                        .addGap(169, 169, 169)

                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

                            .addGroup(layout.createSequentialGroup()

                                .addComponent(bayar)

                                .addGap(18, 18, 18)

                                .addComponent(check))

                            .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE))

                        .addGap(18, 18, 18)

                        .addComponent(exit)))

                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

            .addGroup(layout.createSequentialGroup()

                .addContainerGap()

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                    .addGroup(layout.createSequentialGroup()

                        .addComponent(jLabel11)

                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                            .addComponent(jLabel1)

                            .addComponent(Txt6, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE))

                        .addGap(91, 91, 91))

                    .addGroup(layout.createSequentialGroup()

                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                            .addComponent(jLabel13)

                            .addGroup(layout.createSequentialGroup()

                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                                    .addComponent(jLabel15)

                                    .addComponent(jLabel16))

                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 60, Short.MAX_VALUE)

                                .addComponent(Txt5, javax.swing.GroupLayout.PREFERRED_SIZE, 133, javax.swing.GroupLayout.PREFERRED_SIZE))

                            .addGroup(layout.createSequentialGroup()

                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                                    .addComponent(jLabel12)

                                    .addComponent(jLabel9)

                                    .addComponent(jLabel14))

                                .addGap(59, 59, 59)

                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                                    .addComponent(CB2, javax.swing.GroupLayout.PREFERRED_SIZE, 123, javax.swing.GroupLayout.PREFERRED_SIZE)

                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                                        .addComponent(CB1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

                                        .addComponent(Txt3, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)

                                        .addComponent(Txt2, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)

                                        .addComponent(Txt1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)))))

                        .addGap(277, 277, 277))))

        );

        layout.setVerticalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addGroup(layout.createSequentialGroup()

                .addContainerGap()

                .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE)

                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

                    .addGroup(layout.createSequentialGroup()

                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

                            .addComponent(jLabel9)

                            .addComponent(jLabel1))

                        .addGap(18, 18, 18)

                        .addComponent(Txt6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

                    .addGroup(layout.createSequentialGroup()

                        .addComponent(Txt1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

                        .addGap(18, 18, 18)

                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                            .addComponent(jLabel11)

                            .addComponent(Txt2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))

                .addGap(18, 18, 18)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                    .addComponent(CB1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

                    .addComponent(jLabel12))

                .addGap(18, 18, 18)

                .addComponent(Txt3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

                .addGap(2, 2, 2)

                .addComponent(jLabel13)

                .addGap(18, 18, 18)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                    .addComponent(jLabel14)

                    .addComponent(CB2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

                .addGap(18, 18, 18)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                    .addComponent(jLabel15)

                    .addComponent(Txt4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

                .addGap(14, 14, 14)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                    .addComponent(jLabel16)

                    .addComponent(Txt5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 57, Short.MAX_VALUE)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                    .addComponent(bayar)

                    .addComponent(check)

                    .addComponent(exit))

                .addGap(23, 23, 23))

        );

        pack();

    }// </editor-fold>

    private void bayarActionPerformed(java.awt.event.ActionEvent evt) {                                      

        // TODO add your handling code here:

        b=Integer.parseInt(Txt4.getText());

        c=Integer.parseInt(Txt5.getText());

        z=b*c;

        Txt6.setText(String.valueOf(z));

        String nama=Txt1.getText();

        String nokt=Txt2.getText();

        String jenis=(String)CB1.getSelectedItem();

        String nmsepeda=Txt3.getText();

        String lama=(String)CB2.getSelectedItem();

        String harga=Txt4.getText();

        String jumlah=Txt5.getText();

        String hasil=Txt6.getText();

        try{

            Statement sta =(Statement) conek.GetConnection().createStatement();

            sta.executeUpdate("INSERT INTO tbtest VALUES('"+nama+"','"+nokt+"','"+jenis+"','"+nmsepeda+"','"+lama+"','"+harga+"','"+jumlah+"','"+hasil+"')");

            JOptionPane.showMessageDialog(null,"Data telah tersimpan silahkan Check untuk melihat data");

        }catch(Exception e){

            JOptionPane.showMessageDialog(null,"Terjadi kesalahan");

        }

    }                                    

    private void checkActionPerformed(java.awt.event.ActionEvent evt) {                                     

        // TODO add your handling code here:

        new list().show();

    }                                     

    private void exitActionPerformed(java.awt.event.ActionEvent evt) {                                    

        // TODO add your handling code here:

        dispose();

    }                                   

    private void CB2ActionPerformed(java.awt.event.ActionEvent evt) {                                   

        // TODO add your handling code here:

        if(CB2.getSelectedItem().equals("---- Pilih Jam ----")){

    }else if(CB2.getSelectedItem().equals("1 Jam")){

        a=70000;

         Txt4.setText(""+a);

    }else if(CB2.getSelectedItem().equals("2 Jam")){

        a=75000;

        Txt4.setText(""+a);

    }

    else if(CB2.getSelectedItem().equals("3 Jam")){

        a=70000;

         Txt4.setText(""+a);

    }

    }                                  

    private void CB1ActionPerformed(java.awt.event.ActionEvent evt) {                                   

        // TODO add your handling code here:

         if(CB1.getSelectedItem().equals("1")){

        Txt3.setText("Sepeda Santai");

    }

    else if(CB1.getSelectedItem().equals("2")){

        Txt3.setText("Sepeda Balap");

    }

    else if(CB1.getSelectedItem().equals("3")){

        Txt3.setText("Sepeda Gunung");

    }

    else if(CB1.getSelectedItem().equals("---- Pilih Kode ----")){

        Txt3.setText("");

    }

    }                                  

    private void Txt3ActionPerformed(java.awt.event.ActionEvent evt) {                                    

        // TODO add your handling code here:

    }                                   

    /**

     * @param args the command line arguments

     */

    public static void main(String args[]) {

        /* Set the Nimbus look and feel */

        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">

        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.

         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html

         */

        try {

            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {

                if ("Nimbus".equals(info.getName())) {

                    javax.swing.UIManager.setLookAndFeel(info.getClassName());

                    break;

                }

            }

        } catch (ClassNotFoundException ex) {

            java.util.logging.Logger.getLogger(Jsewa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (InstantiationException ex) {

            java.util.logging.Logger.getLogger(Jsewa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (IllegalAccessException ex) {

            java.util.logging.Logger.getLogger(Jsewa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (javax.swing.UnsupportedLookAndFeelException ex) {

            java.util.logging.Logger.getLogger(Jsewa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        }

        //</editor-fold>

        /* Create and display the form */

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new Jsewa().setVisible(true);

            }

        });

    }

    // Variables declaration - do not modify                    

    private javax.swing.JComboBox<String> CB1;

    private javax.swing.JComboBox<String> CB2;

    private javax.swing.JTextField Txt1;

    private javax.swing.JTextField Txt2;

    private javax.swing.JTextField Txt3;

    private javax.swing.JTextField Txt4;

    private javax.swing.JTextField Txt5;

    private javax.swing.JTextField Txt6;

    private javax.swing.JButton bayar;

    private javax.swing.JButton check;

    private javax.swing.JButton exit;

    private javax.swing.JLabel jLabel1;

    private javax.swing.JLabel jLabel11;

    private javax.swing.JLabel jLabel12;

    private javax.swing.JLabel jLabel13;

    private javax.swing.JLabel jLabel14;

    private javax.swing.JLabel jLabel15;

    private javax.swing.JLabel jLabel16;

    private javax.swing.JLabel jLabel3;

    private javax.swing.JLabel jLabel9;

    // End of variables declaration                  

}

Source List

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package proses;

import com.mysql.jdbc.Statement;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JOptionPane;

import koneksi.conek;

import javax.swing.table.DefaultTableModel;

/**

 *

 * @author awien

 */

public class list extends javax.swing.JFrame {

    /**

     * Creates new form list

     */

    public list() {

        initComponents();

        datatable();

    }

    /**

     * This method is called from within the constructor to initialize the form.

     * WARNING: Do NOT modify this code. The content of this method is always

     * regenerated by the Form Editor.

     */

    @SuppressWarnings("unchecked")

    // <editor-fold defaultstate="collapsed" desc="Generated Code">

    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();

        table = new javax.swing.JTable();

        btncari = new javax.swing.JButton();

        jButton2 = new javax.swing.JButton();

        jLabel1 = new javax.swing.JLabel();

        TxtC = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        table.setModel(new javax.swing.table.DefaultTableModel(

            new Object [][] {

                {null, null, null, null},

                {null, null, null, null},

                {null, null, null, null},

                {null, null, null, null}

            },

            new String [] {

                "Title 1", "Title 2", "Title 3", "Title 4"

            }

        ));

        jScrollPane1.setViewportView(table);

        btncari.setText("Cari");

        btncari.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                btncariActionPerformed(evt);

            }

        });

        jButton2.setText("Refresh");

        jButton2.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                jButton2ActionPerformed(evt);

            }

        });

        jLabel1.setText("jLabel1");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

        getContentPane().setLayout(layout);

        layout.setHorizontalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 779, Short.MAX_VALUE)

            .addGroup(layout.createSequentialGroup()

                .addContainerGap()

                .addComponent(jLabel1)

                .addGap(18, 18, 18)

                .addComponent(TxtC, javax.swing.GroupLayout.PREFERRED_SIZE, 153, javax.swing.GroupLayout.PREFERRED_SIZE)

                .addGap(18, 18, 18)

                .addComponent(btncari)

                .addGap(18, 18, 18)

                .addComponent(jButton2)

                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

        );

        layout.setVerticalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

                .addGap(30, 30, 30)

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

                    .addComponent(btncari)

                    .addComponent(jButton2)

                    .addComponent(jLabel1)

                    .addComponent(TxtC, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 43, Short.MAX_VALUE)

                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 329, javax.swing.GroupLayout.PREFERRED_SIZE))

        );

        pack();

    }// </editor-fold>

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

         DefaultTableModel tbl = new DefaultTableModel();

        tbl.addColumn("Nama");

        tbl.addColumn("No KTP");

        tbl.addColumn("Type");

        tbl.addColumn("Nama Sepeda");

        tbl.addColumn("Lama Sewa");

        tbl.addColumn("Harga");

        tbl.addColumn("Jumlah");

        tbl.addColumn("Hasil");

        table.setModel(tbl);

        try{

            Statement sta=(Statement) conek.GetConnection().createStatement();

            ResultSet res=sta.executeQuery("SELECT * FROM tbtest");

            while(res.next())

            {

                tbl.addRow(new Object[]{

                    res.getString("nama"),

                    res.getString("nokt"),

                    res.getString("jenis"),

                    res.getString("nmsepeda"),

                    res.getString("lama"),

                    res.getString("harga"),

                    res.getString("jumlah"),

                    res.getString("hasil")

                });

                table.setModel(tbl);

            }

        }catch(Exception e){

            JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");

        }

    }                                       

    private void btncariActionPerformed(java.awt.event.ActionEvent evt) {                                       

        // TODO add your handling code here:

        try{

            Statement sta=(Statement) conek.GetConnection().createStatement();

            ResultSet res=sta.executeQuery("SELECT * FROM tbtest WHERE nama =('"+TxtC.getText()+"')");

        DefaultTableModel tbl = new DefaultTableModel();

        tbl.addColumn("Nama");

        tbl.addColumn("No KTP");

        tbl.addColumn("Type");

        tbl.addColumn("Nama Sepeda");

        tbl.addColumn("Lama Sewa");

        tbl.addColumn("Harga");

        tbl.addColumn("Jumlah");

        tbl.addColumn("Hasil");

        table.setModel(tbl);

            while(res.next())

            {

                tbl.addRow(new Object[]{

                    res.getString("nama"),

                    res.getString("nokt"),

                    res.getString("jenis"),

                    res.getString("nmsepeda"),

                    res.getString("lama"),

                    res.getString("harga"),

                    res.getString("jumlah"),

                    res.getString("hasil")

                });

                table.setModel(tbl);

            }

        }catch(Exception e){

            JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");

        }

    }                                      

    public void datatable(){

        DefaultTableModel tbl = new DefaultTableModel();

        tbl.addColumn("Nama");

        tbl.addColumn("No KTP");

        tbl.addColumn("Type");

        tbl.addColumn("Nama Sepeda");

        tbl.addColumn("Lama Sewa");

        tbl.addColumn("Harga");

        tbl.addColumn("Jumlah");

        tbl.addColumn("Hasil");

        table.setModel(tbl);

        try{

            Statement sta=(Statement) conek.GetConnection().createStatement();

            ResultSet res=sta.executeQuery("SELECT * FROM tbtest");

            while(res.next())

            {

                tbl.addRow(new Object[]{

                    res.getString("nama"),

                    res.getString("nokt"),

                    res.getString("jenis"),

                    res.getString("nmsepeda"),

                    res.getString("lama"),

                    res.getString("harga"),

                    res.getString("jumlah"),

                    res.getString("hasil")

                });

                table.setModel(tbl);

            }

        }catch(Exception e){

            JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");

        }

    }

    /**

     * @param args the command line arguments

     */

    public static void main(String args[]) {

        /* Set the Nimbus look and feel */

        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">

        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.

         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html

         */

        try {

            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {

                if ("Nimbus".equals(info.getName())) {

                    javax.swing.UIManager.setLookAndFeel(info.getClassName());

                    break;

                }

            }

        } catch (ClassNotFoundException ex) {

            java.util.logging.Logger.getLogger(list.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (InstantiationException ex) {

            java.util.logging.Logger.getLogger(list.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (IllegalAccessException ex) {

            java.util.logging.Logger.getLogger(list.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (javax.swing.UnsupportedLookAndFeelException ex) {

            java.util.logging.Logger.getLogger(list.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        }

        //</editor-fold>

        /* Create and display the form */

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new list().setVisible(true);

            }

        });

    }

    // Variables declaration - do not modify                    

    private javax.swing.JTextField TxtC;

    private javax.swing.JButton btncari;

    private javax.swing.JButton jButton2;

    private javax.swing.JLabel jLabel1;

    private javax.swing.JScrollPane jScrollPane1;

    private javax.swing.JTable table;

    // End of variables declaration                  

}