SHARE
TWEET

Untitled

a guest May 19th, 2017 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. answerlabel2 = new JLabel();
  2. dlabel.add(answerlabel2);
  3.  
  4.  
  5.  
  6. PreparedStatement pst3 = conn.prepareStatement("select answer_desc from lesson join question using(lesson_no) join answer using(question_no,lesson_no)join education_level using(edulevel_no) join vision_level using(vislevel_no) join lesson_category using(cat_no) where cat_no = ? and lesson_no = ?");
  7.  
  8.                                         pst3.setInt(1,catno);
  9.                                         pst3.setInt(2,lessonValue);
  10.                                         ResultSet rs3 = pst3.executeQuery();
  11.  
  12.                                     while (rs3.next()) {
  13.  
  14.                                             answerlabel2.setText(rs3.getString(1));
  15.                                                    
  16.                                             }
RAW Paste Data
Top