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();
}
}
Filed under: java
;
