Berikut coding untuk aplikasi pencarian dengan JComboBox Java Visual dan Mysql
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.table.DefaultTableModel;
class Aplikasi_Cari_Combobox extends JFrame
{
JLabel gambar = new JLabel(new ImageIcon("gambar/template.jpg"));
JLabel judul = new JLabel("Aplikasi Pencarian Data Mahasiswa");
JLabel garis = new JLabel ("===============================================================");
JLabel Lcari = new JLabel ("Cari Data Berdasarkan :");
String [] cari = {"Mata Kuliah","Java Visual","PBO","VIBI","Database","Jaringan","C++"};
JComboBox cbcari = new JComboBox(cari);
String [] header = {"NIM","Nama","Kelas","Mata_Kuliah","Tugas1","Tugas2","Tugas3","Tugas4","Tugas5","UTS","UAS","Nilai_Angka","Nilai_Huruf"};
DefaultTableModel model = new DefaultTableModel(null,header);
JTable tabel = new JTable(model);
JScrollPane pane = new JScrollPane (tabel);
Aplikasi_Cari_Combobox()
{
setTitle("Aplikasi Pencarian Data Mahasiswa");
setLocation(0,0);
setSize(1020, 400);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
void KomponenVisual()
{
getContentPane().setLayout(null);
getContentPane().setBackground(Color.pink);
getContentPane().add(judul);
judul.setBounds(300,10,300,20);
judul.setFont(new Font("Tempus Sans ITC",Font.BOLD,18));
getContentPane().add(garis);
garis.setBounds(200,30,590,20);
getContentPane().add(Lcari);
Lcari.setBounds(200,60,150,20);
getContentPane().add(cbcari);
cbcari.setBounds(360,60,150,30);
getContentPane().add(pane);
pane.setBounds(10,130,985,200);
pane.setOpaque(false); //untuk tranparan tabel
pane.getViewport().setOpaque(false); //untuk tranparan tabel
setVisible(true);
loadData(); //ambil data di void load data
}
void AksiReaksi()
{
cbcari.addActionListener(new ActionListener() //untuk tombol cari
{
public void actionPerformed (ActionEvent e)
{
if(cbcari.isEnabled()==true)
{
if(cbcari.getSelectedItem().equals(""))
{
JOptionPane.showMessageDialog(null,"Data belum dipilih");
}
else
{
String sPilihan = String.valueOf(cbcari.getSelectedItem());
proses_temukanData("select * from datanilai where mata_kuliah = '"+sPilihan+"'");
}}
else
{
JOptionPane.showMessageDialog(null,"maaf Data yang anda cari tidak ada");
proses_temukanData(" ");
} } } ) ;
}
///////////////////////////////////////////////////////////////////
//untuk proses temukan data
void proses_temukanData(String sql)
{
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
try
{
Connection koneksi = DriverManager.getConnection("jdbc:mysql://localhost/DataMahasiswa","root","");
Statement stm= koneksi.createStatement();
ResultSet r = stm.executeQuery(sql);
while(r.next())
{
String nim = r.getString("nim");
String nama = r.getString("nama");
String kelas = r.getString("kelas");
String kuliah = r.getString("mata_kuliah");
String tugas1 = r.getString("tugas1");
String tugas2 = r.getString("tugas2");
String tugas3 = r.getString("tugas3");
String tugas4 = r.getString("tugas4");
String tugas5 = r.getString("tugas5");
String uts = r.getString("uts");
String uas = r.getString("uas");
String Nilai_Angka = r.getString("Nilai_Angka");
String Nilai_Huruf = r.getString("Nilai_Huruf");
String[] dataBaris={nim,nama,kelas,kuliah,tugas1,tugas2,tugas3,tugas4,tugas5,uts,uas,Nilai_Angka,Nilai_Huruf};
model.addRow(dataBaris);
}
r.close();
stm.close();
}
catch(SQLException ext)
{
System.err.println("Pencarian Data Error :"+ext);
} }
////////////////////////////////////////////////////////////////////
void loadData() //untuk tampil data
{
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
try
{
Connection koneksi = DriverManager.getConnection("jdbc:mysql://localhost/DataMahasiswa","root","");
Statement stm=koneksi.createStatement();
String sql="select * from datanilai ";
ResultSet r=stm.executeQuery(sql);
while(r.next())
{
Object[]ob=new Object[14];
ob[0]=r.getString("nim");
ob[1]=r.getString("nama");
ob[2]=r.getString("kelas");
ob[3]=r.getString("mata_kuliah");
ob[4]=r.getString("tugas1");
ob[5]=r.getString("tugas2");
ob[6]=r.getString("tugas3");
ob[7]=r.getString("tugas4");
ob[8]=r.getString("tugas5");
ob[9]=r.getString("uts");
ob[10]=r.getString("uas");
ob[11]=r.getString("Nilai_Angka");
ob[12]=r.getString("Nilai_Huruf");
model.addRow(ob);
}
r.close();
stm.close();
}
catch(SQLException e)
{
System.out.println("Load Data Error : "+e);
} }
public static void main(String[]args)
{
Aplikasi_Cari_Combobox acc = new Aplikasi_Cari_Combobox();
acc.KomponenVisual();
acc.AksiReaksi();
} }