The Artima Developer Community
Sponsored Link

Legacy Java Answers Forum
October 2001

Advertisement

Advertisement

This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

To retrieve data inserted by user

Posted by shashidhar on October 29, 2001 at 4:01 PM


Please , let me know how do i allow the user to enter data and update the database with the new values entered.
Thank you

//Description: This project implements CJFrame to display Table Data in window
//within text fields. ActionListener interface is implemented
//for buttons on the window to show data.


import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.border.*;


public class customerformentry extends CJFrame implements ActionListener
{
Container c;

JPanel dataPanel, controlPanel, statusPanel;

JTextField status,CustomerNumber, CustomerName, CustomerAddress1,CustomerAddress2,CustomerCity,CustomerState,
CustomerZipCode,CustomerTelephone,CustomerCreditLimit,
CustomerPrimaryContact;

JLabel Cnumber,Cname,Caddress1,Caddress2,City,State,Zip,
Telephone,Climit,Contact;

JButton first, prev, next, last, quit;

String[][] row; //gets data in the form of rows and column from JDBC
int k, i;

public customerformentry()
{

String db = "jdbc:odbc:shashi";
//this part is JDBC interface to get data
String user = ""; //from table
String pw = "";
Connection con;
Statement st;
ResultSet rs;

row = new String[54][20];

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(db, user, pw);
try
{
st = con.createStatement();
rs = st.executeQuery("SELECT * FROM tblCustomer");
k=0;
while(rs.next())
{
for(i = 0; i < 10; i++)
{
row[k][i] = rs.getString(i+1);
}
k++;
}
rs.close();
st.close();
}
catch(SQLException e)
{
System.out.println("SQLException in inner try block!");
System.out.println(e);
}
con.close();
}
catch(ClassNotFoundException e)
{
System.out.println("ClassNotFoundException!");
System.out.println(e);
}
catch(SQLException e)
{
System.out.println("SQLException in outer try block!");
System.out.println(e);
}

c = getContentPane();
//this part draws layout of window
c.setLayout(new BorderLayout(15, 15));

dataPanel = new JPanel();
//labels and text fields
dataPanel.setBorder(new TitledBorder("Data"));
dataPanel.setLayout(new GridLayout(10, 5,0 , 0));
Cnumber = new JLabel("Customernumber",10);
Cname = new JLabel("Customername",10);
Caddress1= new JLabel("Customeraddress1",10);
Caddress2= new JLabel("Customeraddress2",10);
City = new JLabel("CustomerCity",10);
State = new JLabel("CustomerState",10);
Zip = new JLabel("CustomerZipCodecode",10);
Telephone= new JLabel("CustomerTelephone",10);
Climit = new JLabel("credit limit",10);
Contact = new JLabel("primary CustomerPrimaryContact",10);


CustomerNumber = new JTextField(20);
CustomerName = new JTextField(20);
CustomerAddress1=new JTextField(20);
CustomerAddress2=new JTextField(20);
CustomerCity = new JTextField(20);
CustomerState = new JTextField(20);
CustomerZipCode=new JTextField(20);
CustomerTelephone=new JTextField(20);
CustomerCreditLimit = new JTextField(20);
CustomerPrimaryContact=new JTextField(20);


dataPanel.add(Cnumber);
dataPanel.add(CustomerNumber);
dataPanel.add(Cname);
dataPanel.add(CustomerName);
dataPanel.add(Caddress1);
dataPanel.add(CustomerAddress1);
dataPanel.add(Caddress2);
dataPanel.add(CustomerAddress2);
dataPanel.add(City);
dataPanel.add(CustomerCity);
dataPanel.add(State);
dataPanel.add(CustomerState);
dataPanel.add(Zip);
dataPanel.add(CustomerZipCode);
dataPanel.add(Telephone);
dataPanel.add(CustomerTelephone);
dataPanel.add(Climit);
dataPanel.add(CustomerCreditLimit);
dataPanel.add(Contact);
dataPanel.add(CustomerPrimaryContact);
c.add(dataPanel, BorderLayout.NORTH);

controlPanel = new JPanel(); //buttons to show data
controlPanel.setBorder(new TitledBorder("Control"));
controlPanel.setLayout(new GridLayout(1, 5));
first = new JButton("First");
first.addActionListener(this);
prev = new JButton("Prev");
prev.addActionListener(this);
next = new JButton("Next");
next.addActionListener(this);
last = new JButton("Last");
last.addActionListener(this);
quit = new JButton("Quit");
quit.addActionListener(this);
controlPanel.add(first);
controlPanel.add(prev);
controlPanel.add(next);
controlPanel.add(last);
controlPanel.add(quit);
c.add(controlPanel, BorderLayout.CENTER);

statusPanel = new JPanel();
//status text field
statusPanel.setBorder(new TitledBorder("Status"));
status = new JTextField(20);
statusPanel.add(status);
c.add(statusPanel, BorderLayout.SOUTH);
}

int m=0 , n=0;
public void actionPerformed(ActionEvent e)
//action listener interface
{
Object source = e.getSource();

if(source == first)
{
n = 0;
m = 0;
{
CustomerNumber.setText(row[n][m++]); CustomerName.setText(row[n][m++]);
CustomerAddress1.setText(row[n][m++]);
CustomerAddress2.setText(row[n][m++]);
CustomerCity.setText(row[n][m++]);
CustomerState.setText(row[n][m++]);
CustomerZipCode.setText(row[n][m++]);
CustomerTelephone.setText(row[n][m++]);
CustomerCreditLimit.setText(row[n][m++]);
CustomerPrimaryContact.setText(row[n][m]);
}
}
else
if(source == prev)
{
m = 0;
if(n == 0)
{
status.setText("At the first row.");
}
else
{

CustomerNumber.setText(row[--n][m++]);
CustomerName.setText(row[n][m++]);
CustomerAddress1.setText(row[n][m++]);
CustomerAddress2.setText(row[n][m++]);
CustomerCity.setText(row[n][m++]);
CustomerState.setText(row[n][m++]);
CustomerZipCode.setText(row[n][m++]);
CustomerTelephone.setText(row[n][m++]);
CustomerCreditLimit.setText(row[n][m++]);
CustomerPrimaryContact.setText(row[n][m]);

}
}
else
if(source == next)
{
m = 0;
if(n == k-1)
{
status.setText("At the last row.");
CustomerNumber.setText(row[n][m++]);
CustomerName.setText(row[n][m++]);
CustomerAddress1.setText(row[n][m++]);
CustomerAddress2.setText(row[n][m++]);
CustomerCity.setText(row[n][m++]);
CustomerState.setText(row[n][m++]);
CustomerZipCode.setText(row[n][m++]);
CustomerTelephone.setText(row[n][m++]);
CustomerCreditLimit.setText(row[n][m++]);
CustomerPrimaryContact.setText(row[n][m]);

}
else
{
CustomerNumber.setText(row[++n][m++]);
CustomerName.setText(row[n][m++]);
CustomerAddress1.setText(row[n][m++]);
CustomerAddress2.setText(row[n][m++]);
CustomerCity.setText(row[n][m++]);
CustomerState.setText(row[n][m++]);
CustomerZipCode.setText(row[n][m++]);
CustomerTelephone.setText(row[n][m++]);
CustomerCreditLimit.setText(row[n][m++]);
CustomerPrimaryContact.setText(row[n][m]);
}
}
else
if(source == last)
{
m = 0;
n = k-1;
{
CustomerNumber.setText(row[n][m++]);
CustomerName.setText(row[n][m++]);
CustomerAddress1.setText(row[n][m++]);
CustomerAddress2.setText(row[n][m++]);
CustomerCity.setText(row[n][m++]);
CustomerState.setText(row[n][m++]);
CustomerZipCode.setText(row[n][m++]);
CustomerTelephone.setText(row[n][m++]);
CustomerCreditLimit.setText(row[n][m++]);
CustomerPrimaryContact.setText(row[n][m]);

}
}
else
if(source == quit)
{
dispose();
System.exit(0);
}
return;
}

public static void main(String[] args)
//main program inside class
{
customerformentry gui;
gui = new customerformentry();
gui.setBounds(50, 25, 50, 50);
gui.pack();
gui.setVisible(true);
return;
}

}



Replies:
  • Update Matt Gerrans October 29, 2001 at 4:42 PM (0)

Sponsored Links



Google
  Web Artima.com   
Copyright © 1996-2009 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us