This post shows you how to build a very simple ajax dictionary. The dictionary does not have a database, it just add a string to keywords and send back to browsers. This application is a normal web application. In the third part, we will make a Ajax dictionary portlet in Liferay.
Step 1: Create a Web Project named AjaxDict
Step 2: Copy DWR.jar to 
Step 3: Declare DWR Servlet in
<?xml version="1.0"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<servlet>
<servlet-name>dwr-invoker</servlet-name>
<display-name>DWR Servlet</display-name>
<servlet-class>uk.ltd.getahead.dwr.DWRServlet</servlet-class>
<init-param>
<param-name>debug</param-name>
<param-value>true</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dwr-invoker</servlet-name>
<url-pattern>/dwr/*</url-pattern>
</servlet-mapping>
</web-app>
Step 4.1: Create Dictionary Engine Class
package com.aq.jdict;
/**
* This is just a simple engine.
* In real application, this engine will search the keyword
* in database, then return the meaning and other information.
* @author naqalone
*
*/
public class JDEngine {
public static String search(String keyword)
{
String meaning="meaning of "+keyword;
return meaning;
}
}
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>A Sample Dictionary</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="Ajax Dictionary">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script type='text/javascript'
src='/AjaxDict/dwr/interface/JDEngine.js'></script>
<script type='text/javascript' src='/AjaxDict/dwr/engine.js'></script>
<script type='text/javascript' src='/AjaxDict/dwr/util.js'></script>
<script>
function search()
{
var keyword;
keyword = DWRUtil.getValue("txtKeyword");
JDEngine.search(updateMeaning,keyword);
}
function updateMeaning(rxData)
{
DWRUtil.setValue("result",rxData);
}
</script>
</head>
<body>
<font color="#004080"> <strong>A very simple Ajax
Dictionary - Powered by DWR</strong> </font>
<br>
<br>
Keyword :
<input type="text" name="txtKeyword">
<input type="button" value="Search" name="btSearch"
onClick="javascript:search();">
<br>
Meaning:
<div id="result" border="1">
</div>
</body>
</html>
Step 5: Declare Engine class in
<!DOCTYPE dwr PUBLIC
"-//GetAhead Limited//DTD Direct Web Remoting 1.0//EN"
"http://www.getahead.ltd.uk/dwr/dwr10.dtd">
<dwr>
<allow>
<create creator="none" javascript="JDEngine">
<param name="class" value="com.aq.jdict.JDEngine"/>
</create>
<convert converter="bean" match="com.aq.jdict.JDEntry"/>
</allow>
</dwr>
Step 6: Configure the JBoss (or Tomcat)server
If you already configured a server, you can skip this step.
Step 7: Deploy
Step 8: Start jBoss
Step 9: Test in IE or Firefox
GOTO: http://locaclhost:8080/AjaxDict
That's all!
Part 1,
2
December 21, 2006
How to use DWR in Liferay Portal (Part 2 - A simple Dictionary)
December 18, 2006
Ajax - Hello World
Ajax - one of the most important web technology in 2005. Ajax has changed not only the web development industry but also the software development industry. This new technology mades the gap between desktop application and web application smaller. Go here for more information about Ajax
In this tutorial, you will learn the basic principle of Ajax. You will see that it is not too much difficult.
Requirements for this tutorial:
1. Tomcat server (Download)
Step 1: Create a HTML file (C:\tomcat\webapps\ajax1.html)
<HTML>
<HEAD>
<script>
function loadurl(dest) {
try {
xmlhttp = window.XMLHttpRequest?new XMLHttpRequest(): new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {
}
xmlhttp.onreadystatechange = myHandler;
xmlhttp.open("GET", dest);
xmlhttp.send(null);
}
function myHandler(){
if ((xmlhttp.readyState == 4) && (xmlhttp.status == 200))
{
document.getElementById("output").innerHTML = xmlhttp.responseText;
}
}
</script>
</HEAD>
<body>
<input type="button" value="Load from server"/ onclick="javascript:loadurl('/sample.txt')">
<div id="output"></div>
</body>
</HTML>
Step 2: Create a sample resource
In real applications, a servlet or something else :) gets data from database and sends them back to the client.
To make it simple, I create a simple resource, just a simple text file located in the server:
Content of C:\tomcat\webapps\ROOT\sample.txt
Step 3: Test your result
- Start your server (C:\tomcat\bin\startup.bat)
- Open IE, type in address bar: http://localhost:8080/ajax1.html
- Click the button "Load from server"
That's all !
Review
Now look again what is under the hook. When you click the button, the javascript function loadurl will be called.
What happens in loadurl ?
1. create XMLHttpRequest object
2. Assign the listener for the event onreadystatechange
3. XMLHttpRequest object send request to server by executing the method: open("GET",dest)
4. Server receive the request, get content in the sample.txt, send back to the client. The browser will listen and invoke the listener myHandler() everytime the readyState of XMLHttpRequest object is changed.
5. myHandler need to check if the received data is ready or not. When the receiving is completed, the value of DOM object with id="output" will be changed to the response text
6. Maybe you wonder why we use xmlhttp.send(null) in this case. The reason is when we call the send method, the browser will wait for the response from the server. This is the Synchronous model. But Ajax is asynchronous, we will send null to the server, so the client will not wait. We send request by open("GET",dest);
December 13, 2006
JasperReports Presentations & Tutorials (Big Collections:Updated frequently)
Here you will find the big collections of JasperReports Presentations & Tutorials.
1. Very nice, basic, animated presentation
2. Reporting Made Easy with JasperReports and Hibernate
3. JasperReports for jBoss (pdf) - Teodor Danciu
4. Creating a Report with JasperReports (for beginners) - Deepak Vohra
5. iReport Tutorials
December 12, 2006
SQLException: Result set type is TYPE_FORWARD_ONLY
Sometimes you encounter this stupid exception:
java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
How to avoid it ?
Answer:
You need to create the statement of type TYPE_SCROLL_SENSITIVE.
Connection conn = ConnectionPool.getConnection();
Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
stmt.setFetchSize...
ResultSet rs = stmt.execute...
December 08, 2006
Customize Dojo ComboBox
This post shows some tips that I found to customize the dojo ComboBox Widget.
1. Change text align in drowdown menu:
Change dojoComboBoxOptions in dojo/src/widget/ComboBox.css/* the drop down */
.dojoComboBoxOptions {
font-family: Verdana, Helvetica, Garamond, sans-serif;
/* font-size: 0.7em; */
background-color: white;
border: 1px solid #afafaf;
position: absolute;
z-index: 1000;
overflow: auto;
cursor: default;
text-align: left;
}
December 07, 2006
How to use DWR in Liferay Portal (Part 1 - Installation)
This tutorial shows you how to use DWR in Liferay.
I assume that you already know how to use DWR. If not, please go here: Getting started with DWR
1. Download file dwr.jar (Current stable version is 1.1.3 Updated 7/12/2006)
2. Copy dwr.jar to C:\training\Liferay\ext\ext-lib\portalJARs in the portal directory are automatically copied to the portal classpath and are only visible by the portal.
3. Create a test bean:
package com.test;
public class SampleBean {
private String myName;
private String[] myMovies;
public String[] getMyMovies() {
myMovies = new String[3];
myMovies[0] = "Happy Feet";
myMovies[1] = "Casino Royale";
myMovies[2] = "Lord of the Ring";
return myMovies;
}
public String getMyName() {
myName = "Anh Quan";
return myName;
}
}
4. Store the dwr.xml in C:\training\Liferay\ext\ext-web\docroot\WEB-INF
Here is a sample dwr.xml
<dwr>
<allow>
<create creator="new" javascript="SampleBean">
<param name="class" value="com.test.SampleBean"/>
</create>
</allow>
</dwr>
5. Deploy to tomcat: Start\Run\Cmd , then C:\trainging\liferay\ext\ant deploy
6. Start your tomcat server C:\trainging\liferay\tomcat\bin\startup.bat
Check point:
1. Be sure that dwr.jar is copied to C:\training\liferay\tomcat\webapps\ROOT\WEB-INF\lib
and dwr.xml is copied to C:\training\liferay\tomcat\webapps\ROOT\WEB-INF
7. In IE, go to http://localhost:8080/dwr
You will see something like :Classes known to DWR:
Go to http://localhost:8080/dwr/test/SampleBean, click "Execute" next to getMyMovies( );
You will see:
8. Congratulation! You are now ready to explore the power of DWR.
Part 1,2
December 03, 2006
How to get Servlet context in Struts Action class ?
English
In a servlet, to get the Servlet context, you use
ServletContext context = getServletConfig().getServletContext();
In a Struts Action class, you need to get the Servlet first. Then you can get Servlet context
ServletContext context = getServlet().getServletConfig().getServletContext();
Vietnamese
Trong một servlet thông thường, để lấy Servlet context bạn sử dụng đoạn code sau:
ServletContext context = getServletConfig().getServletContext();
Nhưng trong một Struts Action class, bạn cần phải lấy Servlet trước. Khi đã có Servlet rồi, bạn sử dụng bình thường như ở trên
ServletContext context = getServlet().getServletConfig().getServletContext();
December 02, 2006
About me
My name is Anh Quan Nguyen, from Saigon, Vietnam.
I am currently living in Frankfurt, Germany.
I like to blog about Web 2.0, JasperReports, Portal/Portlet, JSR168, DWR, Dojo, Struts... and so on.
A little bit about my background. In March 2003, I graduated Bachelor in Electronics, Hochiminh City University of Technology. Then I got a position as Electronic Engineer in Sony. Tivi production made me tired. I decided to change my career. In September 2004, I came to Germany to take the Master Course in Communication and Media Engineering. Here I also do not know exactly my real way, become a telecom. engineer or a software developer. After a while of listening to my heart, I know I have no other choice than to become a programmer. It's quite a little bit late, but it's better than going to the wrong way for the rest of my life.
Thank you for visiting my website. And if you are professional programmer, please help me with your knowledge.
Nice to know you all !
OutOfMemory - How to avoid it ?
Sometimes, you encounter the OutOfMemoryException because JasperReports tries to fill data which are bigger than memory allocated to JVM.
Don't be panic. JasperReports can split a big report to smaller segments and store these segment in a temporary directory in your drive.
What you have to do is to set the built-in parameter REPORT_VIRTUALIZER
Take a look at the code below://Create connection to database server
connection = ConnectionPool.getConnection();
//Create a cache at C:\Temp
JRFileVirtualizer fileVirtualizer = new JRFileVirtualizer(3, "c:\\Temp");
//Set parameter REPORT_VIRTUALIZER
HashMap parameterMap = new HashMap();
parameterMap.put(JRParameter.REPORT_VIRTUALIZER, fileVirtualizer);
//Fill data as usual
JasperFillManager.fillReportToFile("MyReport.jasper", parameterMap,connection);
Good luck !
Struts and XDoclet
Type your summary here.
Type the rest of your post here.
Portlet development with XDoclet, ANT
Type your summary here.
Type the rest of your post here.
Struts based porlet in Liferay Portal
Type your summary here.
Type the rest of your post here.
Struts resources (eBooks, articles, tutorials)
Type your summary here.
Type the rest of your post here.
Struts development in MyEclipse
Hướng dẫn cách sử dụng MyEclipse để phát triển Struts application
Type the rest of your post here.
HelloWorld Struts Application
Chương trình cơ bản sử dụng Struts
Type the rest of your post here.
JasperReports Resources (eBooks, articles, tutorials)
eBooks:
1.
2.
3.
4.
5.
6.
7.
Articles:
Tutorials:
Type the rest of your post here.
Jasper Report Printing from Servlet
In this post I will show you how to write a simple Servlet to view PDF reports on web browser.
The source code is quite simple and self exlained.
Take a look !
package com.db.misportal.servlet;
import java.io.IOException;
import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.log4j.Logger;
import com.db.report.jasper.custom.common.AbstractReport;
import com.db.report.jasper.custom.consumptionreport.ConsumptionReport;
import com.db.report.jasper.custom.trackingreport.TrackingReport;
/**
* @web.servlet name = "JasperReportsBrowserServlet" description = "Display PDF
* reports on the browser.The default file name is
* <productcode>.pdf"
*
* @web.servlet-mapping url-pattern = "/JasperReportsBrowserServlet/*"
*
* @author anhquan.nguyen@gmail.com
*
*/
public class JasperReportsBrowserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
static Logger _log = Logger.getLogger(JasperReportsBrowserServlet.class);
String strProductCode;
String strReportDate;
String strReportHome;
String strProductCategory;
String strReportType;
String strReportMonth;
String strReportYear;
String strReportMode;
public void init(ServletConfig config) throws ServletException {
super.init(config);
_log.info("init JasperReportsBrowserServlet...");
// String initial = config.getInitParameter("initial");
ServletContext context = this.getServletConfig().getServletContext();
strReportHome = context.getRealPath("/reports");
_log.debug("Report Home : " + strReportHome);
_log.info("init completed!");
}
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
process(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
process(request, response);
}
protected void process(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ServletOutputStream servletOutputStream = response.getOutputStream();
/* Get parameters from form */
strProductCode = request.getParameter("productCode");
strProductCategory = request.getParameter("productCategory");
strReportType = request.getParameter("reportType");
strReportMonth = request.getParameter("reportMonth");
strReportYear = request.getParameter("reportYear");
strReportMode = request.getParameter("reportMode");
strReportDate = strReportMonth + "/" + strReportYear;
AbstractReport report = null;
String strReportHome = "N:\\thesis\\workspace\\misportal\\WebRoot\\reports";
if ("consumption_report".equals(strReportType)) {
String strPDFFileName = strProductCode + ".pdf";
String strContentHeader = strProductCode;
report = new ConsumptionReport();
report.setParams(strProductCode, strReportDate);
if ("single".equals(strReportMode)) {
report.setPath("consumptionreportsingle", strReportHome
+ "\\consumption\\in", strReportHome
+ "\\consumption\\out");
} else // all
{
strPDFFileName = "Consumption" + ".pdf";
strContentHeader = "Consumption";
report.setPath("consumptionreportall", strReportHome
+ "\\consumption\\in", strReportHome
+ "\\consumption\\out");
}
exportToPDFStream(response, servletOutputStream, report,
strPDFFileName, strContentHeader);
} else if ("tracking_report".equals(strReportType)) {
if ("single".equals(strReportMode)) {
report = new TrackingReport();
report.setParams(strProductCode, strReportDate);
report.setPath("tracking", strReportHome
+ "\\trackingreport\\in", strReportHome
+ "\\trackingreport\\out");
report.setSubReports("tracking_part", 1, 10);
String strPDFFileName = strProductCode + ".pdf";
String strContentHeader = strProductCode;
exportToPDFStream(response, servletOutputStream, report,
strPDFFileName, strContentHeader);
} else {
report = new TrackingReport();
report.setParams(strProductCode, strReportDate);
report.setPath("tracking", strReportHome
+ "\\trackingreport\\in", strReportHome
+ "\\trackingreport\\out");
report.setSubReports("tracking_part", 1, 10);
String strPDFFileName = strProductCode + ".pdf";
String strContentHeader = strProductCode;
exportToPDFStream(response, servletOutputStream, report,
strPDFFileName, strContentHeader);
}
}
servletOutputStream.close();
}
/**
* Export to PDF Stream
*
* @param response
* @param servletOutputStream
* @param report
* @param strPDFFileName
* Default file name
* @param strContentHeader
* Content header description
* @throws IOException
*/
private void exportToPDFStream(HttpServletResponse response,
ServletOutputStream servletOutputStream, AbstractReport report,
String strPDFFileName, String strContentHeader) throws IOException {
byte[] bytes = report.getPDFBytes();
_log.debug("Bytes length : " + bytes.length);
response.setContentType("application/pdf");
response.setHeader("Content-Description", strContentHeader);
response.setHeader("Content-transfer-encoding", "binary");
response.setHeader("Content-Disposition", "attachment; filename="
+ strPDFFileName);
response.setContentLength(bytes.length);
servletOutputStream.write(bytes, 0, bytes.length);
servletOutputStream.flush();
_log.debug("close outputstream");
}
}
That's all !
Create more readable report with conditional Formatting
Khi tạo report, bạn sẽ thấy nếu sử dụng conditional formatting thì sẽ tạo được những report rất đẹp. Ví dụ, đối với field kiểu boolean, thay vì hiện giá trị true/false, bạn có thể xuất dấu check (dạng file image). Làm việc đó như thế nào? Thực sự cũng không quá phức tạp.
Type the rest of your post here.
How to use SubReports
Để tạo một report phức tạp, bạn không thể sử dụng một file jrxml đơn lẻ được. Trong trường hợp này, để đơn giản, bạn có thể chia main report thành các subreport để dễ quản lý.
Type the rest of your post here.
Dynamic datasource & embedded SQL
Trong JasperReport, bạn có thể nhúng lệnh SQL trong file jrxml hoặc có thể truyền data bằng datasource. Cách nào hay hơn ? Lần này tôi sẽ so sánh ưu và nhược điểm của hai phương pháp này.
Type the rest of your post here.
Create better quality Chart in PDF format
Bạn sẽ để ý rằng khi tạo Chart trong JasperReports và export ra PDF, Chart nhận được rất xấu, đặc biệt là các ký tự và số (đôi khi mờ không thấy chữ). Tại sao? Đó là do PdfExporter của JasperReports convert Chart ra dạng pixel, sau đó mới in ra PDF. Mà đương nhiên là các chữ số dạng pixel thì không thể rõ bằng các chữ số dạng text được rồi. Bạn không thể dùng Select Tool trong Acrobat Reader để chọn các chữ số trong Chart, mà chỉ có thể select chart như một hình ảnh. Bài viết này sẽ hướng dẫn bạn các vượt qua khó khăn này.
Type the rest of your post here.
Force PageBreak in JasperReports
Trong MS Access, bạn có thể dễ dàng "ép" report nhảy qua trang mới. Nhưng việc này không dễ dàng tí nào trong JasperReports. Bài viết này hướng dẫn bạn vượt qua hạn chế này của Jasper
Type the rest of your post here.
How to use Crosstab
Crosstab hay còn gọi là PivotTable trong Excel và Access. Làm thế nào để tạo Crosstab trong JasperReports. Bài viết này sẽ hướng dẫn chi tiết cách tạo Crosstab.
Type the rest of your post here.
How to use ChartCustomizer
JasperReports use jFreeChart as a charting library. However many features in jFreeChart are not yet supported in JasperReports. With the help of customizer, you can fully control jFreeChart.
I took me quite a while to learn how to customize the jFreeChart in JasperReports.For example, we cannot change the size of bars in BarChart, or we cannot add a complicated dynamic subtitle.
Like scriptlets, Customizer is automatically invoked during the filling process.
Your own customizer class must implement net.sf.jasperreports.engine.JRChartCustomizer interface. This interface has only one method customize(org.jfree.chart.JFreeChart chart, JRChart jasperChart).
Here is one example:
ConsumptionChartCustomizer.java
package com.db.report.jasper.custom.consumptionreport.style;
import java.awt.BasicStroke;
import java.awt.Color;
import java.awt.Font;
import java.sql.Connection;
import java.sql.SQLException;
import net.sf.jasperreports.engine.JRAbstractChartCustomizer;
import net.sf.jasperreports.engine.JRChart;
import org.apache.log4j.Logger;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.axis.CategoryAxis;
import org.jfree.chart.axis.NumberAxis;
import org.jfree.chart.block.BlockBorder;
import org.jfree.chart.plot.CategoryPlot;
import org.jfree.chart.renderer.category.StackedBarRenderer;
import org.jfree.chart.title.LegendTitle;
import org.jfree.chart.title.TextTitle;
import org.jfree.chart.title.Title;
import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.ui.HorizontalAlignment;
import org.jfree.ui.RectangleEdge;
import org.jfree.ui.RectangleInsets;
import com.db.misportal.util.ConnectionPool;
import com.db.report.jasper.custom.consumptionreport.dataset.ODBCDataset;
public class ConsumptionChartCustomizer extends JRAbstractChartCustomizer {
/** Default Constanst */
protected static final java.awt.Font HEADER_FONT = new java.awt.Font(
"Arial", Font.BOLD + Font.ITALIC, 14);
protected static final Color HEADER_COLOR = new Color(0x00, 0x00, 0xDE);
protected static final float BAR_WIDTH = 0.03f;
protected static final java.awt.Font TITLE_FONT = new java.awt.Font(
"Arial", Font.BOLD, 8);
protected static final Color TITLE_COLOR = new Color(0x00, 0x00, 128);
protected static final java.awt.Font TICKET_FONT = new java.awt.Font(
"Arial", Font.PLAIN, 8);
protected static final java.awt.Font LEGEND_FONT = new java.awt.Font(
"Arial", Font.PLAIN, 8);
protected static final java.awt.Color GRID_COLOR = new java.awt.Color(0, 0,
0);
private final static String[] DEFAULT_MONTH_ABBREVIATION = { "J", "F", "M",
"A", " M", " J", " J ", " A", " S", "O", "N", "D" };
protected static final String DEFAULT_TITLE = "Default Title";
protected static final String DEFAULT_SUB_TITLE = null;
protected static final String DEFAULT_DOMAIN_AXIS_LABEL = null;
protected static final String DEFAULT_RANGE_AXIS_LABEL = null;
protected static final RectangleEdge DEFAULT_LEGEND_POSITION = RectangleEdge.TOP;
protected JFreeChart chart;
private Title subTitle = null;
private boolean hasSubTitle = false;
private boolean hasLegend = false;
protected static final RectangleEdge DEFAULT_SUBTITLE_POSITION = RectangleEdge.BOTTOM;
protected static final HorizontalAlignment DEFAULT_SUBTITLE_HORIZONTAL_ALIGNMENT = HorizontalAlignment.LEFT;
public void customize(JFreeChart chart, JRChart jrChart) {
_log.info("customize jFreeChart ...");
this.chart = chart;
/* Set Chart Title */
try {
TextTitle title = chart.getTitle();
title.setHorizontalAlignment(HorizontalAlignment.LEFT);
} catch (NullPointerException e) {
}
/* Chart Properties */
chart.setBackgroundPaint(Color.white);
chart.setBorderPaint(new Color(192, 192, 192));
chart.setBorderVisible(true);
chart.setBorderStroke(new BasicStroke(0.001f));
chart.setPadding(new RectangleInsets(1, 1, 1, 1)); // top,left,bottom,right
/* Legend Properties */
hasLegend = true;
try {
LegendTitle legend = chart.getLegend();
legend.setItemFont(LEGEND_FONT);
legend.setBorder(BlockBorder.NONE);
legend.setPosition(DEFAULT_LEGEND_POSITION);
} catch (NullPointerException e) {
hasLegend = false;
}
/* Chart subtitle */
try {
int subTitleIndex = 0;
if (hasLegend) {
subTitleIndex = 1;
} else {
subTitleIndex = 0;
}
hasSubTitle = true;
subTitle = chart.getSubtitle(subTitleIndex);
setSubTitlePosition(DEFAULT_SUBTITLE_POSITION);
setSubTitleHorizontalAlignment(DEFAULT_SUBTITLE_HORIZONTAL_ALIGNMENT);
} catch (IllegalArgumentException e) {
hasSubTitle = false;
subTitle = null;
_log.debug("This chart has no subtitle.");
}
/* Axis: Ticket Label + Line */
try {
CategoryPlot plot = chart.getCategoryPlot();
NumberAxis numberAxis = (NumberAxis) plot.getRangeAxis();
numberAxis.setTickLabelFont(TICKET_FONT);
numberAxis.setTickLabelPaint(Color.black);
numberAxis.setAxisLinePaint(Color.black);
numberAxis.setAxisLineStroke(new BasicStroke(0.001f));
numberAxis.setTickMarkPaint(GRID_COLOR);
numberAxis.setTickMarkStroke(new BasicStroke(0.001f));
numberAxis.setTickMarkOutsideLength(3f);
CategoryAxis categoryAxis = (CategoryAxis) plot.getDomainAxis();
categoryAxis.setTickLabelFont(TICKET_FONT);
categoryAxis.setTickLabelPaint(Color.black);
categoryAxis.setAxisLinePaint(Color.black);
categoryAxis.setAxisLineStroke(new BasicStroke(0.001f));
categoryAxis.setAxisLineVisible(false);
categoryAxis.setTickMarkPaint(GRID_COLOR);
categoryAxis.setTickMarkStroke(new BasicStroke(0.001f));
categoryAxis.setTickMarkOutsideLength(3f);
categoryAxis.setTickMarkInsideLength(1f);
// plot.setBackgroundPaint(Color.gray);
/* Grid */
// plot.setRangeGridlinesVisible(false);
plot.setRangeGridlinePaint(GRID_COLOR);
plot.setRangeGridlineStroke(new BasicStroke(0.001f));
plot.clearRangeMarkers();
/* Outline */
plot.setOutlinePaint(null);
/* Unit */
numberAxis
.setStandardTickUnits(NumberAxis.createIntegerTickUnits());
StackedBarRenderer renderer = (StackedBarRenderer) plot
.getRenderer();
renderer.setMaximumBarWidth(BAR_WIDTH);
renderer.setDrawBarOutline(true);
renderer.setOutlinePaint(Color.black);
renderer.setOutlineStroke(new BasicStroke(0.00001f));
/* Series Color - dont need it any more - we set color in iReport */
// renderer.setSeriesPaint(0, new Color(153, 153, 255));
// renderer.setSeriesPaint(1, new Color(153, 51, 102));
// renderer.setSeriesPaint(2, new Color(255, 255, 204));
// renderer.setSeriesPaint(3, new Color(204, 255, 255));
} catch (NullPointerException e) {
}
}
/**
* Set query with default month abbreviation
*
* @param query
*/
protected void setQuery(String query) {
this.setQuery(query, DEFAULT_MONTH_ABBREVIATION);
}
/**
* Set Chart Query : execute query and set plot dataset
*
* @param query
* @param month_abbreviation
*/
protected void setQuery(String query, String[] month_abbreviation) {
Connection conn = null;
DefaultCategoryDataset dataset = null;
try {
conn = ConnectionPool.getConnection();
dataset = new ODBCDataset(conn, query);
} catch (SQLException e) {
e.printStackTrace();
} catch (com.db.report.jasper.custom.common.dataset.NullDatasetException e) {
_log.debug("Empty dataset...Hide chart");
this.hide();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
CategoryPlot plot = chart.getCategoryPlot();
plot.setDataset(dataset);
}
/**
* Set chart title
*
* @param strTitle
*/
public void setTitle(String strTitle) {
TextTitle title = chart.getTitle();
if (title == null) {
chart.setTitle(strTitle);
} else {
title.setText(strTitle);
}
}
/**
* Set Legend Position
*
* @param position
*/
public void setLegendPosition(RectangleEdge position) {
try {
LegendTitle legend = chart.getLegend();
legend.setPosition(position);
} catch (NullPointerException e) {
}
}
/**
* Make chart invisible
*
*/
public void hide() {
CategoryPlot plot = chart.getCategoryPlot();
NumberAxis numberAxis = (NumberAxis) plot.getRangeAxis();
numberAxis.setVisible(false);
CategoryAxis categoryAxis = (CategoryAxis) plot.getDomainAxis();
categoryAxis.setVisible(false);
plot.setRangeGridlinesVisible(false);
}
/**
* Set Subtitle Position
*
* @param position
*/
public void setSubTitlePosition(RectangleEdge position) {
if (hasSubTitle && subTitle != null) {
subTitle.setPosition(position);
}
}
/**
* Set Subtitle text
*
* @param text
*/
public void setSubTitleText(String text) {
if (hasSubTitle && subTitle != null) {
((TextTitle) subTitle).setText(text);
}
}
/**
* Set Subtitle Horizontal Aligment (LEFT,RIGHT,CENTER)
*
* @param align
*/
public void setSubTitleHorizontalAlignment(HorizontalAlignment align) {
if (hasSubTitle && subTitle != null) {
subTitle.setHorizontalAlignment(align);
}
}
/** Logger */
static Logger _log = Logger.getLogger(ConsumptionChartCustomizer.class);
}
That's so far for today!