Langkah-Langkah Membuat Aplikasi Database Dengan Menampilkan Hasil Grafik Sebagai Laporannya (Netbeans | Mysql)
1. Buka Xampp, kemudian hidupkan Apache dan MySql
2.) Bukalah halaman : localhost/phpmyadmin Pada
browser, tidak perlu menggunakan koneksi internet
3.) Buat Database baru dengan nama
"ProjectUAS" dan klik create, kemudian buat tabel
"nilai_mhs" didalam database grafik dengan 3 columns, klik go
4.) Sebelumnya, input isi columns sesuai kebutuhan dan NIM indexnya menjadi primary dan klik save
5.) kemudian buat lagi tabel "data_mhs"
didalam database grafik dengan 3 columns, klik go , Lalu input kembali isi
columns sesuai kebutuhan dan NIM indexnya menjadi primary dan klik save
6.) Buka NetBeans, dan buat projek baru dengan nama
"RIVALDHAJI", dan finish
7.) Buatlah JFrameFrom dengan nama classnya
"Nilai_MAHASISWA" seperti dibawah ini, dan finish
8.) Desain sebagai
berikut
9.) Masukan Source Code
pada masing fungsi (Button)
/*
* 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
rivaldhaji;
import
java.awt.Dimension;
import
java.awt.Toolkit;
import
java.sql.Connection;
import
java.sql.DriverManager;
import
java.sql.ResultSet;
import
java.sql.SQLException;
import
java.sql.Statement;
import
javax.swing.JOptionPane;
import
javax.swing.table.DefaultTableModel;
/**
*
* @author hp
*/
public
class Nilai_Mahasiswa extends javax.swing.JFrame {
private
Connection con_RIVALDHAJI;
private
Statement stat_RIVALDHAJI;
private
ResultSet res_RIVALDHAJI;
private
String t_RIVALDHAJI;
private
DefaultTableModel dtm_RIVALDHAJI;
ResultSet
rs_RIVALDHAJI;
String
sql_RIVALDHAJI;
/**
* Creates new form Nilai_Mahasiswa
*/
public Nilai_Mahasiswa() {
initComponents();
koneksi_RIVALDHAJI();
kosongkan_RIVALDHAJI();
tabel_RIVALDHAJI();
kosongkan1_RIVALDHAJI();
tabel1_RIVALDHAJI();
//membuat
layout tampil di tengah pada saat ditampilkan
Dimension screenSize =
Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation( (screenSize.width - frameSize.width) /
2,
(screenSize.height - frameSize.height)
/ 2);
}
private
void koneksi_RIVALDHAJI(){
try {
Class.forName("com.mysql.jdbc.Driver");
con_RIVALDHAJI=DriverManager.getConnection("jdbc:mysql://localhost/projectuas",
"root", "");
stat_RIVALDHAJI=con_RIVALDHAJI.createStatement();
} catch (Exception e) {
JOptionPane.showMessageDialog(null,"koneksi gagal" +e);
}
}
private void kosongkan_RIVALDHAJI(){
jTextField1_RIVALDHAJI.setText("");
jTextField2_RIVALDHAJI.setText("");
jTextField3_RIVALDHAJI.setText("");
}
private void kosongkan1_RIVALDHAJI(){
nim_RIVALDHAJI.setText("");
nama_RIVALDHAJI.setText("");
jComboBox1.setSelectedIndex(0);
}
private void tabel1_RIVALDHAJI(){
DefaultTableModel t_RIVALDHAJI= new
DefaultTableModel();
t_RIVALDHAJI.addColumn("NIM");
t_RIVALDHAJI.addColumn("Nilai
Semester Ganjil");
t_RIVALDHAJI.addColumn("Nilai
Semester Genap");
jTable1_RIVALDHAJI.setModel(t_RIVALDHAJI);
try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from
data_mhs");
while (res_RIVALDHAJI.next()) {
t_RIVALDHAJI.addRow(new Object[]{
res_RIVALDHAJI.getString("NIM"),
res_RIVALDHAJI.getString("Nilai
Semester Ganjil"),
res_RIVALDHAJI.getString("Nilai Semester Genap"),
});
}
}catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private void tabel_RIVALDHAJI(){
DefaultTableModel t_RIVALDHAJI= new
DefaultTableModel();
t_RIVALDHAJI.addColumn("NIM");
t_RIVALDHAJI.addColumn("Nama");
t_RIVALDHAJI.addColumn("Jurusan");
tabel_RIVALDHAJI.setModel(t_RIVALDHAJI); try{
res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from
nilai_mhs");
while (res_RIVALDHAJI.next()) {
t_RIVALDHAJI.addRow(new Object[]{
res_RIVALDHAJI.getString("NIM"),
res_RIVALDHAJI.getString("Nama"),
res_RIVALDHAJI.getString("Jurusan"),
});
}
}catch (Exception e) {
JOptionPane.showMessageDialog(rootPane,
e);
}
}
/**
* This method is called from within the
constructor to initialize the form.
* WARNING: Do NOT modify this code. The
content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jComboBox1 = new
javax.swing.JComboBox<>();
nim_RIVALDHAJI = new
javax.swing.JTextField();
nama_RIVALDHAJI = new
javax.swing.JTextField();
save_RIVALDHAJI = new
javax.swing.JButton();
clear_RIVALDHAJI = new
javax.swing.JButton();
jScrollPane1 = new
javax.swing.JScrollPane();
tabel_RIVALDHAJI = new javax.swing.JTable();
tampil_RIVALDHAJI = new
javax.swing.JButton();
hapus_RIVALDHAJI = new
javax.swing.JButton();
jTextField1_RIVALDHAJI = new
javax.swing.JTextField();
jTextField2_RIVALDHAJI = new
javax.swing.JTextField();
jButton1_RIVALDHAJI = new
javax.swing.JButton();
jButton5_RIVALDHAJI = new
javax.swing.JButton();
jScrollPane2 = new
javax.swing.JScrollPane();
jTable1_RIVALDHAJI = new
javax.swing.JTable();
jButton2_RIVALDHAJI = new javax.swing.JButton();
jLabel5 = new javax.swing.JLabel();
jButton4_RIVALDHAJI = new
javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
jTextField3_RIVALDHAJI = new
javax.swing.JTextField();
jButton3_RIVALDHAJI = new
javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setBackground(new java.awt.Color(51,
204, 255));
jLabel1.setFont(new
java.awt.Font("Times New Roman", 1, 24)); // NOI18N
jLabel1.setText("NILAI
MAHASISWA");
jLabel2.setText("NIM");
jLabel3.setText("Nama");
jLabel4.setText("Jurusan");
jComboBox1.setModel(new
javax.swing.DefaultComboBoxModel<>(new String[] { "Teknik
Informatika", "Teknik Kimia", "Teknik Industri",
"Sastra Indonesia", "Sastra Jepang", "Sastra
Inggris", " " }));
nim_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
nim_RIVALDHAJIActionPerformed(evt);
}
});
save_RIVALDHAJI.setText("Save");
save_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
save_RIVALDHAJIActionPerformed(evt);
}
});
clear_RIVALDHAJI.setText("Clear");
clear_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
clear_RIVALDHAJIActionPerformed(evt);
}
});
tabel_RIVALDHAJI.setModel(new
javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null},
{null, null, null},
{null, null, null},
{null, null, null}
},
new String [] {
"Title 1",
"Title 2", "Title 3"
}
));
tabel_RIVALDHAJI.addMouseListener(new
java.awt.event.MouseAdapter() {
public void
mouseClicked(java.awt.event.MouseEvent evt) {
tabel_RIVALDHAJIMouseClicked(evt);
}
});
jScrollPane1.setViewportView(tabel_RIVALDHAJI);
tampil_RIVALDHAJI.setText("View");
tampil_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
tampil_RIVALDHAJIActionPerformed(evt);
}
});
hapus_RIVALDHAJI.setText("Delete");
hapus_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
hapus_RIVALDHAJIActionPerformed(evt);
}
});
jButton1_RIVALDHAJI.setText("Save");
jButton1_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton1_RIVALDHAJIActionPerformed(evt);
}
});
jButton5_RIVALDHAJI.setText("Clear");
jButton5_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton5_RIVALDHAJIActionPerformed(evt);
}
});
jTable1_RIVALDHAJI.setModel(new
javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null},
{null, null, null},
{null, null, null},
{null, null, null}
},
new String [] {
"Title 1",
"Title 2", "Title 3"
}
));
jTable1_RIVALDHAJI.addMouseListener(new
java.awt.event.MouseAdapter() {
public void
mouseClicked(java.awt.event.MouseEvent evt) {
jTable1_RIVALDHAJIMouseClicked(evt);
}
});
jScrollPane2.setViewportView(jTable1_RIVALDHAJI);
jButton2_RIVALDHAJI.setText("View");
jButton2_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton2_RIVALDHAJIActionPerformed(evt);
}
});
jLabel5.setText("NIM");
jButton4_RIVALDHAJI.setText("Delete");
jButton4_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton4_RIVALDHAJIActionPerformed(evt);
}
});
jLabel6.setText("Nilai Semester
Ganjil");
jLabel7.setText("Nilai Semester
Genap");
jButton3_RIVALDHAJI.setText("Grafik");
jButton3_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton3_RIVALDHAJIActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(425, 425, 425)
.addComponent(jLabel1)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4)
.addComponent(jLabel2)
.addComponent(jLabel3))
.addGap(69, 69,
69)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nim_RIVALDHAJI)
.addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.DEFAULT_SIZE,
130, Short.MAX_VALUE)))
.addGroup(layout.createSequentialGroup()
.addComponent(save_RIVALDHAJI)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(clear_RIVALDHAJI))))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(29, 29, 29)
.addComponent(tampil_RIVALDHAJI)
.addGap(72, 72, 72)
.addComponent(hapus_RIVALDHAJI)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
144, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane2,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGap(25, 25, 25)
.addComponent(jButton2_RIVALDHAJI)
.addGap(72, 72, 72)
.addComponent(jButton4_RIVALDHAJI))
.addGroup(layout.createSequentialGroup()
.addGap(24, 24, 24)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel7)
.addComponent(jLabel5)
.addComponent(jLabel6)
.addGroup(layout.createSequentialGroup()
.addComponent(jButton1_RIVALDHAJI)
.addGap(26, 26,
26)
.addComponent(jButton5_RIVALDHAJI)))
.addGap(23, 23, 23)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(7, 7,
7)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jTextField1_RIVALDHAJI)
.addComponent(jTextField2_RIVALDHAJI)
.addComponent(jTextField3_RIVALDHAJI,
javax.swing.GroupLayout.DEFAULT_SIZE, 110, Short.MAX_VALUE)))
.addComponent(jButton3_RIVALDHAJI))))
.addGap(58, 58, 58))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(nim_RIVALDHAJI,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(20, 20, 20)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(27, 27, 27)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(37, 37, 37)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(save_RIVALDHAJI)
.addComponent(clear_RIVALDHAJI))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 140,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tampil_RIVALDHAJI)
.addComponent(hapus_RIVALDHAJI)))
.addGroup(layout.createSequentialGroup()
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField1_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addGap(20, 20, 20)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField2_RIVALDHAJI,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6))
.addGap(27, 27, 27)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7)
.addComponent(jTextField3_RIVALDHAJI,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(37, 37, 37)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1_RIVALDHAJI)
.addComponent(jButton5_RIVALDHAJI)
.addComponent(jButton3_RIVALDHAJI))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 140,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton2_RIVALDHAJI)
.addComponent(jButton4_RIVALDHAJI))))
.addContainerGap(41,
Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void
hapus_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
stat_RIVALDHAJI.executeUpdate("delete from data_mhs where " +
"NIM='"+nim_RIVALDHAJI.getText() +"'" );
kosongkan1_RIVALDHAJI();
JOptionPane.showMessageDialog(null,
"Berhasil");
} catch (Exception e) {
JOptionPane.showMessageDialog(null,
"pesan salah : "+e);
}
}
private void jButton4_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent
evt) {
// TODO add your handling code here:
try {
stat_RIVALDHAJI.executeUpdate("delete from nilai_mhs where " +
"NIM='"+jTextField1_RIVALDHAJI.getText() +"'" );
kosongkan_RIVALDHAJI();
JOptionPane.showMessageDialog(null,
"Berhasil");
} catch (Exception e) {
JOptionPane.showMessageDialog(null,
"pesan salah : "+e);
}
}
private void
clear_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kosongkan1_RIVALDHAJI();
}
private void
nim_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void
save_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
String a;
a
= nim_RIVALDHAJI.getText();
jTextField1_RIVALDHAJI.setText(a);
int s=0;
koneksi_RIVALDHAJI();
String cs="";
s=jComboBox1.getSelectedIndex();
if(s==0)
{
cs="Teknik
Informatika";
}
else if(s==1)
{
cs="Teknik Kimia";
}
else if(s==2)
{
cs="Teknik Industri";
}
else if(s==3)
{
cs="Sastra Indonesia";
}
else if(s==4)
{
cs="Sastra Jepang";
}
else
{
cs="Sastra Inggris";
}
stat_RIVALDHAJI.executeUpdate("insert into data_mhs values ("
+ "'" + nim_RIVALDHAJI.getText()+"'," + "'" +
nama_RIVALDHAJI.getText()+ "',"+"'"+cs+"')");
kosongkan1_RIVALDHAJI();
JOptionPane.showMessageDialog(null,
"Berhasil Menyimpan Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null,
"Perintah Salah : "+e);
}
}
private void
jButton5_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kosongkan1_RIVALDHAJI();
}
private void
jButton1_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
stat_RIVALDHAJI.executeUpdate("insert into nilai_mhs values ("
+ "'" + jTextField1_RIVALDHAJI.getText()+"'," +
"'" + jTextField2_RIVALDHAJI.getText()+ "'," +
"'" + jTextField3_RIVALDHAJI.getText()+ "')");
kosongkan_RIVALDHAJI();
JOptionPane.showMessageDialog(null,
"Berhasil Menyimpan Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null,
"Perintah Salah : "+e);
}
}
private void
jButton3_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
RIVALDHAJI obj1_RIVALDHAJI = new
RIVALDHAJI();
obj1_RIVALDHAJI.setNilai(jTextField2_RIVALDHAJI.getText(),jTextField3_RIVALDHAJI.getText());
obj1_RIVALDHAJI.setVisible(true);
dispose();
}
private void
tampil_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
Object []
rows={"NIM","Nama","Jurusan"};
dtm_RIVALDHAJI=new
DefaultTableModel(null,rows);
tabel_RIVALDHAJI.setModel(dtm_RIVALDHAJI); tabel_RIVALDHAJI.setBorder(null);
jScrollPane2.setVisible(true);
jScrollPane2.setViewportView(tabel_RIVALDHAJI);
int no = 1;
String
nim="",nama="",jrs="";try{String sql="select
* from data_mhs";Statement
st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql);
while(rs.next()){nim=rs.getString("NIM");nama=rs.getString("Nama");jrs=rs.getString("Jurusan");
String []
tampil={""+nim,nama,jrs};dtm_RIVALDHAJI.addRow(tampil);
}
}catch(SQLException
e){e.printStackTrace();
JOptionPane.showMessageDialog(null,"Query Salah "+e);
}
}catch(Exception
e){e.printStackTrace();
}
}
private void
jButton2_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
Object []
rows={"NIM","Nilai Semester Ganjil","Nilai Semester
Genap"};
dtm_RIVALDHAJI=new
DefaultTableModel(null,rows);
jTable1_RIVALDHAJI.setModel(dtm_RIVALDHAJI);
jTable1_RIVALDHAJI.setBorder(null);
jScrollPane1.setVisible(true);
jScrollPane1.setViewportView(jTable1_RIVALDHAJI);
int no = 1;
String
nim="",gnp="",gjl="";try{String sql="select
* from nilai_mhs";Statement
st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql);
while(rs.next()){nim=rs.getString("NIM");gjl=rs.getString("Nilai
Semester Ganjil");gnp=rs.getString("Nilai Semester Genap");
String []
tampil={""+nim,gjl,gnp};dtm_RIVALDHAJI.addRow(tampil);
}
}catch(SQLException
e){e.printStackTrace();
JOptionPane.showMessageDialog(null,"Query Salah "+e);
}
}catch(Exception
e){e.printStackTrace();
}
}
private void
tabel_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int i =
tabel_RIVALDHAJI.getSelectedRow();
if(i==-1){
return;
}
String code =
(String)tabel_RIVALDHAJI.getValueAt(i,0);
String code1 =
(String)tabel_RIVALDHAJI.getValueAt(i,1);
String code2 =
(String)tabel_RIVALDHAJI.getValueAt(i, 2);
String code3 =
(String)tabel_RIVALDHAJI.getValueAt(i, 0);
nim_RIVALDHAJI.setText(code);
nama_RIVALDHAJI.setText(code1);
jComboBox1.setSelectedItem(code2);
jTextField1_RIVALDHAJI.setText(code3);
}
private void
jTable1_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int i_RIVALDHAJI =
jTable1_RIVALDHAJI.getSelectedRow();
if(i_RIVALDHAJI==-1){
return;
}
String code_RIVALDHAJI =
(String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,0);
String code1_RIVALDHAJI =
(String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,1);
String code2_RIVALDHAJI =
(String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,2);
jTextField1_RIVALDHAJI.setText(code_RIVALDHAJI);
jTextField2_RIVALDHAJI.setText(code1_RIVALDHAJI);
jTextField3_RIVALDHAJI.setText(code2_RIVALDHAJI);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold
defaultstate="collapsed" desc=" Look and feel setting code
(optional) ">
/* If Nimbus (introduced in Java SE 6)
is not available, stay with the default look and feel.
* For details see
http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for
(javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName()))
{
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new
Runnable() {
public void run() {
new Nilai_Mahasiswa().setVisible(true);
}
});
}
// Variables declaration - do not
modify
private javax.swing.JButton
clear_RIVALDHAJI;
private javax.swing.JButton
hapus_RIVALDHAJI;
private javax.swing.JButton
jButton1_RIVALDHAJI;
private javax.swing.JButton
jButton2_RIVALDHAJI;
private javax.swing.JButton
jButton3_RIVALDHAJI;
private javax.swing.JButton
jButton4_RIVALDHAJI;
private javax.swing.JButton
jButton5_RIVALDHAJI;
private javax.swing.JComboBox<String>
jComboBox1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JScrollPane
jScrollPane1;
private javax.swing.JScrollPane
jScrollPane2;
private javax.swing.JTable
jTable1_RIVALDHAJI;
private javax.swing.JTextField
jTextField1_RIVALDHAJI;
private javax.swing.JTextField
jTextField2_RIVALDHAJI;
private javax.swing.JTextField
jTextField3_RIVALDHAJI;
private javax.swing.JTextField
nama_RIVALDHAJI;
private javax.swing.JTextField
nim_RIVALDHAJI;
private javax.swing.JButton
save_RIVALDHAJI;
private javax.swing.JTable
tabel_RIVALDHAJI;
private javax.swing.JButton
tampil_RIVALDHAJI;
// End of variables declaration
}
10. Masukan Source Code pada RIVALDHAJI.class
/*
* 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 rivaldhaji;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author hp
*/
public class Nilai_Mahasiswa extends javax.swing.JFrame {
private Connection con_RIVALDHAJI;
private Statement stat_RIVALDHAJI;
private ResultSet res_RIVALDHAJI;
private String t_RIVALDHAJI;
private DefaultTableModel dtm_RIVALDHAJI;
ResultSet rs_RIVALDHAJI;
String sql_RIVALDHAJI;
/**
* Creates new form
Nilai_Mahasiswa
*/
public Nilai_Mahasiswa() {
initComponents();
koneksi_RIVALDHAJI();
kosongkan_RIVALDHAJI();
tabel_RIVALDHAJI();
kosongkan1_RIVALDHAJI();
tabel1_RIVALDHAJI();
//membuat layout tampil di tengah pada saat ditampilkan
Dimension screenSize =
Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize =
getSize();
setLocation( (screenSize.width - frameSize.width) /
2,
(screenSize.height -
frameSize.height) / 2);
}
private void koneksi_RIVALDHAJI(){
try {
Class.forName("com.mysql.jdbc.Driver");
con_RIVALDHAJI=DriverManager.getConnection("jdbc:mysql://localhost/projectuas",
"root", "");
stat_RIVALDHAJI=con_RIVALDHAJI.createStatement();
} catch (Exception e) {
JOptionPane.showMessageDialog(null,"koneksi
gagal" +e);
}
}
private void
kosongkan_RIVALDHAJI(){
jTextField1_RIVALDHAJI.setText("");
jTextField2_RIVALDHAJI.setText("");
jTextField3_RIVALDHAJI.setText("");
}
private void
kosongkan1_RIVALDHAJI(){
nim_RIVALDHAJI.setText("");
nama_RIVALDHAJI.setText("");
jComboBox1.setSelectedIndex(0);
}
private void
tabel1_RIVALDHAJI(){
DefaultTableModel
t_RIVALDHAJI= new DefaultTableModel();
t_RIVALDHAJI.addColumn("NIM");
t_RIVALDHAJI.addColumn("Nilai Semester Ganjil");
t_RIVALDHAJI.addColumn("Nilai Semester Genap");
jTable1_RIVALDHAJI.setModel(t_RIVALDHAJI); try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select
* from data_mhs");
while
(res_RIVALDHAJI.next()) {
t_RIVALDHAJI.addRow(new Object[]{
res_RIVALDHAJI.getString("NIM"),
res_RIVALDHAJI.getString("Nilai Semester Ganjil"),
res_RIVALDHAJI.getString("Nilai Semester Genap"),
});
}
}catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private void
tabel_RIVALDHAJI(){
DefaultTableModel
t_RIVALDHAJI= new DefaultTableModel();
t_RIVALDHAJI.addColumn("NIM");
t_RIVALDHAJI.addColumn("Nama");
t_RIVALDHAJI.addColumn("Jurusan");
tabel_RIVALDHAJI.setModel(t_RIVALDHAJI);
try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from
nilai_mhs");
while
(res_RIVALDHAJI.next()) {
t_RIVALDHAJI.addRow(new Object[]{
res_RIVALDHAJI.getString("NIM"),
res_RIVALDHAJI.getString("Nama"),
res_RIVALDHAJI.getString("Jurusan"),
});
}
}catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
/**
* This method is called from
within the constructor to initialize the form.
* WARNING: Do NOT modify
this code. The content of this method is always
* regenerated by the Form
Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void initComponents()
{
jLabel1 = new
javax.swing.JLabel();
jLabel2 = new
javax.swing.JLabel();
jLabel3 = new
javax.swing.JLabel();
jLabel4 = new
javax.swing.JLabel();
jComboBox1 = new
javax.swing.JComboBox<>();
nim_RIVALDHAJI = new
javax.swing.JTextField();
nama_RIVALDHAJI = new
javax.swing.JTextField();
save_RIVALDHAJI = new
javax.swing.JButton();
clear_RIVALDHAJI = new
javax.swing.JButton();
jScrollPane1 = new
javax.swing.JScrollPane();
tabel_RIVALDHAJI = new
javax.swing.JTable();
tampil_RIVALDHAJI = new
javax.swing.JButton();
hapus_RIVALDHAJI = new
javax.swing.JButton();
jTextField1_RIVALDHAJI =
new javax.swing.JTextField();
jTextField2_RIVALDHAJI =
new javax.swing.JTextField();
jButton1_RIVALDHAJI = new
javax.swing.JButton();
jButton5_RIVALDHAJI = new
javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
jTable1_RIVALDHAJI = new
javax.swing.JTable();
jButton2_RIVALDHAJI = new
javax.swing.JButton();
jLabel5 = new
javax.swing.JLabel();
jButton4_RIVALDHAJI = new
javax.swing.JButton();
jLabel6 = new
javax.swing.JLabel();
jLabel7 = new
javax.swing.JLabel();
jTextField3_RIVALDHAJI =
new javax.swing.JTextField();
jButton3_RIVALDHAJI = new
javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setBackground(new
java.awt.Color(51, 204, 255));
jLabel1.setFont(new
java.awt.Font("Times New Roman", 1, 24)); // NOI18N
jLabel1.setText("NILAI MAHASISWA");
jLabel2.setText("NIM");
jLabel3.setText("Nama");
jLabel4.setText("Jurusan");
jComboBox1.setModel(new
javax.swing.DefaultComboBoxModel<>(new String[] { "Teknik
Informatika", "Teknik Kimia", "Teknik Industri",
"Sastra Indonesia", "Sastra Jepang", "Sastra
Inggris", " " }));
nim_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
nim_RIVALDHAJIActionPerformed(evt);
}
});
save_RIVALDHAJI.setText("Save");
save_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
save_RIVALDHAJIActionPerformed(evt);
}
});
clear_RIVALDHAJI.setText("Clear");
clear_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
clear_RIVALDHAJIActionPerformed(evt);
}
});
tabel_RIVALDHAJI.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null,
null},
{null, null,
null},
{null, null,
null},
{null, null,
null}
},
new String [] {
"Title
1", "Title 2", "Title 3"
}
));
tabel_RIVALDHAJI.addMouseListener(new java.awt.event.MouseAdapter() {
public void
mouseClicked(java.awt.event.MouseEvent evt) {
tabel_RIVALDHAJIMouseClicked(evt);
}
});
jScrollPane1.setViewportView(tabel_RIVALDHAJI);
tampil_RIVALDHAJI.setText("View");
tampil_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener()
{
public void
actionPerformed(java.awt.event.ActionEvent evt) {
tampil_RIVALDHAJIActionPerformed(evt);
}
});
hapus_RIVALDHAJI.setText("Delete");
hapus_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
hapus_RIVALDHAJIActionPerformed(evt);
}
});
jButton1_RIVALDHAJI.setText("Save");
jButton1_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton1_RIVALDHAJIActionPerformed(evt);
}
});
jButton5_RIVALDHAJI.setText("Clear");
jButton5_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton5_RIVALDHAJIActionPerformed(evt);
}
});
jTable1_RIVALDHAJI.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null,
null},
{null, null,
null},
{null, null,
null},
{null, null,
null}
},
new String [] {
"Title
1", "Title 2", "Title 3"
}
));
jTable1_RIVALDHAJI.addMouseListener(new
java.awt.event.MouseAdapter() {
public void
mouseClicked(java.awt.event.MouseEvent evt) {
jTable1_RIVALDHAJIMouseClicked(evt);
}
});
jScrollPane2.setViewportView(jTable1_RIVALDHAJI);
jButton2_RIVALDHAJI.setText("View");
jButton2_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton2_RIVALDHAJIActionPerformed(evt);
}
});
jLabel5.setText("NIM");
jButton4_RIVALDHAJI.setText("Delete");
jButton4_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton4_RIVALDHAJIActionPerformed(evt);
}
});
jLabel6.setText("Nilai Semester Ganjil");
jLabel7.setText("Nilai Semester Genap");
jButton3_RIVALDHAJI.setText("Grafik");
jButton3_RIVALDHAJI.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton3_RIVALDHAJIActionPerformed(evt);
}
});
javax.swing.GroupLayout
layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(425, 425,
425)
.addComponent(jLabel1)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4)
.addComponent(jLabel2)
.addComponent(jLabel3))
.addGap(69, 69, 69)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nim_RIVALDHAJI)
.addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.DEFAULT_SIZE,
130, Short.MAX_VALUE)))
.addGroup(layout.createSequentialGroup()
.addComponent(save_RIVALDHAJI)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(clear_RIVALDHAJI))))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(29, 29, 29)
.addComponent(tampil_RIVALDHAJI)
.addGap(72, 72, 72)
.addComponent(hapus_RIVALDHAJI)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
144, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGap(25, 25, 25)
.addComponent(jButton2_RIVALDHAJI)
.addGap(72, 72, 72)
.addComponent(jButton4_RIVALDHAJI))
.addGroup(layout.createSequentialGroup()
.addGap(24, 24, 24)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel7)
.addComponent(jLabel5)
.addComponent(jLabel6)
.addGroup(layout.createSequentialGroup()
.addComponent(jButton1_RIVALDHAJI)
.addGap(26, 26, 26)
.addComponent(jButton5_RIVALDHAJI)))
.addGap(23, 23, 23)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(7, 7, 7)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jTextField1_RIVALDHAJI)
.addComponent(jTextField2_RIVALDHAJI)
.addComponent(jTextField3_RIVALDHAJI,
javax.swing.GroupLayout.DEFAULT_SIZE, 110, Short.MAX_VALUE)))
.addComponent(jButton3_RIVALDHAJI))))
.addGap(58, 58,
58))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(nim_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(20, 20, 20)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(27, 27, 27)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(37, 37, 37)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(save_RIVALDHAJI)
.addComponent(clear_RIVALDHAJI))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 140,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tampil_RIVALDHAJI)
.addComponent(hapus_RIVALDHAJI)))
.addGroup(layout.createSequentialGroup()
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField1_RIVALDHAJI,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addGap(20, 20, 20)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField2_RIVALDHAJI,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6))
.addGap(27, 27, 27)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7)
.addComponent(jTextField3_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(37, 37, 37)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1_RIVALDHAJI)
.addComponent(jButton5_RIVALDHAJI)
.addComponent(jButton3_RIVALDHAJI))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 140,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton2_RIVALDHAJI)
.addComponent(jButton4_RIVALDHAJI))))
.addContainerGap(41, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void
hapus_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
try {
stat_RIVALDHAJI.executeUpdate("delete from data_mhs where " +
"NIM='"+nim_RIVALDHAJI.getText() +"'" );
kosongkan1_RIVALDHAJI();
JOptionPane.showMessageDialog(null, "Berhasil");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "pesan salah : "+e);
}
}
private void
jButton4_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
try {
stat_RIVALDHAJI.executeUpdate("delete from nilai_mhs where " +
"NIM='"+jTextField1_RIVALDHAJI.getText() +"'" );
kosongkan_RIVALDHAJI();
JOptionPane.showMessageDialog(null, "Berhasil");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "pesan salah : "+e);
}
}
private void
clear_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
kosongkan1_RIVALDHAJI();
}
private void
nim_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
}
private void
save_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
try {
String a;
a =
nim_RIVALDHAJI.getText();
jTextField1_RIVALDHAJI.setText(a);
int s=0;
koneksi_RIVALDHAJI();
String
cs="";
s=jComboBox1.getSelectedIndex();
if(s==0)
{
cs="Teknik
Informatika";
}
else if(s==1)
{
cs="Teknik
Kimia";
}
else if(s==2)
{
cs="Teknik
Industri";
}
else if(s==3)
{
cs="Sastra
Indonesia";
}
else if(s==4)
{
cs="Sastra
Jepang";
}
else
{
cs="Sastra
Inggris";
}
stat_RIVALDHAJI.executeUpdate("insert into data_mhs values ("
+ "'" + nim_RIVALDHAJI.getText()+"'," + "'" +
nama_RIVALDHAJI.getText()+ "',"+"'"+cs+"')");
kosongkan1_RIVALDHAJI();
JOptionPane.showMessageDialog(null, "Berhasil Menyimpan
Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Perintah Salah : "+e);
}
}
private void
jButton5_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
kosongkan1_RIVALDHAJI();
}
private void jButton1_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent
evt) {
// TODO add your handling
code here:
try {
stat_RIVALDHAJI.executeUpdate("insert into nilai_mhs values ("
+ "'" + jTextField1_RIVALDHAJI.getText()+"'," +
"'" + jTextField2_RIVALDHAJI.getText()+ "'," +
"'" + jTextField3_RIVALDHAJI.getText()+ "')");
kosongkan_RIVALDHAJI();
JOptionPane.showMessageDialog(null, "Berhasil Menyimpan
Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Perintah Salah : "+e);
}
}
private void
jButton3_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
RIVALDHAJI
obj1_RIVALDHAJI = new RIVALDHAJI();
obj1_RIVALDHAJI.setNilai(jTextField2_RIVALDHAJI.getText(),jTextField3_RIVALDHAJI.getText());
obj1_RIVALDHAJI.setVisible(true);
dispose();
}
private void
tampil_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling
code here:
try{
Object []
rows={"NIM","Nama","Jurusan"};
dtm_RIVALDHAJI=new
DefaultTableModel(null,rows);
tabel_RIVALDHAJI.setModel(dtm_RIVALDHAJI);
tabel_RIVALDHAJI.setBorder(null);
jScrollPane2.setVisible(true);
jScrollPane2.setViewportView(tabel_RIVALDHAJI);
int no = 1;
String
nim="",nama="",jrs="";try{String sql="select
* from data_mhs";Statement
st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql);
while(rs.next()){nim=rs.getString("NIM");nama=rs.getString("Nama");jrs=rs.getString("Jurusan");
String []
tampil={""+nim,nama,jrs};dtm_RIVALDHAJI.addRow(tampil);
}
}catch(SQLException
e){e.printStackTrace();
JOptionPane.showMessageDialog(null,"Query Salah "+e);
}
}catch(Exception e){e.printStackTrace();
}
}
private void
jButton2_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
Object []
rows={"NIM","Nilai Semester Ganjil","Nilai Semester
Genap"};
dtm_RIVALDHAJI=new
DefaultTableModel(null,rows);
jTable1_RIVALDHAJI.setModel(dtm_RIVALDHAJI);
jTable1_RIVALDHAJI.setBorder(null);
jScrollPane1.setVisible(true);
jScrollPane1.setViewportView(jTable1_RIVALDHAJI);
int no = 1;
String
nim="",gnp="",gjl="";try{String sql="select
* from nilai_mhs";Statement
st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql);
while(rs.next()){nim=rs.getString("NIM");gjl=rs.getString("Nilai
Semester Ganjil");gnp=rs.getString("Nilai Semester Genap");
String []
tampil={""+nim,gjl,gnp};dtm_RIVALDHAJI.addRow(tampil);
}
}catch(SQLException
e){e.printStackTrace();
JOptionPane.showMessageDialog(null,"Query
Salah "+e);
}
}catch(Exception
e){e.printStackTrace();
}
}
private void
tabel_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling
code here:
int i =
tabel_RIVALDHAJI.getSelectedRow();
if(i==-1){
return;
}
String code =
(String)tabel_RIVALDHAJI.getValueAt(i,0);
String code1 =
(String)tabel_RIVALDHAJI.getValueAt(i,1);
String code2 =
(String)tabel_RIVALDHAJI.getValueAt(i, 2);
String code3 =
(String)tabel_RIVALDHAJI.getValueAt(i, 0);
nim_RIVALDHAJI.setText(code);
nama_RIVALDHAJI.setText(code1);
jComboBox1.setSelectedItem(code2);
jTextField1_RIVALDHAJI.setText(code3);
}
private void
jTable1_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling
code here:
int i_RIVALDHAJI =
jTable1_RIVALDHAJI.getSelectedRow();
if(i_RIVALDHAJI==-1){
return;
}
String code_RIVALDHAJI =
(String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,0);
String code1_RIVALDHAJI =
(String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,1);
String code2_RIVALDHAJI =
(String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,2);
jTextField1_RIVALDHAJI.setText(code_RIVALDHAJI);
jTextField2_RIVALDHAJI.setText(code1_RIVALDHAJI);
jTextField3_RIVALDHAJI.setText(code2_RIVALDHAJI);
}
/**
* @param args the command line arguments
*/
public static void
main(String args[]) {
/* Set the Nimbus look
and feel */
//<editor-fold
defaultstate="collapsed" desc=" Look and feel setting code
(optional) ">
/* If Nimbus (introduced
in Java SE 6) is not available, stay with the default look and feel.
* For details see
http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for
(javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels()) {
if
("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch
(ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (InstantiationException
ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
//</editor-fold>
/* Create and display the
form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new
Nilai_Mahasiswa().setVisible(true);
}
});
}
// Variables declaration - do
not modify
private javax.swing.JButton
clear_RIVALDHAJI;
private javax.swing.JButton
hapus_RIVALDHAJI;
private javax.swing.JButton
jButton1_RIVALDHAJI;
private javax.swing.JButton
jButton2_RIVALDHAJI;
private javax.swing.JButton
jButton3_RIVALDHAJI;
private javax.swing.JButton
jButton4_RIVALDHAJI;
private javax.swing.JButton
jButton5_RIVALDHAJI;
private
javax.swing.JComboBox<String> jComboBox1;
private javax.swing.JLabel
jLabel1;
private javax.swing.JLabel
jLabel2;
private javax.swing.JLabel
jLabel3;
private javax.swing.JLabel
jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel
jLabel6;
private javax.swing.JLabel
jLabel7;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTable
jTable1_RIVALDHAJI;
private javax.swing.JTextField
jTextField1_RIVALDHAJI;
private
javax.swing.JTextField jTextField2_RIVALDHAJI;
private
javax.swing.JTextField jTextField3_RIVALDHAJI;
private
javax.swing.JTextField nama_RIVALDHAJI;
private
javax.swing.JTextField nim_RIVALDHAJI;
private javax.swing.JButton
save_RIVALDHAJI;
private javax.swing.JTable
tabel_RIVALDHAJI;
private javax.swing.JButton
tampil_RIVALDHAJI;
// End of variables
declaration
}
1111. Jalankan
/ Run program dengan cara klik kanan pada JFrame DataInput > Run Program
atau dengan menekan Shift+F6
Komentar
Posting Komentar