Advertisement
Guest User

Untitled

a guest
Jul 24th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. JOptionPane.showMessageDialog(frame, "displayed");
  2.  
  3. while (rs.next()) {
  4. String name = rs.getString("Name");
  5. String size = rs.getString("size");
  6. String price = rs.getString("price");
  7. textArea_Name.append(name);
  8. textArea_size.append(size);
  9. textArea_price.append(price);
  10. comboBox_1.addItem(rs.getString("Name"));
  11. comboBox_1.getSelectedItem();
  12.  
  13. }}
  14.  
  15.  
  16. catch (SQLException e ) {
  17. System.out.println("user not added");
  18. e.printStackTrace();
  19. }
  20.  
  21. }
  22. });
  23.  
  24. con = DriverManager.getConnection("jdbc:mysql://:3306/database","user","password");
  25. stat = con.createStatement();
  26. ResultSet rs = stat.executeQuery("select name from student;");
  27. while(rs.next()){
  28. jComboBox1.addItem(rs.getString("name"));
  29. }
  30. rs.close();
  31. stat.close();
  32. con.close();
  33.  
  34. try {
  35. Statement stmt = db.con.createStatement();
  36. ResultSet rs = stmt5.executeQuery("select * from tbl_your_table");
  37. while (rs.next()) {
  38. String pat = rs.getString("name");
  39. jComboBox.addItem(pat);
  40. }
  41.  
  42. } catch (Exception e) {
  43.  
  44. JOptionPane.showMessageDialog(null, e);
  45. }
  46.  
  47. try {
  48. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  49.  
  50. Connection conn= DriverManager.getConnection("jdbc:odbc:driverName");
  51. Statement st = conn.createStatement();
  52.  
  53. ResultSet r=st.executeQuery("select * from tableName");
  54.  
  55. while (r.next()) {
  56.  
  57. JComboBox.addItem(r.getString("Key_Coloumn_Name"));
  58. }
  59.  
  60.  
  61. conn.close();
  62. } catch (Exception e) {
  63. JOptionPane.showMessageDialog(null,"Failed to Connect to Database","Error Connection", JOptionPane.WARNING_MESSAGE);
  64. System.exit(0);
  65. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement