[go: up one dir, main page]
Scribd
Upload
41 views10 pages

Codes

The document is a Java program that connects to a MySQL database to retrieve customer information and display it in a graphical user interface (GUI). It includes functionalities to navigate through records, add, edit, and delete customer data. The program utilizes Swing components for the GUI and handles SQL exceptions with dialog messages.

Uploaded by

kenneth simo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
41 views10 pages

Codes

The document is a Java program that connects to a MySQL database to retrieve customer information and display it in a graphical user interface (GUI). It includes functionalities to navigate through records, add, edit, and delete customer data. The program utilizes Swing components for the GUI and handles SQL exceptions with dialog messages.

Uploaded by

kenneth simo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 10

package finals;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;

public class Main extends javax.swing.JFrame {

Connection con;
Statement stmt;
ResultSet rs;

public Main() {
initComponents();
DoConnect();
}
public void DoConnect( ) {

try
{
String host= "jdbc:mysql://localhost:3306/Customer";
String uName ="root";
String uPass ="";

Connection con=DriverManager.getConnection(host,uName,uPass);

Statement stmt =
con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE )
;
String sql= "SELECT *FROM customerInfo";
rs = stmt.executeQuery(sql);

rs.next();
String first = rs.getString("First_Name");
String last = rs.getString("Last_Name");
float total_col = rs.getInt("Total_Cost");
String total = Float.toString(total_col);
String date = rs.getString("Date");
int rn_col = rs.getInt("Receipt_No");
String rn = Integer.toString(rn_col);

jTextFirstName.setText(first);
jTextLastName.setText(last);
jTextTotal.setText(total);
jTextDate.setText(date);
jTextReceipt.setText(rn);
}
catch(SQLException err)
{
JOptionPane.showMessageDialog(Main.this, err.getMessage());
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">

private void initComponents() {

jPanel1 = new javax.swing.JPanel();


jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jTextReceipt = new javax.swing.JTextField();
jTextFirstName = new javax.swing.JTextField();
jTextLastName = new javax.swing.JTextField();
jTextTotal = new javax.swing.JTextField();
jTextDate = new javax.swing.JTextField();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
btnFirst = new javax.swing.JButton();
btnPrevious = new javax.swing.JButton();
btnNext = new javax.swing.JButton();
btnlast = new javax.swing.JButton();
btnAdd = new javax.swing.JButton();
btnEdit = new javax.swing.JButton();
btnDelete = new javax.swing.JButton();
jTextField6 = new javax.swing.JTextField();
jButton8 = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setResizable(false);
getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

jPanel1.setBackground(new java.awt.Color(255, 255, 204));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel1.setText("Receipt No:");

jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel2.setText("First Name:");

jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel3.setText("Last Name:");

jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel4.setText("Total Cost:");

jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel5.setText("Date:");

jTextReceipt.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N

jTextFirstName.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N

jTextLastName.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N


jTextTotal.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
jTextTotal.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextTotalActionPerformed(evt);
}
});

jTextDate.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N

jScrollPane1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N

jTable1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N


jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {

},
new String [] {
"Receipt No", "First Name", "Last Name", "Total Cost", "Date"
}
));
jScrollPane1.setViewportView(jTable1);

btnFirst.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnFirst.setText("First");
btnFirst.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnFirstActionPerformed(evt);
}
});

btnPrevious.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnPrevious.setText("Previous");
btnPrevious.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnPreviousActionPerformed(evt);
}
});

btnNext.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnNext.setText("Next");
btnNext.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnNextActionPerformed(evt);
}
});

btnlast.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnlast.setText("Last");
btnlast.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnlastActionPerformed(evt);
}
});

btnAdd.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnAdd.setText("Add Records");
btnAdd.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnAddActionPerformed(evt);
}
});

btnEdit.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnEdit.setText("Edit Records");
btnEdit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnEditActionPerformed(evt);
}
});

btnDelete.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


btnDelete.setText("Delete Records");

jTextField6.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N

jButton8.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N


jButton8.setText("Search");

javax.swing.GroupLayout jPanel1Layout = new


javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1,
javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jTextReceipt,
javax.swing.GroupLayout.PREFERRED_SIZE, 178,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel2,
javax.swing.GroupLayout.PREFERRED_SIZE, 119,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel4,
javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jTextTotal,
javax.swing.GroupLayout.PREFERRED_SIZE, 200,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(18, 18, 18)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jTextFirstName,
javax.swing.GroupLayout.PREFERRED_SIZE, 200,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel3,
javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jTextLastName,
javax.swing.GroupLayout.PREFERRED_SIZE, 178,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel5,
javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jTextDate,
javax.swing.GroupLayout.PREFERRED_SIZE, 200,
javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jTextField6,
javax.swing.GroupLayout.PREFERRED_SIZE, 222,
javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton8,
javax.swing.GroupLayout.PREFERRED_SIZE, 108,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(0, 19, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel1Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(63, 63, 63)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(77, 77, 77)
.addComponent(btnAdd,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnEdit,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnDelete,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(btnFirst,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnPrevious,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnNext,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnlast,
javax.swing.GroupLayout.PREFERRED_SIZE, 158,
javax.swing.GroupLayout.PREFERRED_SIZE))))
.addComponent(jScrollPane1,
javax.swing.GroupLayout.PREFERRED_SIZE, 857,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(47, 47, 47))
);
jPanel1Layout.setVerticalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(31, 31, 31)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASEL
INE)
.addComponent(jTextField6,
javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton8))
.addGap(18, 18, 18)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASEL
INE)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE,
34, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextReceipt,
javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE,
36, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextFirstName,
javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE,
34, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextLastName,
javax.swing.GroupLayout.PREFERRED_SIZE, 34,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASEL
INE)
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE,
35, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextTotal,
javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE,
36, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextDate,
javax.swing.GroupLayout.PREFERRED_SIZE, 36,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(31, 31, 31)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASEL
INE)
.addComponent(btnFirst)
.addComponent(btnPrevious)
.addComponent(btnNext)
.addComponent(btnlast))
.addGap(42, 42, 42)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASEL
INE)
.addComponent(btnAdd)
.addComponent(btnEdit)
.addComponent(btnDelete))
.addGap(18, 18, 18)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE))
);

getContentPane().add(jPanel1, new
org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 970, 760));

pack();
}// </editor-fold>

private void jTextTotalActionPerformed(java.awt.event.ActionEvent evt) {

private void btnlastActionPerformed(java.awt.event.ActionEvent evt) {

try {
rs.last();
String first = rs.getString("First_Name");
String last = rs.getString("Last_Name");
float total_col = rs.getInt("Total_Cost");
String total = Float.toString(total_col);
String date = rs.getString("Date");
int rn_col = rs.getInt("Receipt_No");
String rn = Integer.toString(rn_col);

jTextFirstName.setText(first);
jTextLastName.setText(last);
jTextTotal.setText(total);
jTextDate.setText(date);
jTextReceipt.setText(rn);
}
catch (SQLException err) {
JOptionPane.showMessageDialog(Main.this, err.getMessage());
}
}

private void btnEditActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:


}

private void btnNextActionPerformed(java.awt.event.ActionEvent evt) {

try {
if (rs. next()) {
rs.next();
String first = rs.getString("First_Name");
String last = rs.getString("Last_Name");
float total_col = rs.getInt("Total_Cost");
String total = Float.toString(total_col);
String date = rs.getString("Date");
int rn_col = rs.getInt("Receipt_No");
String rn = Integer.toString(rn_col);

jTextFirstName.setText(first);
jTextLastName.setText(last);
jTextTotal.setText(total);
jTextDate.setText(date);
jTextReceipt.setText(rn);
}
else {
rs.previous( );
JOptionPane.showMessageDialog(Main.this, "End of File");
}
}

catch (SQLException err) {


JOptionPane.showMessageDialog(Main.this, err.getMessage());
}
}

private void btnPreviousActionPerformed(java.awt.event.ActionEvent evt) {

try {
if (rs. previous()) {
rs.next();
String first = rs.getString("First_Name");
String last = rs.getString("Last_Name");
float total_col = rs.getInt("Total_Cost");
String total = Float.toString(total_col);
String date = rs.getString("Date");
int rn_col = rs.getInt("Receipt_No");
String rn = Integer.toString(rn_col);

jTextFirstName.setText(first);
jTextLastName.setText(last);
jTextTotal.setText(total);
jTextDate.setText(date);
jTextReceipt.setText(rn);
}
else {
rs.next( );
JOptionPane.showMessageDialog(Main.this, "End of File");
}
}

catch (SQLException err) {


JOptionPane.showMessageDialog(Main.this, err.getMessage());
}
}

private void btnFirstActionPerformed(java.awt.event.ActionEvent evt) {

try {
rs.first();
rs.next();
String first = rs.getString("First_Name");
String last = rs.getString("Last_Name");
float total_col = rs.getInt("Total_Cost");
String total = Float.toString(total_col);
String date = rs.getString("Date");
int rn_col = rs.getInt("Receipt_No");
String rn = Integer.toString(rn_col);

jTextFirstName.setText(first);
jTextLastName.setText(last);
jTextTotal.setText(total);
jTextDate.setText(date);
jTextReceipt.setText(rn);
}
catch (SQLException err) {
JOptionPane.showMessageDialog(Main.this, err.getMessage());
}
}

private void btnAddActionPerformed(java.awt.event.ActionEvent evt) {

/**
* @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(Main.class.getName()).log(java.util.logging.Leve
l.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Main.class.getName()).log(java.util.logging.Leve
l.SEVERE, null, ex);
} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(Main.class.getName()).log(java.util.logging.Leve
l.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(Main.class.getName()).log(java.util.logging.Leve
l.SEVERE, null, ex);
}
//</editor-fold>

/* Create and display the form */


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

// Variables declaration - do not modify


private javax.swing.JButton btnAdd;
private javax.swing.JButton btnDelete;
private javax.swing.JButton btnEdit;
private javax.swing.JButton btnFirst;
private javax.swing.JButton btnNext;
private javax.swing.JButton btnPrevious;
private javax.swing.JButton btnlast;
private javax.swing.JButton jButton8;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextDate;
private javax.swing.JTextField jTextField6;
private javax.swing.JTextField jTextFirstName;
private javax.swing.JTextField jTextLastName;
private javax.swing.JTextField jTextReceipt;
private javax.swing.JTextField jTextTotal;
// End of variables declaration
}

You might also like