Membuat koneksi Mysql menggunakan Script Java

Membuat koneksi dengan script java akan membuat atau menyambungkan data yang ada pada Mysql akan terditeksi, dengan bantuan XAMPP semuanya akan jadi mudah memasukan dan menghapus data, beberapa contoh Script java coneksi dibawah ini akan membantu anda membuat data di mysql.

1. code Cruid

import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;


class DBnews extends JFrame{
JLabel lblNama = new JLabel("Nama");
JLabel lblNim = new JLabel("Nim");
JTextField txtNama = new JTextField(8);
JTextField txtNim = new JTextField(8);
JButton btnSimpan = new JButton("Simpan");
JButton btnUbah = new JButton("Ubah");
JButton btnHapus = new JButton("Hapus");
JTable tabel = new JTable();
JScrollPane jScrollPane = new JScrollPane();
private Connection conn;

void DBnews(){
setTitle("KELOMPOK 1");
setLocation (200,300);
setSize (800,300);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}


void aturKomponen(){
getContentPane().setLayout(null);
getContentPane().add(lblNim);
lblNim.setBounds(10,10,100,20);
getContentPane().add(lblNama);
lblNama.setBounds(10,30,100,20);
getContentPane().add(txtNim);
txtNim.setBounds(130,10,100,20);
getContentPane().add(txtNama);
txtNama.setBounds(130,30,100,20);
getContentPane().add(tabel);
tabel.setBounds(20,60,600,200);
getContentPane().add(btnSimpan);
btnSimpan.setBounds(250,10,100,20);
getContentPane().add(btnUbah);
btnUbah.setBounds(250,30,100,20);
getContentPane().add(btnHapus);
btnHapus.setBounds(350,10,100,40);
setVisible(true);


}


public void aksi(){
btnSimpan.addActionListener(new java.awt.event.ActionListener(){
public void actionPerformed(java.awt.event.ActionEvent evt){
try{
masukanData();
}
catch (Exception e) {
}
}
});

btnUbah.addActionListener(new java.awt.event.ActionListener(){
public void actionPerformed(java.awt.event.ActionEvent evt){
try{
ubahData();
}
catch (Exception e){
}
}
});


btnHapus.addActionListener(new java.awt.event.ActionListener(){
public void actionPerformed(java.awt.event.ActionEvent evt){
try{
hapusData();
}
catch (Exception e){
}
}
});


tabel.addMouseListener(new java.awt.event.MouseAdapter(){
public void mouseClicked(java.awt.event.MouseEvent evt){
tableClick();
}
});
}


private void tableClick(){
int xbaris = this.tabel.getSelectedRow();
txtNim.setText(tabel.getValueAt(xbaris,0).toString ());
txtNama.setText(tabel.getValueAt(xbaris,1).toString ());
}

private void koneksi() throws ClassNotFoundException {
try {
Class.forName("com.mysql.jdbc.Driver");
conn= DriverManager.getConnection("jdbc:mysql://localhost/perpustakaan?user=root&password=");
Statement stmt = conn.createStatement();
}
catch (Exception e){
}
}


private void showTabel(){
DefaultTableModel dtm=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/dbnews?user=root&password=");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from mhs");
//Menciptakan model tabel
dtm = createTable (rs);
}
catch (Exception e){
}
pack();
setVisible(true);
tabel.setModel(dtm);
}


private void masukanData() throws SQLException, SQLException,ClassNotFoundException {
koneksi();
Statement perintah = conn.createStatement();
String sql = "insert into mhs values ('"+txtNama.getText() +"', '"+txtNim.getText()+"')";
perintah.execute(sql);
perintah.close();
txtNama.setText("");
txtNim.setText("");
showTabel();
aturKomponen();
JOptionPane.showMessageDialog(null, "Data berhasil disimpan","Informasi", JOptionPane.INFORMATION_MESSAGE);
}


private void ubahData() throws SQLException, SQLException, ClassNotFoundException {
koneksi();
Statement perintah = conn.createStatement();
String sql = "update mhs set nama='"+txtNama.getText()+"' where Nim='"+txtNim.getText()+"'";
perintah.execute(sql);
perintah.close();
txtNama.setText("");
txtNim.setText("");
showTabel();
aturKomponen();
JOptionPane.showMessageDialog(null,"Data berhasil diubah", "Informasi", JOptionPane.INFORMATION_MESSAGE);
}


private void hapusData() throws SQLException, SQLException, ClassNotFoundException{
koneksi();
Statement perintah = conn.createStatement();
String sql = "delete from  mhs where Nim ='"+txtNim.getText()+"'";
perintah.execute(sql);
perintah.close();
txtNama.setText("");
txtNim.setText("");
showTabel();
aturKomponen();
JOptionPane.showMessageDialog(null,"Data berhasil diubah", "Informasi", JOptionPane.INFORMATION_MESSAGE);
}


private DefaultTableModel createTable(ResultSet rs) throws SQLException{
DefaultTableModel dtm = new DefaultTableModel();
ResultSetMetaData rsmd = rs.getMetaData();
int intNum = rsmd.getColumnCount();
String[] str = new String[intNum];
for (int i = 0; i < intNum; i++){
str[i] = rsmd.getColumnName(i + 1);
}
dtm.setColumnIdentifiers(str);
while (rs.next()){
String[] data = new String[intNum];
for (int i = 0; i < intNum; i++){
data[i] = rs.getString(i + 1);
}
dtm.addRow(data);
}
return dtm;
}


public static void main(String[] args){
DBnews running=new DBnews();
running.DBnews();
running.aturKomponen();
running.showTabel();
running.aksi();
}
}


2. Script Menu

import javax.swing.*;


public class menu extends JFrame {


    JMenuBar menubar = new JMenuBar();
    JMenu file = new JMenu("File");
    JMenu operasi = new JMenu("Operasi");
    JMenu about = new JMenu("Pembuat");
    JMenuItem exit = new JMenuItem("Exit");
    JMenuItem cruid = new JMenuItem("CRUID");
    JMenuItem pembuat = new JMenuItem("Pembuat");


    menu() {
        setTitle("Contoh Menu ");
        setLocation(400, 200);
        setSize(400, 250);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


    }


    void pengaturanComponen() {
        getContentPane().setLayout(null);


        menubar.add(file);
        menubar.add(operasi);
        menubar.add(about);
        file.add(exit);
        operasi.add(cruid);
about.add(pembuat);
        getContentPane().add(menubar);
        menubar.setBounds(4, 4, 400, 40);
        setVisible(true);
    }


    void aksi() {
        exit.addActionListener(new java.awt.event.ActionListener() {


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


            System.exit(0);


            }
        });
cruid.addActionListener(new java.awt.event.ActionListener() {


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


                cruid CruidAlias=new cruid();
               CruidAlias.setVisible(true);


            }
        });
pembuat.addActionListener(new java.awt.event.ActionListener() {


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


                About AboutAlias=new About();
               AboutAlias.setVisible(true);


            }
        });
    }


    public static void main(String[] args) {




        menu runningapp = new menu();
        runningapp.pengaturanComponen();
        runningapp.aksi();
    }
}




3. Script koneksi

import javax.swing.*;
import java.awt.*;
import java.sql.*;
public class Koneksi {
    
    void koneksiDatabase(){
            try {
             Class.forName("com.mysql.jdbc.Driver");
           Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/dbnews?user=root&password=");
           Statement stmt = conn.createStatement();
           
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, ex.getMessage());
        } catch (ClassNotFoundException ex) {
            JOptionPane.showMessageDialog(null, ex.getMessage());
        }


    }






    public static void main(String args[]){
    Koneksi kon=new Koneksi();
    kon.koneksiDatabase();


    }






}
4. script import

import java.util.logging.level;
import java.util.logging.logger;
import javax.swing.*;
import javax.sql.*;
import javax.swing.table.DefaultTableModel;


class cruid extends JFrame {
 JLabel lblNama =new JLabel("Nama ");
 JLabel lblNim = new JLabel("NIM ");
 JTextField txtNama =new JTextField(8);
 JTextField txtNim = new JTextField(8);
 JButton btnSimpan =new JButton("Simpan");
 JButton btnUbah =new JButton("Ubah");
 JButton btnHapus =new JButton("Hapus");
 Jtable table =new JTable();
 JScrollPane jScrollPane = new JScrollPane();
 private Connection conn;


 void cruid (){
  setTitle("contoh database");
  setLocation (200,300);
  setSize(800,300);
  setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
 }


 void aturKomponen(){
  getContentPane().setlayout(null);
  getContentPane().add(lblNim);
  lblNim.setBounds(10,10,100,20);
  getContentPane().add(lblNama);
  lblNama.setBounds(10,30,100,20);
  getContentPane().add(txtNim);
  txtNim.setBounds(130,10,100,20);
  getContentPane().add(txtNama);
  txtNama.setBounds(130,30,100,20);
  getContentPane().add(tabel);
  tabel.setBounds(20,60,600,200);
  getContentPane().add(btnSimpan);
  btnSimpan.setBounds(250,10,30,100,20);
  getContentPane().add(btnUbah);
  btnUbah.setBounds(250,30,100,20);
  getContenPane().add(btnHapus);
  btnHapus.setBounds(350,10,100,20);
  setVisible(true);
}




public void aksi(){


  btnSimpan.addActionListener(new java.awt.event.ActionListener) {
public void actionPerformed(java)
  


apabila ingin menambahkan foto dalam data maka scriptnya

import javax.swing.*;




class About extends JFrame {


 JLabel lblFoto =new JLabel();
 JLabel Ket =new JLabel("Created By: ");


 About (){
  setTitle("About..");
  setLocation (200,300);
  setSize(200,200);
  setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
aturKomponen();
  setVisible(true);
 }


 void aturKomponen(){
 lblFoto.setIcon(new javax.swing.ImageIcon("edit.png"));


  getContentPane().setLayout(null);
  getContentPane().add(lblFoto);
  lblFoto.setBounds(50,20,200,180);
  getContentPane().add(Ket);
  Ket.setBounds(10,40,200,20);
 }




 public static void main(String args[]){


  java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new About().setVisible(true);
            }
        });




 }
}

Posted in: Java