asked on

How to enter JRadioButtons into Access Database and retrieve it out?

HI..

I am currently doing a vote system using JRadioButton and the problem is I can't capture the data clicked by JRadioButton into microsoft access database.I have linked using ODBC and it linked successfully but still I can't capture it out and retireve it for display.

Would appreciate anyone who can help in anyway.Thanks!

My coding are as follows...

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

public class VoteDialog extends JPanel {
 JButton voteButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The candidates";

 DataBase db = new DataBase();
Connection connection = db.getConnection();

public VoteDialog(JFrame frame) {
this.frame = frame;
JLabel title;

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a candidate.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;

final String defaultMessageCommand = "default";

radioButtons[0] = new JRadioButton("<html>Polythenic 1: Nanyang Poly</html>");
radioButtons[0].setActionCommand(defaultMessageCommand);

radioButtons[1] = new JRadioButton("<html>Polythenic 2: Singapore Poly</html>");
radioButtons[1].setActionCommand(defaultMessageCommand);

radioButtons[2] = new JRadioButton("<html>Polythenic 3: Temasek Poly</html>");
radioButtons[2].setActionCommand(defaultMessageCommand);

radioButtons[3] = new JRadioButton("<html>Polythenic 4: Republic Poly</html>");
radioButtons[3].setActionCommand(defaultMessageCommand);

 radioButtons[4] = new JRadioButton("<html>Polythenic 5: Ngee Ann Poly</html>");
radioButtons[4].setActionCommand(defaultMessageCommand);

// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);
}
voteButton = new JButton("Vote");

voteButton.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();

 if(e.getSource()==voteButton) {

 String insertString;
 Statement statement;

 if (radioButtons[i]=radioButtons[0]) {
 int p1= Integer.parseInt(radioButtons[0].getText());
 int p2= Integer.parseInt(radioButtons[1].getText());
 int p3= Integer.parseInt(radioButtons[2].getText());
 int p4= Integer.parseInt(radioButtons[3].getText());
 int p5= Integer.parseInt(radioButtons[4].getText());

 insertString = "Insert into poly (nyp, sp, tp, rp, np) "+
 " VALUES ( '"+ p1 +"', '"+ p2 +"', '"+ p3 +"', '"+ p4 +"','"+ p5 +"')";

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}

 }
 }
// ok dialog
if (command == defaultMessageCommand) {
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");
 }
return;
}

});

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}

CEHJ

If you're inserting ints then they shouldn't be quoted

CEHJ

e.g.

" VALUES ("+ p1 + ","+ p2

etc.

ASKER CERTIFIED SOLUTION

CEHJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CEHJ

Or

if (radioButtons[i]==radioButtons[0])

ProfJL

ASKER

Hi CEHJ...

I had changed my codes but when i used if (radioButtons[i]==radioButtons[0]) ....it say

C:\Documents and Settings\JL\Desktop\filechooser\VoteDialog.java:99: cannot resolve symbol
symbol: variable i
            if (radioButtons[i]==radioButtons[0]) {
}

wat should i do to solve this problem..??

anyway I wann add in number to my database once the user clicked on 1 of the choice like if one user chose the first option of the JradioButton it will enter 1 in the database.Upon clicking the second time it will add on to the number like if the user clicked the first option of the JRadioButton again it will add into the database to 2.

I have tried this method but dunno if it works..
      if (radioButtons[i]==radioButtons[0]) {
                        p1=0+1;
                        p1++;
                  }

CEHJ

>>I had changed my codes but when i used ...

It would have said that anyway. There is no variable 'i' in scope there

I'm not entirely sure what you're trying to achieve

ProfJL

ASKER

I am actually trying to do a voting system of some choices...meaning once a user clicked on one fo the choices it will add "1" to the database and upon clikcing on the second time on the same option..it would add the number automatically to "2" meaning it will keep adding..

>>I had changed my codes meaning i change all the parts quoted

Below is my new codes...

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

public class VoteDialog extends JPanel {
 JButton voteButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The candidates";

 DataBase db = new DataBase();
Connection connection = db.getConnection();

public VoteDialog(JFrame frame) {
this.frame = frame;
JLabel title;

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a candidate.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;

final String defaultMessageCommand = "default";

radioButtons[0] = new JRadioButton("<html>Polythenic 1: Nanyang Poly</html>");
radioButtons[0].setActionCommand(defaultMessageCommand);

radioButtons[1] = new JRadioButton("<html>Polythenic 2: Singapore Poly</html>");
radioButtons[1].setActionCommand(defaultMessageCommand);

radioButtons[2] = new JRadioButton("<html>Polythenic 3: Temasek Poly</html>");
radioButtons[2].setActionCommand(defaultMessageCommand);

radioButtons[3] = new JRadioButton("<html>Polythenic 4: Republic Poly</html>");
radioButtons[3].setActionCommand(defaultMessageCommand);

 radioButtons[4] = new JRadioButton("<html>Polythenic 5: Ngee Ann Poly</html>");
radioButtons[4].setActionCommand(defaultMessageCommand);

// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);}

voteButton = new JButton("Vote");

voteButton.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();

 if(e.getSource()==voteButton) {
 int p1,p2,p3,p4,p5;
 String insertString;
 Statement statement;

 while (radioButtons[i]==radioButtons[0]) {
 p1=0+1;
 p1++;

 p1= Integer.parseInt(radioButtons[0].getText());
 p2= Integer.parseInt(radioButtons[1].getText());
 p3= Integer.parseInt(radioButtons[2].getText());
 p4= Integer.parseInt(radioButtons[3].getText());
 p5= Integer.parseInt(radioButtons[4].getText());


 }
 insertString = "Insert into poly (nyp, sp, np, rp, tp) "+
 " VALUES ( "+ p1 +", "+ p2 +", "+ p3 +", "+ p4 +","+ p5 +")";

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}

 }

// ok dialog
if (command == defaultMessageCommand)
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");

return;

}

});

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}

however i still get the problem that 'i" is not resolve varibale...wat shld I do to solve that..thanks..

CEHJ

I would hold the count in a parallel array. Obviously you need to get the value of the radio buttons 'on submit' or you'd have chaos as people changed their minds:

int[] voteCounts = new int[radioButtons.length];
// (if first button selected)
voteCounts[0]++;

ProfJL

ASKER

I had added in the follwing codes and compiled with success but however when i clicked the "vote button" it shows errors shown below:

java.lang.NumberFormatException: For input string: "<html>Polythenic 1: Nanyang Poly</html>"
at java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
at java.lang.Integer.parseInt(Integer.java:468)
at java.lang.Integer.parseInt(Integer.java:518)
at VoteDialog$1.actionPerformed(VoteDialog.java:97)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
86)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

what is happening..plz enlighten me..thanks.

CEHJ

You're trying to convert that unconvertable radio button text to a number

ProfJL

ASKER

I changed all the text to number and it worked but how do i set all the number to "0" first and then if it clicked on "1" it will go to that column in the database and add on it only..Upon clicking on "1" the second time it will add from 1 to 2 and so on..

"1" is the first option that i had set.
I thought of using your way like

// (if first button selected)---------->what do i put here for the choices?
voteCounts[0]++;

My codes are shown below..

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

public class VoteDialog extends JPanel {
 JButton voteButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The candidates";

 DataBase db = new DataBase();
Connection connection = db.getConnection();

public VoteDialog(JFrame frame) {
this.frame = frame;
JLabel title;

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a candidate.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;

final String defaultMessageCommand = "default";

radioButtons[0] = new JRadioButton("1");
radioButtons[0].setActionCommand(defaultMessageCommand);

radioButtons[1] = new JRadioButton("2");
radioButtons[1].setActionCommand(defaultMessageCommand);

radioButtons[2] = new JRadioButton("3");
radioButtons[2].setActionCommand(defaultMessageCommand);

radioButtons[3] = new JRadioButton("4");
radioButtons[3].setActionCommand(defaultMessageCommand);

 radioButtons[4] = new JRadioButton("5");
radioButtons[4].setActionCommand(defaultMessageCommand);

// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);}

voteButton = new JButton("Vote");

voteButton.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();

 if(e.getSource()==voteButton) {
 int p1,p2,p3,p4,p5;
 String insertString;
 Statement statement;

 int[] voteCounts = new int[radioButtons.length];
 //if ( voteCounts[0].selected)
 voteCounts[0]++;

 //p1=0+1;
 //p1++;

 p1= Integer.parseInt(radioButtons[0].getText());
 p2= Integer.parseInt(radioButtons[1].getText());
 p3= Integer.parseInt(radioButtons[2].getText());
 p4= Integer.parseInt(radioButtons[3].getText());
 p5= Integer.parseInt(radioButtons[4].getText());



 insertString = "Insert into poly (nyp, sp, np, rp, tp) "+
 " VALUES ( "+ p1 +", "+ p2 +", "+ p3 +", "+ p4 +","+ p5 +")";

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}



// ok dialog
if (command == defaultMessageCommand)
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");

return;
}
}

});

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}

CEHJ

>>int[] voteCounts = new int[radioButtons.length];

You don't put that in the ActionListener or it'll get created every time it's called. You need to create it only once.

From here:

String command = group.getSelection().getActionCommand();

you need to do

int numberChosen = Integer.parseInt(command);
voteCounts[--numberChosen]++;

ProfJL

ASKER

It doesn't seem to work and now it can't add into database..

an error occurs like this shown:

java.lang.NumberFormatException: For input string: "default"
at java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
at java.lang.Integer.parseInt(Integer.java:468)
at java.lang.Integer.parseInt(Integer.java:518)
at VoteDialog$1.actionPerformed(VoteDialog.java:89)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
86)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

CEHJ

Make sure one button is always selected

CEHJ

And the action commands should all be numbers - at the moment you're using "default'

ProfJL

ASKER

I changed the "default" to number "1" and I can insert into the database. However it is still adding all the options "1", "2", "3", "4", "5" all at the same time to the database.what I wanted is to insert only the option that you selected.

My codes are as shown:

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

public class VoteDialog extends JPanel {
 JButton voteButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The candidates";

 DataBase db = new DataBase();
Connection connection = db.getConnection();

public VoteDialog(JFrame frame) {
this.frame = frame;
JLabel title;

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a candidate.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;

final String defaultMessageCommand = "1";

radioButtons[0] = new JRadioButton("1");
radioButtons[0].setActionCommand(defaultMessageCommand);

radioButtons[1] = new JRadioButton("2");
radioButtons[1].setActionCommand(defaultMessageCommand);

radioButtons[2] = new JRadioButton("3");
radioButtons[2].setActionCommand(defaultMessageCommand);

radioButtons[3] = new JRadioButton("4");
radioButtons[3].setActionCommand(defaultMessageCommand);

 radioButtons[4] = new JRadioButton("5");
radioButtons[4].setActionCommand(defaultMessageCommand);

// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);}

voteButton = new JButton("Vote");

voteButton.addActionListener(new ActionListener() {


 int[] voteCounts = new int[radioButtons.length];
public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();


 int numberChosen = Integer.parseInt(command);
 voteCounts[--numberChosen]++;

 if(e.getSource()==voteButton) {
 int p1,p2,p3,p4,p5;
 String insertString;
 Statement statement;





 p1= Integer.parseInt(radioButtons[0].getText());
 p2= Integer.parseInt(radioButtons[1].getText());
 p3= Integer.parseInt(radioButtons[2].getText());
 p4= Integer.parseInt(radioButtons[3].getText());
 p5= Integer.parseInt(radioButtons[4].getText());



 insertString = "Insert into poly (nyp, sp, np, rp, tp) "+
 " VALUES ( "+ p1 +", "+ p2 +", "+ p3 +", "+ p4 +","+ p5 +")";

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}



// ok dialog
if (command == defaultMessageCommand)
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");

return;
}
}

});

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}

CEHJ

You're now setting all the buttons to the same value. The action commands should be numbered from 1 to 5. You need to insert the values of the array voteCounts into the database

CEHJ

So

>>" VALUES ( "+ p1 +", "+ p2 +", "+ p3 +", "+ p4 +","+ p5 +")";

should be

" VALUES ( "+ voteCounts[0] +", "+ voteCounts1] +", "+ voteCounts[2] +", "+ voteCounts[3] +","+ voteCounts[4] +")";

ProfJL

ASKER

>>You're now setting all the buttons to the same value. The action commands should be numbered from 1 to 5.

I don't wat u mean by this..can u show it out to me..?? thanks..Sorry for the inconvenience.

ProfJL

ASKER

hi I had changed my coding to it but it still doesn't works..y does it keep adding everything into the database?

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

public class VoteDialog extends JPanel {
 JButton voteButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The candidates";

 DataBase db = new DataBase();
Connection connection = db.getConnection();

public VoteDialog(JFrame frame) {
this.frame = frame;
JLabel title;

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a candidate.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;

String defaultMessageCommand = "1";

radioButtons[0] = new JRadioButton("1");
radioButtons[0].setActionCommand(defaultMessageCommand);

radioButtons[1] = new JRadioButton("2");
radioButtons[1].setActionCommand(defaultMessageCommand);

radioButtons[2] = new JRadioButton("3");
radioButtons[2].setActionCommand(defaultMessageCommand);

radioButtons[3] = new JRadioButton("4");
radioButtons[3].setActionCommand(defaultMessageCommand);

 radioButtons[4] = new JRadioButton("5");
radioButtons[4].setActionCommand(defaultMessageCommand);

// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);}

voteButton = new JButton("Vote");

voteButton.addActionListener(new ActionListener() {


 int[] voteCounts = new int[radioButtons.length];
public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();


 int numberChosen = Integer.parseInt(command);
 voteCounts[--numberChosen]++;

 if(e.getSource()==voteButton) {

 String insertString;
 Statement statement;

 if(numberChosen==1) {

 voteCounts[0]= Integer.parseInt(radioButtons[0].getText());
 insertString = "Insert into poly (nyp) "+
 " VALUES ( "+ voteCounts[0] +")";
 }

 if(numberChosen==2) {

 voteCounts[1]= Integer.parseInt(radioButtons[1].getText());
 insertString = "Insert into poly (sp) "+
 " VALUES ( "+ voteCounts[1] +")";
 }
 if(numberChosen==3) {

 voteCounts[2]= Integer.parseInt(radioButtons[2].getText());
 insertString = "Insert into poly (np) "+
 " VALUES ( "+ voteCounts[2] +")";
 }
 if(numberChosen==4) {

 voteCounts[3]= Integer.parseInt(radioButtons[3].getText());
 insertString = "Insert into poly (rp) "+
 " VALUES ( "+ voteCounts[3] +")";
 }
 if(numberChosen==5) {

 voteCounts[4]= Integer.parseInt(radioButtons[4].getText());
 insertString = "Insert into poly (tp) "+
 " VALUES ( "+ voteCounts[4] +")";
 }


 //voteCounts[1]= Integer.parseInt(radioButtons[1].getText());
 //voteCounts[2]= Integer.parseInt(radioButtons[2].getText());
 //voteCounts[3]= Integer.parseInt(radioButtons[3].getText());
 //voteCounts[4]= Integer.parseInt(radioButtons[4].getText());



 // insertString = "Insert into poly (nyp, sp, np, rp, tp) "+
 //" VALUES ( "+ voteCounts[0] +", "+ voteCounts[1] +", "+ voteCounts[2] +", "+ voteCounts[3] +","+ voteCounts[4] +")";

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}



// ok dialog
if (command == defaultMessageCommand)
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");

return;
}
}

});

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}

ProfJL

ASKER

Hi CEHJ..

can u just help mi 1 last time by telling mi how to insert string from JRadioButtons into the microsoft access database??

Thanks

CEHJ

>>I don't wat u mean by this..can u show it out to me..??

>>String defaultMessageCommand = "1";

All action commands on all buttons get set to this value, which is wrong

ProfJL

ASKER

ok thanks//

can u tell mi how to insert string from JRadioButtons into the microsoft access database??

Thanks

CEHJ

>>can u tell mi how to insert string from JRadioButtons into the microsoft access database??

Depends on whether you want to make an insert for each vote, or only at the end on the basis of cumulative votes

ProfJL

ASKER

I want to insert string into the microsoft access database for each vote like if i click on the first option of the JRadioButton with text "nyp" , it will add it into the NYP column of the database only.

Thanks.

CEHJ

As i mentioned before, that's not how your interface should work or you'll get garbage in the database. What you should have is something like 'Choose your vote by clicking on....' then 'When you have done that, confirm your vote by clicking on the 'Confirm' button...'

Then you need an update statement to increase the count for that particular institution

ProfJL

ASKER

That mean i don't use JRadioButtons for my voting system?
I will need to create 4 buttons for my choices
and add actionlistener in them..
Lastly then add into access database?

CEHJ

Yes, of course you use radio buttons - that's how they'd make their exclusive choice. You only need *one* confirm button. The database gets updated on confirmation

ProfJL

ASKER

can i know the coding for the event handler of the confirm button??

CEHJ

String command = group.getSelection().getActionCommand();
updateDatabase(Integer.parseInt(command));

Then write a small method to do the update called 'updateDatabase'

ProfJL

ASKER

Hi CEHJ..would you please help me to finish up the rest of the coding because I am really urgently need this system to be done and It quite waste of time doing it step by step by myself which i don't know.Would really appreciate if yopu could help me out this time round.

import java.io.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import javax.swing.filechooser.*;
import java.applet.Applet;
import java.applet.AudioClip;
import java.awt.Event;
import javax.swing.text.*;
import java.sql.*;
import java.text.*;

public class VoteDialog extends JPanel implements ActionListener {
 JButton voteButton;
 JButton confirmButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The candidates";


 DataBase db = new DataBase();
Connection connection = db.getConnection();

public VoteDialog(JFrame frame) {
this.frame = frame;
JLabel title;

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a candidate.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;
 final JButton confirmButton;


radioButtons[0] = new JRadioButton("1");

 radioButtons[1] = new JRadioButton("2");

radioButtons[2] = new JRadioButton("3");

radioButtons[3] = new JRadioButton("4");


 radioButtons[4] = new JRadioButton("5");

// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);
}

 voteButton = new JButton("Vote");
confirmButton = new JButton("confirm");
confirmButton.addActionListener(this);
voteButton.addActionListener(this);


 int[] voteCounts = new int[radioButtons.length];

public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();
 updateDatabase(Integer.parseInt(command));


 int numberChosen = Integer.parseInt(command);
 voteCounts[--numberChosen]++;

 if(e.getSource()==voteButton) {

 String insertString;
 Statement statement;




 voteCounts[0]= Integer.parseInt(radioButtons[0].getText());
 voteCounts[1]= Integer.parseInt(radioButtons[1].getText());
 voteCounts[2]= Integer.parseInt(radioButtons[2].getText());
 voteCounts[3]= Integer.parseInt(radioButtons[3].getText());
 voteCounts[4]= Integer.parseInt(radioButtons[4].getText());



 insertString = "Insert into poly (nyp, sp, np, rp, tp) "+
 " VALUES ( "+ voteCounts[0] +", "+ voteCounts[1] +", "+ voteCounts[2] +", "+ voteCounts[3] +","+ voteCounts[4] +")";

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}




}
}

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
confirmButton,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}

CEHJ

I'm not going to code it for you, but i'll supervise your doing it in easy steps if you want. The first step will be this:

1. Post the code that simply displays a panel containing the radio buttons *only* in a group, with their action commands set to the right numbers. Make sure it is runnable

ProfJL

ASKER

Hi CEHJ..
thanks for your help my vote is more or less done..However I can't seem to add actionListener to my vote application.

It will prompt errors whenever I want to implements actionlistener to a JButton like: Identifier needed etc..Below are my codes..

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.text.*;
import javax.swing.event.*;
import javax.swing.text.*;
import java.util.*;

public class VoteDialog extends JPanel {
 JButton voteButton;
JLabel label;
JFrame frame;
String simpleDialogDesc = "The Polythenics";
 JButton backButton;

 DataBase db = new DataBase();
Connection connection = db.getConnection();

 private boolean DEBUG = true;

public VoteDialog(JFrame frame) {

this.frame = frame;
JLabel title;

ArrayList nameList =new ArrayList();

String[] columnNames = {"NYP",
 "SP",
 "NP",
 "RP",
"TP"};

String query;
Statement statement;
ResultSet rs;

String nyp="";
String sp="";
String np="";
String rp="";
String tp="";

voteinfo s1;
int i=0;

query = "SELECT * FROM poly";

try{
statement = connection.createStatement();
rs = statement.executeQuery(query);

while (rs.next()){


 nyp = rs.getString("NYP");
sp = rs.getString("SP");
np = rs.getString("NP");
rp = rs.getString("RP");
tp = rs.getString("TP");
s1= new voteinfo(nyp,sp,np,rp,tp);
nameList.add(s1);
i++;

}
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}

Object[][] data = new Object[i][5];
int count=0;
while (count<i){
 s1 = (voteinfo) nameList.get(count);
 System.out.println("poly:" + s1.getp1());
 System.out.println("poly:" + s1.getp2());
 System.out.println("poly:" + s1.getp3());
 System.out.println("poly:" + s1.getp4());
 System.out.println("poly:" + s1.getp5());

 data[count][0] = s1.getp1();
 data[count][1] = s1.getp2();
 data[count][2] = s1.getp3();
 data[count][3] = s1.getp4();
 data[count][4] = s1.getp5();

count++;

}

final JTable table = new JTable(data, columnNames);
table.setPreferredScrollableViewportSize(new Dimension(100, 100));
//
//Create the scroll pane and add the table to it.
JScrollPane scrollPane = new JScrollPane(table);

// Create the components.
JPanel choicePanel = createSimpleDialogBox();

System.out.println("passed createSimpleDialogBox");

title = new JLabel("Click the \"Vote\" button"
+ " once you have selected a poly.",
JLabel.CENTER);

label = new JLabel("Vote now!", JLabel.CENTER);
 label.setBorder(BorderFactory.createEmptyBorder(10,10,10,10));
choicePanel.setBorder(BorderFactory.createEmptyBorder(20,20,5,20));

// Set the layout.
setLayout(new BorderLayout());
add(title, BorderLayout.NORTH);
add(label, BorderLayout.SOUTH);
add(choicePanel, BorderLayout.CENTER);
//Add the scroll pane to this window.
add(scrollPane, BorderLayout.EAST);
}

void setLabel(String newText) {
label.setText(newText);
}

private JPanel createSimpleDialogBox() {
final int numButtons = 5;
final JRadioButton[] radioButtons = new JRadioButton[numButtons];

final ButtonGroup group = new ButtonGroup();

final JButton voteButton;

final String action1 = "1";
final String action2 = "2";
final String action3 = "3";
final String action4 = "4";
final String action5 = "5";

radioButtons[0] = new JRadioButton("1");
radioButtons[0].setActionCommand(action1);
JLabel nyp = new JLabel("<html>NanYang Polythenic</html>");
 nyp.setBounds(60,33,150,60);
 add (nyp);

radioButtons[1] = new JRadioButton("2");
radioButtons[1].setActionCommand(action2);
JLabel sp = new JLabel("<html>Singapore Polythenic</html>");
 sp.setBounds(60,58,150,60);
 add (sp);


radioButtons[2] = new JRadioButton("3");
radioButtons[2].setActionCommand(action3);
JLabel np = new JLabel("<html>Ngee Ann Polythenic</html>");
 np.setBounds(60,81,150,60);
 add (np);


radioButtons[3] = new JRadioButton("4");
radioButtons[3].setActionCommand(action4);
JLabel rp = new JLabel("<html>Republic Polythenic</html>");
 rp.setBounds(60,107,150,60);
 add (rp);


 radioButtons[4] = new JRadioButton("5");
radioButtons[4].setActionCommand(action5);
JLabel tp = new JLabel("<html>Singapore Polythenic</html>");
 tp.setBounds(60,130,150,60);
 add (tp);


// Select the first button by default.
radioButtons[0].setSelected(true);

 for (int i = 0; i < numButtons; i++) {
group.add(radioButtons[i]);
}

voteButton = new JButton("Vote");
backButton = new JButton("Back");

voteButton.addActionListener(new ActionListener() {


 int[] voteCounts = new int[radioButtons.length];

 String insertString;

public void actionPerformed(ActionEvent e) {
 String command = group.getSelection().getActionCommand();




 int numberChosen = Integer.parseInt(command);
 voteCounts[numberChosen]++;

 if(e.getSource()==voteButton) {


 Statement statement;

 if (command == action1) {
voteCounts[0]= Integer.parseInt(radioButtons[0].getText());
insertString = "Insert into poly (nyp) "+
 " VALUES ( "+ voteCounts[0] +")";
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");
}

 // ok dialog
if (command == action2) {
voteCounts[1]= Integer.parseInt(radioButtons[1].getText());
insertString = "Insert into poly (sp) "+
 " VALUES ( "+ voteCounts[1] +")";
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");
}
 if (command == action3) {
voteCounts[2]= Integer.parseInt(radioButtons[2].getText());
insertString = "Insert into poly (np) "+
 " VALUES ( "+ voteCounts[2] +")";
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");
}
if (command == action4) {
voteCounts[3]= Integer.parseInt(radioButtons[3].getText());
insertString = "Insert into poly (rp) "+
 " VALUES ( "+ voteCounts[3] +")";
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");
}
if (command == action5) {
voteCounts[4]= Integer.parseInt(radioButtons[4].getText());
insertString = "Insert into poly (tp) "+
 " VALUES ( "+ voteCounts[4] +")";
 JOptionPane.showMessageDialog(frame,
"Your Vote Han Been Counted");
}

 try{
statement = connection.createStatement();
statement.executeUpdate(insertString);
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}




}

});

 System.out.println("calling createPane");
return createPane(simpleDialogDesc + ":",
radioButtons,
voteButton);
}

private JPanel createPane(String description,
JRadioButton[] radioButtons,
JButton showButton) {
int numChoices = radioButtons.length;
JPanel box = new JPanel();
JLabel label = new JLabel(description);

box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
box.add(label);

for (int i = 0; i < numChoices; i++) {
box.add(radioButtons[i]);
}

JPanel pane = new JPanel();
pane.setLayout(new BorderLayout());
pane.add(box, BorderLayout.NORTH);
pane.add(showButton, BorderLayout.SOUTH);
System.out.println("returning pane");
return pane;
}




public static void main(String[] args) {
JFrame frame = new JFrame("VoteDialog");

Container contentPane = frame.getContentPane();
contentPane.setLayout(new GridLayout(1,1));
contentPane.add(new VoteDialog(frame));

// Exit when the window is closed.
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.pack();
frame.setVisible(true);
}
}