package e_commerce;
import java.sql.*;

public class DaoCategorie {

	private static Connection conn=null;

	static {

		try {

			Class.forName("com.mysql.jdbc.Driver");

			conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/5novembre", "root", "");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void inserimento(ModelCategorie p) {
		String sql="Insert into categorie (categoria) values (?)";
		PreparedStatement ps;

		try {
			ps= conn.prepareStatement(sql);
			ps.setString(1, p.getCategoria());
			ps.executeUpdate();

		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void cancellamento(ModelCategorie p) {
		String sql="Delete from categorie (categoria) values (?)";
		PreparedStatement ps;

		try {
			ps= conn.prepareStatement(sql);
		ps.setString(1, p.getCategoria());
		ps.executeUpdate();


		} catch (SQLException e) {
			e.printStackTrace();
		}
	}



}