CariProdukModel

/*
 * 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 model;

import controller.CariProdukController;
import koneksi.koneksi;
import view.FormCariProduk;
import view.FormKasir;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;

/**
 *
 * @author Rendra Triyanto
 */
public class CariProdukModel implements CariProdukController {

    @Override
    public void Tampil(FormCariProduk cp) throws SQLException {
        cp.tbl.getDataVector().removeAllElements();
        cp.tbl.fireTableDataChanged();
        try {
            Connection con = koneksi.getKoneksi();
            Statement st = con.createStatement();
            String sql = "select * from tbl_barang order by kode_barang asc";
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()) {
                Object[] ob = new Object[8];
                ob[0] = rs.getString(1);
                ob[1] = rs.getString(2);
                ob[2] = rs.getString(3);
                ob[3] = rs.getString(4);
                ob[4] = rs.getString(5);
                cp.tbl.addRow(ob);
            }
        } catch (Exception e) {
            System.out.println(e);
        }
    }

    @Override
    public void KlikTabel(FormCariProduk cb) throws SQLException {
        try {
            int pilih = cb.tblCariProduk.getSelectedRow();
            if (pilih == -1) {
                return;
            }
            FormKasir.txtkode_barang.setText(cb.tbl.getValueAt(pilih, 0).toString());
            FormKasir.txtnama.setText(cb.tbl.getValueAt(pilih, 1).toString());
            FormKasir.txtharga.setText(cb.tbl.getValueAt(pilih, 3).toString());
            FormKasir.txtjumlah.setText("1");
            FormKasir.btnOK.requestFocus();
        } catch (Exception e) {
        }
    }

    @Override
    public void Cari(FormCariProduk cp) throws SQLException {
        cp.tbl.getDataVector().removeAllElements();
        cp.tbl.fireTableDataChanged();
        try {
            Connection con = koneksi.getKoneksi();
            Statement st = con.createStatement();
            String sql = "select * from tbl_barang where nama like '%" + cp.txtCari.getText() + "%'";
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()) {
                Object[] ob = new Object[8];
                ob[0] = rs.getString(1);
                ob[1] = rs.getString(2);
                ob[2] = rs.getString(3);
                ob[3] = rs.getString(4);
                ob[4] = rs.getString(5);
                cp.tbl.addRow(ob);
            }
        } catch (Exception e) {
            System.out.println(e);
        }
    }

}