เขียนโปรแกรม Java NetBeans บนฐานข้อมูล MySQL Server 5.5

ledphong · 24 มกราคม 2015

ตัวอย่าง FormAdd บางตอน
====================
<pre class="java5" style="font-family:monospace;">package com.java.myapp;
 
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
 
public class FormAdd extends javax.swing.JInternalFrame {
 
Connection connect = null;
DefaultTableModel dt = null;
int CodePK = 0;
String Budget,Sex,FullName,IDCard,BanID,Moo,Poverty,Help,Comment,CodeID = null;
float Money;
Statement st = null;
ResultSet rs = null;
static JTable table;//new
PreparedStatement pstmt = null;
 
public FormAdd() {
initComponents();
setTitle("เพิ่มรายการ / แก้ไขรายการ");
int inset = 50;
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds(inset*6, inset, screenSize.width - inset * 12, screenSize.height-inset * 4);
//=============Connection MySQL==============
try
{
//connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb"
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/dbHelp" +
"?user=root&password=gomplayer");
//JOptionPane.showMessageDialog(null,"Connect Database Successfully"
//showdata();
ClearAll();
}
catch(Exception ex){
JOptionPane.showMessageDialog(null,"Connect Database Failed!\n"+ex.getMessage());
}
//===========================================
}</pre>

ledphong · 24 มกราคม 2015

ปุ่ม GenID หรือกำหนดเลขแบบ Auto
=========================
<pre class="java5" style="font-family:monospace;">private void btnGenIDActionPerformed(java.awt.event.ActionEvent evt) {
GenIDAuto();
}
 
private boolean GenIDAuto()
{
Boolean status = false;
try {
String sql = "SELECT max(CodePK) FROM tblHelp";//ใช้กับ 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));
String paded = String.format("%7s",String.valueOf(maxID)).replace(' ', '0');
txtCodeID.setText("CUS"+paded);
}
 
//ปิดปุ่ม
btnGenID.setEnabled(false);
btnEdit.setEnabled(false);
btnDelete.setEnabled(false);
btnSearch.setEnabled(false);
 
//ปิด textBox
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
status = true;
} catch(Exception ex){
JOptionPane.showMessageDialog(null,"Error Auto GenID!\n"+ex.getMessage());
}
return status;
}</pre>

ledphong · 24 มกราคม 2015

<pre class="java5" style="font-family:monospace;">private void ClearAll()
{
try {
txtCodePK.setText("");
cbBudget.setSelectedItem(null);
cbSex.setSelectedItem(null);
txtFullName.setText("");
txtIDCard.setText("");
txtBanID.setText("");
cbMoo.setSelectedItem(null);
txtPoverty.setText("");
cbHelp.setSelectedItem(null);
txtMoney.setText("0.00");//0.00
cbComment.setSelectedItem(null);
txtCodeID.setText("");
txtSearch.setText("");
jComboBox1.setSelectedItem(null);
jComboBox2.setSelectedItem(null);
jComboBox3.setSelectedItem(null);
} catch(Exception ex){
JOptionPane.showMessageDialog(null,"Error Clear All Data!\n"+ex.getMessage());
}
}</pre>

ledphong · 24 มกราคม 2015

<pre class="java5" style="font-family:monospace;">private boolean InsertData()
{
String CodePK = txtCodePK.getText();
String Budget = (String)cbBudget.getSelectedItem();
String Sex = (String)cbSex.getSelectedItem();
String FullName = txtFullName.getText();
String IDCard = txtIDCard.getText();
String BanID = txtBanID.getText();
String Moo = (String)cbMoo.getSelectedItem();
String Poverty = txtPoverty.getText();
String Help = (String)cbHelp.getSelectedItem();
String Money = txtMoney.getText();
String Comment = (String)cbComment.getSelectedItem();
String CodeID = txtCodeID.getText();
String MyD = (String)jComboBox1.getSelectedItem();
String MyDateMonth = (String)jComboBox2.getSelectedItem();
String MyDateYear = (String)jComboBox3.getSelectedItem();
 
if (CodePK.equals(""))
{
JOptionPane.showMessageDialog(null,
"กรุณากดปุ่ม GenID ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
txtCodePK.requestFocusInWindow();
return false;
//(cbBudget.getItemCount() != 0)) ค่า ComboBox ว่าง
//JcomboBox.setSelectedIndex(-1);
}
if (cbBudget.getSelectedItem() == null)
{
JOptionPane.showMessageDialog(null,
"กรุณาเลือก ปีงบประมาณ ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
cbBudget.requestFocusInWindow();
return false;
}
if (cbSex.getSelectedItem() == null)
{
JOptionPane.showMessageDialog(null,
"กรุณาเลือก เพศ ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
cbSex.requestFocusInWindow();
return false;
}
if (FullName.equals(""))
{
JOptionPane.showMessageDialog(null,
"กรุณาพิมพ์ ชื่อ-สกุล ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
txtFullName.requestFocusInWindow();
return false;
}
if (cbMoo.getSelectedItem() == null)
{
JOptionPane.showMessageDialog(null,
"กรุณาเลือก หมู่ที่ ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
cbMoo.requestFocusInWindow();
return false;
}
if (Poverty.equals(""))
{
JOptionPane.showMessageDialog(null,
"กรุณาพิมพ์ ความยากจน ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
txtPoverty.requestFocusInWindow();
return false;
}
if (cbHelp.getSelectedItem() == null)
{
JOptionPane.showMessageDialog(null,
"กรุณาเลือก ความช่วยเหลือ ก่อนครับ " ,
"รายงานสถานะ",JOptionPane.QUESTION_MESSAGE);
cbHelp.requestFocusInWindow();
return false;
}
 
Boolean status = false;
try {
//connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb"
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/dbHelp" +
"?user=root&password=gomplayer");
 
PreparedStatement pstmt = connect.prepareStatement("INSERT INTO tblHelp"+
"(CodePK,Budget,Sex,FullName,IDCard,BanID,Moo," +
"Poverty,Help,Money,Comment,CodeID,MyDateDay,MyDateMonth,MyDateYear)"+
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstmt.setString(1, CodePK);
pstmt.setString(2, Budget);
pstmt.setString(3, Sex);
pstmt.setString(4, FullName);
pstmt.setString(5, IDCard);
pstmt.setString(6, BanID);
pstmt.setString(7, Moo);
pstmt.setString(8, Poverty);
pstmt.setString(9, Help);
pstmt.setString(10, Money);
pstmt.setString(11, Comment);
pstmt.setString(12, CodeID);
pstmt.setString(13, MyD);
pstmt.setString(14, MyDateMonth);
pstmt.setString(15, MyDateYear);
//pstmt.setString(16,((JTextField).dob.getDateEditor().getUiCoponent()).getText());//เวลา
pstmt.executeUpdate();
 
JOptionPane.showMessageDialog(null,"บันทึกข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
 
btnRefresh.doClick();
status = true;
} catch(Exception e){
JOptionPane.showMessageDialog(null, "บันทึกข้อมูลผิดพลาด!\n"+e.getMessage());
}
return status;
}</pre>

ledphong · 24 มกราคม 2015

<pre class="java5" style="font-family:monospace;">private boolean UpdateData()
{
if (txtCodePK.getText().equals(""))
{
JOptionPane.showMessageDialog(null,
"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา" ,
"รายงานสถานะ",JOptionPane.PLAIN_MESSAGE);
txtSearch.requestFocusInWindow();
return false;
}
 
int CodePK = Integer.parseInt(txtCodePK.getText());
String Budget = (String)cbBudget.getSelectedItem();
String Sex = (String)cbSex.getSelectedItem();
String FullName = txtFullName.getText();
String IDCard = txtIDCard.getText();
String BanID = txtBanID.getText();
String Moo = (String)cbMoo.getSelectedItem();
String Poverty = txtPoverty.getText();
String Help = (String)cbHelp.getSelectedItem();
float Money = new Float(txtMoney.getText());
String Comment = (String)cbComment.getSelectedItem();
String MyD = (String)jComboBox1.getSelectedItem();
String DateMonth = (String)jComboBox2.getSelectedItem();
String DateYear = (String)jComboBox3.getSelectedItem();
 
Boolean status = false;
try {
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/dbHelp" +
"?user=root&password=gomplayer");
 
PreparedStatement pstmt = connect.prepareStatement("UPDATE tblHelp SET " +
"Budget = ?,"+
"Sex = ?,"+
"FullName = ?,"+
"IDCard = ?,"+
"BanID = ?,"+
"Moo = ?,"+
"Poverty = ?,"+
"Help = ?,"+
"Money = ?,"+
"Comment = ?, "+
"MyDateDay = ?, "+
"MyDateMonth = ?, "+
"MyDateYear = ? "+
"WHERE CodePK = ?");
 
pstmt.setString(1, Budget);
pstmt.setString(2, Sex);
pstmt.setString(3, FullName);
pstmt.setString(4, IDCard);
pstmt.setString(5, BanID);
pstmt.setString(6, Moo);
pstmt.setString(7, Poverty);
pstmt.setString(8, Help);
pstmt.setFloat(9, Money);
pstmt.setString(10, Comment);
pstmt.setString(11, MyD);
pstmt.setString(12, DateMonth);
pstmt.setString(13, DateYear);
pstmt.setInt(14, CodePK);
pstmt.executeUpdate();
 
JOptionPane.showMessageDialog(null,"แก้ไขข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
 
btnRefresh.doClick();
status = true;
} catch(Exception e){
JOptionPane.showMessageDialog(null, "แก้ไขข้อมูลผิดพลาด!\n"+e.getMessage());
}
return status;
}</pre>

ledphong · 24 มกราคม 2015

<pre class="java5" style="font-family:monospace;">private boolean DeleteData()
{
if (txtCodePK.getText().equals(""))
{
JOptionPane.showMessageDialog(null,
"กรุณาพิมพ์ค้นหาข้อมูลก่อนและกดปุ่มค้นหา" ,
"รายงานสถานะ",JOptionPane.PLAIN_MESSAGE);
txtSearch.requestFocusInWindow();
return false;
}
 
Boolean status = false;
int conf = JOptionPane.showConfirmDialog(null,"คุณต้องการลบข้อมูลหรือไม่","รายงานสถานะ",JOptionPane.YES_NO_OPTION);
if(conf==0){
int CodePK = Integer.parseInt(txtCodePK.getText());
 
try {
//connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb"
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/dbHelp" +
"?user=root&password=gomplayer");
 
PreparedStatement pstmt = connect.prepareStatement("DELETE FROM tblHelp WHERE CodePK = ?");
 
pstmt.setInt(1, CodePK);
pstmt.executeUpdate();
 
JOptionPane.showMessageDialog(null,"ลบข้อมูลเรียบร้อยแล้ว","รายงานสถานะ",JOptionPane.INFORMATION_MESSAGE);
 
btnRefresh.doClick();
status = true;
} catch(Exception ex){
JOptionPane.showMessageDialog(null,"ลบข้อมูลผิดพลาด!\n"+ex.getMessage());
}
}
return status;
}</pre>

ledphong · 24 มกราคม 2015

<pre class="java5" style="font-family:monospace;">private void btnSearchActionPerformed(java.awt.event.ActionEvent evt) {
if ((txtSearch.getText().equals("")) && txtCodePK.getText().equals(""))
{
JOptionPane.showMessageDialog(null,
"กรุณาพิมพ์ค้นหาข้อมูลก่อน " ,
"รายงานสถานะ",JOptionPane.PLAIN_MESSAGE);
return ;
}
 
Scanner scanner = new Scanner(txtSearch.getText());
if (scanner.hasNextInt()) {
try{
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/dbHelp" +
"?user=root&password=gomplayer");
 
String sql = "Select * from tblHelp " +
"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")));
cbSex.setSelectedItem(String.valueOf(rs.getString("Sex")));
txtFullName.setText(String.valueOf(rs.getString("FullName")));
txtIDCard.setText(String.valueOf(rs.getString("IDCard")));
txtBanID.setText(String.valueOf(rs.getString("BanID")));
cbMoo.setSelectedItem(String.valueOf(rs.getString("Moo")));
txtPoverty.setText(String.valueOf(rs.getString("Poverty")));
cbHelp.setSelectedItem(String.valueOf(rs.getString("Help")));
txtMoney.setText(String.valueOf(rs.getString("Money")));
//txtMoney.setText(df.format(Double.parseDouble(rs.getString("Money&quot)));
txtCodeID.setText(String.valueOf(rs.getString("CodeID")));
cbBudget.setSelectedItem(String.valueOf(rs.getString("Budget")));
cbComment.setSelectedItem(String.valueOf(rs.getString("Comment")));
jComboBox1.setSelectedItem(String.valueOf(rs.getString("MyDateDay")));
jComboBox2.setSelectedItem(String.valueOf(rs.getString("MyDateMonth")));
jComboBox3.setSelectedItem(String.valueOf(rs.getString("MyDateYear")));
 
//ปิดปุ่มและtextBox
btnGenID.setEnabled(false);
btnAdd.setEnabled(false);
btnSearch.setEnabled(false);
txtSearch.setEnabled(false);
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
} while (rs.next());
}
}catch(Exception ex){
JOptionPane.showMessageDialog(null, "ไม่สามารถแสดงข้อมูลได้!\n"+ex.getMessage());
}
 
}else {
JOptionPane.showMessageDialog(null,"ข้อมูลที่ป้อนเข้ามาไม่ใช่ตัวเลขครับ");
txtSearch.setText("");
}
}
 
private void txtSearchKeyPressed(java.awt.event.KeyEvent evt) {
try {
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
btnSearch.doClick();
}
//ปิดปุ่มและ textBox
txtCodePK.setEnabled(false);
txtCodeID.setEnabled(false);
btnGenID.setEnabled(false);
btnAdd.setEnabled(false);
} catch(Exception ex){
JOptionPane.showMessageDialog(null,"Error Refresh Data!\n"+ex.getMessage());
}
}
 
private void btnAddActionPerformed(java.awt.event.ActionEvent evt) {
InsertData();
}
 
private void btnEditActionPerformed(java.awt.event.ActionEvent evt) {
UpdateData();
}
 
private void btnRefreshActionPerformed(java.awt.event.ActionEvent evt) {
try {
 
ClearAll();
//เปิดปุ่ม
btnGenID.setEnabled(true);
btnAdd.setEnabled(true);
btnEdit.setEnabled(true);
btnDelete.setEnabled(true);
btnSearch.setEnabled(true);
 
//เปิด textBox
txtSearch.setEnabled(true);
txtCodePK.setEnabled(true);
cbBudget.setEnabled(true);
//cbBudget.setSelectedItem("2557"
cbSex.setEnabled(true);
//cbSex.setSelectedItem("ชาย"
txtFullName.setEnabled(true);
txtIDCard.setEnabled(true);
txtBanID.setEnabled(true);
cbMoo.setEnabled(true);
//cbMoo.setSelectedItem("หมู่ที่ 1"
txtPoverty.setEnabled(true);
cbHelp.setEnabled(true);
//cbHelp.setSelectedItem("เงินสงเคราะห์"
txtMoney.setEnabled(true);
cbComment.setEnabled(true);
//cbComment.setSelectedItem("รอดำเนินการ"
txtCodeID.setEnabled(true);
} catch(Exception ex){
JOptionPane.showMessageDialog(null,"Error Refresh Data!\n"+ex.getMessage());
}
}
 
private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {
DeleteData();
} </pre>

ledphong · 24 มกราคม 2015

2.แบบใช้ Class ล้วนๆ
================================
ลองปรับจากการ Connect MS Access 2010 (.mdb) ==> MySQL Server ดูเอาน่ะครับ

ledphong · 24 มกราคม 2015

Connect Class
=============

ledphong · 24 มกราคม 2015

MyClass Class
=========================
<pre class="java5" style="font-family:monospace;">/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.java.myapp;
import java.sql.*;
import javax.swing.JOptionPane;
/**
*
* @author BB
*/
public class MyClass {
Connection connect;
private int CodePK;
private String Sex;
private String FullName;
private String Moo;
private String Poverty;
private String Help;
private float Money;
private String CodeID;
private String Budget;
private String Comment;
 
public MyClass()
{
connect = Connect.ConnectDB();
}
 
public int getCodePK() {
return CodePK;
}
 
public void setCodePK(int CodePK) {
this.CodePK = CodePK;
}
 
public String getSex() {
return Sex;
}
 
public void setSex(String Sex) {
this.Sex = Sex;
}
 
public String getFullName() {
return FullName;
}
 
public void setFullName(String FullName) {
this.FullName = FullName;
}
 
public String getMoo() {
return Moo;
}
 
public void setMoo(String Moo) {
this.Moo = Moo;
}
 
public String getPoverty() {
return Poverty;
}
 
public void setPoverty(String Poverty) {
this.Poverty = Poverty;
}
 
public String getHelp() {
return Help;
}
 
public void setHelp(String Help) {
this.Help = Help;
}
 
public float getMoney() {
return Money;
}
 
public void setMoney(float Money) {
this.Money = Money;
}
 
public String getCodeID() {
return CodeID;
}
 
public void setCodeID(String CodeID) {
this.CodeID = CodeID;
}
 
public String getBudget() {
return Budget;
}
 
public void setBudget(String Budget) {
this.Budget = Budget;
}
 
public String getComment() {
return Comment;
}
 
public void setComment(String Comment) {
this.Comment = Comment;
}
 
public boolean GenID()
{
boolean status = false;
try{
String sql = "SELECT nvl(max(CodePK),0) FROM tblHelp";
PreparedStatement pstmt = connect.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
if(rs.next())
{
status = true;
CodePK = rs.getInt("CodePK")+1;
}
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"Error GenID!\n"+ex.getMessage());
}
return status;
}
 
public boolean SearchDataUserDetails()
{
boolean status = false;
try{
String sql = "Select * from tblHelp " +
"Where CodePK Like ?";
PreparedStatement pstmt = connect.prepareStatement(sql);
pstmt.setInt(1,CodePK);
ResultSet rs = pstmt.executeQuery();
if(rs.next())
{
status = true;
CodePK = rs.getInt("CodePK");
Sex = rs.getString("Sex");
FullName = rs.getString("FullName");
Moo = rs.getString("Moo");
Poverty = rs.getString("Poverty");
Help = rs.getString("Help");
Money = rs.getFloat("Money");
CodeID = rs.getString("CodeID");
Budget = rs.getString("Budget");
Comment = rs.getString("Comment");
}
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"ค้นหาข้อมูลผิดพลาด!\n"+ex.getMessage());
}
return status;
}
 
public boolean InsertDataUserDetails()
{
boolean status = false;
try{
PreparedStatement pstmt = connect.prepareStatement("INSERT INTO tblHelp"+
"(CodePK,Sex,FullName,Moo,Poverty," +
"Help,Money,CodeID,Budget,Comment) " +
"VALUES (?,?,?,?,?,?,?,?,?,?)");
pstmt.setInt(1, CodePK);
pstmt.setString(2, Sex);
pstmt.setString(3, FullName);
pstmt.setString(4, Moo);
pstmt.setString(5, Poverty);
pstmt.setString(6, Help);
pstmt.setFloat(7, Money);
pstmt.setString(8, CodeID);
pstmt.setString(9, Budget);
pstmt.setString(10, Comment);
if(!pstmt.execute())
{
status = true;
}
 
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"บันทึกข้อมูลผิดพลาด!\n"+ex.getMessage());
}
return status;
}
 
public boolean UpdateDataUserDetails()
{
boolean status = false;
try{
PreparedStatement pstmt = connect.prepareStatement("UPDATE tblHelp SET " +
"Sex = ?,"+
"FullName = ?,"+
"Moo = ?,"+
"Poverty = ?,"+
"Help = ?,"+
"Money = ?,"+
"Budget = ?,"+
"Comment = ? "+
"WHERE CodePK = ?");
 
pstmt.setString(1, Sex);
pstmt.setString(2, FullName);
pstmt.setString(3, Moo);
pstmt.setString(4, Poverty);
pstmt.setString(5, Help);
pstmt.setFloat(6, Money);
pstmt.setString(7, Budget);
pstmt.setString(8, Comment);
pstmt.setInt(9, CodePK);
 
if(!pstmt.execute())
{
status = true;
}
 
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"แก้ไขข้อมูลผิดพลาด!\n"+ex.getMessage());
}
return status;
}
 
public boolean DeleteDataUserDetails()
{
boolean status = false;
try{
PreparedStatement pstmt = connect.prepareStatement("DELETE FROM tblHelp WHERE CodePK = ?");
 
pstmt.setInt(1, CodePK);
pstmt.executeUpdate();
 
if(!pstmt.execute())
{
status = true;
}
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"ลบข้อมูลผิดพลาด!\n"+ex.getMessage());
}
return status;
}
}</pre>

ledphong · 24 มกราคม 2015

FormLogin.java
===============================
<pre class="java5" style="font-family:monospace;">/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.java.myapp;
 
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.JOptionPane;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
*
* @author BBCOM
*/
public class FormLogin extends javax.swing.JFrame {
 
Statement st = null;
Connection connect = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
/**
* Creates new form FormLogin
*/
public FormLogin() {
initComponents();
this.setLocationRelativeTo(null);
setTitle("เข้าสู่โปรแกรมช่วยเหลือผู้ประสบปัญหาทางสังคม");
 
try
{
connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb");
}
catch(Exception ex){
JOptionPane.showMessageDialog(null,"Connect Database Failed!\n"+ex.getMessage());
}
}
 
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code"> 
private void initComponents() {
 
txtUserName = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
btnOK = new javax.swing.JButton();
btnRefresh = new javax.swing.JButton();
txtPassword = new javax.swing.JPasswordField();
 
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
 
jLabel1.setText("User Name :");
 
jLabel2.setText("Password :");
 
btnOK.setText("OK");
btnOK.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnOKActionPerformed(evt);
}
});
 
btnRefresh.setText("Refresh");
btnRefresh.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnRefreshActionPerformed(evt);
}
});
 
txtPassword.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
txtPasswordKeyPressed(evt);
}
});
 
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(58, 58, 58)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(33, 33, 33)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addComponent(btnOK, javax.swing.GroupLayout.DEFAULT_SIZE, 65, Short.MAX_VALUE)
.addGap(18, 18, 18)
.addComponent(btnRefresh))
.addComponent(txtUserName)
.addComponent(txtPassword))
.addContainerGap(118, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(34, 34, 34)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtUserName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(txtPassword, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(50, 50, 50)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(btnOK)
.addComponent(btnRefresh))
.addContainerGap(48, Short.MAX_VALUE))
);
 
pack();
}// </editor-fold> 
 
private void btnRefreshActionPerformed(java.awt.event.ActionEvent evt) {
txtUserName.setText("");
txtPassword.setText("");
}
 
private void txtPasswordKeyPressed(java.awt.event.KeyEvent evt) {
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
try{
connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb");
String sql = "select * from tblUser where UserName=? and Password=?";
pstmt = connect.prepareStatement(sql);
pstmt.setString(1,txtUserName.getText());
pstmt.setString(2,txtPassword.getText());
rs = pstmt.executeQuery();
if(rs.next()){
 
FormAdd f1 = new FormAdd();
f1.setVisible(true);
this.setVisible(false);
rs.close();
pstmt.close();
}else{
JOptionPane.showMessageDialog(null,"กรุณา Login & Password อีกครั้ง","รายงานสถานะ",JOptionPane.PLAIN_MESSAGE);
}
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"Login Failed!\n"+ex.getMessage());
}
 
}
}
 
private void btnOKActionPerformed(java.awt.event.ActionEvent evt) {
try{
connect=DriverManager.getConnection("jdbc:ucanaccess://C:\\java\\dbHelp.mdb");
String sql = "select * from tblUser where UserName=? and Password=?";
pstmt = connect.prepareStatement(sql);
pstmt.setString(1,txtUserName.getText());
pstmt.setString(2,txtPassword.getText());
rs = pstmt.executeQuery();
if(rs.next()){
 
FormAdd f1 = new FormAdd();
f1.setVisible(true);
this.setVisible(false);
rs.close();
pstmt.close();
}else{
JOptionPane.showMessageDialog(null,"กรุณา Login & Password อีกครั้ง","รายงานสถานะ",JOptionPane.PLAIN_MESSAGE);
}
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"Login Failed!\n"+ex.getMessage());
}
}
 
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(FormLogin.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(FormLogin.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(FormLogin.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(FormLogin.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
 
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new FormLogin().setVisible(true);
}
});
}
 
// Variables declaration - do not modify 
private javax.swing.JButton btnOK;
private javax.swing.JButton btnRefresh;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JPasswordField txtPassword;
private javax.swing.JTextField txtUserName;
// End of variables declaration 
}</pre>

ledphong · 24 มกราคม 2015

FormAdd.Java
======================

ledphong · 2 มีนาคม 2015

รอ Java Version ใหม่

sontaya31 · 13 มีนาคม 2017

ดีมากๆเลยครับ พอเห็นโค้ดยาวๆ เสร็จเลยครับ งง เป็นไก่ตาแตกเลย ขอบคุณครับ

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

เขียนโปรแกรม Java NetBeans บนฐานข้อมูล MySQL Server 5.5

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

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

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

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

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

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

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

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

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

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

j89.png

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

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

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

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

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

1.png

sontaya31 สมาชิกใหม่

แชร์หน้านี้

แชร์หน้านี้

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

เขียนโปรแกรม Java NetBeans บนฐานข้อมูล MySQL Server 5.5

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

j89.png

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

1.png

แชร์หน้านี้

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

ติดต่อเรา