badripaudel77/spring-hibernate-crud

SPRING + HIBERNATE + MYSQL CRUD APPLICATION

spring-hibernate-crud

SPRING + HIBERNATE + MYSQL CRUD APPLICATION

This project contains all the required starter files ( jar files for spring, hibernate, and xml files ) for basic crud type app. Im not using maven for dependency management so all jar jar files have been downloaded manually.

SPRING AND HIBERNATE CRUD APP USES THE MANUALLY DOWNLOADED JAR FILES MYSQL AS DATABASE DOES ADD, DELETE , UPDATE AND FETCH THE RECORD FROM THE TABLE DEFINED IN DB 5)TO RUN THIS PROJECT CLONE IT AND RUN THE SQL FILE ATTACHED IN HERE sql file query is : to create database first run : create database spring_hib_crud;

then to create table run the following :

CREATE TABLE customer ( id int(11) NOT NULL, first_name varchar(45) NOT NULL, last_name varchar(45) NOT NULL, email varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO customer (id, first_name, last_name, email) VALUES (13, 'Badri', 'Paudel', '[email protected]'), (15, 'Alisha ', 'Paudel', '[email protected]'), (18, 'Gita', 'Bhattarai', '[email protected]'), (19, 'Ganesh', 'Stha', '[email protected]'), (32, 'Woo', 'Jian', '[email protected]'), (35, 'Hari', 'Vai', '[email protected]');

ALTER TABLE customer ADD PRIMARY KEY (id);