/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

package cobacoba;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

import javax.swing.JTextArea;

/**

 *

 * @author user

 */

public class Biodata extends javax.swing.JFrame {



 /**

 * Creates new form Biodata

 */

 properti pr;

 public Biodata() {

 initComponents();

 }



 /**

 * 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() {



 jTextFieldNama = new javax.swing.JTextField();

 jLabel1 = new javax.swing.JLabel();

 jTextFieldKampus = new javax.swing.JTextField();

 jLabel2 = new javax.swing.JLabel();

 jTextFieldAlamat = new javax.swing.JTextField();

 jLabel3 = new javax.swing.JLabel();

 jTextFieldTelpon = new javax.swing.JTextField();

 jLabel4 = new javax.swing.JLabel();

 jButtonSimpan = new javax.swing.JButton();

 jLabel5 = new javax.swing.JLabel();

 jTextFieldID = new javax.swing.JTextField();



 setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);



 jTextFieldNama.setName(""); // NOI18N



 jLabel1.setText("Nama");



 jLabel2.setText("Kampus");



 jLabel3.setText("Alamat");



 jLabel4.setText("No Telepon");



 jButtonSimpan.setText("Simpan");

 jButtonSimpan.addActionListener(new java.awt.event.ActionListener() {

 public void actionPerformed(java.awt.event.ActionEvent evt) {

 jButtonSimpanActionPerformed(evt);

 }

 });



 jLabel5.setText("ID");



 jTextFieldID.setName(""); // NOI18N



 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(78, 78, 78)

 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

 .addGroup(layout.createSequentialGroup()

 .addComponent(jLabel5)

 .addGap(35, 35, 35)

 .addComponent(jTextFieldID, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE))

 .addComponent(jButtonSimpan, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)

 .addGroup(layout.createSequentialGroup()

 .addComponent(jLabel4)

 .addGap(35, 35, 35)

 .addComponent(jTextFieldTelpon, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE))

 .addGroup(layout.createSequentialGroup()

 .addComponent(jLabel3)

 .addGap(35, 35, 35)

 .addComponent(jTextFieldAlamat, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE))

 .addGroup(layout.createSequentialGroup()

 .addComponent(jLabel2)

 .addGap(35, 35, 35)

 .addComponent(jTextFieldKampus, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE))

 .addGroup(layout.createSequentialGroup()

 .addComponent(jLabel1)

 .addGap(35, 35, 35)

 .addComponent(jTextFieldNama, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE)))

 .addContainerGap(174, Short.MAX_VALUE))

 );

 layout.setVerticalGroup(

 layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

 .addGroup(layout.createSequentialGroup()

 .addGap(13, 13, 13)

 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

 .addComponent(jTextFieldID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

 .addComponent(jLabel5))

 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

 .addComponent(jTextFieldNama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

 .addComponent(jLabel1))

 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

 .addComponent(jTextFieldKampus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

 .addComponent(jLabel2))

 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

 .addComponent(jTextFieldAlamat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

 .addComponent(jLabel3))

 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

 .addComponent(jTextFieldTelpon, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

 .addComponent(jLabel4))

 .addGap(28, 28, 28)

 .addComponent(jButtonSimpan)

 .addContainerGap(113, Short.MAX_VALUE))

 );



 pack();

 }// </editor-fold> 



 private void jButtonSimpanActionPerformed(java.awt.event.ActionEvent evt) { 

 

 // TODO add your handling code here:

 

 pr = new properti();

 pr.setID(Integer.valueOf(jTextFieldID.getText()));

 pr.setNama(jTextFieldNama.getText());

 pr.setKampus(jTextFieldKampus.getText());

 pr.setAlamat(jTextFieldAlamat.getText());

 pr.setNotelepon(jTextFieldTelpon.getText());

 

 try{

 pr.insertBiodata();

 /*String abc="Nama\\\\\\\\\\\\\\\\t:"+jTextFieldNama.getText()+"\n"+

 "Kampus\t:"+jTextFieldKampus.getText()+"\n"+

 "Alamat\t:"+jTextFieldAlamat.getText()+"\n"+

 "No Telepon\t:"+jTextFieldTelpon.getText();

 

 JOptionPane.showMessageDialog(null, new JTextArea(abc));

 */

 }

 catch(Exception ex)

 {

 JOptionPane.showMessageDialog(null, ex.getMessage());

 }

 } 



 /**

 * @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(Biodata.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

 } catch (InstantiationException ex) {

 java.util.logging.Logger.getLogger(Biodata.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

 } catch (IllegalAccessException ex) {

 java.util.logging.Logger.getLogger(Biodata.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

 } catch (javax.swing.UnsupportedLookAndFeelException ex) {

 java.util.logging.Logger.getLogger(Biodata.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 Biodata().setVisible(true);

 }

 });

 }

 // Variables declaration - do not modify 

 private javax.swing.JButton jButtonSimpan;

 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.JTextField jTextFieldAlamat;

 private javax.swing.JTextField jTextFieldID;

 private javax.swing.JTextField jTextFieldKampus;

 private javax.swing.JTextField jTextFieldNama;

 private javax.swing.JTextField jTextFieldTelpon;

 // End of variables declaration 

}

/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

package cobacoba;





import java.sql.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;







/**

 *

 * @author user

 */

public class properti {

 

 private int id;

 private String nama;

 private String kampus;

 private String alamat;

 private String notelepon;

 Connection koneksi;

// buat koneksi

 

String url="jdbc:mysql://localhost:8080/biodatasiswa";

String username="root";

String pass="";



 

 

 /**

 *

 */

 



 



 

 

 public void setID(int idnya)

 {

 

 id=idnya;

 }

 

 public int getID()

 {

 

 return id;

 }

 

 public void setNama(String namanya)

 {

 

 nama=namanya;

 }

 

 /**

 *

 * @return

 */

 public String getNama()

 {

 return nama;

 }

 

 public void setKampus(String kampusnya)

 {

 

 kampus=kampusnya;

 }

 

 public String getKampus()

 {

 return kampus;

 }

 

 public void setAlamat(String alamatnya)

 {

 alamat=alamatnya;

 }

 

 public String getAlamat()

 {

 return alamat;

 }

 

 public void setNotelepon(String noteleponnya)

 {

 notelepon=noteleponnya;

 }

 

 public String getNotelepon()

 {

 return notelepon;

 }

 

 /**

 *

 * @return

 * @throws ClassNotFoundException

 */

 public void insertBiodata()throws ClassNotFoundException

 {

 

 String sql="insert into biodata1 values("+this.getID()+",'"+this.getNama()+"','"+this.getKampus()+"','"+this.getAlamat()+"','"+this.getNotelepon()+"');";

 try

 {

 Class.forName("com.mysql.jdbc.Driver").newInstance();

 koneksi = DriverManager.getConnection(url, username, pass);

 Statement st = koneksi.createStatement();

 st.executeUpdate(sql);

 

 }

 catch(SQLException ex)

 {

 

 }

 catch(InstantiationException ex)

 {}

 catch(IllegalAccessException ex)

 {}

 catch(NumberFormatException ex)

 {}

 

 

 }

}