import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
public class ZohoReportsCloudSQL
{
public static void main(String args[])
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName("com.zoho.cloudsql.jdbc.ZohoReportsDriver");
Properties conProps = new Properties();
conProps.put("ZOHO_API_KEY","abcd");
// Zoho username to login to Zoho service
conProps.put("user","david");
// Zoho password to login to Zoho service
conProps.put("password","davidpwd");
// Uncomment this incase you need proxy settings
/*
// Proxy host name to connect the internet
conProps.put("PROXYSERVER","proxy_hostname");
// Proxy port to connect the internet
conProps.put("PROXYPORT","proxy_port");
// Proxy user name to connect the internet
conProps.put("PROXYUSERNAME","proxy_username");
// Proxy password to connect the internet
conProps.put("PROXYPASSWORD","proxy_password"); */
/* Important Note: Connection is single threaded in Zoho Reports */
// david is the owner of the database 'Sales'
con = DriverManager.getConnection("https://reports.zoho.com/" +
"api/david/Sales",conProps);
stmt = con.createStatement();
String sql ="select * from <tablename>";
rs = stmt.executeQuery(sql);
}
catch(SQLException se)
{
// handle any errors
System.out.println("SQLException: " + se.getMessage());
System.out.println("Zoho Reports Error code: " + se.getErrorCode());
}
catch(Exception e)
{
// handle the exception
}
finally
{
if(rs != null)
{
try
{
rs.close();
}
catch(SQLException sqlEx) { } // ignore
}
if(stmt != null)
{
try
{
stmt.close();
}
catch (SQLException sqlEx) { } // ignore
}
if(con != null)
{
try
{
con.close();
}
catch (SQLException sqlEx) { } // ignore
}
}
}
}
Uploading ....