/*
 * 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 db;


import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javafx.application.Application;
import static javafx.application.Application.launch;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Pos;
import javafx.scene.Scene;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.TextField;
import javafx.scene.input.KeyEvent;
import javafx.scene.layout.GridPane;
import javafx.scene.layout.StackPane;
import javafx.stage.Stage;

/**
 *
 * @author ASUS
 */
public class Trying extends Application {

        Label L1 = new Label("ID");
        Label L2 = new Label("First Name");
        Label L3 = new Label("Last Name");
        Label L4 = new Label("Age");
        TextField textNum1 = new TextField();
        TextField textNum2 = new TextField();
        TextField textNum3 = new TextField();
        TextField textNum4 = new TextField();
        Button btnadd = new Button("Add");
        Button btndel = new Button("Delete");
        Button btnup = new Button("Update");
        Button R = new Button("Make New Entry");

        Label dissum = new Label();
        Label msgsum = new Label("SUM: ");

    @Override
    public void start(Stage primaryStage) {
        GridPane myPane = new GridPane();

        myPane.setHgap(10);
        myPane.setVgap(10);

        Scene sc = new Scene(myPane,600,600);
        primaryStage.setScene(sc);
        primaryStage.show();
        primaryStage.setTitle("Student Managment System");

        myPane.add(L1, 0, 0);myPane.add(textNum1,1,0);
        myPane.add(L2, 0, 1);myPane.add(textNum2,1,1);//1,2
        myPane.add(L3, 0, 2);myPane.add(textNum3,1,2);//2,2
        myPane.add(L4, 0, 3);myPane.add(textNum4,1,3);//3,2
        myPane.add(btnadd, 2, 1);
        myPane.add(btndel, 2, 2);
        myPane.add(btnup, 2, 3);
        myPane.add(R, 2, 4);









        myPane.setAlignment(Pos.CENTER);




         btnadd.setOnAction(new EventHandler<ActionEvent>() {

             String dbURL = "jdbc:mysql://localhost:3306/baal";
             String username = "root";
             String password = null;
            @Override
                public void handle(ActionEvent event) {
                try (Connection conn = DriverManager.getConnection(dbURL, username, password)) {


			String sql = "INSERT INTO user (fname, lname, age) VALUES (?, ?, ?)";

			PreparedStatement statement = conn.prepareStatement(sql);
			statement.setString(1, textNum2.getText());
			statement.setString(2, textNum3.getText());
			statement.setString(3, textNum4.getText());


			int rowsInserted = statement.executeUpdate();
			if (rowsInserted > 0) {
				System.out.println("A new user was inserted successfully!");
			}


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

            }
        });





         btnup.setOnAction(new EventHandler<ActionEvent>() {
                String dbURL = "jdbc:mysql://localhost:3306/baal";
                String username = "root";
                String password = null;

                @Override
                public void handle(ActionEvent event) {


		try (Connection conn = DriverManager.getConnection(dbURL, username, password)) {

			String sql = "UPDATE user SET  fname=?, lname=? ,age=? WHERE id=?";

			PreparedStatement statement = conn.prepareStatement(sql);
			statement.setString(1, textNum2.getText());
			statement.setString(2, textNum3.getText());
			statement.setString(3, textNum4.getText());
			statement.setString(4, textNum1.getText());

			int rowsUpdated = statement.executeUpdate();
			if (rowsUpdated > 0) {
				System.out.println("An existing user was updated successfully!");
			}


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

        });


         btndel.setOnAction(new EventHandler<ActionEvent>() {
                String dbURL = "jdbc:mysql://localhost:3306/baal";
                String username = "root";
                String password = null;

                @Override
                public void handle(ActionEvent event) {


		try (Connection conn = DriverManager.getConnection(dbURL, username, password)) {

			String sql = "DELETE FROM user WHERE id=?";

			PreparedStatement statement = conn.prepareStatement(sql);
			statement.setString(1,textNum1.getText());

			int rowsDeleted = statement.executeUpdate();
			if (rowsDeleted > 0) {
				System.out.println("A user was deleted successfully!");
			}

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

        });



         R.setOnAction(new EventHandler<ActionEvent> (){
            @Override
            public void handle(ActionEvent event) {
                textNum1.setText("");
                textNum2.setText("");
                textNum3.setText("");
                textNum4.setText("");
            }
        });
    }




    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        launch(args);
    }

}