We are trying to implement java swing and Database using MS Access.My project is on Billing system

We are trying to implement java swing and Database using MS Access.My
project is on Billing system

import java.io.; import javax.swing.; import javax.swing.event.; import
javax.swing.border.TitledBorder; import javax.swing.BorderFactory; import
javax.swing.border.Border; import java.awt.; import javax.swing.Icon;
import java.awt.event.ItemEvent; import java.awt.event.ItemListener;
import java.sql.*; import java.awt.event.ActionListener; import
java.awt.event.ActionEvent; public class trial extends JFrame { JCheckBox
c1,c2,c3,c4,c5,c6,c7; JButton b1; JTextField textFieldSum; JLabel
labelSum; private int sum = 0; Connection con; Statement pst; trial() {
Container c=getContentPane(); JPanel p=new JPanel(new GridLayout(0,3));
Border border1=BorderFactory.createTitledBorder("Chilled Beverages");
p.setBorder(border1); ImageIcon rollIcon = new ImageIcon("download.jpg");
ActionListener at=new ActionHandler(); c1=new JCheckBox("Coca Cola");
c1.addActionListener(at); c2=new JCheckBox("Sprite");
c2.addActionListener(at); c3=new JCheckBox("Fruiti");
c3.addActionListener(at); c4=new JCheckBox("Seven Up");
c4.addActionListener(at); c5=new JCheckBox("Cold Coffee");
c5.addActionListener(at); c6=new JCheckBox("Ice Tea");
c6.addActionListener(at); c7=new JCheckBox("Chocolate Crushees");
c7.addActionListener(at); labelSum = new JLabel("Sum: "); textFieldSum =
new JTextField(5); b1=new JButton("Add to Cart");
b1.addActionListener(at); p.add(c1); c1.setRolloverIcon(rollIcon);
p.add(c2); p.add(c3); p.add(c4); p.add(c5); p.add(c6); p.add(c7);
p.add(labelSum); textFieldSum.setEditable(false); p.add(textFieldSum);
p.add(b1); c.add(p); setVisible(true); setSize(300,400);
setLocationRelativeTo(null);} class ActionHandler implements
ActionListener { public void actionPerformed(ActionEvent ae) {try
{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:paybill");
pst=con.createStatement(); int Num=2500; String BillNo="B"+Num;
System.out.println(BillNo); Num++; pst.execute("insert into info
values('"+BillNo+"',' ',' ')"); System.out.println("Connected to
database"); int cc,sp,fr,su,co,it,ch; String order=""; String rate="";
if(ae.getSource()==b1) {if(c1.isSelected()) {pst.execute("UPDATE set
Item_Cc='cc_20' from info where Bill no='"+BillNo+"')");}
if(c2.isSelected()) {order=order+"sp#"; rate=rate+"#30"; sp=1;}
if(c3.isSelected()) {order=order+"fr#"; rate=rate+"#20"; fr=1;}
if(c4.isSelected()) {order=order+"su#"; rate=rate+"#20"; su=1;}
if(c5.isSelected()) {order=order+"co#"; rate=rate+"#25"; co=1;}
if(c6.isSelected()) {order=order+"it#"; rate=rate+"#20"; it=1;}
if(c7.isSelected()) {order=order+"ch#"; rate=rate+"#24"; ch=1;}}
System.out.print("Products selected: " + order + "\n"); String
o[]=order.split("#"); String r[]=rate.split("#"); int l=o.length; int
r1=r.length;} catch(Exception e) {e.printStackTrace();} } } public static
void main(String args[]) { new trial();}}