package exam;

import java.sql.*;
import java.util.InputMismatchException;
import java.util.Scanner;

public class Main4 {
	private static final String ADD_ITEM_QUERY = "insert into items (name, description, price) values(?, ?, ?);";

	public static Connection getConn(String url) throws SQLException{
		return DriverManager.getConnection(url, "root", "coderslab");
	}

	public static void addItem(Connection conn, String name, String description, double price) throws SQLException{
		try(PreparedStatement preparedStatement = conn.prepareStatement(ADD_ITEM_QUERY)){
			preparedStatement.setString(1, name);
			preparedStatement.setString(2, description);
			preparedStatement.setDouble(3, price);
			int i = preparedStatement.executeUpdate();
			if (i == 1){
				System.out.println("Dodano");
			}
			else{
				System.out.println("Błąd dodawania");
			}
		}
	}

	public static void main(String[] args){
		Scanner scan = new Scanner(System.in);
		String name, desc;
		double price;
		while(true){
			System.out.println("Podaj dane:\nNazwa przedmiotu");
			name = scan.nextLine();
			System.out.println("Opis przedmiotu");
			desc = scan.nextLine();
			System.out.println("Cena przedmiotu");
			try{
				price = scan.nextDouble();
				scan.nextLine();
			} catch(InputMismatchException e){
				System.out.println("Niepoprawne dane, spróbuje jeszcze raz");
				scan.nextLine();
				continue;
			}
			break;
		}
		String url = "jdbc:mysql://localhost:3306/exam_2" ;
		try(Connection conn = getConn(url)){
			addItem(conn, name, desc, price);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		scan.close();


	}

}