UniversitiesDAO.java

package ru.pritykovskaya;

import java.io.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

/**
 * User: pritykovskaya
 * Date: 26.09.11
 */
public class UniversitiesDAO {
    public static void main(String[] args) {
        for (int i = 0; i < 10; i++) {
            File file = new File("sdf.txt");
            try {
                Reader reader = new FileReader(file);
            } catch (FileNotFoundException e) {
                e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
            }
        }

    }

    private Connection connection;

    public void connectToDB() throws SQLException {
        connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/helloyandex",
                "pritykovskaya", "");

        if (connection == null) {
            throw new SQLException();
        }
    }

    public void add(University university) throws SQLException {
        Statement stmt = connection.createStatement();
        stmt.executeUpdate("INSERT INTO UNIVERSITIES (NAME) VALUES ('" + university.getName() + "')", Statement.RETURN_GENERATED_KEYS);
        stmt.close();
    }

    public List<University> getAll() throws SQLException {
        Statement stmt = connection.createStatement();
        ResultSet resultSet = stmt.executeQuery("SELECT ID, NAME FROM UNIVERSITIES");

        List<University> universities = new ArrayList<University>();
        while (resultSet.next()) {
            universities.add(new University(resultSet.getInt(1), resultSet.getString(2)));
        }

        return universities;
    }

    public void closeConnection() throws SQLException {
        connection.close();
    }
}