Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void FacultyNameItemStateChanged(java.awt.event.ItemEvent evt)
- String query = "SELECT * FROM tblinstructor WHERE Instructor = '" + FacultyName.getSelectedItem()+ "' AND Course_Year_Level = '" + jLabelHiddenCourse.getText() + "'";
- try{
- Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
- Connection dbConn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\kim\\Desktop\\Thesis Docu\\FPAS\\FPAS.accdb");
- PreparedStatement select = dbConn.prepareStatement(query);
- ResultSet mResult = select.executeQuery();
- if(mResult.next()){
- String result1 = mResult.getString("Instructor");
- String result2 = mResult.getString("DescriptiveTitle");
- String result3 = mResult.getString("Day");
- String result4 = mResult.getString("Time");
- System.out.println(".............start.............");
- System.out.println(result1);
- System.out.println(result2);
- System.out.println(result3);
- System.out.println(result4);
- System.out.println(".............end.............");
- // jTxtFaculty.setText(result1);
- // jTxtCourse.setText(result2);
- // jTxtDay.setText(result3);
- // jTxtTime.setText(result4);
- }
- else{
- JOptionPane.showMessageDialog(null, "");
- }
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(null, e);
- }
Advertisement
Add Comment
Please, Sign In to add comment