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();
            ////////////////////ДАЛЬШЕ ПЫТАЮСЬ ДОБАВИТЬ НОВОСТИ В БД

            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;
    }
}