Database Kategori

database access

tampilan awal program

package Kategori;

import java.sql.*;

import javax.swing.*;

  

/**

 *

 * @author Juli

 */

public class Cobain {

    void testCobain()

    {

        try

        {

            String dbname="jdbc:odbc:Kategori_12090629";

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection con=DriverManager.getConnection(dbname,"admin","admin");

            JOptionPane.showMessageDialog(null, "Cobain Berhasil","Insert Data",JOptionPane.INFORMATION_MESSAGE);

            con.close();

        }

        catch (Exception e)

        {

            JOptionPane.showInternalMessageDialog(null, "error"+e,"Gagal",JOptionPane.WARNING_MESSAGE);

        }

    }

    public static void main(String args[])

    {

            Cobain test = new Cobain ();

            test.testCobain();

            System.exit(0);

    }

}

package Kategori; 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.swing.JOptionPane;

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

// TODO add your handling code here:

    txtkode.setText("");

    txtnama.setText("");

    txtkode.setEditable(true);

    txtnama.setEditable(true);

    txtkode.requestFocus();

}                       

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

// TODO add your handling code here:

    String kode=txtkode.getText();

    String nama=txtnama.getText();

    try

    {

        String dbname="jdbc:odbc:Kategori_12090629";

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        Connection con=DriverManager.getConnection(dbname,"admin","admin");

        java.sql.Statement statement=con.createStatement();

        String sql="insert into tb_kategori values('"+kode+"','"+nama+"');";

        statement.executeUpdate(sql);

        statement.close();

        

        JOptionPane.showMessageDialog(null,"data berhasil di input","Insert data",JOptionPane.INFORMATION_MESSAGE);

        con.close();}

    catch (Exception e)

    {

        JOptionPane.showMessageDialog(null,"Error"+e,"Gagal",JOptionPane.WARNING_MESSAGE);

    }        

}            

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

// TODO add your handling code here:

    String kode=txtkode.getText();

    String nama=txtnama.getText();

    try

    {

        String dbname="jdbc:odbc:Kategori_12090629";

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        Connection con=DriverManager.getConnection(dbname,"admin","admin");

        Statement statement = con.createStatement();

        String sql ="Update tb_kategori SET NAMA='"+nama+"'While KODE Like'"+kode+"'";

        statement.executeUpdate(sql);

        statement.close();

        JOptionPane.showMessageDialog(null,"Data berhasil di edit","Edit data",JOptionPane.INFORMATION_MESSAGE);

        con.close();

    }

    catch (Exception e)

    {

        JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);

    }

}       

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

// TODO add your handling code here:

    String kode=txtkode.getText();

    try

    {

        String dbname="jdbc:odbc:Kategori_12090629";

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        Connection con=DriverManager.getConnection(dbname,"admin","admin");

        Statement statement = con.createStatement();

        String sql = "Delete From tb_kategori Where KODE Like'"+kode+"'";

        statement.executeUpdate(sql);

        statement.close();

        txtkode.setText("");

        txtnama.setText("");

        JOptionPane.showMessageDialog(null,"Data berhasil di hapus","Hapus Data",JOptionPane.INFORMATION_MESSAGE);

con.close();

    }

    catch (Exception e)

    {

    JOptionPane.showMessageDialog(null,"Error:"+e,"gagal",JOptionPane.WARNING_MESSAGE);

    }              

}                      

private void btnExitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
    JOptionPane.showMessageDialog(null,"Terima Kasih","Keluar",1);
    System.exit(0);