test

import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
class data_transaksi extends JFrame {
    Connection kon;
    Statement s;
    ResultSet rs;

    JLabel ltransaksi,lkat,lkey;
    JTextField tkey;
    JButton hapus,kembali;
    JScrollPane sp;
    JTable ttrans;

   data_transaksi() {
        ltransaksi = new JLabel("DATA TRANSAKSI");
        lkey = new JLabel("Kata Kunci");

        tkey = new JTextField();

        hapus = new JButton("Hapus");
        kembali = new JButton("Kembali");

        ttrans = new JTable();
        sp = new JScrollPane(ttrans);

        ltransaksi.setBounds(300,10,150,25);
        lkey.setBounds(10,80,150,25);

        tkey.setBounds(150,80,150,25);

        hapus.setBounds(10,370,80,25);
        kembali.setBounds(100,370,80,25);
        sp.setBounds(10,110,650,250);

        add(lkey);
        add(ltransaksi);

        add(tkey);


        add(hapus);
        add(kembali);
        add(sp);
        tampilanData();

        kembali.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent x) {
                 new e_booking();
                 setVisible(false);
                }
            });

            tkey.addKeyListener(
        new KeyAdapter(){
            public void keyPressed(KeyEvent ke){
                int kode=ke.getKeyCode();
                if(kode==ke.VK_ENTER){
                    tampilanData();
                }
            }
        });


        setSize(700,500);
        setLayout(null);
        setVisible(true);
    }

    private Object[][]getData() throws SQLException {
        String url = "jdbc:mysql://localhost/db_booking";
        String user = "root";
        String password = "";

        Object[][]data = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(url,user,password);

            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select tbl_transaksi.id_transaksi, tbl_transaksi.id_pelanggan, tbl_pelanggan.nama, tbl_transaksi.jenis, tbl_transaksi.jumlah, tbl_transaksi.harga from tbl_transaksi, tbl_pelanggan where tbl_transaksi.id_transaksi like '%"+tkey.getText()+"%' or tbl_transaksi.id_pelanggan like '%"+tkey.getText()+"%' or tbl_pelanggan.nama like '%"+tkey.getText()+"%'or tbl_transaksi.jenis like '%"+tkey.getText()+"%' or tbl_transaksi.asal like '%"+tkey.getText()+"%' or tbl_transaksi.tujuan like '%"+tkey.getText()+"%'");

            rs.last();
            int rowCount = rs.getRow();
            rs.beforeFirst();

            data = new Object[rowCount][7];
            int no = 0;
            while (rs.next()) {
                data[no][0] = rs.getString("id_transaksi");
                data[no][1] = rs.getString("id_pelanggan");

                data[no][2] = rs.getString("nama");
                data[no][3] = rs.getString("jenis");
                data[no][4] = rs.getString("jumlah");
                data[no][5] = rs.getString("harga");
                int a = Integer.parseInt(rs.getString("jumlah"));
                int b = Integer.parseInt(rs.getString("harga"));
                data[no][6] = a*b;
                no = no+1;
            }
            st.close();
            con.close();
        }
        catch(ClassNotFoundException e){System.out.println("koneksi gagal "+e.toString());}
        return data;
    }

    private void tampilanData() {
        try {
            String [] cn = {"id_transaksi","id_pelanggan","nama","jenis","jumlah","harga","total"};
            JTable ttrans = new JTable(getData(),cn);
            sp.setViewportView(ttrans);
        }
            catch(SQLException e) {
                System.err.println(e.getMessage());
            }
        }

        public static void main (String[] args) {
            new data_transaksi();
        }
    }