package laba1;

import java.sql.*;
import java.util.Properties;

public class Main {

    private static final String CONN_URL = "jdbc:mysql://localhost:3306/dblab";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "1111";

    public static void main(String[] args) throws ClassNotFoundException {
        Class.forName("com.mysql.jdbc.Driver");
        Properties props = new Properties();
        props.setProperty("user", USERNAME);
        props.setProperty("password", PASSWORD);
        Connection conn = null;
        Statement stmt;
        try {
              conn = DriverManager.getConnection(CONN_URL, props);
            stmt = conn.createStatement();
            System.out.println("Connected to database");
            String sql = "alter table second add gruppa7 text";
            stmt.executeUpdate(sql);
            sql = "update second set gruppa7='ka-67' where id='1'";
            stmt.executeUpdate(sql);
            sql = "update second set gruppa7='ka-24' where id='2'";
            stmt.executeUpdate(sql);
            sql = "update second set gruppa7='ka-53' where id='3'";
            stmt.executeUpdate(sql);
            sql = "select * from second";
            ResultSet rs = stmt.executeQuery(sql);
            //STEP 5: Extract data from result set
            while(rs.next()){
                System.out.println(rs.getInt("second.id") + ", " + rs.getString("second.surname") + ", "
                        + rs.getString("second.gruppa7"));
            }
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}