Completed

Extract Json from PostgreSQL with Java Servlet

Hi

currently this Java retrieves elements from a .json file. These elements create a photo gallery developed with JQuery.

Requiments: Tomcat 9 and Java 8, PostgreSQL 10

1) EXTRACT FROM POSTGRESQL

*****************************************

I want Java to query PostgreSQL and get the elements to create the gallery directly from PostgreSQL.

The PostgreSQL table must be called "Contents" and must have 3 fields, the first "ID" (Serial) the second "MediaResult" (field type Json) and status (int) default is 0

Every single image must correspond to a line with relative ID.

The Java file that gets the .json file is as follows (see part of the code), Therefore, each section of similar Json code will be a different image and must therefore be saved in a line of the dedicated PostgreSQL (table) and with its unique ID for each image.

PS. To be clear this is the code Json related to an image in the gallery:

{

"title" : "Azuki bean",

"description" : "Swiss chard pumpkin bunya nuts maize plantain aubergine napa cabbage soko coriander sweet pepper water spinach winter purslane shallot tigernut lentil [login to view URL] chard pumpkin bunya nuts maize plantain aubergine napa cabbage.",

"thumbnail" : ["images/small/[login to view URL]", "images/small/[login to view URL]", "images/small/[login to view URL]", "images/small/[login to view URL]", "images/small/[login to view URL]"],

"large" : ["[login to view URL]", "images/large/[login to view URL]", "images/large/[login to view URL]", "images/large/[login to view URL]", "images/large/[login to view URL]"],

"img_title" : ["jquery elastic grid 1 ", "jquery elastic grid 2", "jquery elastic grid 3", "jquery elastic grid 4", "jquery elastic grid 5"],

"button_list" :

[

{ "title":"Demo", "url" : "[login to view URL]", "new_window" : true },

{ "title":"Download", "url":"[login to view URL]", "new_window" : false}

],

"tags" : ["Self Portrait"]

}

Summing up Java will have to get the results from PostgreSQL and no longer from the .json file

2) IMPORT FROM CSV

*****************************************

I have a CSV with the following fields:

DESCRIPTION | TITLE | THUMB | CATEGORY | URL

I would like a Servlet requesting through the form to select the .CSV file and save the various fields in Json, with the format of part 1 (attached .json file).

Then the fields will match as follows:

DESCRIPTION = description

TITLE = title

THUMB = thumbnail (value is one or multiple, as in example)

CATEGORY = tags (value is one or multiple, as in example)

URL = is this part: { "title":"Demo", "url" : "[login to view URL]", "new_window" : true }

3) APPROVATION

*****************************************

The third and last part consists in moderating the contents loaded by the CSV file.

It must be a servlet that in sequence will show a preview of the image, the title and the url + 2 button

1. APPROVED = value 1

2. DECLINED = value 2

Now there is a small change to be made to Part 1 (EXTRACT FROM POSTGRESQL)

They will only be extracted, and then the visible images with the value 1 (Approved)

Each time you access the approval servlet, it will start displaying images with a value of 0, making sure that all images are moderated gradually.

PS. Once an image is approved or declined, the servlet will show the next image Not moderate.

Taidot: Java, Javascript, JSON, PostgreSQL

Näytä lisää: ajax post java servlet, java servlet ajax, java servlet ajax chat, php chat ajax java servlet, extract sample audio java, example ajax java servlet, sql server database java servlet, send lotus notes mail via java servlet, ajax java servlet, java servlet json xml, atm simulation java servlet sample, active user tracking struts java servlet, java servlet login system, paypal ipn java servlet, create xml java servlet, stock postgresql java, download source code online leave management java servlet, java servlet api json, java servlet login download

Tietoa työnantajasta:
( 17 arvostelua ) Chiasso, Switzerland

Projektin tunnus: #17566236

Myönnetty käyttäjälle:

mercuriev

1) reading from PostgreSQL instead of JSON - looks clear. Looks like everything is considered. Estimate - less than 1 day. 2) import from CSV. Looks like everything is considered and clear. To be started on first day. Lisää

$10 USD 10 päivässä
(1 arvostelu)
0.0

22 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

trustus

Hello, We have a team of Skilled Java-J2EE professionals with experience up to 8 years. ===== Our Expertise in Java / J2EE : * Desktop Applications : Swing, Eclipse Rich Client Platform, AWT, SWT, RMI * Lisää

$100 USD 1 päivässä
(81 arvostelua)
7.7
paulprabhakarand

i, I am a tech savvy person, more than a decade I am developing and delivering applications on Java based technologies. I am a certified Java professional. My logical thinking and problem solving skills are quite goo Lisää

$80 USD 3 päivässä
(25 arvostelua)
5.2
$100 USD 4 päivässä
(44 arvostelua)
5.0
deytps86

Hello, I am working Java/J2EE technologies for last 16+ years that include Spring MVC, Springboot, Struts, Hibernate, JPA with Spring data/repository with MySQL, Oracle, MongoDB, PostGRE Cassandra! Can we talk in d Lisää

$90 USD 3 päivässä
(20 arvostelua)
4.6
atulamol

Hello Sir, I have More than Five years (5+ years) of experience in Professional Software Development. Seeking for a challenging position as a Java Developer with the strong working experience in programming, de Lisää

$100 USD 10 päivässä
(24 arvostelua)
4.5
Shatrughna2110

Hi There, I had a look at all 3 requirements. I have 14 years of industry experience in developing applications using Java. Please let me know more details. Best Regards, Shatrughna

$133 USD 5 päivässä
(12 arvostelua)
4.5
oatechnology

Hi , hope you are well i am java developer and i have 5 years experience in software development using Java i am expert with JSP , Servlets and JSON , and i can help you in this project hope to contact me to Lisää

$80 USD 10 päivässä
(35 arvostelua)
4.6
xiongjiezhao222

Hi, My name is Xiong Jie Zhao, live in China. I am a newbie in this freelancer, but I have many experiences with Java EE and Java web development using spring framework. I have some skills with the crawling and sea Lisää

$100 USD 2 päivässä
(12 arvostelua)
4.0
$111 USD 2 päivässä
(4 arvostelua)
3.7
$55 USD 2 päivässä
(4 arvostelua)
3.4
p4logics

Hello Sir! I think I'm a great fit for this project because I have an interest in your project and can deliver on time, according to your specifications we are expert in software development using java, j2EE, javafx an Lisää

$55 USD 1 päivässä
(6 arvostelua)
3.2
infoshemeer

I am a proficient developer with a web-development orientation. My preferred technologies are PHP, Java, JavaScript, any dialects of SQL, but my experience is not limited to these. I am experienced at developing websi Lisää

$100 USD 10 päivässä
(14 arvostelua)
3.3
simrankaurc

Hello, I am very interested in the project and you would like to apply to it. I'm a web developer with 7 years experience in Java, J2EE, Spring, Hibernate,PHP, MYSQL, CSS3, HTML5 and deep knowledge Wordpress, W Lisää

$61 USD 10 päivässä
(5 arvostelua)
2.8
khurram4225

Hey there, Hope you are doing well. We have gone through all the details of your project and after having necessary information to check our caliber, we have come to the result that we can make your project done succe Lisää

$100 USD 0 päivässä
(6 arvostelua)
2.9
$50 USD 15 päivässä
(9 arvostelua)
2.7
kamrankhankhail

I have 3+ Year experience in Java Web Technologies. Also working in Javascript Technologies I am a Full Stack Developer

$100 USD 3 päivässä
(4 arvostelua)
2.4
Nidhijain123

Hello, I can do this task very easily. I have sound working experience with json and have sound knowledge on scripting using Mysql for scraping. Hope to hear from you soon.

$77 USD 10 päivässä
(1 arvostelu)
2.5
HotfixSolutions

Hi there, I've over 7+years of experience, in Java language, with multiple frameworks-Spring MVC, Spring Restful web services, Google Guice, Jersey Web Services with consumer and produces the JSON or XML.I deliver Lisää

$61 USD 10 päivässä
(0 arvostelua)
0.0
Aramlog

I'm Lead Software Engineer at EPAM and I have great experience in Java and PostgreSQL. This is just a one day work for me.

$35 USD 1 päivässä
(0 arvostelua)
0.0
prasadtikkas1

i saw your post and i am intreested in doing your project. i am working in MNC company and have 3+yrs of exp in JAva Development.

$100 USD 20 päivässä
(0 arvostelua)
0.0