Ditta Khairunnisa
0611503004
1. Buat new project lalu kita beri nama dengan Utama.main dimana di kelas utama ini program yang akan dieksekusi.
2. lalu simpan di folder sesuai keinginan kita
Pada Editor Netbeans ketika anda membuat project maka otomatis packagenya akan terbentuk dan dinamakan sesuai dengan nama project yang anda buat.
Lagkah selanjutnya adalah membuat design atau formnya:
1. Klik kanan pada package yang anda buat lalu pilih new-jframe form
2. beri nama form dengan jenis_test
package utama;
import javax.swing.event.*;
import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;
import com.toedter.calendar.*;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Calendar;
import java.text.*; //biar yang diinput cuma angka
import javax.swing.text.*;
import javax.swing.table.DefaultTableModel;
/**
*
* @author ditta
*/
public class jenis_test extends javax.swing.JFrame {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
DefaultTableModel tabMod;
String[] strjdl ={"Kode Test","Nama Test"};
/** Creates new form jenis_test */
public jenis_test() {
initComponents();
tabMod = new DefaultTableModel(null,strjdl);
tabel.setModel(tabMod);
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
//
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
txtkdtest = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
txtnmtest = new javax.swing.JTextField();
btnsave = new javax.swing.JButton();
btnedit = new javax.swing.JButton();
btndelete = new javax.swing.JButton();
btncancel = new javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
tabel = new javax.swing.JTable();
btnexit = new javax.swing.JButton();
btncari = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBackground(new java.awt.Color(0, 102, 153));
jLabel1.setFont(new java.awt.Font("Arial Black", 1, 14));
jLabel1.setText("Entry Jenis Test");
jLabel2.setText("Kode Test");
txtkdtest.addFocusListener(new java.awt.event.FocusAdapter() {
public void focusGained(java.awt.event.FocusEvent evt) {
txtkdtestFocusGained(evt);
}
});
txtkdtest.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
txtkdtestKeyPressed(evt);
}
public void keyReleased(java.awt.event.KeyEvent evt) {
txtkdtestKeyReleased(evt);
}
});
jLabel3.setText("Nama Test");
btnsave.setText("Save");
btnsave.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnsaveActionPerformed(evt);
}
});
btnedit.setText("Edit");
btnedit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btneditActionPerformed(evt);
}
});
btndelete.setText("Delete");
btndelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btndeleteActionPerformed(evt);
}
});
btncancel.setText("Cancel");
btncancel.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btncancelActionPerformed(evt);
}
});
tabel.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null},
{null, null},
{null, null},
{null, null}
},
new String [] {
"Kode Test", "Nama Test"
}
));
tabel.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
tabelMousePressed(evt);
}
});
jScrollPane2.setViewportView(tabel);
btnexit.setText("Exit");
btnexit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnexitActionPerformed(evt);
}
});
btncari.setText("Cari");
btncari.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btncariActionPerformed(evt);
}
});
private void txtkdtestFocusGained(java.awt.event.FocusEvent evt) {
// TODO add your handling code here:
add();
}
private void txtkdtestKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
}
private void txtkdtestKeyReleased(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
}
private void btnsaveActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
save();
}
private void btneditActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
edit();
}
private void btndeleteActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
delete();
}
private void btncancelActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:zzz
cancel();
}
private void tabelMousePressed(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
isi();
}
private void btnexitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
dispose();
}
private void btncariActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here
tampilketabel();
}
void keluar(){
System.exit(0);
}
public String getkdtest() {
try {
//HashMap plg=new HashMap();
koneksi konek = new koneksi();
Connection conn = konek.open_a_Connection();
Statement stm = conn.createStatement();
String sql="SELECT kd_test FROM jenis_test ORDER BY kd_test DESC";
ResultSet rs =stm.executeQuery(sql);
if(rs.next()) {
String kode="";
int kod=Integer.parseInt(rs.getString("kd_test").substring(1)) + 1;
conn.close();
if(kod > 1 && kod < 10) { kode= "T000" + kod; } else if(kod > 9 && kod < 100) { kode= "T00" + kod; } else if(kod > 99 && kod < 1000) { kode= "T0" + kod; } else if(kod > 999 && kod < 1000) {
kode= "T" + kod;
}
return kode;
}
else {
conn.close();
return "T0001";
}
} catch(Exception e) {
JOptionPane.showMessageDialog(null,e);
return null;
}
}
void add(){
cancel();
txtkdtest.setText(getkdtest());
btnsave.setEnabled(true);
btnedit.setEnabled(false);
btndelete.setEnabled(false);
txtnmtest.requestFocus();
txtkdtest.setEditable(false);
}
void cancel()
{
//txtnmcasis.setText("");
txtkdtest.setText("");
txtnmtest.setText("");
txtkdtest.requestFocus();
txtkdtest.setEditable(true);
}
void save(){
try{
String sql="insert into jenis_test values('"+txtkdtest.getText()+"','"+txtnmtest.getText()+"')";
koneksi konek = new koneksi();
Connection conn=konek.open_a_Connection();
Statement stm=conn.createStatement();
stm.executeUpdate(sql);
JOptionPane.showMessageDialog(null,"konfirmasi","data telah berhasil disimpan",JOptionPane.INFORMATION_MESSAGE);
stm.close();
conn.close();
cancel();
tampilketabel();
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Konfirmasi"+e,"Data Gagal"+e,JOptionPane.INFORMATION_MESSAGE);
}
}
void edit(){
try{
String sql=" update jenis_test set nm_test='"+txtnmtest.getText()+"' where kd_test='"+txtkdtest.getText()+"'";
koneksi konek=new koneksi();
Connection conn=konek.open_a_Connection();
Statement stm= conn.createStatement();
stm.executeUpdate(sql);
JOptionPane.showMessageDialog(null,"Keterangan","data berhasil di update",JOptionPane.INFORMATION_MESSAGE);
tampilketabel();
cancel();
stm.close();
conn.close();
cancel();
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Konfirmasi","Data Gagal Dimasukan",JOptionPane.ERROR_MESSAGE);
}
}
void tampil(){
try{
String sql="select * from jenis_test where kd_test='"+txtkdtest.getText()+"'";
koneksi konek = new koneksi();
Connection conn = konek.open_a_Connection();
Statement stm = conn.createStatement();
ResultSet rs =stm.executeQuery(sql);
if(rs.next()){
txtnmtest.setText(rs.getString("nm_test"));
btnsave.setEnabled(false);
btnedit.setEnabled(true);
btndelete.setEnabled(true);
btncancel.setEnabled(true);
}
} catch(Exception e){
JOptionPane.showMessageDialog(null,"Konfirmasi","data Tidak Ada",JOptionPane.INFORMATION_MESSAGE);
}
}
void delete(){
try{
String sql="delete from jenis_test where kd_test='"+txtkdtest.getText()+"'";
koneksi konek=new koneksi();
Connection conn=konek.open_a_Connection();
Statement stm= conn.createStatement();
stm.executeUpdate(sql);
JOptionPane.showMessageDialog(null,"Keterangan","data berhasil di Delete",JOptionPane.INFORMATION_MESSAGE);
tampilketabel();
cancel();
stm.close();
conn.close();
}catch(Exception e){
JOptionPane.showMessageDialog(null,"konfirmasi","data Gagal di delete",JOptionPane.ERROR_MESSAGE);
}
}
void tampilketabel(){
try{
hapusTabel();
String sql="select * from jenis_test order by kd_test asc";
koneksi konek = new koneksi();
Connection conn = konek.open_a_Connection();
Statement state = conn.createStatement();
ResultSet rs = state.executeQuery (sql);
while (rs.next()){
//String tglkwi = rs.getString("tgl_kwi");
String kdtest=rs.getString("kd_test");
String nmtest=rs.getString("nm_test");
String [] data = {kdtest,nmtest};
tabMod.addRow(data);
}
}
catch(Exception e){
JOptionPane.showMessageDialog(null,"konfirmasi","data tidak dapat dimasukan ke tabel",JOptionPane.ERROR_MESSAGE);
}
}
void hapusTabel(){
int brs = tabMod.getRowCount();
for(int i=0;i
}
}
private void isi() {
int index=tabel.getSelectedRow();
if(index != -1) {
txtkdtest.setText(tabel.getValueAt(index,0).toString());
txtnmtest.setText(tabel.getValueAt(index,1).toString());
pk=txtkdtest.getText();
btnsave.setEnabled(false);
btnedit.setEnabled(true);
btndelete.setEnabled(true);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new jenis_test().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton btncancel;
private javax.swing.JButton btncari;
private javax.swing.JButton btndelete;
private javax.swing.JButton btnedit;
private javax.swing.JButton btnexit;
private javax.swing.JButton btnsave;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTable tabel;
private javax.swing.JTextField txtkdtest;
private javax.swing.JTextField txtnmtest;
// End of variables declaration
private String pk="";
}
Langkah selanjutnya kita buat class baru untuk koneksi caranya mirip seperti membuat form baru sperti diatas.
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package kkp;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
/**
*
* @author Administrator
*/
public class koneksi {
public Connection open_a_Connection()throws SQLException
{
Connection connect = null;
try
{
Class.forName("com.mysql.jdbc.Driver");
connect=DriverManager.getConnection("jdbc:mysql://localhost/psb","root","");
return connect;
}
catch(SQLException T)
{
JOptionPane.showMessageDialog
(null,"No Connection to Database open!","ERROR MESSAGE",JOptionPane.WARNING_MESSAGE);
return null;
}
catch(Exception R)
{
JOptionPane.showMessageDialog
(null,"Could not connect to Database!","ERROR MESSAGE",JOptionPane.WARNING_MESSAGE);
return null;
}
}
/** Creates a new instance of DBConnection1 */
public koneksi() {
}
}
Yang terkahir jangan lupa untuk menambah kan sedikit coding pada file utama anda:
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new jenis_test().setVisible(true);
}
});
}
}
Demikian tutorial kali ini, bagaimana mudah bukan?, dalam hitungan beberapa menit anda sudah bisa membuat form java di Netbeans.
Have A Nice Java Coding…
Tidak ada komentar:
Posting Komentar