good day guys,
please help:
i'm having trouble of displaying my data from ms access database to JList. if there's someone could help me, i would greatly appreciate it. i'm using netbeans 6.0 for developing an application. here is my code so far:
note: some of my code is auto generated by netbeans JDK.
thanks guys for helping me.
2 days have been passed and still i can't get pass with this. thanks again...
please help:
i'm having trouble of displaying my data from ms access database to JList. if there's someone could help me, i would greatly appreciate it. i'm using netbeans 6.0 for developing an application. here is my code so far:
note: some of my code is auto generated by netbeans JDK.
Code:
/*TO GOD BE THE GLORY! I CAN DO ALL THINGS THROUGH CHRIST WHO STRENGHTENS ME!
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* MainForm.java
*
* Created on Feb 4, 2011, 8:41:45 AM
*/
package UsernamePasswordPackage;
import java.awt.Color;
import java.sql.*;
import javax.swing.*;
/**
*
* @author jmoreno
*/
public class MainForm extends javax.swing.JFrame {
/** Creates new form MainForm */
DefaultListModel list = new DefaultListModel();
public MainForm() {
this.setTitle("Username & Password Manager");
initComponents();
jButton1.requestFocus();
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jList1.clearSelection();
jButton5.setBackground(Color.getHSBColor(0, 217, 114));
//PopulatejList();
}
/** 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() {
jPanel1 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jList1 = new javax.swing.JList();
jLabel1 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jTextField2 = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jTextField3 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jButton5 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DO_NOTHING_ON_CLOSE);
setResizable(false);
jList1.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
jList1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jList1MouseClicked(evt);
}
});
jScrollPane1.setViewportView(jList1);
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 16));
jLabel1.setText("Username :");
jTextField1.setFont(new java.awt.Font("Tahoma", 0, 16));
jTextField1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField1ActionPerformed(evt);
}
});
jTextField1.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jTextField1KeyPressed(evt);
}
});
jTextField2.setFont(new java.awt.Font("Tahoma", 0, 16));
jTextField2.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jTextField2KeyPressed(evt);
}
});
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 16));
jLabel2.setText("Password :");
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 16));
jLabel3.setText("Website :");
jTextField3.setFont(new java.awt.Font("Tahoma", 0, 16));
jTextField3.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jTextField3KeyPressed(evt);
}
});
jButton1.setText("Add");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton1.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jButton1KeyPressed(evt);
}
});
jButton2.setText("Edit");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton2.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jButton2KeyPressed(evt);
}
});
jButton3.setText("Save");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton3.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jButton3KeyPressed(evt);
}
});
jButton4.setText("Cancel");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jButton4.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jButton4KeyPressed(evt);
}
});
jButton5.setText("Exit");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jButton5.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jButton5KeyPressed(evt);
}
});
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.TRAILING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 223, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addContainerGap(20, Short.MAX_VALUE))
);
jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jTextField1, jTextField2, jTextField3});
jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jLabel1, jLabel2, jLabel3});
jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jButton1, jButton2, jButton3, jButton4, jButton5});
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 172, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton2)
.addComponent(jButton3)
.addComponent(jButton4)
.addComponent(jButton5))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel1Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jTextField1, jTextField2, jTextField3});
jPanel1Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jLabel1, jLabel2, jLabel3});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-405)/2, (screenSize.height-396)/2, 405, 396);
}// </editor-fold>
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int choose = JOptionPane.showConfirmDialog(null,"Continue to add new record?","Add New Record",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(choose == JOptionPane.OK_OPTION){
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton3.setEnabled(true);
jButton4.setEnabled(true);
jButton5.setEnabled(false);
jTextField1.setEnabled(true);
jTextField2.setEnabled(true);
jTextField3.setEnabled(true);
jTextField1.requestFocus();
}else if(choose == JOptionPane.CANCEL_OPTION){
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jButton1.requestFocus();
}
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
JOptionPane.showMessageDialog(null,"You have been cancelled the adding of new record/s.");
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
}
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int choose = JOptionPane.showConfirmDialog(null,"Continue to exit?.","Exit",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(choose == JOptionPane.YES_OPTION){
this.dispose();
}else if(choose == JOptionPane.NO_OPTION){
jButton1.requestFocus();
return;
}
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(jTextField1.getText().isEmpty()){
JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
if(jTextField1.getText().isEmpty()){
jTextField1.requestFocus();
}
return;
}
else if(jTextField2.getText().isEmpty()){
JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
if(jTextField2.getText().isEmpty()){
jTextField2.requestFocus();
}
return;
}
else if(jTextField3.getText().isEmpty()){
JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
if(jTextField3.getText().isEmpty()){
jTextField3.requestFocus();
}
return;
}
int choose = JOptionPane.showConfirmDialog(null,"Continue to save new record?","Confirmation",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(choose == JOptionPane.YES_OPTION){
String text1 = jTextField1.getText();
String text2 = jTextField2.getText();
String text3 = jTextField3.getText();
String dbuser = "";
String dbpasswd = "";
String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
String SQLString = "INSERT INTO Table1(Username,Password,Website)VALUES('"+text1+"','"+text2+"','"+text3+"')";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
return;
}
Statement stmt = null;
Connection con = null;
try{
//con = DriverManager.getConnection("jdbc:odbc:db1.mdb");
//con = DriverManager.getConnection(DriverPrefix+DataSource,dbuser,dbpasswd);
con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
stmt = con.createStatement();
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
}
try{
stmt.executeUpdate(SQLString);
con.close();
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jButton1.requestFocus();
}
catch(SQLException e){
JOptionPane.showMessageDialog(null,"Check that all TextFields have been completed.\n"+e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
}
}
else{
jTextField1.setText("");
jTextField1.setEnabled(false);
jTextField2.setText("");
jTextField2.setEnabled(false);
jTextField3.setText("");
jTextField3.setEnabled(false);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jButton1.requestFocus();
}
}
private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton3.setEnabled(true);
jButton4.setEnabled(true);
jButton5.setEnabled(false);
jTextField1.setEnabled(true);
jTextField2.setEnabled(true);
jTextField3.setEnabled(true);
jTextField1.requestFocus();
}
private void jTextField1KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
jTextField2.requestFocus();
}
}
private void jTextField2KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
jTextField3.requestFocus();
}
}
private void jTextField3KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
jButton3.requestFocus();
}
}
private void jButton1KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
int choose = JOptionPane.showConfirmDialog(null,"Continue to add new record?","Add New Record",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(choose == JOptionPane.OK_OPTION){
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton3.setEnabled(true);
jButton4.setEnabled(true);
jButton5.setEnabled(false);
jTextField1.setEnabled(true);
jTextField2.setEnabled(true);
jTextField3.setEnabled(true);
jTextField1.requestFocus();
}else if(choose == JOptionPane.CANCEL_OPTION){
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jButton1.requestFocus();
}
}
}
private void jButton2KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton3.setEnabled(true);
jButton4.setEnabled(true);
jButton5.setEnabled(false);
jTextField1.setEnabled(true);
jTextField2.setEnabled(true);
jTextField3.setEnabled(true);
jTextField1.requestFocus();
}
}
private void jButton3KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
if(jTextField1.getText().isEmpty()){
JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
if(jTextField1.getText().isEmpty()){
jTextField1.requestFocus();
}
return;
}
else if(jTextField2.getText().isEmpty()){
JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
if(jTextField2.getText().isEmpty()){
jTextField2.requestFocus();
}
return;
}
else if(jTextField3.getText().isEmpty()){
JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
if(jTextField3.getText().isEmpty()){
jTextField3.requestFocus();
}
return;
}
int choose = JOptionPane.showConfirmDialog(null,"Continue to save new record?","Confirmation",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(choose == JOptionPane.YES_OPTION){
String text1 = jTextField1.getText();
String text2 = jTextField2.getText();
String text3 = jTextField3.getText();
String dbuser = "";
String dbpasswd = "";
String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
String SQLString = "INSERT INTO Table1(Username,Password,Website)VALUES('"+text1+"','"+text2+"','"+text3+"')";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
return;
}
Statement stmt = null;
Connection con = null;
try{
//con = DriverManager.getConnection("jdbc:odbc:db1.mdb");
//con = DriverManager.getConnection(DriverPrefix+DataSource,dbuser,dbpasswd);
con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
stmt = con.createStatement();
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
}
try{
stmt.executeUpdate(SQLString);
con.close();
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jButton1.requestFocus();
}
catch(SQLException e){
JOptionPane.showMessageDialog(null,"Check that all TextFields have been completed.\n"+e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
}
}
else{
jTextField1.setText("");
jTextField1.setEnabled(false);
jTextField2.setText("");
jTextField2.setEnabled(false);
jTextField3.setText("");
jTextField3.setEnabled(false);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jButton1.requestFocus();
}
}
}
private void jButton4KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
JOptionPane.showMessageDialog(null,"You have been cancelled the adding of new record/s.");
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(true);
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
}
}
private void jButton5KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==10){
int choose = JOptionPane.showConfirmDialog(null,"Continue to exit?.","Exit",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(choose == JOptionPane.YES_OPTION){
this.dispose();
}else if(choose == JOptionPane.NO_OPTION){
jButton1.requestFocus();
return;
}
}
}
private void jList1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
}
public void PopulatejList(){
String dbuser = "";
String dbpasswd = "";
String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
String SQLString = ("select * from Table1");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
return;
}
Statement stmt = null;
Connection con = null;
ResultSet rset = null;
try{
con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
stmt = con.createStatement();
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
}
try{
rset = stmt.executeQuery(SQLString);
String Add;
while(rset.next()){
Add = rset.getString("ID")+rset.getString("Username")+rset.getString("Password")+
rset.getString("Website");
list.addElement(Add);
}
con.close();
}
catch(SQLException e){
JOptionPane.showMessageDialog(null,e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
}
jList1 = new JList(list);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) throws SQLException {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new MainForm().setVisible(true);
MainForm MF = new MainForm();
MF.PopulatejList();
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JList jList1;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
// End of variables declaration
}
2 days have been passed and still i can't get pass with this. thanks again...