报错信息:
500 Servlet Exception
java.lang.InternalError: Can't connect to X11 window server using ':0.0'
as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>;(X11GraphicsEnvironment.java:125)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:62)
at java.awt.Font.initializeFont(Font.java:309)
at java.awt.Font.<init>;(Font.java:345)
at org.jfree.chart.axis.AxisConstants.<clinit>;(Unknown Source)
at org.jfree.chart.axis.Axis.<init>;(Unknown Source)
at org.jfree.chart.axis.ValueAxis.<init>;(Unknown Source)
at org.jfree.chart.axis.NumberAxis.<init>;(Unknown Source)
at org.jfree.chart.ChartFactory.createXYLineChart(Unknown Source)
at HelloWorld.service(ShowChart.java:283)
at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
String last_time=year+month+date;
DBconnect db=new DBconnect();
String sql="select * from bank_fee_status_his where item_id='1' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
ResultSet rs=db.executeQuery(sql);
XYSeries series1 = new XYSeries("交通银行"
try{
double i=6.0;
while(rs.next())
{
if(!rs.getString(6).equals("0.00")
{
series1.add(i, Double.parseDouble(rs.getString(6)));
}
i++;
}
}
catch(Exception e){}
sql="select * from bank_fee_status_his where item_id='2' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series2 = new XYSeries("工商银行"
rs=db.executeQuery(sql);
sql="select * from bank_fee_status_his where item_id='3' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series3 = new XYSeries("邮政储蓄"
rs=db.executeQuery(sql);
sql="select * from bank_fee_status_his where item_id='4' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series4 = new XYSeries("招商银行"
rs=db.executeQuery(sql);
sql="select * from bank_fee_status_his where item_id='5' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series5 = new XYSeries("商业银行");
rs=db.executeQuery(sql);
sql="select * from bank_fee_status_his where item_id='6' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series6 = new XYSeries("上海浦东发展银行");
rs=db.executeQuery(sql);
sql="select * from bank_fee_status_his where item_id='7' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series7 = new XYSeries("建设银行");
rs=db.executeQuery(sql);
try{
sql="select * from bank_fee_status_his where item_id='8' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series8 = new XYSeries("深圳发展银行");
rs=db.executeQuery(sql);
try{
sql="select * from bank_fee_status_his where item_id='9' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series9 = new XYSeries("广东发展银行");
rs=db.executeQuery(sql);
try{
sql="select * from bank_fee_status_his where item_id='10' and to_char(last_time,'yyyymmdd')='"+last_time+"' order by last_time asc";
XYSeries series10= new XYSeries("华夏银行");
rs=db.executeQuery(sql);
try{