package com.company.database;

import java.sql.*;

/**
 * Created by Tomek on 3/7/2016.
 */
public class MySQLAccess {

    private Connection connection;
    private Statement statement;
    private PreparedStatement preparedStatement;
    private ResultSet resultSet;


    public void readDatabase() throws Exception{

        try{
            //ladowanie sterownika bazy danych
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql//localhost:82/nauka?"
                    +"user=root&password=");
            statement = connection.createStatement();

            resultSet = statement.executeQuery("select * from student");
            writeResultSet(resultSet);

        } catch (Exception e){
            throw e;
        } finally {

        }
    }

    public void writeResultSet(ResultSet resultSet) throws SQLException
    {
        while (resultSet.next())
        {
            String id_stud = resultSet.getString("id_stud");
            String name = resultSet.getString("name");
            String surname = resultSet.getString("surname");
            String birth_date = resultSet.getString("birth_date");
            String semester = resultSet.getString("semester");

            System.out.println(id_stud + name + surname + birth_date+semester + semester);

        }

    }



}