template.java

Java报表源程序 提供二维报表设计

		jasperDesign.setColumnSpacing(0);
		jasperDesign.setLeftMargin(40);
		jasperDesign.setRightMargin(40);
		jasperDesign.setTopMargin(50);
		jasperDesign.setBottomMargin(50);
/*		
		//Fonts
		JRDesignStyle normalStyle = new JRDesignStyle();
		normalStyle.setName("normalStyle");
		normalStyle.setDefault(true);
		normalStyle.setFontName("瀹嬩綋");
		normalStyle.setFontSize(12);
		normalStyle.setPdfFontName("瀹嬩綋");
		normalStyle.setPdfEncoding("GBK");
		normalStyle.setPdfEmbedded(false);
		jasperDesign.addStyle(normalStyle);

		JRDesignStyle boldStyle = new JRDesignStyle();
		boldStyle.setName("boldStyle");
		boldStyle.setFontName("瀹嬩綋");
		boldStyle.setFontSize(12);
		boldStyle.setBold(true);
		boldStyle.setPdfFontName("瀹嬩綋");
		boldStyle.setPdfEncoding("GBK");
		boldStyle.setPdfEmbedded(false);
		jasperDesign.addStyle(boldStyle);

		JRDesignStyle italicStyle = new JRDesignStyle();
		italicStyle.setName("italicStyle");
		italicStyle.setFontName("瀹嬩綋");
		italicStyle.setFontSize(9);
		italicStyle.setItalic(true);
		italicStyle.setPdfFontName("瀹嬩綋");
		italicStyle.setPdfEncoding("GBK");
		italicStyle.setPdfEmbedded(false);
		jasperDesign.addStyle(italicStyle);
*/
		/*	
		JRDesignStyle normalStyle = new JRDesignStyle();
		normalStyle.setName("Arial_Normal___1");
		normalStyle.setDefault(true);
		normalStyle.setFontName("Arial");
		normalStyle.setFontSize(12);
		normalStyle.setPdfFontName("Helvetica");
		normalStyle.setPdfEncoding("Cp1252");
		normalStyle.setPdfEmbedded(false);
		jasperDesign.addStyle(normalStyle);
	*/	
		
		JRDesignStyle normalStyle = new JRDesignStyle();
		normalStyle.setName("Arial_Normal");
		normalStyle.setDefault(true);
		normalStyle.setFontName("song");
		normalStyle.setFontSize(9);
		normalStyle.setPdfFontName("STSong-Light");
		normalStyle.setPdfEncoding("UniGB-UCS2-H");
		normalStyle.setPdfEmbedded(true);
		jasperDesign.addStyle(normalStyle);

		/*	
		JRDesignStyle boldStyle = new JRDesignStyle();
		boldStyle.setName("Arial_Bold");
		boldStyle.setFontName("Arial");
		boldStyle.setFontSize(9);
		boldStyle.setBold(true);
		boldStyle.setPdfFontName("瀹嬩綋");
		boldStyle.setPdfEncoding("Adobe-GB1-UCS2");
		boldStyle.setPdfEmbedded(false);
		jasperDesign.addStyle(boldStyle);

		
		JRDesignStyle italicStyle = new JRDesignStyle();
		italicStyle.setName("Arial_Italic");
		italicStyle.setFontName("Arial");
		italicStyle.setFontSize(9);
		italicStyle.setItalic(true);
		italicStyle.setPdfFontName("瀹嬩綋");
		italicStyle.setPdfEncoding("Adobe-GB1-UCS2");
		italicStyle.setPdfEmbedded(false);
		jasperDesign.addStyle(italicStyle);
		
		*/
		jasperDesign.setDefaultStyle(normalStyle);
		System.out.println("--22--" + jasperDesign.getLanguage());
		//Parameters
		JRDesignParameter parameter = new JRDesignParameter();
		parameter.setName("ReportTitle");
		parameter.setValueClass(java.lang.String.class);		
		jasperDesign.addParameter(parameter);

		parameter = new JRDesignParameter();
		parameter.setName("OrderByClause");
		parameter.setValueClass(java.lang.String.class);
		jasperDesign.addParameter(parameter);

		//Query
		JRDesignQuery query = new JRDesignQuery();
		query.setText("SELECT * FROM RST_EMPLOYEE ");
		jasperDesign.setQuery(query);

		//Fields
		JRDesignField field = new JRDesignField();
		field.setName("employeeid");
		field.setValueClass(java.lang.Integer.class);
		jasperDesign.addField(field);

		field = new JRDesignField();
		field.setName("employeename");
		field.setValueClass(java.lang.String.class);
		jasperDesign.addField(field);

		field = new JRDesignField();
		field.setName("employeecode");
		field.setValueClass(java.lang.String.class);
		jasperDesign.addField(field);

		field = new JRDesignField();
		field.setName("departmentid");
		field.setValueClass(java.lang.String.class);
		jasperDesign.addField(field);

		//Variables

		//Title
		JRDesignBand band = new JRDesignBand();		
		band.setHeight(50);
		JRDesignLine line = new JRDesignLine();		
		line.setX(0);
		line.setY(0);
		line.setWidth(515);
		line.setHeight(0);
		band.addElement(line);
		JRDesignTextField textField = new JRDesignTextField();
		textField.setBlankWhenNull(true);
		textField.setX(0);
		textField.setY(10);
		textField.setWidth(515);
		textField.setHeight(30);
		textField.setHorizontalAlignment(JRAlignment.HORIZONTAL_ALIGN_CENTER);
		textField.setStyle(normalStyle);
		textField.setFontSize(22);
		JRDesignExpression expression = new JRDesignExpression();
		expression.setValueClass(java.lang.String.class);
		expression.setText("$P{ReportTitle}");
		textField.setExpression(expression);
		band.addElement(textField);
		jasperDesign.setTitle(band);
		
		//Page header
		band = new JRDesignBand();
		band.setHeight(20);
		JRDesignRectangle rectangle = new JRDesignRectangle();
		rectangle.setX(0);
		rectangle.setY(5);
		rectangle.setWidth(515);
		rectangle.setHeight(15);
		rectangle.setForecolor(new Color(0x33, 0x33, 0x33));
		rectangle.setBackcolor(new Color(0x33, 0x33, 0x33));
		band.addElement(rectangle);
		JRDesignStaticText staticText = new JRDesignStaticText();
		staticText.setX(0);
		staticText.setY(5);
		staticText.setWidth(55);
		staticText.setHeight(15);
		staticText.setForecolor(Color.white);
		staticText.setBackcolor(new Color(0x33, 0x33, 0x33));
		staticText.setMode(JRElement.MODE_OPAQUE);
		staticText.setHorizontalAlignment(JRAlignment.HORIZONTAL_ALIGN_CENTER);
		staticText.setStyle(normalStyle);
		staticText.setText("employeeid");
		band.addElement(staticText);
		staticText = new JRDesignStaticText();
		staticText.setX(56);
		staticText.setY(5);
		staticText.setWidth(44);
		staticText.setHeight(15);
		staticText.setForecolor(Color.white);
		staticText.setBackcolor(new Color(0x33, 0x33, 0x33));
		staticText.setMode(JRElement.MODE_OPAQUE);
		staticText.setStyle(normalStyle);
		staticText.setText("employeename");
		band.addElement(staticText);
		staticText = new JRDesignStaticText();
		staticText.setX(101);
		staticText.setY(5);
		staticText.setWidth(50);
		staticText.setHeight(15);
		staticText.setForecolor(Color.white);
		staticText.setBackcolor(new Color(0x33, 0x33, 0x33));
		staticText.setMode(JRElement.MODE_OPAQUE);
		staticText.setStyle(normalStyle);
		staticText.setText("employeecode");
		band.addElement(staticText);
		jasperDesign.setPageHeader(band);
		staticText = new JRDesignStaticText();
		staticText.setX(151);
		staticText.setY(5);
		staticText.setWidth(50);
		staticText.setHeight(15);
		staticText.setForecolor(Color.white);
		staticText.setBackcolor(new Color(0x33, 0x33, 0x33));
		staticText.setMode(JRElement.MODE_OPAQUE);
		staticText.setStyle(normalStyle);
		staticText.setText("departmentid");
		band.addElement(staticText);
		jasperDesign.setPageHeader(band);
		
		//Column header
		band = new JRDesignBand();
		jasperDesign.setColumnHeader(band);
		
		//Detail
		band = new JRDesignBand();
		band.setHeight(20);
		
		textField = new JRDesignTextField();
		textField.setX(0);
		textField.setY(4);
		textField.setWidth(55);
		textField.setHeight(15);
		textField.setHorizontalAlignment(JRAlignment.HORIZONTAL_ALIGN_RIGHT);
		textField.setStyle(normalStyle);
		expression = new JRDesignExpression();
		expression.setValueClass(java.lang.Integer.class);
		expression.setText("$F{employeeid}");
		textField.setExpression(expression);
		band.addElement(textField);
		
		textField = new JRDesignTextField();
		textField.setStretchWithOverflow(true);
		textField.setX(56);
		textField.setY(4);
		textField.setWidth(44);
		textField.setHeight(15);
		textField.setPositionType(JRElement.POSITION_TYPE_FLOAT);
		textField.setStyle(normalStyle);
		expression = new JRDesignExpression();
		expression.setValueClass(java.lang.String.class);
		expression.setText("$F{employeename}");
		textField.setExpression(expression);
		band.addElement(textField);
		textField = new JRDesignTextField();
		textField.setStretchWithOverflow(true);
		textField.setX(101);
		textField.setY(4);
		textField.setWidth(50);
		textField.setHeight(15);
		textField.setPositionType(JRElement.POSITION_TYPE_FLOAT);
		textField.setStyle(normalStyle);
		expression = new JRDesignExpression();
		expression.setValueClass(java.lang.String.class);
		expression.setText("$F{employeecode}");
		textField.setExpression(expression);
		band.addElement(textField);
		textField = new JRDesignTextField();
		textField.setStretchWithOverflow(true);
		textField.setX(151);
		textField.setY(4);
		textField.setWidth(50);
		textField.setHeight(15);
		textField.setPositionType(JRElement.POSITION_TYPE_FLOAT);
		textField.setStyle(normalStyle);
		expression = new JRDesignExpression();
		expression.setValueClass(java.lang.String.class);
		expression.setText("$F{departmentid}");
		textField.setExpression(expression);
		band.addElement(textField);		
		line = new JRDesignLine();
		line.setX(0);
		line.setY(19);
		line.setWidth(515);
		line.setHeight(0);
		line.setForecolor(new Color(0x80, 0x80, 0x80));
		line.setPositionType(JRElement.POSITION_TYPE_FLOAT);
		band.addElement(line);
		jasperDesign.setDetail(band);

		//Column footer
		band = new JRDesignBand();
		jasperDesign.setColumnFooter(band);

		//Page footer
		band = new JRDesignBand();
		jasperDesign.setPageFooter(band);

		//Summary
		band = new JRDesignBand();
		jasperDesign.setSummary(band);
		
		return jasperDesign;
	}
}