Advertisement
Guest User

Untitled

a guest
May 20th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.29 KB | None | 0 0
  1. cmbAtdncStrm = new JComboBox(strm);
  2. cmbAtdncStrm.setForeground(new Color(0, 51, 102));
  3. cmbAtdncStrm.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  4. cmbAtdncStrm.setBounds(10, 34, 103, 22);
  5. cmbAtdncStrm.setRenderer(new MyComboBoxRenderer(" Stream"));
  6. cmbAtdncStrm.setSelectedIndex(-1);
  7. panelAtdnc.add(cmbAtdncStrm);
  8.  
  9.  
  10. panelDt = new JPanel();
  11. panelDt.setLayout(null);
  12. panelDt.setOpaque(false);
  13. panelDt.setBorder(new TitledBorder(UIManager.getBorder("CheckBoxMenuItem.border"), "<html><font face='Tw Cen MT' size='3'>DATE </font><font color='red'></font></html>", TitledBorder.LEADING, TitledBorder.TOP, null, new Color(109, 109, 109)));
  14. panelDt.setBounds(2, 136, 235, 46);
  15. panelAtdnc.add(panelDt);
  16.  
  17. cmbDtDay = new JComboBox<Object>(days);
  18. cmbDtDay.setRenderer(new MyComboBoxRenderer(" Day"));
  19. cmbDtDay.setSelectedIndex(-1);
  20. cmbDtDay.setForeground(new Color(0, 51, 102));
  21. cmbDtDay.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  22. cmbDtDay.setBounds(8, 18, 60, 22);
  23. panelDt.add(cmbDtDay);
  24.  
  25. cmbDtMnth = new JComboBox<Object>(mnth);
  26. cmbDtMnth.setRenderer(new MyComboBoxRenderer(" Month"));
  27. cmbDtMnth.setSelectedIndex(-1);
  28. cmbDtMnth.setForeground(new Color(0, 51, 102));
  29. cmbDtMnth.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  30. cmbDtMnth.setBounds(75, 18, 82, 22);
  31. panelDt.add(cmbDtMnth);
  32.  
  33. cmbDtYr = new JComboBox<Object>(year);
  34. cmbDtYr.setRenderer(new MyComboBoxRenderer(" Year"));
  35. cmbDtYr.setSelectedIndex(-1);
  36. cmbDtYr.setForeground(new Color(0, 51, 102));
  37. cmbDtYr.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  38. cmbDtYr.setBounds(164, 18, 65, 22);
  39. panelDt.add(cmbDtYr);
  40.  
  41.  
  42.  
  43. cmbAtdncSem = new JComboBox<Object>(sem);
  44. cmbAtdncSem.setRenderer(new MyComboBoxRenderer(" Semester"));
  45. cmbAtdncSem.setSelectedIndex(-1);
  46. cmbAtdncSem.setForeground(new Color(0, 51, 102));
  47. cmbAtdncSem.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  48. cmbAtdncSem.setBounds(130, 34, 103, 22);
  49. panelAtdnc.add(cmbAtdncSem);
  50.  
  51. JLabel lblAtdncStatus = new JLabel("NO. OF DAYS PRESENT TILL NOW :-");
  52. lblAtdncStatus.setForeground(new Color(0, 51, 102));
  53. lblAtdncStatus.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  54. lblAtdncStatus.setBounds(16, 213, 205, 14);
  55. panelAtdnc.add(lblAtdncStatus);
  56.  
  57. txtAtdncNo = new JTextField();
  58. txtAtdncNo.setOpaque(false);
  59. txtAtdncNo.setForeground(Color.RED);
  60. txtAtdncNo.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  61. txtAtdncNo.setColumns(10);
  62. txtAtdncNo.setBorder(new MatteBorder(0, 0, 1, 0, (Color) Color.LIGHT_GRAY));
  63. txtAtdncNo.setBounds(232, 208, 72, 22);
  64. panelAtdnc.add(txtAtdncNo);
  65.  
  66. lblSave = new JLabel("Save");
  67. lblSave.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
  68. lblSave.setIcon(new ImageIcon(Student.class.getResource("/img/Check-16.png")));
  69. lblSave.setForeground(new Color(0, 51, 102));
  70. lblSave.setFont(new Font("Tw Cen MT", Font.PLAIN, 16));
  71. lblSave.setBounds(206, 340, 72, 18);
  72. panelAtdnc.add(lblSave);
  73.  
  74. cmbName = new JComboBox();
  75. cmbName.setEnabled(false);
  76. cmbName.setForeground(new Color(0, 51, 102));
  77. cmbName.setBorder(new MatteBorder(0, 0, 1, 0, (Color) Color.LIGHT_GRAY));
  78. cmbName.setFont(new Font("Tw Cen MT", Font.PLAIN, 13));
  79. cmbName.setBounds(10, 85, 150, 22);
  80. cmbName.setRenderer(new MyComboBoxRenderer(" Name of the Student"));
  81. cmbName.setSelectedIndex(-1);
  82. panelAtdnc.add(cmbName);
  83.  
  84. JLabel lblCheck = new JLabel("Check");
  85. lblCheck.addMouseListener(new MouseAdapter() {
  86. @Override
  87. public void mouseClicked(MouseEvent arg0) {
  88. name=new Vector();
  89. atdnc=new Vector();
  90. try{
  91. //Class.forName("com.oracle.jdbc.Driver");
  92. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE","ADMIN","admin");
  93. Statement st=con.createStatement();
  94. ResultSet rslt1=st.executeQuery("select * from student where stream='"+cmbAtdncStrm.getSelectedItem()+"' and semester='"+cmbAtdncSem.getSelectedItem()+"'");
  95. //ResultSet rslt2=st.executeQuery("select distinct attendance from student where
  96.  
  97. current_date='"+cmbDtDay.getSelectedItem()+"''"+cmbDtMnth.getSelectedItem()+"''"+cmbDtYr.getSelectedItem()+"'");
  98.  
  99. while(rslt1.next()){
  100. name.add(rslt1.getString(2));
  101. System.out.println(name);
  102. cmbName.setEnabled(true);
  103. cmbName=new JComboBox<>(name);
  104.  
  105. }
  106. }catch(Exception e){
  107. e.printStackTrace();
  108. JOptionPane.showMessageDialog(null,"No Student Found");
  109. }
  110.  
  111. }
  112. });
  113. lblCheck.setForeground(new Color(0, 51, 102));
  114. lblCheck.setFont(new Font("Tw Cen MT", Font.PLAIN, 16));
  115. lblCheck.setBounds(258, 39, 46, 14);
  116. panelAtdnc.add(lblCheck);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement