Forums:

Need help in Dojo connecting Oracle database tables

Greenhorn

Posts: 10

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm using oracle db&jsp

Here is my table:
Stock table : columns are Daily, Weekly,Monthly.

How to connect my oracle table with Dojo &wnt to display column charts.

Here is my JSP file called Report.jsp

If i hard code the data from table,i'm getting column charts.

Unable generate column chats dynamically.
Please help me the step how to connect my oracle table with dojo.

Much appreciated any sample code how to connect oracle table with dojo.

Here is my Report.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
     <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <title>Reorts</title>
       
        
		
		
		<link rel="stylesheet" href="dojoroot/dijit/themes/claro/claro.css" media="screen"/>
		<link rel="stylesheet" href="dojoroot/dojo/resources/dojo.css" />
		
				
		<script>dojoConfig = {parseOnLoad: true}</script>
		<script src="dojoroot/dojo/dojo.js"></script>
		
		<script>

require(["dojox/charting/Chart",  
                 "dojox/charting/themes/MiamiNice",
                "dojox/charting/plot2d/Columns",
                "dojox/charting/plot2d/Markers",
                "dojox/charting/axis2d/Default",
                "dojo/domReady!"],
            function(Chart,theme,Columns,Markers,Default,domReady)
          {
     
            // Define the data

var chartData = [5100,1200,2500,];

//Create the chart within it's "holding" node
            
        	
            var chart = new Chart("chartNode",{
                title: "Reports",
        		titlePos: "top",
        		titleGap: 30,
        		titleFont: "normal normal normal 25pt Arial",
        		titleFontColor: "black"
        	}); 
            
            
            // Set the theme
        
          
            chart.setTheme(theme); 
     
           // Add the only/default plot
            chart.addPlot("default", {
            type: "Columns",
            markers: false,
            labels: true,
            stroke: {color: "red", width: 15}, 
            labelStyle: "outside", 
            gap:15 
          });
     
           // Add axes
           chart.addAxis("x",{fixLower:"minor",natural:true,font:"normal normal 2pt Arial",
                                labels:[{value:1,text:"Daily"},
                                       {value:2,text:"Weekly"},
                                       {value:3,text:"Monthly"}], rotation: -90});    
            
           chart.addAxis("y", { vertical: true, fixLower: "major", fixUpper: "major",includeZero:true });
     
          // Add the series of data
           chart.addSeries("Overall NIP Progress",chartData);
     
          // Render the chart!
           chart.render();
     
    });
     
       </script>
        
   </head>

</body>

</html>

Mohamed Sanaulla

Bartender

Posts: 3225

I like...

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

the required chartData needs to be populated from a call to the server.

So the flow would be like this:
1. A servlet which would read your request for data, connect to the DB, and return the data.
2. Call this servlet end point from your Dojo and populate the chartData with the response received from the servlet.

To return a response from Servlet have a look at JSON. You would basically need to return a JSON array of integers from your servlet.

Hope you are aware of writing a servlet?

So you got to learn the following to achieve your requirement:
1. Writing a Servlet which reads the request parameters for any data your are passing and interact with the DB.
2. Read about JSON and how you can return JSON response from Servlet. For creating JSON content you can have a look at GSON or Jackson Object Mapper.
3. Call this API from your Dojo code.

Mohamed Sanaulla | My Blog | Author of Java 9 Cookbook | Java 11 Cookbook

pushpa naga

Greenhorn

Posts: 10

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks a lot for your reply Mohamed Sanaulla.

I'm very much new to Java.This very urgent issue
Much appreciated if you can send me any sample code.

Mohamed Sanaulla

Bartender

Posts: 3225

I like...

posted 10 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

pushpa naga wrote:Thanks a lot for your reply Mohamed Sanaulla.

I'm very much new to Java.This very urgent issue
Much appreciated if you can send me any sample code.

I am afraid I cannot send you the code. Its useful for you to learn and implement it yourself so that you can reuse your knowledge elsewhere. I know its easy to copy and paste when you are tight on deadlines, but its not the right way.

Mohamed Sanaulla | My Blog | Author of Java 9 Cookbook | Java 11 Cookbook

pushpa naga

Greenhorn

Posts: 10

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Mohamed Sanaulla,

Can't make it any progress in this issues.

So sorry to giving you an trouble again,please help in in this.

Your help is so much appreciated.

Mohamed Sanaulla

Bartender

Posts: 3225

I like...

posted 10 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

pushpa naga wrote:Hi Mohamed Sanaulla,

Can't make it any progress in this issues.

So sorry to giving you an trouble again,please help in in this.

Your help is so much appreciated.

You can post your code here and let us know where you are stuck. Coderanch is NotACodeMill

Mohamed Sanaulla | My Blog | Author of Java 9 Cookbook | Java 11 Cookbook

pushpa naga

Greenhorn

Posts: 10

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Mohamed Sanaulla,

I can read my database tables data from my servlet & populating in my browser.(Is it right way to read table data)

After that how to parse that table data as an JSON object.

Not able to proceed forward, Please assist me this .

Here is my databaseAccess.java

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class databaseAccess extends HttpServlet{

/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

public void doGet(HttpServletRequest request,
                HttpServletResponse response)
        throws ServletException, IOException
{
  Connection conn=null;
  Statement stmt=null;

// Set response content type
  response.setContentType("text/html");
  PrintWriter out = response.getWriter();
  String title = "Database Result";
  String docType =
    "<!doctype html public \"-//w3c//dtd html 4.0 " +
     "transitional//en\">\n";
     out.println(docType +
     "<html>\n" +
     "<head><title>" + title + "</title></head>\n" +
     "<body bgcolor=\"#f0f0f0\">\n" +
     "<h1 align=\"center\">" + title + "</h1>\n");
  try{
     // Register JDBC driver
     Class.forName("oracle.jdbc.OracleDriver");
    
     // Open a connection
     conn  = DriverManager.getConnection("oracle:thin:@10.102.239.141:1521/VCSTAGE","vcstaging","vcstaging");

// Execute SQL query
     stmt = conn.createStatement();
     String sql;
      sql = "SELECT * FROM STOCK";
   
     ResultSet rs = stmt.executeQuery(sql);

// Extract data from result set
     while(rs.next()){
        //Retrieve by column name
        int daily  = rs.getInt("daily");
        int weekly = rs.getInt("weekly");
        int monthly = rs.getInt("monthly");

//Display values
        out.println("Daily: " + daily + "<br>");
        out.println(", Weekly: " + weekly + "<br>");
        out.println(", Monthly: " + monthly + "<br>");
        
     }

out.println("</body></html>");

// Clean-up environment
     rs.close();
     stmt.close();
     conn.close();
    }catch(SQLException se){
     //Handle errors for JDBC
      se.printStackTrace();
    }catch(Exception e){
       //Handle errors for Class.forName
     e.printStackTrace();
    }finally{
       //finally block used to close resources
    	
     try{
        if(stmt!=null)
           stmt.close();
     }catch(SQLException se2){
     }// nothing we can do
     try{
        if(conn!=null)
        conn.close();
     }catch(SQLException se){
        se.printStackTrace();
     }//end finally try
    } //end try
   }
   }

pushpa naga

Greenhorn

Posts: 10

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Mohamed Sanaulla,

Can we follow below steps to dynamically generate column charts using DOJO.

1. Exporting database table data to CSV file(Basically i have to get data dynamically from my database tables) from my servlet class & saved that csv file in an specified location(in my project location).

2. From that Csv file using CSVstore or CSVobjectStore i.e dojo modules can we populate column bar charts.

can we do like this.I don't know is it right way or not.

Thanks very much in advance.
Pushpa

Why does your bag say "bombs"? The reason I ask is that my bag says "tiny ads" and it has stuff like this:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders