Just a simple JEE shop I made as a proyect for my school to get confident with servlets and jsp.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.
First and foremost, this is a tutorial for Arch-based distro's users, if it is not your case you will need to learn how to install the packages for your distros. The rest of the tutorial is the same.
I hope you did not need help to install this. Anyway here is the archwiki page about java. If you are not familiar with JDK8 new features please check this CheatSheet out.
In my case I will choose openJDK11 because is the LTS version of the JDK.
sudo pacman -Syu
sudo pacman -S jdk11-openjdk
Now we need to set the JAVA_HOME in my case I will set it for all users so I just add this at the end of /etc/profile
#JAVA
export JAVA_HOME="/usr/lib/jvm/java-11-openjdk"
export PATH=$JAVA_HOME/bin:$PATH
In case you would prefer to set the JAVA_HOME only for your user just add the same lines on ~/.bash_profile If you want to know more about the bash configuration files please check the wiki
After that restart your machine.
reboot
In order to run this software you will need to install Eclipse IDE for java EE developers. You can not install several eclipse versions because they will conflict so if it is your case you will need to find the way to keep both. You cant get more info here.
sudo pacman -Syu
sudo pacman -S eclipse-jee
MariaDB is nowdays the default relational database solution for Arch Linux so it will be my choice.
sudo pacman -Syu mariadb mariadb-clients libmariadbclient
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl start mysqld.service
sudo systemctl enable mysqld.service
Now we need to create owr db. First of all we will log into owr mariadb server.
sudo mysql -u root
So go ahead and create the shop's db and a new user.
CREATE DATABASE shop;
GRANT ALL ON shop.* TO 'shopadmin'@localhost IDENTIFIED BY 'shop';
FLUSH privileges;
exit
We can now login with this new user which have all privileges on that bd.
mysql -u shopadmin -p
Let's create the tables we need now.
use shop
CREATE TABLE IF NOT EXISTS customers(
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(10) NOT NULL,
password VARCHAR(20) NOT NULL);
CREATE TABLE IF NOT EXISTS products (
idProduct INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
description VARCHAR(40) NOT NULL,
price FLOAT(7,2) NOT NULL);
CREATE TABLE IF NOT EXISTS bills (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
client_id INT NOT NULL,
purchase_date DATETIME NOT NULL);
CREATE TABLE IF NOT EXISTS bill_lines(
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
bill_id INT NOT NULL,
product_id INT NOT NULL,
units INT NOT NULL CHECK( UNITS > 0));
Tomcat is the server that will allow us to execute owr projet.In order to install Tomcat just download it form here or use wget.
If you have download the tar.gz version execute this commands to extract it and move it to your home directory.
cd ~/Downloads
tar -xvzf apache-tomcat-9.x.xx.tar.gz
mv apache-tomcat-9.x.xx ~/Tomcat
Now we need to change the file permissions under the directory bin to allow Eclipse to execute Tomcat
sudo chmod +x ~/Tomcat/bin/*
This Tomcat installation is only for development and testing purposes, so if you want to use Tomcat to deploy your JavaEE application you will need to follow a few more steps that I will add on an md file on the future.
- MySQL's Connector/J - The official connector for MySQL database which is compatible with MariaDB. More info here
- servlet-api.jar - Included with Tomcat (under the directory lib)
- jsp-api.jar - Included with Tomcat (under the directory lib)
For some reason I can not just import this project with the git tool that eclipse provides. So I just created a new Dynamic Web Project (Dynamic web module 4.0 and named JEEShop), then I deleted the MANIFIEST.MF and I open my terminal and I start a git repository on the proyect's directory.
cd eclipse-workspace/JEEShop
git init
git remote add origin https://github.com/seniorglez/JEEShop.git
git pull origin master
Now we have the full project but eclipse will not show the files we just pull, we just need to refresh the project. All we need to do is right click on the project and select Refresh (or press F5).
- Eclipse - The IDE I used
- Tomcat - The Java Servlet and JavaServer Pages implementation
- MariaDB - The relational database solution
Feel free to fork it and made pull request if I made something wrong but please keep in mind that it is just an example of servlet and jsp use.
- Diego Dominguez
JEEShop is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or any later version.
JEEShop is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with JEEShop. If not, see https://www.gnu.org/licenses/
I used GPL3 license because this is just an example of app and it will never turn on a real app because if you want to develop an real one you will prefer to use a framework like Hibernate. But if you are developing a server side application under GPL3 means that this app will provide HTML and not an executable program so another person could take your code, make changes on it and not publish his own version. If you want to keep your application full free please use AGPL3 instead of GPL3.