How vikas7075/crud-operation-in-java-jdbc works
Project type and purpose
• This is a simple full-stack Java console application that performs CRUD operations on an Employees table in a MySQL database.
• The user interacts via the console; the application uses JDBC to connect to a local XAMPP-hosted MySQL server.
File structure
• Top level:
• README.md – project description
• crud/ – IntelliJ project folder
• Inside crud/:
• src/Main.java – single entry point and UI + logic
• lib/mysql-connector-java-8.0.11.jar – JDBC driver
• out/production/crud – compiled classes
• No separate “data access” or “service” packages, so the layers are co-located in Main.java.
README for additional insights
• Technology stack: Java 8, Java Console, XAMPP, MySQL, JDBC API
• Process steps: loading driver, establishing connection, creating statement, executing query, closing connection
Detail
• Five JDBC steps in the data access layer as sub-steps or annotations.
• Localhost network connection (TCP port 3306) between the Connector/J and MySQL server.