Author
Md Faiz Akram

User Name: faiz.krm@gmail.com
password:- 1234

Projcect Features

• Spring MVC
• Spring Security
• Hibernate
• Maven
• JSP
• Mailing API
• File Uploading
• File Compressor
• Ajax Call with File Uploading
• JSTL
• JSP
• HTML
• CSS
• jQuery
• JS
• BootStrap
• Sweet Alert JS
• Basic Dashboard
• Basic Profile

Connection Pulling using hibernate c3p0

Mailing API Configuration

ViewResolver Configuration

Genrate you own Password org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder

import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;

	public static void main(String[] args) {
		 int i = 0;
		 while (i < 10) {
		  String password = "1234";
		  BCryptPasswordEncoder passwordEncoder = new BCryptPasswordEncoder();
		  String hashedPassword = passwordEncoder.encode(password);
		  System.out.println(hashedPassword);
		  i++;
		 }}}

Project Table Schema View

accer

 

• roles

• user_profile

• user_role

• user_verfication

• users

 

roles

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
Id	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
Role	varchar(20)	latin1_swedish_ci	NO		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

roles

0

PRIMARY

1

Id

A

4

(NULL)

(NULL)

BTREE

roles

0

Role_Id

1

Id

A

4

(NULL)

(NULL)

BTREE

Back

 

user_profile

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
User_Email_Id	varchar(60)	latin1_swedish_ci	NO	PRI	(NULL)		select,insert,update,references
Name	varchar(60)	latin1_swedish_ci	NO		(NULL)		select,insert,update,references
DOB	varchar(20)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
DOJ	varchar(60)	latin1_swedish_ci	NO		(NULL)		select,insert,update,references
MobileNo	varchar(10)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Skype	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
LinkedIn	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Facebook	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Twitter	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
GooglePlus	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Website	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Address	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
ProfilePic	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

user_profile

0

PRIMARY

1

User_Email_Id

A

4

(NULL)

(NULL)

BTREE

user_profile

1

User_Email_Id

1

User_Email_Id

A

4

(NULL)

(NULL)

BTREE

user_profile

1

ix_some_id

1

User_Email_Id

A

4

(NULL)

(NULL)

BTREE

Back

 

user_role

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
User_Id	int(11)	(NULL)	NO	MUL	(NULL)		select,insert,update,references
Role_Id	int(11)	(NULL)	NO	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

user_role

1

FK143BF46A7214966

1

Role_Id

A

4

(NULL)

(NULL)

BTREE

user_role

1

FK143BF46AAC4C0D46

1

User_Id

A

4

(NULL)

(NULL)

BTREE

Foreign Key Relationships

FK Id	Reference Table	Source Column	Target Column	Extra Info
user_role_ibfk_1	users	`User_Id`	`Id`	ON DELETE CASCADE ON UPDATE CASCADE,
user_role_ibfk_2	roles	`Role_Id`	`Id`	ON DELETE CASCADE ON UPDATE CASCADE

Back

 

user_verfication

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
Verification_Id	int(10)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
User_Email_Id	varchar(60)	latin1_swedish_ci	NO	MUL	(NULL)		select,insert,update,references
Admin_Email_Verification	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
User_Email_Verification	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Mobile_Verification	varchar(10)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Forgot_Password	text	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
Account_Status	varchar(20)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

user_verfication

0

PRIMARY

1

Verification_Id

A

3

(NULL)

(NULL)

BTREE

user_verfication

1

User_Email_Id

1

User_Email_Id

A

3

(NULL)

(NULL)

BTREE

Foreign Key Relationships

FK Id	Reference Table	Source Column	Target Column	Extra Info
user_verfication_ibfk_1	user_profile	`User_Email_Id`	`User_Email_Id`	ON DELETE CASCADE ON UPDATE CASCADE

Back

 

users

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
Id	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
User_Email_Id	varchar(60)	latin1_swedish_ci	NO	UNI	(NULL)		select,insert,update,references
Password	varchar(60)	latin1_swedish_ci	NO		(NULL)		select,insert,update,references
Enable	tinyint(1)	(NULL)	NO		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

users

0

PRIMARY

1

Id

A

4

(NULL)

(NULL)

BTREE

users

0

User_Id

1

Id

A

4

(NULL)

(NULL)

BTREE

users

0

Email_Id

1

User_Email_Id

A

4

(NULL)

(NULL)

BTREE

Foreign Key Relationships

FK Id	Reference Table	Source Column	Target Column	Extra Info
users_ibfk_1	user_profile	`User_Email_Id`	`User_Email_Id`	ON DELETE CASCADE ON UPDATE CASCADE

Back