CRUD Java Netbeans# New,Save,Update,Delete Connect MySQL Server Xampp
( REGISTRATION PASIEN ) PROGRAM SAMPLE
Java Apache Netbeans# WITH MYSQL SERVER XAMPP
Bismillah
Pada tahap awal ini untuk membuat aplikasi Java # with MySql Server Xampp kita membutuhkan beberapa toll dan form diantara nya adalah : Form Registration - Form PatientRec.
- Apache Netbeans IDE 14 Link Download
Database dengan nama : medical .
Tabel - tabel yang digunakan dalam database medical antara lain :
- TABLE `patientregistration`
Link Download Database
Dengan Sql Query sebagai berikut : medical.sql
- TABLE `patientregistration`
----------------------------------
CREATE TABLE `patientregistration` (
`PatientID` int(10) NOT NULL,
`PatientName` varchar(25) DEFAULT NULL,
`FatherName` varchar(25) DEFAULT NULL,
`Email` varchar(30) DEFAULT NULL,
`ContactNo` varchar(15) DEFAULT NULL,
`Age` int(2) DEFAULT NULL,
`Remarks` varchar(100) DEFAULT NULL,
`Gen` varchar(10) DEFAULT NULL,
`BG` varchar(3) DEFAULT NULL,
`Address` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
Desaign Form sebagai berikut :
Form Registration Pasien
Source code Class Connect.java
package hospital;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import java.sql.*;
/**
*
* @author ASUS
*/
public class Connect {
Connection con=null;
public static Connection ConnectDB(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/medical","root","");
return con;
}catch(ClassNotFoundException | SQLException e){
JOptionPane.showMessageDialog(null, e);
return null;
}
}
}
---------------------------------------------------------------------------------
Source code Registration.java
package hospital;
import java.awt.HeadlessException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
/**
*
* @author ASUS
*/
public class Registration extends javax.swing.JFrame {
Connection con=null;
ResultSet rs=null;
PreparedStatement pst=null;
/**
* Creates new form Registration
*/
public Registration() {
initComponents();
}
private void Reset()
{
txtId.setText("");
txtName.setText("");
txtFname.setText("");
txtContact.setText("");
txtAdd.setText("");
txtAge.setText("");
txtEmail.setText("");
txtInfo.setText("");
cmbBG.setSelectedIndex(-1);
cmbGender.setSelectedIndex(-1);
btnSave.setEnabled(true);
btnUpdate.setEnabled(false);
btnDelete.setEnabled(false);
txtId.requestDefaultFocus();
}
/**
* 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.
*/
@SuppressWarnings("unchecked")
private void btnNewActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
Reset();
}
private void btnSaveActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
con=Connect.ConnectDB();
if (txtId.getText().equals("")) {
JOptionPane.showMessageDialog( this, "Please enter patient id","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (txtName.getText().equals("")) {
JOptionPane.showMessageDialog( this, "Please enter patient name","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (txtFname.getText().equals("")) {
JOptionPane.showMessageDialog( this, "Please enter Father's name","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (txtAdd.getText().equals("")) {
JOptionPane.showMessageDialog( this, "Please enter address","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (txtContact.getText().equals("")) {
JOptionPane.showMessageDialog( this, "Please enter contact no.","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (txtAge.getText().equals("")) {
JOptionPane.showMessageDialog( this, "Please enter age","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (cmbGender.getSelectedItem().equals("")) {
JOptionPane.showMessageDialog( this, "Please select gender","Error", JOptionPane.ERROR_MESSAGE);
return;
}
if (cmbBG.getSelectedItem().equals("")) {
JOptionPane.showMessageDialog( this, "Please select blood group","Error", JOptionPane.ERROR_MESSAGE);
return;
}
Statement stmt;
stmt= con.createStatement();
String sql1="Select PatientID from PatientRegistration where PatientID= '" + txtId.getText() + "'";
rs=stmt.executeQuery(sql1);
if(rs.next()){
JOptionPane.showMessageDialog( this, "Patient ID already exists","Error", JOptionPane.ERROR_MESSAGE);
txtId.setText("");
txtId.requestDefaultFocus();
return;
}
String sql= "insert into PatientRegistration(PatientID,Patientname,FatherName,Email,ContactNo,Age,Remarks,Gen,BG,Address)values('"+ txtId.getText() + "','"+ txtName.getText() + "','"+ txtFname.getText() + "','"+ txtEmail.getText() + "','"+ txtContact.getText() + "'," + txtAge.getText() + ",'"+ txtInfo.getText() + "','" + cmbGender.getSelectedItem() + "','"+ cmbBG.getSelectedItem() + "','" + txtAdd.getText() + "')";
pst=con.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(this,"Successfully Registered","Patient",JOptionPane.INFORMATION_MESSAGE);
btnSave.setEnabled(false);
}catch(HeadlessException | SQLException ex){
JOptionPane.showMessageDialog(this,ex);
}
}
private void btnUpdateActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
con=Connect.ConnectDB();
String sql= "update PatientRegistration set Patientname='"+ txtName.getText() + "',Fathername='"+ txtFname.getText() + "',Email='"+ txtEmail.getText() + "',ContactNo='"+ txtContact.getText() + "',Age=" + txtAge.getText() + ",Remarks='"+ txtInfo.getText() + "',Gen='" + cmbGender.getSelectedItem() + "',BG='"+ cmbBG.getSelectedItem() + "',Address='" + txtAdd.getText() + "' where PatientID='" + txtId.getText() + "'";
pst=con.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(this,"Successfully updated","Record",JOptionPane.INFORMATION_MESSAGE);
btnUpdate.setEnabled(false);
}catch(HeadlessException | SQLException ex){
JOptionPane.showMessageDialog(this,ex);
} // TODO add your handling code here:
}
private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
int P = JOptionPane.showConfirmDialog(null," Are you sure want to delete ?","Confirmation",JOptionPane.YES_NO_OPTION);
if (P==0)
{
con=Connect.ConnectDB();
String sql= "delete from patientregistration where PatientID = '" + txtId.getText() + "'";
pst=con.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(this,"Successfully deleted","Record",JOptionPane.INFORMATION_MESSAGE);
Reset();
}
}catch(HeadlessException | SQLException ex){
JOptionPane.showMessageDialog(this,ex);
} // TODO add your handling code here:
}
private void btnGetDataActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
this.hide();
PatientRec frm=new PatientRec();
frm.setVisible(true); // TODO add your handling code here:
}
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
MenuMain ob1 =new MenuMain();
ob1.setVisible(true);
}
---------------------------------------------------------------------------------
Pada Crud Java # Registration Pasien Untuk Form (JFrame From) : Form Registration Pasien semua Pallete Swing Control yang digunakan seperti : TextBox dan Button di Set propertis nya pada Code atau Customize Code di set menjadi Public dengan MengKlik Kanan Pada TextBox atau Button tersebut seperti gambar berikut :
Gambar Clik Kanan Pada TextBox
Gambar Clik Kanan Pada Button
Source code PatientRec.java
package hospital;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import net.proteanit.sql.DbUtils;
/**
*
* @author ASUS
*/
public class PatientRec extends javax.swing.JFrame {
Connection con=null;
ResultSet rs=null;
PreparedStatement pst=null;
/**
* Creates new form PatientRec
*/
public PatientRec() {
initComponents();
con= Connect.ConnectDB();
Get_Data();
}
private void Get_Data(){
String sql="select PatientID as 'Patient ID', PatientName as 'Patient Name',FatherName as 'Father Name',Address,ContactNo as 'Contact No',Email as 'Email ID',Age,Gen as 'Gender',BG as 'Blood Group',Remarks from Patientregistration";
try{
pst=con.prepareStatement(sql);
rs= pst.executeQuery();
jTable1.setModel(DbUtils.resultSetToTableModel(rs));
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
/**
* 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.
*/
@SuppressWarnings("unchecked")
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
try{
con=Connect.ConnectDB();
int row= jTable1.getSelectedRow();
String table_click= jTable1.getModel().getValueAt(row, 0).toString();
String sql= "select * from PatientRegistration where PatientID = '" + table_click + "'";
pst=con.prepareStatement(sql);
rs= pst.executeQuery();
if(rs.next()){
this.hide();
Registration frm = new Registration();
frm.setVisible(true);
String add1=rs.getString("PatientID");
frm.txtId.setText(add1);
String add2=rs.getString("Patientname");
frm.txtName.setText(add2);
String add3=rs.getString("Fathername");
frm.txtFname.setText(add3);
String add5=rs.getString("Email");
frm.txtEmail.setText(add5);
int add6 = rs.getInt("Age");
String add= Integer.toString(add6);
frm.txtAge.setText(add);
String add7=rs.getString("Remarks");
frm.txtInfo.setText(add7);
String add9=rs.getString("BG");
frm.cmbBG.setSelectedItem(add9);
String add11=rs.getString("Gen");
frm.cmbGender.setSelectedItem(add11);
String add15=rs.getString("Address");
frm.txtAdd.setText(add15);
String add16=rs.getString("ContactNo");
frm.txtContact.setText(add16);
frm.btnUpdate.setEnabled(true);
frm.btnDelete.setEnabled(true);
frm.btnSave.setEnabled(false);
}
}catch(Exception ex){
JOptionPane.showMessageDialog(this,ex);
}
}
---------------------------------------------------------------------------------
Tampilan Akhir Sebagai berikut :
Form Registration Pasien Running
Form PatientRec Running Connect DataBase setelah Clik Tombol GETDATA Pada Registration Pasien
Form Registration Pasien Running Menampilkan Data Setelah ClikMouse Pada Tabel Form PatientRec
Alhamdulillah
semoga bermanfaat
selamat Mencoba.
Komentar
Posting Komentar