- Beranda
- Komunitas
- Tech
- Programmer Forum
[ASK] Cara koneksi java ke mysql


TS
putusaputra
[ASK] Cara koneksi java ke mysql
Malem gan . .
ane mw numpang nanya gan. ane lg buat project tentang java desktop. ane stuck di koneksiin databasenya. ane udah coba cari tutorial di internet tp semua yang ane coba slalu error
Berikut Gambar Programnya :
Berikut Codingnya
ane pake 1 jframeform sama 1 class
Mohon bantuannya gan
ane mw numpang nanya gan. ane lg buat project tentang java desktop. ane stuck di koneksiin databasenya. ane udah coba cari tutorial di internet tp semua yang ane coba slalu error
Berikut Gambar Programnya :
Spoiler for gambar:
![[ASK] Cara koneksi java ke mysql](https://s.kaskus.id/images/2013/09/05/3602689_20130905071909.jpg)
Berikut Codingnya
Spoiler for Biodata.java:
Code:
/*
* 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) {
try {
// 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());
if(pr.insertBiodata())
{
JOptionPane.showMessageDialog(null, "Data berhasil disimpan");
}
else
{
JOptionPane.showMessageDialog(null, "Data gagal disimpan");
}
/*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 (ClassNotFoundException ex) {
Logger.getLogger(Biodata.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* @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
}
Spoiler for properti.java:
Code:
/*
* 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;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @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 boolean insertBiodata() throws ClassNotFoundException
{
koneksi=null;
try {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException ex) {
Logger.getLogger(properti.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(properti.class.getName()).log(Level.SEVERE, null, ex);
}
koneksi = DriverManager.getConnection(url, username, pass);
try (Statement statement = koneksi.createStatement()) {
statement.executeUpdate("INSERT INTO BIODATA1 VALUES("+this.getID()+",'"+this.getNama()+"','"+this.getKampus()+"','"+this.getAlamat()+"','"+this.getNotelepon()+"')" );
}
return true;
} catch (SQLException ex) {
return false;
}
}
}
ane pake 1 jframeform sama 1 class
Mohon bantuannya gan

0
1.5K
Kutip
7
Balasan


Komentar yang asik ya
Urutan
Terbaru
Terlama


Komentar yang asik ya
Komunitas Pilihan