Posts

Showing posts from June, 2017

JAVA CODE : RESTAPI TO ACCESS POSTGRESQL USING ECLIPSE

JAVA CODE : RSETAPI TO ACCESS POSTGRESQL USING ECLIPSE package 1: package com.user.inventory; import java.sql.*; import javax.ws.rs.GET; import javax.ws.rs.Path; //import javax.ws.rs.PathParam; import javax.ws.rs.Produces; //import javax.ws.rs.core.MediaType; //import javax.ws.rs.core.Response; //import javax.ws.rs.QueryParam; import org.codehaus.jettison.json.JSONArray; import com.user.util.ToJSON; @Path("/v/inventory") public class V_inventory { @GET @Produces("application/json") public String returnAllcontacts() throws Exception{ PreparedStatement query = null; Connection conn = null; String returnString = null; try{ Class.forName("org.postgresql.Driver");    conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/ db "," Username "," password ");    query = conn.prepareStatement("select * from tablename ...