Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 255.40 KB | None | 0 0
  1. Code for login page:
  2.  
  3. /*
  4. * To change this template, choose Tools | Templates
  5. * and open the template in the editor.
  6. */
  7.  
  8. /*
  9. * Login.java
  10. *
  11. * Created on Sep 6, 2010, 11:24:53 PM
  12. */
  13. package mobilestorenew;
  14.  
  15. import java.sql.*;
  16. import javax.swing.*;
  17.  
  18. /**
  19. *
  20. * @author Ramesh
  21. */
  22. public class Login extends javax.swing.JFrame {
  23.  
  24. /** Creates new form Login */
  25. String s1, s2, s3, s4;
  26. ResultSet res;
  27. int a = 0;
  28.  
  29. public Login() {
  30. initComponents();
  31. setSize(1270, 740);
  32. setTitle("Login Form");
  33. setVisible(true);
  34.  
  35.  
  36. }
  37.  
  38. /** This method is called from within the constructor to
  39. * initialize the form.
  40. * WARNING: Do NOT modify this code. The content of this method is
  41. * always regenerated by the Form Editor.
  42. */
  43. @SuppressWarnings("unchecked")
  44. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  45. private void initComponents() {
  46.  
  47. jLabel4 = new javax.swing.JLabel();
  48. jPanel1 = new javax.swing.JPanel();
  49. jLabel2 = new javax.swing.JLabel();
  50. jTextField1 = new javax.swing.JTextField();
  51. jLabel3 = new javax.swing.JLabel();
  52. jLabel1 = new javax.swing.JLabel();
  53. jPasswordField1 = new javax.swing.JPasswordField();
  54. jButton1 = new javax.swing.JButton();
  55. jButton2 = new javax.swing.JButton();
  56.  
  57. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  58. getContentPane().setLayout(null);
  59.  
  60. jLabel4.setFont(new java.awt.Font("Monotype Corsiva", 1, 60)); // NOI18N
  61. jLabel4.setForeground(new java.awt.Color(51, 255, 51));
  62. jLabel4.setText("Raj Mobile Store");
  63. getContentPane().add(jLabel4);
  64. jLabel4.setBounds(310, 60, 420, 70);
  65.  
  66. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  67. jPanel1.setLayout(null);
  68.  
  69. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  70. jLabel2.setText("User Name");
  71. jPanel1.add(jLabel2);
  72. jLabel2.setBounds(80, 100, 100, 30);
  73.  
  74. jTextField1.setFont(new java.awt.Font("Tahoma", 1, 18));
  75. jPanel1.add(jTextField1);
  76. jTextField1.setBounds(210, 100, 110, 30);
  77.  
  78. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 18));
  79. jLabel3.setText("Password");
  80. jPanel1.add(jLabel3);
  81. jLabel3.setBounds(80, 150, 110, 30);
  82.  
  83. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
  84. jLabel1.setText("Login Here");
  85. jPanel1.add(jLabel1);
  86. jLabel1.setBounds(150, 30, 130, 40);
  87.  
  88. jPasswordField1.setFont(new java.awt.Font("Tahoma", 1, 18));
  89. jPanel1.add(jPasswordField1);
  90. jPasswordField1.setBounds(210, 150, 110, 30);
  91.  
  92. jButton1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  93. jButton1.setText("Login");
  94. jButton1.addActionListener(new java.awt.event.ActionListener() {
  95. public void actionPerformed(java.awt.event.ActionEvent evt) {
  96. jButton1ActionPerformed(evt);
  97. }
  98. });
  99. jPanel1.add(jButton1);
  100. jButton1.setBounds(120, 230, 90, 40);
  101.  
  102. jButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  103. jButton2.setText("Cancel");
  104. jButton2.addActionListener(new java.awt.event.ActionListener() {
  105. public void actionPerformed(java.awt.event.ActionEvent evt) {
  106. jButton2ActionPerformed(evt);
  107. }
  108. });
  109. jPanel1.add(jButton2);
  110. jButton2.setBounds(230, 230, 90, 40);
  111.  
  112. getContentPane().add(jPanel1);
  113. jPanel1.setBounds(300, 170, 430, 300);
  114.  
  115. pack();
  116. }// </editor-fold>
  117.  
  118. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  119. // TODO add your handling code here:
  120. s1 = jTextField1.getText();
  121. s2 = jPasswordField1.getText();
  122.  
  123. try {
  124. Connection co;
  125. Statement st;
  126. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  127. co = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  128. st = co.createStatement();
  129. res = st.executeQuery("select * from login");
  130. Boolean rec = res.next();
  131. if (!rec) {
  132. JOptionPane.showMessageDialog(null, "There is no records in the table");
  133. } else {
  134. do {
  135. s3 = res.getString(1);
  136. s4 = res.getString(2);
  137.  
  138. if (s1.equals(s3) && s2.equals(s4)) {
  139. dispose();
  140. new Home();
  141. a = 1;
  142. break;
  143. }
  144. } while (res.next());
  145. if (a == 0) {
  146. JOptionPane.showMessageDialog(null, "Invalid user or password");
  147. jTextField1.setText("");
  148. jPasswordField1.setText("");
  149. }
  150. }
  151. st.close();
  152. co.close();
  153. } catch (Exception e) {
  154. JOptionPane.showMessageDialog(null, "The error is:" + e);
  155. }
  156. }
  157.  
  158. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  159. // TODO add your handling code here:
  160. System.exit(0);
  161.  
  162. }
  163.  
  164. public static void main(String args[]) {
  165. java.awt.EventQueue.invokeLater(new Runnable() {
  166.  
  167. public void run() {
  168. new Login().setVisible(true);
  169. }
  170. });
  171. }
  172. // Variables declaration - do not modify
  173. private javax.swing.JButton jButton1;
  174. private javax.swing.JButton jButton2;
  175. private javax.swing.JLabel jLabel1;
  176. private javax.swing.JLabel jLabel2;
  177. private javax.swing.JLabel jLabel3;
  178. private javax.swing.JLabel jLabel4;
  179. private javax.swing.JPanel jPanel1;
  180. private javax.swing.JPasswordField jPasswordField1;
  181. private javax.swing.JTextField jTextField1;
  182. // End of variables declaration
  183. }
  184.  
  185.  
  186.  
  187. Code for Home Page:
  188.  
  189. /*
  190. * To change this template, choose Tools | Templates
  191. * and open the template in the editor.
  192. */
  193.  
  194. /*
  195. * Home.java
  196. *
  197. * Created on Sep 6, 2010, 11:53:35 PM
  198. */
  199. package mobilestorenew;
  200.  
  201. import java.sql.*;
  202. import javax.swing.*;
  203. import java.util.Date;
  204.  
  205. /**
  206. *
  207. * @author Ramesh
  208. */
  209. public class Home extends javax.swing.JFrame {
  210.  
  211. /** Creates new form Home */
  212. int a = 0, flag = 0, b = 0, c = 0, temp, d = 0, f = 0, g = 0;
  213. int rows = 0;
  214. Object data[][];
  215. String col[];
  216. String cid, cid1, id,text="";
  217. String mc1, mc;
  218. JTable table;
  219. String totaldata = "";
  220. int bid;
  221. Date dat1;String dt1,day1,month1,year1,date1;
  222.  
  223. public Home() {
  224.  
  225. initComponents();
  226. setSize(1270, 740);
  227. setTitle("Mobile Store Home Page");
  228. setVisible(true);
  229. idincrement();
  230. installmentcheck();
  231. }
  232.  
  233. public void idincrement()
  234. {
  235. try
  236. {
  237.  
  238. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  239. Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  240. Statement st=co.createStatement();
  241. ResultSet res=st.executeQuery("select * from newbill");
  242. while(res.next())
  243. {
  244. bid=res.getInt(1);
  245. }
  246.  
  247. st.close();
  248. co.close();
  249. }
  250. catch(Exception e)
  251. {
  252. JOptionPane.showMessageDialog(null,"the error is"+e);
  253. System.out.println(e.getMessage());
  254. }
  255. bid=bid+1;
  256.  
  257. dat1=new Date();
  258. dt1=dat1.toString();
  259. System.out.println(dt1);
  260. day1=dt1.substring(8,10);
  261. month1=dt1.substring(4,7);
  262. year1=dt1.substring(24,28);
  263.  
  264.  
  265. date1=day1;
  266. date1+="-";
  267. date1+=month1;
  268. date1+="-";
  269. date1+=year1;
  270.  
  271. }
  272. public void installmentcheck()
  273. {
  274. String countcid="";
  275. String countcname="";
  276. try
  277. {
  278. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  279. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  280. Statement st=con.createStatement();
  281. ResultSet res1=st.executeQuery("select cid,cname,pdate, floor(months_between(sysdate,pdate)) as diff from newcustomer_details");
  282. Boolean rec=res1.next();
  283. if(rec==false)
  284. {
  285. System.out.println("there are no records");
  286. }
  287. else
  288. {
  289. do
  290. {
  291. String dcid=res1.getString(1);
  292. String dcname=res1.getString(2);
  293.  
  294. int diff=res1.getInt(4);
  295.  
  296. if(diff>=2)
  297. {
  298. countcid+=dcid+"\n";
  299. countcname+=dcname+"\n";
  300. JOptionPane.showMessageDialog(null,"The following Customer Not Payed Their Installments from last two months\n" +
  301. countcid+"\t"+countcname);
  302. }
  303.  
  304. }while(res1.next());
  305. }
  306.  
  307. con.commit();
  308. con.close();
  309.  
  310.  
  311. }
  312. catch(Exception e)
  313. {
  314. JOptionPane.showMessageDialog(null,"The error is :"+e);
  315. }
  316. }
  317.  
  318.  
  319. /** This method is called from within the constructor to
  320. * initialize the form.
  321. * WARNING: Do NOT modify this code. The content of this method is
  322. * always regenerated by the Form Editor.
  323. */
  324. @SuppressWarnings("unchecked")
  325. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  326. private void initComponents() {
  327.  
  328. jMenuBar1 = new javax.swing.JMenuBar();
  329. jMenu1 = new javax.swing.JMenu();
  330. jMenuItem1 = new javax.swing.JMenuItem();
  331. jMenuItem3 = new javax.swing.JMenuItem();
  332. jMenuItem2 = new javax.swing.JMenuItem();
  333. jMenuItem4 = new javax.swing.JMenuItem();
  334. jMenu2 = new javax.swing.JMenu();
  335. jMenuItem6 = new javax.swing.JMenuItem();
  336. jMenuItem7 = new javax.swing.JMenuItem();
  337. jMenuItem8 = new javax.swing.JMenuItem();
  338. jMenuItem13 = new javax.swing.JMenuItem();
  339. jMenu3 = new javax.swing.JMenu();
  340. jMenuItem9 = new javax.swing.JMenuItem();
  341. jMenuItem10 = new javax.swing.JMenuItem();
  342. jMenu5 = new javax.swing.JMenu();
  343. jMenuItem5 = new javax.swing.JMenuItem();
  344. jMenuItem14 = new javax.swing.JMenuItem();
  345. jMenuItem15 = new javax.swing.JMenuItem();
  346. jMenu4 = new javax.swing.JMenu();
  347. jMenuItem11 = new javax.swing.JMenuItem();
  348. jMenuItem12 = new javax.swing.JMenuItem();
  349.  
  350. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  351. getContentPane().setLayout(null);
  352.  
  353. jMenu1.setText("Mobile Phone ");
  354.  
  355. jMenuItem1.setText("Add Mobile Phone");
  356. jMenuItem1.setToolTipText("Click here to add a mobile phone");
  357. jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
  358. public void actionPerformed(java.awt.event.ActionEvent evt) {
  359. jMenuItem1ActionPerformed(evt);
  360. }
  361. });
  362. jMenu1.add(jMenuItem1);
  363.  
  364. jMenuItem3.setText("Search Mobile Phone");
  365. jMenuItem3.setToolTipText("Click here to Search a Mobile Phone");
  366. jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
  367. public void actionPerformed(java.awt.event.ActionEvent evt) {
  368. jMenuItem3ActionPerformed(evt);
  369. }
  370. });
  371. jMenu1.add(jMenuItem3);
  372.  
  373. jMenuItem2.setText("Update Mobile Phone");
  374. jMenuItem2.setToolTipText("Click here to Update a Mobile Phone");
  375. jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
  376. public void actionPerformed(java.awt.event.ActionEvent evt) {
  377. jMenuItem2ActionPerformed(evt);
  378. }
  379. });
  380. jMenu1.add(jMenuItem2);
  381.  
  382. jMenuItem4.setText("Delete Mobile Phone");
  383. jMenuItem4.setToolTipText("Click here to delete a mobile phone");
  384. jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
  385. public void actionPerformed(java.awt.event.ActionEvent evt) {
  386. jMenuItem4ActionPerformed(evt);
  387. }
  388. });
  389. jMenu1.add(jMenuItem4);
  390.  
  391. jMenuBar1.add(jMenu1);
  392.  
  393. jMenu2.setText("Customer ");
  394.  
  395. jMenuItem6.setText("Search Customer");
  396. jMenuItem6.setToolTipText("Click here to Search a Customer");
  397. jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
  398. public void actionPerformed(java.awt.event.ActionEvent evt) {
  399. jMenuItem6ActionPerformed(evt);
  400. }
  401. });
  402. jMenu2.add(jMenuItem6);
  403.  
  404. jMenuItem7.setText("Update Customer");
  405. jMenuItem7.setToolTipText("Click here to Update Customer Details");
  406. jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
  407. public void actionPerformed(java.awt.event.ActionEvent evt) {
  408. jMenuItem7ActionPerformed(evt);
  409. }
  410. });
  411. jMenu2.add(jMenuItem7);
  412.  
  413. jMenuItem8.setText("Delete Customer");
  414. jMenuItem8.setToolTipText("Click here to Delete a Customer");
  415. jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
  416. public void actionPerformed(java.awt.event.ActionEvent evt) {
  417. jMenuItem8ActionPerformed(evt);
  418. }
  419. });
  420. jMenu2.add(jMenuItem8);
  421.  
  422. jMenuItem13.setText("Credit Payments");
  423. jMenuItem13.setToolTipText("Click here for Credit Payments");
  424. jMenuItem13.addActionListener(new java.awt.event.ActionListener() {
  425. public void actionPerformed(java.awt.event.ActionEvent evt) {
  426. jMenuItem13ActionPerformed(evt);
  427. }
  428. });
  429. jMenu2.add(jMenuItem13);
  430.  
  431. jMenuBar1.add(jMenu2);
  432.  
  433. jMenu3.setText("Bill Administration ");
  434.  
  435. jMenuItem9.setText("Generate Bill");
  436. jMenuItem9.setToolTipText("Click here to Generate Bill");
  437. jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
  438. public void actionPerformed(java.awt.event.ActionEvent evt) {
  439. jMenuItem9ActionPerformed(evt);
  440. }
  441. });
  442. jMenu3.add(jMenuItem9);
  443.  
  444. jMenuItem10.setText("Search Bill");
  445. jMenuItem10.setToolTipText("Click here Search a Bill");
  446. jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
  447. public void actionPerformed(java.awt.event.ActionEvent evt) {
  448. jMenuItem10ActionPerformed(evt);
  449. }
  450. });
  451. jMenu3.add(jMenuItem10);
  452.  
  453. jMenuBar1.add(jMenu3);
  454.  
  455. jMenu5.setText("Sales Reports ");
  456.  
  457. jMenuItem5.setText("Daily Reports");
  458. jMenuItem5.setToolTipText("Click here for Daily Reports");
  459. jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
  460. public void actionPerformed(java.awt.event.ActionEvent evt) {
  461. jMenuItem5ActionPerformed(evt);
  462. }
  463. });
  464. jMenu5.add(jMenuItem5);
  465.  
  466. jMenuItem14.setText("Monthly Reports");
  467. jMenuItem14.setToolTipText("Click here for Monthly Reports");
  468. jMenuItem14.addActionListener(new java.awt.event.ActionListener() {
  469. public void actionPerformed(java.awt.event.ActionEvent evt) {
  470. jMenuItem14ActionPerformed(evt);
  471. }
  472. });
  473. jMenu5.add(jMenuItem14);
  474.  
  475. jMenuItem15.setText("Yearly Reports");
  476. jMenuItem15.setToolTipText("Click here for Yearly Reports");
  477. jMenuItem15.addActionListener(new java.awt.event.ActionListener() {
  478. public void actionPerformed(java.awt.event.ActionEvent evt) {
  479. jMenuItem15ActionPerformed(evt);
  480. }
  481. });
  482. jMenu5.add(jMenuItem15);
  483.  
  484. jMenuBar1.add(jMenu5);
  485.  
  486. jMenu4.setText("User");
  487.  
  488. jMenuItem11.setText("LogOff");
  489. jMenuItem11.setToolTipText("Click here to LogOff");
  490. jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
  491. public void actionPerformed(java.awt.event.ActionEvent evt) {
  492. jMenuItem11ActionPerformed(evt);
  493. }
  494. });
  495. jMenu4.add(jMenuItem11);
  496.  
  497. jMenuItem12.setText("Exit");
  498. jMenuItem12.setToolTipText("Click here to Exit from the Application");
  499. jMenuItem12.addActionListener(new java.awt.event.ActionListener() {
  500. public void actionPerformed(java.awt.event.ActionEvent evt) {
  501. jMenuItem12ActionPerformed(evt);
  502. }
  503. });
  504. jMenu4.add(jMenuItem12);
  505.  
  506. jMenuBar1.add(jMenu4);
  507.  
  508. setJMenuBar(jMenuBar1);
  509.  
  510. pack();
  511. }// </editor-fold>
  512.  
  513. private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {
  514. // TODO add your handling code here:
  515. dispose();
  516. new Login();
  517. }
  518.  
  519. private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {
  520. // TODO add your handling code here:
  521. dispose();
  522. }
  523.  
  524. private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
  525. // TODO add your handling code here:
  526. new Addmobile1();
  527. }
  528.  
  529. private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {
  530. // TODO add your handling code here:
  531.  
  532. new SearchMobile();
  533. }
  534.  
  535. private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
  536. // TODO add your handling code here:
  537. new MobileUpdate();
  538. }
  539.  
  540. private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {
  541. // TODO add your handling code here:
  542.  
  543. String id1 = JOptionPane.showInputDialog(null, "Enter Mobile Phone Id (or) IMEI No");
  544. while (id1.equals("")) {
  545. JOptionPane.showMessageDialog(null, "You should have to enter something");
  546. id1 = JOptionPane.showInputDialog(null, "Enter Mobile Phone Id (or) IMEI No");
  547. }
  548. try {
  549. Connection con;
  550. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  551. con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  552. Statement st = con.createStatement();
  553. ResultSet res = st.executeQuery("select * from newmobile_details");
  554. Boolean rec = res.next();
  555. if (!rec) {
  556. JOptionPane.showMessageDialog(null, "There are no mobile phones in the database");
  557. } else {
  558. do {
  559.  
  560. String s1 = res.getString(1);
  561. String s2 = res.getString(3);
  562. String s3 = res.getString(6);
  563.  
  564. if (id1.equalsIgnoreCase(s1) || id1.equalsIgnoreCase(s3)) {
  565. 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);
  566. if (reply == JOptionPane.YES_OPTION) {
  567. PreparedStatement prp = con.prepareStatement("delete newmobile_details where phone_id=?");
  568. prp.setString(1, s1);
  569. prp.executeUpdate();
  570. JOptionPane.showMessageDialog(null, "The mobile successfully deleted");
  571. a = 1;
  572. } else if (reply == JOptionPane.NO_OPTION) {
  573. JOptionPane.showMessageDialog(null, "The mobile phone is not deleted");
  574. a = 1;
  575. break;
  576. } else if (reply == JOptionPane.CANCEL_OPTION) {
  577. JOptionPane.showMessageDialog(null, "The mobile phone details are not deleted");
  578. a = 1;
  579. break;
  580. } else {
  581. }
  582. }
  583.  
  584.  
  585. } while (res.next());
  586. if (a == 0) {
  587. JOptionPane.showMessageDialog(null, "The mobile phone does not exists in the database");
  588. }
  589. }
  590. con.commit();
  591. con.close();
  592.  
  593. } catch (Exception e) {
  594. JOptionPane.showMessageDialog(null, "the error is" + e);
  595. }
  596.  
  597. }
  598.  
  599. private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {
  600. // TODO add your handling code here:
  601. new BillGeneration();
  602. }
  603.  
  604. private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {
  605. // TODO add your handling code here:
  606. String searchbill = JOptionPane.showInputDialog(null, "Enter the Bill Id to search");
  607. while (searchbill.equals("")) {
  608. JOptionPane.showMessageDialog(null, "Please enter Bill Id");
  609. searchbill = JOptionPane.showInputDialog(null, "Enter the Bill Id to search");
  610. }
  611. try {
  612.  
  613. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  614. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  615. Statement st = con.createStatement();
  616. ResultSet res = st.executeQuery("select * from newbill");
  617. Boolean rec = res.next();
  618. if (!rec) {
  619. JOptionPane.showMessageDialog(null, "There are no Bills exists");
  620. } else {
  621. do {
  622. String dbid = res.getString(1);
  623. if (searchbill.equals(dbid)) {
  624. BillGeneration bg = new BillGeneration();
  625. bg.jTextField1.setText(dbid);
  626. bg.jTextField2.setText(res.getDate(2).toString());
  627. bg.jTextField3.setText(res.getString(3));
  628. bg.jTextField6.setText(res.getString(4));
  629. bg.jTextField7.setText(res.getString(5));
  630.  
  631. bg.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
  632. "--------------------------------------------------------------------------");
  633. bg.jTextArea1.append(res.getString(6));
  634. bg.jPanel1.setVisible(false);
  635. bg.jButton2.setVisible(false);
  636. bg.jTextField7.setEditable(false);
  637. bg.jTextField3.setEditable(false);
  638.  
  639. bg.jLabel2.setBounds(280, 110, 130, 30);
  640. bg.jTextField1.setBounds(460, 110, 130, 30);
  641. bg.jLabel3.setBounds(280, 170, 130, 30);
  642. bg.jTextField2.setBounds(460, 170, 130, 30);
  643. bg.jLabel4.setBounds(280, 230, 130, 30);
  644. bg.jTextField3.setBounds(460, 230, 130, 30);
  645. bg.jLabel8.setBounds(280, 290, 130, 30);
  646. bg.jScrollPane1.setBounds(460, 290, 410, 160);
  647. bg.jLabel9.setBounds(280, 480, 130, 30);
  648. bg.jTextField6.setBounds(460, 480, 130, 30);
  649. bg.jLabel10.setBounds(280, 540, 130, 30);
  650. bg.jTextField7.setBounds(460, 540, 130, 30);
  651. bg.jButton1.setBounds(430, 620, 100, 40);
  652.  
  653. bg.jLabel1.setText("Search Results");
  654. bg.jLabel8.setText("Mobiles Purchased");
  655. bg.jButton1.setText("CLOSE");
  656. bg.setTitle("Search Bill");
  657. bg.flag = 1;
  658. f = 1;
  659. }
  660. } while (res.next());
  661.  
  662. if (f == 0) {
  663. JOptionPane.showMessageDialog(null, "The Bill Id does not exists");
  664. }
  665. }
  666. } catch (Exception e) {
  667. JOptionPane.showMessageDialog(null, "The error is :" + e);
  668. }
  669.  
  670.  
  671. }
  672.  
  673. private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {
  674. // TODO add your handling code here:
  675. new SearchCustomer();
  676. }
  677.  
  678. private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {
  679. // TODO add your handling code here:
  680. cid = JOptionPane.showInputDialog(null, "Enter Customer Id");
  681. while (cid.equals("")) {
  682. JOptionPane.showMessageDialog(null, "Please Enter Customer Id");
  683. cid = JOptionPane.showInputDialog(null, "Enter Customer Id to Search");
  684. }
  685. try {
  686. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  687. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  688. Statement st = con.createStatement();
  689. ResultSet res = st.executeQuery("select * from newcustomer_details");
  690. Boolean rec = res.next();
  691. if (!rec) {
  692. JOptionPane.showMessageDialog(null, "There are no customer EXISTS");
  693. } else {
  694. do {
  695. cid1 = res.getString(1);
  696. if (cid.equalsIgnoreCase(cid1)) {
  697. CreditCustomer cc = new CreditCustomer();
  698.  
  699. cc.jTextField1.setText(cid1);
  700. cc.jTextField2.setText(res.getString(2));
  701. java.sql.Date dt = res.getDate(3);
  702.  
  703. String dd = dt.toString();
  704. String year = dd.substring(0, 4);
  705. String month = dd.substring(5, 7);
  706. String day = dd.substring(8, 10);
  707.  
  708. if (month.equals("01")) {
  709. mc1 = "jan";
  710. } else if (month.equals("02")) {
  711. mc1 = "feb";
  712. } else if (month.equals("03")) {
  713. mc1 = "mar";
  714. } else if (month.equals("04")) {
  715. mc1 = "apr";
  716. } else if (month.equals("05")) {
  717. mc1 = "may";
  718. } else if (month.equals("06")) {
  719. mc1 = "jun";
  720. } else if (month.equals("07")) {
  721. mc1 = "jul";
  722. } else if (month.equals("08")) {
  723. mc1 = "aug";
  724. } else if (month.equals("09")) {
  725. mc1 = "sep";
  726. } else if (month.equals("10")) {
  727. mc1 = "oct";
  728. } else if (month.equals("11")) {
  729. mc1 = "nov";
  730. } else if (month.equals("12")) {
  731. mc1 = "dec";
  732. }
  733. String date = day;
  734. date += "-";
  735. date += mc1;
  736. date += "-";
  737. date += year;
  738. cc.jTextField3.setText(date);
  739. cc.jTextField4.setText(Integer.toString(res.getInt(4)));
  740. cc.jTextField5.setText(Integer.toString(res.getInt(5)));
  741. cc.jTextField6.setText(Integer.toString(res.getInt(6)));
  742.  
  743. java.sql.Date dob = res.getDate(7);
  744. String ddob = dob.toString();
  745. String year2 = ddob.substring(0, 4);
  746. String month2 = ddob.substring(5, 7);
  747. String day2 = ddob.substring(8, 10);
  748.  
  749. if (month2.equals("01")) {
  750. mc = "jan";
  751. } else if (month2.equals("02")) {
  752. mc = "feb";
  753. } else if (month2.equals("03")) {
  754. mc = "mar";
  755. } else if (month2.equals("04")) {
  756. mc = "apr";
  757. } else if (month2.equals("05")) {
  758. mc = "may";
  759. } else if (month2.equals("06")) {
  760. mc = "jun";
  761. } else if (month2.equals("07")) {
  762. mc = "jul";
  763. } else if (month2.equals("08")) {
  764. mc = "aug";
  765. } else if (month2.equals("09")) {
  766. mc = "sep";
  767. } else if (month2.equals("10")) {
  768. mc = "oct";
  769. } else if (month2.equals("11")) {
  770. mc = "nov";
  771. } else if (month2.equals("12")) {
  772. mc = "dec";
  773. }
  774.  
  775. cc.jComboBox1.setSelectedItem(day2);
  776. cc.jComboBox2.setSelectedItem(mc);
  777. cc.jComboBox3.setSelectedItem(year2);
  778. cc.jTextField7.setText(Integer.toString(res.getInt(8)));
  779.  
  780. String gender = res.getString(9);
  781. if (gender.equalsIgnoreCase("male")) {
  782. cc.jRadioButton1.setSelected(true);
  783. } else if (gender.equalsIgnoreCase("female")) {
  784. cc.jRadioButton2.setSelected(true);
  785. }
  786.  
  787. cc.jTextField8.setText(res.getString(10));
  788. cc.jTextField9.setText(res.getString(11));
  789. cc.jTextField10.setText(res.getString(12));
  790. cc.jTextField11.setText(res.getString(13));
  791. cc.jTextField12.setText(res.getString(14));
  792. cc.jTextArea1.setText(res.getString(15));
  793. cc.jTextField13.setVisible(false);
  794. cc.jTextField14.setVisible(false);
  795. cc.jLabel25.setVisible(false);
  796. cc.jLabel26.setVisible(false);
  797. cc.jLabel1.setText("Update Customer Details");
  798. cc.jButton1.setText("Update Customer Details");
  799. cc.flag = 3;
  800.  
  801. c = 1;
  802. break;
  803. }
  804.  
  805. } while (res.next());
  806. if (c == 0) {
  807. JOptionPane.showMessageDialog(null, "The customer id does not exists");
  808. }
  809. }
  810. } catch (Exception e) {
  811. JOptionPane.showMessageDialog(null, "The error is" + e);
  812. }
  813. }
  814.  
  815. private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {
  816. // TODO add your handling code here:
  817. cid = JOptionPane.showInputDialog(null, "Enter Customer Id");
  818. while (cid.equals("")) {
  819. JOptionPane.showMessageDialog(null, "Please Enter Customer Id");
  820. cid = JOptionPane.showInputDialog(null, "Enter Customer Id to Search");
  821. }
  822. try {
  823. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  824. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  825. Statement st = con.createStatement();
  826. ResultSet res = st.executeQuery("select * from newcustomer_details");
  827. Boolean rec = res.next();
  828. if (!rec) {
  829. JOptionPane.showMessageDialog(null, "There are no customer");
  830. } else {
  831. do {
  832. cid1 = res.getString(1);
  833. if (cid.equalsIgnoreCase(cid1)) {
  834. int reply = JOptionPane.showConfirmDialog(null, "Are you sure you want delete this customer");
  835.  
  836. if (reply == JOptionPane.YES_OPTION) {
  837. PreparedStatement prp = con.prepareStatement("delete newcustomer_details where cid=" + cid);
  838. prp.executeUpdate();
  839. JOptionPane.showMessageDialog(null, "The Customer Details Deleted Successfully");
  840. } else if (reply == JOptionPane.NO_OPTION) {
  841. JOptionPane.showMessageDialog(null, "The customer details are not deleted");
  842. } else if (reply == JOptionPane.CANCEL_OPTION) {
  843. JOptionPane.showMessageDialog(null, "The customer details are not deleted");
  844. }
  845. d = 1;
  846. break;
  847. }
  848. } while (res.next());
  849. if (d == 0) {
  850. JOptionPane.showMessageDialog(null, "The Customer Id is not exists in the database");
  851. }
  852. con.commit();
  853. con.close();
  854. }
  855. } catch (Exception e) {
  856. JOptionPane.showMessageDialog(null, "The error is:" + e);
  857. }
  858. }
  859.  
  860. private void jMenuItem13ActionPerformed(java.awt.event.ActionEvent evt) {
  861. // TODO add your handling code here:
  862. int creditpayid;
  863. String creditpayid1 = JOptionPane.showInputDialog(null, "Enter Customer Id");
  864. while (creditpayid1.equals(""))
  865. {
  866. JOptionPane.showMessageDialog(null, "Please enter Customer Id");
  867. creditpayid1 = JOptionPane.showInputDialog(null, "Enter Customer Id");
  868. }
  869.  
  870. try
  871. {
  872. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  873. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  874. Statement st = con.createStatement();
  875. ResultSet res = st.executeQuery("select * from newcustomer_details");
  876. Boolean rec = res.next();
  877. if (rec == false)
  878. {
  879. JOptionPane.showMessageDialog(null, "There are no records");
  880. }
  881. else
  882. {
  883. do
  884. {
  885. int dcid = res.getInt(1);
  886. String dcname = res.getString(2);
  887. int dpaidamt = res.getInt(4);
  888. int dbalamt = res.getInt(5);
  889. int drefid = res.getInt(6);
  890.  
  891. String dmob_purchase = res.getString(15);
  892.  
  893. creditpayid = Integer.parseInt(creditpayid1);
  894.  
  895. if (creditpayid == dcid)
  896. {
  897.  
  898. int creditpay = Integer.parseInt(JOptionPane.showInputDialog(null, "Enter the Amount that Customer want to Pay"));
  899. while(creditpay<500)
  900. {
  901. JOptionPane.showMessageDialog(null,"The Installment Payment should be Greater than or equal to 500");
  902. creditpay = Integer.parseInt(JOptionPane.showInputDialog(null, "Enter the Amount that Customer want to Pay"));
  903. }
  904.  
  905. int totalbal = dbalamt - creditpay;
  906.  
  907. PreparedStatement prp = con.prepareStatement("update newcustomer_details set pdate=?,paidamt=?,balamt=? where cid=?");
  908. prp.setString(1,date1);
  909. prp.setInt(2, creditpay);
  910. prp.setInt(3, totalbal);
  911. prp.setInt(4, dcid);
  912. prp.executeUpdate();
  913.  
  914. JOptionPane.showMessageDialog(null, dcname + " Remaining Balance Amount is: " + totalbal);
  915. int reply = JOptionPane.showConfirmDialog(null, "Do you want to print the Bill");
  916. if (reply == JOptionPane.YES_OPTION)
  917. {
  918.  
  919. PrintPreview pp=new PrintPreview();
  920. pp.jLabel3.setText(Integer.toString(bid));
  921. pp.jLabel5.setText(date1);
  922. pp.jLabel7.setText(dcname);
  923. pp.jLabel10.setText("Amount Paid:");
  924. pp.jLabel11.setText(Integer.toString(creditpay));
  925. pp.jLabel12.setText("Remaining Balance:");
  926. pp.jLabel13.setText(Integer.toString(totalbal));
  927. pp.jTextArea1.setText(dmob_purchase);
  928. pp.flag=1;
  929. }
  930. else if (reply == JOptionPane.NO_OPTION)
  931. {
  932. }
  933. else if (reply == JOptionPane.CANCEL_OPTION)
  934. {
  935. }
  936. g = 1;
  937.  
  938.  
  939. }
  940. }
  941. while (res.next());
  942. if (g == 0)
  943. {
  944. JOptionPane.showMessageDialog(null, "The Customer Id does not exists");
  945. }
  946. }
  947. con.commit();
  948. con.close();
  949. }
  950. catch(NumberFormatException e)
  951. {
  952.  
  953. }
  954. catch (Exception e)
  955. {
  956. JOptionPane.showMessageDialog(null, "The error is : " + e);
  957. }
  958. }
  959.  
  960. private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {
  961. // TODO add your handling code here:
  962. int countsales=0,totalamt=0;
  963. try
  964. {
  965. String date = JOptionPane.showInputDialog(null, "Enter Date on which you want the Reports (EX:01-jan-2000)");
  966. while(date.equalsIgnoreCase(""))
  967. {
  968. JOptionPane.showMessageDialog(null,"Please enter date");
  969. date = JOptionPane.showInputDialog(null, "Enter Date on which you want the Reports (EX:01-jan-2000)");
  970. }
  971. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  972. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
  973. Statement st = con.createStatement();
  974. ResultSet res = st.executeQuery("select * from newbill where bdate='" + date + "'");
  975. Boolean rec = res.next();
  976. if (rec == false)
  977. {
  978. JOptionPane.showMessageDialog(null, "There are no sales on the given date");
  979. }
  980. else
  981. {
  982. SalesReports sr=new SalesReports();
  983. sr.jLabel2.setVisible(false);
  984. sr.jLabel3.setVisible(false);
  985. sr.jComboBox1.setVisible(false);
  986. sr.jComboBox2.setVisible(false);
  987. sr.jButton3.setVisible(false);
  988. sr.jScrollPane1.setBounds(60, 70, 910, 510);
  989. sr.jTextArea1.setText("");
  990. text="";
  991. sr.jLabel1.setText("Daily Reports");
  992. do
  993. {
  994. String dbid = res.getString(1);
  995. java.sql.Date dbdate = res.getDate(2);
  996. String bdate = dbdate.toString();
  997. String dcname = res.getString(3);
  998. int dprice = res.getInt(4);
  999. int damtpaid = res.getInt(5);
  1000. String mob_purchased = res.getString(7);
  1001. countsales++;
  1002. totalamt+=damtpaid;
  1003.  
  1004. text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
  1005. sr.jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
  1006. "-----------------------------------------------------------------------------------------------------" +
  1007. "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
  1008. "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
  1009.  
  1010.  
  1011. } while(res.next());
  1012.  
  1013.  
  1014. }
  1015. }
  1016. catch(NullPointerException e)
  1017. {
  1018.  
  1019. }
  1020. catch(SQLException e)
  1021. {
  1022. JOptionPane.showMessageDialog(null,"INVALID DATE!, please follow the Example");
  1023. }
  1024. catch (Exception e)
  1025. {
  1026. JOptionPane.showMessageDialog(null, "The error is:" + e);
  1027. }
  1028. }
  1029.  
  1030. private void jMenuItem14ActionPerformed(java.awt.event.ActionEvent evt) {
  1031. // TODO add your handling code here:
  1032. SalesReports sr=new SalesReports();
  1033. sr.jLabel1.setText("Monthly Reports");
  1034. sr.flag=0;
  1035. }
  1036.  
  1037. private void jMenuItem15ActionPerformed(java.awt.event.ActionEvent evt) {
  1038. // TODO add your handling code here:
  1039. SalesReports sr=new SalesReports();
  1040. sr.jLabel1.setText("Yearly Reports");
  1041. sr.jLabel2.setVisible(false);
  1042. sr.jComboBox1.setVisible(false);
  1043. sr.flag=1;
  1044. }
  1045.  
  1046. /**
  1047. * @param args the command line arguments
  1048. */
  1049. public static void main(String args[]) {
  1050. java.awt.EventQueue.invokeLater(new Runnable() {
  1051.  
  1052. public void run() {
  1053. new Home().setVisible(true);
  1054.  
  1055. }
  1056. });
  1057. }
  1058. // Variables declaration - do not modify
  1059. private javax.swing.JMenu jMenu1;
  1060. private javax.swing.JMenu jMenu2;
  1061. private javax.swing.JMenu jMenu3;
  1062. private javax.swing.JMenu jMenu4;
  1063. private javax.swing.JMenu jMenu5;
  1064. private javax.swing.JMenuBar jMenuBar1;
  1065. private javax.swing.JMenuItem jMenuItem1;
  1066. private javax.swing.JMenuItem jMenuItem10;
  1067. private javax.swing.JMenuItem jMenuItem11;
  1068. private javax.swing.JMenuItem jMenuItem12;
  1069. private javax.swing.JMenuItem jMenuItem13;
  1070. private javax.swing.JMenuItem jMenuItem14;
  1071. private javax.swing.JMenuItem jMenuItem15;
  1072. private javax.swing.JMenuItem jMenuItem2;
  1073. private javax.swing.JMenuItem jMenuItem3;
  1074. private javax.swing.JMenuItem jMenuItem4;
  1075. private javax.swing.JMenuItem jMenuItem5;
  1076. private javax.swing.JMenuItem jMenuItem6;
  1077. private javax.swing.JMenuItem jMenuItem7;
  1078. private javax.swing.JMenuItem jMenuItem8;
  1079. private javax.swing.JMenuItem jMenuItem9;
  1080. // End of variables declaration
  1081. }
  1082.  
  1083.  
  1084.  
  1085.  
  1086. Code for Addmobile Page:
  1087.  
  1088. /*
  1089. * To change this template, choose Tools | Templates
  1090. * and open the template in the editor.
  1091. */
  1092.  
  1093. /*
  1094. * Addmobile1.java
  1095. *
  1096. * Created on Sep 11, 2010, 10:53:35 PM
  1097. */
  1098.  
  1099. package mobilestorenew;
  1100.  
  1101. import java.sql.*;
  1102. import javax.swing.JOptionPane;
  1103. import java.util.Date;
  1104.  
  1105. /**
  1106. *
  1107. * @author Ramesh
  1108. */
  1109. public class Addmobile1 extends javax.swing.JFrame {
  1110.  
  1111. /** Creates new form Addmobile1 */
  1112. String model,name,pcolor,date1,cbox="";
  1113.  
  1114. int price,no,s1,s3,index,inc,inc1;
  1115. String s2,imeino,mid,dpname,dpid,pname;
  1116.  
  1117. int a=0,z=0,b=0,d=0;
  1118. int count=0;int prevalue=0,curvalue;
  1119.  
  1120.  
  1121. public Addmobile1()
  1122. {
  1123. initComponents();
  1124. setVisible(true);
  1125. setSize(1270,740);
  1126. setTitle("Add Mobile Phone Details");
  1127.  
  1128. jTextField5.setEditable(false);
  1129. jTextField6.setEditable(false);
  1130. jComboBox2.setEnabled(false);
  1131. jComboBox3.setEnabled(false);
  1132. jComboBox4.setEnabled(false);
  1133. jComboBox5.setEnabled(false);
  1134. jCheckBox1.setEnabled(false);
  1135. jCheckBox2.setEnabled(false);
  1136. jCheckBox3.setEnabled(false);
  1137. jCheckBox4.setEnabled(false);
  1138. jCheckBox5.setEnabled(false);
  1139. jCheckBox6.setEnabled(false);
  1140. jButton4.setEnabled(false);
  1141. jButton3.setEnabled(false);
  1142.  
  1143. }
  1144.  
  1145. /** This method is called from within the constructor to
  1146. * initialize the form.
  1147. * WARNING: Do NOT modify this code. The content of this method is
  1148. * always regenerated by the Form Editor.
  1149. */
  1150. @SuppressWarnings("unchecked")
  1151. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  1152. private void initComponents() {
  1153.  
  1154. jLabel1 = new javax.swing.JLabel();
  1155. jPanel1 = new javax.swing.JPanel();
  1156. jLabel18 = new javax.swing.JLabel();
  1157. jLabel19 = new javax.swing.JLabel();
  1158. jLabel20 = new javax.swing.JLabel();
  1159. jLabel21 = new javax.swing.JLabel();
  1160. jLabel22 = new javax.swing.JLabel();
  1161. jTextField5 = new javax.swing.JTextField();
  1162. jTextField6 = new javax.swing.JTextField();
  1163. jButton4 = new javax.swing.JButton();
  1164. jLabel12 = new javax.swing.JLabel();
  1165. jLabel11 = new javax.swing.JLabel();
  1166. jComboBox2 = new javax.swing.JComboBox();
  1167. jCheckBox1 = new javax.swing.JCheckBox();
  1168. jCheckBox2 = new javax.swing.JCheckBox();
  1169. jCheckBox3 = new javax.swing.JCheckBox();
  1170. jCheckBox4 = new javax.swing.JCheckBox();
  1171. jCheckBox5 = new javax.swing.JCheckBox();
  1172. jCheckBox6 = new javax.swing.JCheckBox();
  1173. jButton3 = new javax.swing.JButton();
  1174. jComboBox3 = new javax.swing.JComboBox();
  1175. jComboBox4 = new javax.swing.JComboBox();
  1176. jComboBox5 = new javax.swing.JComboBox();
  1177. jLabel5 = new javax.swing.JLabel();
  1178. jLabel7 = new javax.swing.JLabel();
  1179. jLabel13 = new javax.swing.JLabel();
  1180. jPanel2 = new javax.swing.JPanel();
  1181. jLabel2 = new javax.swing.JLabel();
  1182. jLabel3 = new javax.swing.JLabel();
  1183. jComboBox1 = new javax.swing.JComboBox();
  1184. jLabel4 = new javax.swing.JLabel();
  1185. jTextField2 = new javax.swing.JTextField();
  1186. jTextField3 = new javax.swing.JTextField();
  1187. jLabel6 = new javax.swing.JLabel();
  1188. jTextField4 = new javax.swing.JTextField();
  1189. jLabel8 = new javax.swing.JLabel();
  1190. jLabel9 = new javax.swing.JLabel();
  1191. jLabel10 = new javax.swing.JLabel();
  1192. jButton1 = new javax.swing.JButton();
  1193.  
  1194. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  1195. getContentPane().setLayout(null);
  1196.  
  1197. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
  1198. jLabel1.setText("Add Mobile Phone Details");
  1199. getContentPane().add(jLabel1);
  1200. jLabel1.setBounds(350, 0, 303, 40);
  1201.  
  1202. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  1203. jPanel1.setEnabled(false);
  1204. jPanel1.setLayout(null);
  1205.  
  1206. jLabel18.setFont(new java.awt.Font("Tahoma", 1, 14));
  1207. jLabel18.setText("Mobile Phone Id");
  1208. jPanel1.add(jLabel18);
  1209. jLabel18.setBounds(50, 20, 130, 30);
  1210.  
  1211. jLabel19.setFont(new java.awt.Font("Tahoma", 1, 14));
  1212. jLabel19.setText("Mobile Phone Color");
  1213. jPanel1.add(jLabel19);
  1214. jLabel19.setBounds(50, 70, 190, 30);
  1215.  
  1216. jLabel20.setFont(new java.awt.Font("Tahoma", 1, 14));
  1217. jLabel20.setText("Enter IMEI Number");
  1218. jPanel1.add(jLabel20);
  1219. jLabel20.setBounds(50, 120, 160, 30);
  1220.  
  1221. jLabel21.setFont(new java.awt.Font("Tahoma", 1, 14));
  1222. jLabel21.setText("Enter Date Of Manufacture");
  1223. jPanel1.add(jLabel21);
  1224. jLabel21.setBounds(50, 170, 190, 30);
  1225.  
  1226. jLabel22.setFont(new java.awt.Font("Tahoma", 1, 14));
  1227. jLabel22.setText("Additional Accessories");
  1228. jPanel1.add(jLabel22);
  1229. jLabel22.setBounds(50, 230, 170, 30);
  1230.  
  1231. jTextField5.setFont(new java.awt.Font("Tahoma", 1, 14));
  1232. jPanel1.add(jTextField5);
  1233. jTextField5.setBounds(250, 20, 140, 30);
  1234.  
  1235. jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
  1236. jTextField6.addFocusListener(new java.awt.event.FocusAdapter() {
  1237. public void focusLost(java.awt.event.FocusEvent evt) {
  1238. jTextField6FocusLost(evt);
  1239. }
  1240. });
  1241. jPanel1.add(jTextField6);
  1242. jTextField6.setBounds(250, 120, 140, 30);
  1243.  
  1244. jButton4.setFont(new java.awt.Font("Tahoma", 1, 18));
  1245. jButton4.setText(" SAVE PHONE DETAILS");
  1246. jButton4.addActionListener(new java.awt.event.ActionListener() {
  1247. public void actionPerformed(java.awt.event.ActionEvent evt) {
  1248. jButton4ActionPerformed(evt);
  1249. }
  1250. });
  1251. jPanel1.add(jButton4);
  1252. jButton4.setBounds(90, 330, 240, 50);
  1253.  
  1254. jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
  1255. jPanel1.add(jLabel12);
  1256. jLabel12.setBounds(410, 120, 100, 30);
  1257.  
  1258. jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
  1259. jPanel1.add(jLabel11);
  1260. jLabel11.setBounds(410, 20, 100, 30);
  1261.  
  1262. jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  1263. jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Red", "Green", "Blue", "Black", "White", "Cyan", "Yellow", "Orange", "Purple", "Pink", "Voilet", "Magenta" }));
  1264. jPanel1.add(jComboBox2);
  1265. jComboBox2.setBounds(250, 70, 140, 30);
  1266.  
  1267. jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11));
  1268. jCheckBox1.setText("Charger ");
  1269. jPanel1.add(jCheckBox1);
  1270. jCheckBox1.setBounds(250, 240, 80, 23);
  1271.  
  1272. jCheckBox2.setFont(new java.awt.Font("Tahoma", 1, 11));
  1273. jCheckBox2.setText("HeadSet ");
  1274. jPanel1.add(jCheckBox2);
  1275. jCheckBox2.setBounds(360, 240, 80, 23);
  1276.  
  1277. jCheckBox3.setFont(new java.awt.Font("Tahoma", 1, 11));
  1278. jCheckBox3.setText("DataCable ");
  1279. jPanel1.add(jCheckBox3);
  1280. jCheckBox3.setBounds(460, 240, 100, 23);
  1281.  
  1282. jCheckBox4.setFont(new java.awt.Font("Tahoma", 1, 11));
  1283. jCheckBox4.setText("Battery ");
  1284. jPanel1.add(jCheckBox4);
  1285. jCheckBox4.setBounds(250, 280, 80, 23);
  1286.  
  1287. jCheckBox5.setFont(new java.awt.Font("Tahoma", 1, 11));
  1288. jCheckBox5.setText("MemoryCard ");
  1289. jPanel1.add(jCheckBox5);
  1290. jCheckBox5.setBounds(360, 280, 101, 23);
  1291.  
  1292. jCheckBox6.setFont(new java.awt.Font("Tahoma", 1, 11));
  1293. jCheckBox6.setText("CD ");
  1294. jPanel1.add(jCheckBox6);
  1295. jCheckBox6.setBounds(470, 280, 50, 23);
  1296.  
  1297. jButton3.setFont(new java.awt.Font("Tahoma", 1, 18));
  1298. jButton3.setText("CANCEL");
  1299. jButton3.addActionListener(new java.awt.event.ActionListener() {
  1300. public void actionPerformed(java.awt.event.ActionEvent evt) {
  1301. jButton3ActionPerformed(evt);
  1302. }
  1303. });
  1304. jPanel1.add(jButton3);
  1305. jButton3.setBounds(370, 330, 110, 50);
  1306.  
  1307. jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
  1308. 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" }));
  1309. jPanel1.add(jComboBox3);
  1310. jComboBox3.setBounds(250, 180, 50, 30);
  1311.  
  1312. jComboBox4.setFont(new java.awt.Font("Tahoma", 1, 12));
  1313. jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
  1314. jPanel1.add(jComboBox4);
  1315. jComboBox4.setBounds(330, 180, 56, 30);
  1316.  
  1317. jComboBox5.setFont(new java.awt.Font("Tahoma", 1, 12));
  1318. 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" }));
  1319. jComboBox5.addFocusListener(new java.awt.event.FocusAdapter() {
  1320. public void focusLost(java.awt.event.FocusEvent evt) {
  1321. jComboBox5FocusLost(evt);
  1322. }
  1323. });
  1324. jPanel1.add(jComboBox5);
  1325. jComboBox5.setBounds(426, 180, 60, 30);
  1326.  
  1327. jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12));
  1328. jLabel5.setText("(DD)");
  1329. jPanel1.add(jLabel5);
  1330. jLabel5.setBounds(300, 180, 30, 30);
  1331.  
  1332. jLabel7.setFont(new java.awt.Font("Tahoma", 1, 12));
  1333. jLabel7.setText("(MM)");
  1334. jPanel1.add(jLabel7);
  1335. jLabel7.setBounds(390, 180, 32, 30);
  1336.  
  1337. jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
  1338. jLabel13.setText("(YY)");
  1339. jPanel1.add(jLabel13);
  1340. jLabel13.setBounds(490, 180, 30, 30);
  1341.  
  1342. getContentPane().add(jPanel1);
  1343. jPanel1.setBounds(200, 290, 570, 400);
  1344.  
  1345. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  1346. jPanel2.setLayout(null);
  1347.  
  1348. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
  1349. jLabel2.setText("Price");
  1350. jPanel2.add(jLabel2);
  1351. jLabel2.setBounds(50, 120, 90, 30);
  1352.  
  1353. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
  1354. jLabel3.setText("No. of Mobile Phones");
  1355. jPanel2.add(jLabel3);
  1356. jLabel3.setBounds(50, 170, 150, 30);
  1357.  
  1358. jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
  1359. jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
  1360. jPanel2.add(jComboBox1);
  1361. jComboBox1.setBounds(250, 20, 140, 30);
  1362.  
  1363. jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
  1364. jLabel4.setText("Mobile Phone Model");
  1365. jPanel2.add(jLabel4);
  1366. jLabel4.setBounds(50, 20, 150, 30);
  1367.  
  1368. jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
  1369. jTextField2.addFocusListener(new java.awt.event.FocusAdapter() {
  1370. public void focusLost(java.awt.event.FocusEvent evt) {
  1371. jTextField2FocusLost(evt);
  1372. }
  1373. });
  1374. jPanel2.add(jTextField2);
  1375. jTextField2.setBounds(250, 70, 140, 30);
  1376.  
  1377. jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
  1378. jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
  1379. public void focusLost(java.awt.event.FocusEvent evt) {
  1380. jTextField3FocusLost(evt);
  1381. }
  1382. });
  1383. jPanel2.add(jTextField3);
  1384. jTextField3.setBounds(250, 120, 140, 30);
  1385.  
  1386. jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
  1387. jLabel6.setText("Enter Mobile Name");
  1388. jPanel2.add(jLabel6);
  1389. jLabel6.setBounds(50, 70, 160, 30);
  1390.  
  1391. jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
  1392. jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
  1393. public void focusLost(java.awt.event.FocusEvent evt) {
  1394. jTextField4FocusLost(evt);
  1395. }
  1396. });
  1397. jPanel2.add(jTextField4);
  1398. jTextField4.setBounds(250, 170, 140, 30);
  1399.  
  1400. jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12));
  1401. jPanel2.add(jLabel8);
  1402. jLabel8.setBounds(410, 70, 100, 30);
  1403.  
  1404. jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
  1405. jPanel2.add(jLabel9);
  1406. jLabel9.setBounds(410, 120, 100, 30);
  1407.  
  1408. jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
  1409. jPanel2.add(jLabel10);
  1410. jLabel10.setBounds(410, 170, 100, 30);
  1411.  
  1412. getContentPane().add(jPanel2);
  1413. jPanel2.setBounds(200, 60, 570, 220);
  1414.  
  1415. jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
  1416. jButton1.setText("Enter each Phone Details");
  1417. jButton1.addActionListener(new java.awt.event.ActionListener() {
  1418. public void actionPerformed(java.awt.event.ActionEvent evt) {
  1419. jButton1ActionPerformed(evt);
  1420. }
  1421. });
  1422. getContentPane().add(jButton1);
  1423. jButton1.setBounds(780, 130, 210, 60);
  1424.  
  1425. pack();
  1426. }// </editor-fold>
  1427.  
  1428. private void jTextField2FocusLost(java.awt.event.FocusEvent evt) {
  1429. // TODO add your handling code here:
  1430. if(jTextField2.getText().equals(""))
  1431. {
  1432. jLabel8.setText("Entry Is Must");
  1433. jTextField2.setText("");
  1434. }
  1435. else
  1436. {
  1437. jLabel8.setText("");
  1438. try
  1439. {
  1440.  
  1441. name=jTextField2.getText();
  1442. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  1443. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  1444. Statement st=con.createStatement();
  1445. ResultSet res=st.executeQuery("select * from newmobile_details");
  1446. Boolean rec=res.next();
  1447. if(!rec)
  1448. {
  1449.  
  1450. }
  1451. else
  1452. {
  1453. do
  1454. {
  1455. String nm=res.getString(3);
  1456. if(name.equals(nm))
  1457. {
  1458. jTextField3.setText(Integer.toString(res.getInt(4)));
  1459.  
  1460. }
  1461. }while(res.next());
  1462.  
  1463.  
  1464. }
  1465. con.commit();
  1466. con.close();
  1467. }
  1468. catch(Exception e)
  1469. {
  1470. JOptionPane.showMessageDialog(null,"The error is :"+e);
  1471. }
  1472. }
  1473. }
  1474.  
  1475. private void jTextField3FocusLost(java.awt.event.FocusEvent evt) {
  1476. // TODO add your handling code here:
  1477. if(jTextField3.getText().equals(""))
  1478. {
  1479. jLabel9.setText("Entry Is Must") ;
  1480. jTextField3.setText("");
  1481. }
  1482.  
  1483. else
  1484. {
  1485. String jtf1=jTextField3.getText();
  1486. int fg=0;
  1487. for(int i=0;i<jtf1.length();i++)
  1488. {
  1489. char c=jtf1.charAt(i);
  1490. if(Character.isLetter(c))
  1491. {
  1492. fg=0;
  1493. break;
  1494. }
  1495. else
  1496. {
  1497. fg=1;
  1498.  
  1499. }
  1500. }
  1501. if(fg==0)
  1502. {
  1503. jLabel9.setText("Enter Numbers") ;
  1504. jTextField3.setText("");
  1505. }
  1506. else
  1507. jLabel9.setText("") ;
  1508. }
  1509. }
  1510.  
  1511. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  1512. // TODO add your handling code here:
  1513.  
  1514. if(jTextField2.getText().equals("") || jTextField3.getText().equals("") || jTextField4.getText().equals("")) {
  1515.  
  1516. JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
  1517.  
  1518. if(jTextField2.getText().equals("")) {
  1519. jLabel8.setText("Fill this field");
  1520. } else {
  1521. jLabel8.setText("");
  1522. }
  1523. if(jTextField3.getText().equals("")) {
  1524. jLabel9.setText("Fill this field");
  1525.  
  1526. } else {
  1527. jLabel9.setText("");
  1528. }
  1529. if(jTextField4.getText().equals("")) {
  1530. jLabel10.setText("Fill this field");
  1531. } else {
  1532. jLabel10.setText("");
  1533. }
  1534.  
  1535. }
  1536. else
  1537. {
  1538. no=Integer.parseInt(jTextField4.getText());
  1539. if(count<no)
  1540. {
  1541. jComboBox1.setEnabled(false);
  1542. jTextField2.setEditable(false);
  1543. jTextField3.setEditable(false);
  1544. jTextField4.setEditable(false);
  1545. jButton1.setEnabled(false);
  1546.  
  1547. JOptionPane.showMessageDialog(null,"Enter First Mobile Phone Details");
  1548. jTextField6.setEditable(true);
  1549. jComboBox2.setEnabled(true);
  1550. jComboBox3.setEnabled(true);
  1551. jComboBox4.setEnabled(true);
  1552. jComboBox5.setEnabled(true);
  1553. jCheckBox1.setEnabled(true);
  1554. jCheckBox2.setEnabled(true);
  1555. jCheckBox3.setEnabled(true);
  1556. jCheckBox4.setEnabled(true);
  1557. jCheckBox5.setEnabled(true);
  1558. jCheckBox6.setEnabled(true);
  1559. jButton4.setEnabled(true);
  1560. jButton3.setEnabled(true);
  1561.  
  1562. }
  1563. else
  1564. {
  1565. JOptionPane.showMessageDialog(null,"enter No. of Mobiles as 1 or more");
  1566. jTextField4.setText("");
  1567. }
  1568.  
  1569. //extra requirement code
  1570. try
  1571. {
  1572. pname=jTextField2.getText();
  1573. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  1574. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  1575. Statement st=con.createStatement();
  1576. ResultSet res=st.executeQuery("select * from newmobile_details");
  1577. Boolean rec=res.next();
  1578. if(!rec)
  1579. {
  1580. mid=jTextField2.getText();
  1581. mid+="-";
  1582. mid+="1";
  1583. jTextField5.setText(mid);
  1584. }
  1585. else
  1586. {
  1587. do
  1588. {
  1589. dpid=res.getString(1);
  1590. dpname=res.getString(3);
  1591. if(pname.equalsIgnoreCase(dpname))
  1592. {
  1593. System.out.println(dpid);
  1594.  
  1595. index=dpid.indexOf("-");
  1596.  
  1597. System.out.println(index);
  1598.  
  1599. curvalue=Integer.parseInt(dpid.substring(index+1));
  1600.  
  1601. if(prevalue<curvalue)
  1602. {
  1603. inc=curvalue+1;
  1604. prevalue=curvalue;
  1605. }
  1606.  
  1607. mid=jTextField2.getText();
  1608. mid+="-";
  1609. mid+=Integer.toString(inc);
  1610. jTextField5.setText(mid);
  1611. b=1;
  1612.  
  1613. }
  1614.  
  1615. }while(res.next());
  1616.  
  1617. if(b==0)
  1618. {
  1619. mid=jTextField2.getText();
  1620. mid+="-";
  1621. mid+="1";
  1622. jTextField5.setText(mid);
  1623. }
  1624. }
  1625. con.commit();
  1626. con.close();
  1627. }
  1628. catch(Exception e)
  1629. {
  1630. JOptionPane.showMessageDialog(null,"The error is:"+e);
  1631. }
  1632. //extra requirement code ends here
  1633.  
  1634. }
  1635. }
  1636.  
  1637. private void jTextField4FocusLost(java.awt.event.FocusEvent evt) {
  1638. // TODO add your handling code here:
  1639. if(jTextField4.getText().equals(""))
  1640. {
  1641. jLabel10.setText("Entry Is Must") ;
  1642. jTextField4.setText("");
  1643. }
  1644.  
  1645. else
  1646. {
  1647. String jtf1=jTextField4.getText();
  1648. int fg=0;
  1649. for(int i=0;i<jtf1.length();i++)
  1650. {
  1651. char c=jtf1.charAt(i);
  1652. if(Character.isLetter(c))
  1653. {
  1654. fg=0;
  1655. break;
  1656. }
  1657. else
  1658. {
  1659. fg=1;
  1660.  
  1661. }
  1662. }
  1663. if(fg==0)
  1664. {
  1665. jLabel10.setText("Enter Numbers") ;
  1666. jTextField4.setText("");
  1667. }
  1668. else
  1669. jLabel10.setText("") ;
  1670.  
  1671. }
  1672. }
  1673.  
  1674. private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
  1675. // TODO add your handling code here:
  1676. if(jTextField5.getText().equals("") || jTextField6.getText().equals(""))
  1677. {
  1678. JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
  1679. if(jTextField5.getText().equals(""))
  1680. {
  1681. jLabel11.setText("Fill this field");
  1682.  
  1683. }
  1684. else
  1685. {
  1686. jLabel11.setText("");
  1687. }
  1688. if(jTextField6.getText().equals(""))
  1689. {
  1690. jLabel12.setText("Fill this field");
  1691.  
  1692. }
  1693. else
  1694. {
  1695. jLabel12.setText("");
  1696. }
  1697.  
  1698. }
  1699. else
  1700. {
  1701.  
  1702. name=jTextField2.getText();
  1703. model=(String)jComboBox1.getSelectedItem();
  1704. price=Integer.parseInt(jTextField3.getText());
  1705.  
  1706. pcolor=(String)jComboBox2.getSelectedItem();
  1707. imeino=jTextField6.getText();
  1708.  
  1709. date1=(String)jComboBox3.getSelectedItem();
  1710. date1+="-";
  1711. date1+=(String)jComboBox4.getSelectedItem();
  1712. date1+="-";
  1713. date1+=(String)jComboBox5.getSelectedItem();
  1714.  
  1715.  
  1716. cbox="";
  1717. Boolean temp=(Boolean)jCheckBox1.isSelected();
  1718. if(temp==true)
  1719. {
  1720. cbox+=(String)jCheckBox1.getText();
  1721. }
  1722.  
  1723. Boolean temp1=(Boolean)jCheckBox2.isSelected();
  1724. if(temp1==true)
  1725. {
  1726. cbox+=(String)jCheckBox2.getText();
  1727. }
  1728.  
  1729. Boolean temp2=(Boolean)jCheckBox3.isSelected();
  1730. if(temp2==true)
  1731. {
  1732. cbox+=(String)jCheckBox3.getText();
  1733. }
  1734.  
  1735. Boolean temp3=(Boolean)jCheckBox4.isSelected();
  1736. if(temp3==true)
  1737. {
  1738. cbox+=(String)jCheckBox4.getText();
  1739. }
  1740.  
  1741. Boolean temp4=(Boolean)jCheckBox5.isSelected();
  1742. if(temp4==true)
  1743. {
  1744. cbox+=(String)jCheckBox5.getText();
  1745. }
  1746.  
  1747. Boolean temp5=(Boolean)jCheckBox6.isSelected();
  1748. if(temp5==true)
  1749. {
  1750. cbox+=(String)jCheckBox6.getText();
  1751. }
  1752.  
  1753. System.out.println(cbox);
  1754. try
  1755. {
  1756. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  1757. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  1758. System.out.println("connected successfully");
  1759.  
  1760. if(count<no)
  1761. {
  1762. PreparedStatement prp=con.prepareStatement("insert into newmobile_details values(?,?,?,?,?,?,?,?)");
  1763.  
  1764. prp.setString(1,mid);
  1765. prp.setString(2,model);
  1766. prp.setString(3,name);
  1767. prp.setInt(4,price);
  1768. prp.setString(5,pcolor);
  1769. prp.setString(6,imeino);
  1770. prp.setString(7,date1);
  1771. prp.setString(8,cbox);
  1772.  
  1773. prp.executeUpdate();
  1774.  
  1775. JOptionPane.showMessageDialog(null,"Mobiele Phone details saved successfully");
  1776.  
  1777.  
  1778. jTextField6.setText("");
  1779.  
  1780. jComboBox2.setSelectedItem("Red");
  1781. jComboBox3.setSelectedItem("01");
  1782. jComboBox4.setSelectedItem("jan");
  1783. jComboBox5.setSelectedItem("2000");
  1784.  
  1785. jCheckBox1.setSelected(false);
  1786. jCheckBox2.setSelected(false);
  1787. jCheckBox3.setSelected(false);
  1788. jCheckBox4.setSelected(false);
  1789. jCheckBox5.setSelected(false);
  1790. jCheckBox6.setSelected(false);
  1791.  
  1792. cbox="";
  1793.  
  1794. con.commit();
  1795. con.close();
  1796.  
  1797. count++;
  1798. //extra requirement code starts from here
  1799.  
  1800. index=jTextField5.getText().indexOf("-");
  1801. System.out.println(index);
  1802. inc1=Integer.parseInt(jTextField5.getText().substring(index+1));
  1803. inc1++;
  1804. System.out.print(inc1);
  1805. mid=jTextField2.getText();
  1806. mid+="-";
  1807. mid+=Integer.toString(inc1);
  1808. jTextField5.setText(mid);
  1809.  
  1810. //ends here
  1811.  
  1812. if(count<no)
  1813. {
  1814. JOptionPane.showMessageDialog(null,"Enter Next Mobile Phone Details");
  1815. }
  1816. if(count>=no)
  1817. {
  1818.  
  1819. count=0;
  1820.  
  1821. jComboBox1.setEnabled(true);
  1822. jTextField2.setEditable(true);
  1823. jTextField3.setEditable(true);
  1824. jTextField4.setEditable(true);
  1825. jButton1.setEnabled(true);
  1826.  
  1827. jTextField6.setEditable(false);
  1828. jComboBox2.setEnabled(false);
  1829. jCheckBox1.setSelected(false);
  1830. jCheckBox2.setSelected(false);
  1831. jCheckBox3.setSelected(false);
  1832. jCheckBox4.setSelected(false);
  1833. jCheckBox5.setSelected(false);
  1834. jCheckBox6.setSelected(false);
  1835.  
  1836. jComboBox1.setSelectedItem("Nokia");
  1837. jComboBox2.setSelectedItem("Red");
  1838. jComboBox3.setSelectedItem("1");
  1839. jComboBox4.setSelectedItem("jan");
  1840. jComboBox5.setSelectedItem("2000");
  1841.  
  1842. jComboBox2.setEnabled(false);
  1843. jComboBox3.setEnabled(false);
  1844. jComboBox4.setEnabled(false);
  1845. jComboBox5.setEnabled(false);
  1846. jButton4.setEnabled(false);
  1847. jButton3.setEnabled(false);
  1848.  
  1849. jTextField2.setText("");
  1850. jTextField3.setText("");
  1851. jTextField4.setText("");
  1852. jTextField5.setText("");
  1853. jTextField6.setText("");
  1854.  
  1855. jCheckBox1.setEnabled(false);
  1856. jCheckBox2.setEnabled(false);
  1857. jCheckBox3.setEnabled(false);
  1858. jCheckBox4.setEnabled(false);
  1859. jCheckBox5.setEnabled(false);
  1860. jCheckBox6.setEnabled(false);
  1861.  
  1862.  
  1863. }
  1864.  
  1865. }
  1866.  
  1867.  
  1868. }
  1869. catch(SQLException e)
  1870. {
  1871. JOptionPane.showMessageDialog(null,"INVALID DATE, please select correct date");
  1872. jComboBox3.setSelectedItem("01");
  1873. jComboBox4.setSelectedItem("jan");
  1874. jComboBox5.setSelectedItem("2000");
  1875. }
  1876. catch(Exception e)
  1877. {
  1878. JOptionPane.showMessageDialog(null,"The error is1:"+e);
  1879. System.out.println(e.getMessage());
  1880. }
  1881.  
  1882. }
  1883. }
  1884.  
  1885. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  1886. // TODO add your handling code here:
  1887.  
  1888. count=0;
  1889.  
  1890. jComboBox1.setSelectedItem("Nokia");
  1891. jComboBox1.setEnabled(true);
  1892. jTextField2.setEditable(true);
  1893. jTextField3.setEditable(true);
  1894. jTextField4.setEditable(true);
  1895. jButton1.setEnabled(true);
  1896.  
  1897. jTextField2.setText("");
  1898. jTextField3.setText("");
  1899. jTextField4.setText("");
  1900. jTextField5.setText("");
  1901. jTextField6.setText("");
  1902.  
  1903. jComboBox2.setSelectedItem("Red");
  1904. jComboBox3.setSelectedItem("01");
  1905. jComboBox4.setSelectedItem("jan");
  1906. jComboBox5.setSelectedItem("2000");
  1907.  
  1908. jCheckBox1.setSelected(false);
  1909. jCheckBox2.setSelected(false);
  1910. jCheckBox3.setSelected(false);
  1911. jCheckBox4.setSelected(false);
  1912. jCheckBox5.setSelected(false);
  1913. jCheckBox6.setSelected(false);
  1914.  
  1915. jTextField6.setEditable(false);
  1916. jComboBox2.setEnabled(false);
  1917. jComboBox3.setEnabled(false);
  1918. jComboBox4.setEnabled(false);
  1919. jComboBox5.setEnabled(false);
  1920. jCheckBox1.setEnabled(false);
  1921. jCheckBox2.setEnabled(false);
  1922. jCheckBox3.setEnabled(false);
  1923. jCheckBox4.setEnabled(false);
  1924. jCheckBox5.setEnabled(false);
  1925. jCheckBox6.setEnabled(false);
  1926. jButton4.setEnabled(false);
  1927. jButton3.setEnabled(false);
  1928.  
  1929. }
  1930.  
  1931. private void jTextField6FocusLost(java.awt.event.FocusEvent evt) {
  1932. // TODO add your handling code here:
  1933. if(jTextField6.getText().equals(""))
  1934. {
  1935. jLabel12.setText("Entry Is Must");
  1936. }
  1937. else
  1938. {
  1939. String jtf1=jTextField6.getText();
  1940. int fg=0;
  1941. for(int i=0;i<jtf1.length();i++)
  1942. {
  1943. char c=jtf1.charAt(i);
  1944. if(Character.isLetter(c))
  1945. {
  1946. fg=0;
  1947. break;
  1948. }
  1949. else
  1950. {
  1951. fg=1;
  1952.  
  1953. }
  1954. }
  1955. if(fg==0)
  1956. {
  1957. jLabel12.setText("Enter Numbers") ;
  1958. jTextField6.setText("");
  1959. }
  1960. else
  1961. {
  1962. jLabel12.setText("");
  1963. }
  1964.  
  1965. String imei=jTextField6.getText();
  1966. try
  1967. {
  1968. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  1969. Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  1970. Statement st=con.createStatement();
  1971. ResultSet res=st.executeQuery("select * from newmobile_details");
  1972. Boolean rec=res.next();
  1973. if(!rec)
  1974. {
  1975.  
  1976. }
  1977. else
  1978. {
  1979. do
  1980. {
  1981. String dimei=res.getString(6);
  1982. if(imei.equals(dimei))
  1983. {
  1984. JOptionPane.showMessageDialog(null,"The Mobile Phone is already in the database");
  1985. jTextField6.setText("");
  1986. jLabel12.setText("");
  1987. }
  1988. }while(res.next());
  1989. }
  1990. }
  1991. catch(Exception e)
  1992. {
  1993. JOptionPane.showMessageDialog(null,"The error is"+e);
  1994. }
  1995.  
  1996. }
  1997. }
  1998.  
  1999. private void jComboBox5FocusLost(java.awt.event.FocusEvent evt) {
  2000. // TODO add your handling code here:
  2001. String temp1=(String)jComboBox5.getSelectedItem();
  2002. int useryear=Integer.parseInt(temp1);
  2003. Date curyear=new Date();
  2004. String temp2=curyear.toString();
  2005. temp2=temp2.substring(24,28);
  2006. int cyear=Integer.parseInt(temp2);
  2007.  
  2008. if(useryear>cyear)
  2009. {
  2010. JOptionPane.showMessageDialog(null,"The Manufacture Date should be on (or) before this year");
  2011. jComboBox5.setSelectedItem("2000");
  2012. }
  2013.  
  2014. }
  2015.  
  2016. /**
  2017. * @param args the command line arguments
  2018. */
  2019. public static void main(String args[]) {
  2020. java.awt.EventQueue.invokeLater(new Runnable() {
  2021. public void run() {
  2022. new Addmobile1().setVisible(true);
  2023. }
  2024. });
  2025. }
  2026.  
  2027. // Variables declaration - do not modify
  2028. private javax.swing.JButton jButton1;
  2029. private javax.swing.JButton jButton3;
  2030. private javax.swing.JButton jButton4;
  2031. private javax.swing.JCheckBox jCheckBox1;
  2032. private javax.swing.JCheckBox jCheckBox2;
  2033. private javax.swing.JCheckBox jCheckBox3;
  2034. private javax.swing.JCheckBox jCheckBox4;
  2035. private javax.swing.JCheckBox jCheckBox5;
  2036. private javax.swing.JCheckBox jCheckBox6;
  2037. private javax.swing.JComboBox jComboBox1;
  2038. private javax.swing.JComboBox jComboBox2;
  2039. private javax.swing.JComboBox jComboBox3;
  2040. private javax.swing.JComboBox jComboBox4;
  2041. private javax.swing.JComboBox jComboBox5;
  2042. private javax.swing.JLabel jLabel1;
  2043. private javax.swing.JLabel jLabel10;
  2044. private javax.swing.JLabel jLabel11;
  2045. private javax.swing.JLabel jLabel12;
  2046. private javax.swing.JLabel jLabel13;
  2047. private javax.swing.JLabel jLabel18;
  2048. private javax.swing.JLabel jLabel19;
  2049. private javax.swing.JLabel jLabel2;
  2050. private javax.swing.JLabel jLabel20;
  2051. private javax.swing.JLabel jLabel21;
  2052. private javax.swing.JLabel jLabel22;
  2053. private javax.swing.JLabel jLabel3;
  2054. private javax.swing.JLabel jLabel4;
  2055. private javax.swing.JLabel jLabel5;
  2056. private javax.swing.JLabel jLabel6;
  2057. private javax.swing.JLabel jLabel7;
  2058. private javax.swing.JLabel jLabel8;
  2059. private javax.swing.JLabel jLabel9;
  2060. private javax.swing.JPanel jPanel1;
  2061. private javax.swing.JPanel jPanel2;
  2062. private javax.swing.JTextField jTextField2;
  2063. private javax.swing.JTextField jTextField3;
  2064. private javax.swing.JTextField jTextField4;
  2065. private javax.swing.JTextField jTextField5;
  2066. private javax.swing.JTextField jTextField6;
  2067. // End of variables declaration
  2068.  
  2069. }
  2070.  
  2071.  
  2072.  
  2073.  
  2074. Code for SearchMobile Page:
  2075.  
  2076.  
  2077. /*
  2078. * To change this template, choose Tools | Templates
  2079. * and open the template in the editor.
  2080. */
  2081.  
  2082. /*
  2083. * SearchMobile.java
  2084. *
  2085. * Created on Nov 7, 2010, 9:35:13 PM
  2086. */
  2087.  
  2088. package mobilestorenew;
  2089.  
  2090. import java.sql.*;
  2091. import javax.swing.*;
  2092.  
  2093. /**
  2094. *
  2095. * @author Ramesh
  2096. */
  2097. public class SearchMobile extends javax.swing.JFrame {
  2098.  
  2099. /** Creates new form SearchMobile */
  2100. int flag=0,rows=0,b=0,sprice,eprice;
  2101. String id,mname;
  2102. Object data[][];
  2103. JTable table;
  2104. JScrollPane jsp;
  2105. ResultSet rs;
  2106. public SearchMobile() {
  2107. initComponents();
  2108. setVisible(true);
  2109. setSize(1270,740);
  2110. setTitle("Search Mobile Phone");
  2111. ButtonGroup bg=new ButtonGroup();
  2112. bg.add(jRadioButton1);
  2113. bg.add(jRadioButton2);
  2114. bg.add(jRadioButton3);
  2115. jTextField2.setEditable(false);
  2116. jTextField3.setEditable(false);
  2117. jTextField4.setEditable(false);
  2118. jsp.setVisible(false);
  2119.  
  2120. }
  2121. public void tabledisp()
  2122. {
  2123. try
  2124. {
  2125.  
  2126. data=new Object[rows][8];
  2127. Object[] colheads={"Mobile Phone Id","Mobile Phone Model","Mobile Phone Name","Mobile Phone Price","phone color","IMEI no","Manufacture Date","Accessories"};
  2128.  
  2129.  
  2130. Class.forName("sun.jdbc.odbc.JdbcOdbc");
  2131. Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
  2132. Statement st=con.createStatement();
  2133.  
  2134. rs=st.executeQuery("select * from msearch");
  2135. for(int i=0;i<rows;i++)
  2136. {
  2137. rs.next();
  2138. for(int j=0;j<8;j++)
  2139. {
  2140. data [i][j]=rs.getString(j+1);
  2141. System.out.println(data[i][j]);
  2142. }
  2143. }
  2144. table=new JTable(data,colheads);
  2145.  
  2146. int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
  2147. int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
  2148. jsp=new JScrollPane(table,v,h);
  2149. jsp.setBounds(70,420,900,200);
  2150. jPanel2.add(jsp);
  2151. add(jsp);
  2152. System.out.println("hai we came here");
  2153. rows=0;
  2154. st.close();
  2155. con.commit();
  2156. con.close();
  2157.  
  2158. }
  2159. catch(Exception e)
  2160. {
  2161. JOptionPane.showMessageDialog(null,"here the error is:"+e);
  2162. }
  2163.  
  2164. }
  2165.  
  2166. /** This method is called from within the constructor to
  2167. * initialize the form.
  2168. * WARNING: Do NOT modify this code. The content of this method is
  2169. * always regenerated by the Form Editor.
  2170. */
  2171. @SuppressWarnings("unchecked")
  2172. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  2173. private void initComponents() {
  2174.  
  2175. jPanel2 = new javax.swing.JPanel();
  2176. jPanel1 = new javax.swing.JPanel();
  2177. jTextField1 = new javax.swing.JTextField();
  2178. jRadioButton1 = new javax.swing.JRadioButton();
  2179. jRadioButton2 = new javax.swing.JRadioButton();
  2180. jRadioButton3 = new javax.swing.JRadioButton();
  2181. jTextField2 = new javax.swing.JTextField();
  2182. jTextField3 = new javax.swing.JTextField();
  2183. jTextField4 = new javax.swing.JTextField();
  2184. jLabel2 = new javax.swing.JLabel();
  2185. jLabel3 = new javax.swing.JLabel();
  2186. jLabel4 = new javax.swing.JLabel();
  2187. jButton1 = new javax.swing.JButton();
  2188. jButton2 = new javax.swing.JButton();
  2189. jLabel1 = new javax.swing.JLabel();
  2190.  
  2191. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  2192. getContentPane().setLayout(null);
  2193.  
  2194. 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
  2195. jPanel2.setLayout(null);
  2196. getContentPane().add(jPanel2);
  2197. jPanel2.setBounds(50, 380, 940, 260);
  2198.  
  2199. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  2200. jPanel1.setLayout(null);
  2201.  
  2202. jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  2203. jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
  2204. public void focusGained(java.awt.event.FocusEvent evt) {
  2205. jTextField1FocusGained(evt);
  2206. }
  2207. });
  2208. jPanel1.add(jTextField1);
  2209. jTextField1.setBounds(290, 40, 150, 30);
  2210.  
  2211. jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  2212. jRadioButton1.setSelected(true);
  2213. jRadioButton1.setText(" Search By Mobile ID or IMEI No.");
  2214. jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
  2215. public void actionPerformed(java.awt.event.ActionEvent evt) {
  2216. jRadioButton1ActionPerformed(evt);
  2217. }
  2218. });
  2219. jPanel1.add(jRadioButton1);
  2220. jRadioButton1.setBounds(20, 40, 260, 25);
  2221.  
  2222. jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  2223. jRadioButton2.setText(" Search By Mobile Name");
  2224. jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
  2225. public void actionPerformed(java.awt.event.ActionEvent evt) {
  2226. jRadioButton2ActionPerformed(evt);
  2227. }
  2228. });
  2229. jPanel1.add(jRadioButton2);
  2230. jRadioButton2.setBounds(20, 100, 200, 25);
  2231.  
  2232. jRadioButton3.setFont(new java.awt.Font("Tahoma", 1, 14));
  2233. jRadioButton3.setText("Search By Mobile Price");
  2234. jRadioButton3.addActionListener(new java.awt.event.ActionListener() {
  2235. public void actionPerformed(java.awt.event.ActionEvent evt) {
  2236. jRadioButton3ActionPerformed(evt);
  2237. }
  2238. });
  2239. jPanel1.add(jRadioButton3);
  2240. jRadioButton3.setBounds(20, 160, 190, 25);
  2241.  
  2242. jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
  2243. jTextField2.addFocusListener(new java.awt.event.FocusAdapter() {
  2244. public void focusGained(java.awt.event.FocusEvent evt) {
  2245. jTextField2FocusGained(evt);
  2246. }
  2247. });
  2248. jPanel1.add(jTextField2);
  2249. jTextField2.setBounds(290, 100, 150, 30);
  2250.  
  2251. jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
  2252. jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
  2253. public void focusGained(java.awt.event.FocusEvent evt) {
  2254. jTextField3FocusGained(evt);
  2255. }
  2256. });
  2257. jPanel1.add(jTextField3);
  2258. jTextField3.setBounds(290, 160, 150, 30);
  2259.  
  2260. jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
  2261. jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
  2262. public void focusGained(java.awt.event.FocusEvent evt) {
  2263. jTextField4FocusGained(evt);
  2264. }
  2265. });
  2266. jPanel1.add(jTextField4);
  2267. jTextField4.setBounds(480, 160, 130, 30);
  2268.  
  2269. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12));
  2270. jLabel2.setText("to");
  2271. jPanel1.add(jLabel2);
  2272. jLabel2.setBounds(450, 160, 20, 30);
  2273. jPanel1.add(jLabel3);
  2274. jLabel3.setBounds(460, 40, 120, 30);
  2275. jPanel1.add(jLabel4);
  2276. jLabel4.setBounds(460, 100, 120, 30);
  2277.  
  2278. getContentPane().add(jPanel1);
  2279. jPanel1.setBounds(50, 100, 640, 250);
  2280.  
  2281. jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
  2282. jButton1.setText("Search");
  2283. jButton1.addActionListener(new java.awt.event.ActionListener() {
  2284. public void actionPerformed(java.awt.event.ActionEvent evt) {
  2285. jButton1ActionPerformed(evt);
  2286. }
  2287. });
  2288. getContentPane().add(jButton1);
  2289. jButton1.setBounds(720, 200, 120, 50);
  2290.  
  2291. jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
  2292. jButton2.setText("Cancel");
  2293. jButton2.addActionListener(new java.awt.event.ActionListener() {
  2294. public void actionPerformed(java.awt.event.ActionEvent evt) {
  2295. jButton2ActionPerformed(evt);
  2296. }
  2297. });
  2298. getContentPane().add(jButton2);
  2299. jButton2.setBounds(870, 200, 110, 50);
  2300.  
  2301. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
  2302. jLabel1.setText("Search Mobile Phone Details");
  2303. getContentPane().add(jLabel1);
  2304. jLabel1.setBounds(320, 20, 350, 50);
  2305.  
  2306. pack();
  2307. }// </editor-fold>
  2308.  
  2309. private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  2310. // TODO add your handling code here:
  2311.  
  2312. jTextField2.setEditable(true);
  2313. jTextField1.setEditable(false);
  2314. jTextField3.setEditable(false);
  2315. jTextField4.setEditable(false);
  2316. jTextField1.setText("");
  2317. jTextField3.setText("");
  2318. jTextField4.setText("");
  2319. flag=1;
  2320. jsp.setVisible(false);
  2321. }
  2322.  
  2323. private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  2324. // TODO add your handling code here:
  2325. jTextField3.setEditable(true);
  2326. jTextField4.setEditable(true);
  2327. jTextField1.setEditable(false);
  2328. jTextField2.setEditable(false);
  2329. jTextField4.setText("");
  2330. jTextField1.setText("");
  2331. jTextField2.setText("");
  2332. flag=2;
  2333. jsp.setVisible(false);
  2334. }
  2335.  
  2336. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  2337. // TODO add your handling code here:
  2338. if(flag==0)
  2339. {
  2340. if(jTextField1.getText().equals(""))
  2341. {
  2342. jLabel3.setText("Entry is Must");
  2343. }
  2344. else
  2345. {
  2346. id=jTextField1.getText();
  2347. try
  2348. {
  2349. Class.forName("sun.jdbc.odbc.JdbcOdbc");
  2350. Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
  2351. Statement st=con.createStatement();
  2352. st.executeUpdate("delete msearch");
  2353. ResultSet res=st.executeQuery("select * from newmobile_details");
  2354. Boolean rec=res.next();
  2355. if(!rec)
  2356. {
  2357. JOptionPane.showMessageDialog(null,"There are no records");
  2358.  
  2359. }
  2360. else
  2361. {
  2362. do
  2363. {
  2364. String mid=res.getString(1);
  2365. String model=res.getString(2);
  2366. String name=res.getString(3);
  2367. int price=res.getInt(4);
  2368. String pcolor=res.getString(5);
  2369. String imei=res.getString(6);
  2370. java.sql.Date date=res.getDate(7);
  2371. String access=res.getString(8);
  2372.  
  2373. if(id.equals(mid) || id.equals(imei))
  2374. {
  2375. System.out.println("iam inside");
  2376.  
  2377. PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
  2378. prp.setString(1,mid);
  2379. prp.setString(2,model);
  2380. prp.setString(3,name);
  2381. prp.setInt(4,price);
  2382. prp.setString(5,pcolor);
  2383. prp.setString(6,imei);
  2384. prp.setDate(7,date);
  2385. prp.setString(8,access);
  2386.  
  2387. prp.executeUpdate();
  2388.  
  2389. System.out.println("iam inside2");
  2390. rows++;
  2391.  
  2392. b=1;
  2393. jTextField1.setText("");
  2394. }
  2395.  
  2396.  
  2397. }while(res.next());
  2398. if(b==0)
  2399. {
  2400. JOptionPane.showMessageDialog(null,"The mobile phone does not exists ");
  2401. jTextField1.setText("");
  2402. }
  2403. }
  2404. con.commit();
  2405. con.close();
  2406. }
  2407. catch(Exception e)
  2408. {
  2409. JOptionPane.showMessageDialog(null,"The error is1:" +e);
  2410. }
  2411. tabledisp();
  2412. }
  2413. }
  2414.  
  2415. else if(flag==1)
  2416. {
  2417. if(jTextField2.getText().equals(""))
  2418. {
  2419. jLabel4.setText("Entry is Must");
  2420. }
  2421. else
  2422. {
  2423. mname=jTextField2.getText();
  2424. try
  2425. {
  2426. Class.forName("sun.jdbc.odbc.JdbcOdbc");
  2427. Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
  2428. Statement st=con.createStatement();
  2429. st.executeUpdate("delete msearch");
  2430. ResultSet res=st.executeQuery("select * from newmobile_details");
  2431. Boolean rec=res.next();
  2432. if(!rec)
  2433. {
  2434. JOptionPane.showMessageDialog(null,"There are no records");
  2435. }
  2436. else
  2437. {
  2438. do
  2439. {
  2440. String mid=res.getString(1);
  2441. String model=res.getString(2);
  2442. String name=res.getString(3);
  2443. int price=res.getInt(4);
  2444. String pcolor=res.getString(5);
  2445. String imei=res.getString(6);
  2446. java.sql.Date date=res.getDate(7);
  2447. String access=res.getString(8);
  2448.  
  2449. if(mname.equalsIgnoreCase(name))
  2450. {
  2451. PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
  2452. prp.setString(1,mid);
  2453. prp.setString(2,model);
  2454. prp.setString(3,name);
  2455. prp.setInt(4,price);
  2456. prp.setString(5,pcolor);
  2457. prp.setString(6,imei);
  2458. prp.setDate(7,date);
  2459. prp.setString(8,access);
  2460.  
  2461. prp.executeUpdate();
  2462.  
  2463. System.out.println("iam inside2");
  2464. rows++;
  2465.  
  2466. b=1;
  2467. jTextField2.setText("");
  2468. }
  2469.  
  2470.  
  2471. }while(res.next());
  2472. if(b==0)
  2473. {
  2474. JOptionPane.showMessageDialog(null,"The mobile does not exists ");
  2475. jTextField2.setText("");
  2476. }
  2477. }
  2478. con.commit();
  2479. con.close();
  2480. }
  2481. catch(Exception e)
  2482. {
  2483. JOptionPane.showMessageDialog(null,"The error is1:" +e);
  2484. }
  2485. tabledisp();
  2486.  
  2487. }
  2488. }
  2489. else if(flag==2)
  2490. {
  2491. if(jTextField3.getText().equals("") || jTextField4.getText().equals(""))
  2492. {
  2493. JOptionPane.showMessageDialog(null,"Fill the both fields");
  2494. }
  2495. else if(Integer.parseInt(jTextField3.getText())>Integer.parseInt(jTextField4.getText()))
  2496. {
  2497. JOptionPane.showMessageDialog(null,"First Enter small price and then Enter Big Price");
  2498. jTextField3.setText("");
  2499. jTextField4.setText("");
  2500. }
  2501. else
  2502. {
  2503. sprice=Integer.parseInt(jTextField3.getText());
  2504. eprice=Integer.parseInt(jTextField4.getText());
  2505. try
  2506. {
  2507. Class.forName("sun.jdbc.odbc.JdbcOdbc");
  2508. Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
  2509. Statement st=con.createStatement();
  2510. st.executeUpdate("delete msearch");
  2511. ResultSet res=st.executeQuery("select * from newmobile_details");
  2512. Boolean rec=res.next();
  2513. if(!rec)
  2514. {
  2515. JOptionPane.showMessageDialog(null,"There are no records");
  2516. }
  2517. else
  2518. {
  2519. do
  2520. {
  2521.  
  2522. String mid=res.getString(1);
  2523. String model=res.getString(2);
  2524. String name=res.getString(3);
  2525. int price=res.getInt(4);
  2526. String pcolor=res.getString(5);
  2527. String imei=res.getString(6);
  2528. java.sql.Date date=res.getDate(7);
  2529. String access=res.getString(8);
  2530.  
  2531. System.out.append("iam stuck here");
  2532. for(int i=sprice;i<=eprice;i++)
  2533. {
  2534. if(i==price)
  2535. {
  2536. PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
  2537. prp.setString(1,mid);
  2538. prp.setString(2,model);
  2539. prp.setString(3,name);
  2540. prp.setInt(4,price);
  2541. prp.setString(5,pcolor);
  2542. prp.setString(6,imei);
  2543. prp.setDate(7,date);
  2544. prp.setString(8,access);
  2545.  
  2546. prp.executeUpdate();
  2547.  
  2548. System.out.println("iam inside2");
  2549. rows++;
  2550. b=1;
  2551. jTextField3.setText("");
  2552. jTextField4.setText("");
  2553.  
  2554. }
  2555. }
  2556. }while(res.next());
  2557.  
  2558. if(b==0)
  2559. {
  2560. JOptionPane.showMessageDialog(null,"There are no mobiles between the price you entered");
  2561. jTextField3.setText("");
  2562. jTextField4.setText("");
  2563. }
  2564.  
  2565. }
  2566. }
  2567. catch(Exception e)
  2568. {
  2569. JOptionPane.showMessageDialog(null,"The error is:"+e);
  2570. }
  2571. tabledisp();
  2572.  
  2573. }
  2574. }
  2575.  
  2576.  
  2577. }
  2578.  
  2579. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  2580. // TODO add your handling code here:
  2581. jTextField1.setText("");
  2582. jTextField2.setText("");
  2583. jTextField3.setText("");
  2584. jTextField4.setText("");
  2585. }
  2586.  
  2587. private void jTextField1FocusGained(java.awt.event.FocusEvent evt) {
  2588. // TODO add your handling code here:
  2589. jsp.setVisible(false);
  2590. b=0;
  2591. }
  2592.  
  2593. private void jTextField2FocusGained(java.awt.event.FocusEvent evt) {
  2594. // TODO add your handling code here:
  2595. jsp.setVisible(false);
  2596. b=0;
  2597. }
  2598.  
  2599. private void jTextField3FocusGained(java.awt.event.FocusEvent evt) {
  2600. // TODO add your handling code here:
  2601. jsp.setVisible(false);
  2602. b=0;
  2603. }
  2604.  
  2605. private void jTextField4FocusGained(java.awt.event.FocusEvent evt) {
  2606. // TODO add your handling code here:
  2607. jsp.setVisible(false);
  2608. b=0;
  2609. }
  2610.  
  2611. private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  2612. // TODO add your handling code here:
  2613. flag=0;
  2614. jTextField1.setEditable(true);
  2615. jTextField2.setEditable(false);
  2616. jTextField3.setEditable(false);
  2617. jTextField4.setEditable(false);
  2618. jTextField2.setText("");
  2619. jTextField2.setText("");
  2620. jTextField2.setText("");
  2621.  
  2622. }
  2623.  
  2624. /**
  2625. * @param args the command line arguments
  2626. */
  2627. public static void main(String args[]) {
  2628. java.awt.EventQueue.invokeLater(new Runnable() {
  2629. public void run() {
  2630. new SearchMobile().setVisible(true);
  2631. }
  2632. });
  2633. }
  2634.  
  2635. // Variables declaration - do not modify
  2636. private javax.swing.JButton jButton1;
  2637. private javax.swing.JButton jButton2;
  2638. private javax.swing.JLabel jLabel1;
  2639. private javax.swing.JLabel jLabel2;
  2640. private javax.swing.JLabel jLabel3;
  2641. private javax.swing.JLabel jLabel4;
  2642. private javax.swing.JPanel jPanel1;
  2643. private javax.swing.JPanel jPanel2;
  2644. private javax.swing.JRadioButton jRadioButton1;
  2645. private javax.swing.JRadioButton jRadioButton2;
  2646. private javax.swing.JRadioButton jRadioButton3;
  2647. private javax.swing.JTextField jTextField1;
  2648. private javax.swing.JTextField jTextField2;
  2649. private javax.swing.JTextField jTextField3;
  2650. private javax.swing.JTextField jTextField4;
  2651. // End of variables declaration
  2652.  
  2653. }
  2654.  
  2655.  
  2656.  
  2657.  
  2658.  
  2659. Code for UpdateMobile Page:
  2660.  
  2661.  
  2662. /*
  2663. * To change this template, choose Tools | Templates
  2664. * and open the template in the editor.
  2665. */
  2666.  
  2667. /*
  2668. * MobileUpdate.java
  2669. *
  2670. * Created on Sep 12, 2010, 11:49:21 PM
  2671. */
  2672.  
  2673. package mobilestorenew;
  2674.  
  2675.  
  2676. import java.sql.Connection;
  2677. import java.sql.DriverManager;
  2678. import java.sql.PreparedStatement;
  2679. import java.sql.ResultSet;
  2680. import java.sql.Statement;
  2681. import javax.swing.JOptionPane;
  2682.  
  2683. /**
  2684. *
  2685. * @author Ramesh
  2686. */
  2687. public class MobileUpdate extends javax.swing.JFrame {
  2688.  
  2689. /** Creates new form MobileUpdate */
  2690. String model,name,cbox;
  2691.  
  2692. int price,i1;
  2693.  
  2694. String id,s1,s2,s3,s4,s5,pcolor,date;
  2695. int a=0;
  2696. int b=0;
  2697. String imeino;
  2698. String dt,year,ddate,mc,month;
  2699.  
  2700.  
  2701. public MobileUpdate() {
  2702. initComponents();
  2703. setVisible(true);
  2704. setSize(1270,740);
  2705. setTitle("Update Mobile Details");
  2706. disflds();
  2707. JOptionPane.showMessageDialog(null,"Enter Phone Id (or) IMEI No. in the First Text Field");
  2708.  
  2709. }
  2710. public void disflds()
  2711. {
  2712. jComboBox1.setEnabled(false);
  2713. jComboBox2.setEnabled(false);
  2714. jComboBox3.setEnabled(false);
  2715. jComboBox4.setEnabled(false);
  2716. jComboBox5.setEnabled(false);
  2717.  
  2718. jTextField2.setEditable(false);
  2719. jTextField3.setEditable(false);
  2720. jTextField4.setEditable(false);
  2721.  
  2722. jCheckBox1.setEnabled(false);
  2723. jCheckBox2.setEnabled(false);
  2724. jCheckBox3.setEnabled(false);
  2725. jCheckBox4.setEnabled(false);
  2726. jCheckBox5.setEnabled(false);
  2727. jCheckBox6.setEnabled(false);
  2728.  
  2729. jButton1.setEnabled(false);
  2730. }
  2731. public void clrcombocheck()
  2732. {
  2733. jComboBox1.setSelectedItem("Nokia");
  2734. jComboBox2.setSelectedItem("Red");
  2735. jComboBox3.setSelectedItem("01");
  2736. jComboBox4.setSelectedItem("jan");
  2737. jComboBox5.setSelectedItem("2000");
  2738.  
  2739. jCheckBox1.setSelected(false);
  2740. jCheckBox2.setSelected(false);
  2741. jCheckBox3.setSelected(false);
  2742. jCheckBox4.setSelected(false);
  2743. jCheckBox5.setSelected(false);
  2744. jCheckBox6.setSelected(false);
  2745. }
  2746.  
  2747. /** This method is called from within the constructor to
  2748. * initialize the form.
  2749. * WARNING: Do NOT modify this code. The content of this method is
  2750. * always regenerated by the Form Editor.
  2751. */
  2752. @SuppressWarnings("unchecked")
  2753. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  2754. private void initComponents() {
  2755.  
  2756. jLabel1 = new javax.swing.JLabel();
  2757. jPanel1 = new javax.swing.JPanel();
  2758. jLabel2 = new javax.swing.JLabel();
  2759. jTextField1 = new javax.swing.JTextField();
  2760. jLabel4 = new javax.swing.JLabel();
  2761. jLabel5 = new javax.swing.JLabel();
  2762. jTextField2 = new javax.swing.JTextField();
  2763. jLabel6 = new javax.swing.JLabel();
  2764. jTextField3 = new javax.swing.JTextField();
  2765. jLabel3 = new javax.swing.JLabel();
  2766. jTextField4 = new javax.swing.JTextField();
  2767. jLabel7 = new javax.swing.JLabel();
  2768. jComboBox2 = new javax.swing.JComboBox();
  2769. jLabel8 = new javax.swing.JLabel();
  2770. jLabel9 = new javax.swing.JLabel();
  2771. jCheckBox1 = new javax.swing.JCheckBox();
  2772. jCheckBox2 = new javax.swing.JCheckBox();
  2773. jCheckBox3 = new javax.swing.JCheckBox();
  2774. jCheckBox4 = new javax.swing.JCheckBox();
  2775. jCheckBox5 = new javax.swing.JCheckBox();
  2776. jCheckBox6 = new javax.swing.JCheckBox();
  2777. jLabel10 = new javax.swing.JLabel();
  2778. jComboBox1 = new javax.swing.JComboBox();
  2779. jComboBox3 = new javax.swing.JComboBox();
  2780. jComboBox4 = new javax.swing.JComboBox();
  2781. jComboBox5 = new javax.swing.JComboBox();
  2782. jLabel11 = new javax.swing.JLabel();
  2783. jLabel12 = new javax.swing.JLabel();
  2784. jLabel13 = new javax.swing.JLabel();
  2785. jPanel2 = new javax.swing.JPanel();
  2786. jButton2 = new javax.swing.JButton();
  2787. jButton1 = new javax.swing.JButton();
  2788.  
  2789. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  2790. setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
  2791. getContentPane().setLayout(null);
  2792.  
  2793. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
  2794. jLabel1.setText("Update Mobile Phone Details");
  2795. getContentPane().add(jLabel1);
  2796. jLabel1.setBounds(370, 20, 343, 50);
  2797.  
  2798. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Update Mobile Details"));
  2799. jPanel1.setLayout(null);
  2800.  
  2801. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
  2802. jLabel2.setText("Mobile Phone Price");
  2803. jPanel1.add(jLabel2);
  2804. jLabel2.setBounds(100, 210, 160, 30);
  2805.  
  2806. jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
  2807. jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
  2808. public void focusLost(java.awt.event.FocusEvent evt) {
  2809. jTextField1FocusLost(evt);
  2810. }
  2811. });
  2812. jPanel1.add(jTextField1);
  2813. jTextField1.setBounds(290, 40, 140, 30);
  2814.  
  2815. jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
  2816. jLabel4.setText("Mobile Phone Model");
  2817. jPanel1.add(jLabel4);
  2818. jLabel4.setBounds(100, 100, 150, 30);
  2819.  
  2820. jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
  2821. jLabel5.setText("Enter Phone Id (or) IMEI No.");
  2822. jPanel1.add(jLabel5);
  2823. jLabel5.setBounds(60, 40, 210, 30);
  2824.  
  2825. jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
  2826. jTextField2.addKeyListener(new java.awt.event.KeyAdapter() {
  2827. public void keyTyped(java.awt.event.KeyEvent evt) {
  2828. jTextField2KeyTyped(evt);
  2829. }
  2830. });
  2831. jPanel1.add(jTextField2);
  2832. jTextField2.setBounds(290, 160, 140, 30);
  2833.  
  2834. jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
  2835. jLabel6.setText("Mobile Phone Name");
  2836. jPanel1.add(jLabel6);
  2837. jLabel6.setBounds(100, 150, 160, 30);
  2838.  
  2839. jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
  2840. jTextField3.addKeyListener(new java.awt.event.KeyAdapter() {
  2841. public void keyTyped(java.awt.event.KeyEvent evt) {
  2842. jTextField3KeyTyped(evt);
  2843. }
  2844. });
  2845. jPanel1.add(jTextField3);
  2846. jTextField3.setBounds(290, 220, 140, 30);
  2847.  
  2848. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
  2849. jLabel3.setText("Mobile Phone Color");
  2850. jPanel1.add(jLabel3);
  2851. jLabel3.setBounds(100, 280, 140, 30);
  2852.  
  2853. jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
  2854. jTextField4.addKeyListener(new java.awt.event.KeyAdapter() {
  2855. public void keyTyped(java.awt.event.KeyEvent evt) {
  2856. jTextField4KeyTyped(evt);
  2857. }
  2858. });
  2859. jPanel1.add(jTextField4);
  2860. jTextField4.setBounds(290, 340, 140, 30);
  2861.  
  2862. jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
  2863. jLabel7.setText("IMEI No");
  2864. jPanel1.add(jLabel7);
  2865. jLabel7.setBounds(100, 340, 100, 30);
  2866.  
  2867. jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  2868. jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Red", "Green", "Blue", "Black", "White", "Cyan", "Yellow", "Orange", "Purple", "Pink", "Voilet", "Magenta" }));
  2869. jComboBox2.addItemListener(new java.awt.event.ItemListener() {
  2870. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2871. jComboBox2ItemStateChanged(evt);
  2872. }
  2873. });
  2874. jPanel1.add(jComboBox2);
  2875. jComboBox2.setBounds(290, 280, 140, 30);
  2876.  
  2877. jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14));
  2878. jLabel8.setText("Date of Manufacture");
  2879. jPanel1.add(jLabel8);
  2880. jLabel8.setBounds(100, 390, 150, 30);
  2881.  
  2882. jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
  2883. jLabel9.setText("Additional Accessories");
  2884. jPanel1.add(jLabel9);
  2885. jLabel9.setBounds(100, 440, 170, 20);
  2886.  
  2887. jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11));
  2888. jCheckBox1.setText("Charger ");
  2889. jCheckBox1.addItemListener(new java.awt.event.ItemListener() {
  2890. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2891. jCheckBox1ItemStateChanged(evt);
  2892. }
  2893. });
  2894. jPanel1.add(jCheckBox1);
  2895. jCheckBox1.setBounds(290, 440, 80, 23);
  2896.  
  2897. jCheckBox2.setFont(new java.awt.Font("Tahoma", 1, 11));
  2898. jCheckBox2.setText("HeadSet ");
  2899. jCheckBox2.addItemListener(new java.awt.event.ItemListener() {
  2900. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2901. jCheckBox2ItemStateChanged(evt);
  2902. }
  2903. });
  2904. jPanel1.add(jCheckBox2);
  2905. jCheckBox2.setBounds(400, 440, 80, 23);
  2906.  
  2907. jCheckBox3.setFont(new java.awt.Font("Tahoma", 1, 11));
  2908. jCheckBox3.setText("DataCable ");
  2909. jCheckBox3.addItemListener(new java.awt.event.ItemListener() {
  2910. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2911. jCheckBox3ItemStateChanged(evt);
  2912. }
  2913. });
  2914. jPanel1.add(jCheckBox3);
  2915. jCheckBox3.setBounds(290, 470, 100, 23);
  2916.  
  2917. jCheckBox4.setFont(new java.awt.Font("Tahoma", 1, 11));
  2918. jCheckBox4.setText("Battery ");
  2919. jCheckBox4.addItemListener(new java.awt.event.ItemListener() {
  2920. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2921. jCheckBox4ItemStateChanged(evt);
  2922. }
  2923. });
  2924. jPanel1.add(jCheckBox4);
  2925. jCheckBox4.setBounds(400, 470, 80, 23);
  2926.  
  2927. jCheckBox5.setFont(new java.awt.Font("Tahoma", 1, 11));
  2928. jCheckBox5.setText("MemoryCard ");
  2929. jCheckBox5.addItemListener(new java.awt.event.ItemListener() {
  2930. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2931. jCheckBox5ItemStateChanged(evt);
  2932. }
  2933. });
  2934. jPanel1.add(jCheckBox5);
  2935. jCheckBox5.setBounds(290, 500, 101, 23);
  2936.  
  2937. jCheckBox6.setFont(new java.awt.Font("Tahoma", 1, 11));
  2938. jCheckBox6.setText("CD ");
  2939. jCheckBox6.addItemListener(new java.awt.event.ItemListener() {
  2940. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2941. jCheckBox6ItemStateChanged(evt);
  2942. }
  2943. });
  2944. jPanel1.add(jCheckBox6);
  2945. jCheckBox6.setBounds(400, 500, 50, 23);
  2946. jPanel1.add(jLabel10);
  2947. jLabel10.setBounds(440, 40, 120, 30);
  2948.  
  2949. jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
  2950. jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
  2951. jComboBox1.addItemListener(new java.awt.event.ItemListener() {
  2952. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2953. jComboBox1ItemStateChanged(evt);
  2954. }
  2955. });
  2956. jPanel1.add(jComboBox1);
  2957. jComboBox1.setBounds(290, 100, 140, 30);
  2958.  
  2959. jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
  2960. 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" }));
  2961. jComboBox3.addItemListener(new java.awt.event.ItemListener() {
  2962. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2963. jComboBox3ItemStateChanged(evt);
  2964. }
  2965. });
  2966. jPanel1.add(jComboBox3);
  2967. jComboBox3.setBounds(290, 390, 50, 30);
  2968.  
  2969. jComboBox4.setFont(new java.awt.Font("Tahoma", 1, 12));
  2970. jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
  2971. jComboBox4.addItemListener(new java.awt.event.ItemListener() {
  2972. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2973. jComboBox4ItemStateChanged(evt);
  2974. }
  2975. });
  2976. jPanel1.add(jComboBox4);
  2977. jComboBox4.setBounds(380, 390, 56, 30);
  2978.  
  2979. jComboBox5.setFont(new java.awt.Font("Tahoma", 1, 12));
  2980. 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" }));
  2981. jComboBox5.addItemListener(new java.awt.event.ItemListener() {
  2982. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  2983. jComboBox5ItemStateChanged(evt);
  2984. }
  2985. });
  2986. jPanel1.add(jComboBox5);
  2987. jComboBox5.setBounds(490, 390, 60, 30);
  2988.  
  2989. jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
  2990. jLabel11.setText("(DD)");
  2991. jPanel1.add(jLabel11);
  2992. jLabel11.setBounds(340, 390, 28, 30);
  2993.  
  2994. jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
  2995. jLabel12.setText("(MM)");
  2996. jPanel1.add(jLabel12);
  2997. jLabel12.setBounds(440, 390, 40, 30);
  2998.  
  2999. jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
  3000. jLabel13.setText("(YY)");
  3001. jPanel1.add(jLabel13);
  3002. jLabel13.setBounds(550, 390, 24, 30);
  3003.  
  3004. getContentPane().add(jPanel1);
  3005. jPanel1.setBounds(210, 70, 590, 530);
  3006.  
  3007. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  3008. jPanel2.setLayout(null);
  3009.  
  3010. jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
  3011. jButton2.setText("Cancel");
  3012. jButton2.addActionListener(new java.awt.event.ActionListener() {
  3013. public void actionPerformed(java.awt.event.ActionEvent evt) {
  3014. jButton2ActionPerformed(evt);
  3015. }
  3016. });
  3017. jPanel2.add(jButton2);
  3018. jButton2.setBounds(280, 20, 110, 40);
  3019.  
  3020. jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
  3021. jButton1.setText("Update Mobile Details");
  3022. jButton1.setEnabled(false);
  3023. jButton1.addActionListener(new java.awt.event.ActionListener() {
  3024. public void actionPerformed(java.awt.event.ActionEvent evt) {
  3025. jButton1ActionPerformed(evt);
  3026. }
  3027. });
  3028. jPanel2.add(jButton1);
  3029. jButton1.setBounds(30, 20, 240, 40);
  3030.  
  3031. getContentPane().add(jPanel2);
  3032. jPanel2.setBounds(320, 610, 410, 80);
  3033.  
  3034. pack();
  3035. }// </editor-fold>
  3036.  
  3037. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  3038. // TODO add your handling code here:
  3039. id=jTextField1.getText();
  3040.  
  3041. model=(String)jComboBox1.getSelectedItem();
  3042. name=jTextField2.getText();
  3043. price=Integer.parseInt(jTextField3.getText());
  3044. pcolor=(String)jComboBox2.getSelectedItem();
  3045. imeino=jTextField4.getText();
  3046.  
  3047. date=(String)jComboBox3.getSelectedItem();
  3048. date+="-";
  3049. date+=(String)jComboBox4.getSelectedItem();
  3050. date+="-";
  3051. date+=(String)jComboBox5.getSelectedItem();
  3052.  
  3053. cbox=null;
  3054.  
  3055. Boolean temp=(Boolean)jCheckBox1.isSelected();
  3056. if(temp==true)
  3057. {
  3058. cbox+=(String)jCheckBox1.getText();
  3059. }
  3060.  
  3061. Boolean temp1=(Boolean)jCheckBox2.isSelected();
  3062. if(temp1==true)
  3063. {
  3064. cbox+=(String)jCheckBox2.getText();
  3065. }
  3066.  
  3067. Boolean temp2=(Boolean)jCheckBox3.isSelected();
  3068. if(temp2==true)
  3069. {
  3070. cbox+=(String)jCheckBox3.getText();
  3071. }
  3072.  
  3073. Boolean temp3=(Boolean)jCheckBox4.isSelected();
  3074. if(temp3==true)
  3075. {
  3076. cbox+=(String)jCheckBox4.getText();
  3077. }
  3078.  
  3079. Boolean temp4=(Boolean)jCheckBox5.isSelected();
  3080. if(temp4==true)
  3081. {
  3082. cbox+=(String)jCheckBox5.getText();
  3083. }
  3084.  
  3085. Boolean temp5=(Boolean)jCheckBox6.isSelected();
  3086. if(temp5==true)
  3087. {
  3088. cbox+=(String)jCheckBox6.getText();
  3089. }
  3090.  
  3091. cbox=cbox.substring(4);
  3092. try
  3093. {
  3094.  
  3095. Connection con;
  3096. Statement st;
  3097.  
  3098. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3099. con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  3100. st=con.createStatement();
  3101.  
  3102. PreparedStatement prp=con.prepareStatement("update newmobile_details set mobile_model=?,mobile_name=?,mobile_price=?,pcolor=?,imeino=?,mdate=?,accessories=? where phone_id=?");
  3103. prp.setString(1,model);
  3104. prp.setString(2,name);
  3105. prp.setInt(3,price);
  3106. prp.setString(4,pcolor);
  3107. prp.setString(5,imeino);
  3108. prp.setString(6,date);
  3109. prp.setString(7,cbox);
  3110. prp.setString(8,id);
  3111. prp.executeUpdate();
  3112. JOptionPane.showMessageDialog(null,"Mobile Phone details updated successfully");
  3113. jTextField1.setText("");
  3114. jTextField2.setText("");
  3115. jTextField2.setText("");
  3116. jTextField3.setText("");
  3117. jTextField4.setText("");
  3118.  
  3119. cbox=null;
  3120.  
  3121. jTextField1.setEditable(true);
  3122.  
  3123. disflds();
  3124.  
  3125. clrcombocheck();
  3126. jButton1.setEnabled(false);
  3127. con.commit();
  3128. con.close();
  3129. }
  3130. catch(Exception e)
  3131. {
  3132. System.out.println(e.getMessage());
  3133. JOptionPane.showMessageDialog(null,"error is:"+e);
  3134. }
  3135. }
  3136.  
  3137. private void jTextField1FocusLost(java.awt.event.FocusEvent evt) {
  3138. // TODO add your handling code here:
  3139. if(jTextField1.getText().equals(""))
  3140. {
  3141. jLabel10.setText("Entry is Must");
  3142. }
  3143. else
  3144. {
  3145. id=jTextField1.getText();
  3146. try
  3147. {
  3148. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3149. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  3150. Statement st=con.createStatement();
  3151. ResultSet res=st.executeQuery("select * from newmobile_details");
  3152. Boolean rec=res.next();
  3153. if(!rec)
  3154. {
  3155. JOptionPane.showMessageDialog(null,"There are no mobiles in the database");
  3156. jTextField1.setText("");
  3157. }
  3158. else
  3159. {
  3160. do
  3161. {
  3162. s1=res.getString(1);
  3163. s2=res.getString(2);
  3164. s3=res.getString(3);
  3165. i1=res.getInt(4);
  3166. s4=res.getString(5);
  3167. s5=res.getString(6);
  3168.  
  3169.  
  3170. if(id.equalsIgnoreCase(s1) || id.equalsIgnoreCase(s5))
  3171. {
  3172.  
  3173. jTextField1.setEditable(false);
  3174. jTextField2.setEditable(true);
  3175. jTextField2.setEditable(true);
  3176. jTextField3.setEditable(true);
  3177. jTextField4.setEditable(true);
  3178.  
  3179. jComboBox1.setEnabled(true);
  3180. jComboBox2.setEnabled(true);
  3181. jComboBox3.setEnabled(true);
  3182. jComboBox4.setEnabled(true);
  3183. jComboBox5.setEnabled(true);
  3184.  
  3185. jCheckBox1.setEnabled(true);
  3186. jCheckBox2.setEnabled(true);
  3187. jCheckBox3.setEnabled(true);
  3188. jCheckBox4.setEnabled(true);
  3189. jCheckBox5.setEnabled(true);
  3190. jCheckBox6.setEnabled(true);
  3191. jComboBox2.setEnabled(true);
  3192.  
  3193. jLabel5.setText(" Mobile Phone Id");
  3194.  
  3195. jLabel10.setText("");
  3196.  
  3197. b=1;
  3198.  
  3199. jTextField1.setText(s1);
  3200. jComboBox1.setSelectedItem(s2);
  3201. jTextField2.setText(s3);
  3202. jTextField3.setText(Integer.toString(i1));
  3203. jComboBox2.setSelectedItem(s4);
  3204. jTextField4.setText(s5);
  3205.  
  3206. dt=res.getDate(7).toString();
  3207. System.out.println(dt);
  3208.  
  3209. year=dt.substring(0,4);
  3210. System.out.println(year);
  3211.  
  3212. month=dt.substring(5,7);
  3213. System.out.println(month);
  3214.  
  3215. ddate=dt.substring(8,10);
  3216. System.out.println(ddate);
  3217. if(month.equals("01"))
  3218. {
  3219. mc="jan";
  3220. }
  3221. else if(month.equals("02"))
  3222. {
  3223. mc="feb";
  3224. }
  3225. else if(month.equals("03"))
  3226. {
  3227. mc="mar";
  3228. }
  3229. else if(month.equals("04"))
  3230. {
  3231. mc="apr";
  3232. }
  3233. else if(month.equals("05"))
  3234. {
  3235. mc="may";
  3236. }
  3237. else if(month.equals("06"))
  3238. {
  3239. mc="jun";
  3240. }
  3241. else if(month.equals("07"))
  3242. {
  3243. mc="jul";
  3244. }
  3245. else if(month.equals("08"))
  3246. {
  3247. mc="aug";
  3248. }
  3249. else if(month.equals("09"))
  3250. {
  3251. mc="sep";
  3252. }
  3253. else if(month.equals("10"))
  3254. {
  3255. mc="oct";
  3256. }
  3257. else if(month.equals("11"))
  3258. {
  3259. mc="nov";
  3260. }
  3261. else if(month.equals("12"))
  3262. {
  3263. mc="dec";
  3264. }
  3265.  
  3266. jComboBox3.setSelectedItem(ddate);
  3267. jComboBox4.setSelectedItem(mc);
  3268. jComboBox5.setSelectedItem(year);
  3269.  
  3270. cbox=res.getString(8);
  3271. Boolean cb1=cbox.contains("Charger");
  3272. if(cb1==true)
  3273. {
  3274. jCheckBox1.setSelected(true);
  3275. }
  3276. else
  3277. {
  3278. }
  3279.  
  3280. Boolean cb2=cbox.contains("HeadSet");
  3281. if(cb2==true)
  3282. {
  3283. jCheckBox2.setSelected(true);
  3284. }
  3285. else
  3286. {
  3287. }
  3288.  
  3289. Boolean cb3=cbox.contains("DataCable");
  3290. if(cb3==true)
  3291. {
  3292. jCheckBox3.setSelected(true);
  3293. }
  3294. else
  3295. {
  3296. }
  3297.  
  3298. Boolean cb4=cbox.contains("Battery");
  3299. if(cb4==true)
  3300. {
  3301. jCheckBox4.setSelected(true);
  3302. }
  3303. else
  3304. {
  3305. }
  3306.  
  3307. Boolean cb5=cbox.contains("MemoryCard");
  3308. if(cb5==true)
  3309. {
  3310. jCheckBox5.setSelected(true);
  3311. }
  3312. else
  3313. {
  3314. }
  3315.  
  3316. Boolean cb6=cbox.contains("CD");
  3317. if(cb6==true)
  3318. {
  3319. jCheckBox6.setSelected(true);
  3320. }
  3321. else
  3322. {
  3323. }
  3324.  
  3325. jButton1.setEnabled(false);
  3326. }
  3327. }while(res.next());
  3328.  
  3329. if(b!=1)
  3330. {
  3331. JOptionPane.showMessageDialog(null,"The mobile details does not exists in the database");
  3332. jTextField1.setText("");
  3333. jLabel10.setText("");
  3334. }
  3335. }
  3336. con.commit();
  3337. con.close();
  3338. }
  3339. catch(Exception e)
  3340. {
  3341. JOptionPane.showMessageDialog(null,"There are no additional accessories for this mobile");
  3342. jButton1.setEnabled(false);
  3343. }
  3344. }
  3345. }
  3346.  
  3347. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  3348. // TODO add your handling code here:
  3349. jTextField1.setText("");
  3350. jTextField2.setText("");
  3351. jTextField3.setText("");
  3352. jTextField4.setText("");
  3353.  
  3354. jTextField1.setEditable(true);
  3355.  
  3356. disflds();
  3357.  
  3358. clrcombocheck();
  3359.  
  3360. b=0;
  3361. }
  3362.  
  3363. private void jTextField4KeyTyped(java.awt.event.KeyEvent evt) {
  3364. // TODO add your handling code here:
  3365. jButton1.setEnabled(true);
  3366. }
  3367.  
  3368. private void jTextField3KeyTyped(java.awt.event.KeyEvent evt) {
  3369. // TODO add your handling code here:
  3370. jButton1.setEnabled(true);
  3371. }
  3372.  
  3373. private void jComboBox2ItemStateChanged(java.awt.event.ItemEvent evt) {
  3374. // TODO add your handling code here:
  3375. jButton1.setEnabled(true);
  3376. }
  3377.  
  3378. private void jComboBox3ItemStateChanged(java.awt.event.ItemEvent evt) {
  3379. // TODO add your handling code here:
  3380. jButton1.setEnabled(true);
  3381. }
  3382.  
  3383. private void jComboBox4ItemStateChanged(java.awt.event.ItemEvent evt) {
  3384. // TODO add your handling code here:
  3385. jButton1.setEnabled(true);
  3386. }
  3387.  
  3388. private void jComboBox5ItemStateChanged(java.awt.event.ItemEvent evt) {
  3389. // TODO add your handling code here:
  3390. jButton1.setEnabled(true);
  3391. }
  3392.  
  3393. private void jCheckBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
  3394. // TODO add your handling code here:
  3395. jButton1.setEnabled(true);
  3396. }
  3397.  
  3398. private void jCheckBox2ItemStateChanged(java.awt.event.ItemEvent evt) {
  3399. // TODO add your handling code here:
  3400. jButton1.setEnabled(true);
  3401. }
  3402.  
  3403. private void jCheckBox3ItemStateChanged(java.awt.event.ItemEvent evt) {
  3404. // TODO add your handling code here:
  3405. jButton1.setEnabled(true);
  3406. }
  3407.  
  3408. private void jCheckBox4ItemStateChanged(java.awt.event.ItemEvent evt) {
  3409. // TODO add your handling code here:
  3410. jButton1.setEnabled(true);
  3411. }
  3412.  
  3413. private void jCheckBox5ItemStateChanged(java.awt.event.ItemEvent evt) {
  3414. // TODO add your handling code here:
  3415. jButton1.setEnabled(true);
  3416. }
  3417.  
  3418. private void jCheckBox6ItemStateChanged(java.awt.event.ItemEvent evt) {
  3419. // TODO add your handling code here:
  3420. jButton1.setEnabled(true);
  3421. }
  3422.  
  3423. private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
  3424. // TODO add your handling code here:
  3425. jButton1.setEnabled(true);
  3426. }
  3427.  
  3428. private void jTextField2KeyTyped(java.awt.event.KeyEvent evt) {
  3429. // TODO add your handling code here:
  3430. jButton1.setEnabled(true);
  3431. }
  3432.  
  3433. /**
  3434. * @param args the command line arguments
  3435. */
  3436. public static void main(String args[]) {
  3437. java.awt.EventQueue.invokeLater(new Runnable() {
  3438. public void run() {
  3439. new MobileUpdate().setVisible(true);
  3440. }
  3441. });
  3442. }
  3443.  
  3444. // Variables declaration - do not modify
  3445. private javax.swing.JButton jButton1;
  3446. private javax.swing.JButton jButton2;
  3447. private javax.swing.JCheckBox jCheckBox1;
  3448. private javax.swing.JCheckBox jCheckBox2;
  3449. private javax.swing.JCheckBox jCheckBox3;
  3450. private javax.swing.JCheckBox jCheckBox4;
  3451. private javax.swing.JCheckBox jCheckBox5;
  3452. private javax.swing.JCheckBox jCheckBox6;
  3453. private javax.swing.JComboBox jComboBox1;
  3454. private javax.swing.JComboBox jComboBox2;
  3455. private javax.swing.JComboBox jComboBox3;
  3456. private javax.swing.JComboBox jComboBox4;
  3457. private javax.swing.JComboBox jComboBox5;
  3458. private javax.swing.JLabel jLabel1;
  3459. private javax.swing.JLabel jLabel10;
  3460. private javax.swing.JLabel jLabel11;
  3461. private javax.swing.JLabel jLabel12;
  3462. private javax.swing.JLabel jLabel13;
  3463. private javax.swing.JLabel jLabel2;
  3464. private javax.swing.JLabel jLabel3;
  3465. private javax.swing.JLabel jLabel4;
  3466. private javax.swing.JLabel jLabel5;
  3467. private javax.swing.JLabel jLabel6;
  3468. private javax.swing.JLabel jLabel7;
  3469. private javax.swing.JLabel jLabel8;
  3470. private javax.swing.JLabel jLabel9;
  3471. private javax.swing.JPanel jPanel1;
  3472. private javax.swing.JPanel jPanel2;
  3473. private javax.swing.JTextField jTextField1;
  3474. private javax.swing.JTextField jTextField2;
  3475. private javax.swing.JTextField jTextField3;
  3476. private javax.swing.JTextField jTextField4;
  3477. // End of variables declaration
  3478. }
  3479.  
  3480.  
  3481.  
  3482. Code for BillGeneration Page:
  3483.  
  3484.  
  3485. /*
  3486. * To change this template, choose Tools | Templates
  3487. * and open the template in the editor.
  3488. */
  3489.  
  3490. /*
  3491. * BillGeneration.java
  3492. *
  3493. * Created on Nov 1, 2010, 6:56:04 PM
  3494. */
  3495.  
  3496. package mobilestorenew;
  3497.  
  3498. import java.sql.*;
  3499. import javax.swing.*;
  3500. import java.util.Date;
  3501.  
  3502. /**
  3503. *
  3504. * @author Ramesh
  3505. */
  3506. public class BillGeneration extends javax.swing.JFrame {
  3507.  
  3508. /** Creates new form BillGeneration */
  3509.  
  3510. Date dat;
  3511. int bid,reply;
  3512. int a=0,b=0,c=0,d=0,x=0;
  3513. String dt,year,month,day,date;
  3514. int price=0,amtpaid,balamt,dpaidamt,dbalamt,drefid,dage;
  3515. String text="",cid="r",dcid,dcname,year1,month1,day1,mc1,dt1,dgender;
  3516. String cname,mob_purchased,ddno,dstreet,dcity,dstate,dphno;
  3517. int flag=0;
  3518. String s1,s2,s3,s4,nameappend="";int addprice;
  3519.  
  3520. public BillGeneration() {
  3521. initComponents();
  3522. setVisible(true);
  3523. setSize(1270,740);
  3524. setTitle("Generate Bill");
  3525. jTextField1.setEditable(false);
  3526. jTextField2.setEditable(false);
  3527. jTextField6.setEditable(false);
  3528. idincrement();
  3529. jTextField6.setText(Integer.toString(price));
  3530.  
  3531. }
  3532. public void idincrement()
  3533. {
  3534. try
  3535. {
  3536.  
  3537. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3538. Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  3539. Statement st=co.createStatement();
  3540. ResultSet res=st.executeQuery("select * from newbill");
  3541. while(res.next())
  3542. {
  3543. bid=res.getInt(1);
  3544. }
  3545.  
  3546. st.close();
  3547. co.close();
  3548. }
  3549. catch(Exception e)
  3550. {
  3551. JOptionPane.showMessageDialog(null,"the error is"+e);
  3552. System.out.println(e.getMessage());
  3553. }
  3554. bid=bid+1;
  3555. jTextField1.setText(Integer.toString(bid));
  3556.  
  3557. dat=new Date();
  3558. dt=dat.toString();
  3559. System.out.println(dt);
  3560. day=dt.substring(8,10);
  3561. month=dt.substring(4,7);
  3562. year=dt.substring(24,28);
  3563.  
  3564.  
  3565. date=day;
  3566. date+="-";
  3567. date+=month;
  3568. date+="-";
  3569. date+=year;
  3570.  
  3571. jTextField2.setText(date);
  3572.  
  3573. }
  3574.  
  3575.  
  3576. /** This method is called from within the constructor to
  3577. * initialize the form.
  3578. * WARNING: Do NOT modify this code. The content of this method is
  3579. * always regenerated by the Form Editor.
  3580. */
  3581. @SuppressWarnings("unchecked")
  3582. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  3583. private void initComponents() {
  3584.  
  3585. jLabel1 = new javax.swing.JLabel();
  3586. jLabel2 = new javax.swing.JLabel();
  3587. jLabel3 = new javax.swing.JLabel();
  3588. jLabel4 = new javax.swing.JLabel();
  3589. jLabel8 = new javax.swing.JLabel();
  3590. jLabel9 = new javax.swing.JLabel();
  3591. jLabel10 = new javax.swing.JLabel();
  3592. jButton1 = new javax.swing.JButton();
  3593. jTextField1 = new javax.swing.JTextField();
  3594. jTextField2 = new javax.swing.JTextField();
  3595. jTextField3 = new javax.swing.JTextField();
  3596. jTextField6 = new javax.swing.JTextField();
  3597. jTextField7 = new javax.swing.JTextField();
  3598. jScrollPane1 = new javax.swing.JScrollPane();
  3599. jTextArea1 = new javax.swing.JTextArea();
  3600. jButton2 = new javax.swing.JButton();
  3601. jLabel11 = new javax.swing.JLabel();
  3602. jPanel1 = new javax.swing.JPanel();
  3603. jLabel5 = new javax.swing.JLabel();
  3604. jLabel6 = new javax.swing.JLabel();
  3605. jLabel7 = new javax.swing.JLabel();
  3606. jTextField4 = new javax.swing.JTextField();
  3607. jComboBox1 = new javax.swing.JComboBox();
  3608. jLabel12 = new javax.swing.JLabel();
  3609. jLabel13 = new javax.swing.JLabel();
  3610. jTextField5 = new javax.swing.JTextField();
  3611. jLabel15 = new javax.swing.JLabel();
  3612. jLabel14 = new javax.swing.JLabel();
  3613.  
  3614. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  3615. getContentPane().setLayout(null);
  3616.  
  3617. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
  3618. jLabel1.setText("Generate Bill");
  3619. getContentPane().add(jLabel1);
  3620. jLabel1.setBounds(390, 20, 220, 40);
  3621.  
  3622. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
  3623. jLabel2.setText("Bill Id");
  3624. getContentPane().add(jLabel2);
  3625. jLabel2.setBounds(280, 80, 120, 30);
  3626.  
  3627. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
  3628. jLabel3.setText("Bill Date");
  3629. getContentPane().add(jLabel3);
  3630. jLabel3.setBounds(280, 130, 130, 30);
  3631.  
  3632. jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
  3633. jLabel4.setText("Customer Name");
  3634. getContentPane().add(jLabel4);
  3635. jLabel4.setBounds(280, 180, 130, 30);
  3636.  
  3637. jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14));
  3638. jLabel8.setText("Added Mobiles");
  3639. getContentPane().add(jLabel8);
  3640. jLabel8.setBounds(280, 400, 110, 30);
  3641.  
  3642. jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
  3643. jLabel9.setText("Price");
  3644. getContentPane().add(jLabel9);
  3645. jLabel9.setBounds(280, 530, 110, 30);
  3646.  
  3647. jLabel10.setFont(new java.awt.Font("Tahoma", 1, 14));
  3648. jLabel10.setText("Amount Paid");
  3649. getContentPane().add(jLabel10);
  3650. jLabel10.setBounds(280, 580, 110, 30);
  3651.  
  3652. jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
  3653. jButton1.setText("Generate Bill");
  3654. jButton1.addActionListener(new java.awt.event.ActionListener() {
  3655. public void actionPerformed(java.awt.event.ActionEvent evt) {
  3656. jButton1ActionPerformed(evt);
  3657. }
  3658. });
  3659. getContentPane().add(jButton1);
  3660. jButton1.setBounds(380, 640, 160, 40);
  3661.  
  3662. jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
  3663. getContentPane().add(jTextField1);
  3664. jTextField1.setBounds(460, 80, 130, 30);
  3665.  
  3666. jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
  3667. getContentPane().add(jTextField2);
  3668. jTextField2.setBounds(460, 130, 130, 30);
  3669.  
  3670. jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
  3671. jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
  3672. public void focusLost(java.awt.event.FocusEvent evt) {
  3673. jTextField3FocusLost(evt);
  3674. }
  3675. });
  3676. getContentPane().add(jTextField3);
  3677. jTextField3.setBounds(460, 180, 130, 30);
  3678.  
  3679. jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
  3680. getContentPane().add(jTextField6);
  3681. jTextField6.setBounds(460, 530, 130, 30);
  3682.  
  3683. jTextField7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  3684. jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
  3685. public void focusLost(java.awt.event.FocusEvent evt) {
  3686. jTextField7FocusLost(evt);
  3687. }
  3688. });
  3689. getContentPane().add(jTextField7);
  3690. jTextField7.setBounds(460, 580, 130, 30);
  3691.  
  3692. jTextArea1.setColumns(20);
  3693. jTextArea1.setEditable(false);
  3694. jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11));
  3695. jTextArea1.setRows(5);
  3696. jTextArea1.setTabSize(9);
  3697. jScrollPane1.setViewportView(jTextArea1);
  3698.  
  3699. getContentPane().add(jScrollPane1);
  3700. jScrollPane1.setBounds(460, 400, 410, 110);
  3701.  
  3702. jButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  3703. jButton2.setText("ADD");
  3704. jButton2.addActionListener(new java.awt.event.ActionListener() {
  3705. public void actionPerformed(java.awt.event.ActionEvent evt) {
  3706. jButton2ActionPerformed(evt);
  3707. }
  3708. });
  3709. getContentPane().add(jButton2);
  3710. jButton2.setBounds(740, 280, 100, 40);
  3711. getContentPane().add(jLabel11);
  3712. jLabel11.setBounds(580, 180, 120, 30);
  3713.  
  3714. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  3715. jPanel1.setLayout(null);
  3716.  
  3717. jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
  3718. jLabel5.setText("Select Phone Model");
  3719. jPanel1.add(jLabel5);
  3720. jLabel5.setBounds(40, 20, 150, 30);
  3721.  
  3722. jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
  3723. jLabel6.setText("Enter Phone Name");
  3724. jPanel1.add(jLabel6);
  3725. jLabel6.setBounds(40, 70, 180, 30);
  3726.  
  3727. jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
  3728. jLabel7.setText("Enter IMEI Number");
  3729. jPanel1.add(jLabel7);
  3730. jLabel7.setBounds(40, 120, 180, 30);
  3731.  
  3732. jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
  3733. jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
  3734. public void focusGained(java.awt.event.FocusEvent evt) {
  3735. jTextField4FocusGained(evt);
  3736. }
  3737. public void focusLost(java.awt.event.FocusEvent evt) {
  3738. jTextField4FocusLost(evt);
  3739. }
  3740. });
  3741. jPanel1.add(jTextField4);
  3742. jTextField4.setBounds(220, 70, 130, 30);
  3743.  
  3744. jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
  3745. jComboBox1.addItemListener(new java.awt.event.ItemListener() {
  3746. public void itemStateChanged(java.awt.event.ItemEvent evt) {
  3747. jComboBox1ItemStateChanged(evt);
  3748. }
  3749. });
  3750. jPanel1.add(jComboBox1);
  3751. jComboBox1.setBounds(220, 20, 130, 30);
  3752.  
  3753. jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
  3754. jPanel1.add(jLabel12);
  3755. jLabel12.setBounds(360, 70, 100, 30);
  3756.  
  3757. jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
  3758. jPanel1.add(jLabel13);
  3759. jLabel13.setBounds(360, 120, 100, 30);
  3760.  
  3761. jTextField5.setFont(new java.awt.Font("Tahoma", 1, 12));
  3762. jTextField5.addFocusListener(new java.awt.event.FocusAdapter() {
  3763. public void focusGained(java.awt.event.FocusEvent evt) {
  3764. jTextField5FocusGained(evt);
  3765. }
  3766. public void focusLost(java.awt.event.FocusEvent evt) {
  3767. jTextField5FocusLost(evt);
  3768. }
  3769. });
  3770. jPanel1.add(jTextField5);
  3771. jTextField5.setBounds(220, 120, 130, 30);
  3772.  
  3773. getContentPane().add(jPanel1);
  3774. jPanel1.setBounds(240, 220, 480, 170);
  3775.  
  3776. jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12));
  3777. getContentPane().add(jLabel15);
  3778. jLabel15.setBounds(600, 580, 100, 30);
  3779.  
  3780. jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12));
  3781. getContentPane().add(jLabel14);
  3782. jLabel14.setBounds(600, 530, 200, 30);
  3783.  
  3784. pack();
  3785. }// </editor-fold>
  3786.  
  3787. private void jTextField3FocusLost(java.awt.event.FocusEvent evt) {
  3788. // TODO add your handling code here:
  3789. if(jTextField3.getText().equals(""))
  3790. {
  3791. jLabel11.setText("Entry Is Must") ;
  3792. jTextField3.setText("");
  3793. }
  3794.  
  3795. else
  3796. {
  3797. jLabel11.setText("") ;
  3798. }
  3799. }
  3800.  
  3801. private void jTextField4FocusLost(java.awt.event.FocusEvent evt) {
  3802. // TODO add your handling code here:
  3803. if(jTextField4.getText().equals(""))
  3804. {
  3805. jLabel12.setText("Entry Is Must");
  3806. }
  3807. else
  3808. {
  3809. jLabel12.setText("");
  3810.  
  3811. String name=jTextField4.getText();
  3812. String model=(String) jComboBox1.getSelectedItem();
  3813. try
  3814. {
  3815. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3816. Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
  3817. Statement st=con.createStatement();
  3818.  
  3819. ResultSet res=st.executeQuery("select * from newmobile_details");
  3820. Boolean rec=res.next();
  3821. if(!rec)
  3822. {
  3823. JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
  3824.  
  3825. }
  3826. else
  3827. {
  3828. do
  3829. {
  3830. String s11=res.getString(2);
  3831. String s22=res.getString(3);
  3832.  
  3833. if(model.equalsIgnoreCase(s11) && name.equalsIgnoreCase(s22))
  3834. {
  3835. b=1;
  3836. }
  3837.  
  3838. }while(res.next());
  3839. if(b==0)
  3840. {
  3841. JOptionPane.showMessageDialog(null,"The mobile phone is not available, Please purchase another one");
  3842. jTextField4.setText("");
  3843. jLabel12.setText("Entry Is Must");
  3844.  
  3845.  
  3846. }
  3847. }
  3848. con.commit();
  3849. con.close();
  3850. }
  3851. catch(Exception e)
  3852. {
  3853. JOptionPane.showMessageDialog(null,"The error is: "+e);
  3854. }
  3855. }
  3856. }
  3857.  
  3858. private void jTextField4FocusGained(java.awt.event.FocusEvent evt) {
  3859. // TODO add your handling code here:
  3860. b=0;
  3861.  
  3862. }
  3863.  
  3864. private void jTextField5FocusLost(java.awt.event.FocusEvent evt) {
  3865. // TODO add your handling code here:
  3866. if(jTextField5.getText().equals(""))
  3867. {
  3868. jLabel13.setText("Entry is Must");
  3869. }
  3870. else
  3871. {
  3872. String jtf1=jTextField5.getText();
  3873. int fg=0;
  3874. for(int i=0;i<jtf1.length();i++)
  3875. {
  3876. char c1=jtf1.charAt(i);
  3877. if(Character.isLetter(c1))
  3878. {
  3879. fg=0;
  3880. break;
  3881. }
  3882. else
  3883. {
  3884. fg=1;
  3885.  
  3886. }
  3887. }
  3888. if(fg==0)
  3889. {
  3890. jLabel13.setText("Enter Numbers") ;
  3891. jTextField5.setText("");
  3892. }
  3893. else
  3894. {
  3895. jLabel13.setText("") ;
  3896. }
  3897. try
  3898. {
  3899. String imeino=jTextField5.getText();
  3900. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3901. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  3902. Statement st=con.createStatement();
  3903.  
  3904. ResultSet res=st.executeQuery("select * from newmobile_details");
  3905. Boolean rec=res.next();
  3906. if(!rec)
  3907. {
  3908. JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
  3909.  
  3910. }
  3911. else
  3912. {
  3913. do
  3914. {
  3915. String s12=res.getString(6);
  3916. if(imeino.equals(s12))
  3917. {
  3918. c=1;
  3919. }
  3920. }while(res.next());
  3921. if(c==0)
  3922. {
  3923. JOptionPane.showMessageDialog(null,"The mobile phone is not available, Please purchase another one");
  3924. jTextField5.setText("");
  3925. jLabel13.setText("Entry is Must");
  3926. }
  3927. }
  3928. con.commit();
  3929. con.close();
  3930.  
  3931. }
  3932. catch(Exception e)
  3933. {
  3934. JOptionPane.showMessageDialog(null,"The error is:"+e);
  3935. }
  3936. }
  3937. }
  3938.  
  3939. private void jTextField5FocusGained(java.awt.event.FocusEvent evt) {
  3940. // TODO add your handling code here:
  3941. c=0;
  3942. }
  3943.  
  3944. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  3945. // TODO add your handling code here:
  3946. x=0;
  3947. if(jTextField4.getText().equals("") || jTextField5.getText().equals(""))
  3948. {
  3949. JOptionPane.showMessageDialog(null,"Enter All appropriate fields");
  3950. if(jTextField4.getText().equals(""))
  3951. {
  3952. jLabel12.setText("Fill this Field");
  3953. }
  3954. else
  3955. {
  3956. jLabel12.setText("");
  3957. }
  3958. if(jTextField5.getText().equals(""))
  3959. {
  3960. jLabel13.setText("Fill this Field");
  3961. }
  3962. else
  3963. {
  3964. jLabel13.setText("");
  3965. }
  3966. }
  3967. else
  3968. {
  3969. try
  3970. {
  3971.  
  3972. String model=(String)jComboBox1.getSelectedItem();
  3973. String name=jTextField4.getText();
  3974. String imeino=jTextField5.getText();
  3975.  
  3976. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3977. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  3978. Statement st=con.createStatement();
  3979.  
  3980. ResultSet res=st.executeQuery("select * from newmobile_details");
  3981. Boolean rec=res.next();
  3982. if(!rec)
  3983. {
  3984. JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
  3985. jTextField4.setText("");
  3986. jTextField5.setText("");
  3987.  
  3988. }
  3989. else
  3990. {
  3991. do
  3992. {
  3993. s1=res.getString(2);
  3994. s2=res.getString(3);
  3995. addprice=res.getInt(4);
  3996. s3=res.getString(5);
  3997. s4=res.getString(6);
  3998.  
  3999. if(s1.equalsIgnoreCase(model) && s2.equalsIgnoreCase(name) && s4.equalsIgnoreCase(imeino))
  4000. {
  4001.  
  4002. int reply2=JOptionPane.showConfirmDialog(null,"Are Sure You Want to Purchase");
  4003. if(reply2==JOptionPane.YES_OPTION)
  4004. {
  4005.  
  4006. price+=addprice;
  4007. jTextField6.setText(Integer.toString(price));
  4008.  
  4009. text+="\n"+s2+"\t"+addprice+"\t"+s3+"\t"+s4;
  4010. System.out.println(text);
  4011.  
  4012. jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
  4013. "--------------------------------------------------------------------------"+text);
  4014.  
  4015. PreparedStatement prp=con.prepareStatement("delete newmobile_details where imeino="+s4);
  4016. prp.executeUpdate();
  4017. nameappend+=s2+", ";
  4018. System.out.println(nameappend);
  4019. jComboBox1.setSelectedItem("nokia");
  4020. jTextField4.setText("");
  4021. jTextField5.setText("");
  4022. x=1;
  4023.  
  4024. }
  4025. if(reply2==JOptionPane.NO_OPTION)
  4026. {
  4027. jComboBox1.setSelectedItem("nokia");
  4028. jTextField4.setText("");
  4029. jTextField5.setText("");
  4030. }
  4031. if(reply2==JOptionPane.CANCEL_OPTION)
  4032. {
  4033. jComboBox1.setSelectedItem("nokia");
  4034. jTextField4.setText("");
  4035. jTextField5.setText("");
  4036. }
  4037.  
  4038. }
  4039. }while(res.next());
  4040. if(x==0)
  4041. {
  4042. JOptionPane.showMessageDialog(null,"The Model and Name and IMEI No does not match, please enter correctly");
  4043. }
  4044. }
  4045. }
  4046. catch(Exception e)
  4047. {
  4048. JOptionPane.showMessageDialog(null,"The error is:"+e);
  4049. }
  4050. }
  4051.  
  4052. }
  4053.  
  4054. private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
  4055. // TODO add your handling code here:
  4056. jTextField4.setText("");
  4057. jTextField5.setText("");
  4058. }
  4059.  
  4060. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  4061. // TODO add your handling code here:
  4062. if(flag==0)
  4063. {
  4064. if(jTextField3.getText().equals("") || jTextField6.getText().equals("0") || jTextField7.getText().equals(""))
  4065. {
  4066. JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
  4067. if(jTextField3.getText().equals(""))
  4068. {
  4069. jLabel11.setText("Fill this Field");
  4070. }
  4071. else
  4072. {
  4073. jLabel11.setText("");
  4074. }
  4075. if(jTextField6.getText().equals("0"))
  4076. {
  4077. jLabel14.setText("Please Add Mobile Phone");
  4078. }
  4079. else
  4080. {
  4081. jLabel14.setText("");
  4082. }
  4083. if(jTextField7.getText().equals(""))
  4084. {
  4085. jLabel15.setText("Fill this field");
  4086. }
  4087. else
  4088. {
  4089. jLabel15.setText("");
  4090. }
  4091. }
  4092. else
  4093. {
  4094. cname=jTextField3.getText();
  4095. mob_purchased=text;
  4096. amtpaid=Integer.parseInt(jTextField7.getText());
  4097. balamt=price-amtpaid;
  4098. try
  4099. {
  4100. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  4101. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  4102.  
  4103. PreparedStatement prp=con.prepareStatement("insert into newbill values(?,?,?,?,?,?,?)");
  4104. prp.setInt(1,bid);
  4105. prp.setString(2,date);
  4106. prp.setString(3,cname);
  4107. prp.setInt(4,price);
  4108. prp.setInt(5,amtpaid);
  4109. prp.setString(6,mob_purchased);
  4110. prp.setString(7,nameappend);
  4111.  
  4112. prp.executeUpdate();
  4113. JOptionPane.showMessageDialog(null,"Bill details successfully saved");
  4114.  
  4115. PrintPreview pp=new PrintPreview();
  4116. pp.jLabel3.setText(Integer.toString(bid));
  4117. pp.jLabel5.setText(date);
  4118. pp.jLabel7.setText(cname);
  4119. pp.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
  4120. "--------------------------------------------------------------------------"+text);
  4121. pp.jLabel11.setText(Integer.toString(price));
  4122. pp.jLabel13.setText(Integer.toString(amtpaid));
  4123. pp.text=text;
  4124. pp.flag=0;
  4125.  
  4126. price=0;
  4127. bid++;
  4128. text="-";
  4129. jTextField1.setText(Integer.toString(bid));
  4130. jTextField3.setText("");
  4131. jTextArea1.setText("");
  4132. jTextField6.setText("0");
  4133. jTextField7.setText("");
  4134.  
  4135. con.commit();
  4136. con.close();
  4137. }
  4138. catch(Exception e)
  4139. {
  4140. JOptionPane.showMessageDialog(null,"The error is:"+e);
  4141. }
  4142.  
  4143. }
  4144. }
  4145. if(flag==1)
  4146. {
  4147. dispose();
  4148. }
  4149. }
  4150.  
  4151. private void jTextField7FocusLost(java.awt.event.FocusEvent evt) {
  4152. // TODO add your handling code here:
  4153. int amtcheck=Integer.parseInt(jTextField7.getText());
  4154. if(amtcheck>price)
  4155. {
  4156. jTextField7.setText("");
  4157. JOptionPane.showMessageDialog(null,"The Bill Amount is:"+price+", So pay less than or equal to the amount");
  4158. }
  4159. }
  4160.  
  4161. /**
  4162. * @param args the command line arguments
  4163. */
  4164. public static void main(String args[]) {
  4165. java.awt.EventQueue.invokeLater(new Runnable() {
  4166. public void run() {
  4167. new BillGeneration().setVisible(true);
  4168. }
  4169. });
  4170. }
  4171.  
  4172. // Variables declaration - do not modify
  4173. public javax.swing.JButton jButton1;
  4174. public javax.swing.JButton jButton2;
  4175. private javax.swing.JComboBox jComboBox1;
  4176. public javax.swing.JLabel jLabel1;
  4177. public javax.swing.JLabel jLabel10;
  4178. private javax.swing.JLabel jLabel11;
  4179. private javax.swing.JLabel jLabel12;
  4180. private javax.swing.JLabel jLabel13;
  4181. private javax.swing.JLabel jLabel14;
  4182. private javax.swing.JLabel jLabel15;
  4183. public javax.swing.JLabel jLabel2;
  4184. public javax.swing.JLabel jLabel3;
  4185. public javax.swing.JLabel jLabel4;
  4186. private javax.swing.JLabel jLabel5;
  4187. private javax.swing.JLabel jLabel6;
  4188. private javax.swing.JLabel jLabel7;
  4189. public javax.swing.JLabel jLabel8;
  4190. public javax.swing.JLabel jLabel9;
  4191. public javax.swing.JPanel jPanel1;
  4192. public javax.swing.JScrollPane jScrollPane1;
  4193. public javax.swing.JTextArea jTextArea1;
  4194. public javax.swing.JTextField jTextField1;
  4195. public javax.swing.JTextField jTextField2;
  4196. public javax.swing.JTextField jTextField3;
  4197. private javax.swing.JTextField jTextField4;
  4198. private javax.swing.JTextField jTextField5;
  4199. public javax.swing.JTextField jTextField6;
  4200. public javax.swing.JTextField jTextField7;
  4201. // End of variables declaration
  4202.  
  4203. }
  4204.  
  4205.  
  4206.  
  4207. Code for PrintPreview Page:
  4208.  
  4209.  
  4210. /*
  4211. * To change this template, choose Tools | Templates
  4212. * and open the template in the editor.
  4213. */
  4214.  
  4215. /*
  4216. * PrintPreview.java
  4217. *
  4218. * Created on Nov 14, 2010, 10:52:13 PM
  4219. */
  4220.  
  4221. package mobilestorenew;
  4222.  
  4223. import java.awt.Font;
  4224. import java.awt.Graphics;
  4225. import java.awt.Graphics2D;
  4226. import java.awt.print.*;
  4227. import java.sql.*;
  4228. import javax.swing.*;
  4229.  
  4230. /**
  4231. *
  4232. * @author Ramesh
  4233. */
  4234. public class PrintPreview extends javax.swing.JFrame implements Printable{
  4235.  
  4236. /** Creates new form PrintPreview */
  4237. int a=0,d=0,flag=0;
  4238. int price,amtpaid,reply1=1,reply,balamt,dpaidamt,dbalamt,drefid,dage;
  4239. String refid="c",custrefid,cname,date,text,cid="r",dcid;
  4240. String dcname,year1,month1,day1,mc1,dt1,dgender,ddno,dstreet,dcity,dstate,dphno;
  4241.  
  4242. public PrintPreview() {
  4243. initComponents();
  4244. setVisible(true);
  4245. setTitle("Print Preview");
  4246. setSize(700,650);
  4247. setResizable(false);
  4248. setLocation(180,60);
  4249. }
  4250.  
  4251. /** This method is called from within the constructor to
  4252. * initialize the form.
  4253. * WARNING: Do NOT modify this code. The content of this method is
  4254. * always regenerated by the Form Editor.
  4255. */
  4256. @SuppressWarnings("unchecked")
  4257. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  4258. private void initComponents() {
  4259.  
  4260. jLabel1 = new javax.swing.JLabel();
  4261. jPanel1 = new javax.swing.JPanel();
  4262. jLabel2 = new javax.swing.JLabel();
  4263. jLabel3 = new javax.swing.JLabel();
  4264. jLabel4 = new javax.swing.JLabel();
  4265. jLabel5 = new javax.swing.JLabel();
  4266. jLabel6 = new javax.swing.JLabel();
  4267. jLabel7 = new javax.swing.JLabel();
  4268. jLabel8 = new javax.swing.JLabel();
  4269. jLabel9 = new javax.swing.JLabel();
  4270. jScrollPane1 = new javax.swing.JScrollPane();
  4271. jTextArea1 = new javax.swing.JTextArea();
  4272. jLabel10 = new javax.swing.JLabel();
  4273. jLabel11 = new javax.swing.JLabel();
  4274. jLabel12 = new javax.swing.JLabel();
  4275. jLabel13 = new javax.swing.JLabel();
  4276. jButton1 = new javax.swing.JButton();
  4277.  
  4278. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  4279. getContentPane().setLayout(null);
  4280.  
  4281. jLabel1.setFont(new java.awt.Font("Monotype Corsiva", 1, 36));
  4282. jLabel1.setText("Raj Mobile Store");
  4283. getContentPane().add(jLabel1);
  4284. jLabel1.setBounds(230, 30, 270, 40);
  4285.  
  4286. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  4287. jPanel1.setLayout(null);
  4288.  
  4289. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4290. jLabel2.setText("Bill Id :");
  4291. jPanel1.add(jLabel2);
  4292. jLabel2.setBounds(40, 40, 50, 30);
  4293.  
  4294. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4295. jLabel3.setText("Bill Id");
  4296. jPanel1.add(jLabel3);
  4297. jLabel3.setBounds(100, 40, 90, 30);
  4298.  
  4299. jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
  4300. jLabel4.setText("Bill Date :");
  4301. jPanel1.add(jLabel4);
  4302. jLabel4.setBounds(410, 40, 70, 30);
  4303.  
  4304. jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4305. jLabel5.setText("Bill Date");
  4306. jPanel1.add(jLabel5);
  4307. jLabel5.setBounds(480, 40, 110, 30);
  4308.  
  4309. jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
  4310. jLabel6.setText("Customer Name :");
  4311. jPanel1.add(jLabel6);
  4312. jLabel6.setBounds(40, 90, 130, 30);
  4313.  
  4314. jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4315. jLabel7.setText("Customer Name");
  4316. jPanel1.add(jLabel7);
  4317. jLabel7.setBounds(170, 90, 270, 30);
  4318.  
  4319. jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4320. jLabel8.setText("---------------------------------------------------------------------------------------------------------");
  4321. jPanel1.add(jLabel8);
  4322. jLabel8.setBounds(0, 130, 630, 17);
  4323.  
  4324. jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
  4325. jLabel9.setText("Mobiles Purchased :");
  4326. jPanel1.add(jLabel9);
  4327. jLabel9.setBounds(40, 170, 140, 30);
  4328.  
  4329. jTextArea1.setColumns(20);
  4330. jTextArea1.setEditable(false);
  4331. jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  4332. jTextArea1.setRows(5);
  4333. jTextArea1.setTabSize(9);
  4334. jScrollPane1.setViewportView(jTextArea1);
  4335.  
  4336. jPanel1.add(jScrollPane1);
  4337. jScrollPane1.setBounds(190, 170, 410, 110);
  4338.  
  4339. jLabel10.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4340. jLabel10.setText("Total Price :");
  4341. jPanel1.add(jLabel10);
  4342. jLabel10.setBounds(40, 310, 100, 30);
  4343.  
  4344. jLabel11.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4345. jLabel11.setText("Total Price");
  4346. jPanel1.add(jLabel11);
  4347. jLabel11.setBounds(190, 310, 100, 30);
  4348.  
  4349. jLabel12.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  4350. jLabel12.setText("Amount Paid :");
  4351. jPanel1.add(jLabel12);
  4352. jLabel12.setBounds(40, 350, 150, 30);
  4353.  
  4354. jLabel13.setFont(new java.awt.Font("Tahoma", 1, 14));
  4355. jLabel13.setText("Amount Paid ");
  4356. jPanel1.add(jLabel13);
  4357. jLabel13.setBounds(190, 350, 100, 30);
  4358.  
  4359. jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
  4360. jButton1.setText("Print");
  4361. jButton1.addActionListener(new java.awt.event.ActionListener() {
  4362. public void actionPerformed(java.awt.event.ActionEvent evt) {
  4363. jButton1ActionPerformed(evt);
  4364. }
  4365. });
  4366. jPanel1.add(jButton1);
  4367. jButton1.setBounds(280, 410, 100, 40);
  4368.  
  4369. getContentPane().add(jPanel1);
  4370. jPanel1.setBounds(30, 100, 630, 480);
  4371.  
  4372. pack();
  4373. }// </editor-fold>
  4374.  
  4375. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  4376. // TODO add your handling code here:
  4377.  
  4378. if(flag==0)
  4379. {
  4380. jButton1.setVisible(false);
  4381. PrinterJob printJob = PrinterJob.getPrinterJob();
  4382.  
  4383. if (printJob.printDialog())
  4384. {
  4385. try
  4386. {
  4387. printJob.print();
  4388. printJob.setCopies(1);
  4389.  
  4390. }
  4391. catch(Exception PrintException)
  4392. {
  4393. PrintException.printStackTrace();
  4394. }
  4395. printJob.cancel();
  4396. }
  4397. printJob.cancel();
  4398. jButton1.setVisible(true);
  4399.  
  4400. cname=jLabel7.getText();
  4401. date=jLabel5.getText();
  4402. amtpaid=Integer.parseInt(jLabel13.getText());
  4403. price=Integer.parseInt(jLabel11.getText());
  4404. balamt=price-amtpaid;
  4405.  
  4406.  
  4407. if(price!=amtpaid)
  4408. {
  4409. dispose();
  4410. while(reply1!=JOptionPane.YES_OPTION)
  4411. {
  4412. 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");
  4413. if(reply==JOptionPane.YES_OPTION)
  4414. {
  4415. while(!refid.equals(custrefid))
  4416. {
  4417. try
  4418. {
  4419. refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Reference Id");
  4420. while(refid.equals(""))
  4421. {
  4422. JOptionPane.showMessageDialog(null,"Please Enter Reference Id");
  4423. refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Referece Id");
  4424. }
  4425. }
  4426. catch(NullPointerException e)
  4427. {
  4428. int reply3=JOptionPane.showConfirmDialog(null,"Are you sure, you dont want to save customer details");
  4429. if(reply3==JOptionPane.YES_OPTION)
  4430. {
  4431. JOptionPane.showMessageDialog(null,"The customer details are not saved");
  4432. break;
  4433. }
  4434. if(reply3==JOptionPane.NO_OPTION)
  4435. {
  4436. refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Reference Id");
  4437. while(refid.equals(""))
  4438. {
  4439. JOptionPane.showMessageDialog(null,"Please Enter Reference Id");
  4440. refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Referece Id");
  4441. }
  4442. }
  4443. if(reply3==JOptionPane.CANCEL_OPTION)
  4444. {
  4445. JOptionPane.showMessageDialog(null,"The customer details are not saved");
  4446. break;
  4447. }
  4448. }
  4449. try
  4450. {
  4451. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  4452. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  4453. Statement st=con.createStatement();
  4454. ResultSet res=st.executeQuery("select * from newcustomer_details");
  4455. Boolean rec=res.next();
  4456. if(!rec)
  4457. {
  4458. custrefid="1";
  4459. CreditCustomer cs=new CreditCustomer();
  4460. cs.jTextField2.setText(cname);
  4461. cs.jTextField3.setText(date);
  4462. cs.jTextField4.setText(Integer.toString(amtpaid));
  4463. cs.jTextField5.setText(Integer.toString(balamt));
  4464. cs.jTextField6.setText(refid);
  4465. cs.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
  4466. "--------------------------------------------------------------------------"+text);
  4467. cs.jTextField13.setVisible(false);
  4468. cs.jTextField14.setVisible(false);
  4469. cs.jLabel25.setVisible(false);
  4470. cs.jLabel26.setVisible(false);
  4471. cs.flag=0;
  4472. }
  4473. else
  4474. {
  4475. do
  4476. {
  4477. custrefid=res.getString(1);
  4478. if(refid.equals(custrefid))
  4479. {
  4480. CreditCustomer cs=new CreditCustomer();
  4481. cs.jTextField2.setText(cname);
  4482. cs.jTextField3.setText(date);
  4483. cs.jTextField4.setText(Integer.toString(amtpaid));
  4484. cs.jTextField5.setText(Integer.toString(balamt));
  4485. cs.jTextField6.setText(refid);
  4486. cs.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
  4487. "--------------------------------------------------------------------------"+text);
  4488. cs.jTextField13.setVisible(false);
  4489. cs.jTextField14.setVisible(false);
  4490. cs.jLabel25.setVisible(false);
  4491. cs.jLabel26.setVisible(false);
  4492. cs.flag=0;
  4493. a=1;
  4494. break;
  4495. }
  4496. }while(res.next());
  4497. if(a==0)
  4498. {
  4499. JOptionPane.showMessageDialog(null,"The Reference Id is wrong, please enter correct Reference ID");
  4500. }
  4501. }
  4502. }
  4503. catch(Exception e)
  4504. {
  4505. JOptionPane.showMessageDialog(null,"The error is:"+e);
  4506. }
  4507. }
  4508. break;
  4509. }
  4510. else if(reply==JOptionPane.NO_OPTION)
  4511. {
  4512. while(!cid.equals(dcid))
  4513. {
  4514. System.out.println("i came here");
  4515. try
  4516. {
  4517. cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
  4518. while(cid.equals(""))
  4519. {
  4520. JOptionPane.showMessageDialog(null,"Plese Enter Customer Id");
  4521. cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
  4522. }
  4523. }
  4524. catch(NullPointerException e)
  4525. {
  4526. int reply4=JOptionPane.showConfirmDialog(null,"Are you sure, you dont want to save customer details");
  4527. if(reply4==JOptionPane.YES_OPTION)
  4528. {
  4529. JOptionPane.showMessageDialog(null,"The customer details are not saved");
  4530. break;
  4531. }
  4532. if(reply4==JOptionPane.NO_OPTION)
  4533. {
  4534. cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
  4535. while(cid.equals(""))
  4536. {
  4537. JOptionPane.showMessageDialog(null,"Plese Enter Customer Id");
  4538. cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
  4539. }
  4540. }
  4541. if(reply4==JOptionPane.CANCEL_OPTION)
  4542. {
  4543. JOptionPane.showMessageDialog(null,"The customer details are not saved");
  4544. break;
  4545. }
  4546. }
  4547. try
  4548. {
  4549. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  4550. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  4551. Statement st=con.createStatement();
  4552. ResultSet res=st.executeQuery("select * from newcustomer_details");
  4553. Boolean rec=res.next();
  4554. if(!rec)
  4555. {
  4556. }
  4557. else
  4558. {
  4559. do
  4560. {
  4561. dcid=res.getString(1);
  4562. dcname=res.getString(2);
  4563. dpaidamt=res.getInt(4);
  4564. dbalamt=res.getInt(5);
  4565. drefid=res.getInt(6);
  4566.  
  4567. java.sql.Date ddob=res.getDate(7);
  4568. dt1=ddob.toString();
  4569. year1=dt1.substring(0,4);
  4570. month1=dt1.substring(5,7);
  4571. day1=dt1.substring(8,10);
  4572. if(month1.equals("01"))
  4573. {
  4574. mc1="jan";
  4575. }
  4576. else if(month1.equals("02"))
  4577. {
  4578. mc1="feb";
  4579. }
  4580. else if(month1.equals("03"))
  4581. {
  4582. mc1="mar";
  4583. }
  4584. else if(month1.equals("04"))
  4585. {
  4586. mc1="apr";
  4587. }
  4588. else if(month1.equals("05"))
  4589. {
  4590. mc1="may";
  4591. }
  4592. else if(month1.equals("06"))
  4593. {
  4594. mc1="jun";
  4595. }
  4596. else if(month1.equals("07"))
  4597. {
  4598. mc1="jul";
  4599. }
  4600. else if(month1.equals("08"))
  4601. {
  4602. mc1="aug";
  4603. }
  4604. else if(month1.equals("09"))
  4605. {
  4606. mc1="sep";
  4607. }
  4608. else if(month1.equals("10"))
  4609. {
  4610. mc1="oct";
  4611. }
  4612. else if(month1.equals("11"))
  4613. {
  4614. mc1="nov";
  4615. }
  4616. else if(month1.equals("12"))
  4617. {
  4618. mc1="dec";
  4619. }
  4620.  
  4621. dage=res.getInt(8);
  4622. dgender=res.getString(9);
  4623. ddno=res.getString(10);
  4624. dstreet=res.getString(11);
  4625. dcity=res.getString(12);
  4626. dstate=res.getString(13);
  4627. dphno=res.getString(14);
  4628. String dmob_purchase=res.getString(15);
  4629. dmob_purchase+=text;
  4630. if(cid.equals(dcid))
  4631. {
  4632. CreditCustomer cs=new CreditCustomer();
  4633. cs.jComboBox1.setEnabled(false);
  4634. cs.jComboBox2.setEnabled(false);
  4635. cs.jComboBox3.setEnabled(false);
  4636. cs.jTextField7.setEditable(false);
  4637. cs.jRadioButton1.setEnabled(false);
  4638. cs.jRadioButton2.setEnabled(false);
  4639. cs.jTextField8.setEditable(false);
  4640. cs.jTextField9.setEditable(false);
  4641. cs.jTextField10.setEditable(false);
  4642. cs.jTextField11.setEditable(false);
  4643. cs.jTextField12.setEditable(false);
  4644. cs.jButton1.setText("Update Customer Details");
  4645.  
  4646. cs.jTextField1.setText(dcid);
  4647. cs.jTextField2.setText(dcname);
  4648. cs.jTextField3.setText(date);
  4649. cs.jTextField4.setText(Integer.toString(amtpaid));
  4650. cs.jTextField5.setText(Integer.toString(balamt));
  4651. cs.jTextField6.setText(Integer.toString(drefid));
  4652. cs.jTextArea1.setText(dmob_purchase);
  4653. cs.jComboBox1.setSelectedItem(day1);
  4654. cs.jComboBox2.setSelectedItem(mc1);
  4655. cs.jComboBox3.setSelectedItem(year1);
  4656. cs.jTextField7.setText(Integer.toString(dage));
  4657. if(dgender.equalsIgnoreCase("male"))
  4658. cs.jRadioButton1.setSelected(true);
  4659. if(dgender.equalsIgnoreCase("female"))
  4660. cs.jRadioButton2.setSelected(true);
  4661.  
  4662. cs.jTextField8.setText(ddno);
  4663. cs.jTextField9.setText(dstreet);
  4664. cs.jTextField10.setText(dcity);
  4665. cs.jTextField11.setText(dstate);
  4666. cs.jTextField12.setText(dphno);
  4667. cs.jTextField13.setText(Integer.toString(dbalamt));
  4668.  
  4669. int totalamt=dbalamt+balamt;
  4670. cs.jTextField14.setText(Integer.toString(totalamt));
  4671.  
  4672. cs.flag=1;
  4673. d=1;
  4674. break;
  4675. }
  4676. }while(res.next());
  4677. if(d==0)
  4678. {
  4679. JOptionPane.showMessageDialog(null,"Please enter correct Customer Id");
  4680. }
  4681. }
  4682. }
  4683. catch(Exception e)
  4684. {
  4685. JOptionPane.showMessageDialog(null,"The error is:"+e);
  4686. }
  4687. }
  4688. break;
  4689. }
  4690. else if(reply==JOptionPane.CANCEL_OPTION)
  4691. {
  4692. reply1=JOptionPane.showConfirmDialog(null,"Are you sure you dont want to save customer details");
  4693.  
  4694. if(reply1==JOptionPane.YES_OPTION)
  4695. {
  4696. JOptionPane.showMessageDialog(null,"The Customer Details are not saved");
  4697. }
  4698. if(reply1==JOptionPane.NO_OPTION)
  4699. {
  4700. }
  4701. if(reply1==JOptionPane.CANCEL_OPTION)
  4702. {
  4703. JOptionPane.showMessageDialog(null,"The customer details are not saved");
  4704. break;
  4705. }
  4706.  
  4707. }
  4708. }
  4709. }
  4710. else
  4711. {
  4712. dispose();
  4713. }
  4714. }
  4715. else if(flag==1)
  4716. {
  4717. jButton1.setVisible(false);
  4718. PrinterJob printJob = PrinterJob.getPrinterJob();
  4719.  
  4720. if (printJob.printDialog())
  4721. {
  4722. try
  4723. {
  4724. printJob.print();
  4725. printJob.setCopies(1);
  4726.  
  4727. }
  4728. catch(Exception PrintException)
  4729. {
  4730. PrintException.printStackTrace();
  4731. }
  4732. printJob.cancel();
  4733. }
  4734. printJob.cancel();
  4735. jButton1.setVisible(true);
  4736.  
  4737. }
  4738.  
  4739. }
  4740. public int print(Graphics g, PageFormat pf, int pi) throws PrinterException
  4741. {
  4742. Graphics2D g2 = (Graphics2D) g;
  4743. g2.translate(pf.getImageableX()+5, pf.getImageableY()+5);
  4744. Font f = new Font("Monospaced",Font.PLAIN,12);
  4745. g2.setFont (f);
  4746. paint (g2);
  4747. return Printable.PAGE_EXISTS;
  4748. }
  4749. /**
  4750. * @param args the command line arguments
  4751. */
  4752. public static void main(String args[]) {
  4753. java.awt.EventQueue.invokeLater(new Runnable() {
  4754. public void run() {
  4755. new PrintPreview().setVisible(true);
  4756. }
  4757. });
  4758. }
  4759.  
  4760. // Variables declaration - do not modify
  4761. public javax.swing.JButton jButton1;
  4762. private javax.swing.JLabel jLabel1;
  4763. public javax.swing.JLabel jLabel10;
  4764. public javax.swing.JLabel jLabel11;
  4765. public javax.swing.JLabel jLabel12;
  4766. public javax.swing.JLabel jLabel13;
  4767. public javax.swing.JLabel jLabel2;
  4768. public javax.swing.JLabel jLabel3;
  4769. public javax.swing.JLabel jLabel4;
  4770. public javax.swing.JLabel jLabel5;
  4771. public javax.swing.JLabel jLabel6;
  4772. public javax.swing.JLabel jLabel7;
  4773. private javax.swing.JLabel jLabel8;
  4774. public javax.swing.JLabel jLabel9;
  4775. private javax.swing.JPanel jPanel1;
  4776. public javax.swing.JScrollPane jScrollPane1;
  4777. public javax.swing.JTextArea jTextArea1;
  4778. // End of variables declaration
  4779.  
  4780. }
  4781.  
  4782.  
  4783. Code for AddCustomer Page:
  4784.  
  4785.  
  4786. /*
  4787. * To change this template, choose Tools | Templates
  4788. * and open the template in the editor.
  4789. */
  4790.  
  4791. /*
  4792. * CreditCustomer.java
  4793. *
  4794. * Created on Nov 5, 2010, 8:24:54 PM
  4795. */
  4796.  
  4797. package mobilestorenew;
  4798.  
  4799. import java.sql.*;
  4800. import javax.swing.*;
  4801.  
  4802. /**
  4803. *
  4804. * @author Ramesh
  4805. */
  4806. public class CreditCustomer extends javax.swing.JFrame {
  4807.  
  4808. /** Creates new form CreditCustomer */
  4809. int cid,paidamt,balamt,refid,age,currentcid;
  4810. String sex="Male";
  4811. String cname,pdate,dob,dno,street,city,state,phno,mob_purchased,year;
  4812. int flag,totalbal,prevalue=0,curvalue;
  4813. java.sql.Date dat;
  4814. public CreditCustomer() {
  4815. initComponents();
  4816. setVisible(true);
  4817. setSize(1270,740);
  4818. setTitle("Credit Customer");
  4819. jTextField1.setEditable(false);
  4820. jTextField2.setEditable(false);
  4821. jTextField3.setEditable(false);
  4822. jTextField4.setEditable(false);
  4823. jTextField5.setEditable(false);
  4824. jTextField6.setEditable(false);
  4825. jTextField13.setEditable(false);
  4826. jTextField14.setEditable(false);
  4827. jTextArea1.setEditable(false);
  4828.  
  4829. idincrement();
  4830.  
  4831. ButtonGroup bg=new ButtonGroup();
  4832. bg.add(jRadioButton1);
  4833. bg.add(jRadioButton2);
  4834. }
  4835.  
  4836. public void idincrement()
  4837. {
  4838. try
  4839. {
  4840.  
  4841. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  4842. Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  4843. Statement st=co.createStatement();
  4844. ResultSet res=st.executeQuery("select sysdate from dual");
  4845. res.next();
  4846. dat=res.getDate(1);
  4847. res=st.executeQuery("select * from newcustomer_details");
  4848. Boolean rec=res.next();
  4849. if(!rec)
  4850. {
  4851. cid=1;
  4852. }
  4853. else
  4854. {
  4855. do
  4856. {
  4857. curvalue=res.getInt(1);
  4858. if(prevalue<curvalue)
  4859. {
  4860. cid=curvalue+1;
  4861. prevalue=curvalue;
  4862. }
  4863.  
  4864. }while(res.next());
  4865. }
  4866.  
  4867. st.close();
  4868. co.close();
  4869. }
  4870. catch(Exception e)
  4871. {
  4872. JOptionPane.showMessageDialog(null,"the error is"+e);
  4873. }
  4874.  
  4875. jTextField1.setText(Integer.toString(cid));
  4876.  
  4877. year=dat.toString();
  4878. year=year.substring(0,4);
  4879. }
  4880. public void saveupdate()
  4881. {
  4882. dob=(String)jComboBox1.getSelectedItem();
  4883. dob+="-";
  4884. dob+=(String)jComboBox2.getSelectedItem();
  4885. dob+="-";
  4886. dob+=(String)jComboBox3.getSelectedItem();
  4887. System.out.println(dob);
  4888.  
  4889. age=Integer.parseInt(jTextField7.getText());
  4890. dno=jTextField8.getText();
  4891. street=jTextField9.getText();
  4892. city=jTextField10.getText();
  4893. state=jTextField11.getText();
  4894. phno=jTextField12.getText();
  4895. mob_purchased=jTextArea1.getText();
  4896.  
  4897. }
  4898.  
  4899. /** This method is called from within the constructor to
  4900. * initialize the form.
  4901. * WARNING: Do NOT modify this code. The content of this method is
  4902. * always regenerated by the Form Editor.
  4903. */
  4904. @SuppressWarnings("unchecked")
  4905. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  4906. private void initComponents() {
  4907.  
  4908. jLabel1 = new javax.swing.JLabel();
  4909. jPanel2 = new javax.swing.JPanel();
  4910. jLabel5 = new javax.swing.JLabel();
  4911. jLabel4 = new javax.swing.JLabel();
  4912. jRadioButton1 = new javax.swing.JRadioButton();
  4913. jRadioButton2 = new javax.swing.JRadioButton();
  4914. jLabe = new javax.swing.JLabel();
  4915. jLabel7 = new javax.swing.JLabel();
  4916. jLabel11 = new javax.swing.JLabel();
  4917. jLabel12 = new javax.swing.JLabel();
  4918. jTextField7 = new javax.swing.JTextField();
  4919. jTextField9 = new javax.swing.JTextField();
  4920. jLabel14 = new javax.swing.JLabel();
  4921. jTextField10 = new javax.swing.JTextField();
  4922. jTextField8 = new javax.swing.JTextField();
  4923. jLabel6 = new javax.swing.JLabel();
  4924. jLabel16 = new javax.swing.JLabel();
  4925. jComboBox2 = new javax.swing.JComboBox();
  4926. jLabel17 = new javax.swing.JLabel();
  4927. jComboBox3 = new javax.swing.JComboBox();
  4928. jLabel18 = new javax.swing.JLabel();
  4929. jComboBox1 = new javax.swing.JComboBox();
  4930. jTextField11 = new javax.swing.JTextField();
  4931. jTextField12 = new javax.swing.JTextField();
  4932. jLabel19 = new javax.swing.JLabel();
  4933. jLabel20 = new javax.swing.JLabel();
  4934. jLabel21 = new javax.swing.JLabel();
  4935. jLabel23 = new javax.swing.JLabel();
  4936. jLabel24 = new javax.swing.JLabel();
  4937. jLabel22 = new javax.swing.JLabel();
  4938. jPanel1 = new javax.swing.JPanel();
  4939. jTextField1 = new javax.swing.JTextField();
  4940. jLabel2 = new javax.swing.JLabel();
  4941. jLabel3 = new javax.swing.JLabel();
  4942. jTextField2 = new javax.swing.JTextField();
  4943. jLabel8 = new javax.swing.JLabel();
  4944. jTextField3 = new javax.swing.JTextField();
  4945. jLabel9 = new javax.swing.JLabel();
  4946. jScrollPane1 = new javax.swing.JScrollPane();
  4947. jTextArea1 = new javax.swing.JTextArea();
  4948. jLabel10 = new javax.swing.JLabel();
  4949. jTextField4 = new javax.swing.JTextField();
  4950. jLabel13 = new javax.swing.JLabel();
  4951. jTextField5 = new javax.swing.JTextField();
  4952. jLabel15 = new javax.swing.JLabel();
  4953. jTextField6 = new javax.swing.JTextField();
  4954. jLabel25 = new javax.swing.JLabel();
  4955. jTextField13 = new javax.swing.JTextField();
  4956. jLabel26 = new javax.swing.JLabel();
  4957. jTextField14 = new javax.swing.JTextField();
  4958. jPanel3 = new javax.swing.JPanel();
  4959. jButton1 = new javax.swing.JButton();
  4960. jButton2 = new javax.swing.JButton();
  4961.  
  4962. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  4963. getContentPane().setLayout(null);
  4964.  
  4965. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
  4966. jLabel1.setText("Add Credit Customer Details");
  4967. getContentPane().add(jLabel1);
  4968. jLabel1.setBounds(340, 0, 350, 40);
  4969.  
  4970. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Customer Details", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP));
  4971. jPanel2.setLayout(null);
  4972.  
  4973. jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
  4974. jLabel5.setText("Age");
  4975. jPanel2.add(jLabel5);
  4976. jLabel5.setBounds(480, 30, 80, 30);
  4977.  
  4978. jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
  4979. jLabel4.setText("Gender");
  4980. jPanel2.add(jLabel4);
  4981. jLabel4.setBounds(40, 90, 110, 30);
  4982.  
  4983. jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 12));
  4984. jRadioButton1.setSelected(true);
  4985. jRadioButton1.setText("Male");
  4986. jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
  4987. public void actionPerformed(java.awt.event.ActionEvent evt) {
  4988. jRadioButton1ActionPerformed(evt);
  4989. }
  4990. });
  4991. jPanel2.add(jRadioButton1);
  4992. jRadioButton1.setBounds(130, 90, 60, 30);
  4993.  
  4994. jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 12));
  4995. jRadioButton2.setText("Female");
  4996. jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
  4997. public void actionPerformed(java.awt.event.ActionEvent evt) {
  4998. jRadioButton2ActionPerformed(evt);
  4999. }
  5000. });
  5001. jPanel2.add(jRadioButton2);
  5002. jRadioButton2.setBounds(210, 90, 70, 30);
  5003.  
  5004. jLabe.setFont(new java.awt.Font("Tahoma", 1, 12));
  5005. jLabe.setText("City");
  5006. jPanel2.add(jLabe);
  5007. jLabe.setBounds(480, 140, 90, 30);
  5008.  
  5009. jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
  5010. jLabel7.setText("Door NO");
  5011. jPanel2.add(jLabel7);
  5012. jLabel7.setBounds(480, 90, 110, 30);
  5013.  
  5014. jLabel11.setFont(new java.awt.Font("Tahoma", 1, 14));
  5015. jLabel11.setText("Street");
  5016. jPanel2.add(jLabel11);
  5017. jLabel11.setBounds(40, 140, 80, 30);
  5018.  
  5019. jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
  5020. jLabel12.setText("State");
  5021. jPanel2.add(jLabel12);
  5022. jLabel12.setBounds(40, 200, 80, 30);
  5023.  
  5024. jTextField7.setFont(new java.awt.Font("Tahoma", 1, 14));
  5025. jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
  5026. public void focusGained(java.awt.event.FocusEvent evt) {
  5027. jTextField7FocusGained(evt);
  5028. }
  5029. public void focusLost(java.awt.event.FocusEvent evt) {
  5030. jTextField7FocusLost(evt);
  5031. }
  5032. });
  5033. jPanel2.add(jTextField7);
  5034. jTextField7.setBounds(580, 30, 160, 30);
  5035.  
  5036. jTextField9.setFont(new java.awt.Font("Tahoma", 1, 14));
  5037. jTextField9.addFocusListener(new java.awt.event.FocusAdapter() {
  5038. public void focusLost(java.awt.event.FocusEvent evt) {
  5039. jTextField9FocusLost(evt);
  5040. }
  5041. });
  5042. jPanel2.add(jTextField9);
  5043. jTextField9.setBounds(130, 140, 170, 30);
  5044.  
  5045. jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12));
  5046. jLabel14.setText("Phone Number");
  5047. jPanel2.add(jLabel14);
  5048. jLabel14.setBounds(480, 200, 100, 30);
  5049.  
  5050. jTextField10.setFont(new java.awt.Font("Tahoma", 1, 14));
  5051. jTextField10.addFocusListener(new java.awt.event.FocusAdapter() {
  5052. public void focusLost(java.awt.event.FocusEvent evt) {
  5053. jTextField10FocusLost(evt);
  5054. }
  5055. });
  5056. jPanel2.add(jTextField10);
  5057. jTextField10.setBounds(580, 140, 160, 30);
  5058.  
  5059. jTextField8.setFont(new java.awt.Font("Tahoma", 1, 14));
  5060. jTextField8.addFocusListener(new java.awt.event.FocusAdapter() {
  5061. public void focusLost(java.awt.event.FocusEvent evt) {
  5062. jTextField8FocusLost(evt);
  5063. }
  5064. });
  5065. jPanel2.add(jTextField8);
  5066. jTextField8.setBounds(580, 90, 160, 30);
  5067.  
  5068. jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12));
  5069. jLabel6.setText("Date of Birth");
  5070. jPanel2.add(jLabel6);
  5071. jLabel6.setBounds(40, 30, 90, 30);
  5072.  
  5073. jLabel16.setFont(new java.awt.Font("Tahoma", 1, 12));
  5074. jLabel16.setText("(DD)");
  5075. jPanel2.add(jLabel16);
  5076. jLabel16.setBounds(180, 30, 30, 30);
  5077.  
  5078. jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12));
  5079. jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
  5080. jPanel2.add(jComboBox2);
  5081. jComboBox2.setBounds(210, 30, 56, 30);
  5082.  
  5083. jLabel17.setFont(new java.awt.Font("Tahoma", 1, 12));
  5084. jLabel17.setText("(MM)");
  5085. jPanel2.add(jLabel17);
  5086. jLabel17.setBounds(270, 30, 40, 30);
  5087.  
  5088. jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
  5089. 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" }));
  5090. jPanel2.add(jComboBox3);
  5091. jComboBox3.setBounds(310, 30, 60, 30);
  5092.  
  5093. jLabel18.setFont(new java.awt.Font("Tahoma", 1, 12));
  5094. jLabel18.setText("(YY)");
  5095. jPanel2.add(jLabel18);
  5096. jLabel18.setBounds(370, 30, 30, 30);
  5097.  
  5098. jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
  5099. 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" }));
  5100. jPanel2.add(jComboBox1);
  5101. jComboBox1.setBounds(130, 30, 50, 30);
  5102.  
  5103. jTextField11.setFont(new java.awt.Font("Tahoma", 1, 14));
  5104. jTextField11.addFocusListener(new java.awt.event.FocusAdapter() {
  5105. public void focusLost(java.awt.event.FocusEvent evt) {
  5106. jTextField11FocusLost(evt);
  5107. }
  5108. });
  5109. jPanel2.add(jTextField11);
  5110. jTextField11.setBounds(130, 200, 170, 30);
  5111.  
  5112. jTextField12.setFont(new java.awt.Font("Tahoma", 1, 14));
  5113. jTextField12.addFocusListener(new java.awt.event.FocusAdapter() {
  5114. public void focusLost(java.awt.event.FocusEvent evt) {
  5115. jTextField12FocusLost(evt);
  5116. }
  5117. });
  5118. jPanel2.add(jTextField12);
  5119. jTextField12.setBounds(580, 200, 160, 30);
  5120. jPanel2.add(jLabel19);
  5121. jLabel19.setBounds(750, 30, 170, 30);
  5122. jPanel2.add(jLabel20);
  5123. jLabel20.setBounds(750, 90, 170, 30);
  5124. jPanel2.add(jLabel21);
  5125. jLabel21.setBounds(310, 140, 110, 30);
  5126. jPanel2.add(jLabel23);
  5127. jLabel23.setBounds(310, 200, 120, 30);
  5128. jPanel2.add(jLabel24);
  5129. jLabel24.setBounds(750, 200, 170, 30);
  5130. jPanel2.add(jLabel22);
  5131. jLabel22.setBounds(750, 140, 160, 30);
  5132.  
  5133. getContentPane().add(jPanel2);
  5134. jPanel2.setBounds(20, 370, 980, 250);
  5135.  
  5136. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Customer Details", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP));
  5137. jPanel1.setLayout(null);
  5138.  
  5139. jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
  5140. jPanel1.add(jTextField1);
  5141. jTextField1.setBounds(170, 30, 140, 30);
  5142.  
  5143. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
  5144. jLabel2.setText("Customer Id");
  5145. jPanel1.add(jLabel2);
  5146. jLabel2.setBounds(30, 30, 100, 30);
  5147.  
  5148. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
  5149. jLabel3.setText("Customer Name");
  5150. jPanel1.add(jLabel3);
  5151. jLabel3.setBounds(370, 30, 120, 30);
  5152.  
  5153. jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
  5154. jPanel1.add(jTextField2);
  5155. jTextField2.setBounds(490, 30, 170, 30);
  5156.  
  5157. jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12));
  5158. jLabel8.setText("Date Purchased");
  5159. jPanel1.add(jLabel8);
  5160. jLabel8.setBounds(30, 80, 100, 30);
  5161.  
  5162. jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
  5163. jPanel1.add(jTextField3);
  5164. jTextField3.setBounds(170, 80, 140, 30);
  5165.  
  5166. jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
  5167. jLabel9.setText("Mobiles Purchased");
  5168. jPanel1.add(jLabel9);
  5169. jLabel9.setBounds(370, 130, 120, 30);
  5170.  
  5171. jTextArea1.setColumns(20);
  5172. jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  5173. jTextArea1.setRows(5);
  5174. jTextArea1.setTabSize(9);
  5175. jScrollPane1.setViewportView(jTextArea1);
  5176.  
  5177. jPanel1.add(jScrollPane1);
  5178. jScrollPane1.setBounds(490, 130, 410, 170);
  5179.  
  5180. jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
  5181. jLabel10.setText("Paid Amount");
  5182. jPanel1.add(jLabel10);
  5183. jLabel10.setBounds(370, 80, 100, 30);
  5184.  
  5185. jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
  5186. jPanel1.add(jTextField4);
  5187. jTextField4.setBounds(490, 80, 170, 30);
  5188.  
  5189. jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
  5190. jLabel13.setText("Balance Amount");
  5191. jPanel1.add(jLabel13);
  5192. jLabel13.setBounds(30, 130, 100, 30);
  5193.  
  5194. jTextField5.setFont(new java.awt.Font("Tahoma", 1, 14));
  5195. jPanel1.add(jTextField5);
  5196. jTextField5.setBounds(170, 130, 140, 30);
  5197.  
  5198. jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12));
  5199. jLabel15.setText("Reference Id");
  5200. jPanel1.add(jLabel15);
  5201. jLabel15.setBounds(30, 180, 100, 30);
  5202.  
  5203. jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
  5204. jPanel1.add(jTextField6);
  5205. jTextField6.setBounds(170, 180, 140, 30);
  5206.  
  5207. jLabel25.setFont(new java.awt.Font("Tahoma", 1, 12));
  5208. jLabel25.setText("Old Balance Amount");
  5209. jPanel1.add(jLabel25);
  5210. jLabel25.setBounds(30, 230, 130, 30);
  5211.  
  5212. jTextField13.setFont(new java.awt.Font("Tahoma", 1, 14));
  5213. jPanel1.add(jTextField13);
  5214. jTextField13.setBounds(170, 230, 140, 30);
  5215.  
  5216. jLabel26.setFont(new java.awt.Font("Tahoma", 1, 12));
  5217. jLabel26.setText("Total Balance Amount");
  5218. jPanel1.add(jLabel26);
  5219. jLabel26.setBounds(30, 280, 140, 30);
  5220.  
  5221. jTextField14.setFont(new java.awt.Font("Tahoma", 1, 14));
  5222. jPanel1.add(jTextField14);
  5223. jTextField14.setBounds(170, 280, 140, 30);
  5224.  
  5225. getContentPane().add(jPanel1);
  5226. jPanel1.setBounds(20, 40, 980, 320);
  5227.  
  5228. jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  5229. jPanel3.setLayout(null);
  5230.  
  5231. jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
  5232. jButton1.setText("Save Customer Details");
  5233. jButton1.addActionListener(new java.awt.event.ActionListener() {
  5234. public void actionPerformed(java.awt.event.ActionEvent evt) {
  5235. jButton1ActionPerformed(evt);
  5236. }
  5237. });
  5238. jPanel3.add(jButton1);
  5239. jButton1.setBounds(150, 10, 210, 40);
  5240.  
  5241. jButton2.setFont(new java.awt.Font("Tahoma", 1, 14));
  5242. jButton2.setText("Cancel");
  5243. jButton2.addActionListener(new java.awt.event.ActionListener() {
  5244. public void actionPerformed(java.awt.event.ActionEvent evt) {
  5245. jButton2ActionPerformed(evt);
  5246. }
  5247. });
  5248. jPanel3.add(jButton2);
  5249. jButton2.setBounds(370, 10, 100, 40);
  5250.  
  5251. getContentPane().add(jPanel3);
  5252. jPanel3.setBounds(180, 630, 610, 60);
  5253.  
  5254. pack();
  5255. }// </editor-fold>
  5256.  
  5257. private void jTextField7FocusLost(java.awt.event.FocusEvent evt) {
  5258. // TODO add your handling code here:
  5259. if(jTextField7.getText().equals(""))
  5260. {
  5261. jLabel19.setText("Entry Is Must");
  5262. }
  5263. else if(jTextField7.getText().length()>2)
  5264. {
  5265. jLabel19.setText("Enter Valid Age");
  5266. jTextField7.setText("");
  5267. }
  5268. else
  5269. {
  5270. String jtf1=jTextField7.getText();
  5271. int fg=0;
  5272. for(int i=0;i<jtf1.length();i++)
  5273. {
  5274. char c1=jtf1.charAt(i);
  5275. if(Character.isLetter(c1))
  5276. {
  5277. fg=0;
  5278. break;
  5279. }
  5280. else
  5281. {
  5282. fg=1;
  5283. }
  5284. }
  5285. if(fg==0)
  5286. {
  5287. jLabel19.setText("Enter Numbers");
  5288. jTextField7.setText("");
  5289. }
  5290. else
  5291. jLabel19.setText("") ;
  5292. }
  5293. }
  5294.  
  5295. private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  5296. // TODO add your handling code here:
  5297. sex="Male";
  5298. System.out.println(sex);
  5299. }
  5300.  
  5301. private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  5302. // TODO add your handling code here:
  5303. sex="Female";
  5304. System.out.println(sex);
  5305. }
  5306.  
  5307. private void jTextField8FocusLost(java.awt.event.FocusEvent evt) {
  5308. // TODO add your handling code here:
  5309. if(jTextField8.getText().equals(""))
  5310. {
  5311. jLabel20.setText("Entry Is Must");
  5312. }
  5313. else
  5314. {
  5315. jLabel20.setText("");
  5316. }
  5317. }
  5318.  
  5319. private void jTextField9FocusLost(java.awt.event.FocusEvent evt) {
  5320. // TODO add your handling code here:
  5321. if(jTextField9.getText().equals(""))
  5322. {
  5323. jLabel21.setText("Entry Is Must");
  5324. }
  5325. else
  5326. {
  5327. jLabel21.setText("");
  5328. }
  5329. }
  5330.  
  5331. private void jTextField10FocusLost(java.awt.event.FocusEvent evt) {
  5332. // TODO add your handling code here:
  5333. if(jTextField10.getText().equals(""))
  5334. {
  5335. jLabel22.setText("Entry Is Must");
  5336. }
  5337. else
  5338. {
  5339. jLabel22.setText("");
  5340. }
  5341. }
  5342.  
  5343. private void jTextField11FocusLost(java.awt.event.FocusEvent evt) {
  5344. // TODO add your handling code here:
  5345. if(jTextField11.getText().equals(""))
  5346. {
  5347. jLabel23.setText("Entry Is Must");
  5348. }
  5349. else
  5350. {
  5351. jLabel23.setText("") ;
  5352. }
  5353. }
  5354.  
  5355. private void jTextField12FocusLost(java.awt.event.FocusEvent evt) {
  5356. // TODO add your handling code here:
  5357. if(jTextField12.getText().equals(""))
  5358. {
  5359. jLabel24.setText("Entry Is Must");
  5360. }
  5361. else
  5362. {
  5363. String jtf1=jTextField12.getText();
  5364. int fg=0;
  5365. for(int i=0;i<jtf1.length();i++)
  5366. {
  5367. char c1=jtf1.charAt(i);
  5368. if(Character.isLetter(c1))
  5369. {
  5370. fg=0;
  5371. break;
  5372. }
  5373. else
  5374. {
  5375. fg=1;
  5376. }
  5377. }
  5378. if(fg==0)
  5379. {
  5380. jLabel24.setText("Enter Valid Phone Number");
  5381. jTextField12.setText("");
  5382. }
  5383. else
  5384. jLabel24.setText("") ;
  5385. }
  5386. }
  5387.  
  5388. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  5389. // TODO add your handling code here:
  5390. if(jTextField7.getText().equals("") || jTextField8.getText().equals("") || jTextField9.getText().equals("") || jTextField10.getText().equals("") || jTextField11.getText().equals("") || jTextField12.getText().equals(""))
  5391. {
  5392. JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
  5393. if(jTextField7.getText().equals(""))
  5394. {
  5395. jLabel19.setText("Fill this Field");
  5396. }
  5397. else
  5398. jLabel19.setText("");
  5399. if(jTextField8.getText().equals(""))
  5400. {
  5401. jLabel20.setText("Fill this Field");
  5402. }
  5403. else
  5404. jLabel20.setText("");
  5405. if(jTextField9.getText().equals(""))
  5406. {
  5407. jLabel21.setText("Fill this Field");
  5408. }
  5409. else
  5410. jLabel21.setText("");
  5411. if(jTextField10.getText().equals(""))
  5412. {
  5413. jLabel22.setText("Fill this Field");
  5414. }
  5415. else
  5416. jLabel22.setText("");
  5417. if(jTextField11.getText().equals(""))
  5418. {
  5419. jLabel23.setText("Fill this Field");
  5420. }
  5421. else
  5422. jLabel23.setText("");
  5423. if(jTextField12.getText().equals(""))
  5424. {
  5425. jLabel24.setText("Fill this Field");
  5426. }
  5427. else
  5428. jLabel24.setText("");
  5429. }
  5430. else
  5431. {
  5432. if(flag==0)
  5433. {
  5434. cname=jTextField2.getText();
  5435. pdate=jTextField3.getText();
  5436. paidamt=Integer.parseInt(jTextField4.getText());
  5437. balamt=Integer.parseInt(jTextField5.getText());
  5438. refid=Integer.parseInt(jTextField6.getText());
  5439. saveupdate();
  5440.  
  5441. try
  5442. {
  5443. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  5444. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  5445.  
  5446. PreparedStatement prp=con.prepareStatement("insert into newcustomer_details values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  5447. prp.setInt(1,cid);
  5448. prp.setString(2,cname);
  5449. prp.setString(3,pdate);
  5450. prp.setInt(4,paidamt);
  5451. prp.setInt(5,balamt);
  5452. prp.setInt(6,refid);
  5453. prp.setString(7,dob);
  5454. prp.setInt(8,age);
  5455. prp.setString(9,sex);
  5456. prp.setString(10,dno);
  5457. prp.setString(11,street);
  5458. prp.setString(12,city);
  5459. prp.setString(13,state);
  5460. prp.setString(14,phno);
  5461. prp.setString(15,mob_purchased);
  5462.  
  5463. prp.executeUpdate();
  5464.  
  5465. JOptionPane.showMessageDialog(null,"Customer Details saved successfully");
  5466.  
  5467. con.commit();
  5468. con.close();
  5469. dispose();
  5470.  
  5471. }
  5472. catch(SQLException e)
  5473. {
  5474. JOptionPane.showMessageDialog(null,"INVALID DATE, please select correct date");
  5475. jComboBox1.setSelectedItem("01");
  5476. jComboBox2.setSelectedItem("jan");
  5477. jComboBox3.setSelectedItem("1910");
  5478. }
  5479. catch(Exception e)
  5480. {
  5481. JOptionPane.showMessageDialog(null,"Error is:"+e);
  5482. }
  5483. }
  5484. else if(flag==1)
  5485. {
  5486. currentcid=Integer.parseInt(jTextField1.getText());
  5487. totalbal=Integer.parseInt(jTextField14.getText());
  5488. mob_purchased=jTextArea1.getText();
  5489. try
  5490. {
  5491. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  5492. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  5493.  
  5494. PreparedStatement prp=con.prepareStatement("update newcustomer_details set balamt=?, mob_purchased=? where cid=?");
  5495. prp.setInt(1,totalbal);
  5496. prp.setString(2,mob_purchased);
  5497. prp.setInt(3,currentcid);
  5498. prp.executeUpdate();
  5499.  
  5500. JOptionPane.showMessageDialog(null,"The Customer Details updated successfully");
  5501. con.commit();
  5502. con.close();
  5503. dispose();
  5504.  
  5505. }
  5506. catch(Exception e)
  5507. {
  5508. JOptionPane.showMessageDialog(null,"The error is:"+e);
  5509. }
  5510.  
  5511. }
  5512. else if(flag==2)
  5513. {
  5514. dispose();
  5515. }
  5516. else if(flag==3)
  5517. {
  5518. currentcid=Integer.parseInt(jTextField1.getText());
  5519. saveupdate();
  5520. try
  5521. {
  5522. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  5523. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  5524.  
  5525. PreparedStatement prp=con.prepareStatement("update newcustomer_details set dob=?,age=?,gender=?,dno=?,street=?,city=?,state=?,phno=? where cid=?");
  5526. prp.setString(1,dob);
  5527. prp.setInt(2,age);
  5528. prp.setString(3,sex);
  5529. prp.setString(4,dno);
  5530. prp.setString(5,street);
  5531. prp.setString(6,city);
  5532. prp.setString(7,state);
  5533. prp.setString(8,phno);
  5534. prp.setInt(9,currentcid);
  5535. prp.executeUpdate();
  5536. JOptionPane.showMessageDialog(null,"The Customer Details Updated Successfully");
  5537. con.commit();
  5538. con.close();
  5539. dispose();
  5540.  
  5541.  
  5542. }
  5543. catch(Exception e)
  5544. {
  5545. JOptionPane.showMessageDialog(null,"The error is:"+e);
  5546. }
  5547. }
  5548.  
  5549. }
  5550. }
  5551.  
  5552. private void jTextField7FocusGained(java.awt.event.FocusEvent evt) {
  5553. // TODO add your handling code here:
  5554. String temp=(String)jComboBox3.getSelectedItem();
  5555. int birthyear=Integer.parseInt(temp);
  5556. int thisyear=Integer.parseInt(year);
  5557. System.out.println(birthyear+","+thisyear);
  5558. int agefind=thisyear-birthyear;
  5559. agefind=agefind-1;
  5560. jTextField7.setText(Integer.toString(agefind));
  5561.  
  5562. }
  5563.  
  5564. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  5565. // TODO add your handling code here:
  5566. jComboBox1.setSelectedItem("01");
  5567. jComboBox2.setSelectedItem("jan");
  5568. jComboBox3.setSelectedItem("1910");
  5569. jRadioButton1.setSelected(true);
  5570. jTextField7.setText("");jLabel19.setText("");
  5571. jTextField8.setText("");jLabel20.setText("");
  5572. jTextField9.setText("");jLabel21.setText("");
  5573. jTextField10.setText("");jLabel22.setText("");
  5574. jTextField11.setText("");jLabel23.setText("");
  5575. jTextField12.setText("");jLabel24.setText("");
  5576.  
  5577. }
  5578.  
  5579. /**
  5580. * @param args the command line arguments
  5581. */
  5582. public static void main(String args[]) {
  5583. java.awt.EventQueue.invokeLater(new Runnable() {
  5584. public void run() {
  5585. new CreditCustomer().setVisible(true);
  5586. }
  5587. });
  5588. }
  5589.  
  5590. // Variables declaration - do not modify
  5591. public javax.swing.JButton jButton1;
  5592. public javax.swing.JButton jButton2;
  5593. public javax.swing.JComboBox jComboBox1;
  5594. public javax.swing.JComboBox jComboBox2;
  5595. public javax.swing.JComboBox jComboBox3;
  5596. private javax.swing.JLabel jLabe;
  5597. public javax.swing.JLabel jLabel1;
  5598. private javax.swing.JLabel jLabel10;
  5599. private javax.swing.JLabel jLabel11;
  5600. private javax.swing.JLabel jLabel12;
  5601. private javax.swing.JLabel jLabel13;
  5602. private javax.swing.JLabel jLabel14;
  5603. private javax.swing.JLabel jLabel15;
  5604. private javax.swing.JLabel jLabel16;
  5605. private javax.swing.JLabel jLabel17;
  5606. private javax.swing.JLabel jLabel18;
  5607. private javax.swing.JLabel jLabel19;
  5608. private javax.swing.JLabel jLabel2;
  5609. private javax.swing.JLabel jLabel20;
  5610. private javax.swing.JLabel jLabel21;
  5611. private javax.swing.JLabel jLabel22;
  5612. private javax.swing.JLabel jLabel23;
  5613. private javax.swing.JLabel jLabel24;
  5614. public javax.swing.JLabel jLabel25;
  5615. public javax.swing.JLabel jLabel26;
  5616. private javax.swing.JLabel jLabel3;
  5617. private javax.swing.JLabel jLabel4;
  5618. private javax.swing.JLabel jLabel5;
  5619. private javax.swing.JLabel jLabel6;
  5620. private javax.swing.JLabel jLabel7;
  5621. public javax.swing.JLabel jLabel8;
  5622. private javax.swing.JLabel jLabel9;
  5623. private javax.swing.JPanel jPanel1;
  5624. private javax.swing.JPanel jPanel2;
  5625. private javax.swing.JPanel jPanel3;
  5626. public javax.swing.JRadioButton jRadioButton1;
  5627. public javax.swing.JRadioButton jRadioButton2;
  5628. private javax.swing.JScrollPane jScrollPane1;
  5629. public javax.swing.JTextArea jTextArea1;
  5630. public javax.swing.JTextField jTextField1;
  5631. public javax.swing.JTextField jTextField10;
  5632. public javax.swing.JTextField jTextField11;
  5633. public javax.swing.JTextField jTextField12;
  5634. public javax.swing.JTextField jTextField13;
  5635. public javax.swing.JTextField jTextField14;
  5636. public javax.swing.JTextField jTextField2;
  5637. public javax.swing.JTextField jTextField3;
  5638. public javax.swing.JTextField jTextField4;
  5639. public javax.swing.JTextField jTextField5;
  5640. public javax.swing.JTextField jTextField6;
  5641. public javax.swing.JTextField jTextField7;
  5642. public javax.swing.JTextField jTextField8;
  5643. public javax.swing.JTextField jTextField9;
  5644. // End of variables declaration
  5645.  
  5646. }
  5647.  
  5648.  
  5649.  
  5650. Code for SearchCustomer Page:
  5651.  
  5652.  
  5653. /*
  5654. * To change this template, choose Tools | Templates
  5655. * and open the template in the editor.
  5656. */
  5657.  
  5658. /*
  5659. * SearchCustomer.java
  5660. *
  5661. * Created on Nov 10, 2010, 2:26:43 AM
  5662. */
  5663.  
  5664. package mobilestorenew;
  5665.  
  5666. import java.sql.*;
  5667. import javax.swing.*;
  5668.  
  5669. /**
  5670. *
  5671. * @author Ramesh
  5672. */
  5673. public class SearchCustomer extends javax.swing.JFrame {
  5674.  
  5675. /** Creates new form SearchCustomer */
  5676. int flag=0,rows=0,a=0,b=0;
  5677. String cid;
  5678. Object data[][];
  5679. JTable table;
  5680. JScrollPane jsp;
  5681. ResultSet res;
  5682. ResultSet rs;
  5683. public SearchCustomer() {
  5684. initComponents();
  5685. setVisible(true);
  5686. setSize(1270,740);
  5687. setTitle("Search Customer");
  5688. ButtonGroup bg=new ButtonGroup();
  5689. bg.add(jRadioButton1);
  5690. bg.add(jRadioButton2);
  5691. }
  5692. public void tabledisp()
  5693. {
  5694. try
  5695. {
  5696.  
  5697. data=new Object[rows][15];
  5698. 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"};
  5699.  
  5700.  
  5701. Class.forName("sun.jdbc.odbc.JdbcOdbc");
  5702. Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
  5703. Statement st=con.createStatement();
  5704.  
  5705. rs=st.executeQuery("select * from csearch");
  5706. for(int i=0;i<rows;i++)
  5707. {
  5708. rs.next();
  5709. for(int j=0;j<15;j++)
  5710. {
  5711. data [i][j]=rs.getString(j+1);
  5712. System.out.println(data[i][j]);
  5713. }
  5714. }
  5715. table=new JTable(data,colheads);
  5716.  
  5717. int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
  5718. int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
  5719. jsp=new JScrollPane(table,v,h);
  5720. jsp.setBounds(70,380,900,240);
  5721. jPanel2.add(jsp);
  5722. add(jsp);
  5723. System.out.println("hai we came here");
  5724. rows=0;
  5725. st.close();
  5726. con.commit();
  5727. con.close();
  5728.  
  5729. }
  5730. catch(Exception e)
  5731. {
  5732. JOptionPane.showMessageDialog(null,"here the error is:"+e);
  5733. }
  5734.  
  5735. }
  5736.  
  5737.  
  5738. /** This method is called from within the constructor to
  5739. * initialize the form.
  5740. * WARNING: Do NOT modify this code. The content of this method is
  5741. * always regenerated by the Form Editor.
  5742. */
  5743. @SuppressWarnings("unchecked")
  5744. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  5745. private void initComponents() {
  5746.  
  5747. jPanel1 = new javax.swing.JPanel();
  5748. jLabel2 = new javax.swing.JLabel();
  5749. jTextField1 = new javax.swing.JTextField();
  5750. jLabel3 = new javax.swing.JLabel();
  5751. jRadioButton1 = new javax.swing.JRadioButton();
  5752. jRadioButton2 = new javax.swing.JRadioButton();
  5753. jLabel1 = new javax.swing.JLabel();
  5754. jButton1 = new javax.swing.JButton();
  5755. jButton2 = new javax.swing.JButton();
  5756. jPanel2 = new javax.swing.JPanel();
  5757.  
  5758. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  5759. getContentPane().setLayout(null);
  5760.  
  5761. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  5762. jPanel1.setLayout(null);
  5763.  
  5764. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
  5765. jLabel2.setText("Search Field");
  5766. jPanel1.add(jLabel2);
  5767. jLabel2.setBounds(90, 40, 90, 30);
  5768.  
  5769. jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
  5770. jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
  5771. public void focusGained(java.awt.event.FocusEvent evt) {
  5772. jTextField1FocusGained(evt);
  5773. }
  5774. });
  5775. jPanel1.add(jTextField1);
  5776. jTextField1.setBounds(210, 40, 160, 30);
  5777. jPanel1.add(jLabel3);
  5778. jLabel3.setBounds(380, 40, 100, 30);
  5779.  
  5780. jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
  5781. jRadioButton1.setSelected(true);
  5782. jRadioButton1.setText(" Search By Customer Id");
  5783. jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
  5784. public void actionPerformed(java.awt.event.ActionEvent evt) {
  5785. jRadioButton1ActionPerformed(evt);
  5786. }
  5787. });
  5788. jPanel1.add(jRadioButton1);
  5789. jRadioButton1.setBounds(90, 110, 210, 25);
  5790.  
  5791. jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 14));
  5792. jRadioButton2.setText(" Search By Customer Name");
  5793. jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
  5794. public void actionPerformed(java.awt.event.ActionEvent evt) {
  5795. jRadioButton2ActionPerformed(evt);
  5796. }
  5797. });
  5798. jPanel1.add(jRadioButton2);
  5799. jRadioButton2.setBounds(90, 160, 230, 25);
  5800.  
  5801. getContentPane().add(jPanel1);
  5802. jPanel1.setBounds(40, 90, 500, 240);
  5803.  
  5804. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
  5805. jLabel1.setText("Search Customer Details");
  5806. getContentPane().add(jLabel1);
  5807. jLabel1.setBounds(310, 20, 320, 50);
  5808.  
  5809. jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
  5810. jButton1.setText("Search");
  5811. jButton1.addActionListener(new java.awt.event.ActionListener() {
  5812. public void actionPerformed(java.awt.event.ActionEvent evt) {
  5813. jButton1ActionPerformed(evt);
  5814. }
  5815. });
  5816. getContentPane().add(jButton1);
  5817. jButton1.setBounds(610, 180, 120, 40);
  5818.  
  5819. jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
  5820. jButton2.setText("Cancel");
  5821. getContentPane().add(jButton2);
  5822. jButton2.setBounds(770, 180, 100, 40);
  5823.  
  5824. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("Search Results"));
  5825.  
  5826. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  5827. jPanel2.setLayout(jPanel2Layout);
  5828. jPanel2Layout.setHorizontalGroup(
  5829. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  5830. .addGap(0, 944, Short.MAX_VALUE)
  5831. );
  5832. jPanel2Layout.setVerticalGroup(
  5833. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  5834. .addGap(0, 270, Short.MAX_VALUE)
  5835. );
  5836.  
  5837. getContentPane().add(jPanel2);
  5838. jPanel2.setBounds(40, 350, 960, 300);
  5839.  
  5840. pack();
  5841. }// </editor-fold>
  5842.  
  5843. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  5844. // TODO add your handling code here:
  5845. if(jTextField1.getText().equals(""))
  5846. {
  5847. jLabel3.setText("Entry Is Must");
  5848. jTextField1.setText("");
  5849. }
  5850. else
  5851. {
  5852. jLabel3.setText("");
  5853. cid=jTextField1.getText();
  5854. if(flag==0)
  5855. {
  5856. try
  5857. {
  5858. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  5859. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  5860. Statement st=con.createStatement();
  5861. st.executeUpdate("delete csearch");
  5862. res=st.executeQuery("select * from newcustomer_details");
  5863. Boolean rec=res.next();
  5864. if(rec==false)
  5865. {
  5866. JOptionPane.showMessageDialog(null,"There are no customers exists");
  5867. jTextField1.setText("");
  5868. }
  5869. else
  5870. {
  5871. do
  5872. {
  5873. String dcid=res.getString(1);
  5874. String dcname=res.getString(2);
  5875.  
  5876. java.sql.Date dt=res.getDate(3);
  5877. String dd=dt.toString();
  5878. String year=dd.substring(0,4);
  5879. String month=dd.substring(5,7);
  5880. String day=dd.substring(8,10);
  5881. String mc="";
  5882. if(month.equals("01"))
  5883. {
  5884. mc="jan";
  5885. }
  5886. else if(month.equals("02"))
  5887. {
  5888. mc="feb";
  5889. }
  5890. else if(month.equals("03"))
  5891. {
  5892. mc="mar";
  5893. }
  5894. else if(month.equals("04"))
  5895. {
  5896. mc="apr";
  5897. }
  5898. else if(month.equals("05"))
  5899. {
  5900. mc="may";
  5901. }
  5902. else if(month.equals("06"))
  5903. {
  5904. mc="jun";
  5905. }
  5906. else if(month.equals("07"))
  5907. {
  5908. mc="jul";
  5909. }
  5910. else if(month.equals("08"))
  5911. {
  5912. mc="aug";
  5913. }
  5914. else if(month.equals("09"))
  5915. {
  5916. mc="sep";
  5917. }
  5918. else if(month.equals("10"))
  5919. {
  5920. mc="oct";
  5921. }
  5922. else if(month.equals("11"))
  5923. {
  5924. mc="nov";
  5925. }
  5926. else if(month.equals("12"))
  5927. {
  5928. mc="dec";
  5929. }
  5930. String date=day+"-"+mc+"-"+year;
  5931.  
  5932. int dpaidamt=res.getInt(4);
  5933. int dbalamt=res.getInt(5);
  5934. int drefid=res.getInt(6);
  5935.  
  5936. java.sql.Date dob=res.getDate(7);
  5937.  
  5938. String ddob=dob.toString();
  5939. String year1=ddob.substring(0,4);
  5940. String month1=ddob.substring(5,7);
  5941. String day1=ddob.substring(8,10);
  5942.  
  5943. String mc1="";
  5944. if(month1.equals("01"))
  5945. {
  5946. mc1="jan";
  5947. }
  5948. else if(month1.equals("02"))
  5949. {
  5950. mc1="feb";
  5951. }
  5952. else if(month1.equals("03"))
  5953. {
  5954. mc1="mar";
  5955. }
  5956. else if(month1.equals("04"))
  5957. {
  5958. mc1="apr";
  5959. }
  5960. else if(month1.equals("05"))
  5961. {
  5962. mc1="may";
  5963. }
  5964. else if(month1.equals("06"))
  5965. {
  5966. mc1="jun";
  5967. }
  5968. else if(month1.equals("07"))
  5969. {
  5970. mc1="jul";
  5971. }
  5972. else if(month1.equals("08"))
  5973. {
  5974. mc1="aug";
  5975. }
  5976. else if(month1.equals("09"))
  5977. {
  5978. mc1="sep";
  5979. }
  5980. else if(month1.equals("10"))
  5981. {
  5982. mc1="oct";
  5983. }
  5984. else if(month1.equals("11"))
  5985. {
  5986. mc1="nov";
  5987. }
  5988. else if(month1.equals("12"))
  5989. {
  5990. mc1="dec";
  5991. }
  5992.  
  5993. String date1=day1+"-"+mc1+"-"+year1;
  5994.  
  5995. int dage=res.getInt(8);
  5996. String dgender=res.getString(9);
  5997. String ddno=res.getString(10);
  5998. String dstreet=res.getString(11);
  5999. String dcity=res.getString(12);
  6000. String dstate=res.getString(13);
  6001. String dphno=res.getString(14);
  6002. String dmob_purchased=res.getString(15);
  6003.  
  6004. if(cid.equalsIgnoreCase(dcid))
  6005. {
  6006. PreparedStatement prp=con.prepareStatement("insert into csearch values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  6007. prp.setString(1,dcid);
  6008. prp.setString(2,dcname);
  6009. prp.setString(3,date);
  6010. prp.setInt(4,dpaidamt);
  6011. prp.setInt(5,dbalamt);
  6012. prp.setInt(6,drefid);
  6013. prp.setString(7,date1);
  6014. prp.setInt(8,dage);
  6015. prp.setString(9,dgender);
  6016. prp.setString(10,ddno);
  6017. prp.setString(11,dstreet);
  6018. prp.setString(12,dcity);
  6019. prp.setString(13,dstate);
  6020. prp.setString(14,dphno);
  6021. prp.setString(15,dmob_purchased);
  6022.  
  6023. prp.executeUpdate();
  6024. rows++;
  6025. System.out.println(rows);
  6026. System.out.println("i came here");
  6027.  
  6028. a=1;
  6029.  
  6030. jTextField1.setText("");
  6031.  
  6032. }
  6033.  
  6034. }while(res.next());
  6035. if(a==0)
  6036. {
  6037. JOptionPane.showMessageDialog(null,"The customer ID does not exists");
  6038. jTextField1.setText("");
  6039. }
  6040. }
  6041. con.commit();
  6042. con.close();
  6043. }
  6044. catch(Exception e)
  6045. {
  6046. JOptionPane.showMessageDialog(null,"The error is:"+e);
  6047. }
  6048. tabledisp();
  6049. }
  6050. if(flag==1)
  6051. {
  6052. try
  6053. {
  6054. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  6055. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  6056. Statement st=con.createStatement();
  6057. st.executeUpdate("delete csearch");
  6058. res=st.executeQuery("select * from newcustomer_details");
  6059. Boolean rec=res.next();
  6060. if(rec==false)
  6061. {
  6062. JOptionPane.showMessageDialog(null,"There are no customers exists");
  6063. jTextField1.setText("");
  6064. }
  6065. else
  6066. {
  6067. do
  6068. {
  6069. String dcid=res.getString(1);
  6070. String dcname=res.getString(2);
  6071.  
  6072. java.sql.Date dt=res.getDate(3);
  6073. String dd=dt.toString();
  6074. String year=dd.substring(0,4);
  6075. String month=dd.substring(5,7);
  6076. String day=dd.substring(8,10);
  6077. String mc="";
  6078. if(month.equals("01"))
  6079. {
  6080. mc="jan";
  6081. }
  6082. else if(month.equals("02"))
  6083. {
  6084. mc="feb";
  6085. }
  6086. else if(month.equals("03"))
  6087. {
  6088. mc="mar";
  6089. }
  6090. else if(month.equals("04"))
  6091. {
  6092. mc="apr";
  6093. }
  6094. else if(month.equals("05"))
  6095. {
  6096. mc="may";
  6097. }
  6098. else if(month.equals("06"))
  6099. {
  6100. mc="jun";
  6101. }
  6102. else if(month.equals("07"))
  6103. {
  6104. mc="jul";
  6105. }
  6106. else if(month.equals("08"))
  6107. {
  6108. mc="aug";
  6109. }
  6110. else if(month.equals("09"))
  6111. {
  6112. mc="sep";
  6113. }
  6114. else if(month.equals("10"))
  6115. {
  6116. mc="oct";
  6117. }
  6118. else if(month.equals("11"))
  6119. {
  6120. mc="nov";
  6121. }
  6122. else if(month.equals("12"))
  6123. {
  6124. mc="dec";
  6125. }
  6126. String date=day+"-"+mc+"-"+year;
  6127.  
  6128. int dpaidamt=res.getInt(4);
  6129. int dbalamt=res.getInt(5);
  6130. int drefid=res.getInt(6);
  6131.  
  6132. java.sql.Date dob=res.getDate(7);
  6133.  
  6134. String ddob=dob.toString();
  6135. String year1=ddob.substring(0,4);
  6136. String month1=ddob.substring(5,7);
  6137. String day1=ddob.substring(8,10);
  6138.  
  6139. String mc1="";
  6140. if(month1.equals("01"))
  6141. {
  6142. mc1="jan";
  6143. }
  6144. else if(month1.equals("02"))
  6145. {
  6146. mc1="feb";
  6147. }
  6148. else if(month1.equals("03"))
  6149. {
  6150. mc1="mar";
  6151. }
  6152. else if(month1.equals("04"))
  6153. {
  6154. mc1="apr";
  6155. }
  6156. else if(month1.equals("05"))
  6157. {
  6158. mc1="may";
  6159. }
  6160. else if(month1.equals("06"))
  6161. {
  6162. mc1="jun";
  6163. }
  6164. else if(month1.equals("07"))
  6165. {
  6166. mc1="jul";
  6167. }
  6168. else if(month1.equals("08"))
  6169. {
  6170. mc1="aug";
  6171. }
  6172. else if(month1.equals("09"))
  6173. {
  6174. mc1="sep";
  6175. }
  6176. else if(month1.equals("10"))
  6177. {
  6178. mc1="oct";
  6179. }
  6180. else if(month1.equals("11"))
  6181. {
  6182. mc1="nov";
  6183. }
  6184. else if(month1.equals("12"))
  6185. {
  6186. mc1="dec";
  6187. }
  6188.  
  6189. String date1=day1+"-"+mc1+"-"+year1;
  6190.  
  6191. int dage=res.getInt(8);
  6192. String dgender=res.getString(9);
  6193. String ddno=res.getString(10);
  6194. String dstreet=res.getString(11);
  6195. String dcity=res.getString(12);
  6196. String dstate=res.getString(13);
  6197. String dphno=res.getString(14);
  6198. String dmob_purchased=res.getString(15);
  6199.  
  6200. if(cid.equals(dcname))
  6201. {
  6202. PreparedStatement prp=con.prepareStatement("insert into csearch values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  6203. prp.setString(1,dcid);
  6204. prp.setString(2,dcname);
  6205. prp.setString(3,date);
  6206. prp.setInt(4,dpaidamt);
  6207. prp.setInt(5,dbalamt);
  6208. prp.setInt(6,drefid);
  6209. prp.setString(7,date1);
  6210. prp.setInt(8,dage);
  6211. prp.setString(9,dgender);
  6212. prp.setString(10,ddno);
  6213. prp.setString(11,dstreet);
  6214. prp.setString(12,dcity);
  6215. prp.setString(13,dstate);
  6216. prp.setString(14,dphno);
  6217. prp.setString(15,dmob_purchased);
  6218.  
  6219. prp.executeUpdate();
  6220. rows++;
  6221. System.out.println(rows);
  6222. System.out.println("i came here");
  6223.  
  6224. b=1;
  6225.  
  6226. jTextField1.setText("");
  6227.  
  6228. }
  6229.  
  6230. }while(res.next());
  6231. if(b==0)
  6232. {
  6233. JOptionPane.showMessageDialog(null,"The customer Name does not exists");
  6234. jTextField1.setText("");
  6235. }
  6236. }
  6237. con.commit();
  6238. con.close();
  6239. }
  6240. catch(Exception e)
  6241. {
  6242. JOptionPane.showMessageDialog(null,"The error is:"+e);
  6243. }
  6244. tabledisp();
  6245. }
  6246. }
  6247.  
  6248. }
  6249.  
  6250. private void jTextField1FocusGained(java.awt.event.FocusEvent evt) {
  6251. // TODO add your handling code here:
  6252. jsp.setVisible(false);
  6253. a=0;
  6254. b=0;
  6255. }
  6256.  
  6257. private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  6258. // TODO add your handling code here:
  6259. flag=0;
  6260. }
  6261.  
  6262. private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  6263. // TODO add your handling code here:
  6264. flag=1;
  6265. }
  6266.  
  6267. /**
  6268. * @param args the command line arguments
  6269. */
  6270. public static void main(String args[]) {
  6271. java.awt.EventQueue.invokeLater(new Runnable() {
  6272. public void run() {
  6273. new SearchCustomer().setVisible(true);
  6274. }
  6275. });
  6276. }
  6277.  
  6278. // Variables declaration - do not modify
  6279. private javax.swing.JButton jButton1;
  6280. private javax.swing.JButton jButton2;
  6281. private javax.swing.JLabel jLabel1;
  6282. private javax.swing.JLabel jLabel2;
  6283. private javax.swing.JLabel jLabel3;
  6284. private javax.swing.JPanel jPanel1;
  6285. private javax.swing.JPanel jPanel2;
  6286. private javax.swing.JRadioButton jRadioButton1;
  6287. private javax.swing.JRadioButton jRadioButton2;
  6288. private javax.swing.JTextField jTextField1;
  6289. // End of variables declaration
  6290.  
  6291. }
  6292.  
  6293.  
  6294.  
  6295.  
  6296. Code for SalesReports Page:
  6297.  
  6298.  
  6299.  
  6300. /*
  6301. * To change this template, choose Tools | Templates
  6302. * and open the template in the editor.
  6303. */
  6304.  
  6305. /*
  6306. * SalesReports.java
  6307. *
  6308. * Created on Nov 15, 2010, 1:27:07 AM
  6309. */
  6310.  
  6311. package mobilestorenew;
  6312.  
  6313. import java.awt.Font;
  6314. import java.awt.Graphics;
  6315. import java.awt.Graphics2D;
  6316. import java.awt.print.*;
  6317. import java.sql.*;
  6318. import javax.swing.*;
  6319.  
  6320.  
  6321.  
  6322. /**
  6323. *
  6324. * @author Ramesh
  6325. */
  6326. public class SalesReports extends javax.swing.JFrame implements Printable {
  6327.  
  6328. /** Creates new form SalesReports */
  6329. String text="";
  6330. int a=0,flag;
  6331. int countsales=0,totalamt=0;
  6332. public SalesReports() {
  6333. initComponents();
  6334. setSize(1270,740);
  6335. setTitle("Sales Reports");
  6336. jTextArea1.setEditable(false);
  6337. setVisible(true);
  6338.  
  6339. }
  6340.  
  6341. /** This method is called from within the constructor to
  6342. * initialize the form.
  6343. * WARNING: Do NOT modify this code. The content of this method is
  6344. * always regenerated by the Form Editor.
  6345. */
  6346. @SuppressWarnings("unchecked")
  6347. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  6348. private void initComponents() {
  6349.  
  6350. jLabel1 = new javax.swing.JLabel();
  6351. jButton1 = new javax.swing.JButton();
  6352. jButton2 = new javax.swing.JButton();
  6353. jScrollPane1 = new javax.swing.JScrollPane();
  6354. jTextArea1 = new javax.swing.JTextArea();
  6355. jComboBox1 = new javax.swing.JComboBox();
  6356. jLabel2 = new javax.swing.JLabel();
  6357. jLabel3 = new javax.swing.JLabel();
  6358. jComboBox2 = new javax.swing.JComboBox();
  6359. jButton3 = new javax.swing.JButton();
  6360.  
  6361. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  6362. getContentPane().setLayout(null);
  6363.  
  6364. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
  6365. jLabel1.setText("Sales Reports");
  6366. getContentPane().add(jLabel1);
  6367. jLabel1.setBounds(430, 10, 320, 40);
  6368.  
  6369. jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
  6370. jButton1.setText("Print");
  6371. jButton1.addActionListener(new java.awt.event.ActionListener() {
  6372. public void actionPerformed(java.awt.event.ActionEvent evt) {
  6373. jButton1ActionPerformed(evt);
  6374. }
  6375. });
  6376. getContentPane().add(jButton1);
  6377. jButton1.setBounds(400, 610, 110, 50);
  6378.  
  6379. jButton2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  6380. jButton2.setText("Close");
  6381. jButton2.addActionListener(new java.awt.event.ActionListener() {
  6382. public void actionPerformed(java.awt.event.ActionEvent evt) {
  6383. jButton2ActionPerformed(evt);
  6384. }
  6385. });
  6386. getContentPane().add(jButton2);
  6387. jButton2.setBounds(550, 610, 100, 50);
  6388.  
  6389. jTextArea1.setColumns(20);
  6390. jTextArea1.setEditable(false);
  6391. jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  6392. jTextArea1.setRows(5);
  6393. jTextArea1.setTabSize(10);
  6394. jScrollPane1.setViewportView(jTextArea1);
  6395.  
  6396. getContentPane().add(jScrollPane1);
  6397. jScrollPane1.setBounds(70, 140, 910, 440);
  6398.  
  6399. jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
  6400. getContentPane().add(jComboBox1);
  6401. jComboBox1.setBounds(280, 80, 100, 30);
  6402.  
  6403. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  6404. jLabel2.setText("Select Month");
  6405. getContentPane().add(jLabel2);
  6406. jLabel2.setBounds(160, 80, 100, 30);
  6407.  
  6408. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  6409. jLabel3.setText("Select Year");
  6410. getContentPane().add(jLabel3);
  6411. jLabel3.setBounds(420, 80, 90, 30);
  6412.  
  6413. 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" }));
  6414. getContentPane().add(jComboBox2);
  6415. jComboBox2.setBounds(520, 80, 100, 30);
  6416.  
  6417. jButton3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  6418. jButton3.setText("Generate Report");
  6419. jButton3.addActionListener(new java.awt.event.ActionListener() {
  6420. public void actionPerformed(java.awt.event.ActionEvent evt) {
  6421. jButton3ActionPerformed(evt);
  6422. }
  6423. });
  6424. getContentPane().add(jButton3);
  6425. jButton3.setBounds(720, 70, 160, 50);
  6426.  
  6427. pack();
  6428. }// </editor-fold>
  6429.  
  6430. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  6431. // TODO add your handling code here:
  6432. jButton1.setVisible(false);
  6433. jButton2.setVisible(false);
  6434. jButton3.setVisible(false);
  6435. PrinterJob printJob = PrinterJob.getPrinterJob();
  6436.  
  6437. if (printJob.printDialog())
  6438. {
  6439. try
  6440. {
  6441. printJob.print();
  6442. printJob.setCopies(1);
  6443.  
  6444. }
  6445. catch(Exception PrintException)
  6446. {
  6447. PrintException.printStackTrace();
  6448. }
  6449. printJob.cancel();
  6450. }
  6451. printJob.cancel();
  6452. jButton1.setVisible(true);
  6453. jButton2.setVisible(true);
  6454. jButton3.setVisible(true);
  6455. }
  6456.  
  6457. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  6458. // TODO add your handling code here:
  6459. dispose();
  6460. }
  6461.  
  6462. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  6463. // TODO add your handling code here:
  6464. jTextArea1.setText("");
  6465. text="";
  6466. a=0;
  6467. String month=(String)jComboBox1.getSelectedItem();
  6468. String year=(String)jComboBox2.getSelectedItem();
  6469.  
  6470. try
  6471. {
  6472. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  6473. Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
  6474. Statement st=con.createStatement();
  6475. ResultSet res=st.executeQuery("select * from newbill");
  6476. Boolean rec=res.next();
  6477. if(rec==false)
  6478. {
  6479. JOptionPane.showMessageDialog(null,"There are no sales on that month");
  6480. }
  6481. else
  6482. {
  6483. if(flag==0)
  6484. {
  6485. do
  6486. {
  6487. String dbid = res.getString(1);
  6488. java.sql.Date dbdate = res.getDate(2);
  6489. String bdate = dbdate.toString();
  6490. String dmonth=bdate.substring(5,7);
  6491. String dyear=bdate.substring(0,4);
  6492. String mc1="";
  6493. if (dmonth.equals("01"))
  6494. {
  6495. mc1 = "jan";
  6496. }
  6497. else if (dmonth.equals("02"))
  6498. {
  6499. mc1 = "feb";
  6500. } else if (dmonth.equals("03"))
  6501. {
  6502. mc1 = "mar";
  6503. } else if (dmonth.equals("04"))
  6504. {
  6505. mc1 = "apr";
  6506. } else if (dmonth.equals("05"))
  6507. {
  6508. mc1 = "may";
  6509. } else if (dmonth.equals("06"))
  6510. {
  6511. mc1 = "jun";
  6512. } else if (dmonth.equals("07"))
  6513. {
  6514. mc1 = "jul";
  6515. } else if (dmonth.equals("08"))
  6516. {
  6517. mc1 = "aug";
  6518. } else if (dmonth.equals("09"))
  6519. {
  6520. mc1 = "sep";
  6521. } else if (dmonth.equals("10"))
  6522. {
  6523. mc1 = "oct";
  6524. } else if (dmonth.equals("11"))
  6525. {
  6526. mc1 = "nov";
  6527. } else if (dmonth.equals("12"))
  6528. {
  6529. mc1 = "dec";
  6530. }
  6531.  
  6532. String dcname = res.getString(3);
  6533. int dprice = res.getInt(4);
  6534. int damtpaid = res.getInt(5);
  6535. String mob_purchased = res.getString(7);
  6536.  
  6537. if(mc1.equalsIgnoreCase(month) && dyear.equalsIgnoreCase(year))
  6538. {
  6539. countsales++;
  6540. totalamt+=damtpaid;
  6541. text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
  6542. jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
  6543. "-----------------------------------------------------------------------------------------------------" +
  6544. "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
  6545. "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
  6546. a=1;
  6547. countsales=0;
  6548. totalamt=0;
  6549. }
  6550. }while(res.next());
  6551.  
  6552. }
  6553. if(flag==1)
  6554. {
  6555. do
  6556. {
  6557. String dbid = res.getString(1);
  6558. java.sql.Date dbdate = res.getDate(2);
  6559. String bdate = dbdate.toString();
  6560. String dyear=bdate.substring(0,4);
  6561. String dcname = res.getString(3);
  6562. int dprice = res.getInt(4);
  6563. int damtpaid = res.getInt(5);
  6564. String mob_purchased = res.getString(7);
  6565. if(dyear.equalsIgnoreCase(year))
  6566. {
  6567.  
  6568. countsales++;
  6569. totalamt+=damtpaid;
  6570. text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
  6571. jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
  6572. "-----------------------------------------------------------------------------------------------------" +
  6573. "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
  6574. "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
  6575. countsales=0;
  6576. totalamt=0;
  6577. a=1;
  6578. }
  6579.  
  6580. }
  6581. while(res.next());
  6582.  
  6583. }
  6584. if(a==0)
  6585. {
  6586. JOptionPane.showMessageDialog(null,"There are no sales on that particular month");
  6587. jTextArea1.setText("");
  6588. }
  6589. }
  6590. }
  6591. catch(Exception e)
  6592. {
  6593. JOptionPane.showMessageDialog(null,"The error is:"+e);
  6594. }
  6595.  
  6596.  
  6597. }
  6598. public int print(Graphics g, PageFormat pf, int pi) throws PrinterException
  6599. {
  6600. Graphics2D g2 = (Graphics2D) g;
  6601. g2.translate(pf.getImageableX()+5, pf.getImageableY()+5);
  6602. Font f = new Font("Monospaced",Font.PLAIN,12);
  6603. g2.setFont (f);
  6604. paint (g2);
  6605. return Printable.PAGE_EXISTS;
  6606. }
  6607. /**
  6608. * @param args the command line arguments
  6609. */
  6610. public static void main(String args[]) {
  6611. java.awt.EventQueue.invokeLater(new Runnable() {
  6612. public void run() {
  6613. new SalesReports().setVisible(true);
  6614. }
  6615. });
  6616. }
  6617.  
  6618. // Variables declaration - do not modify
  6619. private javax.swing.JButton jButton1;
  6620. private javax.swing.JButton jButton2;
  6621. public javax.swing.JButton jButton3;
  6622. public javax.swing.JComboBox jComboBox1;
  6623. public javax.swing.JComboBox jComboBox2;
  6624. public javax.swing.JLabel jLabel1;
  6625. public javax.swing.JLabel jLabel2;
  6626. public javax.swing.JLabel jLabel3;
  6627. public javax.swing.JScrollPane jScrollPane1;
  6628. public javax.swing.JTextArea jTextArea1;
  6629. // End of variables declaration
  6630.  
  6631. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement