code_junkie

Problem with return statement

Nov 12th, 2011
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. ArrayList<String> ListNameMagazine = new ArrayList<String>();
  2.  
  3. ShowData Show = new ShowData();
  4.  
  5. int HowManyMagazine = Show.HowManyMagazine(1); // to make sure there is how many Magazine name in my database
  6.  
  7. //System.out.print(HowManyMagazine); //i want to make sure the data is out.
  8.  
  9. String nmeMagazine = null; // this variable for get data from return statement
  10.  
  11. // i want to store in ListNameMagazine
  12. ArrayList<String> ListNameMagazine = new ArrayList<String>();
  13.  
  14. for (int numbeer = 0;numbeer <= HowManyMagazine ; numbeer++)
  15. {
  16. //Store in 1 variable String, because if arrayList it's error
  17. nmeMagazine = Show.getResult("Select Name_Magazine from Magazine");
  18. // Store again in array list
  19. ListNameMagazine.add(nmeMagazine);
  20. }
  21.  
  22. for (String s : ListNameMagazine)
  23. {
  24. System.out.println(s); // show the data
  25. }
  26.  
  27. public String getResult(String sql)
  28. throws SQLException
  29. {
  30. ResultSet rs = st.executeQuery(sql);
  31. ResultSetMetaData resultsetmetadata = rs.getMetaData();
  32.  
  33. //String just_try = null;
  34. while (rs.next()) {
  35. System.out.println("Result:"+rs.getString(1));
  36. //just_try = rs.getString(1);
  37. //return just_try;
  38. }
  39. return null; //return just_try;
  40. }
  41.  
  42. public String getResult(String sql)
  43. throws SQLException
  44. {
  45. ResultSet rs = st.executeQuery(sql);
  46. ResultSetMetaData resultsetmetadata = rs.getMetaData();
  47. String just_try = null;
  48.  
  49. while (rs.next()) {
  50. //System.out.println("Result:"+rs.getString(1));
  51. just_try = rs.getString(1);
  52. return just_try;
  53. }
  54.  
  55. return just_try;
  56. }
  57.  
  58. for (String s : ListNameMagazine)
  59. {
  60. System.out.println(s); // show the data
  61. }
  62.  
  63. public String getResult(String sql)
  64. throws SQLException
  65. {
  66. ResultSet rs = st.executeQuery(sql);
  67. ResultSetMetaData resultsetmetadata = rs.getMetaData();
  68. String just_try = null;
  69.  
  70. while (rs.next()) {
  71. System.out.println("Result:"+rs.getString(1));
  72. //just_try = rs.getString(1);
  73. //return just_try;
  74. }
  75.  
  76. return null;
  77. }
  78.  
  79. while (rs.next()) {
  80.  
  81. //System.out.println("Result:"+rs.getString(1));
  82.  
  83. just_try = rs.getString(1);
  84.  
  85. return just_try;
  86.  
  87. }
  88.  
  89. just_try = rs.getString(1);
  90.  
  91. return just_try;
  92.  
  93. ArrayList<String> ListNameMagazine;
  94. ListNameMagazine = Show.getResult("Select Name_Magazine from Magazine");
  95.  
  96. public ArrayList<String> getResult(String sql) throws SQLException {
  97.  
  98. ResultSet rs = st.executeQuery(sql);
  99.  
  100. ResultSetMetaData resultsetmetadata = rs.getMetaData();
  101.  
  102. ArrayList<String> returnArrayList = new ArrayList<String>();
  103.  
  104. while (rs.next()) {
  105.  
  106. returnArrayList.add(rs.getString(1));
  107.  
  108. }
  109. return returnArrayList;
  110.  
  111. }
  112.  
  113. public List<String> getResult(String sql) throws SQLException;
Add Comment
Please, Sign In to add comment