Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.util.ArrayList;
- import java.util.List;
- public class MySAXApp {
- static String[] a=new String[20];//новости в массиве
- public static void main(String[] args) {
- RssParser rp=new RssParser("https://news.mail.ru/rss/politics/91/");
- rp.parse();//вызываю метод
- RssFeed feed = rp.getFeed();
- // Listing all categories & the no. of elements in each category
- if (feed.category != null)
- {
- System.out.println("Category: ");
- for (String category : feed.category.keySet())
- {
- System.out.println(category
- + ": "
- + ((ArrayList<Item>)feed.category.get(category)).size());
- }
- }
- //// ВЫВОЖУ В КОНСОЛИ НОВОСТИ
- for (int i = 0; i < feed.items.size(); i++){
- System.out.println(feed.items.get(i).title);
- a[i]=feed.items.get(i).title;
- }
- DAO dao=new DAO();
- dao.h2GetConnection();//коннект к базе
- }
- }
- import java.sql.*;
- public class DAO {
- private final static String DB_DRIVER = "org.h2.Driver";
- private final static String DB_URL = "jdbc:h2:~/test/test";
- private final static String DB_USERNAME = "kirill";
- private final static String DB_PASSWORD = "123";
- public static ResultSet resultSet;
- public Connection h2GetConnection() {
- Connection connection = null;
- try {
- Class.forName(DB_DRIVER);
- connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
- System.out.println("Connection OK");
- Statement st = null;
- st = connection.createStatement();
- MySAXApp mySAXApp = new MySAXApp();
- System.out.println("ЗДЕСЯ!!!!!");
- for (int i = 0; i < mySAXApp.a.length; i++) {
- resultSet = st.executeQuery("INSERT INTO NEWS(NEWS_ID,NAME_OF_NEWS) VALUES (" + i + "),(" + mySAXApp.a[i] + ")");
- }
- ////////////////////// проверка////////////////////////////////////////
- System.out.println("SELECT ALL");
- st.execute("select * from NEWS");
- while (resultSet.next()) {
- int id = resultSet.getInt("NEWS_ID");
- String name = resultSet.getString("NAME_OF_NEWS");
- System.out.println();
- }
- } catch (SQLException e) {
- e.printStackTrace();
- System.out.println("Connection ERROR");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- System.out.println("Connection ERROR");
- }
- return connection;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement