Find Jobs
Hire Freelancers

Extract Json from PostgreSQL with Java Servlet

$10-100 USD

Teljesítve
Kiadva ekkor: több mint 5 évvel ezelőtt

$10-100 USD

Teljesítéskor fizetve
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.
Projektazonosító: 17566236

A projektről

21 ajánlat
Távolról teljesíthető projekt
Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
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. Expected completion - morning of 2nd day. Planning to make first deployment then (by default all approved). 3) the approval. Looks like everything is considered and clear. Except the UI part. Makes sense to display pages of images and radio box vis statuses 0|1|2 New | Approved | Declined also makes sense to add optional text field to explain decline reason - 2nd day - deployed 3rd day morning. 4) feedback - possible changes - 3rd day
$10 USD 10 napon belül
5,0 (3 értékelés)
1,2
1,2
21 szabadúszó adott átlagosan $78 USD összegű árajánlatot erre a munkára
Felhasználó avatár
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 * Frameworks: Spring, Spring Security, Spring Social, Struts, Hibernate ,JPA, Lucerne, Quartz, Ant, jUnit, DbUnit, Mybatis * Web Technology : JSP, JSTL, JSF, JQuery, Ajax, JavaScript, DWR, FCK Editor, Extjs * Application Servers : JBoss, WebLogic, WebSphere, Apache Tomcat, Glassfish * Databases : MySQL 4.x/5.x, Oracle 8i/9i/10g/11g, Postgre SQL * Web Services : SOAP, WSDL, RESTFUL Web Services, Apache Axis * IDE : Eclipse, Net Beans, Web Ratio (Model Based Application Development IDE) , Spring IDE * Payment Gateway : PayPal Integration [Experienced in integrating other payment gateways too] * Project Management : SDLC, AGILE ===== We are available from Monday To Friday, 9 hours a day. Our timezone is GMT+5.30. Please initiate chat, so once our developer goes through the attachment we come with our understandings and queries. You will be able to communicate directly with the expert working on your project. After having detail discussion we can come to estimation / quote. We look forward to have long term engagement on the basis of quality of our work evinced in this project. Thanks.
$100 USD 1 napon belül
4,9 (366 értékelés)
8,3
8,3
Felhasználó avatár
$100 USD 4 napon belül
5,0 (139 értékelés)
6,7
6,7
Felhasználó avatár
I have 3+ Year experience in Java Web Technologies. Also working in Javascript Technologies I am a Full Stack Developer
$100 USD 3 napon belül
5,0 (22 értékelés)
6,2
6,2
Felhasználó avatár
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 good. Currently I am developing several applications using Core Java, Servlet,s JSP., Spring framework, restful services, Hibernate, JPA, MySQL, Oracle, MongoDB and Angular.js as Front End. Please come for chat, let us discuss and will start the work right away. NOTE : Most of the technical tests are passed with 90% and above in freelancer.com skill tests. Thanks Paul
$80 USD 3 napon belül
4,9 (73 értékelés)
6,3
6,3
Felhasználó avatár
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 and awt . And Also we are perfect in web development using struts and spring boot framework (Maven/mysql/mongo). also having good experience in Javascript, JSON, PostgreSQL. Please ping me we can start right now. Thanks
$55 USD 1 napon belül
4,7 (56 értékelés)
6,7
6,7
Felhasználó avatár
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 napon belül
5,0 (21 értékelés)
6,1
6,1
Felhasználó avatár
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 details on the requirements? Thank you!
$90 USD 3 napon belül
4,9 (36 értékelés)
5,3
5,3
Felhasználó avatár
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, designing of Spring, Hibernate, CORE JAVA / J2EE application. Develop applications using Spring MVC using Annotations, Spring Boot.
$100 USD 10 napon belül
5,0 (41 értékelés)
5,2
5,2
Felhasználó avatár
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 discuss more about your project Regards Osama
$80 USD 10 napon belül
4,8 (37 értékelés)
5,0
5,0
Felhasználó avatár
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 search system using solr, hbase and nutch based hadoop for image search engine. I have some skills with nosql and postgresql. It is a piece of cake. Regards.
$100 USD 2 napon belül
4,9 (16 értékelés)
4,5
4,5
Felhasználó avatár
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 napon belül
4,9 (2 értékelés)
3,1
3,1
Felhasználó avatár
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 successfully. You will tell us about your project's Deadline and if we will need any information about your project then we will send you texts right away, but before it, please make sure to send a message to us to discuss more about your project..!!! If you want to check our experience related to relevant project then you may visit the link of project which we already did..!!! https://www.freelancer.com/projects/graphic-design/Build-website-15147890/
$100 USD 0 napon belül
5,0 (6 értékelés)
2,9
2,9
Felhasználó avatár
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 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 high quality, clean, working code, quickly and correctly. I'm comfortable with structured code, databases, OO programming, and "specialty" languages such as might be found in workflow or business rules systems. Programming(Major Skills):Core JAVA,Spring Boot,Spring3.x&4.x,JSP,SERVLET,Google guice with Jersey,Hibernate,JPA. Security framework :Spring security ,Apache shiro. Data Science:Cloudera Manager,Hdfs,hbase,Spark,Apache Solr. Programming(Minor Skills):jQuery, JavaScript,AnuglerJs,Bootstrap,BackboneJS,HTML Presentation view :JSP,HTML,JSTL. Databases:Mysql 5.0,Mongodb,Postgres. Tools & Techniques:Eclipse 3.x,Spring Tool Suite 3.x,Netbean. Utility Tools:SVN Client,Github,MySQLWorkbench,QueryBrowser,Jira,pgAdmin. Servers :Tomcat 6.x,7.x,8.x and jetty. Operating Systems: Windows & Linux. Ty Dhiraj
$61 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I am willing to work on this, add me on skype for further discussion, my skype id is anamika.pramanick. Thanks in advance Anamika Pramanick
$45 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

SWITZERLAND zászlója
Chiasso, Switzerland
4,9
19
Fizetési mód hitelesítve
Tagság kezdete: máj. 7, 2013

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.