RESTful CRUD With Java and MySQL in Minutes

I keep receiving so many requests for an article on how to access MySQL database from Android application. Even though Android applications can have direct access to MySQL database server, that is not preferred due to security issues and high complexity. The easy and best solution is developing a REST web service to receive the requests from whatever the client (including Android applications) and execute them on the database connected with the web service.

There are so many articles already available on the Internet about how to create a web service to perform Create, Read, Update & Delete (CRUD) operations on a database and how to connect from an Android client. However, I wondered why most of them are using PHP to develop the web service! I believe developers find PHP a less painful language to develop web services than Java. In this article, I am going to show how to develop a RESTful CRUD Web service with Java in minutes. As a matured language Java has enough frameworks to make your task easy. I guarantee that you will never look back for a different language once you know the tools.

Prerequisite:

• Eclipse IDE for Java EE or any Java IDE with Apache Maven support. (I recommend IntelliJ IDEA)
• MySQL 5.x
• PhpMyAdmin or any other clients to access MySQL database
• Postman or any other REST Clients

Read More

JPA - Hello, World! using Hibernate

Java Persistence API (JPA) is a Java application programming interface specification that describes the management of relational data in applications using Java Platform, Standard Edition and Java Platform, Enterprise Edition. Various frameworks like Hibernate, EclipseLink and Apache OpenJPA provide object relational mapping according to JPA standards. This tutorial guides you to develop a simple Java Persistence API (JPA) based database application using Hibernate framework and MySQL database. 

Note: If you prefer Hibernate 5, visit to the new tutorial JPA - Hello, World! using Hibernate 5

You need Eclipse for Java EE developers and MySQL server in your system in-order to try this tutorial.

If you prefer to import the necessary libraries manually as shown in "Step 3 Without Maven", Eclipse for Java developers is enough. Those who prefer Maven projects, need to have M2Eclipse plugin in their Eclipse. This tutorial recommends Eclipse for Java EE, since it has M2Eclipse plugin by default. Also please be informed that the project attached at the end of this tutorial is created using Maven.

Step 1:

Create a database “javahelps” and a table “student” in MySQL.

CREATE DATABASE IF NOT EXISTS javahelps;

CREATE  TABLE javahelps.student ( 
student_id INT NOT NULL ,
student_name VARCHAR(45) NOT NULL ,
student_age INT NOT NULL ,
PRIMARY KEY (student_id) );

Read More

Hibernate - Hello, World! using Annotation Mapping

This tutorial explains you, how to develop a simple database application using Hibernate Object Relational Mapping (ORM) framework and MySQL database. This article uses Annotation for mapping; the XML mapping is explained in: Hibernate - Hello, World! using XML Mapping

You need Eclipse for Java EE developers and MySQL server in your system in-order to try this tutorial.

If you prefer to import the necessary libraries manually as shown in "Step 3 Without Maven", Eclipse for Java developers is enough. Those who prefer Maven projects, need to have M2Eclipse plugin in their Eclipse. This tutorial recommends Eclipse for Java EE, since it has M2Eclipse plugin by default. Also please be informed that the project attached at the end of this tutorial is created using Maven.

Step 1:

Create a database “javahelps” and a table “student” in MySQL.

CREATE DATABASE IF NOT EXISTS javahelps;

CREATE  TABLE javahelps.student ( 
student_id INT NOT NULL ,
student_name VARCHAR(45) NOT NULL ,
student_age INT NOT NULL ,
PRIMARY KEY (student_id) );

Read More

Hibernate - Hello, World! using XML Mapping

This tutorial explains you, how to develop a simple database application using Hibernate Object Relational Mapping (ORM) framework and MySQL database. This article uses XML mappings; the annotation mapping is explained in: Hibernate - Hello, World! using Annotation Mapping

You need Eclipse for Java EE developers and MySQL server in your system in-order to try this tutorial.

If you prefer to import the necessary libraries manually as shown in "Step 3 Without Maven", Eclipse for Java developers is enough. Those who prefer Maven projects, need to have M2Eclipse plugin in their Eclipse. This tutorial recommends Eclipse for Java EE, since it has M2Eclipse plugin by default. Also please be informed that the project attached at the end of this tutorial is created using Maven.

Step 1:

Create a database “javahelps” and a table “student” in MySQL.

CREATE DATABASE IF NOT EXISTS javahelps;

CREATE  TABLE javahelps.student ( 
student_id INT NOT NULL ,
student_name VARCHAR(45) NOT NULL ,
student_age INT NOT NULL ,
PRIMARY KEY (student_id) );

Step 2:

Create a new Java project “HibernateXML” in Eclipse.

Read More