Langkah-langkah membuat aplikasi database dengan menampilkan hasil grafik
1.) Buka Xampp, kemudian hidupkan Apache dan MySql
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