q

diff --git a/pom.xml b/pom.xml
index c9aec19..0d77d53 100644
--- a/pom.xml
+++ b/pom.xml
@@ -38,6 +38,7 @@
             <version>${junit.version}</version>
             <scope>test</scope>
         </dependency>
+
     </dependencies>
 
     <build>
diff --git a/src/main/SQL/create_library.sql b/src/main/SQL/create_library.sql
index e69de29..a6cf9ec 100644
--- a/src/main/SQL/create_library.sql
+++ b/src/main/SQL/create_library.sql
@@ -0,0 +1,9 @@
+drop database library;
+create database library;
+use library;
+create table book(
+    title varchar(30),
+    publisher varchar(30),
+    copies int,
+    ISBN long PRIMARY KEY,
+);
\ No newline at end of file
diff --git a/src/main/java/abinladin/libraryapplication/BookController.java b/src/main/java/abinladin/libraryapplication/BookController.java
index 3ef14e3..0a0308f 100755
--- a/src/main/java/abinladin/libraryapplication/BookController.java
+++ b/src/main/java/abinladin/libraryapplication/BookController.java
@@ -6,7 +6,7 @@ import javafx.fxml.FXML;
 import javafx.scene.control.Button;
 import javafx.scene.control.DatePicker;
 import javafx.scene.control.TextField;
-
+import java.sql.*;

 
 public class BookController {
 
@@ -44,6 +44,18 @@ public class BookController {
 
         bookArrayList.add(book);
 
+

+       try {

+            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/library", "root", "Abdullah@2511");

+            Statement statement = con.createStatement();

+

+            String query = String.format("insert into book values(\"%s\",\"%s\",\"%s\");", book.getTitle(), book.getAuthor(), book.getPublisher());

+            statement.executeUpdate(query);

+

+        } catch (SQLException e) {

+            e.printStackTrace();

+        }

+

         titleField.clear();
         authorField.clear();
         publisher.clear();
diff --git a/src/main/java/abinladin/libraryapplication/MainApplication.java b/src/main/java/abinladin/libraryapplication/MainApplication.java
index aaf15b8..e3c3d3b 100755
--- a/src/main/java/abinladin/libraryapplication/MainApplication.java
+++ b/src/main/java/abinladin/libraryapplication/MainApplication.java
@@ -17,6 +17,7 @@ public class MainApplication extends Application {
         stage.setScene(scene);
         stage.setResizable(false);
         stage.show();
+
     }
 
     public static void main(String[] args) {
diff --git a/src/main/java/module-info.java b/src/main/java/module-info.java
index 98af036..b76cc7c 100644
--- a/src/main/java/module-info.java
+++ b/src/main/java/module-info.java
@@ -1,6 +1,7 @@
 module abinladin.libraryapplication {
     requires javafx.controls;
     requires javafx.fxml;
+    requires java.sql;
 
 
     opens abinladin.libraryapplication to javafx.fxml;