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)
|