CRUD Program

SQL Script

 -- Drop the database if it already exists

DROP DATABASE IF EXISTS ThachPhamDevDb;

-- Create database

CREATE DATABASE IF NOT EXISTS ThachPhamDevDb;

USE ThachPhamDevDb;

-- Create table Group

DROP TABLE IF EXISTS `Students`;


CREATE TABLE IF NOT EXISTS `Students` (id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                                                                                   `name` NVARCHAR(50) NOT NULL UNIQUE KEY);

-- INSERT DATA
USE ThachPhamDevDb;


INSERT INTO `Students` (`name`) VALUE ('ThachPham'), ('Jade'), ('HuyenPham');

hibernate.cfg.xml

<?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/ThachPhamDevDb</property> <property name="connection.username">root</property> <property name="connection.password">1234@abcd</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>