I.P PROJECT
ON
Pizza Order
CONTENT
Frontend
o
Admin Form (To add and update
pizzas and view orders)
Backend
Admin form
Coding for
button
String id=jTextField1.getText();
String pass=new String(jPasswordField1.getPassword());
if(id.equals("admin") && pass.equals("pass")) ,
dispose();
DefaultListModel dlm=(DefaultListModel) jList1.getModel(); dlm.removeAllElements();
jTextField2.setText(null); jTextField3.setText(null); jTextField4.setText(null); jTextField5.setText(null);
jTextField6.setText(null); jTextField7.setText(null); jTextArea1.setText(null); FormOrders.setVisible(true); try , Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
String qry="select id from orders order by id desc;"; ResultSet rs=stmt.executeQuery(qry); while(rs.next()) , dlm.addElement(rs.getString(1)); - - catch(Exception e) ,
JOptionPane.showMessageDialog(this,e.getMessage()); -
- else
JOptionPane.showMessageDialog(this,"Incorrect login details");
New Pizza form
Coding for
button
String loc=jTextField16.getText(); loc=loc.replace("\\", "\\\\");
if(loc.isEmpty()==false) , DefaultListModel model=(DefaultListModel)jList2.getModel(); model.addElement(loc); jTextField16.setText(null); - else
JOptionPane.showMessageDialog(FormPizza,"Please add location of image first");
Coding for
button
String loc=(String)jList2.getSelectedValue(); if(loc!=null) , jLabel6.setIcon(new ImageIcon(loc)); - FormImage.setVisible(true);
Coding for
button
String name=jTextField8.getText(); String type=""; if(jRadioButton1.isSelected()) type="veg"; else if(jRadioButton2.isSelected()) type="non-veg"; String desc=jTextArea2.getText(); double pprice=-1,mprice=-1,fprice=-1; int flag=0; try, pprice=Double.parseDouble(jTextField9.getText()); mprice=Double.parseDouble(jTextField10.getText()); fprice=Double.parseDouble(jTextField11.getText()); - catch(Exception e), JOptionPane.showMessageDialog(FormPizza,"Invalid Input"); flag=1; - if(flag==0) ,
if((name.isEmpty() || type.isEmpty() || desc.isEmpty() || pprice<0 || mprice<0 || fprice<0)==false)
, try ,
Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
String qry1="insert into pizza
values('"+name+"','"+type+"',"+pprice+","+mprice+","+fprice+",'"+desc+"');"; stmt.executeUpdate(qry1); DefaultListModel model=(DefaultListModel)jList2.getModel(); for(int i=0;i<model.getSize();i++)
,
String qry2="insert into images values('"+name+"','"+model.getElementAt(i)+"');"; stmt.executeUpdate(qry2); - stmt.close(); con.close(); JOptionPane.showMessageDialog(FormPizza,"Pizaa Added"); jButton11.doClick(); - catch(Exception e) , JOptionPane.showMessageDialog(FormPizza,e.getMessage()); - - else JOptionPane.showMessageDialog(FormPizza,"Invalid Input"); -
Coding for
button
jTextField8.setText(null); jTextField9.setText(null); jTextField10.setText(null); jTextField11.setText(null); jTextField16.setText(null); jTextArea2.setText(null); jRadioButton1.setSelected(false); jRadioButton2.setSelected(false);
DefaultListModel dlm=(DefaultListModel)jList2.getModel(); dlm.removeAllElements();
jList2.setModel(dlm);
Coding for
button
FormPizza.setVisible(false); jTextField12.setText(null); jTextField13.setText(null); jTextField14.setText(null); jTextField15.setText(null); jTextArea3.setText(null); jRadioButton4.setSelected(false); jRadioButton3.setSelected(false); DefaultListModel model=(DefaultListModel)jList4.getModel(); model.removeAllElements(); FormModifyPizza.setVisible(true); try , Class.forName("java.sql.DriverManager"); Connection con =(Connection)
Statement stmt=(Statement)con.createStatement();
String qry="select name from pizza;";
ResultSet rs=stmt.executeQuery(qry); while(rs.next()==true) , model.addElement(rs.getString("name")); - jList4.setModel(model); stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(FormPizza,e.getMessage()); -
Modify Pizza form
Coding
List
String name=(String)jList4.getSelectedValue(); try , Class.forName("java.sql.DriverManager"); Connection con =(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
String qry1="select * from pizza where name='"+name+"';"; ResultSet rs=stmt.executeQuery(qry1); if(rs.next()==true) , jTextField14.setText(rs.getString(1)); jTextField12.setText(rs.getString(3)); jTextField13.setText(rs.getString(4)); jTextField15.setText(rs.getString(5)); jTextArea3.setText(rs.getString(6)); String type=rs.getString(2); if(type.equals("veg")) jRadioButton3.setSelected(true); else if(type.equals("non-veg")) jRadioButton4.setSelected(true); stmt.close(); con.close(); - - catch(Exception e) , JOptionPane.showMessageDialog(FormModifyPizza,e.getMessage()); -
Coding
Button
String name=(String)jList4.getSelectedValue(); String newname=jTextField14.getText(); String desc=jTextArea3.getText(); Double pprice=Double.parseDouble(jTextField12.getText()); Double mprice=Double.parseDouble(jTextField13.getText()); Double fprice=Double.parseDouble(jTextField15.getText()); String type=""; if(jRadioButton4.isSelected()) type="veg"; else if(jRadioButton3.isSelected())type="non-veg";
try ,
Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
String qry="update pizza set name='"+newname+"', pprice="+pprice+"," + "mprice="+mprice+",fprice="+fprice+", details='"+desc+"' where name='"+name+"';"; stmt.executeUpdate(qry); JOptionPane.showMessageDialog(FormModifyPizza,"Pizza Updated"); stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(FormModifyPizza,e.getMessage()); -
Coding
Button
String name=(String)jList4.getSelectedValue(); try
,
Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root","");
Statement stmt=(Statement)con.createStatement();
String qry="delete from pizza where name='"+name+"';"; stmt.executeUpdate(qry); JOptionPane.showMessageDialog(FormModifyPizza,"Pizza Deleted"); jTextField12.setText(null); jTextField13.setText(null); jTextField14.setText(null); jTextField15.setText(null); jTextArea3.setText(null); jRadioButton4.setSelected(false); jRadioButton3.setSelected(false); DefaultListModel model=(DefaultListModel)jList4.getModel(); model.removeElement(name);
stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(FormModifyPizza,e.getMessage()); -
Orders form
Coding
List
String id=(String)jList1.getSelectedValue(); String qry="select * from orders where id="+id;
try ,
Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
ResultSet rs=stmt.executeQuery(qry); if(rs.next()==true) , jTextField2.setText(rs.getString(2)); jTextField3.setText(rs.getString(8)); jTextField4.setText(rs.getString(3)); jTextField5.setText(rs.getString(4)); jTextField6.setText(rs.getString(6)); jTextField7.setText(rs.getString(7)); jTextArea1.setText("Order Details:"+rs.getString(9)+"\n\nAddress:\n"+rs.getString(5)); - rs.close(); stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(FormOrders,e.getMessage()); -
Coding
Button
jButton1.doClick();
Coding
Button
Orders form
Coding
Combo Box
int i=jComboBox1.getSelectedIndex(); String qry="";
if(i==0) ,
-
else if (i==1) ,
qry="select name from pizza where type='veg';"; -
else if(i==2) ,
qry="select name from pizza where type='non-veg';"; - jTextField2.setText(null); jTextField3.setText(null); jTextArea1.setText(null); jTextArea2.setText(null); DefaultListModel dlm=(DefaultListModel)jList1.getModel(); dlm.removeAllElements(); DefaultListModel dlm2=(DefaultListModel)jList2.getModel(); dlm2.removeAllElements(); jComboBox2.removeAllItems(); jComboBox3.setSelectedIndex(0); jComboBox4.setSelectedIndex(0);
jComboBox5.setSelectedIndex(0);
try ,
Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement(); ResultSet rs=stmt.executeQuery(qry); while(rs.next()==true) , dlm.addElement(rs.getString("name")); - jList1.setModel(dlm); stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(this,e.getMessage()); -
Coding
Combo Box
String name=(String)jList1.getSelectedValue(); try , Class.forName("java.sql.DriverManager"); Connection con =(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
String qry1="select * from pizza where name='"+name+"';"; ResultSet rs=stmt.executeQuery(qry1); if(rs.next()==true) , jTextArea2.setText(rs.getString(6)); jComboBox2.removeAllItems(); jComboBox2.addItem("Personal- "+rs.getString(3)); jComboBox2.addItem("Medium- "+rs.getString(4)); jComboBox2.addItem("Family- "+rs.getString(5)); - rs.close();
rs=stmt.executeQuery("select loc from images where name='"+name+"';"); DefaultListModel model=(DefaultListModel)jList2.getModel(); model.removeAllElements(); while(rs.next()) , model.addElement(rs.getString(1)); - jList2.setModel(model); rs.close(); stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(this,e.getMessage()); -
Coding
Button
String loc=(String)jList2.getSelectedValue(); jLabel2.setIcon(null);
jLabel2.setIcon(new ImageIcon(loc)); FormImage.setVisible(true);
Coding
Button
String name=(String)jList1.getSelectedValue();
int qty= Integer.parseInt((String)jComboBox5.getSelectedItem()); String size="";
int ind=jComboBox2.getSelectedIndex();
String choice= (String)jComboBox2.getSelectedItem(); double amt=Double.parseDouble(jTextField1.getText()); double price=0; if(ind==0) , size="Personal"; price=qty*Double.parseDouble(choice.substring(9)); -
else if(ind==1) , size="Medium"; price=qty*Double.parseDouble(choice.substring(7)); - else if (ind==2) , size="Family"; price=qty*Double.parseDouble(choice.substring(7)); - DefaultListModel dlm=(DefaultListModel)jList3.getModel(); dlm.addElement(name+"*"+size+"+ x "+qty+" = "+price); jTextField1.setText(""+(amt+price));
Coding
Button
DefaultListModel model=(DefaultListModel)jList3.getModel(); model.removeAllElements();
Coding
Button
DefaultListModel dlm=(DefaultListModel)jList3.getModel(); if(dlm.getSize()>0) , String amt=jTextField1.getText(); String name=jTextField2.getText(); String mob=jTextField3.getText(); String addr= jTextArea1.getText();String pmode=(String)jComboBox3.getSelectedItem(); String dmode=(String)jComboBox4.getSelectedItem(); String details=""; for(int i=0;i<dlm.getSize();i++) , details+="\n"+dlm.getElementAt(i); -
if((amt.isEmpty() || name.isEmpty()|| mob.isEmpty() || addr.isEmpty() || pmode.isEmpty() || dmode.isEmpty())==false)
,
String qry="insert into orders
values(null,'"+name+"',"+mob+",now(),'"+addr+"','"+pmode+"','"+dmode+"',"+amt+",'"+det ails+"');";
try ,
Class.forName("java.sql.DriverManager"); Connection con =(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/pizza","root",""); Statement stmt=(Statement)con.createStatement();
stmt.executeUpdate(qry);
String qry1="select id from orders order by id desc;"; ResultSet rs=stmt.executeQuery(qry1); String id=""; if(rs.next()) , id=rs.getString(1); -
JOptionPane.showMessageDialog(this,"Order Successful, order id: "+id); jButton4.doClick(); jTextField2.setText(null); jTextField3.setText(null); jTextArea1.setText(null); jTextArea2.setText(null);
jList1.clearSelection(); jComboBox2.removeAllItems(); jComboBox3.setSelectedIndex(0); jComboBox4.setSelectedIndex(0); jComboBox5.setSelectedIndex(0); stmt.close(); con.close(); - catch(Exception e) , JOptionPane.showMessageDialog(this,e.getMessage()); - - else JOptionPane.showMessageDialog(this,"Invalid Input"); - else