Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Code for login page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * Login.java
- *
- * Created on Sep 6, 2010, 11:24:53 PM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.*;
- /**
- *
- * @author Ramesh
- */
- public class Login extends javax.swing.JFrame {
- /** Creates new form Login */
- String s1, s2, s3, s4;
- ResultSet res;
- int a = 0;
- public Login() {
- initComponents();
- setSize(1270, 740);
- setTitle("Login Form");
- setVisible(true);
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel4 = new javax.swing.JLabel();
- jPanel1 = new javax.swing.JPanel();
- jLabel2 = new javax.swing.JLabel();
- jTextField1 = new javax.swing.JTextField();
- jLabel3 = new javax.swing.JLabel();
- jLabel1 = new javax.swing.JLabel();
- jPasswordField1 = new javax.swing.JPasswordField();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- getContentPane().setLayout(null);
- jLabel4.setFont(new java.awt.Font("Monotype Corsiva", 1, 60)); // NOI18N
- jLabel4.setForeground(new java.awt.Color(51, 255, 51));
- jLabel4.setText("Raj Mobile Store");
- getContentPane().add(jLabel4);
- jLabel4.setBounds(310, 60, 420, 70);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel1.setLayout(null);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
- jLabel2.setText("User Name");
- jPanel1.add(jLabel2);
- jLabel2.setBounds(80, 100, 100, 30);
- jTextField1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jPanel1.add(jTextField1);
- jTextField1.setBounds(210, 100, 110, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 18));
- jLabel3.setText("Password");
- jPanel1.add(jLabel3);
- jLabel3.setBounds(80, 150, 110, 30);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
- jLabel1.setText("Login Here");
- jPanel1.add(jLabel1);
- jLabel1.setBounds(150, 30, 130, 40);
- jPasswordField1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jPanel1.add(jPasswordField1);
- jPasswordField1.setBounds(210, 150, 110, 30);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jButton1.setText("Login");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jPanel1.add(jButton1);
- jButton1.setBounds(120, 230, 90, 40);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jButton2.setText("Cancel");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- jPanel1.add(jButton2);
- jButton2.setBounds(230, 230, 90, 40);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(300, 170, 430, 300);
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- s1 = jTextField1.getText();
- s2 = jPasswordField1.getText();
- try {
- Connection co;
- Statement st;
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- co = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- st = co.createStatement();
- res = st.executeQuery("select * from login");
- Boolean rec = res.next();
- if (!rec) {
- JOptionPane.showMessageDialog(null, "There is no records in the table");
- } else {
- do {
- s3 = res.getString(1);
- s4 = res.getString(2);
- if (s1.equals(s3) && s2.equals(s4)) {
- dispose();
- new Home();
- a = 1;
- break;
- }
- } while (res.next());
- if (a == 0) {
- JOptionPane.showMessageDialog(null, "Invalid user or password");
- jTextField1.setText("");
- jPasswordField1.setText("");
- }
- }
- st.close();
- co.close();
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "The error is:" + e);
- }
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- System.exit(0);
- }
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new Login().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPasswordField jPasswordField1;
- private javax.swing.JTextField jTextField1;
- // End of variables declaration
- }
- Code for Home Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * Home.java
- *
- * Created on Sep 6, 2010, 11:53:35 PM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.*;
- import java.util.Date;
- /**
- *
- * @author Ramesh
- */
- public class Home extends javax.swing.JFrame {
- /** Creates new form Home */
- int a = 0, flag = 0, b = 0, c = 0, temp, d = 0, f = 0, g = 0;
- int rows = 0;
- Object data[][];
- String col[];
- String cid, cid1, id,text="";
- String mc1, mc;
- JTable table;
- String totaldata = "";
- int bid;
- Date dat1;String dt1,day1,month1,year1,date1;
- public Home() {
- initComponents();
- setSize(1270, 740);
- setTitle("Mobile Store Home Page");
- setVisible(true);
- idincrement();
- installmentcheck();
- }
- public void idincrement()
- {
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=co.createStatement();
- ResultSet res=st.executeQuery("select * from newbill");
- while(res.next())
- {
- bid=res.getInt(1);
- }
- st.close();
- co.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"the error is"+e);
- System.out.println(e.getMessage());
- }
- bid=bid+1;
- dat1=new Date();
- dt1=dat1.toString();
- System.out.println(dt1);
- day1=dt1.substring(8,10);
- month1=dt1.substring(4,7);
- year1=dt1.substring(24,28);
- date1=day1;
- date1+="-";
- date1+=month1;
- date1+="-";
- date1+=year1;
- }
- public void installmentcheck()
- {
- String countcid="";
- String countcname="";
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res1=st.executeQuery("select cid,cname,pdate, floor(months_between(sysdate,pdate)) as diff from newcustomer_details");
- Boolean rec=res1.next();
- if(rec==false)
- {
- System.out.println("there are no records");
- }
- else
- {
- do
- {
- String dcid=res1.getString(1);
- String dcname=res1.getString(2);
- int diff=res1.getInt(4);
- if(diff>=2)
- {
- countcid+=dcid+"\n";
- countcname+=dcname+"\n";
- JOptionPane.showMessageDialog(null,"The following Customer Not Payed Their Installments from last two months\n" +
- countcid+"\t"+countcname);
- }
- }while(res1.next());
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is :"+e);
- }
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jMenuBar1 = new javax.swing.JMenuBar();
- jMenu1 = new javax.swing.JMenu();
- jMenuItem1 = new javax.swing.JMenuItem();
- jMenuItem3 = new javax.swing.JMenuItem();
- jMenuItem2 = new javax.swing.JMenuItem();
- jMenuItem4 = new javax.swing.JMenuItem();
- jMenu2 = new javax.swing.JMenu();
- jMenuItem6 = new javax.swing.JMenuItem();
- jMenuItem7 = new javax.swing.JMenuItem();
- jMenuItem8 = new javax.swing.JMenuItem();
- jMenuItem13 = new javax.swing.JMenuItem();
- jMenu3 = new javax.swing.JMenu();
- jMenuItem9 = new javax.swing.JMenuItem();
- jMenuItem10 = new javax.swing.JMenuItem();
- jMenu5 = new javax.swing.JMenu();
- jMenuItem5 = new javax.swing.JMenuItem();
- jMenuItem14 = new javax.swing.JMenuItem();
- jMenuItem15 = new javax.swing.JMenuItem();
- jMenu4 = new javax.swing.JMenu();
- jMenuItem11 = new javax.swing.JMenuItem();
- jMenuItem12 = new javax.swing.JMenuItem();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- getContentPane().setLayout(null);
- jMenu1.setText("Mobile Phone ");
- jMenuItem1.setText("Add Mobile Phone");
- jMenuItem1.setToolTipText("Click here to add a mobile phone");
- jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem1ActionPerformed(evt);
- }
- });
- jMenu1.add(jMenuItem1);
- jMenuItem3.setText("Search Mobile Phone");
- jMenuItem3.setToolTipText("Click here to Search a Mobile Phone");
- jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem3ActionPerformed(evt);
- }
- });
- jMenu1.add(jMenuItem3);
- jMenuItem2.setText("Update Mobile Phone");
- jMenuItem2.setToolTipText("Click here to Update a Mobile Phone");
- jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem2ActionPerformed(evt);
- }
- });
- jMenu1.add(jMenuItem2);
- jMenuItem4.setText("Delete Mobile Phone");
- jMenuItem4.setToolTipText("Click here to delete a mobile phone");
- jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem4ActionPerformed(evt);
- }
- });
- jMenu1.add(jMenuItem4);
- jMenuBar1.add(jMenu1);
- jMenu2.setText("Customer ");
- jMenuItem6.setText("Search Customer");
- jMenuItem6.setToolTipText("Click here to Search a Customer");
- jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem6ActionPerformed(evt);
- }
- });
- jMenu2.add(jMenuItem6);
- jMenuItem7.setText("Update Customer");
- jMenuItem7.setToolTipText("Click here to Update Customer Details");
- jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem7ActionPerformed(evt);
- }
- });
- jMenu2.add(jMenuItem7);
- jMenuItem8.setText("Delete Customer");
- jMenuItem8.setToolTipText("Click here to Delete a Customer");
- jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem8ActionPerformed(evt);
- }
- });
- jMenu2.add(jMenuItem8);
- jMenuItem13.setText("Credit Payments");
- jMenuItem13.setToolTipText("Click here for Credit Payments");
- jMenuItem13.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem13ActionPerformed(evt);
- }
- });
- jMenu2.add(jMenuItem13);
- jMenuBar1.add(jMenu2);
- jMenu3.setText("Bill Administration ");
- jMenuItem9.setText("Generate Bill");
- jMenuItem9.setToolTipText("Click here to Generate Bill");
- jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem9ActionPerformed(evt);
- }
- });
- jMenu3.add(jMenuItem9);
- jMenuItem10.setText("Search Bill");
- jMenuItem10.setToolTipText("Click here Search a Bill");
- jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem10ActionPerformed(evt);
- }
- });
- jMenu3.add(jMenuItem10);
- jMenuBar1.add(jMenu3);
- jMenu5.setText("Sales Reports ");
- jMenuItem5.setText("Daily Reports");
- jMenuItem5.setToolTipText("Click here for Daily Reports");
- jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem5ActionPerformed(evt);
- }
- });
- jMenu5.add(jMenuItem5);
- jMenuItem14.setText("Monthly Reports");
- jMenuItem14.setToolTipText("Click here for Monthly Reports");
- jMenuItem14.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem14ActionPerformed(evt);
- }
- });
- jMenu5.add(jMenuItem14);
- jMenuItem15.setText("Yearly Reports");
- jMenuItem15.setToolTipText("Click here for Yearly Reports");
- jMenuItem15.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem15ActionPerformed(evt);
- }
- });
- jMenu5.add(jMenuItem15);
- jMenuBar1.add(jMenu5);
- jMenu4.setText("User");
- jMenuItem11.setText("LogOff");
- jMenuItem11.setToolTipText("Click here to LogOff");
- jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem11ActionPerformed(evt);
- }
- });
- jMenu4.add(jMenuItem11);
- jMenuItem12.setText("Exit");
- jMenuItem12.setToolTipText("Click here to Exit from the Application");
- jMenuItem12.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem12ActionPerformed(evt);
- }
- });
- jMenu4.add(jMenuItem12);
- jMenuBar1.add(jMenu4);
- setJMenuBar(jMenuBar1);
- pack();
- }// </editor-fold>
- private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- dispose();
- new Login();
- }
- private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- dispose();
- }
- private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- new Addmobile1();
- }
- private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- new SearchMobile();
- }
- private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- new MobileUpdate();
- }
- private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- String id1 = JOptionPane.showInputDialog(null, "Enter Mobile Phone Id (or) IMEI No");
- while (id1.equals("")) {
- JOptionPane.showMessageDialog(null, "You should have to enter something");
- id1 = JOptionPane.showInputDialog(null, "Enter Mobile Phone Id (or) IMEI No");
- }
- try {
- Connection con;
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("select * from newmobile_details");
- Boolean rec = res.next();
- if (!rec) {
- JOptionPane.showMessageDialog(null, "There are no mobile phones in the database");
- } else {
- do {
- String s1 = res.getString(1);
- String s2 = res.getString(3);
- String s3 = res.getString(6);
- if (id1.equalsIgnoreCase(s1) || id1.equalsIgnoreCase(s3)) {
- int reply = JOptionPane.showConfirmDialog(null, "Are you sure you want to delete the mobile phone " + s2 + " with having mobile id:" + s1 + " and IMEI no:" + s3);
- if (reply == JOptionPane.YES_OPTION) {
- PreparedStatement prp = con.prepareStatement("delete newmobile_details where phone_id=?");
- prp.setString(1, s1);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null, "The mobile successfully deleted");
- a = 1;
- } else if (reply == JOptionPane.NO_OPTION) {
- JOptionPane.showMessageDialog(null, "The mobile phone is not deleted");
- a = 1;
- break;
- } else if (reply == JOptionPane.CANCEL_OPTION) {
- JOptionPane.showMessageDialog(null, "The mobile phone details are not deleted");
- a = 1;
- break;
- } else {
- }
- }
- } while (res.next());
- if (a == 0) {
- JOptionPane.showMessageDialog(null, "The mobile phone does not exists in the database");
- }
- }
- con.commit();
- con.close();
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "the error is" + e);
- }
- }
- private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- new BillGeneration();
- }
- private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- String searchbill = JOptionPane.showInputDialog(null, "Enter the Bill Id to search");
- while (searchbill.equals("")) {
- JOptionPane.showMessageDialog(null, "Please enter Bill Id");
- searchbill = JOptionPane.showInputDialog(null, "Enter the Bill Id to search");
- }
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("select * from newbill");
- Boolean rec = res.next();
- if (!rec) {
- JOptionPane.showMessageDialog(null, "There are no Bills exists");
- } else {
- do {
- String dbid = res.getString(1);
- if (searchbill.equals(dbid)) {
- BillGeneration bg = new BillGeneration();
- bg.jTextField1.setText(dbid);
- bg.jTextField2.setText(res.getDate(2).toString());
- bg.jTextField3.setText(res.getString(3));
- bg.jTextField6.setText(res.getString(4));
- bg.jTextField7.setText(res.getString(5));
- bg.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
- "--------------------------------------------------------------------------");
- bg.jTextArea1.append(res.getString(6));
- bg.jPanel1.setVisible(false);
- bg.jButton2.setVisible(false);
- bg.jTextField7.setEditable(false);
- bg.jTextField3.setEditable(false);
- bg.jLabel2.setBounds(280, 110, 130, 30);
- bg.jTextField1.setBounds(460, 110, 130, 30);
- bg.jLabel3.setBounds(280, 170, 130, 30);
- bg.jTextField2.setBounds(460, 170, 130, 30);
- bg.jLabel4.setBounds(280, 230, 130, 30);
- bg.jTextField3.setBounds(460, 230, 130, 30);
- bg.jLabel8.setBounds(280, 290, 130, 30);
- bg.jScrollPane1.setBounds(460, 290, 410, 160);
- bg.jLabel9.setBounds(280, 480, 130, 30);
- bg.jTextField6.setBounds(460, 480, 130, 30);
- bg.jLabel10.setBounds(280, 540, 130, 30);
- bg.jTextField7.setBounds(460, 540, 130, 30);
- bg.jButton1.setBounds(430, 620, 100, 40);
- bg.jLabel1.setText("Search Results");
- bg.jLabel8.setText("Mobiles Purchased");
- bg.jButton1.setText("CLOSE");
- bg.setTitle("Search Bill");
- bg.flag = 1;
- f = 1;
- }
- } while (res.next());
- if (f == 0) {
- JOptionPane.showMessageDialog(null, "The Bill Id does not exists");
- }
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "The error is :" + e);
- }
- }
- private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- new SearchCustomer();
- }
- private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- cid = JOptionPane.showInputDialog(null, "Enter Customer Id");
- while (cid.equals("")) {
- JOptionPane.showMessageDialog(null, "Please Enter Customer Id");
- cid = JOptionPane.showInputDialog(null, "Enter Customer Id to Search");
- }
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("select * from newcustomer_details");
- Boolean rec = res.next();
- if (!rec) {
- JOptionPane.showMessageDialog(null, "There are no customer EXISTS");
- } else {
- do {
- cid1 = res.getString(1);
- if (cid.equalsIgnoreCase(cid1)) {
- CreditCustomer cc = new CreditCustomer();
- cc.jTextField1.setText(cid1);
- cc.jTextField2.setText(res.getString(2));
- java.sql.Date dt = res.getDate(3);
- String dd = dt.toString();
- String year = dd.substring(0, 4);
- String month = dd.substring(5, 7);
- String day = dd.substring(8, 10);
- if (month.equals("01")) {
- mc1 = "jan";
- } else if (month.equals("02")) {
- mc1 = "feb";
- } else if (month.equals("03")) {
- mc1 = "mar";
- } else if (month.equals("04")) {
- mc1 = "apr";
- } else if (month.equals("05")) {
- mc1 = "may";
- } else if (month.equals("06")) {
- mc1 = "jun";
- } else if (month.equals("07")) {
- mc1 = "jul";
- } else if (month.equals("08")) {
- mc1 = "aug";
- } else if (month.equals("09")) {
- mc1 = "sep";
- } else if (month.equals("10")) {
- mc1 = "oct";
- } else if (month.equals("11")) {
- mc1 = "nov";
- } else if (month.equals("12")) {
- mc1 = "dec";
- }
- String date = day;
- date += "-";
- date += mc1;
- date += "-";
- date += year;
- cc.jTextField3.setText(date);
- cc.jTextField4.setText(Integer.toString(res.getInt(4)));
- cc.jTextField5.setText(Integer.toString(res.getInt(5)));
- cc.jTextField6.setText(Integer.toString(res.getInt(6)));
- java.sql.Date dob = res.getDate(7);
- String ddob = dob.toString();
- String year2 = ddob.substring(0, 4);
- String month2 = ddob.substring(5, 7);
- String day2 = ddob.substring(8, 10);
- if (month2.equals("01")) {
- mc = "jan";
- } else if (month2.equals("02")) {
- mc = "feb";
- } else if (month2.equals("03")) {
- mc = "mar";
- } else if (month2.equals("04")) {
- mc = "apr";
- } else if (month2.equals("05")) {
- mc = "may";
- } else if (month2.equals("06")) {
- mc = "jun";
- } else if (month2.equals("07")) {
- mc = "jul";
- } else if (month2.equals("08")) {
- mc = "aug";
- } else if (month2.equals("09")) {
- mc = "sep";
- } else if (month2.equals("10")) {
- mc = "oct";
- } else if (month2.equals("11")) {
- mc = "nov";
- } else if (month2.equals("12")) {
- mc = "dec";
- }
- cc.jComboBox1.setSelectedItem(day2);
- cc.jComboBox2.setSelectedItem(mc);
- cc.jComboBox3.setSelectedItem(year2);
- cc.jTextField7.setText(Integer.toString(res.getInt(8)));
- String gender = res.getString(9);
- if (gender.equalsIgnoreCase("male")) {
- cc.jRadioButton1.setSelected(true);
- } else if (gender.equalsIgnoreCase("female")) {
- cc.jRadioButton2.setSelected(true);
- }
- cc.jTextField8.setText(res.getString(10));
- cc.jTextField9.setText(res.getString(11));
- cc.jTextField10.setText(res.getString(12));
- cc.jTextField11.setText(res.getString(13));
- cc.jTextField12.setText(res.getString(14));
- cc.jTextArea1.setText(res.getString(15));
- cc.jTextField13.setVisible(false);
- cc.jTextField14.setVisible(false);
- cc.jLabel25.setVisible(false);
- cc.jLabel26.setVisible(false);
- cc.jLabel1.setText("Update Customer Details");
- cc.jButton1.setText("Update Customer Details");
- cc.flag = 3;
- c = 1;
- break;
- }
- } while (res.next());
- if (c == 0) {
- JOptionPane.showMessageDialog(null, "The customer id does not exists");
- }
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "The error is" + e);
- }
- }
- private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- cid = JOptionPane.showInputDialog(null, "Enter Customer Id");
- while (cid.equals("")) {
- JOptionPane.showMessageDialog(null, "Please Enter Customer Id");
- cid = JOptionPane.showInputDialog(null, "Enter Customer Id to Search");
- }
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("select * from newcustomer_details");
- Boolean rec = res.next();
- if (!rec) {
- JOptionPane.showMessageDialog(null, "There are no customer");
- } else {
- do {
- cid1 = res.getString(1);
- if (cid.equalsIgnoreCase(cid1)) {
- int reply = JOptionPane.showConfirmDialog(null, "Are you sure you want delete this customer");
- if (reply == JOptionPane.YES_OPTION) {
- PreparedStatement prp = con.prepareStatement("delete newcustomer_details where cid=" + cid);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null, "The Customer Details Deleted Successfully");
- } else if (reply == JOptionPane.NO_OPTION) {
- JOptionPane.showMessageDialog(null, "The customer details are not deleted");
- } else if (reply == JOptionPane.CANCEL_OPTION) {
- JOptionPane.showMessageDialog(null, "The customer details are not deleted");
- }
- d = 1;
- break;
- }
- } while (res.next());
- if (d == 0) {
- JOptionPane.showMessageDialog(null, "The Customer Id is not exists in the database");
- }
- con.commit();
- con.close();
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "The error is:" + e);
- }
- }
- private void jMenuItem13ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- int creditpayid;
- String creditpayid1 = JOptionPane.showInputDialog(null, "Enter Customer Id");
- while (creditpayid1.equals(""))
- {
- JOptionPane.showMessageDialog(null, "Please enter Customer Id");
- creditpayid1 = JOptionPane.showInputDialog(null, "Enter Customer Id");
- }
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("select * from newcustomer_details");
- Boolean rec = res.next();
- if (rec == false)
- {
- JOptionPane.showMessageDialog(null, "There are no records");
- }
- else
- {
- do
- {
- int dcid = res.getInt(1);
- String dcname = res.getString(2);
- int dpaidamt = res.getInt(4);
- int dbalamt = res.getInt(5);
- int drefid = res.getInt(6);
- String dmob_purchase = res.getString(15);
- creditpayid = Integer.parseInt(creditpayid1);
- if (creditpayid == dcid)
- {
- int creditpay = Integer.parseInt(JOptionPane.showInputDialog(null, "Enter the Amount that Customer want to Pay"));
- while(creditpay<500)
- {
- JOptionPane.showMessageDialog(null,"The Installment Payment should be Greater than or equal to 500");
- creditpay = Integer.parseInt(JOptionPane.showInputDialog(null, "Enter the Amount that Customer want to Pay"));
- }
- int totalbal = dbalamt - creditpay;
- PreparedStatement prp = con.prepareStatement("update newcustomer_details set pdate=?,paidamt=?,balamt=? where cid=?");
- prp.setString(1,date1);
- prp.setInt(2, creditpay);
- prp.setInt(3, totalbal);
- prp.setInt(4, dcid);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null, dcname + " Remaining Balance Amount is: " + totalbal);
- int reply = JOptionPane.showConfirmDialog(null, "Do you want to print the Bill");
- if (reply == JOptionPane.YES_OPTION)
- {
- PrintPreview pp=new PrintPreview();
- pp.jLabel3.setText(Integer.toString(bid));
- pp.jLabel5.setText(date1);
- pp.jLabel7.setText(dcname);
- pp.jLabel10.setText("Amount Paid:");
- pp.jLabel11.setText(Integer.toString(creditpay));
- pp.jLabel12.setText("Remaining Balance:");
- pp.jLabel13.setText(Integer.toString(totalbal));
- pp.jTextArea1.setText(dmob_purchase);
- pp.flag=1;
- }
- else if (reply == JOptionPane.NO_OPTION)
- {
- }
- else if (reply == JOptionPane.CANCEL_OPTION)
- {
- }
- g = 1;
- }
- }
- while (res.next());
- if (g == 0)
- {
- JOptionPane.showMessageDialog(null, "The Customer Id does not exists");
- }
- }
- con.commit();
- con.close();
- }
- catch(NumberFormatException e)
- {
- }
- catch (Exception e)
- {
- JOptionPane.showMessageDialog(null, "The error is : " + e);
- }
- }
- private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- int countsales=0,totalamt=0;
- try
- {
- String date = JOptionPane.showInputDialog(null, "Enter Date on which you want the Reports (EX:01-jan-2000)");
- while(date.equalsIgnoreCase(""))
- {
- JOptionPane.showMessageDialog(null,"Please enter date");
- date = JOptionPane.showInputDialog(null, "Enter Date on which you want the Reports (EX:01-jan-2000)");
- }
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("select * from newbill where bdate='" + date + "'");
- Boolean rec = res.next();
- if (rec == false)
- {
- JOptionPane.showMessageDialog(null, "There are no sales on the given date");
- }
- else
- {
- SalesReports sr=new SalesReports();
- sr.jLabel2.setVisible(false);
- sr.jLabel3.setVisible(false);
- sr.jComboBox1.setVisible(false);
- sr.jComboBox2.setVisible(false);
- sr.jButton3.setVisible(false);
- sr.jScrollPane1.setBounds(60, 70, 910, 510);
- sr.jTextArea1.setText("");
- text="";
- sr.jLabel1.setText("Daily Reports");
- do
- {
- String dbid = res.getString(1);
- java.sql.Date dbdate = res.getDate(2);
- String bdate = dbdate.toString();
- String dcname = res.getString(3);
- int dprice = res.getInt(4);
- int damtpaid = res.getInt(5);
- String mob_purchased = res.getString(7);
- countsales++;
- totalamt+=damtpaid;
- text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
- sr.jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
- "-----------------------------------------------------------------------------------------------------" +
- "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
- "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
- } while(res.next());
- }
- }
- catch(NullPointerException e)
- {
- }
- catch(SQLException e)
- {
- JOptionPane.showMessageDialog(null,"INVALID DATE!, please follow the Example");
- }
- catch (Exception e)
- {
- JOptionPane.showMessageDialog(null, "The error is:" + e);
- }
- }
- private void jMenuItem14ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- SalesReports sr=new SalesReports();
- sr.jLabel1.setText("Monthly Reports");
- sr.flag=0;
- }
- private void jMenuItem15ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- SalesReports sr=new SalesReports();
- sr.jLabel1.setText("Yearly Reports");
- sr.jLabel2.setVisible(false);
- sr.jComboBox1.setVisible(false);
- sr.flag=1;
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new Home().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JMenu jMenu1;
- private javax.swing.JMenu jMenu2;
- private javax.swing.JMenu jMenu3;
- private javax.swing.JMenu jMenu4;
- private javax.swing.JMenu jMenu5;
- private javax.swing.JMenuBar jMenuBar1;
- private javax.swing.JMenuItem jMenuItem1;
- private javax.swing.JMenuItem jMenuItem10;
- private javax.swing.JMenuItem jMenuItem11;
- private javax.swing.JMenuItem jMenuItem12;
- private javax.swing.JMenuItem jMenuItem13;
- private javax.swing.JMenuItem jMenuItem14;
- private javax.swing.JMenuItem jMenuItem15;
- private javax.swing.JMenuItem jMenuItem2;
- private javax.swing.JMenuItem jMenuItem3;
- private javax.swing.JMenuItem jMenuItem4;
- private javax.swing.JMenuItem jMenuItem5;
- private javax.swing.JMenuItem jMenuItem6;
- private javax.swing.JMenuItem jMenuItem7;
- private javax.swing.JMenuItem jMenuItem8;
- private javax.swing.JMenuItem jMenuItem9;
- // End of variables declaration
- }
- Code for Addmobile Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * Addmobile1.java
- *
- * Created on Sep 11, 2010, 10:53:35 PM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.JOptionPane;
- import java.util.Date;
- /**
- *
- * @author Ramesh
- */
- public class Addmobile1 extends javax.swing.JFrame {
- /** Creates new form Addmobile1 */
- String model,name,pcolor,date1,cbox="";
- int price,no,s1,s3,index,inc,inc1;
- String s2,imeino,mid,dpname,dpid,pname;
- int a=0,z=0,b=0,d=0;
- int count=0;int prevalue=0,curvalue;
- public Addmobile1()
- {
- initComponents();
- setVisible(true);
- setSize(1270,740);
- setTitle("Add Mobile Phone Details");
- jTextField5.setEditable(false);
- jTextField6.setEditable(false);
- jComboBox2.setEnabled(false);
- jComboBox3.setEnabled(false);
- jComboBox4.setEnabled(false);
- jComboBox5.setEnabled(false);
- jCheckBox1.setEnabled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox6.setEnabled(false);
- jButton4.setEnabled(false);
- jButton3.setEnabled(false);
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jPanel1 = new javax.swing.JPanel();
- jLabel18 = new javax.swing.JLabel();
- jLabel19 = new javax.swing.JLabel();
- jLabel20 = new javax.swing.JLabel();
- jLabel21 = new javax.swing.JLabel();
- jLabel22 = new javax.swing.JLabel();
- jTextField5 = new javax.swing.JTextField();
- jTextField6 = new javax.swing.JTextField();
- jButton4 = new javax.swing.JButton();
- jLabel12 = new javax.swing.JLabel();
- jLabel11 = new javax.swing.JLabel();
- jComboBox2 = new javax.swing.JComboBox();
- jCheckBox1 = new javax.swing.JCheckBox();
- jCheckBox2 = new javax.swing.JCheckBox();
- jCheckBox3 = new javax.swing.JCheckBox();
- jCheckBox4 = new javax.swing.JCheckBox();
- jCheckBox5 = new javax.swing.JCheckBox();
- jCheckBox6 = new javax.swing.JCheckBox();
- jButton3 = new javax.swing.JButton();
- jComboBox3 = new javax.swing.JComboBox();
- jComboBox4 = new javax.swing.JComboBox();
- jComboBox5 = new javax.swing.JComboBox();
- jLabel5 = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- jLabel13 = new javax.swing.JLabel();
- jPanel2 = new javax.swing.JPanel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jComboBox1 = new javax.swing.JComboBox();
- jLabel4 = new javax.swing.JLabel();
- jTextField2 = new javax.swing.JTextField();
- jTextField3 = new javax.swing.JTextField();
- jLabel6 = new javax.swing.JLabel();
- jTextField4 = new javax.swing.JTextField();
- jLabel8 = new javax.swing.JLabel();
- jLabel9 = new javax.swing.JLabel();
- jLabel10 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
- jLabel1.setText("Add Mobile Phone Details");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(350, 0, 303, 40);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel1.setEnabled(false);
- jPanel1.setLayout(null);
- jLabel18.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel18.setText("Mobile Phone Id");
- jPanel1.add(jLabel18);
- jLabel18.setBounds(50, 20, 130, 30);
- jLabel19.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel19.setText("Mobile Phone Color");
- jPanel1.add(jLabel19);
- jLabel19.setBounds(50, 70, 190, 30);
- jLabel20.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel20.setText("Enter IMEI Number");
- jPanel1.add(jLabel20);
- jLabel20.setBounds(50, 120, 160, 30);
- jLabel21.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel21.setText("Enter Date Of Manufacture");
- jPanel1.add(jLabel21);
- jLabel21.setBounds(50, 170, 190, 30);
- jLabel22.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel22.setText("Additional Accessories");
- jPanel1.add(jLabel22);
- jLabel22.setBounds(50, 230, 170, 30);
- jTextField5.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField5);
- jTextField5.setBounds(250, 20, 140, 30);
- jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField6.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField6FocusLost(evt);
- }
- });
- jPanel1.add(jTextField6);
- jTextField6.setBounds(250, 120, 140, 30);
- jButton4.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton4.setText(" SAVE PHONE DETAILS");
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- jPanel1.add(jButton4);
- jButton4.setBounds(90, 330, 240, 50);
- jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel1.add(jLabel12);
- jLabel12.setBounds(410, 120, 100, 30);
- jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel1.add(jLabel11);
- jLabel11.setBounds(410, 20, 100, 30);
- jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
- jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Red", "Green", "Blue", "Black", "White", "Cyan", "Yellow", "Orange", "Purple", "Pink", "Voilet", "Magenta" }));
- jPanel1.add(jComboBox2);
- jComboBox2.setBounds(250, 70, 140, 30);
- jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox1.setText("Charger ");
- jPanel1.add(jCheckBox1);
- jCheckBox1.setBounds(250, 240, 80, 23);
- jCheckBox2.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox2.setText("HeadSet ");
- jPanel1.add(jCheckBox2);
- jCheckBox2.setBounds(360, 240, 80, 23);
- jCheckBox3.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox3.setText("DataCable ");
- jPanel1.add(jCheckBox3);
- jCheckBox3.setBounds(460, 240, 100, 23);
- jCheckBox4.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox4.setText("Battery ");
- jPanel1.add(jCheckBox4);
- jCheckBox4.setBounds(250, 280, 80, 23);
- jCheckBox5.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox5.setText("MemoryCard ");
- jPanel1.add(jCheckBox5);
- jCheckBox5.setBounds(360, 280, 101, 23);
- jCheckBox6.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox6.setText("CD ");
- jPanel1.add(jCheckBox6);
- jCheckBox6.setBounds(470, 280, 50, 23);
- jButton3.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton3.setText("CANCEL");
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- jPanel1.add(jButton3);
- jButton3.setBounds(370, 330, 110, 50);
- jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
- jPanel1.add(jComboBox3);
- jComboBox3.setBounds(250, 180, 50, 30);
- jComboBox4.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
- jPanel1.add(jComboBox4);
- jComboBox4.setBounds(330, 180, 56, 30);
- jComboBox5.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" }));
- jComboBox5.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jComboBox5FocusLost(evt);
- }
- });
- jPanel1.add(jComboBox5);
- jComboBox5.setBounds(426, 180, 60, 30);
- jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel5.setText("(DD)");
- jPanel1.add(jLabel5);
- jLabel5.setBounds(300, 180, 30, 30);
- jLabel7.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel7.setText("(MM)");
- jPanel1.add(jLabel7);
- jLabel7.setBounds(390, 180, 32, 30);
- jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel13.setText("(YY)");
- jPanel1.add(jLabel13);
- jLabel13.setBounds(490, 180, 30, 30);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(200, 290, 570, 400);
- jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel2.setLayout(null);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel2.setText("Price");
- jPanel2.add(jLabel2);
- jLabel2.setBounds(50, 120, 90, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel3.setText("No. of Mobile Phones");
- jPanel2.add(jLabel3);
- jLabel3.setBounds(50, 170, 150, 30);
- jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
- jPanel2.add(jComboBox1);
- jComboBox1.setBounds(250, 20, 140, 30);
- jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel4.setText("Mobile Phone Model");
- jPanel2.add(jLabel4);
- jLabel4.setBounds(50, 20, 150, 30);
- jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField2.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField2FocusLost(evt);
- }
- });
- jPanel2.add(jTextField2);
- jTextField2.setBounds(250, 70, 140, 30);
- jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField3FocusLost(evt);
- }
- });
- jPanel2.add(jTextField3);
- jTextField3.setBounds(250, 120, 140, 30);
- jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel6.setText("Enter Mobile Name");
- jPanel2.add(jLabel6);
- jLabel6.setBounds(50, 70, 160, 30);
- jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField4FocusLost(evt);
- }
- });
- jPanel2.add(jTextField4);
- jTextField4.setBounds(250, 170, 140, 30);
- jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel2.add(jLabel8);
- jLabel8.setBounds(410, 70, 100, 30);
- jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel2.add(jLabel9);
- jLabel9.setBounds(410, 120, 100, 30);
- jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel2.add(jLabel10);
- jLabel10.setBounds(410, 170, 100, 30);
- getContentPane().add(jPanel2);
- jPanel2.setBounds(200, 60, 570, 220);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jButton1.setText("Enter each Phone Details");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1);
- jButton1.setBounds(780, 130, 210, 60);
- pack();
- }// </editor-fold>
- private void jTextField2FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField2.getText().equals(""))
- {
- jLabel8.setText("Entry Is Must");
- jTextField2.setText("");
- }
- else
- {
- jLabel8.setText("");
- try
- {
- name=jTextField2.getText();
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- }
- else
- {
- do
- {
- String nm=res.getString(3);
- if(name.equals(nm))
- {
- jTextField3.setText(Integer.toString(res.getInt(4)));
- }
- }while(res.next());
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is :"+e);
- }
- }
- }
- private void jTextField3FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField3.getText().equals(""))
- {
- jLabel9.setText("Entry Is Must") ;
- jTextField3.setText("");
- }
- else
- {
- String jtf1=jTextField3.getText();
- int fg=0;
- for(int i=0;i<jtf1.length();i++)
- {
- char c=jtf1.charAt(i);
- if(Character.isLetter(c))
- {
- fg=0;
- break;
- }
- else
- {
- fg=1;
- }
- }
- if(fg==0)
- {
- jLabel9.setText("Enter Numbers") ;
- jTextField3.setText("");
- }
- else
- jLabel9.setText("") ;
- }
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jTextField2.getText().equals("") || jTextField3.getText().equals("") || jTextField4.getText().equals("")) {
- JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
- if(jTextField2.getText().equals("")) {
- jLabel8.setText("Fill this field");
- } else {
- jLabel8.setText("");
- }
- if(jTextField3.getText().equals("")) {
- jLabel9.setText("Fill this field");
- } else {
- jLabel9.setText("");
- }
- if(jTextField4.getText().equals("")) {
- jLabel10.setText("Fill this field");
- } else {
- jLabel10.setText("");
- }
- }
- else
- {
- no=Integer.parseInt(jTextField4.getText());
- if(count<no)
- {
- jComboBox1.setEnabled(false);
- jTextField2.setEditable(false);
- jTextField3.setEditable(false);
- jTextField4.setEditable(false);
- jButton1.setEnabled(false);
- JOptionPane.showMessageDialog(null,"Enter First Mobile Phone Details");
- jTextField6.setEditable(true);
- jComboBox2.setEnabled(true);
- jComboBox3.setEnabled(true);
- jComboBox4.setEnabled(true);
- jComboBox5.setEnabled(true);
- jCheckBox1.setEnabled(true);
- jCheckBox2.setEnabled(true);
- jCheckBox3.setEnabled(true);
- jCheckBox4.setEnabled(true);
- jCheckBox5.setEnabled(true);
- jCheckBox6.setEnabled(true);
- jButton4.setEnabled(true);
- jButton3.setEnabled(true);
- }
- else
- {
- JOptionPane.showMessageDialog(null,"enter No. of Mobiles as 1 or more");
- jTextField4.setText("");
- }
- //extra requirement code
- try
- {
- pname=jTextField2.getText();
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- mid=jTextField2.getText();
- mid+="-";
- mid+="1";
- jTextField5.setText(mid);
- }
- else
- {
- do
- {
- dpid=res.getString(1);
- dpname=res.getString(3);
- if(pname.equalsIgnoreCase(dpname))
- {
- System.out.println(dpid);
- index=dpid.indexOf("-");
- System.out.println(index);
- curvalue=Integer.parseInt(dpid.substring(index+1));
- if(prevalue<curvalue)
- {
- inc=curvalue+1;
- prevalue=curvalue;
- }
- mid=jTextField2.getText();
- mid+="-";
- mid+=Integer.toString(inc);
- jTextField5.setText(mid);
- b=1;
- }
- }while(res.next());
- if(b==0)
- {
- mid=jTextField2.getText();
- mid+="-";
- mid+="1";
- jTextField5.setText(mid);
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- //extra requirement code ends here
- }
- }
- private void jTextField4FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField4.getText().equals(""))
- {
- jLabel10.setText("Entry Is Must") ;
- jTextField4.setText("");
- }
- else
- {
- String jtf1=jTextField4.getText();
- int fg=0;
- for(int i=0;i<jtf1.length();i++)
- {
- char c=jtf1.charAt(i);
- if(Character.isLetter(c))
- {
- fg=0;
- break;
- }
- else
- {
- fg=1;
- }
- }
- if(fg==0)
- {
- jLabel10.setText("Enter Numbers") ;
- jTextField4.setText("");
- }
- else
- jLabel10.setText("") ;
- }
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jTextField5.getText().equals("") || jTextField6.getText().equals(""))
- {
- JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
- if(jTextField5.getText().equals(""))
- {
- jLabel11.setText("Fill this field");
- }
- else
- {
- jLabel11.setText("");
- }
- if(jTextField6.getText().equals(""))
- {
- jLabel12.setText("Fill this field");
- }
- else
- {
- jLabel12.setText("");
- }
- }
- else
- {
- name=jTextField2.getText();
- model=(String)jComboBox1.getSelectedItem();
- price=Integer.parseInt(jTextField3.getText());
- pcolor=(String)jComboBox2.getSelectedItem();
- imeino=jTextField6.getText();
- date1=(String)jComboBox3.getSelectedItem();
- date1+="-";
- date1+=(String)jComboBox4.getSelectedItem();
- date1+="-";
- date1+=(String)jComboBox5.getSelectedItem();
- cbox="";
- Boolean temp=(Boolean)jCheckBox1.isSelected();
- if(temp==true)
- {
- cbox+=(String)jCheckBox1.getText();
- }
- Boolean temp1=(Boolean)jCheckBox2.isSelected();
- if(temp1==true)
- {
- cbox+=(String)jCheckBox2.getText();
- }
- Boolean temp2=(Boolean)jCheckBox3.isSelected();
- if(temp2==true)
- {
- cbox+=(String)jCheckBox3.getText();
- }
- Boolean temp3=(Boolean)jCheckBox4.isSelected();
- if(temp3==true)
- {
- cbox+=(String)jCheckBox4.getText();
- }
- Boolean temp4=(Boolean)jCheckBox5.isSelected();
- if(temp4==true)
- {
- cbox+=(String)jCheckBox5.getText();
- }
- Boolean temp5=(Boolean)jCheckBox6.isSelected();
- if(temp5==true)
- {
- cbox+=(String)jCheckBox6.getText();
- }
- System.out.println(cbox);
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- System.out.println("connected successfully");
- if(count<no)
- {
- PreparedStatement prp=con.prepareStatement("insert into newmobile_details values(?,?,?,?,?,?,?,?)");
- prp.setString(1,mid);
- prp.setString(2,model);
- prp.setString(3,name);
- prp.setInt(4,price);
- prp.setString(5,pcolor);
- prp.setString(6,imeino);
- prp.setString(7,date1);
- prp.setString(8,cbox);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null,"Mobiele Phone details saved successfully");
- jTextField6.setText("");
- jComboBox2.setSelectedItem("Red");
- jComboBox3.setSelectedItem("01");
- jComboBox4.setSelectedItem("jan");
- jComboBox5.setSelectedItem("2000");
- jCheckBox1.setSelected(false);
- jCheckBox2.setSelected(false);
- jCheckBox3.setSelected(false);
- jCheckBox4.setSelected(false);
- jCheckBox5.setSelected(false);
- jCheckBox6.setSelected(false);
- cbox="";
- con.commit();
- con.close();
- count++;
- //extra requirement code starts from here
- index=jTextField5.getText().indexOf("-");
- System.out.println(index);
- inc1=Integer.parseInt(jTextField5.getText().substring(index+1));
- inc1++;
- System.out.print(inc1);
- mid=jTextField2.getText();
- mid+="-";
- mid+=Integer.toString(inc1);
- jTextField5.setText(mid);
- //ends here
- if(count<no)
- {
- JOptionPane.showMessageDialog(null,"Enter Next Mobile Phone Details");
- }
- if(count>=no)
- {
- count=0;
- jComboBox1.setEnabled(true);
- jTextField2.setEditable(true);
- jTextField3.setEditable(true);
- jTextField4.setEditable(true);
- jButton1.setEnabled(true);
- jTextField6.setEditable(false);
- jComboBox2.setEnabled(false);
- jCheckBox1.setSelected(false);
- jCheckBox2.setSelected(false);
- jCheckBox3.setSelected(false);
- jCheckBox4.setSelected(false);
- jCheckBox5.setSelected(false);
- jCheckBox6.setSelected(false);
- jComboBox1.setSelectedItem("Nokia");
- jComboBox2.setSelectedItem("Red");
- jComboBox3.setSelectedItem("1");
- jComboBox4.setSelectedItem("jan");
- jComboBox5.setSelectedItem("2000");
- jComboBox2.setEnabled(false);
- jComboBox3.setEnabled(false);
- jComboBox4.setEnabled(false);
- jComboBox5.setEnabled(false);
- jButton4.setEnabled(false);
- jButton3.setEnabled(false);
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- jTextField5.setText("");
- jTextField6.setText("");
- jCheckBox1.setEnabled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox6.setEnabled(false);
- }
- }
- }
- catch(SQLException e)
- {
- JOptionPane.showMessageDialog(null,"INVALID DATE, please select correct date");
- jComboBox3.setSelectedItem("01");
- jComboBox4.setSelectedItem("jan");
- jComboBox5.setSelectedItem("2000");
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is1:"+e);
- System.out.println(e.getMessage());
- }
- }
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- count=0;
- jComboBox1.setSelectedItem("Nokia");
- jComboBox1.setEnabled(true);
- jTextField2.setEditable(true);
- jTextField3.setEditable(true);
- jTextField4.setEditable(true);
- jButton1.setEnabled(true);
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- jTextField5.setText("");
- jTextField6.setText("");
- jComboBox2.setSelectedItem("Red");
- jComboBox3.setSelectedItem("01");
- jComboBox4.setSelectedItem("jan");
- jComboBox5.setSelectedItem("2000");
- jCheckBox1.setSelected(false);
- jCheckBox2.setSelected(false);
- jCheckBox3.setSelected(false);
- jCheckBox4.setSelected(false);
- jCheckBox5.setSelected(false);
- jCheckBox6.setSelected(false);
- jTextField6.setEditable(false);
- jComboBox2.setEnabled(false);
- jComboBox3.setEnabled(false);
- jComboBox4.setEnabled(false);
- jComboBox5.setEnabled(false);
- jCheckBox1.setEnabled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox6.setEnabled(false);
- jButton4.setEnabled(false);
- jButton3.setEnabled(false);
- }
- private void jTextField6FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField6.getText().equals(""))
- {
- jLabel12.setText("Entry Is Must");
- }
- else
- {
- String jtf1=jTextField6.getText();
- int fg=0;
- for(int i=0;i<jtf1.length();i++)
- {
- char c=jtf1.charAt(i);
- if(Character.isLetter(c))
- {
- fg=0;
- break;
- }
- else
- {
- fg=1;
- }
- }
- if(fg==0)
- {
- jLabel12.setText("Enter Numbers") ;
- jTextField6.setText("");
- }
- else
- {
- jLabel12.setText("");
- }
- String imei=jTextField6.getText();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- }
- else
- {
- do
- {
- String dimei=res.getString(6);
- if(imei.equals(dimei))
- {
- JOptionPane.showMessageDialog(null,"The Mobile Phone is already in the database");
- jTextField6.setText("");
- jLabel12.setText("");
- }
- }while(res.next());
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is"+e);
- }
- }
- }
- private void jComboBox5FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- String temp1=(String)jComboBox5.getSelectedItem();
- int useryear=Integer.parseInt(temp1);
- Date curyear=new Date();
- String temp2=curyear.toString();
- temp2=temp2.substring(24,28);
- int cyear=Integer.parseInt(temp2);
- if(useryear>cyear)
- {
- JOptionPane.showMessageDialog(null,"The Manufacture Date should be on (or) before this year");
- jComboBox5.setSelectedItem("2000");
- }
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new Addmobile1().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton3;
- private javax.swing.JButton jButton4;
- private javax.swing.JCheckBox jCheckBox1;
- private javax.swing.JCheckBox jCheckBox2;
- private javax.swing.JCheckBox jCheckBox3;
- private javax.swing.JCheckBox jCheckBox4;
- private javax.swing.JCheckBox jCheckBox5;
- private javax.swing.JCheckBox jCheckBox6;
- private javax.swing.JComboBox jComboBox1;
- private javax.swing.JComboBox jComboBox2;
- private javax.swing.JComboBox jComboBox3;
- private javax.swing.JComboBox jComboBox4;
- private javax.swing.JComboBox jComboBox5;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel10;
- private javax.swing.JLabel jLabel11;
- private javax.swing.JLabel jLabel12;
- private javax.swing.JLabel jLabel13;
- private javax.swing.JLabel jLabel18;
- private javax.swing.JLabel jLabel19;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel20;
- private javax.swing.JLabel jLabel21;
- private javax.swing.JLabel jLabel22;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- private javax.swing.JLabel jLabel9;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JTextField jTextField2;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField jTextField4;
- private javax.swing.JTextField jTextField5;
- private javax.swing.JTextField jTextField6;
- // End of variables declaration
- }
- Code for SearchMobile Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * SearchMobile.java
- *
- * Created on Nov 7, 2010, 9:35:13 PM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.*;
- /**
- *
- * @author Ramesh
- */
- public class SearchMobile extends javax.swing.JFrame {
- /** Creates new form SearchMobile */
- int flag=0,rows=0,b=0,sprice,eprice;
- String id,mname;
- Object data[][];
- JTable table;
- JScrollPane jsp;
- ResultSet rs;
- public SearchMobile() {
- initComponents();
- setVisible(true);
- setSize(1270,740);
- setTitle("Search Mobile Phone");
- ButtonGroup bg=new ButtonGroup();
- bg.add(jRadioButton1);
- bg.add(jRadioButton2);
- bg.add(jRadioButton3);
- jTextField2.setEditable(false);
- jTextField3.setEditable(false);
- jTextField4.setEditable(false);
- jsp.setVisible(false);
- }
- public void tabledisp()
- {
- try
- {
- data=new Object[rows][8];
- Object[] colheads={"Mobile Phone Id","Mobile Phone Model","Mobile Phone Name","Mobile Phone Price","phone color","IMEI no","Manufacture Date","Accessories"};
- Class.forName("sun.jdbc.odbc.JdbcOdbc");
- Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- rs=st.executeQuery("select * from msearch");
- for(int i=0;i<rows;i++)
- {
- rs.next();
- for(int j=0;j<8;j++)
- {
- data [i][j]=rs.getString(j+1);
- System.out.println(data[i][j]);
- }
- }
- table=new JTable(data,colheads);
- int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
- int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
- jsp=new JScrollPane(table,v,h);
- jsp.setBounds(70,420,900,200);
- jPanel2.add(jsp);
- add(jsp);
- System.out.println("hai we came here");
- rows=0;
- st.close();
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"here the error is:"+e);
- }
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jPanel2 = new javax.swing.JPanel();
- jPanel1 = new javax.swing.JPanel();
- jTextField1 = new javax.swing.JTextField();
- jRadioButton1 = new javax.swing.JRadioButton();
- jRadioButton2 = new javax.swing.JRadioButton();
- jRadioButton3 = new javax.swing.JRadioButton();
- jTextField2 = new javax.swing.JTextField();
- jTextField3 = new javax.swing.JTextField();
- jTextField4 = new javax.swing.JTextField();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- jLabel1 = new javax.swing.JLabel();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Results", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 1, 12))); // NOI18N
- jPanel2.setLayout(null);
- getContentPane().add(jPanel2);
- jPanel2.setBounds(50, 380, 940, 260);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel1.setLayout(null);
- jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField1FocusGained(evt);
- }
- });
- jPanel1.add(jTextField1);
- jTextField1.setBounds(290, 40, 150, 30);
- jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jRadioButton1.setSelected(true);
- jRadioButton1.setText(" Search By Mobile ID or IMEI No.");
- jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton1ActionPerformed(evt);
- }
- });
- jPanel1.add(jRadioButton1);
- jRadioButton1.setBounds(20, 40, 260, 25);
- jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jRadioButton2.setText(" Search By Mobile Name");
- jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton2ActionPerformed(evt);
- }
- });
- jPanel1.add(jRadioButton2);
- jRadioButton2.setBounds(20, 100, 200, 25);
- jRadioButton3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jRadioButton3.setText("Search By Mobile Price");
- jRadioButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton3ActionPerformed(evt);
- }
- });
- jPanel1.add(jRadioButton3);
- jRadioButton3.setBounds(20, 160, 190, 25);
- jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField2.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField2FocusGained(evt);
- }
- });
- jPanel1.add(jTextField2);
- jTextField2.setBounds(290, 100, 150, 30);
- jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField3FocusGained(evt);
- }
- });
- jPanel1.add(jTextField3);
- jTextField3.setBounds(290, 160, 150, 30);
- jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField4FocusGained(evt);
- }
- });
- jPanel1.add(jTextField4);
- jTextField4.setBounds(480, 160, 130, 30);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel2.setText("to");
- jPanel1.add(jLabel2);
- jLabel2.setBounds(450, 160, 20, 30);
- jPanel1.add(jLabel3);
- jLabel3.setBounds(460, 40, 120, 30);
- jPanel1.add(jLabel4);
- jLabel4.setBounds(460, 100, 120, 30);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(50, 100, 640, 250);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton1.setText("Search");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1);
- jButton1.setBounds(720, 200, 120, 50);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton2.setText("Cancel");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2);
- jButton2.setBounds(870, 200, 110, 50);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
- jLabel1.setText("Search Mobile Phone Details");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(320, 20, 350, 50);
- pack();
- }// </editor-fold>
- private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jTextField2.setEditable(true);
- jTextField1.setEditable(false);
- jTextField3.setEditable(false);
- jTextField4.setEditable(false);
- jTextField1.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- flag=1;
- jsp.setVisible(false);
- }
- private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jTextField3.setEditable(true);
- jTextField4.setEditable(true);
- jTextField1.setEditable(false);
- jTextField2.setEditable(false);
- jTextField4.setText("");
- jTextField1.setText("");
- jTextField2.setText("");
- flag=2;
- jsp.setVisible(false);
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(flag==0)
- {
- if(jTextField1.getText().equals(""))
- {
- jLabel3.setText("Entry is Must");
- }
- else
- {
- id=jTextField1.getText();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbc");
- Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- st.executeUpdate("delete msearch");
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no records");
- }
- else
- {
- do
- {
- String mid=res.getString(1);
- String model=res.getString(2);
- String name=res.getString(3);
- int price=res.getInt(4);
- String pcolor=res.getString(5);
- String imei=res.getString(6);
- java.sql.Date date=res.getDate(7);
- String access=res.getString(8);
- if(id.equals(mid) || id.equals(imei))
- {
- System.out.println("iam inside");
- PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
- prp.setString(1,mid);
- prp.setString(2,model);
- prp.setString(3,name);
- prp.setInt(4,price);
- prp.setString(5,pcolor);
- prp.setString(6,imei);
- prp.setDate(7,date);
- prp.setString(8,access);
- prp.executeUpdate();
- System.out.println("iam inside2");
- rows++;
- b=1;
- jTextField1.setText("");
- }
- }while(res.next());
- if(b==0)
- {
- JOptionPane.showMessageDialog(null,"The mobile phone does not exists ");
- jTextField1.setText("");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is1:" +e);
- }
- tabledisp();
- }
- }
- else if(flag==1)
- {
- if(jTextField2.getText().equals(""))
- {
- jLabel4.setText("Entry is Must");
- }
- else
- {
- mname=jTextField2.getText();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbc");
- Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- st.executeUpdate("delete msearch");
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no records");
- }
- else
- {
- do
- {
- String mid=res.getString(1);
- String model=res.getString(2);
- String name=res.getString(3);
- int price=res.getInt(4);
- String pcolor=res.getString(5);
- String imei=res.getString(6);
- java.sql.Date date=res.getDate(7);
- String access=res.getString(8);
- if(mname.equalsIgnoreCase(name))
- {
- PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
- prp.setString(1,mid);
- prp.setString(2,model);
- prp.setString(3,name);
- prp.setInt(4,price);
- prp.setString(5,pcolor);
- prp.setString(6,imei);
- prp.setDate(7,date);
- prp.setString(8,access);
- prp.executeUpdate();
- System.out.println("iam inside2");
- rows++;
- b=1;
- jTextField2.setText("");
- }
- }while(res.next());
- if(b==0)
- {
- JOptionPane.showMessageDialog(null,"The mobile does not exists ");
- jTextField2.setText("");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is1:" +e);
- }
- tabledisp();
- }
- }
- else if(flag==2)
- {
- if(jTextField3.getText().equals("") || jTextField4.getText().equals(""))
- {
- JOptionPane.showMessageDialog(null,"Fill the both fields");
- }
- else if(Integer.parseInt(jTextField3.getText())>Integer.parseInt(jTextField4.getText()))
- {
- JOptionPane.showMessageDialog(null,"First Enter small price and then Enter Big Price");
- jTextField3.setText("");
- jTextField4.setText("");
- }
- else
- {
- sprice=Integer.parseInt(jTextField3.getText());
- eprice=Integer.parseInt(jTextField4.getText());
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbc");
- Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- st.executeUpdate("delete msearch");
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no records");
- }
- else
- {
- do
- {
- String mid=res.getString(1);
- String model=res.getString(2);
- String name=res.getString(3);
- int price=res.getInt(4);
- String pcolor=res.getString(5);
- String imei=res.getString(6);
- java.sql.Date date=res.getDate(7);
- String access=res.getString(8);
- System.out.append("iam stuck here");
- for(int i=sprice;i<=eprice;i++)
- {
- if(i==price)
- {
- PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
- prp.setString(1,mid);
- prp.setString(2,model);
- prp.setString(3,name);
- prp.setInt(4,price);
- prp.setString(5,pcolor);
- prp.setString(6,imei);
- prp.setDate(7,date);
- prp.setString(8,access);
- prp.executeUpdate();
- System.out.println("iam inside2");
- rows++;
- b=1;
- jTextField3.setText("");
- jTextField4.setText("");
- }
- }
- }while(res.next());
- if(b==0)
- {
- JOptionPane.showMessageDialog(null,"There are no mobiles between the price you entered");
- jTextField3.setText("");
- jTextField4.setText("");
- }
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- tabledisp();
- }
- }
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jTextField1.setText("");
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- }
- private void jTextField1FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- jsp.setVisible(false);
- b=0;
- }
- private void jTextField2FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- jsp.setVisible(false);
- b=0;
- }
- private void jTextField3FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- jsp.setVisible(false);
- b=0;
- }
- private void jTextField4FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- jsp.setVisible(false);
- b=0;
- }
- private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- flag=0;
- jTextField1.setEditable(true);
- jTextField2.setEditable(false);
- jTextField3.setEditable(false);
- jTextField4.setEditable(false);
- jTextField2.setText("");
- jTextField2.setText("");
- jTextField2.setText("");
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new SearchMobile().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JRadioButton jRadioButton1;
- private javax.swing.JRadioButton jRadioButton2;
- private javax.swing.JRadioButton jRadioButton3;
- private javax.swing.JTextField jTextField1;
- private javax.swing.JTextField jTextField2;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField jTextField4;
- // End of variables declaration
- }
- Code for UpdateMobile Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * MobileUpdate.java
- *
- * Created on Sep 12, 2010, 11:49:21 PM
- */
- package mobilestorenew;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import javax.swing.JOptionPane;
- /**
- *
- * @author Ramesh
- */
- public class MobileUpdate extends javax.swing.JFrame {
- /** Creates new form MobileUpdate */
- String model,name,cbox;
- int price,i1;
- String id,s1,s2,s3,s4,s5,pcolor,date;
- int a=0;
- int b=0;
- String imeino;
- String dt,year,ddate,mc,month;
- public MobileUpdate() {
- initComponents();
- setVisible(true);
- setSize(1270,740);
- setTitle("Update Mobile Details");
- disflds();
- JOptionPane.showMessageDialog(null,"Enter Phone Id (or) IMEI No. in the First Text Field");
- }
- public void disflds()
- {
- jComboBox1.setEnabled(false);
- jComboBox2.setEnabled(false);
- jComboBox3.setEnabled(false);
- jComboBox4.setEnabled(false);
- jComboBox5.setEnabled(false);
- jTextField2.setEditable(false);
- jTextField3.setEditable(false);
- jTextField4.setEditable(false);
- jCheckBox1.setEnabled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox6.setEnabled(false);
- jButton1.setEnabled(false);
- }
- public void clrcombocheck()
- {
- jComboBox1.setSelectedItem("Nokia");
- jComboBox2.setSelectedItem("Red");
- jComboBox3.setSelectedItem("01");
- jComboBox4.setSelectedItem("jan");
- jComboBox5.setSelectedItem("2000");
- jCheckBox1.setSelected(false);
- jCheckBox2.setSelected(false);
- jCheckBox3.setSelected(false);
- jCheckBox4.setSelected(false);
- jCheckBox5.setSelected(false);
- jCheckBox6.setSelected(false);
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jPanel1 = new javax.swing.JPanel();
- jLabel2 = new javax.swing.JLabel();
- jTextField1 = new javax.swing.JTextField();
- jLabel4 = new javax.swing.JLabel();
- jLabel5 = new javax.swing.JLabel();
- jTextField2 = new javax.swing.JTextField();
- jLabel6 = new javax.swing.JLabel();
- jTextField3 = new javax.swing.JTextField();
- jLabel3 = new javax.swing.JLabel();
- jTextField4 = new javax.swing.JTextField();
- jLabel7 = new javax.swing.JLabel();
- jComboBox2 = new javax.swing.JComboBox();
- jLabel8 = new javax.swing.JLabel();
- jLabel9 = new javax.swing.JLabel();
- jCheckBox1 = new javax.swing.JCheckBox();
- jCheckBox2 = new javax.swing.JCheckBox();
- jCheckBox3 = new javax.swing.JCheckBox();
- jCheckBox4 = new javax.swing.JCheckBox();
- jCheckBox5 = new javax.swing.JCheckBox();
- jCheckBox6 = new javax.swing.JCheckBox();
- jLabel10 = new javax.swing.JLabel();
- jComboBox1 = new javax.swing.JComboBox();
- jComboBox3 = new javax.swing.JComboBox();
- jComboBox4 = new javax.swing.JComboBox();
- jComboBox5 = new javax.swing.JComboBox();
- jLabel11 = new javax.swing.JLabel();
- jLabel12 = new javax.swing.JLabel();
- jLabel13 = new javax.swing.JLabel();
- jPanel2 = new javax.swing.JPanel();
- jButton2 = new javax.swing.JButton();
- jButton1 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
- getContentPane().setLayout(null);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
- jLabel1.setText("Update Mobile Phone Details");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(370, 20, 343, 50);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Update Mobile Details"));
- jPanel1.setLayout(null);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel2.setText("Mobile Phone Price");
- jPanel1.add(jLabel2);
- jLabel2.setBounds(100, 210, 160, 30);
- jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField1FocusLost(evt);
- }
- });
- jPanel1.add(jTextField1);
- jTextField1.setBounds(290, 40, 140, 30);
- jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel4.setText("Mobile Phone Model");
- jPanel1.add(jLabel4);
- jLabel4.setBounds(100, 100, 150, 30);
- jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel5.setText("Enter Phone Id (or) IMEI No.");
- jPanel1.add(jLabel5);
- jLabel5.setBounds(60, 40, 210, 30);
- jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField2.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyTyped(java.awt.event.KeyEvent evt) {
- jTextField2KeyTyped(evt);
- }
- });
- jPanel1.add(jTextField2);
- jTextField2.setBounds(290, 160, 140, 30);
- jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel6.setText("Mobile Phone Name");
- jPanel1.add(jLabel6);
- jLabel6.setBounds(100, 150, 160, 30);
- jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField3.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyTyped(java.awt.event.KeyEvent evt) {
- jTextField3KeyTyped(evt);
- }
- });
- jPanel1.add(jTextField3);
- jTextField3.setBounds(290, 220, 140, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel3.setText("Mobile Phone Color");
- jPanel1.add(jLabel3);
- jLabel3.setBounds(100, 280, 140, 30);
- jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField4.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyTyped(java.awt.event.KeyEvent evt) {
- jTextField4KeyTyped(evt);
- }
- });
- jPanel1.add(jTextField4);
- jTextField4.setBounds(290, 340, 140, 30);
- jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel7.setText("IMEI No");
- jPanel1.add(jLabel7);
- jLabel7.setBounds(100, 340, 100, 30);
- jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
- jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Red", "Green", "Blue", "Black", "White", "Cyan", "Yellow", "Orange", "Purple", "Pink", "Voilet", "Magenta" }));
- jComboBox2.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jComboBox2ItemStateChanged(evt);
- }
- });
- jPanel1.add(jComboBox2);
- jComboBox2.setBounds(290, 280, 140, 30);
- jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel8.setText("Date of Manufacture");
- jPanel1.add(jLabel8);
- jLabel8.setBounds(100, 390, 150, 30);
- jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel9.setText("Additional Accessories");
- jPanel1.add(jLabel9);
- jLabel9.setBounds(100, 440, 170, 20);
- jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox1.setText("Charger ");
- jCheckBox1.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jCheckBox1ItemStateChanged(evt);
- }
- });
- jPanel1.add(jCheckBox1);
- jCheckBox1.setBounds(290, 440, 80, 23);
- jCheckBox2.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox2.setText("HeadSet ");
- jCheckBox2.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jCheckBox2ItemStateChanged(evt);
- }
- });
- jPanel1.add(jCheckBox2);
- jCheckBox2.setBounds(400, 440, 80, 23);
- jCheckBox3.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox3.setText("DataCable ");
- jCheckBox3.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jCheckBox3ItemStateChanged(evt);
- }
- });
- jPanel1.add(jCheckBox3);
- jCheckBox3.setBounds(290, 470, 100, 23);
- jCheckBox4.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox4.setText("Battery ");
- jCheckBox4.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jCheckBox4ItemStateChanged(evt);
- }
- });
- jPanel1.add(jCheckBox4);
- jCheckBox4.setBounds(400, 470, 80, 23);
- jCheckBox5.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox5.setText("MemoryCard ");
- jCheckBox5.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jCheckBox5ItemStateChanged(evt);
- }
- });
- jPanel1.add(jCheckBox5);
- jCheckBox5.setBounds(290, 500, 101, 23);
- jCheckBox6.setFont(new java.awt.Font("Tahoma", 1, 11));
- jCheckBox6.setText("CD ");
- jCheckBox6.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jCheckBox6ItemStateChanged(evt);
- }
- });
- jPanel1.add(jCheckBox6);
- jCheckBox6.setBounds(400, 500, 50, 23);
- jPanel1.add(jLabel10);
- jLabel10.setBounds(440, 40, 120, 30);
- jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
- jComboBox1.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jComboBox1ItemStateChanged(evt);
- }
- });
- jPanel1.add(jComboBox1);
- jComboBox1.setBounds(290, 100, 140, 30);
- jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
- jComboBox3.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jComboBox3ItemStateChanged(evt);
- }
- });
- jPanel1.add(jComboBox3);
- jComboBox3.setBounds(290, 390, 50, 30);
- jComboBox4.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
- jComboBox4.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jComboBox4ItemStateChanged(evt);
- }
- });
- jPanel1.add(jComboBox4);
- jComboBox4.setBounds(380, 390, 56, 30);
- jComboBox5.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" }));
- jComboBox5.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jComboBox5ItemStateChanged(evt);
- }
- });
- jPanel1.add(jComboBox5);
- jComboBox5.setBounds(490, 390, 60, 30);
- jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel11.setText("(DD)");
- jPanel1.add(jLabel11);
- jLabel11.setBounds(340, 390, 28, 30);
- jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel12.setText("(MM)");
- jPanel1.add(jLabel12);
- jLabel12.setBounds(440, 390, 40, 30);
- jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel13.setText("(YY)");
- jPanel1.add(jLabel13);
- jLabel13.setBounds(550, 390, 24, 30);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(210, 70, 590, 530);
- jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel2.setLayout(null);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton2.setText("Cancel");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- jPanel2.add(jButton2);
- jButton2.setBounds(280, 20, 110, 40);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton1.setText("Update Mobile Details");
- jButton1.setEnabled(false);
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jPanel2.add(jButton1);
- jButton1.setBounds(30, 20, 240, 40);
- getContentPane().add(jPanel2);
- jPanel2.setBounds(320, 610, 410, 80);
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- id=jTextField1.getText();
- model=(String)jComboBox1.getSelectedItem();
- name=jTextField2.getText();
- price=Integer.parseInt(jTextField3.getText());
- pcolor=(String)jComboBox2.getSelectedItem();
- imeino=jTextField4.getText();
- date=(String)jComboBox3.getSelectedItem();
- date+="-";
- date+=(String)jComboBox4.getSelectedItem();
- date+="-";
- date+=(String)jComboBox5.getSelectedItem();
- cbox=null;
- Boolean temp=(Boolean)jCheckBox1.isSelected();
- if(temp==true)
- {
- cbox+=(String)jCheckBox1.getText();
- }
- Boolean temp1=(Boolean)jCheckBox2.isSelected();
- if(temp1==true)
- {
- cbox+=(String)jCheckBox2.getText();
- }
- Boolean temp2=(Boolean)jCheckBox3.isSelected();
- if(temp2==true)
- {
- cbox+=(String)jCheckBox3.getText();
- }
- Boolean temp3=(Boolean)jCheckBox4.isSelected();
- if(temp3==true)
- {
- cbox+=(String)jCheckBox4.getText();
- }
- Boolean temp4=(Boolean)jCheckBox5.isSelected();
- if(temp4==true)
- {
- cbox+=(String)jCheckBox5.getText();
- }
- Boolean temp5=(Boolean)jCheckBox6.isSelected();
- if(temp5==true)
- {
- cbox+=(String)jCheckBox6.getText();
- }
- cbox=cbox.substring(4);
- try
- {
- Connection con;
- Statement st;
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- st=con.createStatement();
- PreparedStatement prp=con.prepareStatement("update newmobile_details set mobile_model=?,mobile_name=?,mobile_price=?,pcolor=?,imeino=?,mdate=?,accessories=? where phone_id=?");
- prp.setString(1,model);
- prp.setString(2,name);
- prp.setInt(3,price);
- prp.setString(4,pcolor);
- prp.setString(5,imeino);
- prp.setString(6,date);
- prp.setString(7,cbox);
- prp.setString(8,id);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null,"Mobile Phone details updated successfully");
- jTextField1.setText("");
- jTextField2.setText("");
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- cbox=null;
- jTextField1.setEditable(true);
- disflds();
- clrcombocheck();
- jButton1.setEnabled(false);
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- System.out.println(e.getMessage());
- JOptionPane.showMessageDialog(null,"error is:"+e);
- }
- }
- private void jTextField1FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField1.getText().equals(""))
- {
- jLabel10.setText("Entry is Must");
- }
- else
- {
- id=jTextField1.getText();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no mobiles in the database");
- jTextField1.setText("");
- }
- else
- {
- do
- {
- s1=res.getString(1);
- s2=res.getString(2);
- s3=res.getString(3);
- i1=res.getInt(4);
- s4=res.getString(5);
- s5=res.getString(6);
- if(id.equalsIgnoreCase(s1) || id.equalsIgnoreCase(s5))
- {
- jTextField1.setEditable(false);
- jTextField2.setEditable(true);
- jTextField2.setEditable(true);
- jTextField3.setEditable(true);
- jTextField4.setEditable(true);
- jComboBox1.setEnabled(true);
- jComboBox2.setEnabled(true);
- jComboBox3.setEnabled(true);
- jComboBox4.setEnabled(true);
- jComboBox5.setEnabled(true);
- jCheckBox1.setEnabled(true);
- jCheckBox2.setEnabled(true);
- jCheckBox3.setEnabled(true);
- jCheckBox4.setEnabled(true);
- jCheckBox5.setEnabled(true);
- jCheckBox6.setEnabled(true);
- jComboBox2.setEnabled(true);
- jLabel5.setText(" Mobile Phone Id");
- jLabel10.setText("");
- b=1;
- jTextField1.setText(s1);
- jComboBox1.setSelectedItem(s2);
- jTextField2.setText(s3);
- jTextField3.setText(Integer.toString(i1));
- jComboBox2.setSelectedItem(s4);
- jTextField4.setText(s5);
- dt=res.getDate(7).toString();
- System.out.println(dt);
- year=dt.substring(0,4);
- System.out.println(year);
- month=dt.substring(5,7);
- System.out.println(month);
- ddate=dt.substring(8,10);
- System.out.println(ddate);
- if(month.equals("01"))
- {
- mc="jan";
- }
- else if(month.equals("02"))
- {
- mc="feb";
- }
- else if(month.equals("03"))
- {
- mc="mar";
- }
- else if(month.equals("04"))
- {
- mc="apr";
- }
- else if(month.equals("05"))
- {
- mc="may";
- }
- else if(month.equals("06"))
- {
- mc="jun";
- }
- else if(month.equals("07"))
- {
- mc="jul";
- }
- else if(month.equals("08"))
- {
- mc="aug";
- }
- else if(month.equals("09"))
- {
- mc="sep";
- }
- else if(month.equals("10"))
- {
- mc="oct";
- }
- else if(month.equals("11"))
- {
- mc="nov";
- }
- else if(month.equals("12"))
- {
- mc="dec";
- }
- jComboBox3.setSelectedItem(ddate);
- jComboBox4.setSelectedItem(mc);
- jComboBox5.setSelectedItem(year);
- cbox=res.getString(8);
- Boolean cb1=cbox.contains("Charger");
- if(cb1==true)
- {
- jCheckBox1.setSelected(true);
- }
- else
- {
- }
- Boolean cb2=cbox.contains("HeadSet");
- if(cb2==true)
- {
- jCheckBox2.setSelected(true);
- }
- else
- {
- }
- Boolean cb3=cbox.contains("DataCable");
- if(cb3==true)
- {
- jCheckBox3.setSelected(true);
- }
- else
- {
- }
- Boolean cb4=cbox.contains("Battery");
- if(cb4==true)
- {
- jCheckBox4.setSelected(true);
- }
- else
- {
- }
- Boolean cb5=cbox.contains("MemoryCard");
- if(cb5==true)
- {
- jCheckBox5.setSelected(true);
- }
- else
- {
- }
- Boolean cb6=cbox.contains("CD");
- if(cb6==true)
- {
- jCheckBox6.setSelected(true);
- }
- else
- {
- }
- jButton1.setEnabled(false);
- }
- }while(res.next());
- if(b!=1)
- {
- JOptionPane.showMessageDialog(null,"The mobile details does not exists in the database");
- jTextField1.setText("");
- jLabel10.setText("");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"There are no additional accessories for this mobile");
- jButton1.setEnabled(false);
- }
- }
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jTextField1.setText("");
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- jTextField1.setEditable(true);
- disflds();
- clrcombocheck();
- b=0;
- }
- private void jTextField4KeyTyped(java.awt.event.KeyEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jTextField3KeyTyped(java.awt.event.KeyEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jComboBox2ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jComboBox3ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jComboBox4ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jComboBox5ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jCheckBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jCheckBox2ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jCheckBox3ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jCheckBox4ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jCheckBox5ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jCheckBox6ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- private void jTextField2KeyTyped(java.awt.event.KeyEvent evt) {
- // TODO add your handling code here:
- jButton1.setEnabled(true);
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new MobileUpdate().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JCheckBox jCheckBox1;
- private javax.swing.JCheckBox jCheckBox2;
- private javax.swing.JCheckBox jCheckBox3;
- private javax.swing.JCheckBox jCheckBox4;
- private javax.swing.JCheckBox jCheckBox5;
- private javax.swing.JCheckBox jCheckBox6;
- private javax.swing.JComboBox jComboBox1;
- private javax.swing.JComboBox jComboBox2;
- private javax.swing.JComboBox jComboBox3;
- private javax.swing.JComboBox jComboBox4;
- private javax.swing.JComboBox jComboBox5;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel10;
- private javax.swing.JLabel jLabel11;
- private javax.swing.JLabel jLabel12;
- private javax.swing.JLabel jLabel13;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- private javax.swing.JLabel jLabel9;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JTextField jTextField1;
- private javax.swing.JTextField jTextField2;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField jTextField4;
- // End of variables declaration
- }
- Code for BillGeneration Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * BillGeneration.java
- *
- * Created on Nov 1, 2010, 6:56:04 PM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.*;
- import java.util.Date;
- /**
- *
- * @author Ramesh
- */
- public class BillGeneration extends javax.swing.JFrame {
- /** Creates new form BillGeneration */
- Date dat;
- int bid,reply;
- int a=0,b=0,c=0,d=0,x=0;
- String dt,year,month,day,date;
- int price=0,amtpaid,balamt,dpaidamt,dbalamt,drefid,dage;
- String text="",cid="r",dcid,dcname,year1,month1,day1,mc1,dt1,dgender;
- String cname,mob_purchased,ddno,dstreet,dcity,dstate,dphno;
- int flag=0;
- String s1,s2,s3,s4,nameappend="";int addprice;
- public BillGeneration() {
- initComponents();
- setVisible(true);
- setSize(1270,740);
- setTitle("Generate Bill");
- jTextField1.setEditable(false);
- jTextField2.setEditable(false);
- jTextField6.setEditable(false);
- idincrement();
- jTextField6.setText(Integer.toString(price));
- }
- public void idincrement()
- {
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=co.createStatement();
- ResultSet res=st.executeQuery("select * from newbill");
- while(res.next())
- {
- bid=res.getInt(1);
- }
- st.close();
- co.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"the error is"+e);
- System.out.println(e.getMessage());
- }
- bid=bid+1;
- jTextField1.setText(Integer.toString(bid));
- dat=new Date();
- dt=dat.toString();
- System.out.println(dt);
- day=dt.substring(8,10);
- month=dt.substring(4,7);
- year=dt.substring(24,28);
- date=day;
- date+="-";
- date+=month;
- date+="-";
- date+=year;
- jTextField2.setText(date);
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jLabel8 = new javax.swing.JLabel();
- jLabel9 = new javax.swing.JLabel();
- jLabel10 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- jTextField1 = new javax.swing.JTextField();
- jTextField2 = new javax.swing.JTextField();
- jTextField3 = new javax.swing.JTextField();
- jTextField6 = new javax.swing.JTextField();
- jTextField7 = new javax.swing.JTextField();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTextArea1 = new javax.swing.JTextArea();
- jButton2 = new javax.swing.JButton();
- jLabel11 = new javax.swing.JLabel();
- jPanel1 = new javax.swing.JPanel();
- jLabel5 = new javax.swing.JLabel();
- jLabel6 = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- jTextField4 = new javax.swing.JTextField();
- jComboBox1 = new javax.swing.JComboBox();
- jLabel12 = new javax.swing.JLabel();
- jLabel13 = new javax.swing.JLabel();
- jTextField5 = new javax.swing.JTextField();
- jLabel15 = new javax.swing.JLabel();
- jLabel14 = new javax.swing.JLabel();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
- jLabel1.setText("Generate Bill");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(390, 20, 220, 40);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel2.setText("Bill Id");
- getContentPane().add(jLabel2);
- jLabel2.setBounds(280, 80, 120, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel3.setText("Bill Date");
- getContentPane().add(jLabel3);
- jLabel3.setBounds(280, 130, 130, 30);
- jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel4.setText("Customer Name");
- getContentPane().add(jLabel4);
- jLabel4.setBounds(280, 180, 130, 30);
- jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel8.setText("Added Mobiles");
- getContentPane().add(jLabel8);
- jLabel8.setBounds(280, 400, 110, 30);
- jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel9.setText("Price");
- getContentPane().add(jLabel9);
- jLabel9.setBounds(280, 530, 110, 30);
- jLabel10.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel10.setText("Amount Paid");
- getContentPane().add(jLabel10);
- jLabel10.setBounds(280, 580, 110, 30);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton1.setText("Generate Bill");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1);
- jButton1.setBounds(380, 640, 160, 40);
- jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
- getContentPane().add(jTextField1);
- jTextField1.setBounds(460, 80, 130, 30);
- jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
- getContentPane().add(jTextField2);
- jTextField2.setBounds(460, 130, 130, 30);
- jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField3FocusLost(evt);
- }
- });
- getContentPane().add(jTextField3);
- jTextField3.setBounds(460, 180, 130, 30);
- jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
- getContentPane().add(jTextField6);
- jTextField6.setBounds(460, 530, 130, 30);
- jTextField7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField7FocusLost(evt);
- }
- });
- getContentPane().add(jTextField7);
- jTextField7.setBounds(460, 580, 130, 30);
- jTextArea1.setColumns(20);
- jTextArea1.setEditable(false);
- jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11));
- jTextArea1.setRows(5);
- jTextArea1.setTabSize(9);
- jScrollPane1.setViewportView(jTextArea1);
- getContentPane().add(jScrollPane1);
- jScrollPane1.setBounds(460, 400, 410, 110);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jButton2.setText("ADD");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2);
- jButton2.setBounds(740, 280, 100, 40);
- getContentPane().add(jLabel11);
- jLabel11.setBounds(580, 180, 120, 30);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel1.setLayout(null);
- jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel5.setText("Select Phone Model");
- jPanel1.add(jLabel5);
- jLabel5.setBounds(40, 20, 150, 30);
- jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel6.setText("Enter Phone Name");
- jPanel1.add(jLabel6);
- jLabel6.setBounds(40, 70, 180, 30);
- jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel7.setText("Enter IMEI Number");
- jPanel1.add(jLabel7);
- jLabel7.setBounds(40, 120, 180, 30);
- jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField4FocusGained(evt);
- }
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField4FocusLost(evt);
- }
- });
- jPanel1.add(jTextField4);
- jTextField4.setBounds(220, 70, 130, 30);
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
- jComboBox1.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jComboBox1ItemStateChanged(evt);
- }
- });
- jPanel1.add(jComboBox1);
- jComboBox1.setBounds(220, 20, 130, 30);
- jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel1.add(jLabel12);
- jLabel12.setBounds(360, 70, 100, 30);
- jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
- jPanel1.add(jLabel13);
- jLabel13.setBounds(360, 120, 100, 30);
- jTextField5.setFont(new java.awt.Font("Tahoma", 1, 12));
- jTextField5.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField5FocusGained(evt);
- }
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField5FocusLost(evt);
- }
- });
- jPanel1.add(jTextField5);
- jTextField5.setBounds(220, 120, 130, 30);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(240, 220, 480, 170);
- jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12));
- getContentPane().add(jLabel15);
- jLabel15.setBounds(600, 580, 100, 30);
- jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12));
- getContentPane().add(jLabel14);
- jLabel14.setBounds(600, 530, 200, 30);
- pack();
- }// </editor-fold>
- private void jTextField3FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField3.getText().equals(""))
- {
- jLabel11.setText("Entry Is Must") ;
- jTextField3.setText("");
- }
- else
- {
- jLabel11.setText("") ;
- }
- }
- private void jTextField4FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField4.getText().equals(""))
- {
- jLabel12.setText("Entry Is Must");
- }
- else
- {
- jLabel12.setText("");
- String name=jTextField4.getText();
- String model=(String) jComboBox1.getSelectedItem();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
- }
- else
- {
- do
- {
- String s11=res.getString(2);
- String s22=res.getString(3);
- if(model.equalsIgnoreCase(s11) && name.equalsIgnoreCase(s22))
- {
- b=1;
- }
- }while(res.next());
- if(b==0)
- {
- JOptionPane.showMessageDialog(null,"The mobile phone is not available, Please purchase another one");
- jTextField4.setText("");
- jLabel12.setText("Entry Is Must");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is: "+e);
- }
- }
- }
- private void jTextField4FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- b=0;
- }
- private void jTextField5FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField5.getText().equals(""))
- {
- jLabel13.setText("Entry is Must");
- }
- else
- {
- String jtf1=jTextField5.getText();
- int fg=0;
- for(int i=0;i<jtf1.length();i++)
- {
- char c1=jtf1.charAt(i);
- if(Character.isLetter(c1))
- {
- fg=0;
- break;
- }
- else
- {
- fg=1;
- }
- }
- if(fg==0)
- {
- jLabel13.setText("Enter Numbers") ;
- jTextField5.setText("");
- }
- else
- {
- jLabel13.setText("") ;
- }
- try
- {
- String imeino=jTextField5.getText();
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
- }
- else
- {
- do
- {
- String s12=res.getString(6);
- if(imeino.equals(s12))
- {
- c=1;
- }
- }while(res.next());
- if(c==0)
- {
- JOptionPane.showMessageDialog(null,"The mobile phone is not available, Please purchase another one");
- jTextField5.setText("");
- jLabel13.setText("Entry is Must");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- }
- private void jTextField5FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- c=0;
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- x=0;
- if(jTextField4.getText().equals("") || jTextField5.getText().equals(""))
- {
- JOptionPane.showMessageDialog(null,"Enter All appropriate fields");
- if(jTextField4.getText().equals(""))
- {
- jLabel12.setText("Fill this Field");
- }
- else
- {
- jLabel12.setText("");
- }
- if(jTextField5.getText().equals(""))
- {
- jLabel13.setText("Fill this Field");
- }
- else
- {
- jLabel13.setText("");
- }
- }
- else
- {
- try
- {
- String model=(String)jComboBox1.getSelectedItem();
- String name=jTextField4.getText();
- String imeino=jTextField5.getText();
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newmobile_details");
- Boolean rec=res.next();
- if(!rec)
- {
- JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
- jTextField4.setText("");
- jTextField5.setText("");
- }
- else
- {
- do
- {
- s1=res.getString(2);
- s2=res.getString(3);
- addprice=res.getInt(4);
- s3=res.getString(5);
- s4=res.getString(6);
- if(s1.equalsIgnoreCase(model) && s2.equalsIgnoreCase(name) && s4.equalsIgnoreCase(imeino))
- {
- int reply2=JOptionPane.showConfirmDialog(null,"Are Sure You Want to Purchase");
- if(reply2==JOptionPane.YES_OPTION)
- {
- price+=addprice;
- jTextField6.setText(Integer.toString(price));
- text+="\n"+s2+"\t"+addprice+"\t"+s3+"\t"+s4;
- System.out.println(text);
- jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
- "--------------------------------------------------------------------------"+text);
- PreparedStatement prp=con.prepareStatement("delete newmobile_details where imeino="+s4);
- prp.executeUpdate();
- nameappend+=s2+", ";
- System.out.println(nameappend);
- jComboBox1.setSelectedItem("nokia");
- jTextField4.setText("");
- jTextField5.setText("");
- x=1;
- }
- if(reply2==JOptionPane.NO_OPTION)
- {
- jComboBox1.setSelectedItem("nokia");
- jTextField4.setText("");
- jTextField5.setText("");
- }
- if(reply2==JOptionPane.CANCEL_OPTION)
- {
- jComboBox1.setSelectedItem("nokia");
- jTextField4.setText("");
- jTextField5.setText("");
- }
- }
- }while(res.next());
- if(x==0)
- {
- JOptionPane.showMessageDialog(null,"The Model and Name and IMEI No does not match, please enter correctly");
- }
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- }
- private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- jTextField4.setText("");
- jTextField5.setText("");
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(flag==0)
- {
- if(jTextField3.getText().equals("") || jTextField6.getText().equals("0") || jTextField7.getText().equals(""))
- {
- JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
- if(jTextField3.getText().equals(""))
- {
- jLabel11.setText("Fill this Field");
- }
- else
- {
- jLabel11.setText("");
- }
- if(jTextField6.getText().equals("0"))
- {
- jLabel14.setText("Please Add Mobile Phone");
- }
- else
- {
- jLabel14.setText("");
- }
- if(jTextField7.getText().equals(""))
- {
- jLabel15.setText("Fill this field");
- }
- else
- {
- jLabel15.setText("");
- }
- }
- else
- {
- cname=jTextField3.getText();
- mob_purchased=text;
- amtpaid=Integer.parseInt(jTextField7.getText());
- balamt=price-amtpaid;
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- PreparedStatement prp=con.prepareStatement("insert into newbill values(?,?,?,?,?,?,?)");
- prp.setInt(1,bid);
- prp.setString(2,date);
- prp.setString(3,cname);
- prp.setInt(4,price);
- prp.setInt(5,amtpaid);
- prp.setString(6,mob_purchased);
- prp.setString(7,nameappend);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null,"Bill details successfully saved");
- PrintPreview pp=new PrintPreview();
- pp.jLabel3.setText(Integer.toString(bid));
- pp.jLabel5.setText(date);
- pp.jLabel7.setText(cname);
- pp.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
- "--------------------------------------------------------------------------"+text);
- pp.jLabel11.setText(Integer.toString(price));
- pp.jLabel13.setText(Integer.toString(amtpaid));
- pp.text=text;
- pp.flag=0;
- price=0;
- bid++;
- text="-";
- jTextField1.setText(Integer.toString(bid));
- jTextField3.setText("");
- jTextArea1.setText("");
- jTextField6.setText("0");
- jTextField7.setText("");
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- }
- if(flag==1)
- {
- dispose();
- }
- }
- private void jTextField7FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- int amtcheck=Integer.parseInt(jTextField7.getText());
- if(amtcheck>price)
- {
- jTextField7.setText("");
- JOptionPane.showMessageDialog(null,"The Bill Amount is:"+price+", So pay less than or equal to the amount");
- }
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new BillGeneration().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- public javax.swing.JButton jButton1;
- public javax.swing.JButton jButton2;
- private javax.swing.JComboBox jComboBox1;
- public javax.swing.JLabel jLabel1;
- public javax.swing.JLabel jLabel10;
- private javax.swing.JLabel jLabel11;
- private javax.swing.JLabel jLabel12;
- private javax.swing.JLabel jLabel13;
- private javax.swing.JLabel jLabel14;
- private javax.swing.JLabel jLabel15;
- public javax.swing.JLabel jLabel2;
- public javax.swing.JLabel jLabel3;
- public javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- public javax.swing.JLabel jLabel8;
- public javax.swing.JLabel jLabel9;
- public javax.swing.JPanel jPanel1;
- public javax.swing.JScrollPane jScrollPane1;
- public javax.swing.JTextArea jTextArea1;
- public javax.swing.JTextField jTextField1;
- public javax.swing.JTextField jTextField2;
- public javax.swing.JTextField jTextField3;
- private javax.swing.JTextField jTextField4;
- private javax.swing.JTextField jTextField5;
- public javax.swing.JTextField jTextField6;
- public javax.swing.JTextField jTextField7;
- // End of variables declaration
- }
- Code for PrintPreview Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * PrintPreview.java
- *
- * Created on Nov 14, 2010, 10:52:13 PM
- */
- package mobilestorenew;
- import java.awt.Font;
- import java.awt.Graphics;
- import java.awt.Graphics2D;
- import java.awt.print.*;
- import java.sql.*;
- import javax.swing.*;
- /**
- *
- * @author Ramesh
- */
- public class PrintPreview extends javax.swing.JFrame implements Printable{
- /** Creates new form PrintPreview */
- int a=0,d=0,flag=0;
- int price,amtpaid,reply1=1,reply,balamt,dpaidamt,dbalamt,drefid,dage;
- String refid="c",custrefid,cname,date,text,cid="r",dcid;
- String dcname,year1,month1,day1,mc1,dt1,dgender,ddno,dstreet,dcity,dstate,dphno;
- public PrintPreview() {
- initComponents();
- setVisible(true);
- setTitle("Print Preview");
- setSize(700,650);
- setResizable(false);
- setLocation(180,60);
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jPanel1 = new javax.swing.JPanel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jLabel5 = new javax.swing.JLabel();
- jLabel6 = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- jLabel8 = new javax.swing.JLabel();
- jLabel9 = new javax.swing.JLabel();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTextArea1 = new javax.swing.JTextArea();
- jLabel10 = new javax.swing.JLabel();
- jLabel11 = new javax.swing.JLabel();
- jLabel12 = new javax.swing.JLabel();
- jLabel13 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jLabel1.setFont(new java.awt.Font("Monotype Corsiva", 1, 36));
- jLabel1.setText("Raj Mobile Store");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(230, 30, 270, 40);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel1.setLayout(null);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel2.setText("Bill Id :");
- jPanel1.add(jLabel2);
- jLabel2.setBounds(40, 40, 50, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel3.setText("Bill Id");
- jPanel1.add(jLabel3);
- jLabel3.setBounds(100, 40, 90, 30);
- jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel4.setText("Bill Date :");
- jPanel1.add(jLabel4);
- jLabel4.setBounds(410, 40, 70, 30);
- jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel5.setText("Bill Date");
- jPanel1.add(jLabel5);
- jLabel5.setBounds(480, 40, 110, 30);
- jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel6.setText("Customer Name :");
- jPanel1.add(jLabel6);
- jLabel6.setBounds(40, 90, 130, 30);
- jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel7.setText("Customer Name");
- jPanel1.add(jLabel7);
- jLabel7.setBounds(170, 90, 270, 30);
- jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel8.setText("---------------------------------------------------------------------------------------------------------");
- jPanel1.add(jLabel8);
- jLabel8.setBounds(0, 130, 630, 17);
- jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel9.setText("Mobiles Purchased :");
- jPanel1.add(jLabel9);
- jLabel9.setBounds(40, 170, 140, 30);
- jTextArea1.setColumns(20);
- jTextArea1.setEditable(false);
- jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
- jTextArea1.setRows(5);
- jTextArea1.setTabSize(9);
- jScrollPane1.setViewportView(jTextArea1);
- jPanel1.add(jScrollPane1);
- jScrollPane1.setBounds(190, 170, 410, 110);
- jLabel10.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel10.setText("Total Price :");
- jPanel1.add(jLabel10);
- jLabel10.setBounds(40, 310, 100, 30);
- jLabel11.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel11.setText("Total Price");
- jPanel1.add(jLabel11);
- jLabel11.setBounds(190, 310, 100, 30);
- jLabel12.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel12.setText("Amount Paid :");
- jPanel1.add(jLabel12);
- jLabel12.setBounds(40, 350, 150, 30);
- jLabel13.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel13.setText("Amount Paid ");
- jPanel1.add(jLabel13);
- jLabel13.setBounds(190, 350, 100, 30);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jButton1.setText("Print");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jPanel1.add(jButton1);
- jButton1.setBounds(280, 410, 100, 40);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(30, 100, 630, 480);
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(flag==0)
- {
- jButton1.setVisible(false);
- PrinterJob printJob = PrinterJob.getPrinterJob();
- if (printJob.printDialog())
- {
- try
- {
- printJob.print();
- printJob.setCopies(1);
- }
- catch(Exception PrintException)
- {
- PrintException.printStackTrace();
- }
- printJob.cancel();
- }
- printJob.cancel();
- jButton1.setVisible(true);
- cname=jLabel7.getText();
- date=jLabel5.getText();
- amtpaid=Integer.parseInt(jLabel13.getText());
- price=Integer.parseInt(jLabel11.getText());
- balamt=price-amtpaid;
- if(price!=amtpaid)
- {
- dispose();
- while(reply1!=JOptionPane.YES_OPTION)
- {
- reply=JOptionPane.showConfirmDialog(null,"Is this customer is new Customer or Existing Customer\n If new customer press Yes\n If Existing Customer Press No");
- if(reply==JOptionPane.YES_OPTION)
- {
- while(!refid.equals(custrefid))
- {
- try
- {
- refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Reference Id");
- while(refid.equals(""))
- {
- JOptionPane.showMessageDialog(null,"Please Enter Reference Id");
- refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Referece Id");
- }
- }
- catch(NullPointerException e)
- {
- int reply3=JOptionPane.showConfirmDialog(null,"Are you sure, you dont want to save customer details");
- if(reply3==JOptionPane.YES_OPTION)
- {
- JOptionPane.showMessageDialog(null,"The customer details are not saved");
- break;
- }
- if(reply3==JOptionPane.NO_OPTION)
- {
- refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Reference Id");
- while(refid.equals(""))
- {
- JOptionPane.showMessageDialog(null,"Please Enter Reference Id");
- refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Referece Id");
- }
- }
- if(reply3==JOptionPane.CANCEL_OPTION)
- {
- JOptionPane.showMessageDialog(null,"The customer details are not saved");
- break;
- }
- }
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newcustomer_details");
- Boolean rec=res.next();
- if(!rec)
- {
- custrefid="1";
- CreditCustomer cs=new CreditCustomer();
- cs.jTextField2.setText(cname);
- cs.jTextField3.setText(date);
- cs.jTextField4.setText(Integer.toString(amtpaid));
- cs.jTextField5.setText(Integer.toString(balamt));
- cs.jTextField6.setText(refid);
- cs.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
- "--------------------------------------------------------------------------"+text);
- cs.jTextField13.setVisible(false);
- cs.jTextField14.setVisible(false);
- cs.jLabel25.setVisible(false);
- cs.jLabel26.setVisible(false);
- cs.flag=0;
- }
- else
- {
- do
- {
- custrefid=res.getString(1);
- if(refid.equals(custrefid))
- {
- CreditCustomer cs=new CreditCustomer();
- cs.jTextField2.setText(cname);
- cs.jTextField3.setText(date);
- cs.jTextField4.setText(Integer.toString(amtpaid));
- cs.jTextField5.setText(Integer.toString(balamt));
- cs.jTextField6.setText(refid);
- cs.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
- "--------------------------------------------------------------------------"+text);
- cs.jTextField13.setVisible(false);
- cs.jTextField14.setVisible(false);
- cs.jLabel25.setVisible(false);
- cs.jLabel26.setVisible(false);
- cs.flag=0;
- a=1;
- break;
- }
- }while(res.next());
- if(a==0)
- {
- JOptionPane.showMessageDialog(null,"The Reference Id is wrong, please enter correct Reference ID");
- }
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- break;
- }
- else if(reply==JOptionPane.NO_OPTION)
- {
- while(!cid.equals(dcid))
- {
- System.out.println("i came here");
- try
- {
- cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
- while(cid.equals(""))
- {
- JOptionPane.showMessageDialog(null,"Plese Enter Customer Id");
- cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
- }
- }
- catch(NullPointerException e)
- {
- int reply4=JOptionPane.showConfirmDialog(null,"Are you sure, you dont want to save customer details");
- if(reply4==JOptionPane.YES_OPTION)
- {
- JOptionPane.showMessageDialog(null,"The customer details are not saved");
- break;
- }
- if(reply4==JOptionPane.NO_OPTION)
- {
- cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
- while(cid.equals(""))
- {
- JOptionPane.showMessageDialog(null,"Plese Enter Customer Id");
- cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
- }
- }
- if(reply4==JOptionPane.CANCEL_OPTION)
- {
- JOptionPane.showMessageDialog(null,"The customer details are not saved");
- break;
- }
- }
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newcustomer_details");
- Boolean rec=res.next();
- if(!rec)
- {
- }
- else
- {
- do
- {
- dcid=res.getString(1);
- dcname=res.getString(2);
- dpaidamt=res.getInt(4);
- dbalamt=res.getInt(5);
- drefid=res.getInt(6);
- java.sql.Date ddob=res.getDate(7);
- dt1=ddob.toString();
- year1=dt1.substring(0,4);
- month1=dt1.substring(5,7);
- day1=dt1.substring(8,10);
- if(month1.equals("01"))
- {
- mc1="jan";
- }
- else if(month1.equals("02"))
- {
- mc1="feb";
- }
- else if(month1.equals("03"))
- {
- mc1="mar";
- }
- else if(month1.equals("04"))
- {
- mc1="apr";
- }
- else if(month1.equals("05"))
- {
- mc1="may";
- }
- else if(month1.equals("06"))
- {
- mc1="jun";
- }
- else if(month1.equals("07"))
- {
- mc1="jul";
- }
- else if(month1.equals("08"))
- {
- mc1="aug";
- }
- else if(month1.equals("09"))
- {
- mc1="sep";
- }
- else if(month1.equals("10"))
- {
- mc1="oct";
- }
- else if(month1.equals("11"))
- {
- mc1="nov";
- }
- else if(month1.equals("12"))
- {
- mc1="dec";
- }
- dage=res.getInt(8);
- dgender=res.getString(9);
- ddno=res.getString(10);
- dstreet=res.getString(11);
- dcity=res.getString(12);
- dstate=res.getString(13);
- dphno=res.getString(14);
- String dmob_purchase=res.getString(15);
- dmob_purchase+=text;
- if(cid.equals(dcid))
- {
- CreditCustomer cs=new CreditCustomer();
- cs.jComboBox1.setEnabled(false);
- cs.jComboBox2.setEnabled(false);
- cs.jComboBox3.setEnabled(false);
- cs.jTextField7.setEditable(false);
- cs.jRadioButton1.setEnabled(false);
- cs.jRadioButton2.setEnabled(false);
- cs.jTextField8.setEditable(false);
- cs.jTextField9.setEditable(false);
- cs.jTextField10.setEditable(false);
- cs.jTextField11.setEditable(false);
- cs.jTextField12.setEditable(false);
- cs.jButton1.setText("Update Customer Details");
- cs.jTextField1.setText(dcid);
- cs.jTextField2.setText(dcname);
- cs.jTextField3.setText(date);
- cs.jTextField4.setText(Integer.toString(amtpaid));
- cs.jTextField5.setText(Integer.toString(balamt));
- cs.jTextField6.setText(Integer.toString(drefid));
- cs.jTextArea1.setText(dmob_purchase);
- cs.jComboBox1.setSelectedItem(day1);
- cs.jComboBox2.setSelectedItem(mc1);
- cs.jComboBox3.setSelectedItem(year1);
- cs.jTextField7.setText(Integer.toString(dage));
- if(dgender.equalsIgnoreCase("male"))
- cs.jRadioButton1.setSelected(true);
- if(dgender.equalsIgnoreCase("female"))
- cs.jRadioButton2.setSelected(true);
- cs.jTextField8.setText(ddno);
- cs.jTextField9.setText(dstreet);
- cs.jTextField10.setText(dcity);
- cs.jTextField11.setText(dstate);
- cs.jTextField12.setText(dphno);
- cs.jTextField13.setText(Integer.toString(dbalamt));
- int totalamt=dbalamt+balamt;
- cs.jTextField14.setText(Integer.toString(totalamt));
- cs.flag=1;
- d=1;
- break;
- }
- }while(res.next());
- if(d==0)
- {
- JOptionPane.showMessageDialog(null,"Please enter correct Customer Id");
- }
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- break;
- }
- else if(reply==JOptionPane.CANCEL_OPTION)
- {
- reply1=JOptionPane.showConfirmDialog(null,"Are you sure you dont want to save customer details");
- if(reply1==JOptionPane.YES_OPTION)
- {
- JOptionPane.showMessageDialog(null,"The Customer Details are not saved");
- }
- if(reply1==JOptionPane.NO_OPTION)
- {
- }
- if(reply1==JOptionPane.CANCEL_OPTION)
- {
- JOptionPane.showMessageDialog(null,"The customer details are not saved");
- break;
- }
- }
- }
- }
- else
- {
- dispose();
- }
- }
- else if(flag==1)
- {
- jButton1.setVisible(false);
- PrinterJob printJob = PrinterJob.getPrinterJob();
- if (printJob.printDialog())
- {
- try
- {
- printJob.print();
- printJob.setCopies(1);
- }
- catch(Exception PrintException)
- {
- PrintException.printStackTrace();
- }
- printJob.cancel();
- }
- printJob.cancel();
- jButton1.setVisible(true);
- }
- }
- public int print(Graphics g, PageFormat pf, int pi) throws PrinterException
- {
- Graphics2D g2 = (Graphics2D) g;
- g2.translate(pf.getImageableX()+5, pf.getImageableY()+5);
- Font f = new Font("Monospaced",Font.PLAIN,12);
- g2.setFont (f);
- paint (g2);
- return Printable.PAGE_EXISTS;
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new PrintPreview().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- public javax.swing.JButton jButton1;
- private javax.swing.JLabel jLabel1;
- public javax.swing.JLabel jLabel10;
- public javax.swing.JLabel jLabel11;
- public javax.swing.JLabel jLabel12;
- public javax.swing.JLabel jLabel13;
- public javax.swing.JLabel jLabel2;
- public javax.swing.JLabel jLabel3;
- public javax.swing.JLabel jLabel4;
- public javax.swing.JLabel jLabel5;
- public javax.swing.JLabel jLabel6;
- public javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- public javax.swing.JLabel jLabel9;
- private javax.swing.JPanel jPanel1;
- public javax.swing.JScrollPane jScrollPane1;
- public javax.swing.JTextArea jTextArea1;
- // End of variables declaration
- }
- Code for AddCustomer Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * CreditCustomer.java
- *
- * Created on Nov 5, 2010, 8:24:54 PM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.*;
- /**
- *
- * @author Ramesh
- */
- public class CreditCustomer extends javax.swing.JFrame {
- /** Creates new form CreditCustomer */
- int cid,paidamt,balamt,refid,age,currentcid;
- String sex="Male";
- String cname,pdate,dob,dno,street,city,state,phno,mob_purchased,year;
- int flag,totalbal,prevalue=0,curvalue;
- java.sql.Date dat;
- public CreditCustomer() {
- initComponents();
- setVisible(true);
- setSize(1270,740);
- setTitle("Credit Customer");
- jTextField1.setEditable(false);
- jTextField2.setEditable(false);
- jTextField3.setEditable(false);
- jTextField4.setEditable(false);
- jTextField5.setEditable(false);
- jTextField6.setEditable(false);
- jTextField13.setEditable(false);
- jTextField14.setEditable(false);
- jTextArea1.setEditable(false);
- idincrement();
- ButtonGroup bg=new ButtonGroup();
- bg.add(jRadioButton1);
- bg.add(jRadioButton2);
- }
- public void idincrement()
- {
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=co.createStatement();
- ResultSet res=st.executeQuery("select sysdate from dual");
- res.next();
- dat=res.getDate(1);
- res=st.executeQuery("select * from newcustomer_details");
- Boolean rec=res.next();
- if(!rec)
- {
- cid=1;
- }
- else
- {
- do
- {
- curvalue=res.getInt(1);
- if(prevalue<curvalue)
- {
- cid=curvalue+1;
- prevalue=curvalue;
- }
- }while(res.next());
- }
- st.close();
- co.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"the error is"+e);
- }
- jTextField1.setText(Integer.toString(cid));
- year=dat.toString();
- year=year.substring(0,4);
- }
- public void saveupdate()
- {
- dob=(String)jComboBox1.getSelectedItem();
- dob+="-";
- dob+=(String)jComboBox2.getSelectedItem();
- dob+="-";
- dob+=(String)jComboBox3.getSelectedItem();
- System.out.println(dob);
- age=Integer.parseInt(jTextField7.getText());
- dno=jTextField8.getText();
- street=jTextField9.getText();
- city=jTextField10.getText();
- state=jTextField11.getText();
- phno=jTextField12.getText();
- mob_purchased=jTextArea1.getText();
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jPanel2 = new javax.swing.JPanel();
- jLabel5 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jRadioButton1 = new javax.swing.JRadioButton();
- jRadioButton2 = new javax.swing.JRadioButton();
- jLabe = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- jLabel11 = new javax.swing.JLabel();
- jLabel12 = new javax.swing.JLabel();
- jTextField7 = new javax.swing.JTextField();
- jTextField9 = new javax.swing.JTextField();
- jLabel14 = new javax.swing.JLabel();
- jTextField10 = new javax.swing.JTextField();
- jTextField8 = new javax.swing.JTextField();
- jLabel6 = new javax.swing.JLabel();
- jLabel16 = new javax.swing.JLabel();
- jComboBox2 = new javax.swing.JComboBox();
- jLabel17 = new javax.swing.JLabel();
- jComboBox3 = new javax.swing.JComboBox();
- jLabel18 = new javax.swing.JLabel();
- jComboBox1 = new javax.swing.JComboBox();
- jTextField11 = new javax.swing.JTextField();
- jTextField12 = new javax.swing.JTextField();
- jLabel19 = new javax.swing.JLabel();
- jLabel20 = new javax.swing.JLabel();
- jLabel21 = new javax.swing.JLabel();
- jLabel23 = new javax.swing.JLabel();
- jLabel24 = new javax.swing.JLabel();
- jLabel22 = new javax.swing.JLabel();
- jPanel1 = new javax.swing.JPanel();
- jTextField1 = new javax.swing.JTextField();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jTextField2 = new javax.swing.JTextField();
- jLabel8 = new javax.swing.JLabel();
- jTextField3 = new javax.swing.JTextField();
- jLabel9 = new javax.swing.JLabel();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTextArea1 = new javax.swing.JTextArea();
- jLabel10 = new javax.swing.JLabel();
- jTextField4 = new javax.swing.JTextField();
- jLabel13 = new javax.swing.JLabel();
- jTextField5 = new javax.swing.JTextField();
- jLabel15 = new javax.swing.JLabel();
- jTextField6 = new javax.swing.JTextField();
- jLabel25 = new javax.swing.JLabel();
- jTextField13 = new javax.swing.JTextField();
- jLabel26 = new javax.swing.JLabel();
- jTextField14 = new javax.swing.JTextField();
- jPanel3 = new javax.swing.JPanel();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
- jLabel1.setText("Add Credit Customer Details");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(340, 0, 350, 40);
- jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Customer Details", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP));
- jPanel2.setLayout(null);
- jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel5.setText("Age");
- jPanel2.add(jLabel5);
- jLabel5.setBounds(480, 30, 80, 30);
- jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel4.setText("Gender");
- jPanel2.add(jLabel4);
- jLabel4.setBounds(40, 90, 110, 30);
- jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 12));
- jRadioButton1.setSelected(true);
- jRadioButton1.setText("Male");
- jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton1ActionPerformed(evt);
- }
- });
- jPanel2.add(jRadioButton1);
- jRadioButton1.setBounds(130, 90, 60, 30);
- jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 12));
- jRadioButton2.setText("Female");
- jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton2ActionPerformed(evt);
- }
- });
- jPanel2.add(jRadioButton2);
- jRadioButton2.setBounds(210, 90, 70, 30);
- jLabe.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabe.setText("City");
- jPanel2.add(jLabe);
- jLabe.setBounds(480, 140, 90, 30);
- jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel7.setText("Door NO");
- jPanel2.add(jLabel7);
- jLabel7.setBounds(480, 90, 110, 30);
- jLabel11.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel11.setText("Street");
- jPanel2.add(jLabel11);
- jLabel11.setBounds(40, 140, 80, 30);
- jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel12.setText("State");
- jPanel2.add(jLabel12);
- jLabel12.setBounds(40, 200, 80, 30);
- jTextField7.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField7FocusGained(evt);
- }
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField7FocusLost(evt);
- }
- });
- jPanel2.add(jTextField7);
- jTextField7.setBounds(580, 30, 160, 30);
- jTextField9.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField9.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField9FocusLost(evt);
- }
- });
- jPanel2.add(jTextField9);
- jTextField9.setBounds(130, 140, 170, 30);
- jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel14.setText("Phone Number");
- jPanel2.add(jLabel14);
- jLabel14.setBounds(480, 200, 100, 30);
- jTextField10.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField10.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField10FocusLost(evt);
- }
- });
- jPanel2.add(jTextField10);
- jTextField10.setBounds(580, 140, 160, 30);
- jTextField8.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField8.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField8FocusLost(evt);
- }
- });
- jPanel2.add(jTextField8);
- jTextField8.setBounds(580, 90, 160, 30);
- jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel6.setText("Date of Birth");
- jPanel2.add(jLabel6);
- jLabel6.setBounds(40, 30, 90, 30);
- jLabel16.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel16.setText("(DD)");
- jPanel2.add(jLabel16);
- jLabel16.setBounds(180, 30, 30, 30);
- jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
- jPanel2.add(jComboBox2);
- jComboBox2.setBounds(210, 30, 56, 30);
- jLabel17.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel17.setText("(MM)");
- jPanel2.add(jLabel17);
- jLabel17.setBounds(270, 30, 40, 30);
- jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "1910", "1911", "1912", "1913", "1914", "1915", "1916", "1917", "1918", "1919", "1920", "1921", "1922", "1923", "1924", "1925", "1926", "1927", "1928", "1929", "1930", "1931", "1932", "1933", "1934", "1935", "1936", "1937", "1938", "1939", "1940", "1941", "1942", "1943", "1944", "1945", "1946", "1947", "1948", "1949", "1950", "1951", "1952", "1953", "1954", "1955", "1956", "1957", "1958", "1959", "1960", "1961", "1962", "1963", "1964", "1965", "1966", "1967", "1968", "1969", "1970", "1971", "1972", "1973", "1974", "1975", "1976", "1977", "1978", "1979", "1980", "1981", "1982", "1983", "1984", "1985", "1986", "1987", "1988", "1989", "1990", "1991", "1992", "1993", "1994", "1995" }));
- jPanel2.add(jComboBox3);
- jComboBox3.setBounds(310, 30, 60, 30);
- jLabel18.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel18.setText("(YY)");
- jPanel2.add(jLabel18);
- jLabel18.setBounds(370, 30, 30, 30);
- jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
- jPanel2.add(jComboBox1);
- jComboBox1.setBounds(130, 30, 50, 30);
- jTextField11.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField11.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField11FocusLost(evt);
- }
- });
- jPanel2.add(jTextField11);
- jTextField11.setBounds(130, 200, 170, 30);
- jTextField12.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField12.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusLost(java.awt.event.FocusEvent evt) {
- jTextField12FocusLost(evt);
- }
- });
- jPanel2.add(jTextField12);
- jTextField12.setBounds(580, 200, 160, 30);
- jPanel2.add(jLabel19);
- jLabel19.setBounds(750, 30, 170, 30);
- jPanel2.add(jLabel20);
- jLabel20.setBounds(750, 90, 170, 30);
- jPanel2.add(jLabel21);
- jLabel21.setBounds(310, 140, 110, 30);
- jPanel2.add(jLabel23);
- jLabel23.setBounds(310, 200, 120, 30);
- jPanel2.add(jLabel24);
- jLabel24.setBounds(750, 200, 170, 30);
- jPanel2.add(jLabel22);
- jLabel22.setBounds(750, 140, 160, 30);
- getContentPane().add(jPanel2);
- jPanel2.setBounds(20, 370, 980, 250);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Customer Details", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP));
- jPanel1.setLayout(null);
- jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField1);
- jTextField1.setBounds(170, 30, 140, 30);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel2.setText("Customer Id");
- jPanel1.add(jLabel2);
- jLabel2.setBounds(30, 30, 100, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel3.setText("Customer Name");
- jPanel1.add(jLabel3);
- jLabel3.setBounds(370, 30, 120, 30);
- jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField2);
- jTextField2.setBounds(490, 30, 170, 30);
- jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel8.setText("Date Purchased");
- jPanel1.add(jLabel8);
- jLabel8.setBounds(30, 80, 100, 30);
- jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField3);
- jTextField3.setBounds(170, 80, 140, 30);
- jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel9.setText("Mobiles Purchased");
- jPanel1.add(jLabel9);
- jLabel9.setBounds(370, 130, 120, 30);
- jTextArea1.setColumns(20);
- jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
- jTextArea1.setRows(5);
- jTextArea1.setTabSize(9);
- jScrollPane1.setViewportView(jTextArea1);
- jPanel1.add(jScrollPane1);
- jScrollPane1.setBounds(490, 130, 410, 170);
- jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel10.setText("Paid Amount");
- jPanel1.add(jLabel10);
- jLabel10.setBounds(370, 80, 100, 30);
- jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField4);
- jTextField4.setBounds(490, 80, 170, 30);
- jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel13.setText("Balance Amount");
- jPanel1.add(jLabel13);
- jLabel13.setBounds(30, 130, 100, 30);
- jTextField5.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField5);
- jTextField5.setBounds(170, 130, 140, 30);
- jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel15.setText("Reference Id");
- jPanel1.add(jLabel15);
- jLabel15.setBounds(30, 180, 100, 30);
- jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField6);
- jTextField6.setBounds(170, 180, 140, 30);
- jLabel25.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel25.setText("Old Balance Amount");
- jPanel1.add(jLabel25);
- jLabel25.setBounds(30, 230, 130, 30);
- jTextField13.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField13);
- jTextField13.setBounds(170, 230, 140, 30);
- jLabel26.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel26.setText("Total Balance Amount");
- jPanel1.add(jLabel26);
- jLabel26.setBounds(30, 280, 140, 30);
- jTextField14.setFont(new java.awt.Font("Tahoma", 1, 14));
- jPanel1.add(jTextField14);
- jTextField14.setBounds(170, 280, 140, 30);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(20, 40, 980, 320);
- jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel3.setLayout(null);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jButton1.setText("Save Customer Details");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jPanel3.add(jButton1);
- jButton1.setBounds(150, 10, 210, 40);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jButton2.setText("Cancel");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- jPanel3.add(jButton2);
- jButton2.setBounds(370, 10, 100, 40);
- getContentPane().add(jPanel3);
- jPanel3.setBounds(180, 630, 610, 60);
- pack();
- }// </editor-fold>
- private void jTextField7FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField7.getText().equals(""))
- {
- jLabel19.setText("Entry Is Must");
- }
- else if(jTextField7.getText().length()>2)
- {
- jLabel19.setText("Enter Valid Age");
- jTextField7.setText("");
- }
- else
- {
- String jtf1=jTextField7.getText();
- int fg=0;
- for(int i=0;i<jtf1.length();i++)
- {
- char c1=jtf1.charAt(i);
- if(Character.isLetter(c1))
- {
- fg=0;
- break;
- }
- else
- {
- fg=1;
- }
- }
- if(fg==0)
- {
- jLabel19.setText("Enter Numbers");
- jTextField7.setText("");
- }
- else
- jLabel19.setText("") ;
- }
- }
- private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- sex="Male";
- System.out.println(sex);
- }
- private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- sex="Female";
- System.out.println(sex);
- }
- private void jTextField8FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField8.getText().equals(""))
- {
- jLabel20.setText("Entry Is Must");
- }
- else
- {
- jLabel20.setText("");
- }
- }
- private void jTextField9FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField9.getText().equals(""))
- {
- jLabel21.setText("Entry Is Must");
- }
- else
- {
- jLabel21.setText("");
- }
- }
- private void jTextField10FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField10.getText().equals(""))
- {
- jLabel22.setText("Entry Is Must");
- }
- else
- {
- jLabel22.setText("");
- }
- }
- private void jTextField11FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField11.getText().equals(""))
- {
- jLabel23.setText("Entry Is Must");
- }
- else
- {
- jLabel23.setText("") ;
- }
- }
- private void jTextField12FocusLost(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- if(jTextField12.getText().equals(""))
- {
- jLabel24.setText("Entry Is Must");
- }
- else
- {
- String jtf1=jTextField12.getText();
- int fg=0;
- for(int i=0;i<jtf1.length();i++)
- {
- char c1=jtf1.charAt(i);
- if(Character.isLetter(c1))
- {
- fg=0;
- break;
- }
- else
- {
- fg=1;
- }
- }
- if(fg==0)
- {
- jLabel24.setText("Enter Valid Phone Number");
- jTextField12.setText("");
- }
- else
- jLabel24.setText("") ;
- }
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jTextField7.getText().equals("") || jTextField8.getText().equals("") || jTextField9.getText().equals("") || jTextField10.getText().equals("") || jTextField11.getText().equals("") || jTextField12.getText().equals(""))
- {
- JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
- if(jTextField7.getText().equals(""))
- {
- jLabel19.setText("Fill this Field");
- }
- else
- jLabel19.setText("");
- if(jTextField8.getText().equals(""))
- {
- jLabel20.setText("Fill this Field");
- }
- else
- jLabel20.setText("");
- if(jTextField9.getText().equals(""))
- {
- jLabel21.setText("Fill this Field");
- }
- else
- jLabel21.setText("");
- if(jTextField10.getText().equals(""))
- {
- jLabel22.setText("Fill this Field");
- }
- else
- jLabel22.setText("");
- if(jTextField11.getText().equals(""))
- {
- jLabel23.setText("Fill this Field");
- }
- else
- jLabel23.setText("");
- if(jTextField12.getText().equals(""))
- {
- jLabel24.setText("Fill this Field");
- }
- else
- jLabel24.setText("");
- }
- else
- {
- if(flag==0)
- {
- cname=jTextField2.getText();
- pdate=jTextField3.getText();
- paidamt=Integer.parseInt(jTextField4.getText());
- balamt=Integer.parseInt(jTextField5.getText());
- refid=Integer.parseInt(jTextField6.getText());
- saveupdate();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- PreparedStatement prp=con.prepareStatement("insert into newcustomer_details values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
- prp.setInt(1,cid);
- prp.setString(2,cname);
- prp.setString(3,pdate);
- prp.setInt(4,paidamt);
- prp.setInt(5,balamt);
- prp.setInt(6,refid);
- prp.setString(7,dob);
- prp.setInt(8,age);
- prp.setString(9,sex);
- prp.setString(10,dno);
- prp.setString(11,street);
- prp.setString(12,city);
- prp.setString(13,state);
- prp.setString(14,phno);
- prp.setString(15,mob_purchased);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null,"Customer Details saved successfully");
- con.commit();
- con.close();
- dispose();
- }
- catch(SQLException e)
- {
- JOptionPane.showMessageDialog(null,"INVALID DATE, please select correct date");
- jComboBox1.setSelectedItem("01");
- jComboBox2.setSelectedItem("jan");
- jComboBox3.setSelectedItem("1910");
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"Error is:"+e);
- }
- }
- else if(flag==1)
- {
- currentcid=Integer.parseInt(jTextField1.getText());
- totalbal=Integer.parseInt(jTextField14.getText());
- mob_purchased=jTextArea1.getText();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- PreparedStatement prp=con.prepareStatement("update newcustomer_details set balamt=?, mob_purchased=? where cid=?");
- prp.setInt(1,totalbal);
- prp.setString(2,mob_purchased);
- prp.setInt(3,currentcid);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null,"The Customer Details updated successfully");
- con.commit();
- con.close();
- dispose();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- else if(flag==2)
- {
- dispose();
- }
- else if(flag==3)
- {
- currentcid=Integer.parseInt(jTextField1.getText());
- saveupdate();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- PreparedStatement prp=con.prepareStatement("update newcustomer_details set dob=?,age=?,gender=?,dno=?,street=?,city=?,state=?,phno=? where cid=?");
- prp.setString(1,dob);
- prp.setInt(2,age);
- prp.setString(3,sex);
- prp.setString(4,dno);
- prp.setString(5,street);
- prp.setString(6,city);
- prp.setString(7,state);
- prp.setString(8,phno);
- prp.setInt(9,currentcid);
- prp.executeUpdate();
- JOptionPane.showMessageDialog(null,"The Customer Details Updated Successfully");
- con.commit();
- con.close();
- dispose();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- }
- }
- private void jTextField7FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- String temp=(String)jComboBox3.getSelectedItem();
- int birthyear=Integer.parseInt(temp);
- int thisyear=Integer.parseInt(year);
- System.out.println(birthyear+","+thisyear);
- int agefind=thisyear-birthyear;
- agefind=agefind-1;
- jTextField7.setText(Integer.toString(agefind));
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jComboBox1.setSelectedItem("01");
- jComboBox2.setSelectedItem("jan");
- jComboBox3.setSelectedItem("1910");
- jRadioButton1.setSelected(true);
- jTextField7.setText("");jLabel19.setText("");
- jTextField8.setText("");jLabel20.setText("");
- jTextField9.setText("");jLabel21.setText("");
- jTextField10.setText("");jLabel22.setText("");
- jTextField11.setText("");jLabel23.setText("");
- jTextField12.setText("");jLabel24.setText("");
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new CreditCustomer().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- public javax.swing.JButton jButton1;
- public javax.swing.JButton jButton2;
- public javax.swing.JComboBox jComboBox1;
- public javax.swing.JComboBox jComboBox2;
- public javax.swing.JComboBox jComboBox3;
- private javax.swing.JLabel jLabe;
- public javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel10;
- private javax.swing.JLabel jLabel11;
- private javax.swing.JLabel jLabel12;
- private javax.swing.JLabel jLabel13;
- private javax.swing.JLabel jLabel14;
- private javax.swing.JLabel jLabel15;
- private javax.swing.JLabel jLabel16;
- private javax.swing.JLabel jLabel17;
- private javax.swing.JLabel jLabel18;
- private javax.swing.JLabel jLabel19;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel20;
- private javax.swing.JLabel jLabel21;
- private javax.swing.JLabel jLabel22;
- private javax.swing.JLabel jLabel23;
- private javax.swing.JLabel jLabel24;
- public javax.swing.JLabel jLabel25;
- public javax.swing.JLabel jLabel26;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- public javax.swing.JLabel jLabel8;
- private javax.swing.JLabel jLabel9;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JPanel jPanel3;
- public javax.swing.JRadioButton jRadioButton1;
- public javax.swing.JRadioButton jRadioButton2;
- private javax.swing.JScrollPane jScrollPane1;
- public javax.swing.JTextArea jTextArea1;
- public javax.swing.JTextField jTextField1;
- public javax.swing.JTextField jTextField10;
- public javax.swing.JTextField jTextField11;
- public javax.swing.JTextField jTextField12;
- public javax.swing.JTextField jTextField13;
- public javax.swing.JTextField jTextField14;
- public javax.swing.JTextField jTextField2;
- public javax.swing.JTextField jTextField3;
- public javax.swing.JTextField jTextField4;
- public javax.swing.JTextField jTextField5;
- public javax.swing.JTextField jTextField6;
- public javax.swing.JTextField jTextField7;
- public javax.swing.JTextField jTextField8;
- public javax.swing.JTextField jTextField9;
- // End of variables declaration
- }
- Code for SearchCustomer Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * SearchCustomer.java
- *
- * Created on Nov 10, 2010, 2:26:43 AM
- */
- package mobilestorenew;
- import java.sql.*;
- import javax.swing.*;
- /**
- *
- * @author Ramesh
- */
- public class SearchCustomer extends javax.swing.JFrame {
- /** Creates new form SearchCustomer */
- int flag=0,rows=0,a=0,b=0;
- String cid;
- Object data[][];
- JTable table;
- JScrollPane jsp;
- ResultSet res;
- ResultSet rs;
- public SearchCustomer() {
- initComponents();
- setVisible(true);
- setSize(1270,740);
- setTitle("Search Customer");
- ButtonGroup bg=new ButtonGroup();
- bg.add(jRadioButton1);
- bg.add(jRadioButton2);
- }
- public void tabledisp()
- {
- try
- {
- data=new Object[rows][15];
- Object[] colheads={"Custmer Id","Customer Name","Purchase Date","Paid Amount","Balance Amount","Reference Id","Date Of Birth","Age","Gender","Door No","Street","City","State","Phone No","Mobiles Purchased"};
- Class.forName("sun.jdbc.odbc.JdbcOdbc");
- Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- rs=st.executeQuery("select * from csearch");
- for(int i=0;i<rows;i++)
- {
- rs.next();
- for(int j=0;j<15;j++)
- {
- data [i][j]=rs.getString(j+1);
- System.out.println(data[i][j]);
- }
- }
- table=new JTable(data,colheads);
- int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
- int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
- jsp=new JScrollPane(table,v,h);
- jsp.setBounds(70,380,900,240);
- jPanel2.add(jsp);
- add(jsp);
- System.out.println("hai we came here");
- rows=0;
- st.close();
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"here the error is:"+e);
- }
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jPanel1 = new javax.swing.JPanel();
- jLabel2 = new javax.swing.JLabel();
- jTextField1 = new javax.swing.JTextField();
- jLabel3 = new javax.swing.JLabel();
- jRadioButton1 = new javax.swing.JRadioButton();
- jRadioButton2 = new javax.swing.JRadioButton();
- jLabel1 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- jPanel2 = new javax.swing.JPanel();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
- jPanel1.setLayout(null);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jLabel2.setText("Search Field");
- jPanel1.add(jLabel2);
- jLabel2.setBounds(90, 40, 90, 30);
- jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
- public void focusGained(java.awt.event.FocusEvent evt) {
- jTextField1FocusGained(evt);
- }
- });
- jPanel1.add(jTextField1);
- jTextField1.setBounds(210, 40, 160, 30);
- jPanel1.add(jLabel3);
- jLabel3.setBounds(380, 40, 100, 30);
- jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
- jRadioButton1.setSelected(true);
- jRadioButton1.setText(" Search By Customer Id");
- jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton1ActionPerformed(evt);
- }
- });
- jPanel1.add(jRadioButton1);
- jRadioButton1.setBounds(90, 110, 210, 25);
- jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 14));
- jRadioButton2.setText(" Search By Customer Name");
- jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton2ActionPerformed(evt);
- }
- });
- jPanel1.add(jRadioButton2);
- jRadioButton2.setBounds(90, 160, 230, 25);
- getContentPane().add(jPanel1);
- jPanel1.setBounds(40, 90, 500, 240);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
- jLabel1.setText("Search Customer Details");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(310, 20, 320, 50);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton1.setText("Search");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1);
- jButton1.setBounds(610, 180, 120, 40);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton2.setText("Cancel");
- getContentPane().add(jButton2);
- jButton2.setBounds(770, 180, 100, 40);
- jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("Search Results"));
- javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
- jPanel2.setLayout(jPanel2Layout);
- jPanel2Layout.setHorizontalGroup(
- jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 944, Short.MAX_VALUE)
- );
- jPanel2Layout.setVerticalGroup(
- jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 270, Short.MAX_VALUE)
- );
- getContentPane().add(jPanel2);
- jPanel2.setBounds(40, 350, 960, 300);
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jTextField1.getText().equals(""))
- {
- jLabel3.setText("Entry Is Must");
- jTextField1.setText("");
- }
- else
- {
- jLabel3.setText("");
- cid=jTextField1.getText();
- if(flag==0)
- {
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- st.executeUpdate("delete csearch");
- res=st.executeQuery("select * from newcustomer_details");
- Boolean rec=res.next();
- if(rec==false)
- {
- JOptionPane.showMessageDialog(null,"There are no customers exists");
- jTextField1.setText("");
- }
- else
- {
- do
- {
- String dcid=res.getString(1);
- String dcname=res.getString(2);
- java.sql.Date dt=res.getDate(3);
- String dd=dt.toString();
- String year=dd.substring(0,4);
- String month=dd.substring(5,7);
- String day=dd.substring(8,10);
- String mc="";
- if(month.equals("01"))
- {
- mc="jan";
- }
- else if(month.equals("02"))
- {
- mc="feb";
- }
- else if(month.equals("03"))
- {
- mc="mar";
- }
- else if(month.equals("04"))
- {
- mc="apr";
- }
- else if(month.equals("05"))
- {
- mc="may";
- }
- else if(month.equals("06"))
- {
- mc="jun";
- }
- else if(month.equals("07"))
- {
- mc="jul";
- }
- else if(month.equals("08"))
- {
- mc="aug";
- }
- else if(month.equals("09"))
- {
- mc="sep";
- }
- else if(month.equals("10"))
- {
- mc="oct";
- }
- else if(month.equals("11"))
- {
- mc="nov";
- }
- else if(month.equals("12"))
- {
- mc="dec";
- }
- String date=day+"-"+mc+"-"+year;
- int dpaidamt=res.getInt(4);
- int dbalamt=res.getInt(5);
- int drefid=res.getInt(6);
- java.sql.Date dob=res.getDate(7);
- String ddob=dob.toString();
- String year1=ddob.substring(0,4);
- String month1=ddob.substring(5,7);
- String day1=ddob.substring(8,10);
- String mc1="";
- if(month1.equals("01"))
- {
- mc1="jan";
- }
- else if(month1.equals("02"))
- {
- mc1="feb";
- }
- else if(month1.equals("03"))
- {
- mc1="mar";
- }
- else if(month1.equals("04"))
- {
- mc1="apr";
- }
- else if(month1.equals("05"))
- {
- mc1="may";
- }
- else if(month1.equals("06"))
- {
- mc1="jun";
- }
- else if(month1.equals("07"))
- {
- mc1="jul";
- }
- else if(month1.equals("08"))
- {
- mc1="aug";
- }
- else if(month1.equals("09"))
- {
- mc1="sep";
- }
- else if(month1.equals("10"))
- {
- mc1="oct";
- }
- else if(month1.equals("11"))
- {
- mc1="nov";
- }
- else if(month1.equals("12"))
- {
- mc1="dec";
- }
- String date1=day1+"-"+mc1+"-"+year1;
- int dage=res.getInt(8);
- String dgender=res.getString(9);
- String ddno=res.getString(10);
- String dstreet=res.getString(11);
- String dcity=res.getString(12);
- String dstate=res.getString(13);
- String dphno=res.getString(14);
- String dmob_purchased=res.getString(15);
- if(cid.equalsIgnoreCase(dcid))
- {
- PreparedStatement prp=con.prepareStatement("insert into csearch values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
- prp.setString(1,dcid);
- prp.setString(2,dcname);
- prp.setString(3,date);
- prp.setInt(4,dpaidamt);
- prp.setInt(5,dbalamt);
- prp.setInt(6,drefid);
- prp.setString(7,date1);
- prp.setInt(8,dage);
- prp.setString(9,dgender);
- prp.setString(10,ddno);
- prp.setString(11,dstreet);
- prp.setString(12,dcity);
- prp.setString(13,dstate);
- prp.setString(14,dphno);
- prp.setString(15,dmob_purchased);
- prp.executeUpdate();
- rows++;
- System.out.println(rows);
- System.out.println("i came here");
- a=1;
- jTextField1.setText("");
- }
- }while(res.next());
- if(a==0)
- {
- JOptionPane.showMessageDialog(null,"The customer ID does not exists");
- jTextField1.setText("");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- tabledisp();
- }
- if(flag==1)
- {
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- st.executeUpdate("delete csearch");
- res=st.executeQuery("select * from newcustomer_details");
- Boolean rec=res.next();
- if(rec==false)
- {
- JOptionPane.showMessageDialog(null,"There are no customers exists");
- jTextField1.setText("");
- }
- else
- {
- do
- {
- String dcid=res.getString(1);
- String dcname=res.getString(2);
- java.sql.Date dt=res.getDate(3);
- String dd=dt.toString();
- String year=dd.substring(0,4);
- String month=dd.substring(5,7);
- String day=dd.substring(8,10);
- String mc="";
- if(month.equals("01"))
- {
- mc="jan";
- }
- else if(month.equals("02"))
- {
- mc="feb";
- }
- else if(month.equals("03"))
- {
- mc="mar";
- }
- else if(month.equals("04"))
- {
- mc="apr";
- }
- else if(month.equals("05"))
- {
- mc="may";
- }
- else if(month.equals("06"))
- {
- mc="jun";
- }
- else if(month.equals("07"))
- {
- mc="jul";
- }
- else if(month.equals("08"))
- {
- mc="aug";
- }
- else if(month.equals("09"))
- {
- mc="sep";
- }
- else if(month.equals("10"))
- {
- mc="oct";
- }
- else if(month.equals("11"))
- {
- mc="nov";
- }
- else if(month.equals("12"))
- {
- mc="dec";
- }
- String date=day+"-"+mc+"-"+year;
- int dpaidamt=res.getInt(4);
- int dbalamt=res.getInt(5);
- int drefid=res.getInt(6);
- java.sql.Date dob=res.getDate(7);
- String ddob=dob.toString();
- String year1=ddob.substring(0,4);
- String month1=ddob.substring(5,7);
- String day1=ddob.substring(8,10);
- String mc1="";
- if(month1.equals("01"))
- {
- mc1="jan";
- }
- else if(month1.equals("02"))
- {
- mc1="feb";
- }
- else if(month1.equals("03"))
- {
- mc1="mar";
- }
- else if(month1.equals("04"))
- {
- mc1="apr";
- }
- else if(month1.equals("05"))
- {
- mc1="may";
- }
- else if(month1.equals("06"))
- {
- mc1="jun";
- }
- else if(month1.equals("07"))
- {
- mc1="jul";
- }
- else if(month1.equals("08"))
- {
- mc1="aug";
- }
- else if(month1.equals("09"))
- {
- mc1="sep";
- }
- else if(month1.equals("10"))
- {
- mc1="oct";
- }
- else if(month1.equals("11"))
- {
- mc1="nov";
- }
- else if(month1.equals("12"))
- {
- mc1="dec";
- }
- String date1=day1+"-"+mc1+"-"+year1;
- int dage=res.getInt(8);
- String dgender=res.getString(9);
- String ddno=res.getString(10);
- String dstreet=res.getString(11);
- String dcity=res.getString(12);
- String dstate=res.getString(13);
- String dphno=res.getString(14);
- String dmob_purchased=res.getString(15);
- if(cid.equals(dcname))
- {
- PreparedStatement prp=con.prepareStatement("insert into csearch values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
- prp.setString(1,dcid);
- prp.setString(2,dcname);
- prp.setString(3,date);
- prp.setInt(4,dpaidamt);
- prp.setInt(5,dbalamt);
- prp.setInt(6,drefid);
- prp.setString(7,date1);
- prp.setInt(8,dage);
- prp.setString(9,dgender);
- prp.setString(10,ddno);
- prp.setString(11,dstreet);
- prp.setString(12,dcity);
- prp.setString(13,dstate);
- prp.setString(14,dphno);
- prp.setString(15,dmob_purchased);
- prp.executeUpdate();
- rows++;
- System.out.println(rows);
- System.out.println("i came here");
- b=1;
- jTextField1.setText("");
- }
- }while(res.next());
- if(b==0)
- {
- JOptionPane.showMessageDialog(null,"The customer Name does not exists");
- jTextField1.setText("");
- }
- }
- con.commit();
- con.close();
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- tabledisp();
- }
- }
- }
- private void jTextField1FocusGained(java.awt.event.FocusEvent evt) {
- // TODO add your handling code here:
- jsp.setVisible(false);
- a=0;
- b=0;
- }
- private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- flag=0;
- }
- private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- flag=1;
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new SearchCustomer().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JRadioButton jRadioButton1;
- private javax.swing.JRadioButton jRadioButton2;
- private javax.swing.JTextField jTextField1;
- // End of variables declaration
- }
- Code for SalesReports Page:
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * SalesReports.java
- *
- * Created on Nov 15, 2010, 1:27:07 AM
- */
- package mobilestorenew;
- import java.awt.Font;
- import java.awt.Graphics;
- import java.awt.Graphics2D;
- import java.awt.print.*;
- import java.sql.*;
- import javax.swing.*;
- /**
- *
- * @author Ramesh
- */
- public class SalesReports extends javax.swing.JFrame implements Printable {
- /** Creates new form SalesReports */
- String text="";
- int a=0,flag;
- int countsales=0,totalamt=0;
- public SalesReports() {
- initComponents();
- setSize(1270,740);
- setTitle("Sales Reports");
- jTextArea1.setEditable(false);
- setVisible(true);
- }
- /** This method is called from within the constructor to
- * initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is
- * always regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTextArea1 = new javax.swing.JTextArea();
- jComboBox1 = new javax.swing.JComboBox();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jComboBox2 = new javax.swing.JComboBox();
- jButton3 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- getContentPane().setLayout(null);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
- jLabel1.setText("Sales Reports");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(430, 10, 320, 40);
- jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jButton1.setText("Print");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1);
- jButton1.setBounds(400, 610, 110, 50);
- jButton2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
- jButton2.setText("Close");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2);
- jButton2.setBounds(550, 610, 100, 50);
- jTextArea1.setColumns(20);
- jTextArea1.setEditable(false);
- jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
- jTextArea1.setRows(5);
- jTextArea1.setTabSize(10);
- jScrollPane1.setViewportView(jTextArea1);
- getContentPane().add(jScrollPane1);
- jScrollPane1.setBounds(70, 140, 910, 440);
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
- getContentPane().add(jComboBox1);
- jComboBox1.setBounds(280, 80, 100, 30);
- jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel2.setText("Select Month");
- getContentPane().add(jLabel2);
- jLabel2.setBounds(160, 80, 100, 30);
- jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jLabel3.setText("Select Year");
- getContentPane().add(jLabel3);
- jLabel3.setBounds(420, 80, 90, 30);
- jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" }));
- getContentPane().add(jComboBox2);
- jComboBox2.setBounds(520, 80, 100, 30);
- jButton3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jButton3.setText("Generate Report");
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton3);
- jButton3.setBounds(720, 70, 160, 50);
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jButton1.setVisible(false);
- jButton2.setVisible(false);
- jButton3.setVisible(false);
- PrinterJob printJob = PrinterJob.getPrinterJob();
- if (printJob.printDialog())
- {
- try
- {
- printJob.print();
- printJob.setCopies(1);
- }
- catch(Exception PrintException)
- {
- PrintException.printStackTrace();
- }
- printJob.cancel();
- }
- printJob.cancel();
- jButton1.setVisible(true);
- jButton2.setVisible(true);
- jButton3.setVisible(true);
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- dispose();
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- jTextArea1.setText("");
- text="";
- a=0;
- String month=(String)jComboBox1.getSelectedItem();
- String year=(String)jComboBox2.getSelectedItem();
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
- Statement st=con.createStatement();
- ResultSet res=st.executeQuery("select * from newbill");
- Boolean rec=res.next();
- if(rec==false)
- {
- JOptionPane.showMessageDialog(null,"There are no sales on that month");
- }
- else
- {
- if(flag==0)
- {
- do
- {
- String dbid = res.getString(1);
- java.sql.Date dbdate = res.getDate(2);
- String bdate = dbdate.toString();
- String dmonth=bdate.substring(5,7);
- String dyear=bdate.substring(0,4);
- String mc1="";
- if (dmonth.equals("01"))
- {
- mc1 = "jan";
- }
- else if (dmonth.equals("02"))
- {
- mc1 = "feb";
- } else if (dmonth.equals("03"))
- {
- mc1 = "mar";
- } else if (dmonth.equals("04"))
- {
- mc1 = "apr";
- } else if (dmonth.equals("05"))
- {
- mc1 = "may";
- } else if (dmonth.equals("06"))
- {
- mc1 = "jun";
- } else if (dmonth.equals("07"))
- {
- mc1 = "jul";
- } else if (dmonth.equals("08"))
- {
- mc1 = "aug";
- } else if (dmonth.equals("09"))
- {
- mc1 = "sep";
- } else if (dmonth.equals("10"))
- {
- mc1 = "oct";
- } else if (dmonth.equals("11"))
- {
- mc1 = "nov";
- } else if (dmonth.equals("12"))
- {
- mc1 = "dec";
- }
- String dcname = res.getString(3);
- int dprice = res.getInt(4);
- int damtpaid = res.getInt(5);
- String mob_purchased = res.getString(7);
- if(mc1.equalsIgnoreCase(month) && dyear.equalsIgnoreCase(year))
- {
- countsales++;
- totalamt+=damtpaid;
- text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
- jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
- "-----------------------------------------------------------------------------------------------------" +
- "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
- "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
- a=1;
- countsales=0;
- totalamt=0;
- }
- }while(res.next());
- }
- if(flag==1)
- {
- do
- {
- String dbid = res.getString(1);
- java.sql.Date dbdate = res.getDate(2);
- String bdate = dbdate.toString();
- String dyear=bdate.substring(0,4);
- String dcname = res.getString(3);
- int dprice = res.getInt(4);
- int damtpaid = res.getInt(5);
- String mob_purchased = res.getString(7);
- if(dyear.equalsIgnoreCase(year))
- {
- countsales++;
- totalamt+=damtpaid;
- text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
- jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
- "-----------------------------------------------------------------------------------------------------" +
- "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
- "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
- countsales=0;
- totalamt=0;
- a=1;
- }
- }
- while(res.next());
- }
- if(a==0)
- {
- JOptionPane.showMessageDialog(null,"There are no sales on that particular month");
- jTextArea1.setText("");
- }
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(null,"The error is:"+e);
- }
- }
- public int print(Graphics g, PageFormat pf, int pi) throws PrinterException
- {
- Graphics2D g2 = (Graphics2D) g;
- g2.translate(pf.getImageableX()+5, pf.getImageableY()+5);
- Font f = new Font("Monospaced",Font.PLAIN,12);
- g2.setFont (f);
- paint (g2);
- return Printable.PAGE_EXISTS;
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new SalesReports().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- public javax.swing.JButton jButton3;
- public javax.swing.JComboBox jComboBox1;
- public javax.swing.JComboBox jComboBox2;
- public javax.swing.JLabel jLabel1;
- public javax.swing.JLabel jLabel2;
- public javax.swing.JLabel jLabel3;
- public javax.swing.JScrollPane jScrollPane1;
- public javax.swing.JTextArea jTextArea1;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement