import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

import static java.lang.System.out;
import static java.lang.System.in;
import java.util.Scanner;


public class MainClass {
    static final String url = "jdbc:mysql://saject.ru:3306/cs108?useUnicode=true&characterEncoding=UTF8";
    static final String user = "cs108";
    static final String password = "108";
    static Connection conn;

    public static void main(String[] args) {
        //cs108 || 108 || saject.ru
        PreparedStatement st = null;
        Scanner scan = new Scanner(in);

        int choice = scan.nextInt();
        String name = scan.nextLine();
        String color = scan.nextLine();
        int price = scan.nextInt();
        scan.close();


        try {
            conn  = DriverManager.getConnection(url, user, password);

            switch (choice) {
                case 0 : //insert
                    st = conn.prepareStatement("INSERT INTO flowers (name, price, color) VALUES (?, ?, ?)");

                    st.setString(1, name);
                    st.setInt(2, price);
                    st.setString(3, color);

                    st.executeUpdate();
                    //st = conn.prepareStatement("INSERT INTO flowers (name, price, color) VALUES ('" + name + "', " + price + ", '" + color + "')");
                    break;


                case 1 : //delete
                    st = conn.prepareStatement("DELETE FROM flowers WHERE name = ?");
                    st.setString(1, name);

                    st.executeUpdate();
                    //st = conn.prepareStatement("DELETE FROM flowers WHERE name = '" + name + "'"); //возможна SQL-инъекция
                    break;


                case 2 : //select
                    Statement st1 = conn.createStatement();
                    st1.executeQuery("SELECT name, price, color FROM flowers");

                    ResultSet rs = st1.getResultSet();

                    while (rs.next()) {
                        out.println(rs.getString(1) + " " + rs.getInt(2) + " " + rs.getString(3));
                    }
                    break;


                case 3 :
                    int id = scan.nextInt();
                    st = conn.prepareStatement("UPDATE flowers SET name = ?, price = ?, color = ? WHERE id = ?");

                    st.setString(1, name);
                    st.setInt(2, price);
                    st.setString(3, color);
                    st.setInt(4, id);
                    st.executeUpdate();
                    break;

                default : break;
            }


            conn.close();
            out.println("Выполнено");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}