madhawaseeeee

Untitled

Sep 13th, 2015
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.58 KB | None | 0 0
  1. private void FacultyNameItemStateChanged(java.awt.event.ItemEvent evt)
  2.  
  3.  
  4.  String query = "SELECT * FROM tblinstructor WHERE Instructor = '" + FacultyName.getSelectedItem()+ "' AND Course_Year_Level = '" + jLabelHiddenCourse.getText() + "'";
  5.  
  6.         try{
  7.             Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  8.             Connection dbConn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\kim\\Desktop\\Thesis Docu\\FPAS\\FPAS.accdb");
  9.             PreparedStatement select = dbConn.prepareStatement(query);
  10.             ResultSet mResult = select.executeQuery();
  11.             if(mResult.next()){
  12.                 String result1 = mResult.getString("Instructor");
  13.                 String result2 = mResult.getString("DescriptiveTitle");
  14.                 String result3 = mResult.getString("Day");
  15.                 String result4 = mResult.getString("Time");
  16.  
  17.                 System.out.println(".............start.............");
  18.                 System.out.println(result1);
  19.                 System.out.println(result2);
  20.                 System.out.println(result3);
  21.                 System.out.println(result4);
  22.                 System.out.println(".............end.............");
  23.                // jTxtFaculty.setText(result1);
  24.                // jTxtCourse.setText(result2);
  25.                // jTxtDay.setText(result3);
  26.                // jTxtTime.setText(result4);
  27.             }
  28.             else{
  29.                 JOptionPane.showMessageDialog(null, "");
  30.             }
  31.         }
  32.         catch(Exception e){
  33.             JOptionPane.showMessageDialog(null, e);
  34.         }
Advertisement
Add Comment
Please, Sign In to add comment