Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //import java.io.*;
- //creator by. Ramadhani,S.Kom
- // Politeknik Aceh
- import java.sql.*;
- import javax.swing.*;
- import java.awt.*;
- import java.awt.event.*;
- import javax.swing.table.DefaultTableModel;
- class Aplikasi_Cari_Sql extends JFrame
- {
- JLabel gambar = new JLabel(new ImageIcon("gambar/template.jpg"));
- JLabel judul = new JLabel("Aplikasi Pencarian Data Mahasiswa");
- JLabel garis = new JLabel ("=================================================================================");
- JLabel namaku = new JLabel ("Creator By. Ramadhani,S.Kom");
- JLabel Lcari = new JLabel ("Cari Data Berdasarkan :");
- String [] cari = {"Pilih salah satu","NIM","Nama","Kelas","Kelompok","Tugas1","Tugas2","Tugas3","Tugas4","Tugas5","UTS","UAS","Nilai_Angka","Nilai_Huruf"};
- JComboBox cbcari = new JComboBox(cari);
- JLabel Ldata = new JLabel ("Masukan Data :");
- JTextField txdata = new JTextField ();
- JButton tblcari = new JButton ("Search");
- JButton tblclear = new JButton ("Clear");
- JButton tblLoad = new JButton ("Load Data");
- JButton tblcetak = new JButton ("Print");
- JButton tblexit = new JButton ("Exit");
- DefaultTableModel model = new DefaultTableModel();
- JTable Tabelcari = new JTable();
- JScrollPane pane = new JScrollPane (Tabelcari);
- Aplikasi_Cari_Sql()
- {
- setTitle("Aplikasi Pencarian Data Mahasiswa");
- setLocation(0,0);
- setSize(900, 500);
- setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
- }
- void KomponenVisual()
- {
- getContentPane().setLayout(null);
- getContentPane().add(judul);
- judul.setBounds(300,10,300,20);
- judul.setFont(new Font("Tempus Sans ITC",Font.BOLD,18));
- getContentPane().add(namaku);
- namaku.setBounds(10,10,200,20);
- namaku.setEnabled(false);
- getContentPane().add(garis);
- garis.setBounds(200,30,590,20);
- getContentPane().add(Lcari);
- Lcari.setBounds(10,60,150,20);
- getContentPane().add(cbcari);
- cbcari.setBounds(180,60,150,20);
- getContentPane().add(Ldata);
- Ldata.setBounds(10,90,100,20);
- getContentPane().add(txdata);
- txdata.setBounds(180,90,150,20);
- getContentPane().add(tblcari);
- tblcari.setBounds(340,60,100,50);
- tblcari.setHorizontalAlignment(SwingConstants.LEADING);
- getContentPane().add(tblclear);
- tblclear.setBounds(450,60,100,50);
- tblclear.setHorizontalAlignment(SwingConstants.CENTER);
- getContentPane().add(tblLoad);
- tblLoad.setBounds(560,60,100,50);
- getContentPane().add(tblcetak);
- tblcetak.setBounds(670,60,100,50);
- getContentPane().add(tblexit);
- tblexit.setBounds(780,60,100,50);
- getContentPane().add(pane);
- pane.setBounds(10,130,865,320);
- Tabelcari.setModel(model); //untuk header kolom tabel
- model.addColumn("NIM");
- model.addColumn("Nama");
- model.addColumn("Kelas");
- model.addColumn("Kelompok");
- model.addColumn("Tugas 1");
- model.addColumn("Tugas 2");
- model.addColumn("Tugas 3");
- model.addColumn("Tugas 4");
- model.addColumn("Tugas 5");
- model.addColumn("UTS");
- model.addColumn("UAS");
- model.addColumn("Nilai Akhir");
- model.addColumn("Nilai Huruf");
- getContentPane().add(gambar);
- gambar.setBounds(0,0,900,500);
- setVisible(true);
- loadData(); //untuk ambil data
- }
- void AksiReaksi()
- {
- tblLoad.addActionListener(new ActionListener() //untuk tombol load data
- {
- public void actionPerformed (ActionEvent e)
- {
- loadData(); //untuk ambil data
- } } );
- tblcari.addActionListener(new ActionListener() //untuk tombol cari
- {
- public void actionPerformed (ActionEvent e)
- {
- if(txdata.isEnabled()==true)
- {
- if(txdata.getText().equals(""))
- {
- JOptionPane.showMessageDialog(null,"Data belum dimasukkan");
- }
- else
- {
- String sPilihan = String.valueOf(cbcari.getSelectedItem());
- String sData=txdata.getText();
- proses_temukanData("select * from datanilai where "+sPilihan+" = '"+sData+"'");
- }}
- else
- {
- // JOptionPane.showMessageDialog(null,"maaf Data yang anda cari tidak ada");
- proses_temukanData(" ");
- }}});
- tblclear.addActionListener(new ActionListener() //untuk hapus data
- {
- public void actionPerformed (ActionEvent e)
- {
- resetData();
- }});
- tblcetak.addActionListener(new ActionListener() //UNTUK PRINT
- {
- public void actionPerformed (ActionEvent e)
- {
- int y = 0;
- Frame fr = new Frame();
- PrintJob print = fr.getToolkit().getPrintJob(fr, "Prinnting", null, null);
- if (print != null)
- {
- Graphics g = print.getGraphics();
- if (g != null)
- {
- //untuk kop (header)
- g.setFont(new Font("Dialog", 1, 11));
- g.drawString("LAPORAN DATA NILAI MAHASISWA", 150, 40);
- //untuk nama kolom tabel
- String nim = model.getColumnName(0);
- String nama = model.getColumnName(1);
- String kelas = model.getColumnName(2);
- String kuliah = model.getColumnName(3);
- String tugas1 = model.getColumnName(4);
- String tugas2 = model.getColumnName(5);
- String tugas3 = model.getColumnName(6);
- String tugas4 = model.getColumnName(7);
- String tugas5 = model.getColumnName(8);
- String uts = model.getColumnName(9);
- String uas = model.getColumnName(10);
- String akhir = model.getColumnName(11);
- String huruf = model.getColumnName(12);
- g.setFont(new Font("Dialog", 1, 8));
- g.drawString(nim, 30, 70);
- g.drawString(nama, 80, 70);
- g.drawString(kelas, 130, 70);
- g.drawString(kuliah, 160, 70);
- g.drawString(tugas1, 240, 70);
- g.drawString(tugas2, 280, 70);
- g.drawString(tugas3, 320, 70);
- g.drawString(tugas4, 360, 70);
- g.drawString(tugas5, 400, 70);
- g.drawString(uts, 440, 70);
- g.drawString(uas, 470, 70);
- g.drawString(akhir, 500, 70);
- g.drawString(huruf, 530, 70);
- g.drawLine(30, 73, 570, 73); //untuk garis
- //untuk datanya tabel
- int n = model.getRowCount();
- for (int i = 0; i < n; i++)
- {
- int k = i + 1;
- int j = 10 * k;
- y = 73 + j;
- g.setFont(new Font("Dialog", 0, 8)); //untuk buat tulisan
- String data_nim = model.getValueAt(i, 0).toString();
- String data_nama = model.getValueAt(i, 1).toString();
- String data_kelas = model.getValueAt(i, 2).toString();
- String data_kuliah = model.getValueAt(i, 3).toString();
- String data_tugas1 = model.getValueAt(i, 4).toString();
- String data_tugas2 = model.getValueAt(i, 5).toString();
- String data_tugas3 = model.getValueAt(i, 6).toString();
- String data_tugas4 = model.getValueAt(i, 7).toString();
- String data_tugas5 = model.getValueAt(i, 8).toString();
- String data_uts = model.getValueAt(i, 9).toString();
- String data_uas = model.getValueAt(i, 10).toString();
- String data_akhir = model.getValueAt(i, 11).toString();
- String data_huruf = model.getValueAt(i, 12).toString();
- g.drawString(data_nim, 30, y);
- g.drawString(data_nama, 80, y);
- g.drawString(data_kelas, 130, y);
- g.drawString(data_kuliah, 160, y);
- g.drawString(data_tugas1, 250, y);
- g.drawString(data_tugas2, 290, y);
- g.drawString(data_tugas3, 330, y);
- g.drawString(data_tugas4, 370, y);
- g.drawString(data_tugas5, 410, y);
- g.drawString(data_uts, 445, y);
- g.drawString(data_uas, 475, y);
- g.drawString(data_akhir, 505, y);
- g.drawString(data_huruf, 540, y);
- }
- }
- print.end();
- print.end();
- } } } );
- tblexit.addActionListener (new ActionListener() //untuk keluar
- {
- public void actionPerformed (ActionEvent e)
- {
- System.exit(0);
- }} );
- }
- //untuk bersihin layar
- void resetData()
- {
- txdata.setText("");
- }
- //untuk proses temukan data
- void proses_temukanData(String sql)
- {
- model.getDataVector().removeAllElements();
- model.fireTableDataChanged();
- try
- {
- Connection koneksi = DriverManager.getConnection("jdbc:mysql://localhost/DataMahasiswa","root","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 kelompok = r.getString("kelompok");
- 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,kelompok,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
- {
- //Class.forName("com.mysql.jdbc.Driver");
- Connection koneksi = DriverManager.getConnection("jdbc:mysql://localhost/DataMahasiswa","root","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("kelompok");
- 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);
- }
- /*Tabelcari.addMouseListener(new MouseListener() //untuk tabel cari
- {
- public void mouseClicked(MouseEvent e)
- {
- int i=Tabelcari.getSelectedRow();
- if(i==-1)
- {
- return;
- } }
- public void mousePressed(MouseEvent e){}
- public void mouseReleased(MouseEvent e){}
- public void mouseEntered(MouseEvent e){}
- public void mouseExited(MouseEvent e){}
- }); */
- }
- public static void main(String[]args)
- {
- Aplikasi_Cari_Sql acs = new Aplikasi_Cari_Sql();
- acs.KomponenVisual();
- acs.AksiReaksi();
- } }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement