โปรแกรมโรงพยาบาล HosJava บนฐานข้อมูล MariaDB (โปรแกรมฟอร์มยักษ์) มากมายหลายห้องตรวจ

HosJava.java
=============================
package main;

import java.awt.event.ActionEvent;
import java.text.ParseException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;

public class HosJava extends javax.swing.JFrame {

JDesktopPane jDesktopPane1;
JMenuItem FormAdd;
JMenuBar MenuBar;
JMenu MenuFile;
JMenuItem MenuRep;
JMenu MenuReport;

public HosJava() {
initComponents();
//this.setLocationRelativeTo(null);//center
this.setExtendedState(HosJava.MAXIMIZED_BOTH);//Maximized
setTitle("โปรแกรม Hos Java V.2015 ( Java Open Source 7.3.1 :atabase MariaDB )");
}

@SuppressWarnings("unchecked")

private void initComponents() {

jDesktopPane1 = new javax.swing.JDesktopPane();
MenuBar = new javax.swing.JMenuBar();
MenuFile = new javax.swing.JMenu();
FormAdd = new javax.swing.JMenuItem();
MenuReport = new javax.swing.JMenu();
MenuRep = new javax.swing.JMenuItem();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

//============Menu File=========================================
MenuFile.setText("แฟ้ม");

FormAdd.setText("เพิ่มรายการหลัก");
FormAdd.addActionListener(new java.awt.event.ActionListener() {
@Override
public void actionPerformed(java.awt.event.ActionEvent evt) {
try {
FormAddActionPerformed(evt);
} catch (ParseException ex) {
Logger.getLogger(HosJava.class.getName()).log(Level.SEVERE, null, ex);
}
}
});
MenuFile.add(FormAdd);

MenuBar.add(MenuFile);
//==========Menu Report======================================
MenuReport.setText("รายงาน");

MenuRep.setText("รายงานผล");
MenuRep.addActionListener(new java.awt.event.ActionListener() {
@Override
public void actionPerformed(java.awt.event.ActionEvent evt) {
MenuRepActionPerformed(evt);
}
});
MenuReport.add(MenuRep);

MenuBar.add(MenuReport);
//=========================================================

setJMenuBar(MenuBar);

pack();
}

private void FormAddActionPerformed(ActionEvent evt) throws ParseException {
FormAdd f1 = new FormAdd("เพิ่มรายการหลัก");
jDesktopPane1.add(f1);
f1.show();
}

private void MenuRepActionPerformed(ActionEvent evt) {
FormReport f2 = new FormReport("รายงานผล");
jDesktopPane1.add(f2);
f2.show();
}

public static void main(String args[]) {

java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
new HosJava().setVisible(true);
}
});
}
}

 

FormAdd.java
========================
package main;

import com.toedter.calendar.JDateChooser;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.text.ParseException;
import java.util.Date;
import java.util.Locale;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

public class FormAdd extends javax.swing.JInternalFrame{

final JTextField txtCodePK,txtCodeID,txtFirstName,txtLastName,txtIDCard;
final JTextField txtBanID,txtMoo,txtDiag,txtSearch,txtTambol,txtDistrict;
final JTextField txtIntolerance;
final JComboBox cmbSexFK,cmbTitleFK,cmbReport,cmbProvince;
final JButton btnGenID,btnAdd,btnEdit,btnDelete,btnRefresh,btnSearch;
final JDateChooser txtBirthDate,txtInspectionDate,txtDoctorDate;

FormAdd(String เพิ่มรายการหลัก) throws ParseException{
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame = new JFrame("เพิ่มข้อมูล / แแก้ไขข้อมูล / ลบข้อมูล / ค้นหาข้อมูล");

Container contentPane = frame.getContentPane();
SpringLayout layout = new SpringLayout();
contentPane.setLayout(layout);

//==========JLabel=========================
JLabel lblCodePK = new JLabel("เลข HN : ");
JLabel lblSexFK = new JLabel("เพศ : ");
JLabel lblFirstName = new JLabel("ชื่อ : ");
JLabel lblLastName = new JLabel("สกุล : ");
JLabel lblIDCard = new JLabel("เลขบัตรประชาชน : ");
JLabel lblBirthDate = new JLabel("เดือน วัน,ปี เกิด(คศ.) : ");
JLabel lblBanID = new JLabel("บ้านเลขที่ :");
JLabel lblMoo = new JLabel("หมู่ที่ :");
JLabel lblTambol = new JLabel("ตำบล :");
JLabel lblDistrict = new JLabel("อำเภอ :");
JLabel lblProvince = new JLabel("จังหวัด :");
JLabel lblDiag = new JLabel("อาการของโรค :");
JLabel lblIntolerance = new JLabel("แพ้ยา :");
JLabel lblInspectionDate = new JLabel("เดือน วัน,ปี(คศ.)ที่มาตรวจ :");
JLabel lblReport = new JLabel("รายงาน :");
JLabel lblDoctorDate = new JLabel("วันที่แพทย์นัด :");
JLabel lblSearch = new JLabel("ค้นหาลำดับที่ :");

//==========JTextField=====================
txtCodePK = new JTextField("txtCodePK", 10);//txtCodePK.setBackground(Color.pink);
txtCodeID = new JTextField("txtCodeID", 9);//txtCodeID.setBackground(Color.pink);
txtFirstName = new JTextField("txtFirstName", 22);
txtLastName = new JTextField("txtLastName", 22);
txtIDCard = new JTextField("txtIDCard", 22);
//================txtBirthDate======================
Locale locale = new Locale ( "en", "US" );//new Locale ( "th", "TH" );
txtBirthDate = new JDateChooser ( );
txtBirthDate.setPreferredSize(new Dimension(216, 20));
txtBirthDate.setLocale ( locale );
Date date = new Date();
txtBirthDate.setDate(date);
contentPane.add ( txtBirthDate );
//==================================================

txtBanID = new JTextField("txtBanID",10);
txtMoo = new JTextField("txtMoo",10);
txtTambol = new JTextField("txtTambol",22);
txtDistrict = new JTextField("txtDistrict",22);
txtDiag = new JTextField("txtDiag",22);
txtIntolerance = new JTextField("txtIntolerance",22);
//================txtInspectionDate=================
txtInspectionDate = new JDateChooser ( );
txtInspectionDate.setPreferredSize(new Dimension(216, 20));
txtInspectionDate.setLocale ( locale );
txtInspectionDate.setDate(date);
contentPane.add ( txtInspectionDate );
//==================================================

//================txtDoctorDate=====================
txtDoctorDate = new JDateChooser ( );
txtDoctorDate.setPreferredSize(new Dimension(216, 20));
txtDoctorDate.setLocale ( locale );
txtDoctorDate.setDate(date);
contentPane.add ( txtDoctorDate );
//==================================================
txtSearch = new JTextField("txtSearch",10);txtSearch.setBackground(Color.yellow);


//==========JButton=========================
btnGenID = new JButton("GenID");
btnGenID.setPreferredSize(new Dimension(90, 20));
btnAdd = new JButton("เพิ่มข้อมูล");
btnAdd.setPreferredSize(new Dimension(110, 20));
btnEdit = new JButton("แก้ไขข้อมูล");
btnEdit.setPreferredSize(new Dimension(110, 20));
btnDelete = new JButton("ลบข้อมูล");
btnDelete.setPreferredSize(new Dimension(110, 20));
btnRefresh = new JButton("รีเฟรซข้อมูล");
btnRefresh.setPreferredSize(new Dimension(110, 20));
btnSearch = new JButton("ค้นหา");
btnSearch.setPreferredSize(new Dimension(110, 20));

//=======ComboBox ==================================================
String SexFK[] = {"ชาย","หญิง"};
cmbSexFK = new JComboBox(SexFK);
cmbSexFK.setPreferredSize(new Dimension(115, 20));

String TitleFK[] = {"นาย","นาง","นางสาว","เด็กชาย","เด็กหญิง","พระ","แม่ชี"};
cmbTitleFK = new JComboBox(TitleFK);
cmbTitleFK.setPreferredSize(new Dimension(95, 20));

String Report[] = {"รับรักษา","กลับบ้าน"};
cmbReport = new JComboBox(Report);
cmbReport.setPreferredSize(new Dimension(95, 20));

String Province[] = {"กรุงเทพมหานคร","กระบี่","กาญจนบุรี","กาฬสินธุ์",
"กำแพงเพชร","ขอนแก่น","จันทบุรี","ฉะเชิงเทรา","ชลบุรี","ชัยนาท","ชัยภูมิ",
"ชุมพร","เชียงราย","เชียงใหม่","ตรัง","ตราด","ตาก","นครนายก","นครปฐม",
"นครพนม","นครราชสีมา","นครศรีธรรมราช","นครสวรรค์","นนทบุรี","นราธิวาส",
"น่าน","บึงกาฬ","บุรีรัมย์","ปทุมธานี","ประจวบคีรีขันธ์","ปราจีนบุรี","ปัตตานี",
"พระนครศรีอยุธยา","พะเยา","พังงา","พัทลุง","พิจิตร","พิษณุโลก","เพชรบุรี",
"เพชรบูรณ์","แพร่","ภูเก็ต","มหาสารคาม","มุกดาหาร","แม่ฮ่องสอน","ยะลา",
"ยโสธร","ระนอง","ระยอง","ราชบุรี","ร้อยเอ็ด","ลพบุรี","ลำปาง","ลำพูน",
"เลย","ศรีสะเกษ","สกลนคร","สงขลา","สตูล","สมุทรปราการ","สมุทรสงคราม",
"สมุทรสาคร","สระบุรี","สระแก้ว","สิงห์บุรี","สุพรรณบุรี","สุราษฎร์ธานี","สุรินทร์",
"สุโขทัย","หนองคาย","หนองบัวลำภู","อำนาจเจริญ","อุดรธานี","อุตรดิตถ์",
"อุทัยธานี","อ่างทอง","อุบลราชธานี"};
cmbProvince = new JComboBox(Province);
cmbProvince.setPreferredSize(new Dimension(140, 20));



//=====add lbl==============================
contentPane.add(lblCodePK);
contentPane.add(lblSexFK);
contentPane.add(lblFirstName);
contentPane.add(lblLastName);
contentPane.add(lblIDCard);
contentPane.add(lblBirthDate);
contentPane.add(lblBanID);
contentPane.add(lblMoo);
contentPane.add(lblTambol);
contentPane.add(lblDistrict);
contentPane.add(lblProvince);
contentPane.add(lblDiag);
contentPane.add(lblIntolerance);
contentPane.add(lblInspectionDate);
contentPane.add(lblReport);
contentPane.add(lblDoctorDate);
contentPane.add(lblSearch);



//=====add txt==============================
contentPane.add(txtCodePK);
contentPane.add(txtCodeID);
contentPane.add(txtFirstName);
contentPane.add(txtLastName);
contentPane.add(txtIDCard);
contentPane.add(txtBanID);
contentPane.add(txtMoo);
contentPane.add(txtTambol);
contentPane.add(txtDistrict);
contentPane.add(txtDiag);
contentPane.add(txtIntolerance);
contentPane.add(txtInspectionDate);
contentPane.add(txtDoctorDate);
contentPane.add(txtSearch);


//======add button==========================
contentPane.add(btnGenID);
contentPane.add(btnAdd);
contentPane.add(btnEdit);
contentPane.add(btnDelete);
contentPane.add(btnRefresh);
contentPane.add(btnSearch);

//======add combobox========================
contentPane.add(cmbSexFK);
contentPane.add(cmbTitleFK);
contentPane.add(cmbReport);
contentPane.add(cmbProvince);

//===================lblCodePK===========================================
layout.putConstraint(SpringLayout.WEST, lblCodePK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSex==============================================
layout.putConstraint(SpringLayout.WEST, lblSexFK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSexFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblFirstName=========================================
layout.putConstraint(SpringLayout.WEST, lblFirstName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblLastName=========================================
layout.putConstraint(SpringLayout.WEST, lblLastName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIDCard===========================================
layout.putConstraint(SpringLayout.WEST, lblIDCard, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, lblBirthDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBanID============================================
layout.putConstraint(SpringLayout.WEST, lblBanID, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblMoo==============================================
layout.putConstraint(SpringLayout.WEST, lblMoo, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblTambol===========================================
layout.putConstraint(SpringLayout.WEST, lblTambol, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDistrict=========================================
layout.putConstraint(SpringLayout.WEST, lblDistrict, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblProvince=========================================
layout.putConstraint(SpringLayout.WEST, lblProvince, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDiag=============================================
layout.putConstraint(SpringLayout.WEST, lblDiag, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIntolerance======================================
layout.putConstraint(SpringLayout.WEST, lblIntolerance, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblInspectionDate===================================
layout.putConstraint(SpringLayout.WEST, lblInspectionDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblReport==========================================
layout.putConstraint(SpringLayout.WEST, lblReport, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblReport, 355, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDoctorDate=======================================
layout.putConstraint(SpringLayout.WEST, lblDoctorDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSearch==========================================
layout.putConstraint(SpringLayout.WEST, lblSearch, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================





//==================txtCodePK============================================
layout.putConstraint(SpringLayout.WEST, txtCodePK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtCodeID============================================
layout.putConstraint(SpringLayout.WEST, txtCodeID, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodeID, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbSexFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbSexFK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbSexFK, 30,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbTitleFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbTitleFK, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbTitleFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtFirstName==========================================
layout.putConstraint(SpringLayout.WEST, txtFirstName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtLastName==========================================
layout.putConstraint(SpringLayout.WEST, txtLastName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIDCard============================================
layout.putConstraint(SpringLayout.WEST, txtIDCard, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, txtBirthDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBanID=============================================
layout.putConstraint(SpringLayout.WEST, txtBanID, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtMoo===============================================
layout.putConstraint(SpringLayout.WEST, txtMoo, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtTambol============================================
layout.putConstraint(SpringLayout.WEST, txtTambol, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDistrict==========================================
layout.putConstraint(SpringLayout.WEST, txtDistrict, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbProvince==========================================
layout.putConstraint(SpringLayout.WEST, cmbProvince, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDiag=============================================
layout.putConstraint(SpringLayout.WEST, txtDiag, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIntolerance=======================================
layout.putConstraint(SpringLayout.WEST, txtIntolerance, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtInspectionDate====================================
layout.putConstraint(SpringLayout.WEST, txtInspectionDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbReport===========================================
layout.putConstraint(SpringLayout.WEST, cmbReport, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbReport, 355,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDoctorDate========================================
layout.putConstraint(SpringLayout.WEST, txtDoctorDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================txtSearch==========================================
layout.putConstraint(SpringLayout.WEST, txtSearch, 160, SpringLayout.WEST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================







//===================btnGenID============================================
layout.putConstraint(SpringLayout.WEST, btnGenID, 460, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnGenID, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnAdd============================================
layout.putConstraint(SpringLayout.WEST, btnAdd, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnAdd, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnEdit============================================
layout.putConstraint(SpringLayout.WEST, btnEdit, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnEdit, 35, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnDelte============================================
layout.putConstraint(SpringLayout.WEST, btnDelete, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnDelete, 65, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnRefresh============================================
layout.putConstraint(SpringLayout.WEST, btnRefresh, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, 95, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnSeach============================================
layout.putConstraint(SpringLayout.WEST, btnSearch, 305, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, btnSearch, 405, SpringLayout.NORTH,contentPane);
//=======================================================================



//Display the window.

frame.pack();
frame.setVisible(true);
frame.setSize(690,480);//800,645
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}
}

 

FormReport.java
=========================
package main;

import java.awt.Container;
import javax.swing.JFrame;
import javax.swing.SpringLayout;


public class FormReport extends javax.swing.JInternalFrame{

public FormReport(String รางานผล) {
JFrame.setDefaultLookAndFeelDecorated(true);

//Create and set up the window.
//JFrame frame = new JFrame("เพิ่มรายการหลัก");
JFrame frame = new JFrame("รายงานผล");
//frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//Set up the content pane.
Container contentPane = frame.getContentPane();
SpringLayout layout = new SpringLayout();
contentPane.setLayout(layout);

//==========JLabel=========================



//Display the window.

frame.pack();
frame.setVisible(true);
frame.setSize(690,500);//800,645
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}
}

 

การสร้างฐานข้อมูลบน MariaDB
==================
dbhosjava

 

ตาราง tblhosjava
=========================
CREATE TABLE `tblhosjava` (
`CodePK` INT(12) NOT NULL,
`CodeID` VARCHAR(12) NOT NULL,
`SexFK` VARCHAR(5) NULL DEFAULT NULL,
`TitleFK` VARCHAR(15) NULL DEFAULT NULL,
`FirstName` VARCHAR(30) NULL DEFAULT NULL,
`LastName` VARCHAR(30) NULL DEFAULT NULL,
`IDCard` VARCHAR(17) NULL DEFAULT NULL,
`BirthDate` DATE NULL DEFAULT NULL,
`BanID` VARCHAR(10) NULL DEFAULT NULL,
`Moo` VARCHAR(3) NULL DEFAULT NULL,
`Tambol` VARCHAR(25) NULL DEFAULT NULL,
`District` VARCHAR(25) NULL DEFAULT NULL,
`Province` VARCHAR(25) NULL DEFAULT NULL,
`Diag` VARCHAR(30) NULL DEFAULT NULL,
`Intolerance` VARCHAR(30) NULL DEFAULT NULL,
`InspectionDate` DATE NULL DEFAULT NULL,
`Report` VARCHAR(10) NULL DEFAULT NULL,
`DoctorDate` DATE NULL DEFAULT NULL,
PRIMARY KEY (`CodePK`)
)
COLLATE='tis620_thai_ci'
ENGINE=InnoDB
;

 

เพิ่มคำสั่งปุ่ม Refresh กับปุ่ม GenID
======================
package main;

import com.toedter.calendar.JDateChooser;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.Date;
import java.util.Locale;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

public class FormAdd extends javax.swing.JInternalFrame{

final JTextField txtCodePK,txtCodeID,txtFirstName,txtLastName,txtIDCard;
final JTextField txtBanID,txtMoo,txtDiag,txtSearch,txtTambol,txtDistrict;
final JTextField txtIntolerance;
final JComboBox cmbSexFK,cmbTitleFK,cmbReport,cmbProvince;
final JButton btnGenID,btnAdd,btnEdit,btnDelete,btnRefresh,btnSearch;
final JDateChooser txtBirthDate,txtInspectionDate,txtDoctorDate;
Connection connect = null;
PreparedStatement pstmt = null;
ResultSet rs = null;

FormAdd(String เพิ่มรายการหลัก) throws ParseException{
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame = new JFrame("เพิ่มข้อมูล / แแก้ไขข้อมูล / ลบข้อมูล / ค้นหาข้อมูล");

Container contentPane = frame.getContentPane();
SpringLayout layout = new SpringLayout();
contentPane.setLayout(layout);

//==========JLabel=========================
JLabel lblCodePK = new JLabel("เลข HN : ");
JLabel lblSexFK = new JLabel("เพศ : ");
JLabel lblFirstName = new JLabel("ชื่อ : ");
JLabel lblLastName = new JLabel("สกุล : ");
JLabel lblIDCard = new JLabel("เลขบัตรประชาชน : ");
JLabel lblBirthDate = new JLabel("เดือน วัน,ปี เกิด(คศ.) : ");
JLabel lblBanID = new JLabel("บ้านเลขที่ :");
JLabel lblMoo = new JLabel("หมู่ที่ :");
JLabel lblTambol = new JLabel("ตำบล :");
JLabel lblDistrict = new JLabel("อำเภอ :");
JLabel lblProvince = new JLabel("จังหวัด :");
JLabel lblDiag = new JLabel("อาการของโรค :");
JLabel lblIntolerance = new JLabel("แพ้ยา :");
JLabel lblInspectionDate = new JLabel("เดือน วัน,ปี(คศ.)ที่มาตรวจ :");
JLabel lblReport = new JLabel("รายงาน :");
JLabel lblDoctorDate = new JLabel("วันที่แพทย์นัด :");
JLabel lblSearch = new JLabel("ค้นหาลำดับที่ :");

//==========JTextField=====================
txtCodePK = new JTextField("txtCodePK", 10);//txtCodePK.setBackground(Color.pink);
txtCodeID = new JTextField("txtCodeID", 9);//txtCodeID.setBackground(Color.pink);
txtFirstName = new JTextField("txtFirstName", 22);
txtLastName = new JTextField("txtLastName", 22);
txtIDCard = new JTextField("txtIDCard", 22);
//================txtBirthDate======================
Locale locale = new Locale ( "en", "US" );//new Locale ( "th", "TH" );
txtBirthDate = new JDateChooser ( );
txtBirthDate.setPreferredSize(new Dimension(216, 20));
txtBirthDate.setLocale ( locale );
Date date = new Date();
txtBirthDate.setDate(date);
contentPane.add ( txtBirthDate );
//==================================================

txtBanID = new JTextField("txtBanID",10);
txtMoo = new JTextField("txtMoo",10);
txtTambol = new JTextField("txtTambol",22);
txtDistrict = new JTextField("txtDistrict",22);
txtDiag = new JTextField("txtDiag",22);
txtIntolerance = new JTextField("txtIntolerance",22);
//================txtInspectionDate=================
txtInspectionDate = new JDateChooser ( );
txtInspectionDate.setPreferredSize(new Dimension(216, 20));
txtInspectionDate.setLocale ( locale );
txtInspectionDate.setDate(date);
contentPane.add ( txtInspectionDate );
//==================================================

//================txtDoctorDate=====================
txtDoctorDate = new JDateChooser ( );
txtDoctorDate.setPreferredSize(new Dimension(216, 20));
txtDoctorDate.setLocale ( locale );
txtDoctorDate.setDate(date);
contentPane.add ( txtDoctorDate );
//==================================================
txtSearch = new JTextField("txtSearch",10);txtSearch.setBackground(Color.yellow);


//==========JButton=========================
btnGenID = new JButton("GenID");
btnGenID.setPreferredSize(new Dimension(90, 20));
btnAdd = new JButton("เพิ่มข้อมูล");
btnAdd.setPreferredSize(new Dimension(110, 20));
btnEdit = new JButton("แก้ไขข้อมูล");
btnEdit.setPreferredSize(new Dimension(110, 20));
btnDelete = new JButton("ลบข้อมูล");
btnDelete.setPreferredSize(new Dimension(110, 20));
btnRefresh = new JButton("รีเฟรซข้อมูล");
btnRefresh.setPreferredSize(new Dimension(110, 20));
btnSearch = new JButton("ค้นหา");
btnSearch.setPreferredSize(new Dimension(110, 20));

//=======ComboBox ==================================================
String SexFK[] = {"ชาย","หญิง"};
cmbSexFK = new JComboBox(SexFK);
cmbSexFK.setPreferredSize(new Dimension(115, 20));

String TitleFK[] = {"นาย","นาง","นางสาว","เด็กชาย","เด็กหญิง","พระ","แม่ชี"};
cmbTitleFK = new JComboBox(TitleFK);
cmbTitleFK.setPreferredSize(new Dimension(95, 20));

String Report[] = {"รับรักษา","กลับบ้าน"};
cmbReport = new JComboBox(Report);
cmbReport.setPreferredSize(new Dimension(95, 20));

String Province[] = {"กรุงเทพมหานคร","กระบี่","กาญจนบุรี","กาฬสินธุ์",
"กำแพงเพชร","ขอนแก่น","จันทบุรี","ฉะเชิงเทรา","ชลบุรี","ชัยนาท","ชัยภูมิ",
"ชุมพร","เชียงราย","เชียงใหม่","ตรัง","ตราด","ตาก","นครนายก","นครปฐม",
"นครพนม","นครราชสีมา","นครศรีธรรมราช","นครสวรรค์","นนทบุรี","นราธิวาส",
"น่าน","บึงกาฬ","บุรีรัมย์","ปทุมธานี","ประจวบคีรีขันธ์","ปราจีนบุรี","ปัตตานี",
"พระนครศรีอยุธยา","พะเยา","พังงา","พัทลุง","พิจิตร","พิษณุโลก","เพชรบุรี",
"เพชรบูรณ์","แพร่","ภูเก็ต","มหาสารคาม","มุกดาหาร","แม่ฮ่องสอน","ยะลา",
"ยโสธร","ระนอง","ระยอง","ราชบุรี","ร้อยเอ็ด","ลพบุรี","ลำปาง","ลำพูน",
"เลย","ศรีสะเกษ","สกลนคร","สงขลา","สตูล","สมุทรปราการ","สมุทรสงคราม",
"สมุทรสาคร","สระบุรี","สระแก้ว","สิงห์บุรี","สุพรรณบุรี","สุราษฎร์ธานี","สุรินทร์",
"สุโขทัย","หนองคาย","หนองบัวลำภู","อำนาจเจริญ","อุดรธานี","อุตรดิตถ์",
"อุทัยธานี","อ่างทอง","อุบลราชธานี"};
cmbProvince = new JComboBox(Province);
cmbProvince.setPreferredSize(new Dimension(140, 20));



//=====add lbl==============================
contentPane.add(lblCodePK);
contentPane.add(lblSexFK);
contentPane.add(lblFirstName);
contentPane.add(lblLastName);
contentPane.add(lblIDCard);
contentPane.add(lblBirthDate);
contentPane.add(lblBanID);
contentPane.add(lblMoo);
contentPane.add(lblTambol);
contentPane.add(lblDistrict);
contentPane.add(lblProvince);
contentPane.add(lblDiag);
contentPane.add(lblIntolerance);
contentPane.add(lblInspectionDate);
contentPane.add(lblReport);
contentPane.add(lblDoctorDate);
contentPane.add(lblSearch);



//=====add txt==============================
contentPane.add(txtCodePK);
contentPane.add(txtCodeID);
contentPane.add(txtFirstName);
contentPane.add(txtLastName);
contentPane.add(txtIDCard);
contentPane.add(txtBanID);
contentPane.add(txtMoo);
contentPane.add(txtTambol);
contentPane.add(txtDistrict);
contentPane.add(txtDiag);
contentPane.add(txtIntolerance);
contentPane.add(txtInspectionDate);
contentPane.add(txtDoctorDate);
contentPane.add(txtSearch);


//======add button==========================
contentPane.add(btnGenID);
contentPane.add(btnAdd);
contentPane.add(btnEdit);
contentPane.add(btnDelete);
contentPane.add(btnRefresh);
contentPane.add(btnSearch);

//======add combobox========================
contentPane.add(cmbSexFK);
contentPane.add(cmbTitleFK);
contentPane.add(cmbReport);
contentPane.add(cmbProvince);

//===================lblCodePK===========================================
layout.putConstraint(SpringLayout.WEST, lblCodePK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSex==============================================
layout.putConstraint(SpringLayout.WEST, lblSexFK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSexFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblFirstName=========================================
layout.putConstraint(SpringLayout.WEST, lblFirstName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblLastName=========================================
layout.putConstraint(SpringLayout.WEST, lblLastName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIDCard===========================================
layout.putConstraint(SpringLayout.WEST, lblIDCard, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, lblBirthDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBanID============================================
layout.putConstraint(SpringLayout.WEST, lblBanID, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblMoo==============================================
layout.putConstraint(SpringLayout.WEST, lblMoo, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblTambol===========================================
layout.putConstraint(SpringLayout.WEST, lblTambol, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDistrict=========================================
layout.putConstraint(SpringLayout.WEST, lblDistrict, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblProvince=========================================
layout.putConstraint(SpringLayout.WEST, lblProvince, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDiag=============================================
layout.putConstraint(SpringLayout.WEST, lblDiag, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIntolerance======================================
layout.putConstraint(SpringLayout.WEST, lblIntolerance, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblInspectionDate===================================
layout.putConstraint(SpringLayout.WEST, lblInspectionDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblReport==========================================
layout.putConstraint(SpringLayout.WEST, lblReport, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblReport, 355, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDoctorDate=======================================
layout.putConstraint(SpringLayout.WEST, lblDoctorDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSearch==========================================
layout.putConstraint(SpringLayout.WEST, lblSearch, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================





//==================txtCodePK============================================
layout.putConstraint(SpringLayout.WEST, txtCodePK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtCodeID============================================
layout.putConstraint(SpringLayout.WEST, txtCodeID, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodeID, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbSexFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbSexFK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbSexFK, 30,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbTitleFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbTitleFK, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbTitleFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtFirstName==========================================
layout.putConstraint(SpringLayout.WEST, txtFirstName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtLastName==========================================
layout.putConstraint(SpringLayout.WEST, txtLastName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIDCard============================================
layout.putConstraint(SpringLayout.WEST, txtIDCard, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, txtBirthDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBanID=============================================
layout.putConstraint(SpringLayout.WEST, txtBanID, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtMoo===============================================
layout.putConstraint(SpringLayout.WEST, txtMoo, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtTambol============================================
layout.putConstraint(SpringLayout.WEST, txtTambol, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDistrict==========================================
layout.putConstraint(SpringLayout.WEST, txtDistrict, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbProvince==========================================
layout.putConstraint(SpringLayout.WEST, cmbProvince, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDiag=============================================
layout.putConstraint(SpringLayout.WEST, txtDiag, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIntolerance=======================================
layout.putConstraint(SpringLayout.WEST, txtIntolerance, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtInspectionDate====================================
layout.putConstraint(SpringLayout.WEST, txtInspectionDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbReport===========================================
layout.putConstraint(SpringLayout.WEST, cmbReport, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbReport, 355,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDoctorDate========================================
layout.putConstraint(SpringLayout.WEST, txtDoctorDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================txtSearch==========================================
layout.putConstraint(SpringLayout.WEST, txtSearch, 160, SpringLayout.WEST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================







//===================btnGenID============================================
layout.putConstraint(SpringLayout.WEST, btnGenID, 460, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnGenID, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnAdd============================================
layout.putConstraint(SpringLayout.WEST, btnAdd, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnAdd, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnEdit============================================
layout.putConstraint(SpringLayout.WEST, btnEdit, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnEdit, 35, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnDelte============================================
layout.putConstraint(SpringLayout.WEST, btnDelete, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnDelete, 65, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnRefresh============================================
layout.putConstraint(SpringLayout.WEST, btnRefresh, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, 95, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnSeach============================================
layout.putConstraint(SpringLayout.WEST, btnSearch, 305, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, btnSearch, 405, SpringLayout.NORTH,contentPane);
//=======================================================================

//=========Button Command=================================
btnRefresh.addActionListener(new ButtonListener());
btnGenID.addActionListener(new ButtonListener());
//=========Clear TextBox==================================
txtCodePK.setText("");
txtCodeID.setText("");
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText("");
txtLastName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
txtMoo.setText("");
txtTambol.setText("");
txtDistrict.setText("");
cmbProvince.setSelectedItem(null);
txtDiag.setText("");
txtIntolerance.setText("");
cmbReport.setSelectedItem(null);
txtSearch.setText("");
//========================================================

//Display the window.

frame.pack();
frame.setVisible(true);
frame.setSize(690,480);//800,645
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}

private class ButtonListener implements ActionListener
{
@Override
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========btnRefresh====================
if(source == btnRefresh){
txtCodePK.setText("");
txtCodeID.setText("");
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText("");
txtLastName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
txtMoo.setText("");
txtTambol.setText("");
txtDistrict.setText("");
cmbProvince.setSelectedItem(null);
txtDiag.setText("");
txtIntolerance.setText("");
cmbReport.setSelectedItem(null);
txtSearch.setText("");
//==========เปิดปุ่มและ textBox================
btnGenID.setEnabled(true);
btnAdd.setEnabled(true);
btnEdit.setEnabled(true);
btnDelete.setEnabled(true);
btnSearch.setEnabled(true);
txtSearch.setEnabled(true);
txtCodePK.setEnabled(true);
txtCodeID.setEnabled(true);
//=========================================
}
//===========btnGenID===================================
if(source==btnGenID){
try{
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");
//JOptionPane.showMessageDialog(null,"Connect Database Successfully","รายงานสถานะ",
// JOptionPane.INFORMATION_MESSAGE);
String sql = "SELECT max(CodePK) FROM tblhosjava";//ใช้กับ MySQL
//String sql = "SELECT nvl(max(CodePK),0) FROM tblHelp"; //ใช้กับ MS Access 2003
pstmt = connect.prepareStatement(sql);
rs = pstmt.executeQuery();

if (rs.next()) {

int maxID = rs.getInt(1)+1;

txtCodePK.setText(String.valueOf(maxID));
//txtCodePK.setForeground(Color.red);
String paded = String.format("%10s",String.valueOf(maxID)).replace(' ', '0');
//txtCodeID.setText(paded);
txtCodeID.setText("HN"+paded);
//==========ปิดปุ่มและ textBox====================
btnGenID.setEnabled(false);
btnAdd.setEnabled(true);
btnEdit.setEnabled(false);
btnDelete.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
//=============================================
}
connect.close();
rs.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null,"Error GenID Auto !\n"+ex.getMessage());
}
}
}
}
}

 

โรงพยาบาล มีแผนก
1.OPD
2.IPD
3.X-Ray
4.Ortho
5.Med
6.Sur
7.Nursary
8.Blood Bank

ตอนนี้โรงพยาบาลยังใช้ Windows OS อยู่ก็คิดว่าต่อไปในอนาคต คงหันมาใช้ Ubuntu + Java เป็นแน่แท้แต่จะมีโปรแกรมออกมาสู่ตลาดหรือไม่ ...HosJava

 

แผนก OPD ห้องผู้ป่วยนอก

 

HosJava.java

======================
package main;

import java.awt.event.ActionEvent;
import java.text.ParseException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;

public class HosJava extends javax.swing.JFrame {

JDesktopPane jDesktopPane1;
JMenuItem FormOPD;
JMenuBar MenuBar;
JMenu MenuFile;
JMenuItem MenuRep;
JMenu MenuReport;
JMenuItem FormIPD;

public HosJava() {
initComponents();
//this.setLocationRelativeTo(null);//center
this.setExtendedState(HosJava.MAXIMIZED_BOTH);//Maximized
setTitle("โปรแกรม HosJava V.2015 ( Java Open Source :atabase MariaDB )");
}

@SuppressWarnings("unchecked")

private void initComponents() {

jDesktopPane1 = new javax.swing.JDesktopPane();
MenuBar = new javax.swing.JMenuBar();
MenuFile = new javax.swing.JMenu();
FormOPD = new javax.swing.JMenuItem();
MenuReport = new javax.swing.JMenu();
MenuRep = new javax.swing.JMenuItem();
FormIPD = new javax.swing.JMenuItem();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

//============Menu OPD=========================================
MenuFile.setText("แฟ้ม");

FormOPD.setText("ห้องผู้ป่วยนอก");
FormOPD.addActionListener(new java.awt.event.ActionListener() {
@Override
public void actionPerformed(java.awt.event.ActionEvent evt) {
try {
FormOPDActionPerformed(evt);
} catch (ParseException ex) {
Logger.getLogger(HosJava.class.getName()).log(Level.SEVERE, null, ex);
}
}
});
MenuFile.add(FormOPD);

MenuBar.add(MenuFile);
//==========Menu IPD=========================================
FormIPD.setLabel("ห้องผู้ป่วยใน");

FormIPD.addActionListener(new java.awt.event.ActionListener() {

@Override
public void actionPerformed(java.awt.event.ActionEvent evt) {
try {
FormIPDActionPerformed(evt);
} catch (ParseException ex) {
Logger.getLogger(HosJava.class.getName()).log(Level.SEVERE, null, ex);
}
}

});

MenuFile.add(FormIPD);

MenuBar.add(MenuFile);
//==========Menu Report======================================
MenuReport.setText("รายงาน");

MenuRep.setText("รายงานผล");
MenuRep.addActionListener(new java.awt.event.ActionListener() {
@Override
public void actionPerformed(java.awt.event.ActionEvent evt) {
MenuRepActionPerformed(evt);
}
});
MenuReport.add(MenuRep);

MenuBar.add(MenuReport);
//=========================================================

setJMenuBar(MenuBar);

pack();
}

private void FormOPDActionPerformed(ActionEvent evt) throws ParseException {
FormOPD f1 = new FormOPD("ห้องผู้ป่วยนอก");
jDesktopPane1.add(f1);
f1.show();
}

private void FormIPDActionPerformed(ActionEvent evt) throws ParseException {
FormIPD f2 = new FormIPD("ห้องผู้ป่วยใน");
jDesktopPane1.add(f2);
f2.show();
}

private void MenuRepActionPerformed(ActionEvent evt) {
FormReport f12 = new FormReport("รายงานผล");
jDesktopPane1.add(f12);
f12.show();
}

public static void main(String args[]) {

java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
new HosJava().setVisible(true);
}
});
}
}

 

ปุ่มบันทึก
=========================
package main;

import com.toedter.calendar.JDateChooser;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.Date;
import java.util.Locale;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

public class FormOPD extends javax.swing.JInternalFrame{

final JTextField txtCodePK,txtCodeID,txtFirstName,txtLastName,txtIDCard;
final JTextField txtBanID,txtMoo,txtDiag,txtSearch,txtTambol,txtDistrict;
final JTextField txtIntolerance;
final JComboBox cmbSexFK,cmbTitleFK,cmbReport,cmbProvince;
final JButton btnGenID,btnAdd,btnEdit,btnDelete,btnRefresh,btnSearch;
final JDateChooser txtBirthDate,txtInspectionDate,txtDoctorDate;
Connection connect = null;
PreparedStatement pstmt = null;
ResultSet rs = null;

FormOPD(String ห้องผู้ป่วยนอก) throws ParseException{
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame = new JFrame("ห้องผู้ป่วยนอก : เพิ่มข้อมูล / แก้ไขข้อมูล / ลบข้อมูล / ค้นหาข้อมูล");

Container contentPane = frame.getContentPane();
SpringLayout layout = new SpringLayout();
contentPane.setLayout(layout);

//==========JLabel=========================
JLabel lblCodePK = new JLabel("เลข HN : ");
JLabel lblSexFK = new JLabel("เพศ : ");
JLabel lblFirstName = new JLabel("ชื่อ : ");
JLabel lblLastName = new JLabel("สกุล : ");
JLabel lblIDCard = new JLabel("เลขบัตรประชาชน : ");
JLabel lblBirthDate = new JLabel("เดือน วัน,ปี เกิด(คศ.) : ");
JLabel lblBanID = new JLabel("บ้านเลขที่ :");
JLabel lblMoo = new JLabel("หมู่ที่ :");
JLabel lblTambol = new JLabel("ตำบล :");
JLabel lblDistrict = new JLabel("อำเภอ :");
JLabel lblProvince = new JLabel("จังหวัด :");
JLabel lblDiag = new JLabel("อาการของโรค :");
JLabel lblIntolerance = new JLabel("แพ้ยา :");
JLabel lblInspectionDate = new JLabel("เดือน วัน,ปี(คศ.)ที่มาตรวจ :");
JLabel lblReport = new JLabel("รายงาน :");
JLabel lblDoctorDate = new JLabel("วันที่แพทย์นัด :");
JLabel lblSearch = new JLabel("ค้นหาลำดับที่ :");

//==========JTextField=====================
txtCodePK = new JTextField("txtCodePK", 10);//txtCodePK.setBackground(Color.pink);
txtCodeID = new JTextField("txtCodeID", 9);//txtCodeID.setBackground(Color.pink);
txtFirstName = new JTextField("txtFirstName", 22);
txtLastName = new JTextField("txtLastName", 22);
txtIDCard = new JTextField("txtIDCard", 22);
//================txtBirthDate======================
Locale locale = new Locale ( "en", "US" );//new Locale ( "th", "TH" );
txtBirthDate = new JDateChooser ( );
txtBirthDate.setPreferredSize(new Dimension(216, 20));
txtBirthDate.setLocale ( locale );
Date date = new Date();
txtBirthDate.setDate(date);
contentPane.add ( txtBirthDate );
//==================================================

txtBanID = new JTextField("txtBanID",10);
txtMoo = new JTextField("txtMoo",10);
txtTambol = new JTextField("txtTambol",22);
txtDistrict = new JTextField("txtDistrict",22);
txtDiag = new JTextField("txtDiag",22);
txtIntolerance = new JTextField("txtIntolerance",22);
//================txtInspectionDate=================
txtInspectionDate = new JDateChooser ( );
txtInspectionDate.setPreferredSize(new Dimension(216, 20));
txtInspectionDate.setLocale ( locale );
txtInspectionDate.setDate(date);
contentPane.add ( txtInspectionDate );
//==================================================

//================txtDoctorDate=====================
txtDoctorDate = new JDateChooser ( );
txtDoctorDate.setPreferredSize(new Dimension(216, 20));
txtDoctorDate.setLocale ( locale );
txtDoctorDate.setDate(date);
contentPane.add ( txtDoctorDate );
//==================================================
txtSearch = new JTextField("txtSearch",10);txtSearch.setBackground(Color.yellow);


//==========JButton=========================
btnGenID = new JButton("GenID");
btnGenID.setPreferredSize(new Dimension(90, 20));
btnAdd = new JButton("เพิ่มข้อมูล");
btnAdd.setPreferredSize(new Dimension(110, 20));
btnEdit = new JButton("แก้ไขข้อมูล");
btnEdit.setPreferredSize(new Dimension(110, 20));
btnDelete = new JButton("ลบข้อมูล");
btnDelete.setPreferredSize(new Dimension(110, 20));
btnRefresh = new JButton("รีเฟรซข้อมูล");
btnRefresh.setPreferredSize(new Dimension(110, 20));
btnSearch = new JButton("ค้นหา");
btnSearch.setPreferredSize(new Dimension(110, 20));

//=======ComboBox ==================================================
String SexFK[] = {"ชาย","หญิง"};
cmbSexFK = new JComboBox(SexFK);
cmbSexFK.setPreferredSize(new Dimension(115, 20));

String TitleFK[] = {"นาย","นาง","นางสาว","เด็กชาย","เด็กหญิง","พระ","แม่ชี"};
cmbTitleFK = new JComboBox(TitleFK);
cmbTitleFK.setPreferredSize(new Dimension(95, 20));

String Report[] = {"รับรักษา","กลับบ้าน"};
cmbReport = new JComboBox(Report);
cmbReport.setPreferredSize(new Dimension(95, 20));

String Province[] = {"กรุงเทพมหานคร","กระบี่","กาญจนบุรี","กาฬสินธุ์",
"กำแพงเพชร","ขอนแก่น","จันทบุรี","ฉะเชิงเทรา","ชลบุรี","ชัยนาท","ชัยภูมิ",
"ชุมพร","เชียงราย","เชียงใหม่","ตรัง","ตราด","ตาก","นครนายก","นครปฐม",
"นครพนม","นครราชสีมา","นครศรีธรรมราช","นครสวรรค์","นนทบุรี","นราธิวาส",
"น่าน","บึงกาฬ","บุรีรัมย์","ปทุมธานี","ประจวบคีรีขันธ์","ปราจีนบุรี","ปัตตานี",
"พระนครศรีอยุธยา","พะเยา","พังงา","พัทลุง","พิจิตร","พิษณุโลก","เพชรบุรี",
"เพชรบูรณ์","แพร่","ภูเก็ต","มหาสารคาม","มุกดาหาร","แม่ฮ่องสอน","ยะลา",
"ยโสธร","ระนอง","ระยอง","ราชบุรี","ร้อยเอ็ด","ลพบุรี","ลำปาง","ลำพูน",
"เลย","ศรีสะเกษ","สกลนคร","สงขลา","สตูล","สมุทรปราการ","สมุทรสงคราม",
"สมุทรสาคร","สระบุรี","สระแก้ว","สิงห์บุรี","สุพรรณบุรี","สุราษฎร์ธานี","สุรินทร์",
"สุโขทัย","หนองคาย","หนองบัวลำภู","อำนาจเจริญ","อุดรธานี","อุตรดิตถ์",
"อุทัยธานี","อ่างทอง","อุบลราชธานี"};
cmbProvince = new JComboBox(Province);
cmbProvince.setPreferredSize(new Dimension(140, 20));



//=====add lbl==============================
contentPane.add(lblCodePK);
contentPane.add(lblSexFK);
contentPane.add(lblFirstName);
contentPane.add(lblLastName);
contentPane.add(lblIDCard);
contentPane.add(lblBirthDate);
contentPane.add(lblBanID);
contentPane.add(lblMoo);
contentPane.add(lblTambol);
contentPane.add(lblDistrict);
contentPane.add(lblProvince);
contentPane.add(lblDiag);
contentPane.add(lblIntolerance);
contentPane.add(lblInspectionDate);
contentPane.add(lblReport);
contentPane.add(lblDoctorDate);
contentPane.add(lblSearch);



//=====add txt==============================
contentPane.add(txtCodePK);
contentPane.add(txtCodeID);
contentPane.add(txtFirstName);
contentPane.add(txtLastName);
contentPane.add(txtIDCard);
contentPane.add(txtBanID);
contentPane.add(txtMoo);
contentPane.add(txtTambol);
contentPane.add(txtDistrict);
contentPane.add(txtDiag);
contentPane.add(txtIntolerance);
contentPane.add(txtInspectionDate);
contentPane.add(txtDoctorDate);
contentPane.add(txtSearch);


//======add button==========================
contentPane.add(btnGenID);
contentPane.add(btnAdd);
contentPane.add(btnEdit);
contentPane.add(btnDelete);
contentPane.add(btnRefresh);
contentPane.add(btnSearch);

//======add combobox========================
contentPane.add(cmbSexFK);
contentPane.add(cmbTitleFK);
contentPane.add(cmbReport);
contentPane.add(cmbProvince);

//===================lblCodePK===========================================
layout.putConstraint(SpringLayout.WEST, lblCodePK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSex==============================================
layout.putConstraint(SpringLayout.WEST, lblSexFK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSexFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblFirstName=========================================
layout.putConstraint(SpringLayout.WEST, lblFirstName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblLastName=========================================
layout.putConstraint(SpringLayout.WEST, lblLastName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIDCard===========================================
layout.putConstraint(SpringLayout.WEST, lblIDCard, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, lblBirthDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBanID============================================
layout.putConstraint(SpringLayout.WEST, lblBanID, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblMoo==============================================
layout.putConstraint(SpringLayout.WEST, lblMoo, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblTambol===========================================
layout.putConstraint(SpringLayout.WEST, lblTambol, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDistrict=========================================
layout.putConstraint(SpringLayout.WEST, lblDistrict, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblProvince=========================================
layout.putConstraint(SpringLayout.WEST, lblProvince, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDiag=============================================
layout.putConstraint(SpringLayout.WEST, lblDiag, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIntolerance======================================
layout.putConstraint(SpringLayout.WEST, lblIntolerance, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblInspectionDate===================================
layout.putConstraint(SpringLayout.WEST, lblInspectionDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblReport==========================================
layout.putConstraint(SpringLayout.WEST, lblReport, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblReport, 355, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDoctorDate=======================================
layout.putConstraint(SpringLayout.WEST, lblDoctorDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSearch==========================================
layout.putConstraint(SpringLayout.WEST, lblSearch, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================





//==================txtCodePK============================================
layout.putConstraint(SpringLayout.WEST, txtCodePK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtCodeID============================================
layout.putConstraint(SpringLayout.WEST, txtCodeID, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodeID, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbSexFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbSexFK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbSexFK, 30,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbTitleFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbTitleFK, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbTitleFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtFirstName==========================================
layout.putConstraint(SpringLayout.WEST, txtFirstName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtLastName==========================================
layout.putConstraint(SpringLayout.WEST, txtLastName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIDCard============================================
layout.putConstraint(SpringLayout.WEST, txtIDCard, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, txtBirthDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBanID=============================================
layout.putConstraint(SpringLayout.WEST, txtBanID, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtMoo===============================================
layout.putConstraint(SpringLayout.WEST, txtMoo, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtTambol============================================
layout.putConstraint(SpringLayout.WEST, txtTambol, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDistrict==========================================
layout.putConstraint(SpringLayout.WEST, txtDistrict, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbProvince==========================================
layout.putConstraint(SpringLayout.WEST, cmbProvince, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDiag=============================================
layout.putConstraint(SpringLayout.WEST, txtDiag, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIntolerance=======================================
layout.putConstraint(SpringLayout.WEST, txtIntolerance, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtInspectionDate====================================
layout.putConstraint(SpringLayout.WEST, txtInspectionDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbReport===========================================
layout.putConstraint(SpringLayout.WEST, cmbReport, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbReport, 355,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDoctorDate========================================
layout.putConstraint(SpringLayout.WEST, txtDoctorDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================txtSearch==========================================
layout.putConstraint(SpringLayout.WEST, txtSearch, 160, SpringLayout.WEST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================







//===================btnGenID============================================
layout.putConstraint(SpringLayout.WEST, btnGenID, 460, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnGenID, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnAdd============================================
layout.putConstraint(SpringLayout.WEST, btnAdd, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnAdd, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnEdit============================================
layout.putConstraint(SpringLayout.WEST, btnEdit, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnEdit, 35, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnDelte============================================
layout.putConstraint(SpringLayout.WEST, btnDelete, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnDelete, 65, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnRefresh============================================
layout.putConstraint(SpringLayout.WEST, btnRefresh, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, 95, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnSeach============================================
layout.putConstraint(SpringLayout.WEST, btnSearch, 305, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, btnSearch, 405, SpringLayout.NORTH,contentPane);
//=======================================================================

//=========Button Command=================================
btnRefresh.addActionListener(new ButtonListener());
btnGenID.addActionListener(new ButtonListener());
btnAdd.addActionListener(new ButtonListener());
//=========Clear TextBox==================================
txtCodePK.setText("");
txtCodeID.setText("");
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText("");
txtLastName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
txtMoo.setText("");
txtTambol.setText("");
txtDistrict.setText("");
cmbProvince.setSelectedItem(null);
txtDiag.setText("");
txtIntolerance.setText("");
cmbReport.setSelectedItem(null);
txtSearch.setText("");
//========================================================

//Display the window.

frame.pack();
frame.setVisible(true);
frame.setSize(690,480);//800,645
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}

private class ButtonListener implements ActionListener
{
@Override
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========btnRefresh====================
if(source == btnRefresh){
txtCodePK.setText("");
txtCodeID.setText("");
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText("");
txtLastName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
txtMoo.setText("");
txtTambol.setText("");
txtDistrict.setText("");
cmbProvince.setSelectedItem(null);
txtDiag.setText("");
txtIntolerance.setText("");
cmbReport.setSelectedItem(null);
txtSearch.setText("");
//==========เปิดปุ่มและ textBox================
btnGenID.setEnabled(true);
btnAdd.setEnabled(true);
btnEdit.setEnabled(true);
btnDelete.setEnabled(true);
btnSearch.setEnabled(true);
txtSearch.setEnabled(true);
txtCodePK.setEnabled(true);
txtCodeID.setEnabled(true);
//=========================================
}
//===========btnGenID===================================
if(source==btnGenID){
try{
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");
//JOptionPane.showMessageDialog(null,"Connect Database Successfully","รายงานสถานะ",
// JOptionPane.INFORMATION_MESSAGE);
String sql = "SELECT max(CodePK) FROM tblhosjava";//ใช้กับ MySQL
//String sql = "SELECT nvl(max(CodePK),0) FROM tblHelp"; //ใช้กับ MS Access 2003
pstmt = connect.prepareStatement(sql);
rs = pstmt.executeQuery();

if (rs.next()) {

int maxID = rs.getInt(1)+1;

txtCodePK.setText(String.valueOf(maxID));
//txtCodePK.setForeground(Color.red);
String paded = String.format("%10s",String.valueOf(maxID)).replace(' ', '0');
//txtCodeID.setText(paded);
txtCodeID.setText("HN"+paded);
//==========ปิดปุ่มและ textBox====================
btnGenID.setEnabled(false);
btnAdd.setEnabled(true);
btnEdit.setEnabled(false);
btnDelete.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
//=============================================
}
connect.close();
rs.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null,"Error GenID Auto !\n"+ex.getMessage());
}
}
if(source==btnAdd){
if(txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณากดปุ่ม GenID ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtCodePK.requestFocus();
//return;
}else if(cmbSexFK.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก เพศ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else if(cmbTitleFK.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก คำนำหน้าชื่อ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else if(txtFirstName.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ ชื่อ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtFirstName.requestFocus();
}else if(cmbProvince.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก จังหวัด ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else if(cmbReport.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก รายงาน ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else{
//==============Variable==========================
String CodePK = txtCodePK.getText();
String CodeID = txtCodeID.getText();
String Sex = (String)cmbSexFK.getSelectedItem();
String Title = (String)cmbTitleFK.getSelectedItem();
String FirstName = txtFirstName.getText();
String LastName = txtLastName.getText();
String IDCard = txtIDCard.getText();
String BanID = txtBanID.getText();
String Moo = txtMoo.getText();
String Tambol = txtTambol.getText();
String District = txtDistrict.getText();
String Province = (String)cmbProvince.getSelectedItem();
String Diag = txtDiag.getText();
String Intolerance = txtIntolerance.getText();
String Report = (String)cmbReport.getSelectedItem();

try {
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");

pstmt = connect.prepareStatement("INSERT INTO tblhosjava"+
"(CodePK,CodeID,SexFK,TitleFK,FirstName,LastName,IDCard,BirthDate," +
"BanID,Moo,Tambol,District,Province,Diag,Intolerance," +
"InspectionDate,Report,DoctorDate)"+
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

pstmt.setString(1, CodePK);
pstmt.setString(2, CodeID);
pstmt.setString(3, Sex);
pstmt.setString(4, Title);
pstmt.setString(5, FirstName);
pstmt.setString(6, LastName);
pstmt.setString(7, IDCard);
pstmt.setDate(8, convertUtilDateToSqlDate(txtBirthDate.getDate()));
pstmt.setString(9, BanID);
pstmt.setString(10, Moo);
pstmt.setString(11, Tambol);
pstmt.setString(12, District);
pstmt.setString(13, Province);
pstmt.setString(14, Diag);
pstmt.setString(15, Intolerance);
pstmt.setDate(16, convertUtilDateToSqlDate(txtInspectionDate.getDate()));
pstmt.setString(17, Report);
pstmt.setDate(18, convertUtilDateToSqlDate(txtDoctorDate.getDate()));

pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,"บันทึกข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();//สั่ง Clear All

connect.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException | HeadlessException e){
JOptionPane.showMessageDialog(null, "Error Insert to Database !\n"+e.getMessage());
}
}
}
}
}

private java.sql.Date convertUtilDateToSqlDate(Date date) {
if(date != null) {
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
return sqlDate;
}
return null;
}
}

 

FormOPD.java (สมบูรณ์แล้ว)
====================
package main;

import com.toedter.calendar.JDateChooser;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.Date;
import java.util.Locale;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

public class FormOPD extends javax.swing.JInternalFrame{

final JTextField txtCodePK,txtCodeID,txtFirstName,txtLastName,txtIDCard;
final JTextField txtBanID,txtMoo,txtDiag,txtSearch,txtTambol,txtDistrict;
final JTextField txtIntolerance;
final JComboBox cmbSexFK,cmbTitleFK,cmbReport,cmbProvince;
final JButton btnGenID,btnAdd,btnEdit,btnDelete,btnRefresh,btnSearch;
final JDateChooser txtBirthDate,txtInspectionDate,txtDoctorDate;
Connection connect = null;
PreparedStatement pstmt = null;
ResultSet rs = null;

FormOPD(String ห้องผู้ป่วยนอก) throws ParseException{
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame = new JFrame("ห้องผู้ป่วยนอก : เพิ่มข้อมูล / แก้ไขข้อมูล / ลบข้อมูล / ค้นหาข้อมูล");

Container contentPane = frame.getContentPane();
SpringLayout layout = new SpringLayout();
contentPane.setLayout(layout);

//==========JLabel=========================
JLabel lblCodePK = new JLabel("เลข HN : ");
JLabel lblSexFK = new JLabel("เพศ : ");
JLabel lblFirstName = new JLabel("ชื่อ : ");
JLabel lblLastName = new JLabel("สกุล : ");
JLabel lblIDCard = new JLabel("เลขบัตรประชาชน : ");
JLabel lblBirthDate = new JLabel("เดือน วัน,ปี เกิด(คศ.) : ");
JLabel lblBanID = new JLabel("บ้านเลขที่ :");
JLabel lblMoo = new JLabel("หมู่ที่ :");
JLabel lblTambol = new JLabel("ตำบล :");
JLabel lblDistrict = new JLabel("อำเภอ :");
JLabel lblProvince = new JLabel("จังหวัด :");
JLabel lblDiag = new JLabel("อาการของโรค :");
JLabel lblIntolerance = new JLabel("แพ้ยา :");
JLabel lblInspectionDate = new JLabel("เดือน วัน,ปี(คศ.)ที่มาตรวจ :");
JLabel lblReport = new JLabel("รายงาน :");
JLabel lblDoctorDate = new JLabel("วันที่แพทย์นัด :");
JLabel lblSearch = new JLabel("ค้นหาลำดับที่ :");

//==========JTextField=====================
txtCodePK = new JTextField("txtCodePK", 10);//txtCodePK.setBackground(Color.pink);
txtCodeID = new JTextField("txtCodeID", 9);//txtCodeID.setBackground(Color.pink);
txtFirstName = new JTextField("txtFirstName", 22);
txtLastName = new JTextField("txtLastName", 22);
txtIDCard = new JTextField("txtIDCard", 22);
//================txtBirthDate======================
Locale locale = new Locale ( "en", "US" );//new Locale ( "th", "TH" );
txtBirthDate = new JDateChooser ( );
txtBirthDate.setPreferredSize(new Dimension(216, 20));
txtBirthDate.setLocale ( locale );
Date date = new Date();
txtBirthDate.setDate(date);
contentPane.add ( txtBirthDate );
//==================================================

txtBanID = new JTextField("txtBanID",10);
txtMoo = new JTextField("txtMoo",10);
txtTambol = new JTextField("txtTambol",22);
txtDistrict = new JTextField("txtDistrict",22);
txtDiag = new JTextField("txtDiag",22);
txtIntolerance = new JTextField("txtIntolerance",22);
//================txtInspectionDate=================
txtInspectionDate = new JDateChooser ( );
txtInspectionDate.setPreferredSize(new Dimension(216, 20));
txtInspectionDate.setLocale ( locale );
txtInspectionDate.setDate(date);
contentPane.add ( txtInspectionDate );
//==================================================

//================txtDoctorDate=====================
txtDoctorDate = new JDateChooser ( );
txtDoctorDate.setPreferredSize(new Dimension(216, 20));
txtDoctorDate.setLocale ( locale );
txtDoctorDate.setDate(date);
contentPane.add ( txtDoctorDate );
//==================================================
txtSearch = new JTextField("txtSearch",10);txtSearch.setBackground(Color.yellow);


//==========JButton=========================
btnGenID = new JButton("GenID");
btnGenID.setPreferredSize(new Dimension(90, 20));
btnAdd = new JButton("เพิ่มข้อมูล");
btnAdd.setPreferredSize(new Dimension(110, 20));
btnEdit = new JButton("แก้ไขข้อมูล");
btnEdit.setPreferredSize(new Dimension(110, 20));
btnDelete = new JButton("ลบข้อมูล");
btnDelete.setPreferredSize(new Dimension(110, 20));
btnRefresh = new JButton("รีเฟรซข้อมูล");
btnRefresh.setPreferredSize(new Dimension(110, 20));
btnSearch = new JButton("ค้นหา");
btnSearch.setPreferredSize(new Dimension(110, 20));

//=======ComboBox ==================================================
String SexFK[] = {"ชาย","หญิง"};
cmbSexFK = new JComboBox(SexFK);
cmbSexFK.setPreferredSize(new Dimension(115, 20));

String TitleFK[] = {"นาย","นาง","นางสาว","เด็กชาย","เด็กหญิง","พระ","แม่ชี"};
cmbTitleFK = new JComboBox(TitleFK);
cmbTitleFK.setPreferredSize(new Dimension(95, 20));

String Report[] = {"รับรักษา","กลับบ้าน"};
cmbReport = new JComboBox(Report);
cmbReport.setPreferredSize(new Dimension(95, 20));

String Province[] = {"กรุงเทพมหานคร","กระบี่","กาญจนบุรี","กาฬสินธุ์",
"กำแพงเพชร","ขอนแก่น","จันทบุรี","ฉะเชิงเทรา","ชลบุรี","ชัยนาท","ชัยภูมิ",
"ชุมพร","เชียงราย","เชียงใหม่","ตรัง","ตราด","ตาก","นครนายก","นครปฐม",
"นครพนม","นครราชสีมา","นครศรีธรรมราช","นครสวรรค์","นนทบุรี","นราธิวาส",
"น่าน","บึงกาฬ","บุรีรัมย์","ปทุมธานี","ประจวบคีรีขันธ์","ปราจีนบุรี","ปัตตานี",
"พระนครศรีอยุธยา","พะเยา","พังงา","พัทลุง","พิจิตร","พิษณุโลก","เพชรบุรี",
"เพชรบูรณ์","แพร่","ภูเก็ต","มหาสารคาม","มุกดาหาร","แม่ฮ่องสอน","ยะลา",
"ยโสธร","ระนอง","ระยอง","ราชบุรี","ร้อยเอ็ด","ลพบุรี","ลำปาง","ลำพูน",
"เลย","ศรีสะเกษ","สกลนคร","สงขลา","สตูล","สมุทรปราการ","สมุทรสงคราม",
"สมุทรสาคร","สระบุรี","สระแก้ว","สิงห์บุรี","สุพรรณบุรี","สุราษฎร์ธานี","สุรินทร์",
"สุโขทัย","หนองคาย","หนองบัวลำภู","อำนาจเจริญ","อุดรธานี","อุตรดิตถ์",
"อุทัยธานี","อ่างทอง","อุบลราชธานี"};
cmbProvince = new JComboBox(Province);
cmbProvince.setPreferredSize(new Dimension(140, 20));



//=====add lbl==============================
contentPane.add(lblCodePK);
contentPane.add(lblSexFK);
contentPane.add(lblFirstName);
contentPane.add(lblLastName);
contentPane.add(lblIDCard);
contentPane.add(lblBirthDate);
contentPane.add(lblBanID);
contentPane.add(lblMoo);
contentPane.add(lblTambol);
contentPane.add(lblDistrict);
contentPane.add(lblProvince);
contentPane.add(lblDiag);
contentPane.add(lblIntolerance);
contentPane.add(lblInspectionDate);
contentPane.add(lblReport);
contentPane.add(lblDoctorDate);
contentPane.add(lblSearch);



//=====add txt==============================
contentPane.add(txtCodePK);
contentPane.add(txtCodeID);
contentPane.add(txtFirstName);
contentPane.add(txtLastName);
contentPane.add(txtIDCard);
contentPane.add(txtBanID);
contentPane.add(txtMoo);
contentPane.add(txtTambol);
contentPane.add(txtDistrict);
contentPane.add(txtDiag);
contentPane.add(txtIntolerance);
contentPane.add(txtInspectionDate);
contentPane.add(txtDoctorDate);
contentPane.add(txtSearch);


//======add button==========================
contentPane.add(btnGenID);
contentPane.add(btnAdd);
contentPane.add(btnEdit);
contentPane.add(btnDelete);
contentPane.add(btnRefresh);
contentPane.add(btnSearch);

//======add combobox========================
contentPane.add(cmbSexFK);
contentPane.add(cmbTitleFK);
contentPane.add(cmbReport);
contentPane.add(cmbProvince);

//===================lblCodePK===========================================
layout.putConstraint(SpringLayout.WEST, lblCodePK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSex==============================================
layout.putConstraint(SpringLayout.WEST, lblSexFK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSexFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblFirstName=========================================
layout.putConstraint(SpringLayout.WEST, lblFirstName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblLastName=========================================
layout.putConstraint(SpringLayout.WEST, lblLastName, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIDCard===========================================
layout.putConstraint(SpringLayout.WEST, lblIDCard, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, lblBirthDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblBanID============================================
layout.putConstraint(SpringLayout.WEST, lblBanID, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblMoo==============================================
layout.putConstraint(SpringLayout.WEST, lblMoo, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblTambol===========================================
layout.putConstraint(SpringLayout.WEST, lblTambol, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDistrict=========================================
layout.putConstraint(SpringLayout.WEST, lblDistrict, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblProvince=========================================
layout.putConstraint(SpringLayout.WEST, lblProvince, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDiag=============================================
layout.putConstraint(SpringLayout.WEST, lblDiag, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblIntolerance======================================
layout.putConstraint(SpringLayout.WEST, lblIntolerance, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblInspectionDate===================================
layout.putConstraint(SpringLayout.WEST, lblInspectionDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblReport==========================================
layout.putConstraint(SpringLayout.WEST, lblReport, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblReport, 355, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblDoctorDate=======================================
layout.putConstraint(SpringLayout.WEST, lblDoctorDate, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================lblSearch==========================================
layout.putConstraint(SpringLayout.WEST, lblSearch, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================





//==================txtCodePK============================================
layout.putConstraint(SpringLayout.WEST, txtCodePK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtCodeID============================================
layout.putConstraint(SpringLayout.WEST, txtCodeID, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodeID, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbSexFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbSexFK, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbSexFK, 30,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbTitleFK=============================================
layout.putConstraint(SpringLayout.WEST, cmbTitleFK, 260, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbTitleFK, 30, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtFirstName==========================================
layout.putConstraint(SpringLayout.WEST, txtFirstName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtFirstName, 55, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtLastName==========================================
layout.putConstraint(SpringLayout.WEST, txtLastName, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtLastName, 80, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIDCard============================================
layout.putConstraint(SpringLayout.WEST, txtIDCard, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIDCard, 105, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBirthDate=========================================
layout.putConstraint(SpringLayout.WEST, txtBirthDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBirthDate, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtBanID=============================================
layout.putConstraint(SpringLayout.WEST, txtBanID, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBanID, 155, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtMoo===============================================
layout.putConstraint(SpringLayout.WEST, txtMoo, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtMoo, 180, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtTambol============================================
layout.putConstraint(SpringLayout.WEST, txtTambol, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtTambol, 205, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDistrict==========================================
layout.putConstraint(SpringLayout.WEST, txtDistrict, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDistrict, 230, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbProvince==========================================
layout.putConstraint(SpringLayout.WEST, cmbProvince, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbProvince, 255, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDiag=============================================
layout.putConstraint(SpringLayout.WEST, txtDiag, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDiag, 280, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtIntolerance=======================================
layout.putConstraint(SpringLayout.WEST, txtIntolerance, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIntolerance, 305, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtInspectionDate====================================
layout.putConstraint(SpringLayout.WEST, txtInspectionDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtInspectionDate, 330, SpringLayout.NORTH, contentPane);
//=======================================================================

//==================cmbReport===========================================
layout.putConstraint(SpringLayout.WEST, cmbReport, 110,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbReport, 355,SpringLayout.NORTH, contentPane);
//=======================================================================

//==================txtDoctorDate========================================
layout.putConstraint(SpringLayout.WEST, txtDoctorDate, 110, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDoctorDate, 380, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================txtSearch==========================================
layout.putConstraint(SpringLayout.WEST, txtSearch, 160, SpringLayout.WEST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtSearch, 405, SpringLayout.NORTH, contentPane);
//=======================================================================







//===================btnGenID============================================
layout.putConstraint(SpringLayout.WEST, btnGenID, 460, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnGenID, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnAdd============================================
layout.putConstraint(SpringLayout.WEST, btnAdd, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnAdd, 5, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnEdit============================================
layout.putConstraint(SpringLayout.WEST, btnEdit, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnEdit, 35, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnDelte============================================
layout.putConstraint(SpringLayout.WEST, btnDelete, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnDelete, 65, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnRefresh============================================
layout.putConstraint(SpringLayout.WEST, btnRefresh, 560, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, 95, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnSeach============================================
layout.putConstraint(SpringLayout.WEST, btnSearch, 305, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, btnSearch, 405, SpringLayout.NORTH,contentPane);
//=======================================================================

//=========Button Command=================================
btnRefresh.addActionListener(new ButtonListener());
btnGenID.addActionListener(new ButtonListener());
btnAdd.addActionListener(new ButtonListener());
btnEdit.addActionListener(new ButtonListener());
btnDelete.addActionListener(new ButtonListener());
btnRefresh.addActionListener(new ButtonListener());
btnSearch.addActionListener(new ButtonListener());
txtSearch.addActionListener(new TextListener());
//=========Clear TextBox==================================
txtCodePK.setText("");
txtCodeID.setText("");
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText("");
txtLastName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
txtMoo.setText("");
txtTambol.setText("");
txtDistrict.setText("");
cmbProvince.setSelectedItem(null);
txtDiag.setText("");
txtIntolerance.setText("");
cmbReport.setSelectedItem(null);
txtSearch.setText("");
//=====================txtSearch Only Number==============
txtSearch.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtSearch = (JTextField) e.getSource();
String str = txtSearch.getText();
txtSearch.setText(str.replaceAll("[^0-9]", ""));
}
});

//=====================txtMoo Only Number=================
txtMoo.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoo = (JTextField) e.getSource();
String str = txtMoo.getText();
txtMoo.setText(str.replaceAll("[^0-9]", ""));
}
});
//========================================================

//Display the window.

frame.pack();
frame.setVisible(true);
frame.setSize(690,480);//800,645
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}

//==============txtSearch KeyPress=========================================
private class TextListener implements ActionListener
{
@Override
@SuppressWarnings("UseSpecificCatch")
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========txtSearch====================
if(source == txtSearch){
if((txtSearch.getText().equals("")) && txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
//return;
}else {
btnSearch.doClick();//แทนการ Click btnSeach
}
}
}
}
//===================End txtSearch KeyPress============================

private class ButtonListener implements ActionListener
{
@Override
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========btnRefresh====================
if(source == btnRefresh){
txtCodePK.setText("");
txtCodeID.setText("");
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText("");
txtLastName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
txtMoo.setText("");
txtTambol.setText("");
txtDistrict.setText("");
cmbProvince.setSelectedItem(null);
txtDiag.setText("");
txtIntolerance.setText("");
cmbReport.setSelectedItem(null);
txtSearch.setText("");
//==========เปิดปุ่มและ textBox================
btnGenID.setEnabled(true);
btnAdd.setEnabled(true);
btnEdit.setEnabled(true);
btnDelete.setEnabled(true);
btnSearch.setEnabled(true);
txtSearch.setEnabled(true);
txtCodePK.setEnabled(true);
txtCodeID.setEnabled(true);
//=========================================
}
//===========btnGenID===================================
if(source==btnGenID){
try{
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");
//JOptionPane.showMessageDialog(null,"Connect Database Successfully","รายงานสถานะ",
// JOptionPane.INFORMATION_MESSAGE);
String sql = "SELECT max(CodePK) FROM tblhosjava";//ใช้กับ MySQL
//String sql = "SELECT nvl(max(CodePK),0) FROM tblHelp"; //ใช้กับ MS Access 2003
pstmt = connect.prepareStatement(sql);
rs = pstmt.executeQuery();

if (rs.next()) {

int maxID = rs.getInt(1)+1;

txtCodePK.setText(String.valueOf(maxID));
//txtCodePK.setForeground(Color.red);
String paded = String.format("%10s",String.valueOf(maxID)).replace(' ', '0');
//txtCodeID.setText(paded);
txtCodeID.setText("HN"+paded);
//==========ปิดปุ่มและ textBox====================
btnGenID.setEnabled(false);
btnAdd.setEnabled(true);
btnEdit.setEnabled(false);
btnDelete.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
//=============================================
}
connect.close();
rs.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null,"Error GenID Auto !\n"+ex.getMessage());
}
}
if(source==btnAdd){
if(txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณากดปุ่ม GenID ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtCodePK.requestFocus();
//return;
}else if(cmbSexFK.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก เพศ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else if(cmbTitleFK.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก คำนำหน้าชื่อ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else if(txtFirstName.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ ชื่อ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtFirstName.requestFocus();
}else if(cmbProvince.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก จังหวัด ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else if(cmbReport.getSelectedItem()== null){
JOptionPane.showMessageDialog(null,"กรุณาเลือก รายงาน ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
}else{
//==============Variable==========================
String CodePK = txtCodePK.getText();
String CodeID = txtCodeID.getText();
String Sex = (String)cmbSexFK.getSelectedItem();
String Title = (String)cmbTitleFK.getSelectedItem();
String FirstName = txtFirstName.getText();
String LastName = txtLastName.getText();
String IDCard = txtIDCard.getText();
String BanID = txtBanID.getText();
String Moo = txtMoo.getText();
String Tambol = txtTambol.getText();
String District = txtDistrict.getText();
String Province = (String)cmbProvince.getSelectedItem();
String Diag = txtDiag.getText();
String Intolerance = txtIntolerance.getText();
String Report = (String)cmbReport.getSelectedItem();

try {
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");

pstmt = connect.prepareStatement("INSERT INTO tblhosjava"+
"(CodePK,CodeID,SexFK,TitleFK,FirstName,LastName,IDCard,BirthDate," +
"BanID,Moo,Tambol,District,Province,Diag,Intolerance," +
"InspectionDate,Report,DoctorDate)"+
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

pstmt.setString(1, CodePK);
pstmt.setString(2, CodeID);
pstmt.setString(3, Sex);
pstmt.setString(4, Title);
pstmt.setString(5, FirstName);
pstmt.setString(6, LastName);
pstmt.setString(7, IDCard);
pstmt.setDate(8, convertUtilDateToSqlDate(txtBirthDate.getDate()));
pstmt.setString(9, BanID);
pstmt.setString(10, Moo);
pstmt.setString(11, Tambol);
pstmt.setString(12, District);
pstmt.setString(13, Province);
pstmt.setString(14, Diag);
pstmt.setString(15, Intolerance);
pstmt.setDate(16, convertUtilDateToSqlDate(txtInspectionDate.getDate()));
pstmt.setString(17, Report);
pstmt.setDate(18, convertUtilDateToSqlDate(txtDoctorDate.getDate()));

pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,"บันทึกข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();//สั่ง Clear All

connect.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException | HeadlessException e){
JOptionPane.showMessageDialog(null, "Error Insert to Database !\n"+e.getMessage());
}
}
}
if(source==btnSearch){
if((txtSearch.getText().equals("")) && txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}else {
try{
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");

String sql = "Select * from tblhosjava " +
"Where CodePK LIKE '" + txtSearch.getText() + "' " ;
pstmt = connect.prepareStatement(sql);
rs = pstmt.executeQuery();

if(!rs.next() ){
JOptionPane.showMessageDialog(null,"ไม่พบข้อมูลที่ต้องการค้นหา","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
txtSearch.setText("");
}else{
do{
txtCodePK.setText(String.valueOf(rs.getString("CodePK")));
txtCodeID.setText(String.valueOf(rs.getString("CodeID")));
cmbSexFK.setSelectedItem(String.valueOf(rs.getString("SexFK")));
cmbTitleFK.setSelectedItem(String.valueOf(rs.getString("TitleFK")));
txtFirstName.setText(String.valueOf(rs.getString("FirstName")));
txtLastName.setText(String.valueOf(rs.getString("LastName")));
txtIDCard.setText(String.valueOf(rs.getString("IDCard")));
txtBirthDate.setDate(rs.getDate("BirthDate"));
txtBanID.setText(String.valueOf(rs.getString("BanID")));
txtMoo.setText(String.valueOf(rs.getString("Moo")));
txtTambol.setText(String.valueOf(rs.getString("Tambol")));
txtDistrict.setText(String.valueOf(rs.getString("District")));
cmbProvince.setSelectedItem(String.valueOf(rs.getString("Province")));
txtDiag.setText(String.valueOf(rs.getString("Diag")));
txtIntolerance.setText(String.valueOf(rs.getString("Intolerance")));
txtInspectionDate.setDate(rs.getDate("InspectionDate"));
cmbReport.setSelectedItem(String.valueOf(rs.getString("Report")));
txtDoctorDate.setDate(rs.getDate("DoctorDate"));

//===========================================================
//ปิดปุ่มและtextBox
btnGenID.setEnabled(false);
btnAdd.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
}while (rs.next());
}
connect.close();
rs.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null, "ไม่สามารถแสดงข้อมูลได้!\n"+ex.getMessage());
}
}
}
if(source==btnEdit){
if((txtSearch.getText().equals("")) && txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}else {

int CodePK = Integer.parseInt(txtCodePK.getText());
String Sex = (String)cmbSexFK.getSelectedItem();
String Title = (String)cmbTitleFK.getSelectedItem();
String FirstName = txtFirstName.getText();
String LastName = txtLastName.getText();
String IDCard = txtIDCard.getText();
String BanID = txtBanID.getText();
String Moo = txtMoo.getText();
String Tambol = txtTambol.getText();
String District = txtDistrict.getText();
String Province = (String)cmbProvince.getSelectedItem();
String Diag = txtDiag.getText();
String Intolerance = txtIntolerance.getText();
String Report = (String)cmbReport.getSelectedItem();

try {
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");
pstmt = connect.prepareStatement("UPDATE tblhosjava SET " +
"SexFK = ?,"+
"TitleFK = ?,"+
"FirstName = ?,"+
"LastName = ?,"+
"IDCard = ?,"+
"BirthDate = ?,"+
"BanID = ?,"+
"Moo = ?,"+
"Tambol = ?,"+
"District = ?,"+
"Province = ?,"+
"Diag = ?, "+
"Intolerance = ?, "+
"InspectionDate= ?, "+
"Report = ?, "+
"DoctorDate = ? " +
"WHERE CodePK = ?");
pstmt.setString(1, Sex);
pstmt.setString(2, Title);
pstmt.setString(3, FirstName);
pstmt.setString(4, LastName);
pstmt.setString(5, IDCard);
pstmt.setDate(6, convertUtilDateToSqlDate(txtBirthDate.getDate()));
pstmt.setString(7, BanID);
pstmt.setString(8, Moo);
pstmt.setString(9, Tambol);
pstmt.setString(10, District);
pstmt.setString(11, Province);
pstmt.setString(12, Diag);
pstmt.setString(13, Intolerance);
pstmt.setDate(14, convertUtilDateToSqlDate(txtInspectionDate.getDate()));
pstmt.setString(15, Report);
pstmt.setDate(16, convertUtilDateToSqlDate(txtDoctorDate.getDate()));
pstmt.setInt(17, CodePK);

pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,"แก้ไขข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();//สั่ง Clear All
txtSearch.requestFocus();

connect.close();
pstmt.close();

}catch(ClassNotFoundException | SQLException e){
JOptionPane.showMessageDialog(null, "Error Update to Database !\n"+e.getMessage());
}
}
}
if(source==btnDelete){
if((txtSearch.getText().equals("")) && txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}else {
//==================Do it=============================
int conf = JOptionPane.showConfirmDialog(null,"คุณต้องการลบข้อมูลลำดับที่ : " +txtSearch.getText()+" หรือไม่","รายงานสถานะ",JOptionPane.YES_NO_OPTION);
if(conf==0){
int CodePK = Integer.parseInt(txtCodePK.getText());
try {
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");

pstmt = connect.prepareStatement("DELETE FROM tblhosjava WHERE CodePK = ?");
pstmt.setInt(1, CodePK);
pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,"ลบข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();

connect.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException | HeadlessException ex){
JOptionPane.showMessageDialog(null,"ลบข้อมูลผิดพลาด!\n"+ex.getMessage());
}
}
}
}
}
}

private java.sql.Date convertUtilDateToSqlDate(Date date) {
if(date != null) {
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
return sqlDate;
}
return null;
}
}

 

ฝรั่งบอกว่าใครเขียน Text Mode Java ได้สามารถหากินได้ทั้ง 2 ค่าย คือ NetBeans กับ Eclipse ส่วนมากผมมองไม่เห็นความแตกต่างหากเขียนแบบ Text Mode สุดท้ายแล้วแต่คนชอบครับ

 

การออกแบบรายงานผล Java Text Mode
=======================================
ห้องตรวจ OPD (ผู้ป่วยนอก)

FormReport.java
==============
package main;

import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.SpringLayout;
import javax.swing.table.DefaultTableModel;

public class FormReport extends javax.swing.JInternalFrame{

ResultSet rec = null;
Connection connect = null;
Statement s = null;
JTable table;
PreparedStatement pstmt;
JLabel lblTotalCount;
DefaultTableModel model;
final JButton btnSearch,btnRefresh;
final JTextField txtSearch;

public FormReport(String รางานผล) {
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame = new JFrame("รายงานผล");
//frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//Set up the content pane.
Container contentPane = frame.getContentPane();
SpringLayout layout = new SpringLayout();
contentPane.setLayout(layout);

//==========JLabel===========================================
// ScrollPane
JScrollPane scrollPane = new JScrollPane();

scrollPane.setPreferredSize(new Dimension(1230, 476));//1190,476
layout.putConstraint(SpringLayout.WEST, scrollPane, 0, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, scrollPane, 60, SpringLayout.NORTH, contentPane);//35

contentPane.add(scrollPane);

// Table
table = new JTable();
scrollPane.setViewportView(table);

// Model for Table
model = (DefaultTableModel)table.getModel();
model.addColumn("HN");
model.addColumn("เพศ");
model.addColumn("คำนำหน้า");
model.addColumn("ชื่อ");
model.addColumn("สกุล");
model.addColumn("เลขบัตรประชาชน");
model.addColumn("วันเกิด");
model.addColumn("บ้านเลขที่");
model.addColumn("หมู่ที่");

//=============HN=======================================================
JLabel lblHN = new JLabel("ค้นหา HN คนไข้ :");
layout.putConstraint(SpringLayout.WEST, lblHN, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblHN, 5, SpringLayout.NORTH, contentPane);
contentPane.add(lblHN);

// txtSearch
txtSearch = new JTextField(10);
layout.putConstraint(SpringLayout.WEST, txtSearch, 10,SpringLayout.EAST, lblHN);
layout.putConstraint(SpringLayout.NORTH, txtSearch, 5, SpringLayout.NORTH, contentPane);
contentPane.add(txtSearch);

JLabel lblCount = new JLabel("จำนวนทั้งหมด (คน) :");
layout.putConstraint(SpringLayout.WEST, lblCount, 0, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, lblCount, 35, SpringLayout.NORTH, contentPane);
contentPane.add(lblCount);

lblTotalCount = new JLabel("lblTotalCount");
layout.putConstraint(SpringLayout.WEST, lblTotalCount, 130, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, lblTotalCount, 35, SpringLayout.NORTH, contentPane);
contentPane.add(lblTotalCount);
lblTotalCount.setForeground(Color.blue);

//============Button Command============================================

btnSearch = new JButton("ค้นหา");
layout.putConstraint(SpringLayout.WEST, btnSearch, 230, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, btnSearch, 5, SpringLayout.NORTH, contentPane);
contentPane.add(btnSearch);

btnRefresh = new JButton("รีเฟรซ");
layout.putConstraint(SpringLayout.WEST, btnRefresh, 310, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, 5, SpringLayout.NORTH, contentPane);
contentPane.add(btnRefresh);

//======================================================================
btnRefresh.addActionListener(new ButtonListener());
btnSearch.addActionListener(new ButtonListener());
txtSearch.addActionListener(new TextListener());
//=====================txtSearch Only Number============================
txtSearch.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtSearch = (JTextField) e.getSource();
String str = txtSearch.getText();
txtSearch.setText(str.replaceAll("[^0-9]", ""));
}
});
//===========================================================
showdata();
//===========================================================

//Display the window.
frame.pack();
frame.setVisible(true);
frame.setSize(1240,570);//1200,570
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}

private void showdata() {
try{
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");

s = connect.createStatement();

String sql = "SELECT * FROM tblhosjava "+
"WHERE " +
"CodeID like '%" + txtSearch.getText() + "%' " +
"ORDER BY CodeID ASC";
rec = s.executeQuery(sql);
int row = 0;
while((rec!=null) && (rec.next())){
model.addRow(new Object[0]);
model.setValueAt(rec.getString("CodeID"), row, 0);
model.setValueAt(rec.getString("SexFK"), row, 1);
model.setValueAt(rec.getString("TitleFK"), row, 2);
model.setValueAt(rec.getString("FirstName"), row, 3);
model.setValueAt(rec.getString("LastName"), row, 4);
model.setValueAt(rec.getString("IDCard"), row, 5);
model.setValueAt(rec.getString("BirthDate"), row, 6);
model.setValueAt(rec.getString("BanID"), row, 7);
model.setValueAt(rec.getString("Moo"), row, 8);

row++;
}

// Header Font & Color
table.getTableHeader().setFont(new Font("SansSerif", Font.BOLD, 12));
table.getTableHeader().setForeground(Color.blue);

// Column Width
table.getColumnModel().getColumn(0).setPreferredWidth(10);//CodeID
table.getColumnModel().getColumn(1).setPreferredWidth(10);//Sex
table.getColumnModel().getColumn(2).setPreferredWidth(30);//TitleFK
table.getColumnModel().getColumn(3).setPreferredWidth(80);//FirstName
table.getColumnModel().getColumn(4).setPreferredWidth(80);//LastName
table.getColumnModel().getColumn(5).setPreferredWidth(70);//IDCard
table.getColumnModel().getColumn(6).setPreferredWidth(20);//BirthDate
table.getColumnModel().getColumn(7).setPreferredWidth(20);//BanID
table.getColumnModel().getColumn(8).setPreferredWidth(10);//Moo

// Row Height
table.setRowHeight(20);
//=======Calculate================
Calculate();
//================================
rec.close();
s.close();
connect.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null, "ไม่สามารถแสดงข้อมูลได้!\n"+ex.getMessage());
}
}

private void Calculate() {
try{
Class.forName("org.mariadb.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mariadb://localhost/dbhosjava" +
"?user=root&password=gomplayer");

s = connect.createStatement();

//=======Calculate Cout Row====================
String com2 = "SELECT Count(SexFK) FROM tblhosjava "+
"WHERE " +
"CodeID like '%" + txtSearch.getText() + "%' " +
"ORDER BY CodeID ASC";

rec = s.executeQuery(com2);

if (rec.next()) {
int maxID = rec.getInt(1);

lblTotalCount.setText(String.valueOf(maxID));
}

//====Close==============
rec.close();
s.close();
connect.close();
//=======================
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null, "ไม่สามารถแสดงข้อมูลได้!\n"+ex.getMessage());
}
}

private class ButtonListener implements ActionListener {

@Override
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========btnSearch====================
if(source == btnSearch){
model.setRowCount(0);//Clear JTable
showdata();
}
//===========btnRefresh===================
if(source == btnRefresh){
try{
model.setRowCount(0);//Clear JTable
showdata();
txtSearch.setText("");
}catch (Exception ex){
JOptionPane.showMessageDialog(null,"Error Refresh Data !\n"+ex.getMessage());
}
}
}
}

private class TextListener implements ActionListener {

@Override
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========btnRefresh====================
if(source == txtSearch){
btnSearch.doClick();//แทนการ Click btnSeach
}
}
}
}

 

การพัฒนาในส่วน SpringLayout ได้ทั้ง Java NetBeans และ Java Eclipse
========================================
เพิ่มห้องตรวจ
3.ห้องอายุรกรรมชาย,อายุรกรรมหญิง
4.ศัลยกรรม
5.ห้องผ่าตัด
6.X-Ray
7.Ortho
8.สูตินารีเวช
9.DRG
10.ICU
11.เวชระเบียน
12.สำนักงานสถิติ
13.การเงินและบัญชี
14.เภสัชกรรม
15.โภชนาการ
16.ห้องพิเศษ
17.ห้องชันสูตร
18.ธนาคารเลือด
19.ห้องพยาธิ

ฯลฯ

 

การออกแบบหน้าจอรายงานผล HosJava(ทุกอย่างเขียนด้วย TextMode ล้วนๆ)
========================================
<pre style="background:#404040;color:#dedede">package main;

<span style="color:#ffffa0">import</span> java.awt.Color;
<span style="color:#ffffa0">import</span> java.awt.Container;
<span style="color:#ffffa0">import</span> java.awt.Dimension;
<span style="color:#ffffa0">import</span> java.awt.Font;
<span style="color:#ffffa0">import</span> java.awt.event.ActionEvent;
<span style="color:#ffffa0">import</span> java.awt.event.ActionListener;
<span style="color:#ffffa0">import</span> java.awt.event.KeyAdapter;
<span style="color:#ffffa0">import</span> java.awt.event.KeyEvent;
<span style="color:#ffffa0">import</span> java.sql.Connection;
<span style="color:#ffffa0">import</span> java.sql.DriverManager;
<span style="color:#ffffa0">import</span> java.sql.PreparedStatement;
<span style="color:#ffffa0">import</span> java.sql.ResultSet;
<span style="color:#ffffa0">import</span> java.sql.SQLException;
<span style="color:#ffffa0">import</span> javax.swing.JButton;
<span style="color:#ffffa0">import</span> javax.swing.JFrame;
<span style="color:#ffffa0">import</span> javax.swing.JLabel;
<span style="color:#ffffa0">import</span> javax.swing.JOptionPane;
<span style="color:#ffffa0">import</span> javax.swing.JScrollPane;
<span style="color:#ffffa0">import</span> javax.swing.JTable;
<span style="color:#ffffa0">import</span> javax.swing.JTextField;
<span style="color:#ffffa0">import</span> javax.swing.SpringLayout;
<span style="color:#ffffa0">import</span> javax.swing.table.DefaultTableModel;

<span style="color:#ffffa0">public</span> <span style="color:#6080ff">class</span> <span style="color:#f09040">FormReport</span> extends javax.swing.JInternalFrame{

ResultSet rec <span style="color:#ffffa0">=</span> null;
Connection connect <span style="color:#ffffa0">=</span> null;
JTable table;
PreparedStatement pstmt <span style="color:#ffffa0">=</span> null;
JLabel lblTotalCount;
DefaultTableModel model;
final JButton btnSearch,btnRefresh;
final JTextField txtSearch;

<span style="color:#ffffa0">public</span> FormReport(<span style="color:#6080ff">String</span> รางานผล) {
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JFrame(<span style="color:#ff2020">"รายงานผล"</span>);
<span style="color:#709070;font-style:italic">//frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);</span>

<span style="color:#709070;font-style:italic">//Set up the content pane.</span>
Container contentPane <span style="color:#ffffa0">=</span> frame.getContentPane();
SpringLayout layout <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> SpringLayout();
contentPane.setLayout(layout);

<span style="color:#709070;font-style:italic">//==========JLabel===========================================</span>
<span style="color:#709070;font-style:italic">// ScrollPane</span>
JScrollPane scrollPane <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JScrollPane();

scrollPane.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">1230</span>, <span style="color:#22c0ff">476</span>));<span style="color:#709070;font-style:italic">//1190,476</span>
layout.putConstraint(SpringLayout.WEST, scrollPane, <span style="color:#22c0ff">0</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, scrollPane, <span style="color:#22c0ff">60</span>, SpringLayout.NORTH, contentPane);<span style="color:#709070;font-style:italic">//35</span>

contentPane.add(scrollPane);

<span style="color:#709070;font-style:italic">// Table</span>
table <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTable();
scrollPane.setViewportView(table);

<span style="color:#709070;font-style:italic">// Model for Table</span>
model <span style="color:#ffffa0">=</span> (DefaultTableModel)table.getModel();
model.addColumn(<span style="color:#ff2020">"HN"</span>);
model.addColumn(<span style="color:#ff2020">"เพศ"</span>);
model.addColumn(<span style="color:#ff2020">"คำนำหน้า"</span>);
model.addColumn(<span style="color:#ff2020">"ชื่อ - สกุล"</span>);
model.addColumn(<span style="color:#ff2020">"เลขบัตรประชาชน"</span>);
model.addColumn(<span style="color:#ff2020">"วันเกิด"</span>);
model.addColumn(<span style="color:#ff2020">"อายุ(ปี)"</span>);
model.addColumn(<span style="color:#ff2020">"บ้านเลขที่"</span>);
model.addColumn(<span style="color:#ff2020">"หมู่ที่"</span>);
model.addColumn(<span style="color:#ff2020">"จังหวัด"</span>);
model.addColumn(<span style="color:#ff2020">"รายงาน"</span>);
model.addColumn(<span style="color:#ff2020">"บันทึกวันที่"</span>);

<span style="color:#709070;font-style:italic">//=============HN=======================================================</span>
JLabel lblHN <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"ค้นหา HN คนไข้ :"</span>);
layout.putConstraint(SpringLayout.WEST, lblHN, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblHN, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
contentPane.add(lblHN);

<span style="color:#709070;font-style:italic">// txtSearch</span>
txtSearch <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#22c0ff">10</span>);
layout.putConstraint(SpringLayout.WEST, txtSearch, <span style="color:#22c0ff">10</span>,SpringLayout.EAST, lblHN);
layout.putConstraint(SpringLayout.NORTH, txtSearch, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
contentPane.add(txtSearch);

JLabel lblCount <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"จำนวนทั้งหมด (คน) :"</span>);
layout.putConstraint(SpringLayout.WEST, lblCount, <span style="color:#22c0ff">0</span>, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, lblCount, <span style="color:#22c0ff">35</span>, SpringLayout.NORTH, contentPane);
contentPane.add(lblCount);

lblTotalCount <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"lblTotalCount"</span>);
layout.putConstraint(SpringLayout.WEST, lblTotalCount, <span style="color:#22c0ff">130</span>, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, lblTotalCount, <span style="color:#22c0ff">35</span>, SpringLayout.NORTH, contentPane);
contentPane.add(lblTotalCount);
lblTotalCount.setForeground(Color.blue);

<span style="color:#709070;font-style:italic">//============Button Command============================================</span>

btnSearch <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"ค้นหา"</span>);
layout.putConstraint(SpringLayout.WEST, btnSearch, <span style="color:#22c0ff">230</span>, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, btnSearch, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
contentPane.add(btnSearch);

btnRefresh <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"รีเฟรซ"</span>);
layout.putConstraint(SpringLayout.WEST, btnRefresh, <span style="color:#22c0ff">310</span>, SpringLayout.WEST, lblHN);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
contentPane.add(btnRefresh);

<span style="color:#709070;font-style:italic">//======================================================================</span>
btnRefresh.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnSearch.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
txtSearch.addActionListener(<span style="color:#ffffa0">new</span> TextListener());
<span style="color:#709070;font-style:italic">//=====================txtSearch Only Number============================</span>
txtSearch.addKeyListener(<span style="color:#ffffa0">new</span> KeyAdapter(){
@Override
<span style="color:#ffffa0">public</span> void keyReleased(KeyEvent e) {
JTextField txtSearch <span style="color:#ffffa0">=</span> (JTextField) e.getSource();
<span style="color:#6080ff">String</span> str <span style="color:#ffffa0">=</span> txtSearch.getText();
txtSearch.setText(str.replaceAll(<span style="color:#ff2020">"[^0-9]"</span>, <span style="color:#ff2020">""</span>));
}
});
<span style="color:#709070;font-style:italic">//=========================================================== </span>
showdata();
<span style="color:#709070;font-style:italic">//===========================================================</span>

<span style="color:#709070;font-style:italic">//Display the window.</span>
frame.pack();
frame.setVisible(true);
frame.setSize(<span style="color:#22c0ff">1240</span>,<span style="color:#22c0ff">570</span>);<span style="color:#709070;font-style:italic">//1200,570</span>
frame.setResizable(false);<span style="color:#709070;font-style:italic">//ไม่ให้ Resize</span>
frame.setLocationRelativeTo(null);
}

<span style="color:#ffffa0">private</span> void showdata() {
try{
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);

<span style="color:#6080ff">String</span> sql <span style="color:#ffffa0">=</span> <span style="color:#ff2020">"SELECT CodeID,SexFK,TitleFK, "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"CONCAT_WS(' ',FirstName,LastName) As FullName, "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"IDCard,DATE_FORMAT(DATE_ADD(BirthDate, INTERVAL 543 YEAR),'%d/%m/%Y') AS BirthDate,"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"TRUNCATE((DATEDIFF(Now(),BirthDate)/365.25),0) as Age,"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"BanID,Moo,Province,Report,DATE_FORMAT(DATE_ADD(DateAdd, INTERVAL 543 YEAR),'%d/%m/%Y') AS DateAdd "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"FROM tblhosjava "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"WHERE "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"curdate()&lt;date_add(DateAdd,interval 7 day)"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"AND CodeID like '%"</span> <span style="color:#ffffa0">+</span> txtSearch.getText() <span style="color:#ffffa0">+</span> <span style="color:#ff2020">"%' "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"ORDER BY CodeID ASC"</span>;
<span style="color:#709070;font-style:italic">//curdate()&lt;date_add(date_field,interval 5 day) </span>
pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(sql);<span style="color:#709070;font-style:italic">//new</span>
rec <span style="color:#ffffa0">=</span> pstmt.executeQuery();<span style="color:#709070;font-style:italic">//new</span>
int row <span style="color:#ffffa0">=</span> <span style="color:#22c0ff">0</span>;
<span style="color:#ffffa0">while</span>((rec<span style="color:#ffffa0">!</span><span style="color:#ffffa0">=</span>null) <span style="color:#ffffa0">&amp;</span><span style="color:#ffffa0">&amp;</span> (rec.next())){
model.addRow(<span style="color:#ffffa0">new</span> Object[<span style="color:#22c0ff">0</span>]);
model.setValueAt(rec.getString(<span style="color:#ff2020">"CodeID"</span>), row, <span style="color:#22c0ff">0</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"SexFK"</span>), row, <span style="color:#22c0ff">1</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"TitleFK"</span>), row, <span style="color:#22c0ff">2</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"FullName"</span>), row, <span style="color:#22c0ff">3</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"IDCard"</span>), row, <span style="color:#22c0ff">4</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"BirthDate"</span>), row, <span style="color:#22c0ff">5</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"Age"</span>), row, <span style="color:#22c0ff">6</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"BanID"</span>), row, <span style="color:#22c0ff">7</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"Moo"</span>), row, <span style="color:#22c0ff">8</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"Province"</span>), row, <span style="color:#22c0ff">9</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"Report"</span>), row, <span style="color:#22c0ff">10</span>);
model.setValueAt(rec.getString(<span style="color:#ff2020">"DateAdd"</span>), row, <span style="color:#22c0ff">11</span>);

row<span style="color:#ffffa0">+</span><span style="color:#ffffa0">+</span>;
}

<span style="color:#709070;font-style:italic">// Header Font &amp; Color</span>
table.getTableHeader().setFont(<span style="color:#ffffa0">new</span> Font(<span style="color:#ff2020">"SansSerif"</span>, Font.BOLD, <span style="color:#22c0ff">12</span>));
table.getTableHeader().setForeground(Color.blue);

<span style="color:#709070;font-style:italic">// Column Width</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">0</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//CodeID</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">1</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//Sex</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">2</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//TitleFK</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">3</span>).setPreferredWidth(<span style="color:#22c0ff">80</span>);<span style="color:#709070;font-style:italic">//FirstName</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">4</span>).setPreferredWidth(<span style="color:#22c0ff">40</span>);<span style="color:#709070;font-style:italic">//IDCard</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">5</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//BirthDate</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">6</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//Age</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">7</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//BanID</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">8</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//Moo</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">9</span>).setPreferredWidth(<span style="color:#22c0ff">30</span>);<span style="color:#709070;font-style:italic">//Province</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">10</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//Report</span>
table.getColumnModel().getColumn(<span style="color:#22c0ff">11</span>).setPreferredWidth(<span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//DateAdd</span>

<span style="color:#709070;font-style:italic">// Row Height</span>
table.setRowHeight(<span style="color:#22c0ff">20</span>);
<span style="color:#709070;font-style:italic">//=======Calculate================</span>
Calculate();
<span style="color:#709070;font-style:italic">//================================</span>
rec.close();
pstmt.close();
connect.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null, <span style="color:#ff2020">"ไม่สามารถแสดงข้อมูลได้!<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>ex.getMessage());
}
}

<span style="color:#ffffa0">private</span> void Calculate() {
try{
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);

<span style="color:#709070;font-style:italic">//=======Calculate Cout Row====================</span>
<span style="color:#6080ff">String</span> com2 <span style="color:#ffffa0">=</span> <span style="color:#ff2020">"SELECT Count(SexFK) FROM tblhosjava "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"WHERE "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"curdate()&lt;date_add(DateAdd,interval 7 day)"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"AND CodeID like '%"</span> <span style="color:#ffffa0">+</span> txtSearch.getText() <span style="color:#ffffa0">+</span> <span style="color:#ff2020">"%' "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"ORDER BY CodeID ASC"</span>;

pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(com2);<span style="color:#709070;font-style:italic">//new</span>
rec <span style="color:#ffffa0">=</span> pstmt.executeQuery();<span style="color:#709070;font-style:italic">//new</span>

<span style="color:#ffffa0">if</span> (rec.next()) {
int maxID <span style="color:#ffffa0">=</span> rec.getInt(<span style="color:#22c0ff">1</span>);

lblTotalCount.setText(<span style="color:#6080ff">String</span>.valueOf(maxID));
}

<span style="color:#709070;font-style:italic">//====Close==============</span>
rec.close();
pstmt.close();
connect.close();
<span style="color:#709070;font-style:italic">//=======================</span>
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null, <span style="color:#ff2020">"ไม่สามารถแสดงข้อมูลได้!<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>ex.getMessage());
}
}

<span style="color:#ffffa0">private</span> <span style="color:#6080ff">class</span> <span style="color:#f09040">ButtonListener</span> <span style="color:#ffffa0">implements</span> ActionListener {

@Override
<span style="color:#ffffa0">public</span> void actionPerformed(ActionEvent ae) {
Object source <span style="color:#ffffa0">=</span> ae.getSource();
<span style="color:#709070;font-style:italic">//===========btnSearch====================</span>
<span style="color:#ffffa0">if</span>(source <span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> btnSearch){
model.setRowCount(<span style="color:#22c0ff">0</span>);<span style="color:#709070;font-style:italic">//Clear JTable</span>
showdata();
}
<span style="color:#709070;font-style:italic">//===========btnRefresh===================</span>
<span style="color:#ffffa0">if</span>(source <span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> btnRefresh){
try{
model.setRowCount(<span style="color:#22c0ff">0</span>);<span style="color:#709070;font-style:italic">//Clear JTable</span>
showdata();
txtSearch.setText(<span style="color:#ff2020">""</span>);
}catch (Exception ex){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"Error Refresh Data !<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>ex.getMessage());
}
}
}
}

<span style="color:#ffffa0">private</span> <span style="color:#6080ff">class</span> <span style="color:#f09040">TextListener</span> <span style="color:#ffffa0">implements</span> ActionListener {

@Override
<span style="color:#ffffa0">public</span> void actionPerformed(ActionEvent ae) {
Object source <span style="color:#ffffa0">=</span> ae.getSource();
<span style="color:#709070;font-style:italic">//===========btnRefresh====================</span>
<span style="color:#ffffa0">if</span>(source <span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> txtSearch){
btnSearch.doClick();<span style="color:#709070;font-style:italic">//แทนการ Click btnSeach</span>
}
}
}
}
</pre>

 

ห้องตรวจ OPD (ห้องตรวจผู้ป่วยนอก) (ทุกอย่างเขียนด้วย TextMode ล้วนๆ)
==========================================
<pre style="background:#404040;color:#dedede">package main;

<span style="color:#ffffa0">import</span> com.toedter.calendar.JDateChooser;
<span style="color:#ffffa0">import</span> java.awt.Color;
<span style="color:#ffffa0">import</span> java.awt.Container;
<span style="color:#ffffa0">import</span> java.awt.Dimension;
<span style="color:#ffffa0">import</span> java.awt.HeadlessException;
<span style="color:#ffffa0">import</span> java.awt.event.ActionEvent;
<span style="color:#ffffa0">import</span> java.awt.event.ActionListener;
<span style="color:#ffffa0">import</span> java.awt.event.KeyAdapter;
<span style="color:#ffffa0">import</span> java.awt.event.KeyEvent;
<span style="color:#ffffa0">import</span> java.sql.Connection;
<span style="color:#ffffa0">import</span> java.sql.DriverManager;
<span style="color:#ffffa0">import</span> java.sql.PreparedStatement;
<span style="color:#ffffa0">import</span> java.sql.ResultSet;
<span style="color:#ffffa0">import</span> java.sql.SQLException;
<span style="color:#ffffa0">import</span> java.text.ParseException;
<span style="color:#ffffa0">import</span> java.util.Date;
<span style="color:#ffffa0">import</span> java.util.Locale;
<span style="color:#ffffa0">import</span> javax.swing.JButton;
<span style="color:#ffffa0">import</span> javax.swing.JComboBox;
<span style="color:#ffffa0">import</span> javax.swing.JFrame;
<span style="color:#ffffa0">import</span> javax.swing.JLabel;
<span style="color:#ffffa0">import</span> javax.swing.JOptionPane;
<span style="color:#ffffa0">import</span> javax.swing.JTextField;
<span style="color:#ffffa0">import</span> javax.swing.SpringLayout;

<span style="color:#ffffa0">public</span> <span style="color:#6080ff">class</span> <span style="color:#f09040">FormOPD</span> extends javax.swing.JInternalFrame{

final JTextField txtCodePK,txtCodeID,txtFirstName,txtLastName,txtIDCard;
final JTextField txtBanID,txtMoo,txtDiag,txtSearch,txtTambol,txtDistrict;
final JTextField txtIntolerance;
final JComboBox cmbSexFK,cmbTitleFK,cmbReport,cmbProvince;
final JButton btnGenID,btnAdd,btnEdit,btnDelete,btnRefresh,btnSearch;
final JDateChooser txtBirthDate,txtInspectionDate,txtDoctorDate;
final JTextField txtDateAdd;
Connection connect <span style="color:#ffffa0">=</span> null;
PreparedStatement pstmt <span style="color:#ffffa0">=</span> null;
ResultSet rs <span style="color:#ffffa0">=</span> null;

FormOPD(<span style="color:#6080ff">String</span> ห้องผู้ป่วยนอก) throws ParseException{
JFrame.setDefaultLookAndFeelDecorated(true);

JFrame frame <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JFrame(<span style="color:#ff2020">"ห้องผู้ป่วยนอก : เพิ่มข้อมูล / แก้ไขข้อมูล / ลบข้อมูล / ค้นหาข้อมูล"</span>);

Container contentPane <span style="color:#ffffa0">=</span> frame.getContentPane();
SpringLayout layout <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> SpringLayout();
contentPane.setLayout(layout);

<span style="color:#709070;font-style:italic">//==========JLabel=========================</span>
JLabel lblCodePK <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"เลข HN : "</span>);
JLabel lblSexFK <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"เพศ : "</span>);
JLabel lblFirstName <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"ชื่อ : "</span>);
JLabel lblLastName <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"สกุล : "</span>);
JLabel lblIDCard <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"เลขบัตรประชาชน : "</span>);
JLabel lblBirthDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"เดือน วัน,ปี เกิด(คศ.) : "</span>);
JLabel lblBanID <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"บ้านเลขที่ :"</span>);
JLabel lblMoo <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"หมู่ที่ :"</span>);
JLabel lblTambol <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"ตำบล :"</span>);
JLabel lblDistrict <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"อำเภอ :"</span>);
JLabel lblProvince <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"จังหวัด :"</span>);
JLabel lblDiag <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"อาการของโรค :"</span>);
JLabel lblIntolerance <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"แพ้ยา :"</span>);
JLabel lblInspectionDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"เดือน วัน,ปี(คศ.)ที่มาตรวจ :"</span>);
JLabel lblReport <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"รายงาน :"</span>);
JLabel lblDoctorDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"วันที่แพทย์นัด :"</span>);
JLabel lblSearch <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"ค้นหาลำดับที่&amp;เลขบัตร ปช.:"</span>);
JLabel lblDateAdd <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JLabel(<span style="color:#ff2020">"วันนี้วันที่ :"</span>);

<span style="color:#709070;font-style:italic">//==========JTextField=====================</span>
txtCodePK <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtCodePK"</span>, <span style="color:#22c0ff">10</span>);<span style="color:#709070;font-style:italic">//txtCodePK.setBackground(Color.pink);</span>
txtCodeID <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtCodeID"</span>, <span style="color:#22c0ff">9</span>);<span style="color:#709070;font-style:italic">//txtCodeID.setBackground(Color.pink);</span>
txtFirstName <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtFirstName"</span>, <span style="color:#22c0ff">22</span>);
txtLastName <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtLastName"</span>, <span style="color:#22c0ff">22</span>);
txtIDCard <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtIDCard"</span>, <span style="color:#22c0ff">22</span>);
<span style="color:#709070;font-style:italic">//================txtBirthDate====================== </span>
Locale locale <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> Locale ( <span style="color:#ff2020">"en"</span>, <span style="color:#ff2020">"US"</span> );<span style="color:#709070;font-style:italic">//new Locale ( "th", "TH" );</span>
txtBirthDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JDateChooser ( );
txtBirthDate.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">216</span>, <span style="color:#22c0ff">20</span>));
txtBirthDate.setLocale ( locale );
Date date <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> Date();
txtBirthDate.setDate(date);
contentPane.add ( txtBirthDate );

<span style="color:#709070;font-style:italic">//==================================================</span>

txtBanID <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtBanID"</span>,<span style="color:#22c0ff">10</span>);
txtMoo <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtMoo"</span>,<span style="color:#22c0ff">10</span>);
txtTambol <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtTambol"</span>,<span style="color:#22c0ff">22</span>);
txtDistrict <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtDistrict"</span>,<span style="color:#22c0ff">22</span>);
txtDiag <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtDiag"</span>,<span style="color:#22c0ff">22</span>);
txtIntolerance <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtIntolerance"</span>,<span style="color:#22c0ff">22</span>);
<span style="color:#709070;font-style:italic">//================txtInspectionDate================= </span>
txtInspectionDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JDateChooser ( );
txtInspectionDate.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">216</span>, <span style="color:#22c0ff">20</span>));
txtInspectionDate.setLocale ( locale );
txtInspectionDate.setDate(date);
contentPane.add ( txtInspectionDate );
<span style="color:#709070;font-style:italic">//==================================================</span>

<span style="color:#709070;font-style:italic">//================txtDoctorDate===================== </span>
txtDoctorDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JDateChooser ( );
txtDoctorDate.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">216</span>, <span style="color:#22c0ff">20</span>));
txtDoctorDate.setLocale ( locale );
txtDoctorDate.setDate(date);
contentPane.add ( txtDoctorDate );
<span style="color:#709070;font-style:italic">//==================================================</span>
txtSearch <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtSearch"</span>,<span style="color:#22c0ff">10</span>);txtSearch.setBackground(Color.yellow);
txtDateAdd <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JTextField(<span style="color:#ff2020">"txtDateAdd"</span>, <span style="color:#22c0ff">6</span>);

<span style="color:#709070;font-style:italic">//==========JButton=========================</span>
btnGenID <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"GenID"</span>);
btnGenID.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">90</span>, <span style="color:#22c0ff">25</span>));
btnAdd <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"เพิ่มข้อมูล"</span>);
btnAdd.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">110</span>, <span style="color:#22c0ff">25</span>));
btnEdit <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"แก้ไขข้อมูล"</span>);
btnEdit.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">110</span>, <span style="color:#22c0ff">25</span>));
btnDelete <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"ลบข้อมูล"</span>);
btnDelete.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">110</span>, <span style="color:#22c0ff">25</span>));
btnRefresh <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"รีเฟรซข้อมูล"</span>);
btnRefresh.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">110</span>, <span style="color:#22c0ff">25</span>));
btnSearch <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JButton(<span style="color:#ff2020">"ค้นหา"</span>);
btnSearch.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">120</span>, <span style="color:#22c0ff">25</span>));

<span style="color:#709070;font-style:italic">//=======ComboBox ==================================================</span>
<span style="color:#6080ff">String</span> SexFK[] <span style="color:#ffffa0">=</span> {<span style="color:#ff2020">"ชาย"</span>,<span style="color:#ff2020">"หญิง"</span>};
cmbSexFK <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JComboBox(SexFK);
cmbSexFK.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">115</span>, <span style="color:#22c0ff">20</span>));

<span style="color:#6080ff">String</span> TitleFK[] <span style="color:#ffffa0">=</span> {<span style="color:#ff2020">"นาย"</span>,<span style="color:#ff2020">"นาง"</span>,<span style="color:#ff2020">"นางสาว"</span>,<span style="color:#ff2020">"เด็กชาย"</span>,<span style="color:#ff2020">"เด็กหญิง"</span>,<span style="color:#ff2020">"พระ"</span>,<span style="color:#ff2020">"แม่ชี"</span>};
cmbTitleFK <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JComboBox(TitleFK);
cmbTitleFK.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">95</span>, <span style="color:#22c0ff">20</span>));

<span style="color:#6080ff">String</span> Report[] <span style="color:#ffffa0">=</span> {<span style="color:#ff2020">"รับรักษา"</span>,<span style="color:#ff2020">"กลับบ้าน"</span>};
cmbReport <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JComboBox(Report);
cmbReport.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">95</span>, <span style="color:#22c0ff">20</span>));

<span style="color:#6080ff">String</span> Province[] <span style="color:#ffffa0">=</span> {<span style="color:#ff2020">"กรุงเทพมหานคร"</span>,<span style="color:#ff2020">"กระบี่"</span>,<span style="color:#ff2020">"กาญจนบุรี"</span>,<span style="color:#ff2020">"กาฬสินธุ์"</span>,
<span style="color:#ff2020">"กำแพงเพชร"</span>,<span style="color:#ff2020">"ขอนแก่น"</span>,<span style="color:#ff2020">"จันทบุรี"</span>,<span style="color:#ff2020">"ฉะเชิงเทรา"</span>,<span style="color:#ff2020">"ชลบุรี"</span>,<span style="color:#ff2020">"ชัยนาท"</span>,<span style="color:#ff2020">"ชัยภูมิ"</span>,
<span style="color:#ff2020">"ชุมพร"</span>,<span style="color:#ff2020">"เชียงราย"</span>,<span style="color:#ff2020">"เชียงใหม่"</span>,<span style="color:#ff2020">"ตรัง"</span>,<span style="color:#ff2020">"ตราด"</span>,<span style="color:#ff2020">"ตาก"</span>,<span style="color:#ff2020">"นครนายก"</span>,<span style="color:#ff2020">"นครปฐม"</span>,
<span style="color:#ff2020">"นครพนม"</span>,<span style="color:#ff2020">"นครราชสีมา"</span>,<span style="color:#ff2020">"นครศรีธรรมราช"</span>,<span style="color:#ff2020">"นครสวรรค์"</span>,<span style="color:#ff2020">"นนทบุรี"</span>,<span style="color:#ff2020">"นราธิวาส"</span>,
<span style="color:#ff2020">"น่าน"</span>,<span style="color:#ff2020">"บึงกาฬ"</span>,<span style="color:#ff2020">"บุรีรัมย์"</span>,<span style="color:#ff2020">"ปทุมธานี"</span>,<span style="color:#ff2020">"ประจวบคีรีขันธ์"</span>,<span style="color:#ff2020">"ปราจีนบุรี"</span>,<span style="color:#ff2020">"ปัตตานี"</span>,
<span style="color:#ff2020">"พระนครศรีอยุธยา"</span>,<span style="color:#ff2020">"พะเยา"</span>,<span style="color:#ff2020">"พังงา"</span>,<span style="color:#ff2020">"พัทลุง"</span>,<span style="color:#ff2020">"พิจิตร"</span>,<span style="color:#ff2020">"พิษณุโลก"</span>,<span style="color:#ff2020">"เพชรบุรี"</span>,
<span style="color:#ff2020">"เพชรบูรณ์"</span>,<span style="color:#ff2020">"แพร่"</span>,<span style="color:#ff2020">"ภูเก็ต"</span>,<span style="color:#ff2020">"มหาสารคาม"</span>,<span style="color:#ff2020">"มุกดาหาร"</span>,<span style="color:#ff2020">"แม่ฮ่องสอน"</span>,<span style="color:#ff2020">"ยะลา"</span>,
<span style="color:#ff2020">"ยโสธร"</span>,<span style="color:#ff2020">"ระนอง"</span>,<span style="color:#ff2020">"ระยอง"</span>,<span style="color:#ff2020">"ราชบุรี"</span>,<span style="color:#ff2020">"ร้อยเอ็ด"</span>,<span style="color:#ff2020">"ลพบุรี"</span>,<span style="color:#ff2020">"ลำปาง"</span>,<span style="color:#ff2020">"ลำพูน"</span>,
<span style="color:#ff2020">"เลย"</span>,<span style="color:#ff2020">"ศรีสะเกษ"</span>,<span style="color:#ff2020">"สกลนคร"</span>,<span style="color:#ff2020">"สงขลา"</span>,<span style="color:#ff2020">"สตูล"</span>,<span style="color:#ff2020">"สมุทรปราการ"</span>,<span style="color:#ff2020">"สมุทรสงคราม"</span>,
<span style="color:#ff2020">"สมุทรสาคร"</span>,<span style="color:#ff2020">"สระบุรี"</span>,<span style="color:#ff2020">"สระแก้ว"</span>,<span style="color:#ff2020">"สิงห์บุรี"</span>,<span style="color:#ff2020">"สุพรรณบุรี"</span>,<span style="color:#ff2020">"สุราษฎร์ธานี"</span>,<span style="color:#ff2020">"สุรินทร์"</span>,
<span style="color:#ff2020">"สุโขทัย"</span>,<span style="color:#ff2020">"หนองคาย"</span>,<span style="color:#ff2020">"หนองบัวลำภู"</span>,<span style="color:#ff2020">"อำนาจเจริญ"</span>,<span style="color:#ff2020">"อุดรธานี"</span>,<span style="color:#ff2020">"อุตรดิตถ์"</span>,
<span style="color:#ff2020">"อุทัยธานี"</span>,<span style="color:#ff2020">"อ่างทอง"</span>,<span style="color:#ff2020">"อุบลราชธานี"</span>};
cmbProvince <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> JComboBox(Province);
cmbProvince.setPreferredSize(<span style="color:#ffffa0">new</span> Dimension(<span style="color:#22c0ff">140</span>, <span style="color:#22c0ff">20</span>));



<span style="color:#709070;font-style:italic">//=====add lbl==============================</span>
contentPane.add(lblCodePK);
contentPane.add(lblSexFK);
contentPane.add(lblFirstName);
contentPane.add(lblLastName);
contentPane.add(lblIDCard);
contentPane.add(lblBirthDate);
contentPane.add(lblBanID);
contentPane.add(lblMoo);
contentPane.add(lblTambol);
contentPane.add(lblDistrict);
contentPane.add(lblProvince);
contentPane.add(lblDiag);
contentPane.add(lblIntolerance);
contentPane.add(lblInspectionDate);
contentPane.add(lblReport);
contentPane.add(lblDoctorDate);
contentPane.add(lblSearch);
contentPane.add(lblDateAdd);


<span style="color:#709070;font-style:italic">//=====add txt==============================</span>
contentPane.add(txtCodePK);
contentPane.add(txtCodeID);
contentPane.add(txtFirstName);
contentPane.add(txtLastName);
contentPane.add(txtIDCard);
contentPane.add(txtBanID);
contentPane.add(txtMoo);
contentPane.add(txtTambol);
contentPane.add(txtDistrict);
contentPane.add(txtDiag);
contentPane.add(txtIntolerance);
contentPane.add(txtInspectionDate);
contentPane.add(txtDoctorDate);
contentPane.add(txtSearch);
contentPane.add(txtDateAdd);

<span style="color:#709070;font-style:italic">//======add button==========================</span>
contentPane.add(btnGenID);
contentPane.add(btnAdd);
contentPane.add(btnEdit);
contentPane.add(btnDelete);
contentPane.add(btnRefresh);
contentPane.add(btnSearch);

<span style="color:#709070;font-style:italic">//======add combobox========================</span>
contentPane.add(cmbSexFK);
contentPane.add(cmbTitleFK);
contentPane.add(cmbReport);
contentPane.add(cmbProvince);

<span style="color:#709070;font-style:italic">//===================lblCodePK===========================================</span>
layout.putConstraint(SpringLayout.WEST, lblCodePK, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblCodePK, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblSex==============================================</span>
layout.putConstraint(SpringLayout.WEST, lblSexFK, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSexFK, <span style="color:#22c0ff">30</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblFirstName=========================================</span>
layout.putConstraint(SpringLayout.WEST, lblFirstName, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblFirstName, <span style="color:#22c0ff">55</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblLastName=========================================</span>
layout.putConstraint(SpringLayout.WEST, lblLastName, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblLastName, <span style="color:#22c0ff">80</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblIDCard===========================================</span>
layout.putConstraint(SpringLayout.WEST, lblIDCard, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIDCard, <span style="color:#22c0ff">105</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblBirthDate=========================================</span>
layout.putConstraint(SpringLayout.WEST, lblBirthDate, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBirthDate, <span style="color:#22c0ff">130</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblBanID============================================</span>
layout.putConstraint(SpringLayout.WEST, lblBanID, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBanID, <span style="color:#22c0ff">155</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblMoo==============================================</span>
layout.putConstraint(SpringLayout.WEST, lblMoo, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblMoo, <span style="color:#22c0ff">180</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblTambol===========================================</span>
layout.putConstraint(SpringLayout.WEST, lblTambol, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblTambol, <span style="color:#22c0ff">205</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblDistrict=========================================</span>
layout.putConstraint(SpringLayout.WEST, lblDistrict, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDistrict, <span style="color:#22c0ff">230</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblProvince=========================================</span>
layout.putConstraint(SpringLayout.WEST, lblProvince, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblProvince, <span style="color:#22c0ff">255</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblDiag=============================================</span>
layout.putConstraint(SpringLayout.WEST, lblDiag, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDiag, <span style="color:#22c0ff">280</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblIntolerance======================================</span>
layout.putConstraint(SpringLayout.WEST, lblIntolerance, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblIntolerance, <span style="color:#22c0ff">305</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblInspectionDate===================================</span>
layout.putConstraint(SpringLayout.WEST, lblInspectionDate, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblInspectionDate, <span style="color:#22c0ff">330</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblReport==========================================</span>
layout.putConstraint(SpringLayout.WEST, lblReport, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblReport, <span style="color:#22c0ff">355</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblDoctorDate=======================================</span>
layout.putConstraint(SpringLayout.WEST, lblDoctorDate, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDoctorDate, <span style="color:#22c0ff">380</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================lblSearch==========================================</span>
layout.putConstraint(SpringLayout.WEST, lblSearch, <span style="color:#22c0ff">10</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSearch, <span style="color:#22c0ff">405</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>





<span style="color:#709070;font-style:italic">//==================txtCodePK============================================</span>
layout.putConstraint(SpringLayout.WEST, txtCodePK, <span style="color:#22c0ff">115</span>,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodePK, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtCodeID============================================</span>
layout.putConstraint(SpringLayout.WEST, txtCodeID, <span style="color:#22c0ff">260</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtCodeID, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================cmbSexFK=============================================</span>
layout.putConstraint(SpringLayout.WEST, cmbSexFK, <span style="color:#22c0ff">115</span>,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbSexFK, <span style="color:#22c0ff">30</span>,SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================cmbTitleFK=============================================</span>
layout.putConstraint(SpringLayout.WEST, cmbTitleFK, <span style="color:#22c0ff">265</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbTitleFK, <span style="color:#22c0ff">30</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtFirstName==========================================</span>
layout.putConstraint(SpringLayout.WEST, txtFirstName, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtFirstName, <span style="color:#22c0ff">55</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtLastName==========================================</span>
layout.putConstraint(SpringLayout.WEST, txtLastName, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtLastName, <span style="color:#22c0ff">80</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtIDCard============================================</span>
layout.putConstraint(SpringLayout.WEST, txtIDCard, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIDCard, <span style="color:#22c0ff">105</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtBirthDate=========================================</span>
layout.putConstraint(SpringLayout.WEST, txtBirthDate, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBirthDate, <span style="color:#22c0ff">130</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtBanID=============================================</span>
layout.putConstraint(SpringLayout.WEST, txtBanID, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtBanID, <span style="color:#22c0ff">155</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtMoo===============================================</span>
layout.putConstraint(SpringLayout.WEST, txtMoo, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtMoo, <span style="color:#22c0ff">180</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtTambol============================================</span>
layout.putConstraint(SpringLayout.WEST, txtTambol, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtTambol, <span style="color:#22c0ff">205</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtDistrict==========================================</span>
layout.putConstraint(SpringLayout.WEST, txtDistrict, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDistrict, <span style="color:#22c0ff">230</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================cmbProvince==========================================</span>
layout.putConstraint(SpringLayout.WEST, cmbProvince, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbProvince, <span style="color:#22c0ff">255</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtDiag=============================================</span>
layout.putConstraint(SpringLayout.WEST, txtDiag, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDiag, <span style="color:#22c0ff">280</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtIntolerance=======================================</span>
layout.putConstraint(SpringLayout.WEST, txtIntolerance, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtIntolerance, <span style="color:#22c0ff">305</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtInspectionDate====================================</span>
layout.putConstraint(SpringLayout.WEST, txtInspectionDate, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtInspectionDate, <span style="color:#22c0ff">330</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================cmbReport===========================================</span>
layout.putConstraint(SpringLayout.WEST, cmbReport, <span style="color:#22c0ff">115</span>,SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, cmbReport, <span style="color:#22c0ff">355</span>,SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//==================txtDoctorDate========================================</span>
layout.putConstraint(SpringLayout.WEST, txtDoctorDate, <span style="color:#22c0ff">115</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDoctorDate, <span style="color:#22c0ff">380</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================txtSearch==========================================</span>
layout.putConstraint(SpringLayout.WEST, txtSearch, <span style="color:#22c0ff">165</span>, SpringLayout.WEST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtSearch, <span style="color:#22c0ff">405</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>


<span style="color:#709070;font-style:italic">//===================lblDateAdd==========================================</span>
layout.putConstraint(SpringLayout.WEST, lblDateAdd, <span style="color:#22c0ff">440</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblDateAdd, <span style="color:#22c0ff">280</span>, SpringLayout.NORTH, contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================txtDateAdd==========================================</span>
layout.putConstraint(SpringLayout.WEST, txtDateAdd,<span style="color:#22c0ff">380</span>, SpringLayout.EAST, lblCodePK);
layout.putConstraint(SpringLayout.NORTH, txtDateAdd, <span style="color:#22c0ff">305</span>, SpringLayout.NORTH, contentPane);
txtDateAdd.setEnabled(false);
<span style="color:#709070;font-style:italic">//txtDateAdd.setText("");</span>
<span style="color:#6080ff">String</span> dateString <span style="color:#ffffa0">=</span> <span style="color:#6080ff">String</span>.format(<span style="color:#ff2020">"%1$tY-%1$tm-%1$td"</span>, date);
txtDateAdd.setText(dateString);
<span style="color:#709070;font-style:italic">//txtDateAdd.setForeground(Color.blue);</span>
<span style="color:#709070;font-style:italic">//=======================================================================</span>




<span style="color:#709070;font-style:italic">//===================btnGenID============================================</span>
layout.putConstraint(SpringLayout.WEST, btnGenID, <span style="color:#22c0ff">440</span>, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnGenID, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH,contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================btnAdd==============================================</span>
layout.putConstraint(SpringLayout.WEST, btnAdd, <span style="color:#22c0ff">540</span>, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnAdd, <span style="color:#22c0ff">5</span>, SpringLayout.NORTH,contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================btnEdit============================================</span>
layout.putConstraint(SpringLayout.WEST, btnEdit, <span style="color:#22c0ff">540</span>, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnEdit, <span style="color:#22c0ff">35</span>, SpringLayout.NORTH,contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================btnRefresh=========================================</span>
layout.putConstraint(SpringLayout.WEST, btnRefresh, <span style="color:#22c0ff">540</span>, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, <span style="color:#22c0ff">65</span>, SpringLayout.NORTH,contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================btnDelte============================================</span>
layout.putConstraint(SpringLayout.WEST, btnDelete, <span style="color:#22c0ff">540</span>, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnDelete, <span style="color:#22c0ff">280</span>, SpringLayout.NORTH,contentPane);
<span style="color:#709070;font-style:italic">//=======================================================================</span>

<span style="color:#709070;font-style:italic">//===================btnSeach============================================</span>
layout.putConstraint(SpringLayout.WEST, btnSearch, <span style="color:#22c0ff">295</span>, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, btnSearch, <span style="color:#22c0ff">405</span>, SpringLayout.NORTH,contentPane);
<span style="color:#709070;font-style:italic">//======================================================================= </span>

<span style="color:#709070;font-style:italic">//=========Button Command=================================</span>
btnRefresh.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnGenID.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnAdd.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnEdit.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnDelete.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnRefresh.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
btnSearch.addActionListener(<span style="color:#ffffa0">new</span> ButtonListener());
txtSearch.addActionListener(<span style="color:#ffffa0">new</span> TextListener());
<span style="color:#709070;font-style:italic">//=========Clear TextBox================================== </span>
txtCodePK.setText(<span style="color:#ff2020">""</span>);
txtCodeID.setText(<span style="color:#ff2020">""</span>);
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText(<span style="color:#ff2020">""</span>);
txtLastName.setText(<span style="color:#ff2020">""</span>);
txtIDCard.setText(<span style="color:#ff2020">""</span>);
txtBanID.setText(<span style="color:#ff2020">""</span>);
txtMoo.setText(<span style="color:#ff2020">""</span>);
txtTambol.setText(<span style="color:#ff2020">""</span>);
txtDistrict.setText(<span style="color:#ff2020">""</span>);
cmbProvince.setSelectedItem(null);
txtDiag.setText(<span style="color:#ff2020">""</span>);
txtIntolerance.setText(<span style="color:#ff2020">""</span>);
cmbReport.setSelectedItem(null);
txtSearch.setText(<span style="color:#ff2020">""</span>);

<span style="color:#709070;font-style:italic">//=====================txtMoo Only Number=================</span>
txtMoo.addKeyListener(<span style="color:#ffffa0">new</span> KeyAdapter(){
@Override
<span style="color:#ffffa0">public</span> void keyReleased(KeyEvent e) {
JTextField txtMoo <span style="color:#ffffa0">=</span> (JTextField) e.getSource();
<span style="color:#6080ff">String</span> str <span style="color:#ffffa0">=</span> txtMoo.getText();
txtMoo.setText(str.replaceAll(<span style="color:#ff2020">"[^0-9]"</span>, <span style="color:#ff2020">""</span>));
}
});
<span style="color:#709070;font-style:italic">//========================================================</span>

<span style="color:#709070;font-style:italic">//Display the window.</span>

frame.pack();
frame.setVisible(true);
frame.setSize(<span style="color:#22c0ff">670</span>,<span style="color:#22c0ff">480</span>);<span style="color:#709070;font-style:italic">//800,645</span>
frame.setResizable(false);<span style="color:#709070;font-style:italic">//ไม่ให้ Resize</span>
frame.setLocationRelativeTo(null);
}

<span style="color:#709070;font-style:italic">//==============txtSearch KeyPress=========================================</span>
<span style="color:#ffffa0">private</span> <span style="color:#6080ff">class</span> <span style="color:#f09040">TextListener</span> <span style="color:#ffffa0">implements</span> ActionListener
{
@Override
@SuppressWarnings(<span style="color:#ff2020">"UseSpecificCatch"</span>)
<span style="color:#ffffa0">public</span> void actionPerformed(ActionEvent ae) {
Object source <span style="color:#ffffa0">=</span> ae.getSource();
<span style="color:#709070;font-style:italic">//===========txtSearch====================</span>
<span style="color:#ffffa0">if</span>(source <span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> txtSearch){
<span style="color:#ffffa0">if</span>((txtSearch.getText().equals(<span style="color:#ff2020">""</span>)) <span style="color:#ffffa0">&amp;</span><span style="color:#ffffa0">&amp;</span> txtCodePK.getText().equals(<span style="color:#ff2020">""</span>)){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
<span style="color:#709070;font-style:italic">//return; </span>
}<span style="color:#ffffa0">else</span> {
btnSearch.doClick();<span style="color:#709070;font-style:italic">//แทนการ Click btnSeach</span>
}
}
}
}
<span style="color:#709070;font-style:italic">//===================End txtSearch KeyPress============================</span>

<span style="color:#ffffa0">private</span> <span style="color:#6080ff">class</span> <span style="color:#f09040">ButtonListener</span> <span style="color:#ffffa0">implements</span> ActionListener
{
@Override
<span style="color:#ffffa0">public</span> void actionPerformed(ActionEvent ae) {
Object source <span style="color:#ffffa0">=</span> ae.getSource();
<span style="color:#709070;font-style:italic">//===========btnRefresh====================</span>
<span style="color:#ffffa0">if</span>(source <span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> btnRefresh){
txtCodePK.setText(<span style="color:#ff2020">""</span>);
txtCodeID.setText(<span style="color:#ff2020">""</span>);
cmbSexFK.setSelectedItem(null);
cmbTitleFK.setSelectedItem(null);
txtFirstName.setText(<span style="color:#ff2020">""</span>);
txtLastName.setText(<span style="color:#ff2020">""</span>);
txtIDCard.setText(<span style="color:#ff2020">""</span>);
txtBanID.setText(<span style="color:#ff2020">""</span>);
txtMoo.setText(<span style="color:#ff2020">""</span>);
txtTambol.setText(<span style="color:#ff2020">""</span>);
txtDistrict.setText(<span style="color:#ff2020">""</span>);
cmbProvince.setSelectedItem(null);
txtDiag.setText(<span style="color:#ff2020">""</span>);
txtIntolerance.setText(<span style="color:#ff2020">""</span>);
cmbReport.setSelectedItem(null);
txtSearch.setText(<span style="color:#ff2020">""</span>);
<span style="color:#709070;font-style:italic">//==========เปิดปุ่มและ textBox================</span>
btnGenID.setEnabled(true);
btnAdd.setEnabled(true);
btnEdit.setEnabled(true);
btnDelete.setEnabled(true);
btnSearch.setEnabled(true);
txtSearch.setEnabled(true);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
<span style="color:#709070;font-style:italic">//=========================================</span>
}
<span style="color:#709070;font-style:italic">//===========btnGenID===================================</span>
<span style="color:#ffffa0">if</span>(source<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span>btnGenID){
try{
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);
<span style="color:#709070;font-style:italic">//JOptionPane.showMessageDialog(null,"Connect Database Successfully","รายงานสถานะ",</span>
<span style="color:#709070;font-style:italic">// JOptionPane.INFORMATION_MESSAGE); </span>
<span style="color:#6080ff">String</span> sql <span style="color:#ffffa0">=</span> <span style="color:#ff2020">"SELECT max(CodePK) FROM tblhosjava"</span>;<span style="color:#709070;font-style:italic">//ใช้กับ MySQL</span>
<span style="color:#709070;font-style:italic">//String sql = "SELECT nvl(max(CodePK),0) FROM tblHelp"; //ใช้กับ MS Access 2003</span>
pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(sql);
rs <span style="color:#ffffa0">=</span> pstmt.executeQuery();

<span style="color:#ffffa0">if</span> (rs.next()) {

int maxID <span style="color:#ffffa0">=</span> rs.getInt(<span style="color:#22c0ff">1</span>)<span style="color:#ffffa0">+</span><span style="color:#22c0ff">1</span>;

txtCodePK.setText(<span style="color:#6080ff">String</span>.valueOf(maxID));
<span style="color:#709070;font-style:italic">//txtCodePK.setForeground(Color.red);</span>
<span style="color:#6080ff">String</span> paded <span style="color:#ffffa0">=</span> <span style="color:#6080ff">String</span>.format(<span style="color:#ff2020">"%10s"</span>,<span style="color:#6080ff">String</span>.valueOf(maxID)).replace(<span style="color:#ff2020">' '</span>, <span style="color:#ff2020">'0'</span>);
<span style="color:#709070;font-style:italic">//txtCodeID.setText(paded);</span>
txtCodeID.setText(<span style="color:#ff2020">"HN"</span><span style="color:#ffffa0">+</span>paded);
<span style="color:#709070;font-style:italic">//==========ปิดปุ่มและ textBox====================</span>
btnGenID.setEnabled(false);
btnAdd.setEnabled(true);
btnEdit.setEnabled(false);
btnDelete.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
<span style="color:#709070;font-style:italic">//=============================================</span>
}
connect.close();
rs.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"Error GenID Auto !<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>ex.getMessage());
}
}
<span style="color:#ffffa0">if</span>(source<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span>btnAdd){
<span style="color:#ffffa0">if</span>(txtCodePK.getText().equals(<span style="color:#ff2020">""</span>)){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณากดปุ่ม GenID ด้วยครับ !"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
txtCodePK.requestFocus();
<span style="color:#709070;font-style:italic">//return; </span>
}<span style="color:#ffffa0">else</span> <span style="color:#ffffa0">if</span>(cmbSexFK.getSelectedItem()<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> null){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาเลือก เพศ ด้วยครับ !"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
}<span style="color:#ffffa0">else</span> <span style="color:#ffffa0">if</span>(cmbTitleFK.getSelectedItem()<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> null){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาเลือก คำนำหน้าชื่อ ด้วยครับ !"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
}<span style="color:#ffffa0">else</span> <span style="color:#ffffa0">if</span>(txtFirstName.getText().equals(<span style="color:#ff2020">""</span>)){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาพิมพ์ ชื่อ ด้วยครับ !"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
txtFirstName.requestFocus();
}<span style="color:#ffffa0">else</span> <span style="color:#ffffa0">if</span>(cmbProvince.getSelectedItem()<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> null){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาเลือก จังหวัด ด้วยครับ !"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
}<span style="color:#ffffa0">else</span> <span style="color:#ffffa0">if</span>(cmbReport.getSelectedItem()<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span> null){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาเลือก รายงาน ด้วยครับ !"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
}<span style="color:#ffffa0">else</span>{
<span style="color:#709070;font-style:italic">//==============Variable==========================</span>
<span style="color:#6080ff">String</span> CodePK <span style="color:#ffffa0">=</span> txtCodePK.getText();
<span style="color:#6080ff">String</span> CodeID <span style="color:#ffffa0">=</span> txtCodeID.getText();
<span style="color:#6080ff">String</span> Sex <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbSexFK.getSelectedItem();
<span style="color:#6080ff">String</span> Title <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbTitleFK.getSelectedItem();
<span style="color:#6080ff">String</span> FirstName <span style="color:#ffffa0">=</span> txtFirstName.getText();
<span style="color:#6080ff">String</span> LastName <span style="color:#ffffa0">=</span> txtLastName.getText();
<span style="color:#6080ff">String</span> IDCard <span style="color:#ffffa0">=</span> txtIDCard.getText();
<span style="color:#6080ff">String</span> BanID <span style="color:#ffffa0">=</span> txtBanID.getText();
<span style="color:#6080ff">String</span> Moo <span style="color:#ffffa0">=</span> txtMoo.getText();
<span style="color:#6080ff">String</span> Tambol <span style="color:#ffffa0">=</span> txtTambol.getText();
<span style="color:#6080ff">String</span> District <span style="color:#ffffa0">=</span> txtDistrict.getText();
<span style="color:#6080ff">String</span> Province <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbProvince.getSelectedItem();
<span style="color:#6080ff">String</span> Diag <span style="color:#ffffa0">=</span> txtDiag.getText();
<span style="color:#6080ff">String</span> Intolerance <span style="color:#ffffa0">=</span> txtIntolerance.getText();
<span style="color:#6080ff">String</span> Report <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbReport.getSelectedItem();

Date date <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> Date();
<span style="color:#6080ff">String</span> dateString <span style="color:#ffffa0">=</span> <span style="color:#6080ff">String</span>.format(<span style="color:#ff2020">"%1$tY-%1$tm-%1$td"</span>, date);


try {
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);

pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(<span style="color:#ff2020">"INSERT INTO tblhosjava"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"(CodePK,CodeID,SexFK,TitleFK,FirstName,LastName,IDCard,BirthDate,"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"BanID,Moo,Tambol,District,Province,Diag,Intolerance,"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"InspectionDate,Report,DoctorDate,DateAdd)"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"</span>);

pstmt.setString(<span style="color:#22c0ff">1</span>, CodePK);
pstmt.setString(<span style="color:#22c0ff">2</span>, CodeID);
pstmt.setString(<span style="color:#22c0ff">3</span>, Sex);
pstmt.setString(<span style="color:#22c0ff">4</span>, Title);
pstmt.setString(<span style="color:#22c0ff">5</span>, FirstName);
pstmt.setString(<span style="color:#22c0ff">6</span>, LastName);
pstmt.setString(<span style="color:#22c0ff">7</span>, IDCard);
pstmt.setDate(<span style="color:#22c0ff">8</span>, convertUtilDateToSqlDate(txtBirthDate.getDate()));
pstmt.setString(<span style="color:#22c0ff">9</span>, BanID);
pstmt.setString(<span style="color:#22c0ff">10</span>, Moo);
pstmt.setString(<span style="color:#22c0ff">11</span>, Tambol);
pstmt.setString(<span style="color:#22c0ff">12</span>, District);
pstmt.setString(<span style="color:#22c0ff">13</span>, Province);
pstmt.setString(<span style="color:#22c0ff">14</span>, Diag);
pstmt.setString(<span style="color:#22c0ff">15</span>, Intolerance);
pstmt.setDate(<span style="color:#22c0ff">16</span>, convertUtilDateToSqlDate(txtInspectionDate.getDate()));
pstmt.setString(<span style="color:#22c0ff">17</span>, Report);
pstmt.setDate(<span style="color:#22c0ff">18</span>, convertUtilDateToSqlDate(txtDoctorDate.getDate()));
pstmt.setString(<span style="color:#22c0ff">19</span>, dateString);

pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"บันทึกข้อมูลเรียบร้อยแล้ว"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();<span style="color:#709070;font-style:italic">//สั่ง Clear All</span>

connect.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException | HeadlessException e){
JOptionPane.showMessageDialog(null, <span style="color:#ff2020">"Error Insert to Database !<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>e.getMessage());
}
}
}
<span style="color:#ffffa0">if</span>(source<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span>btnSearch){
<span style="color:#ffffa0">if</span>((txtSearch.getText().equals(<span style="color:#ff2020">""</span>)) <span style="color:#ffffa0">&amp;</span><span style="color:#ffffa0">&amp;</span> txtCodePK.getText().equals(<span style="color:#ff2020">""</span>)){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}<span style="color:#ffffa0">else</span> {
try{
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);

<span style="color:#6080ff">String</span> sql <span style="color:#ffffa0">=</span> <span style="color:#ff2020">"Select * from tblhosjava "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Where CodePK LIKE '"</span> <span style="color:#ffffa0">+</span> txtSearch.getText() <span style="color:#ffffa0">+</span> <span style="color:#ff2020">"' "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"OR IDCard LIKE '"</span> <span style="color:#ffffa0">+</span> txtSearch.getText() <span style="color:#ffffa0">+</span> <span style="color:#ff2020">"'"</span> ;
pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(sql);
rs <span style="color:#ffffa0">=</span> pstmt.executeQuery();

<span style="color:#ffffa0">if</span>(<span style="color:#ffffa0">!</span>rs.next() ){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"ไม่พบข้อมูลที่ต้องการค้นหา"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.INFORMATION_MESSAGE);
txtSearch.setText(<span style="color:#ff2020">""</span>);
}<span style="color:#ffffa0">else</span>{
<span style="color:#ffffa0">do</span>{
txtCodePK.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"CodePK"</span>)));
txtCodeID.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"CodeID"</span>)));
cmbSexFK.setSelectedItem(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"SexFK"</span>)));
cmbTitleFK.setSelectedItem(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"TitleFK"</span>)));
txtFirstName.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"FirstName"</span>)));
txtLastName.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"LastName"</span>)));
txtIDCard.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"IDCard"</span>)));
txtBirthDate.setDate(rs.getDate(<span style="color:#ff2020">"BirthDate"</span>));
txtBanID.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"BanID"</span>)));
txtMoo.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"Moo"</span>)));
txtTambol.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"Tambol"</span>)));
txtDistrict.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"District"</span>)));
cmbProvince.setSelectedItem(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"Province"</span>)));
txtDiag.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"Diag"</span>)));
txtIntolerance.setText(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"Intolerance"</span>)));
txtInspectionDate.setDate(rs.getDate(<span style="color:#ff2020">"InspectionDate"</span>));
cmbReport.setSelectedItem(<span style="color:#6080ff">String</span>.valueOf(rs.getString(<span style="color:#ff2020">"Report"</span>)));
txtDoctorDate.setDate(rs.getDate(<span style="color:#ff2020">"DoctorDate"</span>));

<span style="color:#709070;font-style:italic">//===========================================================</span>
<span style="color:#709070;font-style:italic">//ปิดปุ่มและtextBox</span>
btnGenID.setEnabled(false);
btnAdd.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
}<span style="color:#ffffa0">while</span> (rs.next());
}
connect.close();
rs.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException ex){
JOptionPane.showMessageDialog(null, <span style="color:#ff2020">"ไม่สามารถแสดงข้อมูลได้!<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>ex.getMessage());
}
}
}
<span style="color:#ffffa0">if</span>(source<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span>btnEdit){
<span style="color:#ffffa0">if</span>((txtSearch.getText().equals(<span style="color:#ff2020">""</span>)) <span style="color:#ffffa0">&amp;</span><span style="color:#ffffa0">&amp;</span> txtCodePK.getText().equals(<span style="color:#ff2020">""</span>)){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}<span style="color:#ffffa0">else</span> {

int CodePK <span style="color:#ffffa0">=</span> Integer.parseInt(txtCodePK.getText());
<span style="color:#6080ff">String</span> Sex <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbSexFK.getSelectedItem();
<span style="color:#6080ff">String</span> Title <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbTitleFK.getSelectedItem();
<span style="color:#6080ff">String</span> FirstName <span style="color:#ffffa0">=</span> txtFirstName.getText();
<span style="color:#6080ff">String</span> LastName <span style="color:#ffffa0">=</span> txtLastName.getText();
<span style="color:#6080ff">String</span> IDCard <span style="color:#ffffa0">=</span> txtIDCard.getText();
<span style="color:#6080ff">String</span> BanID <span style="color:#ffffa0">=</span> txtBanID.getText();
<span style="color:#6080ff">String</span> Moo <span style="color:#ffffa0">=</span> txtMoo.getText();
<span style="color:#6080ff">String</span> Tambol <span style="color:#ffffa0">=</span> txtTambol.getText();
<span style="color:#6080ff">String</span> District <span style="color:#ffffa0">=</span> txtDistrict.getText();
<span style="color:#6080ff">String</span> Province <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbProvince.getSelectedItem();
<span style="color:#6080ff">String</span> Diag <span style="color:#ffffa0">=</span> txtDiag.getText();
<span style="color:#6080ff">String</span> Intolerance <span style="color:#ffffa0">=</span> txtIntolerance.getText();
<span style="color:#6080ff">String</span> Report <span style="color:#ffffa0">=</span> (<span style="color:#6080ff">String</span>)cmbReport.getSelectedItem();

try {
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);
pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(<span style="color:#ff2020">"UPDATE tblhosjava SET "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"SexFK = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"TitleFK = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"FirstName = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"LastName = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"IDCard = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"BirthDate = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"BanID = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Moo = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Tambol = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"District = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Province = ?,"</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Diag = ?, "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Intolerance = ?, "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"InspectionDate= ?, "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"Report = ?, "</span><span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"DoctorDate = ? "</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"WHERE CodePK = ?"</span>);
pstmt.setString(<span style="color:#22c0ff">1</span>, Sex);
pstmt.setString(<span style="color:#22c0ff">2</span>, Title);
pstmt.setString(<span style="color:#22c0ff">3</span>, FirstName);
pstmt.setString(<span style="color:#22c0ff">4</span>, LastName);
pstmt.setString(<span style="color:#22c0ff">5</span>, IDCard);
pstmt.setDate(<span style="color:#22c0ff">6</span>, convertUtilDateToSqlDate(txtBirthDate.getDate()));
pstmt.setString(<span style="color:#22c0ff">7</span>, BanID);
pstmt.setString(<span style="color:#22c0ff">8</span>, Moo);
pstmt.setString(<span style="color:#22c0ff">9</span>, Tambol);
pstmt.setString(<span style="color:#22c0ff">10</span>, District);
pstmt.setString(<span style="color:#22c0ff">11</span>, Province);
pstmt.setString(<span style="color:#22c0ff">12</span>, Diag);
pstmt.setString(<span style="color:#22c0ff">13</span>, Intolerance);
pstmt.setDate(<span style="color:#22c0ff">14</span>, convertUtilDateToSqlDate(txtInspectionDate.getDate()));
pstmt.setString(<span style="color:#22c0ff">15</span>, Report);
pstmt.setDate(<span style="color:#22c0ff">16</span>, convertUtilDateToSqlDate(txtDoctorDate.getDate()));
pstmt.setInt(<span style="color:#22c0ff">17</span>, CodePK);

pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"แก้ไขข้อมูลเรียบร้อยแล้ว"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();<span style="color:#709070;font-style:italic">//สั่ง Clear All</span>
txtSearch.requestFocus();

connect.close();
pstmt.close();

}catch(ClassNotFoundException | SQLException e){
JOptionPane.showMessageDialog(null, <span style="color:#ff2020">"Error Update to Database !<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>e.getMessage());
}
}
}
<span style="color:#ffffa0">if</span>(source<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span>btnDelete){
<span style="color:#ffffa0">if</span>((txtSearch.getText().equals(<span style="color:#ff2020">""</span>)) <span style="color:#ffffa0">&amp;</span><span style="color:#ffffa0">&amp;</span> txtCodePK.getText().equals(<span style="color:#ff2020">""</span>)){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}<span style="color:#ffffa0">else</span> {
<span style="color:#709070;font-style:italic">//==================Do it=============================</span>
int conf <span style="color:#ffffa0">=</span> JOptionPane.showConfirmDialog(null,<span style="color:#ff2020">"คุณต้องการลบข้อมูลลำดับที่ : "</span> <span style="color:#ffffa0">+</span>txtSearch.getText()<span style="color:#ffffa0">+</span><span style="color:#ff2020">" หรือไม่"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.YES_NO_OPTION);
<span style="color:#ffffa0">if</span>(conf<span style="color:#ffffa0">=</span><span style="color:#ffffa0">=</span><span style="color:#22c0ff">0</span>){
int CodePK <span style="color:#ffffa0">=</span> Integer.parseInt(txtCodePK.getText());
try {
Class.forName(<span style="color:#ff2020">"org.mariadb.jdbc.Driver"</span>);
connect <span style="color:#ffffa0">=</span> DriverManager.getConnection(<span style="color:#ff2020">"jdbc:mariadb://localhost/dbhosjava"</span> <span style="color:#ffffa0">+</span>
<span style="color:#ff2020">"?user=root&amp;password=gomplayer"</span>);

pstmt <span style="color:#ffffa0">=</span> connect.prepareStatement(<span style="color:#ff2020">"DELETE FROM tblhosjava WHERE CodePK = ?"</span>);
pstmt.setInt(<span style="color:#22c0ff">1</span>, CodePK);
pstmt.executeUpdate();

JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"ลบข้อมูลเรียบร้อยแล้ว"</span>,<span style="color:#ff2020">"รายงานสถานะ"</span>,JOptionPane.INFORMATION_MESSAGE);
btnRefresh.doClick();

connect.close();
pstmt.close();
}catch(ClassNotFoundException | SQLException | HeadlessException ex){
JOptionPane.showMessageDialog(null,<span style="color:#ff2020">"ลบข้อมูลผิดพลาด!<span style="color:#ff8080">\n</span>"</span><span style="color:#ffffa0">+</span>ex.getMessage());
}
}
}
}
}
}

<span style="color:#ffffa0">private</span> java.sql.Date convertUtilDateToSqlDate(Date date) {
<span style="color:#ffffa0">if</span>(date <span style="color:#ffffa0">!</span><span style="color:#ffffa0">=</span> null) {
java.sql.Date sqlDate <span style="color:#ffffa0">=</span> <span style="color:#ffffa0">new</span> java.sql.Date(date.getTime());
<span style="color:#ffffa0">return</span> sqlDate;
}
<span style="color:#ffffa0">return</span> null;
}
}
</pre>

 

ฐานข้อมูล : dbhosjava บน MariaDB
================================
CREATE TABLE `tblhosjava` (
`CodePK` INT(12) NOT NULL,
`CodeID` VARCHAR(12) NOT NULL,
`SexFK` VARCHAR(5) NULL DEFAULT NULL,
`TitleFK` VARCHAR(15) NULL DEFAULT NULL,
`FirstName` VARCHAR(30) NULL DEFAULT NULL,
`LastName` VARCHAR(30) NULL DEFAULT NULL,
`IDCard` VARCHAR(17) NULL DEFAULT NULL,
`BirthDate` DATE NULL DEFAULT NULL,
`BanID` VARCHAR(10) NULL DEFAULT NULL,
`Moo` VARCHAR(3) NULL DEFAULT NULL,
`Tambol` VARCHAR(25) NULL DEFAULT NULL,
`District` VARCHAR(25) NULL DEFAULT NULL,
`Province` VARCHAR(25) NULL DEFAULT NULL,
`Diag` VARCHAR(30) NULL DEFAULT NULL,
`Intolerance` VARCHAR(30) NULL DEFAULT NULL,
`InspectionDate` DATE NULL DEFAULT NULL,
`Report` VARCHAR(10) NULL DEFAULT NULL,
`DoctorDate` DATE NULL DEFAULT NULL,
`DateAdd` DATE NULL DEFAULT NULL,
PRIMARY KEY (`CodePK`)
)
COLLATE='tis620_thai_ci'
ENGINE=InnoDB
;

 

กำลังจะทำบนฐานข้อมูล PostgreSQL 9.6x86