Building a complete MVC CRUD database application from scratch

About

This is a project designed to build a fully functioning JSP/Servlet CRUD web application that connects to a database from scratch.

---

Disclaimer

All images used with permission of luv2code LLC, http://www.luv2code.com

---

ANY INDIVIDUAL OR CONTRIBUTER SHOULD BE ABLE TO FOLLOW ALONG JUST FINE IF THEY READ THE FULL DOCUMENTATION

• NOTE: For those who just want to get straight to the CRUD database app HOW-TO instructions, skip to (chapter 11 - 15) of the documentation file.

WARNING: Since the project is currently at it's initial stages, It may be subject to breaking changes.

When you get stuck, read the FULL DOCUMENTATION for more details or reach me :).

Usage

Getting Started

---

See Deployment for notes on how to deploy the project on a live system.

Prerequisites

---

What things you need to install (the software) and how to install them

1. You need at least JDK_v8 installed on your machine.

   • Steps to install a Java Development Kit (JDK).

2. You need to have a Java Application Server installed on your machine.

   • Installing Tomcat on Ms Windows.

   • Installing Tomcat on a Mac.

3. You need to have a Java Integrated Development Environment (IDE) on your machine.

   • Installing Eclipse on Ms Windows.

   • Installing Eclipse on a Mac.

4. You need to have a relational database management system. (RDMS) on your machine.

   • For this project, we used MySQL.

   • Installing MySQL on Unix/Linux and Mac.

   • Installing MySQL on Ms Windows.

5. [Optional] : You may want to have MySQL Workbench. This is simply a GUI tool that allows you to connect to your MySQL database.

6. Basics of JAVA and HTML.

Deployment

---

A step by step series of examples that tell you how to get a development environment running.

Follow these instructions ONLY after you've met ALL the requirements in the Prerequisites section.

1. First, open up your terminal and clone the repository to your Computer.

   git clone https://github.com/steven7mwesigwa/JspDatabaseApp.git

2. Start your favorite IDE (integrated development environment) i.e Netbeans, Eclipse or IntelliJ and open the project.

3. You may be required to connect your "IDE" to "Tomcat".

   • Connecting Eclipse to Tomcat.

   • Connecting Apache Netbeans to Tomcat.

4. Start MySQL server.

   • i.e for Unix/Linux, run service mysql start in your terminal.

5. Set up your project database with sample data.

6. Deploy the application to tomcat server.

   • This can be as easy as Right-clicking on the project in your IDE and clicking Deploy. i.e for Apache Netbeans.

7. Start tomcat server.

8. Once tomcat is ready, open your favorite browser and search for:

   • http://localhost:8084/JspDatabaseApp/

9. Enjoy :)

Built With

---

• Oracle Java SE 10.0.2 - A Java SE Development Kit for developing and running JAVA applications.

• MySQL 5.6 - MySQL is an open source relational database management system.

• Tomcat - An open source implementation of the Java Servlet, JavaServer Pages, Java Expression Language and Java WebSocket technologies.

• Apache Netbeans - An integrated development environment (IDE) for Java.

• Apache Ant - As a build tool for my web CRUD application.

  • NOTE: The project was changed to use maven instead from release version 1.0.0-beta and later releases.

Contributing

---

Feel free to contribute to anything. Even spotting typos and broken links would very much be appreciated :). Please don't hesitate to submit issues and pull-requests against this project.

1. Fork the repository.

   • This allows you to freely experiment with changes without affecting the original project.

2. Create your feature branch.

   • i.e (git checkout -b feature/fooBar)

3. Commit your changes.

   • i.e (git commit -am 'Add some fooBar')

4. Push to the branch.

   • i.e (git push origin feature/fooBar)

5. Create a new Pull Request.

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to me.

Versioning

---

We use SemVer for versioning. For the versions available, see the tags on this repository.

Authors

---

• Steven Mwesigwa - Portfolio - Twitter

License

---

This project is licensed under the MIT License - see the LICENSE file for more details

Release History

---

Check Release Notes for any changes.

Acknowledgments

---

• Thank you in advance to anyone who wishes to contribute to the project. Even fixing typos and poor english usage would very much be appreciated.

Attribution

All images in this project were adapted from Chad Darby's online course, available at JSP, Servlets and JDBC for Beginners: Build a Database App