ini ada source code koneksiin java ke mysql bagi yang sedang belajar silahkan di baca atau di copy silahkan

import   java.awt.*;
import   java.awt.event.*;
import   javax.swing.*;
import   java.sql.*;
  class test extends JFrame implements ActionListener
  {
            private Container konten  = new Container();
            private JPanel panel1 = new JPanel();
            private JLabel lblNim = new JLabel("Nim   :");
            private JTextField txtNim = new JTextField(10);
            private JLabel lblNama = new JLabel("Nama         :");
            private JTextField txtNama = new JTextField(20);
           
             JButton insertBtn            =          new      JButton("Insert");
             JButton searchBtn          =          new      JButton("Search");
             JButton editBtn              =          new      JButton("Edit");
             JButton deleteBtn           =          new      JButton("Delete");
             JButton clearBtn             =          new      JButton("Clear");
             JButton exitBtn               =          new      JButton("Exit");
             
             //         Deklarsi String Global agar bisa digunakan berulang kali
            String    strNim                           =          "";
            String    strNama                        =          "";
           
           
            //          Hal yang sangat perlu diingat untuk membuat database dalam MySQL
            String    koneksi              =          "org.gjt.mm.mysql.Driver";
            String    database           =          "jdbc:mysql://localhost/mahasiswa";
            String    user                  =          "root";
            String    password          =          "";
           
            test()
            {
                        super("Formulir ");
                        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                        setLocation(10,100);
                        setSize(750,350);
                       
                        konten = getContentPane();
                        konten.setLayout(new FlowLayout(FlowLayout.CENTER));
                       
                        panel1.setLayout(new GridLayout(5,2,5,5));
                        panel1.add(lblNim);
                        panel1.add(txtNim);
                        panel1.add(lblNama);
                        panel1.add(txtNama);
                        panel1.add(insertBtn);
                        panel1.add(searchBtn);
                        panel1.add(editBtn);
                        panel1.add(deleteBtn);
                        panel1.add(clearBtn);
                        panel1.add(exitBtn);
                       
                        insertBtn.addActionListener(this);
                        searchBtn.addActionListener(this);
                        editBtn.addActionListener(this);
                        deleteBtn.addActionListener(this);
                        clearBtn.addActionListener(this);
                        exitBtn.addActionListener(this);
                       
                       
                        konten.add(panel1);
                        pack();
                        show();
            }          
            public void insert()
            {
                        try
                        {
                                    Class.forName(koneksi);
                                    Connection connection = DriverManager.getConnection(database,user,password);
                                    Statement statement = connection.createStatement();
                                    String    sql   =   "insert into data (Nim, Nama) values (’"+strNim+"’,'"+strNama+"’);";
                                               
                                    statement.executeUpdate(sql);
                                    statement.close();
                                    connection.close();
                                   
                                    JOptionPane.showMessageDialog(null,"Data telah disimpan","Insert "+
                                    "Data",JOptionPane.INFORMATION_MESSAGE);
                                    clear();
                        }
                        catch(Exception e)
                        {
                                    JOptionPane.showMessageDialog(null,"Error at insert function",
                                    "Insert Is Error",JOptionPane.ERROR_MESSAGE);
                        }
            }
           
            public void select()
            {
                        try
                        {
                                    Class.forName(koneksi);
                                    Connection connection = DriverManager.getConnection(database,user,password);
                                    Statement  statement = connection.createStatement();
                                    String    sql        = "select * from data where Nim = ‘"+ strNim+"’;";
                                               
                                    ResultSet           rs         =          statement.executeQuery(sql);
                                    if(rs.next())
                                    {
                                                txtNim.setText(rs.getString(1));
                                                txtNama.setText(rs.getString(2));
                                               
                                    }
                                    else
                                    JOptionPane.showMessageDialog(null,"Data yang anda cari tidak"+
                                                "ditemukan","Searching Data",JOptionPane.INFORMATION_MESSAGE);
                                               
                                    statement.close();
                                    connection.close();
                        }
                        catch(Exception e)
                        {
                                    JOptionPane.showMessageDialog(null,"Error at select function",
                                    "Select Is Error",JOptionPane.ERROR_MESSAGE);
                        }
            }
           
            public void update()
            {
                        try
                        {
                                    Class.forName(koneksi);
                                    Connection connection = DriverManager.getConnection(database,user,password);
                                    Statement statement =  connection.createStatement();
String sql = "update  data set Nama=’"+strNama+"’ where Nim=’"+txtNim.getText()+"’";
                                   
                                    statement.executeUpdate(sql);
                                    statement.close();
                                    connection.close();
                                   
                                    JOptionPane.showMessageDialog(null,"Data telah di-Update",
                                    "Update Data",JOptionPane.INFORMATION_MESSAGE);
                                    clear();
                        }
                        catch(Exception e)
                        {
                                    JOptionPane.showMessageDialog(null,"Error at update function",
                                    "Update Is Error",JOptionPane.ERROR_MESSAGE);
                        }
            }
           
            public void delete()
            {
                        try
                        {
                                    Class.forName(koneksi);
                                    Connection connection = DriverManager.getConnection(database,user,password);
                                    Statement statement =   connection.createStatement();
                                    String sql =   "delete from data where Nim = ‘"+ strNim+"’;";
                                               
                                    statement.executeUpdate(sql);
                                    statement.close();
                                    connection.close();
                                   
                                    JOptionPane.showMessageDialog(null,"Data telah dihapus",
                                    "Delete Data",JOptionPane.INFORMATION_MESSAGE);
                                    clear();
                        }
                        catch(Exception e)
                        {
                                    JOptionPane.showMessageDialog(null,"Error at delete function",
                                    "Delete Is Error",JOptionPane.ERROR_MESSAGE);
                        }
            }
           
            public void clear()
            {
                        try
                        {
                                    txtNim.setText("");
                                    txtNama.setText("");
                                    txtNim.requestFocus();
                        }
                        catch(Exception e)
                        {
                                    JOptionPane.showMessageDialog(null,"Error at clear function",
                                    "Clear Is Error",JOptionPane.ERROR_MESSAGE);
                        }
            }
           
            public void actionPerformed(ActionEvent event)
            {
                        strNim               =          txtNim.getText();
                        strNama            =          txtNama.getText();
                       
                        try
                        {
                                    if(event.getSource()       ==        insertBtn)
                                                insert();
                                    if(event.getSource()       ==        searchBtn)
                                                select();
                                    if(event.getSource()       ==        editBtn)
                                                update();
                                    if(event.getSource()       ==        deleteBtn)
                                                delete();
                                    if(event.getSource()       ==        clearBtn)
                                                clear();
                                    if(event.getSource()       ==        exitBtn)
                                                System.exit(0);
                        }
                        catch(Exception e)
                        {
                                    JOptionPane.showMessageDialog(null,"Error at actionPerformed "+
                                    "function","ActionPerformed Is Error",JOptionPane.ERROR_MESSAGE);
                        }
            }
            public static void main(String args[])

            {

                new test();
            }
  }