APLIKASI MENGAJAR DOSEN
Source code :
// Membuat class data dosen
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package aktivitas;
/**
*
* @author Mzhud
*/
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.net.URL;
import java.nio.ByteBuffer;
import java.nio.channels.FileChannel;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.imageio.ImageIO;
import javax.swing.table.DefaultTableModel;
public class data_dosen extends JFrame {
ImageIcon pic = new ImageIcon("src/gambar/Untitled-2.jpg");
ImageIcon pic1 = new ImageIcon("src/gambar/Untitled-5.jpg");
ImageIcon pic2 = new ImageIcon("src/gambar/Untitled-6.jpg");
ImageIcon pic3 = new ImageIcon("src/gambar/Untitled-7.jpg");
ImageIcon pic4 = new ImageIcon("src/gambar/Untitled-8.jpg");
ImageIcon pic5 = new ImageIcon("src/gambar/Untitled-9.jpg");
private Statement stat;
private Connection con;
private ResultSet rs;
private String folder;
private JFileChooser chooser = new JFileChooser();
String a[] = {"Kode", "Nama Dosen", "Matakuliah"};
JLabel gambar2 = new JLabel();
JPanel foto = new JPanel();
JLabel foto1 = new JLabel("Foto");
JTextField browse = new JTextField(20);
JButton btn6 = new JButton("");
JLabel txt1 = new JLabel("Kode");
JLabel txt2 = new JLabel("Nama Dosen");
JLabel txt3 = new JLabel("Kode Matkul");
JLabel txt4 = new JLabel("Hari");
JLabel txt6 = new JLabel("Kelas");
JLabel txt7 = new JLabel("Ruang");
JLabel txt1_1 = new JLabel(":");
JLabel txt2_2 = new JLabel(":");
JLabel txt3_3 = new JLabel(":");
JLabel txt4_4 = new JLabel(":");
JLabel txt5_5 = new JLabel(":");
JLabel txt6_6 = new JLabel(":");
JLabel txt7_7 = new JLabel(":");
JTextField fil1 = new JTextField(20);
JTextField fil2 = new JTextField(20);
JTextField fil3 = new JTextField(20);
JTextField fil4 = new JTextField(20);
JTextField fil5 = new JTextField(20);
JTextField fil6 = new JTextField(20);
JTextField fil7 = new JTextField(20);
JTextField fil8 = new JTextField(20);
JButton btn1 = new JButton("");
JButton btn2 = new JButton("");
JButton btn3 = new JButton("");
JButton btn4 = new JButton("");
JButton btn5 = new JButton("");
DefaultTableModel model = new DefaultTableModel();
JTable tbl1 = new JTable();
JScrollPane sc1 = new JScrollPane();
JLabel gambar = new JLabel();
data_dosen() {
setTitle("Dosen");
setLayout(null);
setSize(678, 690);
setLocation(440, 10);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
formWindowClosing(evt);
}
});
setVisible(true);
setResizable(false);
try {
Class.forName("org.postgresql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:postgresql://localhost/aktivitas_mengajar_dosen", "hudan", "budokter");
stat = con.createStatement();
System.out.println("Koneksi berhasil");
} catch (Exception e) {
System.out.println("Koneksi gagal");
}
folder = System.getProperty("user.dir") + File.separator + "images";
cetak(folder);
new File(folder).mkdir();
}
void tampil() {
setContentPane(gambar);
gambar.setIcon(pic);
model = new DefaultTableModel(null, a);
tbl1.setModel(model);
sc1.getViewport().add(tbl1);
sc1.setBounds(67, 433, 570, 117);
getContentPane().add(sc1);
getContentPane().add(gambar2);
getContentPane().add(foto);
getContentPane().add(foto1);
getContentPane().add(browse);
getContentPane().add(btn6);
getContentPane().add(txt1);
getContentPane().add(txt2);
getContentPane().add(txt3);
getContentPane().add(txt4);
getContentPane().add(txt5);
getContentPane().add(txt6);
getContentPane().add(txt7);
getContentPane().add(txt1_1);
getContentPane().add(txt2_2);
getContentPane().add(txt3_3);
getContentPane().add(txt4_4);
getContentPane().add(txt5_5);
getContentPane().add(txt6_6);
getContentPane().add(txt7_7);
getContentPane().add(fil1);
getContentPane().add(fil2);
getContentPane().add(fil3);
getContentPane().add(fil4);
getContentPane().add(fil5);
getContentPane().add(fil6);
getContentPane().add(fil7);
getContentPane().add(fil8);
getContentPane().add(btn1);
getContentPane().add(btn2);
getContentPane().add(btn3);
getContentPane().add(btn4);
getContentPane().add(btn5);
foto1.setBounds(543, 115, 100, 100);
foto1.setFont(new java.awt.Font("Times new roman", 200, 25));
gambar2.setBounds(505, 185, 120, 120);
foto.setBounds(505, 185, 120, 120);
browse.setBounds(489, 311, 150, 20);
btn6.setBounds(522, 337, 87, 23);
btn6.setIcon(pic5);
txt1.setBounds(90, 157, 200, 20);
txt1_1.setBounds(230, 147, 200, 30);
txt1_1.setFont(new java.awt.Font("Times new roman", 200, 35));
txt1.setForeground(Color.BLACK);
txt1.setFont(new java.awt.Font("Times new roman", 100, 25));
txt1_1.setForeground(Color.BLACK);
txt2.setBounds(90, 185, 200, 20);
txt2.setForeground(Color.BLACK);
txt2.setFont(new java.awt.Font("Times new roman", 100, 25));
txt2_2.setBounds(230, 178, 200, 30);
txt2_2.setFont(new java.awt.Font("Times new roman", 200, 35));
txt2_2.setForeground(Color.BLACK);
txt3.setBounds(90, 219, 200, 20);
txt3.setFont(new java.awt.Font("Times new roman", 100, 25));
txt3.setForeground(Color.BLACK);
txt3_3.setBounds(230, 212, 200, 30);
txt3_3.setFont(new java.awt.Font("Times new roman", 200, 35));
txt3_3.setForeground(Color.BLACK);
txt4.setBounds(90, 253, 200, 20);
txt4.setFont(new java.awt.Font("Times new roman", 100, 25));
txt4.setForeground(Color.BLACK);
txt4_4.setBounds(230, 244, 200, 30);
txt4_4.setFont(new java.awt.Font("Times new roman", 200, 35));
txt4_4.setForeground(Color.BLACK);
txt5.setBounds(90, 286, 200, 20);
txt5.setFont(new java.awt.Font("Times new roman", 100, 25));
txt5.setForeground(Color.BLACK);
txt5_5.setBounds(230, 274, 200, 30);
txt5_5.setFont(new java.awt.Font("Times new roman", 200, 35));
txt5_5.setForeground(Color.BLACK);
txt6.setBounds(90, 312, 200, 20);
txt6.setFont(new java.awt.Font("Times new roman", 100, 25));
txt6.setForeground(Color.BLACK);
txt6_6.setBounds(230, 304, 200, 30);
txt6_6.setFont(new java.awt.Font("Times new roman", 200, 35));
txt6_6.setForeground(Color.BLACK);
txt7.setBounds(90, 336, 200, 30);
txt7.setFont(new java.awt.Font("Times new roman", 100, 25));
txt7.setForeground(Color.BLACK);
txt7_7.setBounds(230, 334, 200, 30);
txt7_7.setFont(new java.awt.Font("Times new roman", 200, 35));
txt7_7.setForeground(Color.BLACK);
fil1.setBounds(260, 153, 215, 25);
fil2.setBounds(260, 184, 215, 25);
fil3.setBounds(260, 215, 215, 25);
fil4.setBounds(69, 386, 100, 25);
fil5.setBounds(260, 245, 215, 25);
fil6.setBounds(260, 275, 215, 25);
fil7.setBounds(260, 305, 215, 25);
fil8.setBounds(260, 335, 215, 25);
btn1.setBounds(260, 385, 70, 30);
btn1.setIcon(pic1);
btn2.setBounds(406, 385, 70, 30);
btn2.setIcon(pic3);
btn3.setBounds(333, 385, 70, 30);
btn3.setIcon(pic2);
btn4.setBounds(481, 153, 24, 24);
btn4.setIcon(pic4);
btn5.setBounds(175, 386, 24, 25);
btn5.setIcon(pic4);
btn1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
simpan();
bersih();
}
});
btn2.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
hapus();
bersih();
}
});
btn3.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
edit();
bersih();
}
});
btn4.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
cari();
}
});
btn5.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
mencari();
}
});
btn6.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
browse();
}
});
}
void mencari() {
if (fil4.getText().equals("")) {
try {
tbl1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
} else {
cari1();
String kode_dos = fil4.getText();
try {
stat = (Statement) con.createStatement();
String sql = "SELECT data_dosen.kode_dos, data_dosen.nama, data_mata_kuliah.matkul from data_dosen, data_mata_kuliah where data_dosen.kode_mk=data_mata_kuliah.kode_mk and kode_dos = '" + kode_dos + "'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String[] row = {
rs.getString(1),
rs.getString(2),
rs.getString(3)
};
model.addRow(row);
}
stat.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
bersih();
fil1.setEditable(false);
}
}
private void cari1() {
String[] field = {"Kode", "Nama Dosen", "Matakuliah"};
model = new DefaultTableModel(null, field);
tbl1.setModel(model);
}
void cari() {
int kode_dos = Integer.parseInt(fil1.getText());
try {
ResultSet isi = stat.executeQuery("SELECT * FROM data_dosen WHERE kode_dos = '" + kode_dos + "'");
if (isi.next()) {
fil1.setText(isi.getString(1));
gambar2.setIcon(new ImageIcon("C:/Users/acer/Documents/NetBeansProjects/aktivitas_mengajar_dosen/images/" + isi.getString(1) + ".jpg"));
fil2.setText(isi.getString(2));
fil3.setText(isi.getString(3));
fil5.setText(isi.getString(4));
fil6.setText(isi.getString(5));
fil7.setText(isi.getString(6));
fil8.setText(isi.getString(7));
}
fil1.setEditable(false);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Pencarian Gagal\n" + ex);
}
}
void simpan() {
String kode_dos = fil1.getText();
String nama_dos = fil2.getText();
String kode_mk = fil3.getText();
String hari = fil5.getText();
String kelas = fil7.getText();
String ruang = fil8.getText();
try {
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection("jdbc:postgresql://localhost/aktivitas_mengajar_dosen", "hudan", "budokter");
Connection con1 = DriverManager.getConnection("jdbc:postgresql://localhost/aktivitas_mengajar_dosen", "hudan", "budokter");
Statement statement = con.createStatement();
Statement statement1 = con1.createStatement();
String sql1 = "select count(*) from data_dosen where hari='" + hari + "' and jam='" + jam + "' and ruang='" + ruang + "'";
String sql = "insert into data_dosen values ('" + kode_dos + "','" + nama_dos + "','" + kode_mk + "','" + hari + "','" + jam + "','" + kelas + "','" + ruang + "')";
try {
new NIOCopier(browse.getText(), gambar2(fil1.getText()));
if (statement.executeUpdate(sql) > 0) {
JOptionPane.showMessageDialog(this, "Penyimpanan berhasil");
}
} catch (Exception ex) {
cetak(ex.toString());
}
ResultSet hasil = statement1.executeQuery(sql1);
if (hasil.next()) {
int total = hasil.getInt(1);
System.out.println("hasil=" + total);
if (total > 0) {
JOptionPane.showMessageDialog(this, "Maaf Gagal");;
} else {
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(this, "Data Tersimpan");;
}
}
} catch (Exception ex) {
// JOptionPane.showMessageDialog(null, "Maaf Anda GAGAL ! \n");
} finally {
ketabel1("SELECT data_dosen.kode_dos, data_dosen.nama, data_mata_kuliah.matkul from data_dosen, data_mata_kuliah where data_dosen.kode_mk=data_mata_kuliah.kode_mk order by kode_dos asc");
}
fil1.setEditable(true);
}
void edit() {
String kode_dos = fil1.getText();
String nama_dos = fil2.getText();
String kode_mk = fil3.getText();
String hari = fil5.getText();
String jam = fil6.getText();
String kelas = fil7.getText();
String ruang = fil8.getText();
try {
Statement statement = con.createStatement();
String sql = "update data_dosen set nama = '" + nama_dos + "',kode_mk = '" + kode_mk + "',hari = '" + hari + "',jam = '" + jam + "',kelas = '" + kelas + "',ruang = '" + ruang + "'where kode_dos ='" + kode_dos + "'";
try {
new NIOCopier(browse.getText(), gambar2(fil1.getText()));
} catch (IOException ex) {
System.out.println(ex.getMessage());
}
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Diubah");
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Maaf Anda GAGAL ! \n");
} finally {
ketabel1("SELECT data_dosen.kode_dos, data_dosen.nama, data_mata_kuliah.matkul from data_dosen, data_mata_kuliah where data_dosen.kode_mk=data_mata_kuliah.kode_mk order by kode_dos asc");
}
fil1.setEditable(true);
}
void hapus() {
String kode_dos = fil1.getText();
try {
Statement statement = con.createStatement();
String sql = "delete from data_dosen where kode_dos = '" + kode_dos + "'";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null, "Data Dihapus");
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Maaf Anda GAGAL ! \n");
} finally {
ketabel1("SELECT data_dosen.kode_dos, data_dosen.nama, data_mata_kuliah.matkul from data_dosen, data_mata_kuliah where data_dosen.kode_mk=data_mata_kuliah.kode_mk order by kode_dos asc");
}
fil1.setEditable(true);
}
void bersih() {
fil1.setText("");
fil2.setText("");
fil3.setText("");
fil5.setText("");
fil6.setText("");
fil7.setText("");
fil8.setText("");
browse.setText("");
gambar2.setIcon(new ImageIcon(""));
}
void ketabel1(String sql) {
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
try {
rs = stat.executeQuery(sql);
while (rs.next()) {
model.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),});
}
rs.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Kesalahan\n" + ex);
}
}
private void formWindowClosing(java.awt.event.WindowEvent evt) {
// TODO add your handling code here
int keluar = JOptionPane.showConfirmDialog(null, "Apakah Anda yakin ingin keluar", "Konfirmasi", JOptionPane.YES_NO_OPTION);
if (keluar == JOptionPane.YES_OPTION) {
display_mengajar_dosen a = new display_mengajar_dosen();
a.setVisible(true);
a.tampil();
setVisible(false);
} else {
setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
}
}
void browse() {
int jes = chooser.showOpenDialog(this);
if (jes == chooser.APPROVE_OPTION) {
File f = chooser.getSelectedFile();
browse.setText(f.getPath());
gambar2.setIcon(new ImageIcon(f.getPath()));
}
}
private void cetak(String folder) {
System.out.println(folder);
}
//@Override
public class NIOCopier {
public NIOCopier(String asal, String tujuan) throws IOException {
FileInputStream inFile = new FileInputStream(asal);
FileOutputStream outFile = new FileOutputStream(tujuan);
FileChannel inChannel = inFile.getChannel();
FileChannel outChannel = outFile.getChannel();
for (ByteBuffer buffer = ByteBuffer.allocate(1024 * 1024);
inChannel.read(buffer) != -1;
buffer.clear()) {
buffer.flip();
while (buffer.hasRemaining()) {
outChannel.write(buffer);
}
}
inChannel.close();
outChannel.close();
}
}
//Method Untuk Memanggil Image/gambar
public static BufferedImage loadImage(String ref) {
BufferedImage bimg = null;
try {
bimg = ImageIO.read(new File(ref));
} catch (Exception e) {
e.printStackTrace();
}
return bimg;
}
//Method untuk Resize Image
public static BufferedImage resize(BufferedImage img, int newW, int newH) {
int w = img.getWidth();
int h = img.getHeight();
BufferedImage dimg = dimg = new BufferedImage(newW, newH,
img.getType());
Graphics2D g = dimg.createGraphics();
g.setRenderingHint(RenderingHints.KEY_INTERPOLATION,
RenderingHints.VALUE_INTERPOLATION_BILINEAR);
g.drawImage(img, 0, 0, newW, newH, 0, 0, w, h, null);
g.dispose();
return dimg;
}
public class Painter extends JLabel {
Image image;
public void setImage(String file) {
URL url = null;
try {
url = new File(file).toURI().toURL();
} catch (Exception ex) {
cetak(ex.toString());
}
image = getToolkit().getImage(url);
repaint();
}
@Override
public void paint(Graphics g) {
double d = image.getHeight(this) / this.getHeight();
double w = image.getWidth(this) / d;
double x = this.getWidth() / 2 - w / 2;
g.drawImage(image, (int) x, 0, (int) (w), this.getHeight(), this);
}
}
private String gambar2(String id) {
return folder + File.separator + id.trim() + ".jpg";
}
public static void main(String[] args) {
// TODO code application logic here
data_dosen a = new data_dosen();
a.tampil();
a.ketabel1("SELECT data_dosen.kode_dos, data_dosen.nama, data_mata_kuliah.matkul from data_dosen, data_mata_kuliah where data_dosen.kode_mk=data_mata_kuliah.kode_mk order by kode_dos asc");
}
}
// Membuat class data profil
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package aktivitas;
/**
*
* @author Mzhud
*/
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.table.DefaultTableModel;
public class data_mas_hud extends JFrame {
ImageIcon pic = new ImageIcon("src/gambar/Untitled-3.jpg");
ImageIcon pic1 = new ImageIcon("src/gambar/fotoku.jpg");
private Statement stat;
private Connection con;
private ResultSet rs;
JLabel foto = new JLabel();
JTextArea fil1 = new JTextArea();
JLabel gambar = new JLabel();
data_mas_hud() {
setTitle("Profil");
setLayout(null);
setSize(572, 662);
setLocation(440, 40);
setVisible(true);
setResizable(false);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
formWindowClosing(evt);
}
});
setVisible(true);
setResizable(false);
try {
Class.forName("org.postgresql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:postgresql://localhost/tugas_uas", "hudan", "budokter");
stat = con.createStatement();
System.out.println("Koneksi berhasil");
} catch (Exception e) {
System.out.println("Koneksi gagal");
}
}
void tampil() {
setContentPane(gambar);
gambar.setIcon(pic);
getContentPane().add(foto);
getContentPane().add(fil1);
fil1.setText("Nama = Hudan Dardiri"
+ "\nNIM = 11650012"
+ "\nJurusan = Teknik Informatika"
+ "\nAngkatan = 2011");
fil1.setFont(new java.awt.Font("Lucida Calligraphy", 0, 22));
fil1.setEditable(false);
fil1.setForeground(Color.blue);
foto.setBounds(180, 155, 200, 200);
foto.setIcon(pic1);
fil1.setBounds(85, 380, 400, 125);
}
private void formWindowClosing(java.awt.event.WindowEvent evt) {
// TODO add your handling code here
int keluar = JOptionPane.showConfirmDialog(null, "Apakah Anda yakin ingin keluar", "Konfirmasi", JOptionPane.YES_NO_OPTION);
if (keluar == JOptionPane.YES_OPTION) {
display_mengajar_dosen a = new display_mengajar_dosen();
a.setVisible(true);
a.tampil();
setVisible(false);
} else {
setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
}
}
public static void main(String[] args) {
// TODO code application logic here
data_mas_hud a = new data_mas_hud();
a.tampil();
}
}
// Membuat class mata kuliah
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package aktivitas;
/**
*
* @author Mzhud
*/
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.table.DefaultTableModel;
public class data_mata_kuliah extends JFrame {
ImageIcon pic = new ImageIcon("src/gambar/Untitled-1.jpg");
ImageIcon pic1 = new ImageIcon("src/gambar/Untitled-5.jpg");
ImageIcon pic2 = new ImageIcon("src/gambar/Untitled-6.jpg");
ImageIcon pic3 = new ImageIcon("src/gambar/Untitled-7.jpg");
ImageIcon pic4 = new ImageIcon("src/gambar/Untitled-8.jpg");
private Statement stat;
private Connection con;
private ResultSet rs;
String a[] = {"Kode MK", "Nama MK", "SKS"};
JLabel txt1 = new JLabel("Kode");
JLabel txt2 = new JLabel("Mata Kuliah");
JLabel txt3 = new JLabel("SKS");
JLabel txt4 = new JLabel("Jurusan");
JLabel txt5 = new JLabel("Semester");
JLabel txt6 = new JLabel("Tahun Ajaran");
JLabel txt7 = new JLabel("Angkatan");
JLabel txt1_1 = new JLabel(":");
JLabel txt2_2 = new JLabel(":");
JLabel txt3_3 = new JLabel(":");
JLabel txt4_4 = new JLabel(":");
JLabel txt5_5 = new JLabel(":");
JLabel txt6_6 = new JLabel(":");
JLabel txt7_7 = new JLabel(":");
JTextField no = new JTextField(20);
JTextField fil1 = new JTextField(20);
JTextField fil2 = new JTextField(20);
JTextField fil3 = new JTextField(20);
JTextField fil4 = new JTextField(20);
JTextField fil5 = new JTextField(20);
JTextField fil6 = new JTextField(20);
JTextField fil7 = new JTextField(20);
JTextField fil8 = new JTextField(20);
JButton btn1 = new JButton("");
JButton btn2 = new JButton("");
JButton btn3 = new JButton("");
JButton btn4 = new JButton("");
JButton btn5 = new JButton("");
DefaultTableModel model = new DefaultTableModel();
JTable tbl1 = new JTable();
JScrollPane sc1 = new JScrollPane();
JLabel gambar = new JLabel();
data_mata_kuliah() {
setTitle("Mata Kuliah");
setLayout(null);
setSize(572, 662);
setLocation(440, 40);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
formWindowClosing(evt);
}
});
setVisible(true);
setResizable(false);
try {
Class.forName("org.postgresql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:postgresql://localhost/aktivitas_mengajar_dosen", "hudan", "budokter");
stat = con.createStatement();
System.out.println("Koneksi berhasil");
} catch (Exception e) {
System.out.println("Koneksi gagal");
}
}
void tampil() {
setContentPane(gambar);
gambar.setIcon(pic);
model = new DefaultTableModel(null, a);
tbl1.setModel(model);
sc1.getViewport().add(tbl1);
sc1.setBounds(67, 440, 438, 90);
getContentPane().add(sc1);
getContentPane().add(no);
getContentPane().add(txt1);
getContentPane().add(txt2);
getContentPane().add(txt3);
getContentPane().add(txt4);
getContentPane().add(txt5);
getContentPane().add(txt6);
getContentPane().add(txt7);
getContentPane().add(txt1_1);
getContentPane().add(txt2_2);
getContentPane().add(txt3_3);
getContentPane().add(txt4_4);
getContentPane().add(txt5_5);
getContentPane().add(txt6_6);
getContentPane().add(txt7_7);
getContentPane().add(fil1);
getContentPane().add(fil2);
getContentPane().add(fil3);
getContentPane().add(fil4);
getContentPane().add(fil5);
getContentPane().add(fil6);
getContentPane().add(fil7);
getContentPane().add(fil8);
getContentPane().add(btn1);
getContentPane().add(btn2);
getContentPane().add(btn3);
getContentPane().add(btn4);
getContentPane().add(btn5);
txt1.setBounds(85, 176, 200, 20);
txt1_1.setBounds(230, 167, 200, 30);
txt1_1.setFont(new java.awt.Font("Times new roman", 200, 35));
txt1.setForeground(Color.BLACK);
txt1.setFont(new java.awt.Font("Times new roman", 100, 25));
txt2.setBounds(85, 206, 200, 20);
txt2.setForeground(Color.BLACK);
txt2.setFont(new java.awt.Font("Times new roman", 100, 25));
txt2_2.setBounds(230, 198, 200, 30);
txt2_2.setFont(new java.awt.Font("Times new roman", 200, 35));
txt3.setBounds(85, 237, 200, 20);
txt3.setFont(new java.awt.Font("Times new roman", 100, 25));
txt3.setForeground(Color.BLACK);
txt3_3.setBounds(230, 230, 200, 30);
txt3_3.setFont(new java.awt.Font("Times new roman", 200, 35));
txt4.setBounds(85, 269, 200, 20);
txt4.setFont(new java.awt.Font("Times new roman", 100, 25));
txt4.setForeground(Color.BLACK);
txt4_4.setBounds(230, 263, 200, 30);
txt4_4.setFont(new java.awt.Font("Times new roman", 200, 35));
txt5.setBounds(85, 297, 200, 30);
txt5.setFont(new java.awt.Font("Times new roman", 100, 25));
txt5.setForeground(Color.BLACK);
txt5_5.setBounds(230, 294, 200, 30);
txt5_5.setFont(new java.awt.Font("Times new roman", 200, 35));
txt6.setBounds(85, 327, 200, 30);
txt6.setFont(new java.awt.Font("Times new roman", 100, 25));
txt6.setForeground(Color.BLACK);
txt6_6.setBounds(230, 324, 200, 30);
txt6_6.setFont(new java.awt.Font("Times new roman", 200, 35));
txt7.setBounds(85, 357, 200, 30);
txt7.setFont(new java.awt.Font("Times new roman", 100, 25));
txt7.setForeground(Color.BLACK);
txt7_7.setBounds(230, 354, 200, 30);
txt7_7.setFont(new java.awt.Font("Times new roman", 200, 35));
no.setBounds(51, 137, 100, 25);
no.setEditable(false);
fil1.setBounds(260, 172, 215, 25);
fil2.setBounds(260, 204, 215, 25);
fil3.setBounds(260, 235, 215, 25);
fil4.setBounds(67, 400, 110, 25);
fil5.setBounds(260, 267, 215, 25);
fil6.setBounds(260, 297, 215, 25);
fil7.setBounds(260, 327, 215, 25);
fil8.setBounds(260, 357, 215, 25);
btn1.setBounds(260, 395, 70, 30);
btn1.setIcon(pic1);
btn2.setBounds(406, 395, 70, 30);
btn2.setIcon(pic3);
btn3.setBounds(333, 395, 70, 30);
btn3.setIcon(pic2);
btn4.setBounds(481, 173, 24, 25);
btn4.setIcon(pic4);
btn5.setBounds(179, 400, 24, 25);
btn5.setIcon(pic4);
btn1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
simpan();
bersih();
}
});
btn2.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
hapus();
bersih();
}
});
btn3.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
edit();
bersih();
}
});
btn4.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
cari();
}
});
btn5.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
mencari();
}
});
}
void kode_otomatis() {
try {
ResultSet isi = stat.executeQuery("SELECT count(*) FROM data_mata_kuliah");
if (isi.next()) {
int kode=(isi.getInt(1)+1);
no.setText(String.valueOf(kode));
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error pada\n" + ex.getMessage());
}
}
void mencari() {
if (fil4.getText().equals("")) {
try {
tbl1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
} else {
cari1();
int kode_mk = Integer.parseInt(fil4.getText());
try {
stat = (Statement) con.createStatement();
String sql = "SELECT * FROM data_mata_kuliah WHERE kode_mk = '" + kode_mk + "'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String[] row = {
rs.getString(1),
rs.getString(2),
rs.getString(3)
};
model.addRow(row);
}
stat.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
bersih();
}
fil1.setEditable(false);
}
private void cari1() {
String[] field = {"Kode MK", "Nama MK", "SKS"};
model = new DefaultTableModel(null, field);
tbl1.setModel(model);
}
void cari() {
String kode_mk = fil1.getText();
try {
ResultSet isi = stat.executeQuery("SELECT * FROM data_mata_kuliah WHERE kode_mk = '" + kode_mk + "'");
if (isi.next()) {
no.setText(isi.getString(1));
fil1.setText(isi.getString(2));
fil2.setText(isi.getString(3));
fil3.setText(isi.getString(4));
fil5.setText(isi.getString(7));
fil6.setText(isi.getString(5));
fil7.setText(isi.getString(6));
fil8.setText(isi.getString(8));
}
fil1.setEditable(false);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Pencarian Gagal\n" + ex);
}
}
void simpan() {
int no1 = Integer.parseInt(no.getText());
String kode_mk = fil1.getText();
String nama_mk = fil2.getText();
int sks_mk = Integer.parseInt(fil3.getText());
String jurusan = fil5.getText();
String semester = fil6.getText();
String tahun_ajaran = fil7.getText();
String angkatan = fil8.getText();
try {
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection("jdbc:postgresql://localhost/aktivitas_mengajar_dosen", "hudan", "budokter");
Statement statement = con.createStatement();
String sql = "insert into data_mata_kuliah values ('" + no1 + "','" + kode_mk + "','" + nama_mk + "','" + sks_mk + "','" + semester + "','" + tahun_ajaran + "','" + jurusan + "','" + angkatan + "')";
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Tersimpan");
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Maaf Anda GAGAL ! \n");
} finally {
ketabel1("SELECT * from data_mata_kuliah order by kode_mk asc");
}
}
void edit() {
int no1 = Integer.parseInt(no.getText());
String kode_mk = fil1.getText();
String nama_mk = fil2.getText();
int sks_mk = Integer.parseInt(fil3.getText());
String jurusan = fil5.getText();
String semester = fil6.getText();
String tahun_ajaran = fil7.getText();
String angkatan = fil8.getText();
try {
Statement statement = con.createStatement();
String sql = "update data_mata_kuliah set no = '" + no1 + "',matkul = '" + nama_mk + "',sks = '" + sks_mk + "',semester = '" + semester + "',tahun_ajaran = '" + tahun_ajaran + "',jurusan = '" + jurusan + "',angkatan = '" + angkatan + "'where kode_mk ='" + kode_mk + "'";
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Diubah");
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Maaf Anda GAGAL ! \n");
} finally {
ketabel1("SELECT * from data_mata_kuliah order by kode_mk asc");
}
fil1.setEditable(true);
}
void hapus() {
String kode_mk = fil1.getText();
try {
Statement statement = con.createStatement();
String sql = "delete from data_mata_kuliah where kode_mk = '" + kode_mk + "'";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null, "Data Dihapus");
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Maaf Anda GAGAL ! \n");
} finally {
ketabel1("SELECT * from data_mata_kuliah order by kode_mk asc");
}
}
void bersih() {
kode_otomatis();
fil1.setText("");
fil2.setText("");
fil3.setText("");
fil5.setText("");
fil6.setText("");
fil7.setText("");
fil8.setText("");
}
void ketabel1(String sql) {
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
try {
rs = stat.executeQuery(sql);
while (rs.next()) {
model.addRow(new Object[]{
rs.getString(2),
rs.getString(3),
rs.getString(4),});
}
rs.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Kesalahan\n" + ex);
}
}
private void formWindowClosing(java.awt.event.WindowEvent evt) {
// TODO add your handling code here
int keluar = JOptionPane.showConfirmDialog(null, "Apakah Anda yakin ingin keluar", "Konfirmasi", JOptionPane.YES_NO_OPTION);
if (keluar == JOptionPane.YES_OPTION) {
display_mengajar_dosen a = new display_mengajar_dosen();
a.setVisible(true);
a.tampil();
setVisible(false);
} else {
setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
}
}
public static void main(String[] args) {
// TODO code application logic here
data_mata_kuliah a = new data_mata_kuliah();
a.tampil();
a.ketabel1("SELECT * from data_mata_kuliah order by kode_mk asc");
a.kode_otomatis();
}
}
// Membuat class display
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package aktivitas;
/**
*
* @author Mzhud
*/
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.table.DefaultTableModel;
import java.io.File;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.view.JasperViewer;
import java.util.HashMap;
import java.util.Map;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperPrintManager;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
public class display_mengajar_dosen extends JFrame {
private String username, password, url;
private Statement stat;
public Connection con;
private ResultSet rs;
JasperReport JasRep;
JasperPrint JasPri;
Map param = new HashMap();
JasperDesign JasDes;
ImageIcon pic = new ImageIcon("src/gambar/Untitled-4.jpg");
ImageIcon pic1 = new ImageIcon("src/gambar/Untitled-10.jpg");
ImageIcon pic2 = new ImageIcon("src/gambar/Untitled-11.jpg");
ImageIcon pic3 = new ImageIcon("src/gambar/Untitled-12.jpg");
String a[] = {"Hari", "Pukul", "Kode", "Mata Kuliah", "SKS", "Dosen", "Ruang", "Kelas"};
JLabel txt1 = new JLabel("Semester");
JLabel txt2 = new JLabel("Tahun Ajaran");
JLabel txt3 = new JLabel("Jurusan");
private javax.swing.ButtonGroup buttonGroup1;
JRadioButton txt4 = new JRadioButton("");
JRadioButton txt5 = new JRadioButton("");
JRadioButton txt6 = new JRadioButton("");
JRadioButton txt7 = new JRadioButton("");
JRadioButton txt8 = new JRadioButton("");
JLabel txt1_1 = new JLabel(":");
JLabel txt2_2 = new JLabel(":");
JLabel txt3_3 = new JLabel(":");
JLabel txt4_4 = new JLabel(":");
JLabel txt5_5 = new JLabel(":");
JLabel txt6_6 = new JLabel(":");
JLabel txt7_7 = new JLabel(":");
JTextField fil1 = new JTextField(20);
JTextField fil2 = new JTextField(20);
JTextField fil3 = new JTextField(20);
JTextField fil4 = new JTextField(20);
JTextField fil5 = new JTextField(20);
JTextField fil6 = new JTextField(20);
JTextField fil7 = new JTextField(20);
JButton btn1 = new JButton("");
JButton btn2 = new JButton("");
JButton btn3 = new JButton("");
DefaultTableModel model = new DefaultTableModel();
JTable tbl1 = new JTable();
JScrollPane sc1 = new JScrollPane();
JLabel gambar = new JLabel();
JMenuBar menu = new JMenuBar();
JMenu About = new JMenu("About");
JMenu dosen = new JMenu("Data Dosen");
JMenu matkul = new JMenu("Data Matkul");
JMenu of = new JMenu("Keluar");
JMenuItem of1 = new JMenuItem("Logout");
JMenuItem Identity = new JMenuItem("Profil");
JMenuItem dosen_data = new JMenuItem("Masuk");
JMenuItem matkul_data = new JMenuItem("Masuk");
display_mengajar_dosen() {
setTitle("Display Mengajar Dosen");
setLayout(null);
setSize(1300, 662);
setLocation(35, 40);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
formWindowClosing(evt);
}
});
setVisible(true);
setResizable(false);
try {
Class.forName("org.postgresql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:postgresql://localhost/aktivitas_mengajar_dosen", "hudan", "budokter");
stat = con.createStatement();
System.out.println("Koneksi berhasil");
} catch (Exception e) {
System.out.println("Koneksi gagal");
}
}
void tampil() {
setContentPane(gambar);
gambar.setIcon(pic);
model = new DefaultTableModel(null, a);
tbl1.setModel(model);
sc1.getViewport().add(tbl1);
sc1.setBounds(170, 350, 1065, 230);
txt4 = new javax.swing.JRadioButton();
buttonGroup1 = new javax.swing.ButtonGroup();
buttonGroup1.add(txt4);
txt4.setText("All");
buttonGroup1.add(txt5);
txt5.setText("Per Dosen");
buttonGroup1.add(txt6);
txt6.setText("Per Matkul");
buttonGroup1.add(txt7);
txt7.setText("Per Kelas");
buttonGroup1.add(txt8);
txt8.setText("Per Ruang");
add(menu);
add(About);
About.setFont(new java.awt.Font("Arial", 0, 15));
add(of);
of.setFont(new java.awt.Font("Arial", 0, 15));
add(of1);
of1.setFont(new java.awt.Font("Arial", 0, 15));
add(Identity);
Identity.setFont(new java.awt.Font("Arial", 0, 15));
add(matkul);
matkul.setFont(new java.awt.Font("Arial", 0, 15));
add(dosen);
dosen.setFont(new java.awt.Font("Arial", 0, 15));
add(dosen_data);
dosen_data.setFont(new java.awt.Font("Arial", 0, 15));
add(matkul_data);
matkul_data.setFont(new java.awt.Font("Arial", 0, 15));
menu.add(matkul);
menu.add(dosen);
menu.add(About);
menu.add(of);
of.add(of1);
About.add(Identity);
matkul.add(matkul_data);
dosen.add(dosen_data);
menu.setBounds(0, 0, 1295, 30);
menu.setBackground(Color.LIGHT_GRAY);
dosen_data.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
data_dosen a = new data_dosen();
a.setVisible(true);
a.tampil();
a.ketabel1("SELECT data_dosen.kode_dos, data_dosen.nama, data_mata_kuliah.matkul from data_dosen, data_mata_kuliah where data_dosen.kode_mk=data_mata_kuliah.kode_mk order by kode_dos asc");
setVisible(false);
}
});
matkul_data.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
data_mata_kuliah a = new data_mata_kuliah();
a.setVisible(true);
a.tampil();
a.ketabel1("SELECT * from data_mata_kuliah order by kode_mk asc");
setVisible(false);
a.kode_otomatis();
}
});
Identity.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
data_mas_hud a = new data_mas_hud();
a.setVisible(true);
a.tampil();
setVisible(false);
}
});
of1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
getContentPane().add(sc1);
getContentPane().add(txt1);
getContentPane().add(txt2);
getContentPane().add(txt3);
getContentPane().add(txt4);
getContentPane().add(txt5);
getContentPane().add(txt6);
getContentPane().add(txt7);
getContentPane().add(txt8);
getContentPane().add(txt1_1);
getContentPane().add(txt2_2);
getContentPane().add(txt3_3);
getContentPane().add(txt4_4);
getContentPane().add(txt5_5);
getContentPane().add(txt6_6);
getContentPane().add(txt7_7);
getContentPane().add(fil1);
getContentPane().add(fil2);
getContentPane().add(fil3);
getContentPane().add(fil4);
getContentPane().add(fil5);
getContentPane().add(fil6);
getContentPane().add(fil7);
getContentPane().add(btn1);
getContentPane().add(btn2);
getContentPane().add(btn3);
txt1.setBounds(170, 182, 200, 20);
txt1_1.setBounds(330, 176, 200, 30);
txt1_1.setFont(new java.awt.Font("Times new roman", 200, 35));
txt1.setForeground(Color.BLACK);
txt1.setFont(new java.awt.Font("Times new roman", 100, 25));
txt1_1.setForeground(Color.BLACK);
txt2.setBounds(170, 211, 200, 30);
txt2.setForeground(Color.BLACK);
txt2.setFont(new java.awt.Font("Times new roman", 100, 25));
txt2_2.setBounds(330, 211, 200, 30);
txt2_2.setFont(new java.awt.Font("Times new roman", 200, 35));
txt2_2.setForeground(Color.BLACK);
txt3.setBounds(170, 246, 200, 20);
txt3.setFont(new java.awt.Font("Times new roman", 100, 25));
txt3.setForeground(Color.BLACK);
txt3_3.setBounds(330, 240, 200, 30);
txt3_3.setFont(new java.awt.Font("Times new roman", 200, 35));
txt3_3.setForeground(Color.BLACK);
txt4.setBounds(770, 180, 60, 25);
txt4.setFont(new java.awt.Font("Times new roman", 100, 25));
txt4.setForeground(Color.BLACK);
txt4.setBackground(Color.LIGHT_GRAY);
txt5.setBounds(850, 180, 140, 25);
txt5.setFont(new java.awt.Font("Times new roman", 100, 25));
txt5.setForeground(Color.BLACK);
txt5.setBackground(Color.LIGHT_GRAY);
txt6.setBounds(850, 210, 140, 25);
txt6.setFont(new java.awt.Font("Times new roman", 100, 25));
txt6.setForeground(Color.BLACK);
txt6.setBackground(Color.LIGHT_GRAY);
txt7.setBounds(850, 240, 140, 25);
txt7.setFont(new java.awt.Font("Times new roman", 100, 25));
txt7.setForeground(Color.BLACK);
txt7.setBackground(Color.LIGHT_GRAY);
txt8.setBounds(850, 271, 140, 27);
txt8.setFont(new java.awt.Font("Times new roman", 100, 25));
txt8.setForeground(Color.BLACK);
txt8.setBackground(Color.LIGHT_GRAY);
fil1.setBounds(370, 183, 210, 25);
fil2.setBounds(370, 214, 210, 25);
fil3.setBounds(370, 245, 210, 25);
fil4.setBounds(1053, 180, 180, 25);
txt4_4.setBounds(1013, 179, 210, 25);
txt4_4.setFont(new java.awt.Font("Times new roman", 200, 35));
fil5.setBounds(1053, 210, 180, 25);
txt5_5.setBounds(1013, 209, 210, 25);
txt5_5.setFont(new java.awt.Font("Times new roman", 200, 35));
fil6.setBounds(1053, 241, 180, 25);
txt6_6.setBounds(1013, 239, 210, 25);
txt6_6.setFont(new java.awt.Font("Times new roman", 200, 35));
fil7.setBounds(1053, 272, 180, 25);
txt7_7.setBounds(1013, 270, 210, 25);
txt7_7.setFont(new java.awt.Font("Times new roman", 200, 35));
btn1.setBounds(370, 295, 70, 30);
btn1.setIcon(pic1);
btn2.setBounds(510, 295, 70, 30);
btn2.setIcon(pic2);
btn3.setBounds(440, 295, 70, 30);
btn3.setIcon(pic3);
txt4.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
fil4.setVisible(false);
fil5.setVisible(false);
fil6.setVisible(false);
fil7.setVisible(false);
try {
stat = (Statement) con.createStatement();
String sql = "SELECT data_dosen.hari, data_dosen.jam, data_mata_kuliah.kode_mk, data_mata_kuliah.matkul, data_mata_kuliah.sks, data_dosen.nama, data_dosen.ruang, data_dosen.kelas from data_dosen, data_mata_kuliah where data_dosen.kode_mk= data_mata_kuliah.kode_mk ";
rs = stat.executeQuery(sql);
while (rs.next()) {
model.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7),
rs.getString(8),});
}
tbl1.setModel(model);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Kesalahan\n" + ex);
}
}
});
txt5.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
fil4.setVisible(true);
fil5.setVisible(false);
fil6.setVisible(false);
fil7.setVisible(false);
}
});
txt6.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
fil4.setVisible(false);
fil5.setVisible(true);
fil6.setVisible(false);
fil7.setVisible(false);
}
});
txt7.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
fil4.setVisible(false);
fil5.setVisible(false);
fil6.setVisible(true);
fil7.setVisible(false);
}
});
txt8.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
fil4.setVisible(false);
fil5.setVisible(false);
fil6.setVisible(false);
fil7.setVisible(true);
}
});
btn1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
run();
}
});
btn2.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
print();
}
});
btn3.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
display_mengajar_dosen a = new display_mengajar_dosen();
a.setVisible(true);
a.tampil();
setVisible(false);
}
});
}
void print() {
try {
File reprt = new File("report1.jrxml");
JasDes = JRXmlLoader.load(reprt);
param.clear();
JasRep = JasperCompileManager.compileReport(JasDes);
JasPri = JasperFillManager.fillReport(JasRep, param, con);
JasperViewer.viewReport(JasPri, false);
// JasperPrintManager.printReport(JasPri, true);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
void run() {
if (fil4.getText().equals("")) {
try {
tbl1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
} else {
cari1();
String nama_dos = fil4.getText();
String semester = fil1.getText();
String tahun_ajaran = fil2.getText();
String jurusan = fil3.getText();
try {
stat = (Statement) con.createStatement();
String sql = "SELECT data_dosen.hari, data_dosen.jam, data_mata_kuliah.kode_mk, data_mata_kuliah.matkul, data_mata_kuliah.sks, data_dosen.nama, data_dosen.ruang, data_dosen.kelas from data_dosen, data_mata_kuliah where data_dosen.kode_mk= data_mata_kuliah.kode_mk and nama = '" + nama_dos + "' and semester = '" + semester + "'and tahun_ajaran = '" + tahun_ajaran + "'and jurusan = '" + jurusan + "'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String[] row = {
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7),
rs.getString(8)
};
model.addRow(row);
}
stat.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
}
if (fil5.getText().equals("")) {
try {
tbl1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
} else {
cari1();
String matkul = fil5.getText();
String semester = fil1.getText();
String tahun_ajaran = fil2.getText();
String jurusan = fil3.getText();
try {
stat = (Statement) con.createStatement();
String sql = "SELECT data_dosen.hari, data_dosen.jam, data_mata_kuliah.kode_mk, data_mata_kuliah.matkul, data_mata_kuliah.sks, data_dosen.nama, data_dosen.ruang, data_dosen.kelas from data_dosen, data_mata_kuliah where data_dosen.kode_mk= data_mata_kuliah.kode_mk and matkul = '" + matkul + "'and semester = '" + semester + "'and tahun_ajaran = '" + tahun_ajaran + "'and jurusan = '" + jurusan + "'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String[] row = {
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7),
rs.getString(8)
};
model.addRow(row);
}
stat.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
}
if (fil6.getText().equals("")) {
try {
tbl1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
} else {
cari1();
String kelas = fil6.getText();
String semester = fil1.getText();
String tahun_ajaran = fil2.getText();
String jurusan = fil3.getText();
try {
stat = (Statement) con.createStatement();
String sql = "SELECT data_dosen.hari, data_dosen.jam, data_mata_kuliah.kode_mk, data_mata_kuliah.matkul, data_mata_kuliah.sks, data_dosen.nama, data_dosen.ruang, data_dosen.kelas from data_dosen, data_mata_kuliah where data_dosen.kode_mk= data_mata_kuliah.kode_mk and kelas = '" + kelas + "'and semester = '" + semester + "'and tahun_ajaran = '" + tahun_ajaran + "'and jurusan = '" + jurusan + "'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String[] row = {
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7),
rs.getString(8)
};
model.addRow(row);
}
stat.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
}
if (fil7.getText().equals("")) {
try {
tbl1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
} else {
cari1();
String ruang = fil7.getText();
String semester = fil1.getText();
String tahun_ajaran = fil2.getText();
String jurusan = fil3.getText();
try {
stat = (Statement) con.createStatement();
String sql = "SELECT data_dosen.hari, data_dosen.jam, data_mata_kuliah.kode_mk, data_mata_kuliah.matkul, data_mata_kuliah.sks, data_dosen.nama, data_dosen.ruang, data_dosen.kelas from data_dosen, data_mata_kuliah where data_dosen.kode_mk= data_mata_kuliah.kode_mk and ruang = '" + ruang + "'and semester = '" + semester + "'and tahun_ajaran = '" + tahun_ajaran + "'and jurusan = '" + jurusan + "'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String[] row = {
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7),
rs.getString(8)
};
model.addRow(row);
}
stat.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "KESALAHAN\n" + e);
}
}
}
private void cari1() {
String[] field = {"Hari", "Pukul", "Kode", "Mata Kuliah", "SKS", "Dosen", "Ruang", "Kelas"};
model = new DefaultTableModel(null, field);
tbl1.setModel(model);
}
private void formWindowClosing(java.awt.event.WindowEvent evt) {
// TODO add your handling code here
{
display_mengajar_dosen a = new display_mengajar_dosen();
a.setVisible(true);
a.tampil();
setVisible(false);
}
}
public static void main(String[] args) {
// TODO code application logic here
display_mengajar_dosen a = new display_mengajar_dosen();
a.tampil();
}
}
Tidak ada komentar:
Posting Komentar