Java NetBeans 7.4x86 กับ PostgreSQL 9.6x86

ledphong · 2 กันยายน 2016

ความแข็งและอึดน่าใช้
อีกอย่างรองรับ iReport 5.5 Support ได้ดี

ledphong · 2 กันยายน 2016

<pre style="background:#000;color:#f8f8f8">package com.java.myolder;

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 static java.lang.Double.parseDouble;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.Locale;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

@SuppressWarnings("ALL")
public class FormPay extends javax.swing.JInternalFrame{

ResultSet rs=null;
Connection connect = null;
PreparedStatement pstmt = null;
final JTextField txtCodePK,txtCodeID,txtBudget;
final JTextField txtGetMoneyOld,txtGetMoneyAcc;
final JTextField txtTotalOldCash,txtMoneyOldCash,txtTotalOldTran,txtMoneyOldTran;
final JTextField txtTotalAccCash,txtMoneyAccCash,txtTotalAccTran,txtMoneyAccTran;
final JTextField txtTotalAidsCash,txtMoneyAidsCash,txtTotalAidsTran,txtMoneyAidsTran;
final JTextField txtWithdrawal,txtBackOld,txtBackAcc,txtSearch;
final JButton btnGenID,btnAdd,btnEdit,btnDelete,btnRefresh,btnSearch;
final JDateChooser txtPayDate;

public FormPay(String ระบบจ่ายเงิน) {
JFrame.setDefaultLookAndFeelDecorated(true);

//Create and set up the window.
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=====================================================
//==========JLabel=========================
JLabel lblCodePK = new JLabel("ลำดับที่ : ");
JLabel lblBudget = new JLabel("ปีงบประมาณ :");
JLabel lblMonth = new JLabel("วัน-เดือน-ปี ที่จ่ายเงินเบี้ย :");
JLabel lblGetMoneyOld = new JLabel("รับเงินจากกรม ผส.(บ):");
JLabel lblGetMoneyAcc = new JLabel("รับเงินจากกรม พก.(บ):");
JLabel lblTotalOldCash = new JLabel("จำนวน ผส.รับเงินสด(คน):");
JLabel lblMoneyOldCash = new JLabel("จำนวนเงิน ผส.(บ):");
JLabel lblTotalOldTran = new JLabel("จำนวน ผส.รับเงินโอน(คน):");
JLabel lblMoneyOldTran = new JLabel("จำนวนเงิน ผส.(บ):");
JLabel lblTotalAccCash = new JLabel("จำนวน พก.รับเงินสด(คน):");
JLabel lblMoneyAccCash = new JLabel("จำนวนเงิน พก.(บ):");
JLabel lblTotalAccTran = new JLabel("จำนวน พก.รับเงินโอน(คน):");
JLabel lblMoneyAccTran = new JLabel("จำนวนเงิน พก.(บ):");
JLabel lblTotalAidsCash = new JLabel("จำนวน Aids.รับเงินสด(คน):");
JLabel lblMoneyAidsCash = new JLabel("จำนวนเงิน Aids.(บ):");
JLabel lblTotalAidsTran = new JLabel("จำนวนAids.เงินโอน(คน):");
JLabel lblMoneyAidsTran = new JLabel("จำนวนเงิน Aids.(บ):");

JLabel lblWithdrawal = new JLabel("เบิกเงินครั้งที่ :");
JLabel lblBackOld = new JLabel("คืนเงินผู้สูงอายุ (บ) :");
JLabel lblBackAcc = new JLabel("คืนเงินผู้พิการ (บ) :");

JLabel lblSearch = new JLabel("ค้นหาลำดับที่ :");

//==========JTextField=====================
txtCodePK = new JTextField("txtCodePK", 10);//txtCodePK.setBackground(Color.pink);
txtCodeID = new JTextField("txtCodeID", 10);//txtCodeID.setBackground(Color.pink);
txtBudget = new JTextField("txtBudget",10);

txtGetMoneyOld = new JTextField("txtGetMoneyOld",10);
txtGetMoneyOld.setBackground(Color.pink);

txtGetMoneyAcc = new JTextField("txtGetMoneyAcc",10);
txtGetMoneyAcc.setBackground(Color.pink);

txtTotalOldCash = new JTextField("txtTotalOldCash",10);
txtMoneyOldCash = new JTextField("txtMoneyOldCash",10);
txtMoneyOldCash.setBackground(Color.pink);

txtTotalOldTran = new JTextField("txtTotalOldTran",10);
txtMoneyOldTran = new JTextField("txtMoneyOldTran",10);
txtMoneyOldTran.setBackground(Color.pink);

txtTotalAccCash = new JTextField("txtTotalAccCash",10);
txtMoneyAccCash = new JTextField("txtMoneyAccCash",10);
txtMoneyAccCash.setBackground(Color.pink);

txtTotalAccTran = new JTextField("txtTotalAccTran",10);
txtMoneyAccTran = new JTextField("txtMoneyAccTran",10);
txtMoneyAccTran.setBackground(Color.pink);

txtTotalAidsCash = new JTextField("txtTotalAidsCash",10);
txtMoneyAidsCash = new JTextField("txtMoneyAidsCash",10);
txtMoneyAidsCash.setBackground(Color.pink);

txtTotalAidsTran = new JTextField("txtTotalAidsTran",10);
txtMoneyAidsTran = new JTextField("txtMoneyAidsTran",10);
txtMoneyAidsTran.setBackground(Color.pink);

txtWithdrawal = new JTextField("txtWithdrawal",10);

txtBackOld = new JTextField("txtBackOld",10);
txtBackOld.setBackground(Color.pink);

txtBackAcc = new JTextField("txtBackAcc",10);
txtBackAcc.setBackground(Color.pink);

txtSearch = new JTextField("txtSearch",10);
txtSearch.setBackground(Color.yellow);

//=====add txt==============================
contentPane.add(txtCodePK);
contentPane.add(txtCodeID);
contentPane.add(txtBudget);
contentPane.add(txtGetMoneyOld);
contentPane.add(txtGetMoneyAcc);
contentPane.add(txtTotalOldCash);
contentPane.add(txtMoneyOldCash);
contentPane.add(txtTotalOldTran);
contentPane.add(txtMoneyOldTran);

contentPane.add(txtTotalAccCash);
contentPane.add(txtMoneyAccCash);
contentPane.add(txtTotalAccTran);
contentPane.add(txtMoneyAccTran);

contentPane.add(txtTotalAidsCash);
contentPane.add(txtMoneyAidsCash);
contentPane.add(txtTotalAidsTran);
contentPane.add(txtMoneyAidsTran);

contentPane.add(txtWithdrawal);
contentPane.add(txtBackOld);
contentPane.add(txtBackAcc);
contentPane.add(txtSearch);

//==========txtPayDate=====================
Locale locale = new Locale ( "en", "US" );//new Locale ( "th", "TH" );
txtPayDate = new JDateChooser ( );
txtPayDate.setPreferredSize(new Dimension(216, 20));
txtPayDate.setLocale ( locale );
Date date = new Date();
txtPayDate.setDate(date);
contentPane.add ( txtPayDate );
//==========================================
//==========JButton=========================
btnGenID = new JButton("GenID");
btnGenID.setPreferredSize(new Dimension(90, 25));
btnAdd = new JButton("เพิ่มข้อมูล");
btnAdd.setPreferredSize(new Dimension(114, 25));
btnEdit = new JButton("แก้ไขข้อมูล");
btnEdit.setPreferredSize(new Dimension(114, 25));
btnDelete = new JButton("ลบข้อมูล");
btnDelete.setPreferredSize(new Dimension(114, 25));
btnRefresh = new JButton("รีเฟรซข้อมูล");
btnRefresh.setPreferredSize(new Dimension(114, 25));
btnSearch = new JButton("ค้นหา");
btnSearch.setPreferredSize(new Dimension(114, 25));

//=====add lbl==============================
contentPane.add(lblCodePK);
contentPane.add(lblBudget);
contentPane.add(lblMonth);
contentPane.add(lblGetMoneyOld);
contentPane.add(lblGetMoneyAcc);
contentPane.add(lblTotalOldCash);
contentPane.add(lblMoneyOldCash);
contentPane.add(lblTotalOldTran);
contentPane.add(lblMoneyOldTran);
contentPane.add(lblTotalAccCash);
contentPane.add(lblMoneyAccCash);
contentPane.add(lblTotalAccTran);
contentPane.add(lblMoneyAccTran);
contentPane.add(lblTotalAidsCash);
contentPane.add(lblMoneyAidsCash);
contentPane.add(lblTotalAidsTran);
contentPane.add(lblMoneyAidsTran);

contentPane.add(lblWithdrawal);
contentPane.add(lblBackOld);
contentPane.add(lblBackAcc);
contentPane.add(lblSearch);

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

//Adjust constraints for the label so it's at (10,5).
//===================lblCodePK===========================================
layout.putConstraint(SpringLayout.WEST, lblCodePK, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblCodePK, 5, SpringLayout.NORTH, contentPane);
//=======================================================================

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

//===================lblWithdrawal=====================================
layout.putConstraint(SpringLayout.WEST, lblWithdrawal, 10, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblWithdrawal, 430, SpringLayout.NORTH, contentPane);
//======================================================================

//===================lblBackOld=========================================
layout.putConstraint(SpringLayout.WEST, lblBackOld, 320, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBackOld, 180, SpringLayout.NORTH, contentPane);
//======================================================================

//===================txtBackOld=========================================
layout.putConstraint(SpringLayout.WEST, txtBackOld, 320, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, txtBackOld, 205, SpringLayout.NORTH, contentPane);
//======================================================================

//===================lblBackAcc=========================================
layout.putConstraint(SpringLayout.WEST, lblBackAcc, 320, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblBackAcc, 230, SpringLayout.NORTH, contentPane);
//======================================================================

//===================txtBackAcc=========================================
layout.putConstraint(SpringLayout.WEST, txtBackAcc, 320, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, txtBackAcc, 255, 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);
//=======================================================================

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

//===================btnDelte============================================
layout.putConstraint(SpringLayout.WEST, btnDelete, 540, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnDelete, 255, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================btnRefresh============================================
layout.putConstraint(SpringLayout.WEST, btnRefresh, 540, SpringLayout.WEST,contentPane);
layout.putConstraint(SpringLayout.NORTH, btnRefresh, 65, SpringLayout.NORTH,contentPane);
//=======================================================================

//===================lblSearch==========================================
layout.putConstraint(SpringLayout.WEST, lblSearch, 540, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, lblSearch, 110, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================txtSearch==========================================
layout.putConstraint(SpringLayout.WEST, txtSearch, 540, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, txtSearch, 130, SpringLayout.NORTH, contentPane);
//=======================================================================

//===================btnSeach============================================
layout.putConstraint(SpringLayout.WEST, btnSearch, 540, SpringLayout.WEST, contentPane);
layout.putConstraint(SpringLayout.NORTH, btnSearch, 155, SpringLayout.NORTH,contentPane);
//=======================================================================

//==================Clear All Data Form Load=============================
txtCodePK.setText("");
txtCodeID.setText("");
txtBudget.setText("");
txtGetMoneyOld.setText("0.00");
txtGetMoneyAcc.setText("0.00");

txtTotalOldCash.setText("0");
txtMoneyOldCash.setText("0.00");
txtTotalOldTran.setText("0");
txtMoneyOldTran.setText("0.00");

txtTotalAccCash.setText("0");
txtMoneyAccCash.setText("0.00");
txtTotalAccTran.setText("0");
txtMoneyAccTran.setText("0.00");

txtTotalAidsCash.setText("0");
txtMoneyAidsCash.setText("0.00");
txtTotalAidsTran.setText("0");
txtMoneyAidsTran.setText("0.00");

txtWithdrawal.setText("0");
txtBackOld.setText("0.00");
txtBackAcc.setText("0.00");
txtSearch.setText("");
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);

//==========================================
//=====================txtBudget Only Number===========================
txtBudget.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtBudget = (JTextField) e.getSource();
String str = txtBudget.getText();
txtBudget.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtGetMoneyOld Only Number===================
txtGetMoneyOld.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtGetMoneyOld = (JTextField) e.getSource();
String str = txtGetMoneyOld.getText();
txtGetMoneyOld.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtGetMoneyAcc Only Number=====================
txtGetMoneyAcc.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtGetMoneyAcc = (JTextField) e.getSource();
String str = txtGetMoneyAcc.getText();
txtGetMoneyAcc.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtTotalOldCash Only Number====================
txtTotalOldCash.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtTotalOldCash = (JTextField) e.getSource();
String str = txtTotalOldCash.getText();
txtTotalOldCash.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtMoneyOldCash Only Number====================
txtMoneyOldCash.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoneyOldCash = (JTextField) e.getSource();
String str = txtMoneyOldCash.getText();
txtMoneyOldCash.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtTotalOldTran Only Number====================
txtTotalOldTran.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtTotalOldTran = (JTextField) e.getSource();
String str = txtTotalOldTran.getText();
txtTotalOldTran.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtMoneyOldTran Only Number====================
txtMoneyOldTran.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoneyOldTran = (JTextField) e.getSource();
String str = txtMoneyOldTran.getText();
txtMoneyOldTran.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtTotalAccCash Only Number====================
txtTotalAccCash.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtTotalAccCash = (JTextField) e.getSource();
String str = txtTotalAccCash.getText();
txtTotalAccCash.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtMoneyAccCash Only Number====================
txtMoneyAccCash.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoneyAccCash = (JTextField) e.getSource();
String str = txtMoneyAccCash.getText();
txtMoneyAccCash.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtTotalAccTran Only Number====================
txtTotalAccTran.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtTotalAccTran = (JTextField) e.getSource();
String str = txtTotalAccTran.getText();
txtTotalAccTran.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtMoneyAccTran Only Number====================
txtMoneyAccTran.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoneyAccTran = (JTextField) e.getSource();
String str = txtMoneyAccTran.getText();
txtMoneyAccTran.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtTotalAidsCash Only Number====================
txtTotalAidsCash.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtTotalAidsCash = (JTextField) e.getSource();
String str = txtTotalAidsCash.getText();
txtTotalAidsCash.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtMoneyAidsCash Only Number====================
txtMoneyAidsCash.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoneyAidsCash = (JTextField) e.getSource();
String str = txtMoneyAidsCash.getText();
txtMoneyAidsCash.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtTotalAidsTran Only Number====================
txtTotalAidsTran.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtTotalAidsTran = (JTextField) e.getSource();
String str = txtTotalAidsTran.getText();
txtTotalAidsTran.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================txtMoneyAidsTran Only Number====================
txtMoneyAidsTran.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtMoneyAidsTran = (JTextField) e.getSource();
String str = txtMoneyAidsTran.getText();
txtMoneyAidsTran.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtBackOld Only Number=========================
txtBackOld.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtBackOld = (JTextField) e.getSource();
String str = txtBackOld.getText();
txtBackOld.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtBackAcc Only Number=========================
txtBackAcc.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtBackAcc = (JTextField) e.getSource();
String str = txtBackAcc.getText();
txtBackAcc.setText(str.replaceAll("[^0-9.]", ""));
}
});
//=====================txtWithdrawal Only Number=========================
txtWithdrawal.addKeyListener(new KeyAdapter(){
@Override
public void keyReleased(KeyEvent e) {
JTextField txtWithdrawal = (JTextField) e.getSource();
String str = txtWithdrawal.getText();
txtWithdrawal.setText(str.replaceAll("[^0-9]", ""));
}
});
//=====================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]", ""));
}
});
//=======Command Button=================================================
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());

txtBudget.addActionListener(new TextListener());
txtGetMoneyOld.addActionListener(new TextListener());
txtGetMoneyAcc.addActionListener(new TextListener());

txtTotalOldCash.addActionListener(new TextListener());
txtMoneyOldCash.addActionListener(new TextListener());
txtTotalOldTran.addActionListener(new TextListener());
txtMoneyOldTran.addActionListener(new TextListener());

txtTotalAccCash.addActionListener(new TextListener());
txtMoneyAccCash.addActionListener(new TextListener());
txtTotalAccTran.addActionListener(new TextListener());
txtMoneyAccTran.addActionListener(new TextListener());

txtTotalAidsCash.addActionListener(new TextListener());
txtMoneyAidsCash.addActionListener(new TextListener());
txtTotalAidsTran.addActionListener(new TextListener());
txtMoneyAidsTran.addActionListener(new TextListener());

txtWithdrawal.addActionListener(new TextListener());
txtBackOld.addActionListener(new TextListener());
txtBackAcc.addActionListener(new TextListener());

//=====================================================================

//Display the window.
frame.pack();
frame.setVisible(true);
frame.setSize(670,490);//740,260
frame.setResizable(false);//ไม่ให้ Resize
frame.setLocationRelativeTo(null);
}
//=====================================================================
private java.sql.Date convertUtilDateToSqlDate(Date date) {
if(date != null) {
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
return sqlDate;
}
return null;
}
//=====================================================================

//==============txtSearch KeyPress=========================================
private class TextListener implements ActionListener
{
@Override
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
}
}

if(source == txtBudget){
txtGetMoneyOld.requestFocus();
}else if(source == txtGetMoneyOld){
txtGetMoneyAcc.requestFocus();
}else if(source == txtGetMoneyAcc){

txtTotalOldCash.requestFocus();
}else if(source == txtTotalOldCash){
txtMoneyOldCash.requestFocus();
}else if(source == txtMoneyOldCash){
txtTotalOldTran.requestFocus();
}else if(source == txtTotalOldTran){
txtMoneyOldTran.requestFocus();
}else if(source == txtMoneyOldTran){
txtBackOld.requestFocus();
}else if(source == txtBackOld){

txtTotalAccCash.requestFocus();
}else if(source == txtTotalAccCash){
txtMoneyAccCash.requestFocus();
}else if(source == txtMoneyAccCash){
txtBackAcc.requestFocus();
}else if(source ==txtBackAcc){
txtTotalAccTran.requestFocus();
}else if(source == txtTotalAccTran){
txtMoneyAccTran.requestFocus();
}else if(source == txtMoneyAccTran){
txtTotalAidsCash.requestFocus();
}else if(source == txtTotalAidsCash){
txtMoneyAidsCash.requestFocus();
}else if(source == txtMoneyAidsCash){
txtTotalAidsTran.requestFocus();
}else if(source == txtTotalAidsTran){
txtMoneyAidsTran.requestFocus();
}else if(source == txtMoneyAidsTran){
txtWithdrawal.requestFocus();
}else if(source == txtWithdrawal){
btnAdd.doClick();
}
}
}
//===================End txtSearch KeyPress============================
private boolean InsertData(){
Boolean status = false;
if(txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณากดปุ่ม GenID ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
btnGenID.requestFocus();
}else if(txtBudget.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาใส่ ปีงบประมาณ ด้วยครับ !","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtBudget.requestFocus();
}else{
int CodePK = Integer.parseInt(txtCodePK.getText());
String CodeID = txtCodeID.getText();
String Budget = txtBudget.getText();
Double GetMoneyOld = parseDouble(txtGetMoneyOld.getText());
Double GetMoneyAcc = parseDouble(txtGetMoneyAcc.getText());
Double TotalOldCash = parseDouble(txtTotalOldCash.getText());
Double MoneyOldCash = parseDouble(txtMoneyOldCash.getText());
Double TotalOldTran = parseDouble(txtTotalOldTran.getText());
Double MoneyOldTran = parseDouble(txtMoneyOldTran.getText());
Double TotalAccCash = parseDouble(txtTotalAccCash.getText());
Double MoneyAccCash = parseDouble(txtMoneyAccCash.getText());
Double TotalAccTran = parseDouble(txtTotalAccTran.getText());
Double MoneyAccTran = parseDouble(txtMoneyAccTran.getText());
Double TotalAidsCash = parseDouble(txtTotalAidsCash.getText());
Double MoneyAidsCash = parseDouble(txtMoneyAidsCash.getText());
Double TotalAidsTran = parseDouble(txtTotalAidsTran.getText());
Double MoneyAidsTran = parseDouble(txtMoneyAidsTran.getText());
Double BackOld = parseDouble(txtBackOld.getText());
Double BackAcc = parseDouble(txtBackAcc.getText());
String Withdrawal = txtWithdrawal.getText();

try{
connect = getDBConnection();

pstmt = connect.prepareStatement("insert into tblmoney"+
"(codepk,codeid,budget,paydate,getmoneyold,getmoneyacc,totaloldcash,moneyoldcash,"+
"totaloldtran,moneyoldtran,totalacccash,moneyacccash,totalacctran,moneyacctran," +
"totalaidscash,moneyaidscash,totalaidstran,moneyaidstran,backold,backacc,withdrawal)"+
"values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

pstmt.setInt(1, CodePK);
pstmt.setString(2, CodeID);
pstmt.setString(3, Budget);
pstmt.setDate(4, convertUtilDateToSqlDate(txtPayDate.getDate()));
pstmt.setDouble(5, GetMoneyOld);
pstmt.setDouble(6, GetMoneyAcc);
pstmt.setDouble(7, TotalOldCash);
pstmt.setDouble(8, MoneyOldCash);
pstmt.setDouble(9, TotalOldTran);
pstmt.setDouble(10, MoneyOldTran);
pstmt.setDouble(11, TotalAccCash);
pstmt.setDouble(12, MoneyAccCash);
pstmt.setDouble(13, TotalAccTran);
pstmt.setDouble(14, MoneyAccTran);
pstmt.setDouble(15, TotalAidsCash);
pstmt.setDouble(16, MoneyAidsCash);
pstmt.setDouble(17, TotalAidsTran);
pstmt.setDouble(18, MoneyAidsTran);
pstmt.setDouble(19, BackOld);
pstmt.setDouble(20, BackAcc);
pstmt.setString(21, Withdrawal);

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

txtSearch.requestFocus();
connect.close();
pstmt.close();
}catch(SQLException e){
JOptionPane.showMessageDialog(null, "Error Insert to Database !\n"+e.getMessage());
}
}
return status;
}
//==============Button Command=========================================
private class ButtonListener implements ActionListener{

@Override
public void actionPerformed(ActionEvent ae) {
Object source = ae.getSource();
//===========btnRefresh====================
if(source == btnRefresh){
try{
txtCodePK.setText("");
txtCodeID.setText("");
txtBudget.setText("");
txtGetMoneyOld.setText("0.00");
txtGetMoneyAcc.setText("0.00");

txtTotalOldCash.setText("0");
txtMoneyOldCash.setText("0.00");
txtTotalOldTran.setText("0");
txtMoneyOldTran.setText("0.00");

txtTotalAccCash.setText("0");
txtMoneyAccCash.setText("0.00");
txtTotalAccTran.setText("0");
txtMoneyAccTran.setText("0.00");

txtTotalAidsCash.setText("0");
txtMoneyAidsCash.setText("0.00");
txtTotalAidsTran.setText("0");
txtMoneyAidsTran.setText("0.00");

txtWithdrawal.setText("0");
txtBackOld.setText("0.00");
txtBackAcc.setText("0.00");
txtSearch.setText("");

//==========txtPayDate=====================
((JTextField)txtPayDate.getDateEditor().getUiComponent()).setText("");
txtPayDate.setDate(new Date());
//==========เปิดปุ่มและ textBox================
txtSearch.requestFocus();
btnGenID.setEnabled(true);
btnAdd.setEnabled(true);
btnEdit.setEnabled(true);
btnDelete.setEnabled(true);
btnSearch.setEnabled(true);
txtSearch.setEnabled(true);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
//==========================================
}catch(Exception e){
JOptionPane.showMessageDialog(null, "Error Refresh Database !\n"+e.getMessage());
}
}
//===========btnGenID==============================================
if(source==btnGenID){
//===========New===================== 
connect = getDBConnection();
if (connect != null) {
try{
String sql = "select max(codepk) from tblmoney ";
pstmt = connect.prepareStatement(sql);
rs = pstmt.executeQuery();

while(rs.next()){
if(rs.wasNull()){
txtCodePK.setText("1");
txtCodeID.setText("0000001");
}else{
int maxID = rs.getInt(1)+1;

txtCodePK.setText(String.valueOf(maxID));
String paded = String.format("%7s",String.valueOf(maxID)).replace(' ', '0');
txtCodeID.setText(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);
//=============================================
}
}
if (rs != null) {
rs.close();
}
connect.close();
pstmt.close();
}catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error GenID Auto !\n"+ex.getMessage());
}
} else {
JOptionPane.showMessageDialog(null,"Failed to make connection!");
}
//===================================
}
//===========btnAdd============================
if(source == btnAdd){
InsertData();
}
//===========btnSearch===========================================
if(source == btnSearch){
if((txtSearch.getText().equals("")) && txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}else{
try{
connect = getDBConnection();

String sql = "select * from tblmoney " +
"where codepk = ? " ;
pstmt = connect.prepareStatement(sql);
int search = Integer.parseInt(txtSearch.getText());
pstmt.setInt(1, search);
rs = pstmt.executeQuery();

if(!rs.next() ){
JOptionPane.showMessageDialog(null,"ไม่พบข้อมูลที่ต้องการค้นหา","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
txtSearch.setText("");
}else{
do{
txtCodePK.setText(String.valueOf(rs.getInt("codepk")));
txtCodeID.setText(String.valueOf(rs.getString("codeid")));
txtBudget.setText(String.valueOf(rs.getString("budget")));
txtPayDate.setDate(rs.getDate("paydate"));

txtGetMoneyOld.setText(String.valueOf(rs.getString("getmoneyold")));
txtGetMoneyAcc.setText(String.valueOf(rs.getString("getmoneyacc")));

txtTotalOldCash.setText(String.valueOf(rs.getString("totaloldcash")));
txtMoneyOldCash.setText(String.valueOf(rs.getString("moneyoldcash")));
txtTotalOldTran.setText(String.valueOf(rs.getString("totaloldtran")));
txtMoneyOldTran.setText(String.valueOf(rs.getString("moneyoldtran")));

txtTotalAccCash.setText(String.valueOf(rs.getString("totalacccash")));
txtMoneyAccCash.setText(String.valueOf(rs.getString("moneyacccash")));
txtTotalAccTran.setText(String.valueOf(rs.getString("totalacctran")));
txtMoneyAccTran.setText(String.valueOf(rs.getString("moneyacctran")));

txtTotalAidsCash.setText(String.valueOf(rs.getString("totalaidscash")));
txtMoneyAidsCash.setText(String.valueOf(rs.getString("moneyaidscash")));
txtTotalAidsTran.setText(String.valueOf(rs.getString("totalaidstran")));
txtMoneyAidsTran.setText(String.valueOf(rs.getString("moneyaidstran")));

txtBackOld.setText(String.valueOf(rs.getString("backold")));
txtBackAcc.setText(String.valueOf(rs.getString("backacc")));
txtWithdrawal.setText(String.valueOf(rs.getString("withdrawal")));

//===========================================================
//ปิดปุ่มและtextBox
txtSearch.requestFocus();
btnGenID.setEnabled(false);
btnAdd.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
}while (rs.next());
}
if (rs != null) {
rs.close();
}
connect.close();
pstmt.close();
}catch(SQLException ex){
JOptionPane.showMessageDialog(null, "ไม่สามารถแสดงข้อมูลได้!\n"+ex.getMessage());
}
}
}
//=================btnEdit========================================
if(source==btnEdit){
if(txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
}else {
int CodePK = Integer.parseInt(txtCodePK.getText());
String Budget = txtBudget.getText();
Double GetMoneyOld = parseDouble(txtGetMoneyOld.getText());
Double GetMoneyAcc = parseDouble(txtGetMoneyAcc.getText());
Double TotalOldCash = parseDouble(txtTotalOldCash.getText());
Double MoneyOldCash = parseDouble(txtMoneyOldCash.getText());
Double TotalOldTran = parseDouble(txtTotalOldTran.getText());
Double MoneyOldTran = parseDouble(txtMoneyOldTran.getText());
Double TotalAccCash = parseDouble(txtTotalAccCash.getText());
Double MoneyAccCash = parseDouble(txtMoneyAccCash.getText());
Double TotalAccTran = parseDouble(txtTotalAccTran.getText());
Double MoneyAccTran = parseDouble(txtMoneyAccTran.getText());
Double TotalAidsCash = parseDouble(txtTotalAidsCash.getText());
Double MoneyAidsCash = parseDouble(txtMoneyAidsCash.getText());
Double TotalAidsTran = parseDouble(txtTotalAidsTran.getText());
Double MoneyAidsTran = parseDouble(txtMoneyAidsTran.getText());
Double BackOld = parseDouble(txtBackOld.getText());
Double BackAcc = parseDouble(txtBackAcc.getText());
String Withdrawal = txtWithdrawal.getText();
try{
connect = getDBConnection();
pstmt = connect.prepareStatement("update tblmoney set " +
"budget = ?,"+
"paydate = ?, "+
"getmoneyold = ?, " +
"getmoneyacc = ?, " +
"totaloldcash = ?, " +
"moneyoldcash = ?, " +
"totaloldtran = ?, " +
"moneyoldtran = ?, " +
"totalacccash = ?, " +
"moneyacccash = ?, " +
"totalacctran = ?, " +
"moneyacctran = ?, " +
"totalaidscash = ?, " +
"moneyaidscash = ?, " +
"totalaidstran = ?, " +
"moneyaidstran = ?, " +
"backold = ?, " +
"backacc = ?, " +
"withdrawal = ? " +
"where codepk = ?");

pstmt.setString(1, Budget);
pstmt.setDate(2, convertUtilDateToSqlDate(txtPayDate.getDate()));
pstmt.setDouble(3, GetMoneyOld);
pstmt.setDouble(4, GetMoneyAcc);
pstmt.setDouble(5, TotalOldCash);
pstmt.setDouble(6, MoneyOldCash);
pstmt.setDouble(7, TotalOldTran);
pstmt.setDouble(8, MoneyOldTran);
pstmt.setDouble(9, TotalAccCash);
pstmt.setDouble(10, MoneyAccCash);
pstmt.setDouble(11, TotalAccTran);
pstmt.setDouble(12, MoneyAccTran);
pstmt.setDouble(13, TotalAidsCash);
pstmt.setDouble(14, MoneyAidsCash);
pstmt.setDouble(15, TotalAidsTran);
pstmt.setDouble(16, MoneyAidsTran);
pstmt.setDouble(17, BackOld);
pstmt.setDouble(18, BackAcc);
pstmt.setString(19, Withdrawal);
pstmt.setInt(20, CodePK);

pstmt.executeUpdate();

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

connect.close();
pstmt.close();
}catch(SQLException | HeadlessException e){
JOptionPane.showMessageDialog(null, "Error Update to Database !\n"+e.getMessage());
}
}
}
//=================btnDelete======================================
if(source==btnDelete){
if((txtSearch.getText().equals("")) && txtCodePK.getText().equals("")){
JOptionPane.showMessageDialog(null,"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา","รายงานสถานะ",JOptionPane.QUESTION_MESSAGE,null);
txtSearch.requestFocus();
//return;
}else {
//==================Do it=============================
int conf = JOptionPane.showConfirmDialog(null,"คุณต้องการลบข้อมูลลำดับที่ : " +txtSearch.getText()+" หรือไม่","รายงานสถานะ",JOptionPane.YES_NO_OPTION);
if(conf==0){
int CodePK = Integer.parseInt(txtCodePK.getText());

try {
//connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb");
connect = getDBConnection();

pstmt = connect.prepareStatement("delete from tblmoney where codepk = ?");

pstmt.setInt(1, CodePK);

pstmt.executeUpdate();

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

btnRefresh.doClick();
txtSearch.requestFocus();
connect.close();
pstmt.close();
} catch(SQLException | HeadlessException ex){
JOptionPane.showMessageDialog(null,"ลบข้อมูลผิดพลาด!\n"+ex.getMessage());
}
}
//====================================================
}
}
}
}
//==============Connection PostgreSQL===================================
private static Connection getDBConnection(){
Connection connect = null;
try{
Class.forName("org.postgresql.Driver");
}catch(ClassNotFoundException e){
System.out.println(e.getMessage());
}

try{
connect = DriverManager.getConnection("jdbcostgresql://127.0.0.1:5432/dbolder", "postgres","gomplayer");
}catch(SQLException e){
System.out.println(e.getMessage());
}

return connect;
}
//======================================================================
}
</pre>

เข้าสู่ระบบหรือลงทะเบียน

Java NetBeans 7.4x86 กับ PostgreSQL 9.6x86

ledphong เป็นที่รู้จักกันดี

ไฟล์ที่แนบมา:

pg1.png

ledphong เป็นที่รู้จักกันดี

แชร์หน้านี้

แชร์หน้านี้

เข้าสู่ระบบหรือลงทะเบียน

Java NetBeans 7.4x86 กับ PostgreSQL 9.6x86

ไฟล์ที่แนบมา:

pg1.png

แชร์หน้านี้

การค้นหาที่มีประโยชน์

ติดต่อเรา