Advertisement
Guest User

Untitled

a guest
May 24th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.49 KB | None | 0 0
  1. Das gibt er aus:
  2.  
  3. cast_info_idx_cid
  4. cast_info_idx_mid
  5. cast_info_idx_pid
  6. cast_info_pkey
  7. char_name_idx_md5
  8. char_name_idx_name
  9. char_name_idx_pcode
  10. char_name_idx_pcodenf
  11. char_name_pkey
  12. ci_idx_role_id
  13. company_name_idx_md5
  14. company_name_idx_name
  15. company_name_idx_pcodenf
  16. company_name_idx_pcodesf
  17. company_name_pkey
  18. company_type_kind_key
  19. company_type_pkey
  20. info_type_info_key
  21. info_type_pkey
  22. kind_type_kind_key
  23. kind_type_pkey
  24. link_type_link_key
  25. link_type_pkey
  26. mc_idx_company_type_id
  27. mi_idx_idx_info_type_id
  28. mi_idx_info_type_id
  29. ml_idx_linked_movie_id
  30. movie_companies_idx_cid
  31. movie_companies_idx_mid
  32. movie_companies_pkey
  33. movie_info_idx_idx_info
  34. movie_info_idx_idx_infotypeid
  35. movie_info_idx_idx_mid
  36. movie_info_idx_mid
  37. movie_info_idx_pkey
  38. movie_info_pkey
  39. movie_link_idx_mid
  40. movie_link_pkey
  41. name_idx_imdb_id
  42. name_idx_md5
  43. name_idx_name
  44. name_idx_pcode
  45. name_idx_pcodecf
  46. name_idx_pcodenf
  47. name_pkey
  48. person_info_idx_pid
  49. person_info_pkey
  50. pi_idx_info_infotype_id
  51. role_type_pkey
  52. role_type_role_key
  53. t_idx_kind_id
  54. t_idx_production_year
  55. title_idx_episode_nr
  56. title_idx_epof
  57. title_idx_imdb_id
  58. title_idx_md5
  59. title_idx_pcode
  60. title_idx_season_nr
  61. title_idx_title
  62. title_pkey
  63. cast_info_id_seq
  64. char_name_id_seq
  65. company_name_id_seq
  66. company_type_id_seq
  67. info_type_id_seq
  68. kind_type_id_seq
  69. link_type_id_seq
  70. movie_companies_id_seq
  71. movie_info_id_seq
  72. movie_info_idx_id_seq
  73. movie_link_id_seq
  74. name_id_seq
  75. person_info_id_seq
  76. role_type_id_seq
  77. title_id_seq
  78. cast_info
  79. char_name
  80. company_name
  81. company_type
  82. info_type
  83. kind_type
  84. link_type
  85. movie_companies
  86. movie_info
  87. movie_info_idx
  88. movie_link
  89. name
  90. person_info
  91. role_type
  92. title
  93.  
  94.  
  95. Das sollte rauskommen:
  96.  
  97. cast_info
  98. char_name
  99. company_name
  100. company_type
  101. info_type
  102. kind_type
  103. link_type
  104. movie_companies
  105. movie_info
  106. movie_info_idx
  107. movie_link
  108. name
  109. person_info
  110. role_type
  111. title
  112.  
  113.  
  114. Code dafür:
  115.  
  116.  
  117. public DatabaseMetaData getMetaData() throws SQLException{
  118. DatabaseMetaData data = null;
  119. Connection con = getConnection();
  120. data = con.getMetaData();
  121. String catalog = null;
  122. String schemaPattern = "public";
  123. String tableNamePattern = null;
  124. String[] types = null;
  125.  
  126.  
  127.  
  128.  
  129. ResultSet rs = data.getTables(catalog, schemaPattern, tableNamePattern, types);
  130. while(rs.next()){
  131. String tableName = rs.getString(3);
  132. System.out.println(tableName);
  133. }
  134.  
  135. return data;
  136. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement