JSP JAVA MYSQL BOOTSTAP POJECT ON SOCIAL MEDIA WEBSITE LIKE FACEBOOK TWITTER

The JSP project is based on Social Media websites like Facebook, Twitter where user can post, comment, make friends and express their feeling. The project is build upon JSP, Servlet, Java, MySQL, Tomcat Server, HTML and BootStrap. The Student can modify the project with their own ideas to meet their requirements. 
The project working is like where we can send Post, Comment on Post, Send Friend request, Delete user where it has the ability to automatically delete all the posts, comments, friend requests of the delete user.
Software Required:
The project is made using Eclipse IDE and MySQL Server. Following are the requirements.
  1. Eclipse JAVA IDE 
  2. MySQL DATABASE 
  3. JDBC Connector for database
  4. TomCat Server
Statements for creating database and tables in MySQL:
  • In this project the database have the name : CipherBooK
Following are the Tables:
  • users (uid, uname, uemail, upass, udob, ugender, uloc, uimage);
create table users(
uid int unsigned not null primary key auto_increment,
uname varchar(30) not null,
uemail varchar(60) not null,
upass varchar(30) not null,
udob date null,
ugender enum('Male','Female') not null,
uloc varchar(30) not null,
uimage blob 
);
  • posts (pid, uid, ptitle, pbody, pdate);
create table posts(
pid int unsigned not null primary key auto_increment,
uid int unsigned not null,
ptitle varchar(30) not null,
pbody text not null,
pdate date not null,
constraint fk_user foreign key(uid) references users(uid) 
on delete cascade 
on update cascade
);
  • relationship (user_one_id, user_two_id, status, action_user_id);
CREATE TABLE relationship(
user_one_id INT NOT NULL REFERENCES Users(uid) on delete cascade on update cascade,
user_two_id INT NOT NULL REFERENCES Users(uid) on delete cascade on update cascade,
status INT NOT NULL default 0,
action_user_id INT NOT NULL,
CONSTRAINT CheckOneWay CHECK (user_one_id < user_two_id),
CONSTRAINT UQ_Friends_Pairs UNIQUE (user_two_id, user_one_id),
CONSTRAINT PK_Friends_Pairs PRIMARY KEY (user_one_id, user_two_id)
);
  • comments( cid, uid, pid, cbody, cdate)
create table comments(
cid int unsigned not null primary key auto_increment,
pid int unsigned not null,
uid int unsigned not null,
cbody text not null,
cdate date not null,
constraint fk_post foreign key(pid) references posts(pid) 
on delete cascade on update cascade
);
Steps:
Download the Project and extract it.
  1. The in Eclipse File-> New -> Dynamic Web Project.
  2. Select the target runt me as Tomcat Folder and keep the Dynamic web module version as 3.0
  3. Copy the files as per Folders are given in the project.
  4. Download and Copy the JAR file in WEB-INF -> lib folder.
Tips for errors:
  1. Make sure that Apache Tomcat server in check in eclipse Properties -> Targeted Runtime
  2. Change Build Path JRE System Library in Properties -> Java Build Path
  3. Import the packages



This Image will help you to organize the files and packages(Folders).

After Reading the whole boring stuff here is the download(Make sure you read it, It's Important) Click here to download free projectSocial media project using JSP, Servlet, Java, MySQL and Bootstrap

27 Comments

  1. Replies
    1. Great Article
      Cloud Computing Projects


      Networking Projects

      Final Year Projects for CSE


      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. Comfortabl y, the post is really the freshest on that deserving topic. I harmonise with your conclusions and definitely will thirstily look forward to your next updates.

    website builder for reseller

    ReplyDelete
  3. Thank you for the link building list.I am going jot down this because it will help me a lot.Great blog! Please keep on posting such blog.

    private label website builder

    ReplyDelete
  4. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me

    white label website builder

    ReplyDelete
  5. I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective. Techno-based information has been fetched in each of your topics. Sure it will enhance and fill the queries of the public needs. Feeling so glad about your article. Thanks…!
    best software testing training in chennai
    best software testing training institute in chennai with placement
    software testing training
    courses

    software testing training and placement
    software testing training online
    software testing class
    software testing classes in chennai
    best software testing courses in chennai
    automation testing courses in chennai

    ReplyDelete
  6. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete
  7. Each new moment is very interesting because it allows you to work more productively and shows what was previously unknown to you.

    ReplyDelete
  8. All your articles look very effective because you show us a lot of important data and useful up-to-date information.

    ReplyDelete
  9. This project surely needs to be worked on more because a big quantity of problems and errors is very distracting while using.

    ReplyDelete
  10. I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective. share more
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  11. This is of utmost importance because Twitter is now included in the mainstream media. Huge numbers of entrepreneurs, brands, celebrities as well as other people use Twitter every day. Follow LinkW88moinhat on Twitter

    ReplyDelete
  12. Thanks for sharing this, I actually appreciate you taking the time to share with everybody.
    Best Institute For Data Science In Hyderabad

    ReplyDelete
  13. digital marketing company in chennai
    mobile app development company in chennai
    ios app development company in chennai
    shakthi tech

    shakthi technologies

    ReplyDelete
  14. android app development company in chennai
    payroll software development companies in chennai
    payroll application development company in chennai
    shakthitech

    website development company in chennai

    ReplyDelete
  15. digital marketing company in chennai
    mobile app development company in chennai
    ios app development company in chennai
    shakthi tech

    shakthi technologies

    ReplyDelete
  16. website designers in chennai - Shakthi tech has the well-trained website professionals to give the best results to the customers
    ecommerce website development company in chennai - ecommerce website development company with the standard features
    software development company in chennai - shakthi tech has well experineced with diverse set of team for custom software development services
    website development company in chennai - Website Development company

    ReplyDelete