/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package pulseapp;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import java.sql.*;

/**
 *
 * @author ASUS
 */
public class ConnBD {
  Connection con = null ;
   PreparedStatement pst = null ;
   ResultSet rs=null ;
   Statement st;

    public  ConnBD() {
        try {
             Class.forName("com.mysql.cj.jdbc.Driver");
      con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bd?serverTimezone=UTC","root","");
     st = con.createStatement();
     System.out.println("succes");
    }




    catch (Exception ex) {
     System.out.println("Error: " + ex);
     System.out.println("ylaaen din rabeek");

 }

}
     public void ajouter(int IDBook,String Type,String Title,String Author,float Price,int Quantity) {
       try {
        st = con.createStatement();
        String sql = "INSERT INTO stock VALUES('"+IDBook+"','"+Type+"','"+Title+"','"+Author+"','"+Price+"','"+Quantity+"')";
        st.executeUpdate(sql);
    }
  catch (Exception ex)
         {
              JOptionPane.showMessageDialog(null, ex);
         }

    }
     public void supprimer(int IDBook1){
       try {

              String query = "SELECT * FROM `stock` WHERE IDBook=?";
              pst = con.prepareStatement(query);
            pst.setInt(1, IDBook1);
             ResultSet rs = pst.executeQuery();



         if(rs.next()){
              st = con.createStatement();
        String sql = "DELETE FROM `stock` WHERE IDBook="+IDBook1;
        st.executeUpdate(sql);
        JOptionPane.showMessageDialog(null, "Deleted Scuccessfully");


        }
         else {
             JOptionPane.showMessageDialog(null, "Key Invalid");
         }
    }
  catch (Exception ex)
         {
              JOptionPane.showMessageDialog(null, ex);
         }
     }
     public void update(int IDBook1,String Type1,String Title1,String Author1,float Price1,int Quantity1){
         try{
        String query = "SELECT * FROM `stock` WHERE IDBook=?";
              pst = con.prepareStatement(query);
            pst.setInt(1, IDBook1);
             ResultSet rs = pst.executeQuery();



         if(rs.next()){
              st = con.createStatement();
          String sql ="UPDATE `stock` SET `Type`='"+Type1+"',`Title`='"+Title1+"',`Author`='"+Author1+"',`Price`='"+Price1+"',`Quantity`='"+Quantity1+"'WHERE `IDBook`='"+IDBook1+"'";




          st.executeUpdate(sql);
           JOptionPane.showMessageDialog(null, "Updated With Sucess");
         }
         else {
             JOptionPane.showMessageDialog(null, "Not Founded");
         }
         }
         catch (Exception ex)
         {
              JOptionPane.showMessageDialog(null, ex);
         }

     }


}