Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.77 KB | None | 0 0
  1. import java.util.ArrayList;
  2. import java.util.List;
  3.  
  4. public class MySAXApp {
  5.  
  6.  
  7. static String[] a=new String[20];//новости в массиве
  8.  
  9. public static void main(String[] args) {
  10.  
  11.  
  12. RssParser rp=new RssParser("https://news.mail.ru/rss/politics/91/");
  13.  
  14. rp.parse();//вызываю метод
  15. RssFeed feed = rp.getFeed();
  16. // Listing all categories & the no. of elements in each category
  17. if (feed.category != null)
  18. {
  19. System.out.println("Category: ");
  20. for (String category : feed.category.keySet())
  21. {
  22. System.out.println(category
  23. + ": "
  24. + ((ArrayList<Item>)feed.category.get(category)).size());
  25. }
  26. }
  27. //// ВЫВОЖУ В КОНСОЛИ НОВОСТИ
  28. for (int i = 0; i < feed.items.size(); i++){
  29. System.out.println(feed.items.get(i).title);
  30. a[i]=feed.items.get(i).title;
  31.  
  32. }
  33.  
  34. DAO dao=new DAO();
  35. dao.h2GetConnection();//коннект к базе
  36.  
  37. }
  38.  
  39. }
  40. import java.sql.*;
  41.  
  42. public class DAO {
  43.  
  44.  
  45. private final static String DB_DRIVER = "org.h2.Driver";
  46. private final static String DB_URL = "jdbc:h2:~/test/test";
  47. private final static String DB_USERNAME = "kirill";
  48. private final static String DB_PASSWORD = "123";
  49. public static ResultSet resultSet;
  50.  
  51. public Connection h2GetConnection() {
  52. Connection connection = null;
  53. try {
  54. Class.forName(DB_DRIVER);
  55. connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
  56. System.out.println("Connection OK");
  57.  
  58. Statement st = null;
  59.  
  60. st = connection.createStatement();
  61.  
  62.  
  63. MySAXApp mySAXApp = new MySAXApp();
  64. System.out.println("ЗДЕСЯ!!!!!");
  65.  
  66. for (int i = 0; i < mySAXApp.a.length; i++) {
  67.  
  68.  
  69.  
  70. resultSet = st.executeQuery("INSERT INTO NEWS(NEWS_ID,NAME_OF_NEWS) VALUES (" + i + "),(" + mySAXApp.a[i] + ")");
  71.  
  72.  
  73. }
  74.  
  75. ////////////////////// проверка////////////////////////////////////////
  76. System.out.println("SELECT ALL");
  77.  
  78. st.execute("select * from NEWS");
  79.  
  80.  
  81. while (resultSet.next()) {
  82.  
  83. int id = resultSet.getInt("NEWS_ID");
  84. String name = resultSet.getString("NAME_OF_NEWS");
  85.  
  86. System.out.println();
  87. }
  88.  
  89.  
  90. } catch (SQLException e) {
  91. e.printStackTrace();
  92. System.out.println("Connection ERROR");
  93. } catch (ClassNotFoundException e) {
  94. e.printStackTrace();
  95. System.out.println("Connection ERROR");
  96. }
  97. return connection;
  98. }
  99. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement