Java Backend Ep1

HelloWorld source code:

https://www.mediafire.com/file/0gutnq32hpbce4m/HelloWorld.zip

1. Database script

DROP DATABASE IF EXISTS FullStackDev;

CREATE DATABASE IF NOT EXISTS FullStackDev;

USE FullStackDev;

-- Create table User --

DROP TABLE IF EXISTS `User`;


CREATE TABLE IF NOT EXISTS `User` (id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                                                                               username VARCHAR(50) NOT NULL);

-- Insert data

INSERT INTO `User` (username) VALUE ('Thach Pham Dev'), ('Jade Enginner'), ('Antony Theta');

 

2. Hibernate config template

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- Database connection settings --> <property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost:3306/FullStackDev</property> <property name="connection.username">root</property> <property name="connection.password">root</property> <!-- format code SQL --> <property name="show_sql">true</property> <property name="hibernate.format_sql">true</property> <property name="connection.pool_size">10</property> <!-- other --> <property name="hibernate.connection.characterEncoding">utf8</property> </session-factory> </hibernate-configuration>