Supermarket billing system, Thesis of Computer Applications

Download Supermarket billing system and more Thesis Computer Applications in PDF only on Docsity!

STUDENT NAME :PAUL SHAJAN R

STAFF NAME : Ms AFFRIN

COURSE NAME : JAVA

DATE : 23-06-

ACKNOWLEDGEMENT First of all, I thank God almighty for giving us the wisdom, grace and knowledge to complete this project successfully and also for showering his choicest blessing upon us.

I express my gratitude to Ms AFFRIN who co-ordinate and guided us in

this project and all through this JAVA course. I take this pleasant opportunity to

convey my thanks to her for her kind co-operation, necessary requirements and access to complete my project work.

I also express my gratitude to Ms AFFRIN Technical Leader who co-

ordinate and guided us in this project and all through this JAVA course. I take this

pleasant opportunity to convey my thanks to him for him kind co-operation, necessary requirements and access to complete my project work. I am thankful to all Staffs of Networkz Systems and to my friend who has given their timely support and helps to bring out our project as a successful one. Above all I remain greatly thankful to my beloved Parents who inspired and guided us in the right path and for being the backbone of all the successful endeavours in our life.

PAUL SHAJAN R

(JAVA)

INTRODUCTION

COURSE INTRODUCTION

JAVA , also known as JAVA developer , is the creation of dynamic web applications.....A lot of people learn web coding because they want to create the next Facebook or find a job in the industry. But it's also a good choice if you just want a general introduction to coding, since it's super easy to get started. Covers Java o o p s , e x c e p t i o n h a n d l i n g , f i l e h a n d l i n g , j f r a m e , m y s q l database and accessibility. This is a good starting point for beginners wishing to learn web development fundamentals across a number of areas. This course is designed to start you on a path toward future studies in web development and design, no matter how little experience or technical knowledge you currently have. The web is a very big place, and if you are the typical internet user, you probably visit several websites every day, whether for business, entertainment or education. But have you ever wondered how these websites actually work? How are they built? How do browsers, computers, and mobile devices interact with the web? What skills are necessary to build a website? With almost 1 billion websites now on the internet, the answers to these questions could be your first step toward a better understanding of the internet and developing a new set of internet skills.

INTRODUCTION

PROJECT NAME

SUPERMARKET BILL

⮚ This project “Supermarket Bill” is a system based on web application

which is useful for passengers.

⮚ An supermarket billing is a resource in which tickets can be booked

on the internet.

⮚ The supermarket billing project is an implementation of a general

supermarket billing , which helps the customer to search the availability

and prices of various airline tickets, along with the different packages available with reservations. ⮚ Tis project also covers features like online registration of the users, modifying the details of the website by the management staff, or administrator of the website by adding or removing or modifying flight details or packages information.

login

CODES

try{

if(jTextField1.getText(). equals("")||

jPasswordField1.getText().equals("") ){

JOptionPane.showMessageDialog(this,"please fill the

fields");

String a="Select * from reg where

name='"+jTextField1.getText()+"'&&

password='"+jPasswordField1.getText()+"'";

Class.forName("com.mysql.jdbc.Driver");

Connection

ob=DriverManager.getConnection("jdbc:mysql://localhost:

306/market?

zeroDateTimeBehavior=convertToNull","root","");

Statement st=ob.createStatement();

ResultSet ai=st.executeQuery(a);

if(ai.next()){

JOptionPane.showMessageDialog(this,"login

sucessfully");

pro obj=new pro();

obj.show();

this.hide();

else{

JOptionPane.showMessageDialog(this,"incorrect");

} }catch(Exception e){ JOptionPane.showMessageDialog(this, e); }

try{ String id=jTextField1.getText(); String name=jTextField2.getText(); String q=jTextField3.getText(); String p=jTextField4.getText(); DefaultTableModel ob=(DefaultTableModel)jTable1.getModel(); String ab[]={id,name,q,p}; ob.addRow(ab); String z="insert into bill(id,name,quantity,price) values(id,'"+jTextField2.getText() +"','"+jTextField3.getText() +"','"+jTextField4.getText()+"')"; Class.forName("com.mysql.jdbc.Driver"); Connection object; object = DriverManager.getConnection("jdbc:mysql://localhost: 3306/market? zeroDateTimeBehavior=convertToNull","root",""); Statement st=object.createStatement(); st.executeUpdate(z); JOptionPane.showMessageDialog(this, "success"); }catch(Exception e){ JOptionPane.showMessageDialog(this, e);} bill bill=new bill();

bill.show(); this.hide(); // TODO add your handling code here: } private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) { jTextField1.setText(""); jTextField2.setText(""); jTextField3.setText(""); jTextField4.setText("");

try{ String id=jTextField1.getText(); String name=jTextField2.getText(); String pass=jPasswordField1.getText(); String gender=(String) jComboBox1.getSelectedItem() ; DefaultTableModel ob=(DefaultTableModel)jTable1.getModel(); String ab[]={id,name,pass,gender}; ob.addRow(ab); }catch(Exception e){}// TODO add your handling code here: } private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) { jTextField1.setText(""); jTextField2.setText(""); jPasswordField1.setText("");

try{ Class.forName("com.mysql.jdbc.Driver"); Connection ob=DriverManager.getConnection("jdbc:mysql://localhost: 306/market? zeroDateTimeBehavior=convertToNull","root",""); Statement st=ob.createStatement(); String a="select * from bill " ; ResultSet rs=st.executeQuery(a); while(rs.next()){ String id=String.valueOf(rs.getInt("id")); String name=rs.getString("name"); String quantity=rs.getString("quantity"); String price=String.valueOf(rs.getInt("price")); if(name.equals(jTextField1.getText()) && quantity.equals(jTextField2.getText())){ String ab[]={id,name,quantity,price}; DefaultTableModel dt=(DefaultTableModel)jTable1.getModel(); dt.addRow(ab); }} }catch(Exception e ){ JOptionPane.showMessageDialog(this, e);