LISTING PROGRAM DATABASE PADA JAVA (NETBEANS)

LISTING PROGRAM DATABASE PADA JAVA (NETBEANS)

Package ....

import java.sql.*;

import javax.swing.*;

*** Listing Program Simpan

 String Npm = jTextField1.getText();

String Nama = jTextField2.getText();

String Alamat = jTextField3.getText();

String TTL = jTextField4.getText();

String Jur = jTextField5.getText();

String TA = jTextField6.getText();

try

{

String dbname="jdbc:odbc:Mahasiswa1";

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

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

Statement statement = con.createStatement();

String sql="insert into tbMhs values('"+Npm+"','"+Nama+"','"+Alamat+"','"+TTL+"','"+Jur+"','"+TA+"');";

statement.executeUpdate(sql);

statement.close();

JOptionPane.showMessageDialog(null, "Data berhasil dimasukkan..","Insert Data",JOptionPane.INFORMATION_MESSAGE);

con.close();

}

catch (Exception e)

{

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

//System.err.println("Exception: "+e.getMessage());

} 

*** Listing Program Batal

    jTextField1.setText("");

    jTextField2.setText("");

    jTextField3.setText("");

    jTextField4.setText("");

    jTextField5.setText("");

    jTextField6.setText("");

*** Listing Program Cari

    String Npm = jTextField1.getText();

try

{

String dbname="jdbc:odbc:Mahasiswa1";

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

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

Statement statement = con.createStatement();

String sql="SELECT * FROM tbMhs WHERE Npm like '"+Npm+"'";

ResultSet rs = statement.executeQuery(sql);

if (rs.next())

{

jTextField2.setText(rs.getString(2));

jTextField3.setText(rs.getString(3));

jTextField4.setText(rs.getString(4));

jTextField5.setText(rs.getString(5));

jTextField6.setText(rs.getString(6));

JOptionPane.showMessageDialog(null, "Data ditemukan","InsertData",JOptionPane.INFORMATION_MESSAGE);

}

else

{

JOptionPane.showMessageDialog(null, "Data tidak ditemukan ","InsertData",JOptionPane.INFORMATION_MESSAGE);

}

statement.close();

con.close();

}

catch (Exception e)

{

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

//System.err.println("Exception: "+e.getMessage());

}

*** Listing Program Edit

String Nama = jTextField2.getText();

String Alamat = jTextField3.getText();

String TTL = jTextField4.getText();

String Jur = String Npm = jTextField1.getText();

String jTextField5.getText();

String TA = jTextField6.getText();

try

{

String dbname="jdbc:odbc:Mahasiswa1";

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

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

Statement statement = con.createStatement();

String sql="UPDATE tbMhs SET Nama='"+Nama+"',Alamat='"+Alamat+"',TTL='"+TTL+"',Jur='"+Jur+"',TA='"+TA+"'WHERE Npm LIKE '"+Npm+"'";

statement.executeUpdate(sql);

statement.close();

JOptionPane.showMessageDialog(null, "Data berhasil diEDIT..","Insert Data",JOptionPane.INFORMATION_MESSAGE);

con.close();

}

catch (Exception e)

{

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

//System.err.println("Exception: "+e.getMessage());

}  

*** Listing Program Hapus

       String Npm = jTextField1.getText();

try

{

String dbname="jdbc:odbc:Mahasiswa1";

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

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

Statement statement = con.createStatement();

String sql="DELETE FROM tbMhs WHERE Npm LIKE '"+Npm+"'";

ResultSet rs = statement.executeQuery(sql);

if (rs.next())

{

jTextField2.setText(rs.getString(2));

jTextField3.setText(rs.getString(3));

jTextField4.setText(rs.getString(4));

jTextField5.setText(rs.getString(5));

jTextField6.setText(rs.getString(6));

JOptionPane.showMessageDialog(null, "Data diHAPUS","InsertData",JOptionPane.INFORMATION_MESSAGE);

}

else

{

JOptionPane.showMessageDialog(null, "Data tidak ditemukan ","InsertData",JOptionPane.INFORMATION_MESSAGE);

}

statement.close();

con.close();

}

catch (Exception e)

{

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

//System.err.println("Exception: "+e.getMessage());

}

*** Listing Program Keluar

dispose();