API tools faq
paste
Guest User

Untitled

a guest
Mar 1st, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 59.77 KB | None | 0 0
raw download clone embed print report
  1. import java.awt.*;
  2. import java.awt.event.*;
  3. import javax.swing.*;
  4. import java.sql.*;
  5. import javax.swing.table.*;
  6. public class Student extends JFrame
  7. {
  8. //Declaring Variables
  9. boolean inAnApplet = true;
  10. final boolean shouldFill = true;
  11. final boolean shouldWeightX = true;
  12.  
  13. //Welcome panel TAB
  14. final static String panelstr0 = " Welcome ";
  15.  
  16. //Login panel TAB
  17. final static String panelstr1 = " LOGIN ";
  18.  
  19. //Student Detail panel TAB
  20. final static String panelstr2 = " ADD STUDENT DETAILS ";
  21.  
  22. //Modify or Delete Student Details panel TAB
  23. final static String panelstr3 = " MODIFY / DELETE STUDENT DETAILS ";
  24.  
  25. //View Report
  26. final static String panelstr4 = " VIEW ";
  27.  
  28.  
  29. //Applying courier new fonts for the controls used
  30. Font dFont = new Font("courier new",Font.PLAIN,12);
  31. Font tFont = new Font("courier new",Font.BOLD,14);
  32.  
  33. //Applying listners for handling radio button events
  34. RadioListener alistener = new RadioListener();
  35.  
  36. //Applying listners for handling check box events
  37. CheckBoxListener ckblistener = new CheckBoxListener();
  38.  
  39. //Applying listners for handling combo box events
  40. ComboBoxListener cmblistener = new ComboBoxListener();
  41.  
  42. //Applying gridbag layout
  43. GridBagLayout grid = new GridBagLayout();
  44. GridBagConstraints gbc1 = new GridBagConstraints();
  45. GridBagConstraints gbc2 = new GridBagConstraints();
  46. GridBagConstraints gbc3 = new GridBagConstraints();
  47. GridBagConstraints gbc4 = new GridBagConstraints();
  48.  
  49. //Dialog Box to ask delete confirmation messages
  50. Container cpane = getContentPane();
  51. JDialog dlg = new JDialog((Frame) null, " Delete Confirmation!!!", true);
  52. Container dlgCPane = dlg.getContentPane();
  53.  
  54. //Grouping the Radio Buttons
  55. ButtonGroup bg1 = new ButtonGroup();
  56. ButtonGroup bg2 = new ButtonGroup();
  57. ButtonGroup bg3 = new ButtonGroup();
  58.  
  59. // Declaring the Labels
  60. JLabel jwelcome, jlogin, jpass, jstudentname, jpreaddress, jpermaaddress, jfathername, jgender, jcourse, jyear, jlabel, jdob, jfatheroccupation, jphone,jlabel111;
  61. JLabel jmstudentname, jmpreaddress, jmpermaaddress, jmfathername, jmgender, jmcourse, jmyear, jmlabel, jmdob, jmfatheroccupation, jmphone;
  62. JLabel jLabeldlg = new JLabel("Are you sure?");
  63.  
  64. // Declaring the Radio buttons
  65. JRadioButton male, female, m_male, m_female;
  66.  
  67. // Declaring the Check boxes
  68. JCheckBox dmc, degree, charcerti, ncc, mdmc, mdegree, mcharcerti, mncc;
  69. JCheckBox ckstudentID, ckstudentname, ckpreaddress, ckpermaaddress, ckfathername, ckgender, ckdob;
  70.  
  71. // Declaring the combo boxes
  72. JComboBox cb_course, cb_year ,mcb_course, mcb_year, cb_sname, cb_fatheroccupation, mcb_fatheroccupation, scb_gender, scb_course;
  73. JComboBox jstudID, jeq;
  74.  
  75. // Declaring the text boxes
  76. JTextField tlogname, tsname, tspreaddress, tspermaaddress, tsphone, tsdob, tsfathername, tsfatheroccupation;
  77. JPasswordField tlogpass = new JPasswordField(40);
  78. JTextField tmname, tmpreaddress, tmpermaaddress, tmphone, tmdob, tmfathername, tmfatheroccupation;
  79.  
  80. // Declaring the String type variables
  81. String driver="sun.jdbc.odbc.JdbcOdbcDriver";
  82. String url="jdbc:odbc:student";
  83. String title_dialog = "Student Record Added";
  84. String fail_dialog = "Login Error";
  85. String add_dialog = "Database Record Added";
  86. String modify_dialog = "Database Record Updated";
  87. String del_dialog = "Database Record Deleted";
  88. String gender = "male";
  89. String year = "I Year";
  90. String course = "BSc(Comp. Sc.)";
  91. String foccupation = "Govt. Employee";
  92. String currentname = "";
  93. String tempname = "";
  94. String qry = "";
  95. String condsel="No Condition", studID="StudentID", eq="=";
  96. String query1, query2, query3, query4, query5, query6, query7, message_dialog, nsel, selname, reg_no,str;
  97.  
  98. //Declaring the Integer type variables
  99. int dmcsel, degreesel, charcfsel, ncccfsel, mdmcsel, mdegreesel, mcharcfsel, mnccsel;
  100. int type_dialog = JOptionPane.PLAIN_MESSAGE;
  101. int ctr_val=0,selstudentID=0,selstudentname=0,selstudentpreadd=0, selstudentpermaadd, selfathername=0,selgender=0, seldob=0;
  102.  
  103. //Declaring the JPanel & Tabbed panes
  104. JPanel pan0, pan1, pan2, pan3, pan4, pan5;
  105. JTabbedPane tbPane = new JTabbedPane();
  106.  
  107. // Declaring the Submit Buttons
  108. JButton delit = new JButton("YES");
  109. JButton delno = new JButton("NO");
  110. JButton login, cont, save, mod_button, del, scb_button;
  111.  
  112. //Building JTable for student reports
  113. Object[] data = new Object[5];
  114. DefaultTableModel defaulttablemodel = new DefaultTableModel();
  115. JTable jtable = new JTable(defaulttablemodel);
  116.  
  117. //Starting with the main() method
  118. public static void main(String args[])
  119. {
  120. Student stud = new Student();
  121. }
  122. //------------------------- Ending with the main() method -----------------
  123.  
  124. //========================= Starting with the Student constructor =========
  125. public Student()
  126. {
  127. // Declaring title for the application
  128. super("1111111");
  129. setUp();
  130. //pack();
  131. //addWindowListener(new WindowEventHandler());
  132. setSize(640,480);
  133. show();
  134. }
  135. //--------------------------Ending with the Student Constructor--------------
  136.  
  137. //Starting the setUp() method to create the File menu on panel
  138. void setUp()
  139. {
  140. setUpMenuBar(); //Calling the setUpMenuBar() to create the Exit Menu item
  141. displayPanel0(); //Calling a method that creates a panel and displays the Exit menu item
  142. cpane.add(tbPane, BorderLayout.CENTER);
  143. }
  144. //------------Ending with the setUp() method---------
  145.  
  146. //-----------Starting with the setUpMenuBar() method to create File menu
  147. void setUpMenuBar()
  148. {
  149. MenuBar mBar = new MenuBar();
  150. Menu mfile = new Menu("File");
  151. // Creating the Exit menu item
  152. MenuItem xfile = new MenuItem("Exit");
  153. // Handling this menu item on click event to Exit
  154. xfile.addActionListener(new MenuItemHandler());
  155. mfile.add(xfile);
  156. mBar.add(mfile);
  157. setMenuBar(mBar);
  158. }
  159. //--------------------------Ending with the setUpMenuBar() method--------------
  160.  
  161. //-----------Starting with the displayPanel0() method to create the Welcome panel
  162.  
  163. void displayPanel0()
  164. {
  165. pan0 = new JPanel(); //Creating a Welcome Panel
  166. pan0.setFont(tFont);
  167. pan0.setLayout(grid);
  168. jwelcome = new JLabel("STUDENT INFORMATION SYSTEM ");
  169. Font f = new Font("Helvetica", Font.BOLD + Font.ITALIC, 30);
  170. jwelcome.setFont(f);
  171. pan0.add(jwelcome);
  172.  
  173. cont = new JButton("Click to Continue");
  174. gbc1.ipady = 1;
  175. gbc1.ipadx = 1;
  176. gbc1.gridx = 0;
  177. gbc1.gridy = 3;
  178. grid.setConstraints(cont, gbc1);
  179. pan0.add(cont);
  180. cont.addActionListener(new ButtonHandler());
  181. tbPane.addTab(panelstr0, pan0);
  182. }
  183. //--------------------------Ending with the displayPanel0() method--------------
  184.  
  185. //-----------Starting with the displayPanel1() method to create the Login panel
  186.  
  187. void displayPanel1()
  188. {
  189. pan1 = new JPanel(); //LOGIN TAB
  190. pan1.setFont(tFont);
  191. pan1.setLayout(grid);
  192. jlogin = new JLabel("Login Name ");
  193. jlogin.setFont(dFont);// Make this Data Font that we declared before
  194. //gbc1.weightx = 0.0; //Horizontal Space not required here
  195. gbc1.weighty = 0.0; //Vertical Space
  196. gbc1.ipady = 2; //Height of Component
  197. gbc1.ipadx = 2; //Width of Component
  198. gbc1.anchor = GridBagConstraints.WEST;
  199. gbc1.gridwidth = 1; //1 columns wide
  200. gbc1.gridx = 0; //aligned with login 0 -- Very Important
  201. gbc1.gridy = 0; //0th Row
  202. // Adding all these features to this Label, jlogin
  203. grid.setConstraints(jlogin, gbc1);
  204. // Adding the Label "jlogin" onto the LOGIN TAB
  205. pan1.add(jlogin);
  206. tlogname = new JTextField(20);
  207. gbc1.ipady = 2;
  208. gbc1.ipadx = 2;
  209. gbc1.weighty = 0.0;
  210. gbc1.anchor = GridBagConstraints.WEST;
  211. gbc1.gridwidth = 5;
  212. gbc1.gridx = 1;
  213. gbc1.gridy = 0;
  214. grid.setConstraints(tlogname, gbc1);
  215. pan1.add(tlogname);
  216. jpass = new JLabel("Password");
  217. jpass.setFont(dFont);
  218. gbc1.ipady = 2;
  219. gbc1.ipadx = 2;
  220. gbc1.weighty = 0.0;
  221. gbc1.anchor = GridBagConstraints.WEST;
  222. gbc1.gridwidth = 5;
  223. gbc1.gridx = 0;
  224. gbc1.gridy = 1;
  225. grid.setConstraints(jpass, gbc1);
  226. pan1.add(jpass);
  227. tlogpass = new JPasswordField(20);
  228. gbc1.ipady = 2;
  229. gbc1.ipadx = 2;
  230. gbc1.weighty = 0.0;
  231. gbc1.anchor = GridBagConstraints.WEST;
  232. gbc1.gridwidth = 2;
  233. gbc1.gridx = 1;
  234. gbc1.gridy = 1;
  235. grid.setConstraints(tlogpass, gbc1);
  236. pan1.add(tlogpass);
  237. login = new JButton("LOGIN");
  238. gbc1.ipady = 2;
  239. gbc1.ipadx = 2;
  240. gbc1.weighty = 0.0;
  241. gbc1.anchor = GridBagConstraints.CENTER;
  242. gbc1.gridwidth = 1;
  243. gbc1.gridx = 1;
  244. gbc1.gridy = 2;
  245. grid.setConstraints(login, gbc1);
  246. pan1.add(login);
  247. login.addActionListener(new ButtonHandler());
  248. tbPane.addTab(panelstr1, pan1);
  249. }
  250. //------------------------------------------------------------ Ending with displayPanel1() method -----------
  251. //============================================================ Starting with displayPanel2() method ===========
  252. void displayPanel2() //ADD STUDENT DETAILS TAB
  253. {
  254. pan2 = new JPanel();
  255. pan2.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),""));
  256. pan2.setLayout(grid);
  257. jstudentname = new JLabel("Student Name");
  258. jstudentname.setFont(dFont);
  259. gbc1.fill = GridBagConstraints.BOTH;
  260. gbc1.ipady = 2;
  261. gbc1.ipadx = 2;
  262. gbc1.gridx = 0;
  263. gbc1.gridy = 1;
  264. grid.setConstraints(jstudentname, gbc1);
  265. pan2.add(jstudentname);
  266. tsname = new JTextField(20);
  267. gbc1.ipady = 2;
  268. gbc1.ipadx = 2;
  269. gbc1.gridx = 1;
  270. gbc1.gridy = 1;
  271. grid.setConstraints(tsname, gbc1);
  272. pan2.add(tsname);
  273. jdob = new JLabel("Date of Birth");
  274. jdob.setFont(dFont);
  275. gbc1.ipady = 2;
  276. gbc1.ipadx = 2;
  277. gbc1.gridx = 0;
  278. gbc1.gridy = 2;
  279. grid.setConstraints(jdob, gbc1);
  280. pan2.add(jdob);
  281. tsdob = new JTextField(20);
  282. gbc1.ipady = 2;
  283. gbc1.ipadx = 2;
  284. gbc1.gridx = 1;
  285. gbc1.gridy = 2;
  286. grid.setConstraints(tsdob, gbc1);
  287. pan2.add(tsdob);
  288. jfathername = new JLabel("Father Name");
  289. jfathername.setFont(dFont);
  290. gbc1.ipady = 2;
  291. gbc1.ipadx = 2;
  292. gbc1.gridx = 0;
  293. gbc1.gridy = 3;
  294. grid.setConstraints(jfathername, gbc1);
  295. pan2.add(jfathername);
  296. tsfathername = new JTextField(20);
  297. gbc1.ipady = 2;
  298. gbc1.ipadx = 2;
  299. gbc1.gridx = 1;
  300. gbc1.gridy = 3;
  301. grid.setConstraints(tsfathername, gbc1);
  302. pan2.add(tsfathername);
  303. jfatheroccupation = new JLabel("Father Occupation");
  304. jfatheroccupation.setFont(dFont);
  305. gbc1.ipady = 2;
  306. gbc1.ipadx = 2;
  307. gbc1.gridx = 0;
  308. gbc1.gridy = 4;
  309. grid.setConstraints(jfatheroccupation, gbc1);
  310. pan2.add(jfatheroccupation);
  311. cb_fatheroccupation = new JComboBox();
  312. cb_fatheroccupation.setFont(dFont);
  313. // Adding Elements to combo box
  314. cb_fatheroccupation.addItem(" Govt. Employee ");
  315. cb_fatheroccupation.addItem(" Self Employed ");
  316. cb_fatheroccupation.addItem(" Business ");
  317. gbc1.fill = GridBagConstraints.BOTH;
  318. gbc1.insets = new Insets(10,0,0,30);
  319. gbc1.ipady = 2;
  320. gbc1.ipadx = 2;
  321. gbc1.gridx = 1;
  322. gbc1.gridy = 4;
  323. cb_fatheroccupation.addItemListener(new ComboBoxListener());
  324. grid.setConstraints(cb_fatheroccupation, gbc1);
  325. pan2.add(cb_fatheroccupation);
  326. jpreaddress = new JLabel("Present Address");
  327. jpreaddress.setFont(dFont);
  328. gbc1.ipady = 2;
  329. gbc1.ipadx = 2;
  330. gbc1.gridx = 0;
  331. gbc1.gridy = 5;
  332. grid.setConstraints(jpreaddress, gbc1);
  333. pan2.add(jpreaddress);
  334. tspreaddress = new JTextField(20);
  335. gbc1.ipady = 2;
  336. gbc1.ipadx = 2;
  337. gbc1.gridx = 1;
  338. gbc1.gridy = 5;
  339. grid.setConstraints(tspreaddress, gbc1);
  340. pan2.add(tspreaddress);
  341. jpermaaddress = new JLabel("Permanent Address");
  342. jpermaaddress.setFont(dFont);
  343. gbc1.ipady = 2;
  344. gbc1.ipadx = 2;
  345. gbc1.gridx = 0;
  346. gbc1.gridy = 6;
  347. grid.setConstraints(jpermaaddress, gbc1);
  348. pan2.add(jpermaaddress);
  349. tspermaaddress = new JTextField(20);
  350. gbc1.ipady = 2;
  351. gbc1.ipadx = 2;
  352. gbc1.gridx = 1;
  353. gbc1.gridy = 6;
  354. grid.setConstraints(tspermaaddress, gbc1);
  355. pan2.add(tspermaaddress);
  356. jphone = new JLabel(" Telephone Number ");
  357. jphone.setFont(dFont);
  358. gbc1.ipady = 2;
  359. gbc1.ipadx = 2;
  360. gbc1.gridx = 0;
  361. gbc1.gridy = 7;
  362. grid.setConstraints(jphone, gbc1);
  363. pan2.add(jphone);
  364. tsphone = new JTextField(20);
  365. gbc1.ipady = 2;
  366. gbc1.ipadx = 2;
  367. gbc1.gridx = 1;
  368. gbc1.gridy = 7;
  369. grid.setConstraints(tsphone, gbc1);
  370. pan2.add(tsphone);
  371. // Checking the default gender as male by using 'true'
  372. jgender = new JLabel("Gender");
  373. jgender.setFont(dFont);
  374. gbc1.ipady = 2;
  375. gbc1.ipadx = 2;
  376. gbc1.gridx = 0;
  377. gbc1.gridy = 8;
  378. grid.setConstraints(jgender, gbc1);
  379. pan2.add(jgender);
  380. male = new JRadioButton("Male",true);
  381. male.setFont(dFont);
  382. gbc1.fill = GridBagConstraints.BOTH;
  383. gbc1.ipady = 2;
  384. gbc1.ipadx = 2;
  385. gbc1.gridx = 1;
  386. gbc1.gridy = 8;
  387. grid.setConstraints(male, gbc1);
  388. male.addActionListener(new RadioListener());
  389. bg1.add(male);
  390. pan2.add(male);
  391. female = new JRadioButton("Female",false);
  392. female.setFont(dFont);
  393. gbc1.fill = GridBagConstraints.BOTH;
  394. gbc1.ipady = 2;
  395. gbc1.ipadx = 2;
  396. gbc1.gridx = 2;
  397. gbc1.gridy = 8;
  398. grid.setConstraints(female, gbc1);
  399. female.addActionListener(new RadioListener());
  400. bg1.add(female);
  401. pan2.add(female);
  402. jcourse = new JLabel(" Course ");
  403. jcourse.setFont(dFont);
  404. gbc1.ipady = 2;
  405. gbc1.ipadx = 2;
  406. gbc1.gridx = 0;
  407. gbc1.gridy = 9;
  408. grid.setConstraints(jcourse, gbc1);
  409. pan2.add(jcourse);
  410. cb_course = new JComboBox();
  411. // Applying Fonts inside the combo box as courier new
  412. cb_course.setFont(dFont);
  413. // Adding the elements to combo box
  414. cb_course.addItem("BSc(Comp.Sc.)");
  415. cb_course.addItem("BCA");
  416. cb_course.addItem("MCA");
  417. cb_course.addItem("MSc");
  418. cb_course.addItem("BE");
  419. cb_course.addItem("ME");
  420. // Filling it align properly with other Elements inside the TAB
  421. gbc1.fill = GridBagConstraints.BOTH;
  422. gbc1.insets = new Insets(10,0,0,30);
  423. gbc1.ipady = 2;
  424. gbc1.ipadx = 2;
  425. gbc1.gridx = 1;
  426. gbc1.gridy = 9;
  427. cb_course.addItemListener(new ComboBoxListener());
  428. grid.setConstraints(cb_course, gbc1);
  429. pan2.add(cb_course);
  430. cb_year = new JComboBox();
  431. cb_year.setFont(dFont);
  432. // Adding the combo box elements to combo box
  433. cb_year.addItem(" A+ ");
  434. cb_year.addItem(" B+ ");
  435. cb_year.addItem(" C+ ");
  436.  
  437. cb_year.addItem(" A ");
  438. cb_year.addItem(" B ");
  439. cb_year.addItem(" C ");
  440.  
  441. cb_year.addItem(" A- ");
  442. cb_year.addItem(" B- ");
  443. cb_year.addItem(" C- ");
  444.  
  445.  
  446. gbc1.fill = GridBagConstraints.BOTH;
  447. gbc1.insets = new Insets(10,0,0,30);
  448. gbc1.ipady = 2;
  449. gbc1.ipadx = 2;
  450. gbc1.gridx = 2;
  451. gbc1.gridy = 9;
  452. cb_year.addItemListener(new ComboBoxListener());
  453. grid.setConstraints(cb_year, gbc1);
  454. pan2.add(cb_year);
  455. dmc = new JCheckBox("Detail Mark Sheet Given");
  456. //Using check boxes
  457. gbc1.fill = GridBagConstraints.BOTH;
  458. gbc1.ipady = 0;
  459. gbc1.ipadx = 0;
  460. gbc1.gridx = 1;
  461. gbc1.gridy = 10;
  462. grid.setConstraints(dmc, gbc1);
  463. dmc.setFont(dFont);
  464. dmc.addItemListener(new CheckBoxListener());
  465. pan2.add(dmc);
  466. degree = new JCheckBox("Degree Awarded");
  467. gbc1.ipady = 0;
  468. gbc1.ipadx = 0;
  469. gbc1.gridx = 2;
  470. gbc1.gridy = 10;
  471. grid.setConstraints(degree, gbc1);
  472. degree.setFont(dFont);
  473. degree.addItemListener(new CheckBoxListener());
  474. pan2.add(degree);
  475. charcerti = new JCheckBox("Character Certificate Given ");
  476. gbc1.ipady = 0;
  477. gbc1.ipadx = 0;
  478. gbc1.gridx = 1;
  479. gbc1.gridy = 11;
  480. grid.setConstraints(charcerti, gbc1);
  481. charcerti.setFont(dFont);
  482. charcerti.addItemListener(new CheckBoxListener());
  483. pan2.add(charcerti);
  484. ncc = new JCheckBox("NCC Certificate Given");
  485. gbc1.ipady = 0;
  486. gbc1.ipadx = 0;
  487. gbc1.gridx = 2;
  488. gbc1.gridy = 11;
  489. grid.setConstraints(ncc, gbc1);
  490. ncc.setFont(dFont);
  491. ncc.addItemListener(new CheckBoxListener());
  492. pan2.add(ncc);
  493. save = new JButton("SAVE RECORD");
  494. gbc1.ipady = 1;
  495. gbc1.ipadx = 2;
  496. gbc1.gridx = 2;
  497. gbc1.gridy = 12;
  498. grid.setConstraints(save, gbc1);
  499. // Handling the SAVERECORD button on click event by ButtonHandler() class
  500. save.addActionListener(new ButtonHandler());
  501. pan2.add(save);
  502. tbPane.addTab(panelstr2,pan2);
  503.  
  504. }
  505. //-------------------------------------------------------------- Ending with displayPanel2() method ---------
  506. //============================================================ Starting displayPanel3() method =========
  507. void displayPanel3() //MODIFY/DELETE STUDENT DETAILS TAB
  508. {
  509. pan3 = new JPanel();
  510. pan3.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),""));
  511. pan3.setLayout(grid);
  512. cb_sname = new JComboBox();
  513. cb_sname.addItem("Select Student Name");
  514. cb_sname.setFont(dFont);
  515. gbc2.fill = GridBagConstraints.BOTH;
  516. gbc2.ipady = 2;
  517. gbc2.ipadx = 2;
  518. gbc2.gridx = 2;
  519. gbc2.gridy = 1;
  520. grid.setConstraints(cb_sname, gbc2);
  521. cb_sname.addItemListener(new ComboBoxListener());
  522. pan3.add(cb_sname);
  523. jmstudentname = new JLabel("Student Name");
  524. jmstudentname.setFont(dFont);
  525. gbc2.fill = GridBagConstraints.BOTH;
  526. gbc2.ipady = 2;
  527. gbc2.ipadx = 2;
  528. gbc2.gridx = 0;
  529. gbc2.gridy = 2;
  530. grid.setConstraints(jmstudentname, gbc2);
  531. pan3.add(jmstudentname);
  532. tmname = new JTextField(20);
  533. gbc2.ipady = 2;
  534. gbc2.ipadx = 2;
  535. gbc2.gridx = 1;
  536. gbc2.gridy = 2;
  537. grid.setConstraints(tmname, gbc2);
  538. pan3.add(tmname);
  539. jmdob = new JLabel("Date of Birth ");
  540. jmdob.setFont(dFont);
  541. gbc2.ipady = 2;
  542. gbc2.ipadx = 2;
  543. gbc2.gridx = 0;
  544. gbc2.gridy = 3;
  545. grid.setConstraints(jmdob, gbc2);
  546. pan3.add(jmdob);
  547. tmdob = new JTextField(20);
  548. gbc2.ipady = 2;
  549. gbc2.ipadx = 2;
  550. gbc2.gridx = 1;
  551. gbc2.gridy = 3;
  552. grid.setConstraints(tmdob, gbc2);
  553. pan3.add(tmdob);
  554. jmfathername = new JLabel("Father's Name");
  555. jmfathername.setFont(dFont);
  556. gbc2.ipady = 2;
  557. gbc2.ipadx = 2;
  558. gbc2.gridx = 0;
  559. gbc2.gridy = 4;
  560. grid.setConstraints(jmfathername, gbc2);
  561. pan3.add(jmfathername);
  562. tmfathername = new JTextField(20);
  563. gbc2.ipady = 2;
  564. gbc2.ipadx = 2;
  565. gbc2.gridx = 1;
  566. gbc2.gridy = 4;
  567. grid.setConstraints(tmfathername, gbc2);
  568. pan3.add(tmfathername);
  569. jmfatheroccupation = new JLabel("Father's Occupation");
  570. jmfatheroccupation.setFont(dFont);
  571. gbc2.ipady = 2;
  572. gbc2.ipadx = 2;
  573. gbc2.gridx = 0;
  574. gbc2.gridy = 5;
  575. grid.setConstraints(jmfatheroccupation, gbc2);
  576. pan3.add(jmfatheroccupation);
  577. mcb_fatheroccupation = new JComboBox();
  578. mcb_fatheroccupation.setFont(dFont);
  579. // Adding the combo box elements to combo box
  580. mcb_fatheroccupation.addItem(" Govt. Employee ");
  581. mcb_fatheroccupation.addItem(" Self Employed ");
  582. mcb_fatheroccupation.addItem(" Business ");
  583. gbc2.fill = GridBagConstraints.BOTH;
  584. gbc2.insets = new Insets(10,0,0,30);
  585. gbc2.ipady = 2;
  586. gbc2.ipadx = 2;
  587. gbc2.gridx = 1;
  588. gbc2.gridy = 5;
  589. mcb_fatheroccupation.addItemListener(new ComboBoxListener());
  590. grid.setConstraints(mcb_fatheroccupation, gbc2);
  591. pan3.add(mcb_fatheroccupation);
  592. jmpreaddress = new JLabel("Present Address");
  593. jmpreaddress.setFont(dFont);
  594. gbc2.ipady = 2;
  595. gbc2.ipadx = 2;
  596. gbc2.gridx = 0;
  597. gbc2.gridy = 6;
  598. grid.setConstraints(jmpreaddress, gbc2);
  599. pan3.add(jmpreaddress);
  600.  
  601. tmpreaddress = new JTextField(20);
  602. gbc2.ipady = 2;
  603. gbc2.ipadx = 2;
  604. gbc2.gridx = 1;
  605. gbc2.gridy = 6;
  606. grid.setConstraints(tmpreaddress, gbc2);
  607. pan3.add(tmpreaddress);
  608.  
  609. JLabel jmpermaaddress = new JLabel("Permanent Address ");
  610. jmpermaaddress.setFont(dFont);
  611. gbc2.ipady = 2;
  612. gbc2.ipadx = 2;
  613. gbc2.gridx = 0;
  614. gbc2.gridy = 7;
  615. grid.setConstraints(jmpermaaddress, gbc2);
  616. pan3.add(jmpermaaddress);
  617. tmpermaaddress = new JTextField(20);
  618. gbc2.ipady = 2;
  619. gbc2.ipadx = 2;
  620. gbc2.gridx = 1;
  621. gbc2.gridy = 7;
  622. grid.setConstraints(tmpermaaddress, gbc2);
  623. pan3.add(tmpermaaddress);
  624. jmphone = new JLabel(" Telephone Number ");
  625. jmphone.setFont(dFont);
  626. gbc2.ipady = 2;
  627. gbc2.ipadx = 2;
  628. gbc2.gridx = 0;
  629. gbc2.gridy = 8;
  630. grid.setConstraints(jmphone, gbc2);
  631. pan3.add(jmphone);
  632. tmphone = new JTextField(20);
  633. gbc2.ipady = 2;
  634. gbc2.ipadx = 2;
  635. gbc2.gridx = 1;
  636. gbc2.gridy = 8;
  637. grid.setConstraints(tmphone, gbc2);
  638. pan3.add(tmphone);
  639. // Checking the default gender as male by using true
  640. jmgender = new JLabel("Gender");
  641. jmgender.setFont(dFont);
  642. gbc2.ipady = 2;
  643. gbc2.ipadx = 2;
  644. gbc2.gridx = 0;
  645. gbc2.gridy = 9;
  646. grid.setConstraints(jmgender, gbc2);
  647. pan3.add(jmgender);
  648.  
  649. m_male = new JRadioButton("Male",true);
  650. m_male.setFont(dFont);
  651. gbc2.fill = GridBagConstraints.BOTH;
  652. gbc2.ipady = 2;
  653. gbc2.ipadx = 2;
  654. gbc2.gridx = 1;
  655. gbc2.gridy = 9;
  656. grid.setConstraints(m_male, gbc2);
  657. m_male.addActionListener(alistener);
  658. bg2.add(m_male);
  659. pan3.add(m_male);
  660. m_female = new JRadioButton("Female",false);
  661. m_female.setFont(dFont);
  662. gbc2.fill = GridBagConstraints.BOTH;
  663. gbc2.ipady = 2;
  664. gbc2.ipadx = 2;
  665. gbc2.gridx = 2;
  666. gbc2.gridy = 9;
  667. grid.setConstraints(m_female, gbc2);
  668. m_female.addActionListener(alistener);
  669. bg2.add(m_female);
  670. pan3.add(m_female);
  671. jmcourse = new JLabel(" Course ");
  672. jmcourse.setFont(dFont);
  673. gbc2.ipady = 2;
  674. gbc2.ipadx = 2;
  675. gbc2.gridx = 0;
  676. gbc2.gridy = 10;
  677. grid.setConstraints(jmcourse, gbc2);
  678. pan3.add(jmcourse);
  679. mcb_course = new JComboBox();
  680. mcb_course.setFont(dFont);
  681. // Adding the combo box elements to combo box
  682. mcb_course.addItem("BSc(Comp.Sc.)");
  683. mcb_course.addItem("BCA");
  684. mcb_course.addItem("MCA");
  685. mcb_course.addItem("MSc");
  686. mcb_course.addItem("BE");
  687. mcb_course.addItem("ME");
  688. // Fillig it to align properly with other Elements inside the TAB
  689. gbc2.fill = GridBagConstraints.BOTH;
  690. gbc2.insets = new Insets(10,0,0,30);
  691. gbc2.ipady = 2;
  692. gbc2.ipadx = 2;
  693. gbc2.gridx = 1;
  694. gbc2.gridy = 10;
  695. mcb_course.addItemListener(new ComboBoxListener());
  696. grid.setConstraints(mcb_course, gbc2);
  697. pan3.add(mcb_course);
  698. mcb_year = new JComboBox();
  699. mcb_year.setFont(dFont);
  700. // Adding Elements to combo box
  701. mcb_year.addItem(" A+ ");
  702. mcb_year.addItem(" B+ ");
  703. mcb_year.addItem(" C+ ");
  704.  
  705. mcb_year.addItem(" A ");
  706. mcb_year.addItem(" B ");
  707. mcb_year.addItem(" C ");
  708.  
  709. mcb_year.addItem(" A- ");
  710. mcb_year.addItem(" B- ");
  711. mcb_year.addItem(" C- ");
  712.  
  713. gbc2.fill = GridBagConstraints.BOTH;
  714. gbc2.insets = new Insets(10,0,0,30);
  715. gbc2.ipady = 2;
  716. gbc2.ipadx = 2;
  717. gbc2.gridx = 2;
  718. gbc2.gridy = 10;
  719. mcb_year.addItemListener(new ComboBoxListener());
  720. grid.setConstraints(mcb_year, gbc2);
  721. pan3.add(mcb_year);
  722. mdmc = new JCheckBox("Detail Mark Sheet Given");
  723. gbc2.fill = GridBagConstraints.BOTH;
  724. gbc2.ipady = 0;
  725. gbc2.ipadx = 0;
  726. gbc2.gridx = 1;
  727. gbc2.gridy = 11;
  728. grid.setConstraints(mdmc, gbc2);
  729. mdmc.setFont(dFont);
  730. mdmc.addItemListener(new CheckBoxListener());
  731. pan3.add(mdmc);
  732. mdegree = new JCheckBox("Degree Awarded");
  733. gbc2.ipady = 0;
  734. gbc2.ipadx = 0;
  735. gbc2.gridx = 2;
  736. gbc2.gridy = 11;
  737. grid.setConstraints(mdegree, gbc2);
  738. mdegree.setFont(dFont);
  739. mdegree.addItemListener(new CheckBoxListener());
  740. pan3.add(mdegree);
  741. mcharcerti = new JCheckBox("Character Certificate Given ");
  742. gbc2.ipady = 0;
  743. gbc2.ipadx = 0;
  744. gbc2.gridx = 1;
  745. gbc2.gridy = 12;
  746. grid.setConstraints(mcharcerti, gbc2);
  747. mcharcerti.setFont(dFont);
  748. mcharcerti.addItemListener(new CheckBoxListener());
  749. pan3.add(mcharcerti);
  750. mncc = new JCheckBox("NCC Certificate Given");
  751. gbc2.ipady = 0;
  752. gbc2.ipadx = 0;
  753. gbc2.gridx = 2;
  754. gbc2.gridy = 12;
  755. grid.setConstraints(mncc, gbc2);
  756. mncc.setFont(dFont);
  757. mncc.addItemListener(new CheckBoxListener());
  758. pan3.add(mncc);
  759. del = new JButton("DELETE");
  760. gbc2.ipady = 2;
  761. gbc2.ipadx = 2;
  762. gbc2.gridx = 1;
  763. gbc2.gridy = 13;
  764. grid.setConstraints(del, gbc2);
  765. pan3.add(del);
  766. del.addActionListener(new ButtonHandler());
  767. mod_button = new JButton("MODIFY");
  768. gbc2.ipady = 2;
  769. gbc2.ipadx = 2;
  770. gbc2.gridx = 2;
  771. gbc2.gridy = 13;
  772. grid.setConstraints(mod_button, gbc2);
  773. pan3.add(mod_button);
  774. mod_button.addActionListener(new ButtonHandler());
  775. tbPane.addTab(panelstr3, pan3);
  776. accessStudName();
  777. }
  778.  
  779. void displayPanel4() //VIEW
  780. {
  781. pan4 = new JPanel();
  782.  
  783. pan4.setLayout(new FlowLayout(FlowLayout.LEFT));
  784. scb_gender = new JComboBox();
  785. scb_gender.setFont(dFont);
  786.  
  787. scb_gender.addItem("Male");
  788. scb_gender.addItem("Female");
  789.  
  790. scb_gender.addItemListener(new ComboBoxListener());
  791. pan4.add(scb_gender);
  792.  
  793. scb_course = new JComboBox();
  794. scb_course.setFont(dFont);
  795. scb_course.addItem("BSc(Comp.Sc.)");
  796. scb_course.addItem("BCA");
  797. scb_course.addItem("MCA");
  798. scb_course.addItem("MSc");
  799. scb_course.addItem("BE");
  800. scb_course.addItem("ME");
  801. pan4.add(scb_course);
  802. scb_course.addItemListener(new ComboBoxListener());
  803.  
  804. scb_button = new JButton("SEARCH");
  805. pan4.add(scb_button);
  806. scb_button.addActionListener(new ButtonHandler());
  807.  
  808. String colname[]={"Id","Name","Address","Phone","Gender","Status","Language","Country","Description"};
  809.  
  810.  
  811. Vector v1=getStudentDetails();
  812. String data [][]=new String[v1.size()][9];
  813. for (int i=0;i<v1.size();i++)
  814. {
  815. /*
  816. Employee_Details e=(Employee_Details)v1.elementAt(i);
  817. data[i][0]=e.id;
  818. data[i][1]=e.name;
  819. data[i][2]=e.address;
  820. data[i][3]=e.phone;
  821. data[i][4]=e.gender;
  822. data[i][5]=e.status;
  823. data[i][6]=e.language;
  824. data[i][7]=e.country;
  825. data[i][8]=e.desc;
  826. */
  827. }
  828.  
  829. JTable jtb = new JTable(data, colname);
  830. jtb.setPreferredScrollableViewportSize(new Dimension(500, 50));
  831. jtb.setFillsViewportHeight(true);
  832. pan4.add(jtb);
  833. tbPane.addTab(panelstr4, pan4);
  834. //accessStudSearch();
  835. }
  836.  
  837. //-------------------------------------------------------------- Ending with displayPanel3() method ---------
  838. //---------------------------------------------------------------Starting with displayPanes() method---------
  839.  
  840. public Vector getStudentDetails()
  841. {
  842. Vector v=new Vector();
  843.  
  844. v=10;
  845. return v;
  846. }
  847.  
  848.  
  849.  
  850. //public Vector getEmployee()
  851. //{
  852. //Vector v=new Vector();
  853. /*
  854. try
  855. {
  856. psmt=con.prepareStatement("select * from student_details");
  857. //psmt.setString(1,id);
  858. rs=psmt.executeQuery();
  859. while(rs.next())
  860. {
  861. //Constructor for Employee_Details Class used only for store value on different varaible
  862. Employee_Details e=new Employee_Details();
  863. e.id=rs.getString(1);
  864. e.name=rs.getString(2);
  865. e.address=rs.getString(3);
  866. e.phone=rs.getString(4);
  867. e.gender=rs.getString(5);
  868. e.status=rs.getString(6);
  869. e.language=rs.getString(7);
  870. e.country=rs.getString(8);
  871. e.desc=rs.getString(9);
  872. v.add(e);
  873. }
  874. }
  875. catch (Exception e3)
  876. {
  877. }
  878. return v;
  879. */
  880. //}
  881.  
  882.  
  883. //-------------------------------------------------------------- Ending with displayPanel3() method ---------
  884. //---------------------------------------------------------------Starting with displayPanes() method---------
  885. void displayPanes() // ACCOUNTANT LOGGEDIN
  886. {
  887. displayPanel2();
  888. displayPanel3();
  889. displayPanel4();
  890. }
  891.  
  892. //========================================================== Starting with verifyLogin() =============
  893. void verifyLogin() //Verifing Login for username 'administrator' and password 'password'
  894. {
  895. try
  896. {
  897. String val1 = tlogname.getText();
  898. val1 = val1.trim();
  899. String val2 = (String)tlogpass.getText();
  900. val2 = val2.trim();
  901. //JDBC step 1 : Writing the query
  902. query1 = "SELECT * FROM login WHERE login='"+val1+"' AND passwd='"+val2+"'";
  903. //JDBC step 2 : Registering the driver="sun.jdbc.odbc.JdbcOdbcDriver"; for MSACCESS
  904. Class.forName(driver);
  905. //JDBC step 3 : Using the driver="sun.jdbc.odbc.JdbcOdbcDriver";
  906. Connection con=DriverManager.getConnection("jdbc:odbc:student");
  907. //JDBC step 4 : Creating a statement
  908. Statement st = con.createStatement();
  909. //JDBC step 5 : Exceuting the query
  910. boolean bresults = st.execute(query1);
  911. //JDBC step 6 : Checking the results if(bresults)
  912. {
  913. ResultSet result = st.getResultSet();
  914. //JDBC step 7 : if there are results retrieve the SET
  915. if(result!=null)
  916. {
  917. //Calling the method "showResults(ResultSet r)" and pass ResultSet to it
  918. showResults(result);
  919. }
  920. else
  921. {
  922.  
  923. }
  924. //JDBC step 8 : Closing the database connection
  925. //con.close();
  926. }
  927. }
  928. catch(SQLException ex)
  929. {
  930. System.out.println("Unable to access the database");
  931. }
  932. catch(ClassNotFoundException ex)
  933. {
  934. System.out.println("Class not found");
  935. }
  936. catch(Exception ex)
  937. {
  938. System.out.println("Exception raised is:"+ex);
  939. }
  940. }
  941. //--------------------------------------------Ending with verifyLogin() method-------
  942.  
  943. //--------------------------------------------Starting with showResults() method------
  944. void showResults(ResultSet r) throws SQLException
  945. {
  946. ResultSetMetaData rmeta = r.getMetaData();
  947. //Retrieving the Metadata from the resultset
  948. int frecord = 0;
  949. int nCols=rmeta.getColumnCount();
  950. if(r.next())
  951. {
  952. // Retrieving the first field from the login table of the student.mdb database
  953. String param1 = r.getString(1).trim();
  954. String param2 = r.getString(2).trim();
  955. if (param1.equals("administrator") && param2.equals("password"))
  956. {
  957. // Verifying for login "administrator" and password 'password'
  958. // if found record, then set frecord = 1
  959. frecord = 1;
  960. //removing Login TAB
  961. tbPane.removeTabAt(0);
  962. // Displaying other panes
  963. displayPanes();
  964. }
  965. /*String param2 = r.getString(2).trim();
  966. if (param2.equals("password"))
  967. {
  968. // Verifying for login "administrator" and password 'password'
  969. // if found record, then set frecord = 1
  970. frecord = 1;
  971. //removing Login TAB
  972. tbPane.removeTabAt(0);
  973. // Displaying other panes
  974. displayPanes();
  975. } */
  976. else if(frecord==0)
  977. {
  978. //if frecord is zero, then display invalid login.
  979. message_dialog = "Invalid Login name/password. Please enter again. ";
  980. type_dialog = JOptionPane.INFORMATION_MESSAGE;
  981. //Disaplaying the alert message
  982. JOptionPane.showMessageDialog((Component) null, message_dialog, fail_dialog, type_dialog);
  983. //Creating the tlogname and tlogpass textboxes empty
  984. tlogname.setText(" ");
  985. tlogpass.setText(" ");
  986. }
  987. }
  988. else
  989. {
  990. message_dialog = "Invalid Login. Please Enter Again.";
  991. type_dialog = JOptionPane.INFORMATION_MESSAGE;
  992. JOptionPane.showMessageDialog((Component) null, message_dialog, fail_dialog, type_dialog);
  993. tlogname.setText(" ");
  994. tlogpass.setText(" ");
  995. }
  996. }
  997. //------------------------------------------------------------------- Ending with showResults() method -------
  998.  
  999. //=================================================================== Starting with addRecord() method====
  1000. void addRecord()
  1001. {
  1002. try
  1003. {
  1004. Class.forName(driver);
  1005. Connection con=DriverManager.getConnection(url);
  1006. Statement st = con.createStatement();
  1007. //Generating new register number
  1008. String query2 = "SELECT * FROM student_details";
  1009. ResultSet rs = st.executeQuery(query2);
  1010. int cnt = 0;
  1011. while (rs.next())
  1012. {
  1013. cnt++;
  1014. }
  1015. cnt = cnt+1;
  1016. String cs = (String)course.substring(0,3);
  1017. char ss = year.charAt(0);
  1018. reg_no = ""+cs+""+ss+"-"+cnt;
  1019. query3 = "INSERT INTO student_details (name,preaddress,permaaddress,fathername,dateofbirth,fatheroccupation,phone,gender,year,course,dmc,degree,charcerti,ncccerti) VALUES ('"+tsname.getText()+"','"+tspreaddress.getText()+"','"+tspermaaddress.getText()+"','"+tsfathername.getText()+"','"+tsdob.getText()+"','"+foccupation+"','"+tsphone.getText()+"','"+gender+"','"+year+"','"+course+"',"+dmcsel+","+degreesel+","+charcfsel+","+ncccfsel+")";
  1020. int rs_int=st.executeUpdate(query3);
  1021. con.close();
  1022. message_dialog = " "+tsname.getText().toUpperCase()+" Record is Added ";
  1023. type_dialog = JOptionPane.INFORMATION_MESSAGE;
  1024. JOptionPane.showMessageDialog((Component) null, message_dialog, add_dialog, type_dialog);
  1025. // Adding the new record to the JTable
  1026. String [] data=new String[7];
  1027. data[0] = reg_no;
  1028. data[1] = tsname.getText();
  1029. data[2] = tspreaddress.getText();
  1030. data[3] = tspermaaddress.getText();
  1031. data[4] = tsphone.getText();
  1032. data[5] = tsfathername.getText();
  1033. data[6] = tsdob.getText();
  1034. defaulttablemodel.addRow(data);
  1035. cb_fatheroccupation.setSelectedIndex(0);
  1036. cb_course.setSelectedIndex(0);
  1037. cb_year.setSelectedIndex(0);
  1038. String snametemp = tsname.getText();
  1039. cb_sname.addItem(tsname.getText());
  1040. //Adding name to combobox in modify names TAB
  1041.  
  1042. //Setting other textboxes as blank to enable new record entry
  1043. tsname.setText(" ");
  1044. tspreaddress.setText(" ");
  1045. tsfathername.setText(" ");
  1046.  
  1047. // Uncheck the checkboxes, if they are checked while adding data
  1048. dmc.setSelected(false);
  1049. degree.setSelected(false);
  1050. ncc.setSelected(false);
  1051. charcerti.setSelected(false);
  1052.  
  1053. //clicking the radiobutton male , to make it default again
  1054. male.doClick();
  1055. }
  1056. catch(SQLException ex)
  1057. {
  1058. System.out.println("Unable to access the database");
  1059. }
  1060. catch(ClassNotFoundException ex)
  1061. {
  1062. System.out.println("Class not found");
  1063. }
  1064. catch(Exception ex)
  1065. {
  1066. System.out.println("Exception raised is:"+ex);
  1067. }
  1068. }
  1069. //------------------------------------------------------------------- Ending with addRecord() -------
  1070. //=============================================================== Starting with accessModifiedDatabase() ========
  1071. void accessModifiedDatabase(int nsel)
  1072. {
  1073. try
  1074. {
  1075. query4 = "SELECT * FROM student_details WHERE registration_no="+nsel+"";
  1076. Class.forName(driver);
  1077. Connection con=DriverManager.getConnection(url);
  1078. Statement st = con.createStatement();
  1079. boolean bresults = st.execute(query4);
  1080. if(bresults)
  1081. {
  1082. ResultSet result = st.getResultSet();
  1083. if(result!=null)
  1084. {
  1085. showModifiedResults(result);
  1086. }
  1087. con.close();
  1088. }
  1089. }
  1090. catch(SQLException ex)
  1091. {
  1092. System.out.println("Unable to access the database");
  1093. }
  1094. catch(ClassNotFoundException ex)
  1095. {
  1096. System.out.println("Class not found");
  1097. }
  1098. catch(Exception ex)
  1099. {
  1100. System.out.println("Exception raised is:"+ex);
  1101. }
  1102. }
  1103. //------------------------------------------------------------------- Ending with accessModifiedDatabase() -------
  1104. //=============================================================== Starting with showModifiedResults() ========
  1105.  
  1106. void showModifiedResults(ResultSet r) throws SQLException
  1107. {
  1108. ResultSetMetaData rmeta = r.getMetaData();
  1109. int frecord = 0;
  1110. int nCols=rmeta.getColumnCount();
  1111. String txt1="";
  1112. String txt2="";
  1113. String txt3="";
  1114. String txt4="";
  1115. String txt5="";
  1116. String txt6="";
  1117. String txt7="";
  1118. String txt8="";
  1119. String txt9="";
  1120. String txt10="";
  1121. String txt11="";
  1122. int int9=0;
  1123. int int10=0;
  1124. int int11=0;
  1125. int int12=0;
  1126. while(r.next())
  1127. {
  1128. reg_no=r.getString(1);
  1129. txt2+=r.getString(2);
  1130. txt3+=r.getString(3);
  1131. txt4+=r.getString(4);
  1132. txt5+=r.getString(5);
  1133. txt6+=r.getString(6);
  1134. txt7+=r.getString(7);
  1135. txt8+=r.getString(8);
  1136. txt9+=r.getString(9);
  1137. txt10=r.getString(10);
  1138. txt11=r.getString(11);
  1139. int9=r.getInt(12);
  1140. int10=r.getInt(13);
  1141. int11=r.getInt(14);
  1142. int12=r.getInt(15);
  1143. }
  1144. currentname = txt2;
  1145. tmname.setText(txt2);
  1146. tmpreaddress.setText(txt3);
  1147. tmpermaaddress.setText(txt4);
  1148. tmphone.setText(txt8);
  1149. tmfathername.setText(txt5);
  1150. tmdob.setText(txt6);
  1151. txt7 = txt7.trim();
  1152. if (txt7.equals("Govt. Employee "))
  1153. {
  1154. mcb_fatheroccupation.setSelectedIndex(0);
  1155. }
  1156. else if(txt7.equals("Self Employed"))
  1157. {
  1158. mcb_fatheroccupation.setSelectedIndex(1);
  1159. }
  1160. else
  1161. {
  1162. mcb_fatheroccupation.setSelectedIndex(2);
  1163. }
  1164. txt9 = txt9.trim();
  1165. if (txt9.equalsIgnoreCase("M"))
  1166. {
  1167. m_male.doClick();
  1168. }
  1169. else
  1170. {
  1171. m_female.doClick();
  1172. }
  1173.  
  1174. txt11 = txt11.trim();
  1175. if (txt11.equals("B.Sc.(Comp. Sc.)"))
  1176. {
  1177. mcb_course.setSelectedIndex(1);
  1178. }
  1179. else
  1180. {
  1181. mcb_course.setSelectedIndex(0);
  1182. }
  1183. txt10 = txt10.trim();
  1184. if (txt10.equals("I Year"))
  1185. {
  1186. mcb_year.setSelectedIndex(0);
  1187. }
  1188. else if(txt10.equals("II Year"))
  1189. {
  1190. mcb_year.setSelectedIndex(1);
  1191. }
  1192. else
  1193. {
  1194. mcb_year.setSelectedIndex(2);
  1195. }
  1196. if(int9==1)
  1197. {
  1198. mdmc.setSelected(true);
  1199. }
  1200. else
  1201. {
  1202. mdmc.setSelected(false);
  1203. }
  1204. if(int10==1)
  1205. {
  1206. mdegree.setSelected(true);
  1207. }
  1208. else
  1209. {
  1210. mdegree.setSelected(false);
  1211. }
  1212. if(int11==1)
  1213. {
  1214. mcharcerti.setSelected(true);
  1215. }
  1216. else
  1217. {
  1218. mcharcerti.setSelected(false);
  1219. }
  1220. if(int12==1)
  1221. {
  1222. mncc.setSelected(true);
  1223. }
  1224. else
  1225. {
  1226. mncc.setSelected(false);
  1227. }
  1228. }
  1229. //------------------------------------------------------------------- Ending with showModifiedResults() -------
  1230. //=============================================================== Starting with accessStudName() ========
  1231.  
  1232. void accessStudName() //Retrieving the student list in the combo box
  1233. {
  1234. try
  1235. {
  1236. query5 = "SELECT registration_no,Name FROM student_details ORDER BY registration_no";
  1237. Class.forName(driver);
  1238. Connection con=DriverManager.getConnection(url);
  1239. Statement st = con.createStatement();
  1240. boolean bresults = st.execute(query5);
  1241. if(bresults)
  1242. {
  1243. ResultSet result = st.getResultSet();
  1244. if(result!=null)
  1245. {
  1246. showStudName(result);
  1247. }
  1248. con.close();
  1249. }
  1250.  
  1251. }
  1252. catch(SQLException ex)
  1253. {
  1254. System.out.println("Unable to access the database");
  1255. }
  1256. catch(ClassNotFoundException ex)
  1257. {
  1258. System.out.println("Class not found");
  1259. }
  1260. catch(Exception ex)
  1261. {
  1262. System.out.println("Exception raised is:"+ex);
  1263. }
  1264. }
  1265. //------------------------------------------------------------------- Ending with accessStudName() -------
  1266. //=============================================================== Starting with showStudName() ========
  1267.  
  1268. void showStudName(ResultSet r) throws SQLException
  1269. {
  1270. ResultSetMetaData rmeta = r.getMetaData();
  1271. int nCols=rmeta.getColumnCount();
  1272. while(r.next())
  1273. {
  1274. cb_sname.addItem(r.getString(1)+":"+r.getString(2));
  1275. ctr_val++;
  1276. }
  1277. }
  1278. //------------------------------------------------------------------- Ending with showStudName() -------
  1279. //=============================================================== Starting with deleteRecord() ========
  1280.  
  1281. void deleteRecord(int nsel) //Deleting the record for the selected student name
  1282. {
  1283. try
  1284. {
  1285. Class.forName(driver);
  1286. Connection con=DriverManager.getConnection(url);
  1287. Statement st = con.createStatement();
  1288. System.out.println("Delete name is :=="+nsel);
  1289. query6 = "DELETE FROM student_details WHERE registration_no="+nsel;
  1290. st.executeUpdate(query6);
  1291. con.close();
  1292. mcb_course.setSelectedIndex(0);
  1293. mcb_year.setSelectedIndex(0);
  1294. tmname.setText(" ");
  1295. tmdob.setText(" ");
  1296. tmpreaddress.setText(" ");
  1297. tmpermaaddress.setText(" ");
  1298. tmfathername.setText(" ");
  1299. tmphone.setText(" ");
  1300. mdmc.setSelected(false);
  1301. mdegree.setSelected(false);
  1302. mncc.setSelected(false);
  1303. mcharcerti.setSelected(false);
  1304. m_male.doClick();
  1305. }
  1306. catch(SQLException ex)
  1307. {
  1308. System.out.println("Unable to access the database");
  1309. }
  1310. catch(ClassNotFoundException ex)
  1311. {
  1312. System.out.println("Class not found");
  1313. }
  1314. catch(Exception ex)
  1315. {
  1316. System.out.println("Exception raised is:"+ex);
  1317. }
  1318. }
  1319. //------------------------------------------------------------------- Ending with deleteRecord() -------
  1320. //=============================================================== Starting with updateRecord() ========
  1321.  
  1322. void updateRecord(int std_id,String str_name) //Update Database when modified
  1323. {
  1324. try
  1325. {
  1326. query7 = "UPDATE student_details SET name='"+tmname.getText()+"', preaddress='"+tmpreaddress.getText()+"', permaaddress='"+tmpermaaddress.getText()+"', fathername='"+tmfathername.getText()+"', dateofbirth='"+tmdob.getText()+"', fatheroccupation='"+foccupation+"', phone='"+tmphone.getText()+"', gender='"+gender+"', year='"+year+"', course='"+course+"', dmc="+dmcsel+", degree="+degreesel+", charcerti="+charcfsel+", ncccerti="+ncccfsel+" WHERE registration_no="+std_id;
  1327. Class.forName(driver);
  1328. Connection con=DriverManager.getConnection(url);
  1329. Statement st = con.createStatement();
  1330. System.out.println(query7);
  1331. int ret=st.executeUpdate(query7);
  1332. System.out.println("Output is "+ret);
  1333. con.close();
  1334. System.out.println("Called After"+str_name);
  1335. message_dialog = " "+tmname.getText().toUpperCase()+" Record is Updated ";
  1336. type_dialog = JOptionPane.INFORMATION_MESSAGE;
  1337. JOptionPane.showMessageDialog((Component) null, message_dialog, modify_dialog, type_dialog);
  1338. }
  1339. catch(SQLException ex)
  1340. {
  1341. System.out.println("Unable to access the database");
  1342. }
  1343. catch(ClassNotFoundException ex)
  1344. {
  1345. System.out.println("Class not found");
  1346. }
  1347. catch(Exception ex)
  1348. {
  1349. System.out.println("Exception raised is:"+ex);
  1350. }
  1351. }
  1352. //------------------------------------------------------------------- Ending with deleteRecord() -------
  1353. //=============================================================== Starting with ButtonHandler class ========
  1354.  
  1355. class ButtonHandler implements ActionListener
  1356. {
  1357. public void actionPerformed(ActionEvent ev)
  1358. {
  1359.  
  1360. String s=ev.getActionCommand();
  1361. if(s.equals("Click to Continue"))
  1362. {
  1363. cont.setEnabled(false);
  1364. displayPanel1();
  1365. tbPane.setSelectedIndex(1);
  1366. tbPane.removeTabAt(0);
  1367. }
  1368. else if(s=="LOGIN") //Login is Clicked
  1369. {
  1370.  
  1371. verifyLogin();
  1372. tbPane.setSelectedIndex(0);
  1373. tlogname.setText("");
  1374. }
  1375. else if(s.equals("SAVE RECORD")) //Save Record is Clicked
  1376. {
  1377.  
  1378. addRecord();
  1379. String snametemp = tsname.getText();
  1380. }
  1381. else if(s.equals("MODIFY")) //Modify Record is Clicked
  1382. {
  1383. int student_id=Integer.parseInt(selname.substring(0,2));
  1384. updateRecord(student_id,selname);
  1385. int x=ctr_val;
  1386.  
  1387. for(int y=x;y>1;y--)
  1388. {
  1389. cb_sname.removeItemAt(y);
  1390.  
  1391. }
  1392. cb_sname.addItem("Select Student Name");
  1393. cb_sname.removeItemAt(0);
  1394. cb_sname.removeItemAt(1);
  1395. accessStudName();
  1396. cb_sname.removeItemAt(1);
  1397.  
  1398. }
  1399. else if(s.equals("DELETE")) //Delete Record Button is Clicked
  1400. {
  1401. dlgCPane.setLayout(new FlowLayout());
  1402. dlgCPane.add(jLabeldlg);
  1403. jLabeldlg.setFont(tFont);
  1404. dlgCPane.add(delit);
  1405. delit.addActionListener(new ButtonHandler());
  1406. dlgCPane.add(delno);
  1407. delno.addActionListener(new ButtonHandler());
  1408. dlg.setBounds(300, 200, 250, 120);
  1409. dlg.show();
  1410. }
  1411. else if(s.equals("YES")) //Yes button is clicked in Delete dialog box
  1412. {
  1413. dlg.dispose();
  1414. selname = cb_sname.getSelectedItem().toString();
  1415. int student_id=Integer.parseInt(selname.substring(0,2));
  1416. deleteRecord(student_id);
  1417. int x=ctr_val;
  1418. for(int y=x;y>1;y--)
  1419. {
  1420. cb_sname.removeItemAt(y);
  1421. }
  1422. cb_sname.addItem("Select Student Name");
  1423. cb_sname.removeItemAt(0);
  1424. cb_sname.removeItemAt(1);
  1425. accessStudName();
  1426. cb_sname.removeItemAt(1);
  1427. }
  1428.  
  1429. else if(s.equals("NO")) //No button is clicked in the Delete dialog box
  1430. {
  1431. dlg.dispose();
  1432. }
  1433. else if(s.equals("Search"))
  1434. {
  1435. displayPanel4();
  1436. }
  1437. }
  1438. }
  1439. //------------------------------------------------------------- Ending with the ButtonHandler --------
  1440. //=========================================================== Starting with the MenuItemHandler ======
  1441.  
  1442. class MenuItemHandler implements ActionListener
  1443. {
  1444. public void actionPerformed(ActionEvent ev)
  1445. {
  1446. String s=ev.getActionCommand();
  1447. if(s=="Exit")
  1448. {
  1449. //close window on menuitem exit
  1450. System.exit(0);
  1451. }
  1452. }
  1453. }
  1454. //----------------------------------------------------------- Ending with the MenuItemHandler ------
  1455. //=========================================================== Starting with the WindowEventHandler ===
  1456. class WindowEventHandler extends WindowAdapter
  1457. {
  1458. public void windowClosing(WindowEvent e)
  1459. {
  1460. //Closing the window on exit
  1461. System.exit(0);
  1462. }
  1463. }
  1464. //----------------------------------------------------------- Ending with WindowEventHandler ---
  1465. //=========================================================== Starting with RadioListener ========
  1466.  
  1467. class RadioListener implements ActionListener
  1468. {
  1469. public void actionPerformed(ActionEvent e)
  1470. {
  1471. gender = e.getActionCommand();
  1472.  
  1473. condsel = e.getActionCommand();
  1474.  
  1475. }
  1476. }
  1477. //----------------------------------------------------------- Ending with the RadioListener --------
  1478. //=========================================================== Starting with the ComboBoxListener ========
  1479.  
  1480. class ComboBoxListener implements ItemListener
  1481. {
  1482. public ComboBoxListener()
  1483. {
  1484. super();
  1485. }
  1486. public void itemStateChanged(ItemEvent e)
  1487. {
  1488. str = (String)e.getItem();
  1489. if (e.getSource().equals(cb_fatheroccupation))
  1490. {
  1491. foccupation = cb_fatheroccupation.getSelectedItem().toString();
  1492. }
  1493. if (e.getSource().equals(mcb_fatheroccupation))
  1494. {
  1495. foccupation = mcb_fatheroccupation.getSelectedItem().toString();
  1496. }
  1497. if (e.getSource().equals(cb_course))
  1498. {
  1499. course = cb_course.getSelectedItem().toString();
  1500. }
  1501. if (e.getSource().equals(mcb_course))
  1502. {
  1503. course = mcb_course.getSelectedItem().toString();
  1504. }
  1505. if (e.getSource().equals(cb_year))
  1506. {
  1507. year = cb_year.getSelectedItem().toString();
  1508. }
  1509. if (e.getSource().equals(mcb_year))
  1510. {
  1511. year = mcb_year.getSelectedItem().toString();
  1512. }
  1513. if (e.getSource().equals(cb_sname))
  1514. {
  1515.  
  1516. selname = cb_sname.getSelectedItem().toString();
  1517. accessModifiedDatabase(Integer.parseInt(selname.substring(0,2)));
  1518. }
  1519. if (e.getSource().equals(jstudID))
  1520. {
  1521. studID = jstudID.getSelectedItem().toString();
  1522. }
  1523. if (e.getSource().equals(jeq))
  1524. {
  1525. eq = jeq.getSelectedItem().toString();
  1526. }
  1527. }
  1528. }
  1529. //----------------------------------------------------------- Ending with the ComboBoxListener --------
  1530. //=========================================================== Starting with the CheckBoxListener =====
  1531.  
  1532. class CheckBoxListener implements ItemListener
  1533. {
  1534.  
  1535. public void itemStateChanged(ItemEvent e)
  1536. {
  1537. Object source = e.getItemSelectable();
  1538. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==dmc))
  1539. {
  1540. dmcsel = 1;
  1541. }
  1542. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==dmc))
  1543. {
  1544. dmcsel = 0;
  1545. }
  1546. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==degree))
  1547. {
  1548. degreesel = 1;
  1549. }
  1550. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==degree))
  1551. {
  1552. degreesel = 0;
  1553. }
  1554. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ncc))
  1555. {
  1556. ncccfsel = 1;
  1557. }
  1558. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ncc))
  1559. {
  1560. ncccfsel = 0;
  1561. }
  1562. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==charcerti))
  1563. {
  1564. charcfsel = 1;
  1565. }
  1566. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==charcerti))
  1567. {
  1568. charcfsel = 0;
  1569. }
  1570. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mdmc))
  1571. {
  1572. mdmcsel = 1;
  1573. }
  1574. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mdmc))
  1575. {
  1576. mdmcsel = 0;
  1577. }
  1578. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mdegree))
  1579. {
  1580. mdegreesel = 1;
  1581. }
  1582. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mdegree))
  1583. {
  1584. mdegreesel = 0;
  1585. }
  1586. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mncc))
  1587. {
  1588. mnccsel = 1;
  1589. }
  1590. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mncc))
  1591. {
  1592. mnccsel = 0;
  1593. }
  1594. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mcharcerti))
  1595. {
  1596. mcharcfsel = 1;
  1597. }
  1598. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mcharcerti))
  1599. {
  1600. mcharcfsel = 0;
  1601. }
  1602. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckstudentID))
  1603. {
  1604. selstudentID = 1;
  1605. }
  1606. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckstudentID))
  1607. {
  1608. selstudentID = 0;
  1609. }
  1610. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckstudentname))
  1611. {
  1612. selstudentname = 1;
  1613. }
  1614. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckstudentname))
  1615. {
  1616. selstudentname = 0;
  1617. }
  1618. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckpreaddress))
  1619. {
  1620. selstudentpreadd = 1;
  1621. }
  1622. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckpreaddress))
  1623. {
  1624. selstudentpreadd = 0;
  1625. }
  1626. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckpermaaddress))
  1627. {
  1628. selstudentpermaadd = 1;
  1629. }
  1630. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckpermaaddress))
  1631. {
  1632. selstudentpermaadd = 0;
  1633. }
  1634. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckfathername))
  1635. {
  1636. selfathername = 1;
  1637. }
  1638. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckfathername))
  1639. {
  1640. selfathername = 0;
  1641. }
  1642. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckgender))
  1643. {
  1644. selgender = 1;
  1645. }
  1646. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckgender))
  1647. {
  1648. selgender = 0;
  1649. }
  1650. if ((e.getStateChange() == ItemEvent.SELECTED) && (source==ckdob))
  1651. {
  1652. seldob = 1;
  1653. }
  1654. if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==ckdob))
  1655. {
  1656. seldob = 0;
  1657. }
  1658.  
  1659. }
  1660. }
  1661. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!