package bean;
import java.sql.*;
import java.sql.*;
import java.util.*;
import java.io.*;
import javax.swing.*;
import org.jfree.data.*;
import org.jfree.chart.*;
import org.jfree.chart.plot.*;
public class L {
//定义初始变量
int i = 0;
int a = 0;
public String selMonth = null;
public String selArea = null;
public String selCity = null;
public String selNet = null;
Vector cleardayStr = new Vector(1,1);
Vector feesumStr = new Vector(1,1);
Vector cleardayStr1 = new Vector(1,1);
Vector feesumStr1 = new Vector(1,1);
Vector monthNum = new Vector(1,1);
Vector cityName = new Vector(1,1);
Vector cityCode = new Vector(1,1);
Vector cityName1 = new Vector(1,1);
Vector cityCode1 = new Vector(1,1);
public void setSelMonth(String selMonth){
this.selMonth = selMonth;
}
public void setSelArea (String selArea){
this.selArea = selArea;
}
public void setSelCity(String selCity){
this.selCity = selCity;
}
public void setSelNet(String selNet){
this.selNet = selNet;
}
public String getSelMonth(){
return selMonth;
}
public String getSelArea(){
return selArea;
}
public String getSelCity(){
return selCity;
}
public String getSelNet(){
return selNet;
}
//获取数据库信息
public int setData(){
//建立连接
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){}
String url="jdbc:oracle:thin:@128.0.2.5:1521:A";
String user="1234";
String password="1234";
String dte = null;
String d =null;
int dat = 0;
//获取本月月份
try{
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = null;
String sql = null;
if(selCity == "n") selCity = null;
if(selNet == "n") selNet = null;
if(selMonth == "n") selMonth = null;
if(selArea == "n") selArea = null;
if (selCity != null)
selArea = "9%";
else if (selCity ==null && selArea != null)
selCity = "%";
else if (selCity == null && selArea == null){
selArea = "9%";
selCity = "%";
}
if (selNet == null)
selNet = "11,21";
dat = 0;
d = month.substring(0,6);
dte = d+"%";
dat = Integer.parseInt(d);
System.out.println(dte);
System.out.println(selNet);
System.out.println(selCity);
System.out.println(selArea);
//得到本月日期数据的sql语句
sql="select distinct clearday, sum(FEESUM) as feesum from temp_billday a , v_dim_area_5 b where a.cityCode=b.city_code and city_l2code like '"+selArea+"' and city_code like '"+selCity+"' and netcode in ("+selNet+") and clearday like '"+dte+"' group by clearday";
rs=stmt.executeQuery(sql);
while(rs.next()){
feesumStr.add(rs.getString("feesum"));
}
sql="select distinct CLEARDAY, sum(FEESUM) as feesum from temp_billday a , v_dim_area_5 b where a.cityCode=b.city_code and city_l2code like '"+selArea+"' and city_code like '"+selCity+"' and netcode in ("+selNet+") and clearday like '"+dte+"' group by clearday";
rs=stmt.executeQuery(sql);
while(rs.next()){
cleardayStr.add(rs.getString("CLEARDAY"));
}
dat = dat - 1;
dte = dat+"%";
//得到上月日期数据的sql语句
sql="select distinct clearday,sum(FEESUM) as feesum from temp_billday a , v_dim_area_5 b where a.cityCode=b.city_code and city_l2code like '"+selArea+"' and city_code like '"+selCity+"' and netcode in ("+selNet+") and clearday like '"+dte+"' group by clearday";
rs=stmt.executeQuery(sql);
while(rs.next()){
feesumStr1.add(rs.getString("FEESUM"));
}
sql="select distinct CLEARDAY, sum(FEESUM) as feesum from temp_billday a , v_dim_area_5 b where a.cityCode=b.city_code and city_l2code like '"+selArea+"' and city_code like '"+selCity+"' and netcode in ("+selNet+") and clearday like '"+dte+"' group by clearday";
rs=stmt.executeQuery(sql);
//得到可选月份
sql="select distinct clearday from temp_billday where clearday like '2003%02'";
rs=stmt.executeQuery(sql);
while(rs.next()){
monthNum.add(rs.getString("clearday"));
}
//得到地区名称
sql="select distinct city_l2name,city_l2code from v_dim_area_5 order by city_l2code";
rs=stmt.executeQuery(sql);
while(rs.next()){
cityCode.add(rs.getString("city_l2code"));
cityName.add(rs.getString("city_l2name"));
}
sql="select city_code,city_name from v_dim_area_5 order by city_code";
rs=stmt.executeQuery(sql);
while(rs.next()){
cityName1.add(rs.getString("city_name"));
cityCode1.add(rs.getString("city_code"));
}
a=0;
rs.close();
stmt.close();
conn.close();
}catch(Exception e){System.out.println (e);}
cleardayStr.trimToSize();
feesumStr.trimToSize();
cleardayStr1.trimToSize();
feesumStr1.trimToSize();
monthNum.trimToSize();
cityCode.trimToSize();
cityName.trimToSize();
cityName1.trimToSize();
cityCode1.trimToSize();
return cleardayStr.size();
}
public Vector getMonthNum(){
return monthNum;
}
public Vector getCurrentDate(){
return cleardayStr;
}
public Vector getCurrentData(){
return feesumStr;
}
public Vector getLastDate(){
return cleardayStr1;
}
public Vector getLastData(){
return feesumStr1;
}
public Vector getCityName(){
return cityName;
}
public Vector getCityCode(){
return cityCode;
}
public Vector getCityName1(){
return cityName1;
}
public Vector getCityCode1(){
return cityCode1;
}
int g=setData();
public JFreeChart getChart(){
//声明画图的数据集
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
int i=0;