??????浠ュ??浣?浜? 璁よ??IReport杩?涓?IDE??韬????跺?烘???ㄦ? 锛?瀛???讹?浣?涓???瑕??ㄩ?ㄥ???版?ゆ??绔?涓???渚?瀛?锛???瑕???瑙ｄ究??锛??蜂??ㄦ?灏??ㄥ???㈡???帮? ????涓昏?璁茶堪浜?ireport??涓?杞姐??瀹?瑁????????缁?锛?浠ュ???烘????浣跨?ㄦ?规?锛???杩?杩??ヤ?涓?mysql???版??婧?锛?璁捐?′?涓???琛ㄥ?????
??????浠ュ??浣?浜?璁よ??IReport杩?涓?IDE??韬????跺?烘???ㄦ?锛?瀛???讹?浣?涓???瑕??ㄩ?ㄥ???版?ゆ??绔?涓???渚?瀛?锛???瑕???瑙ｄ究??锛??蜂??ㄦ?灏??ㄥ???㈡???帮? ????涓昏?璁茶堪浜?ireport??涓?杞姐??瀹?瑁????????缁?锛?浠ュ???烘????浣跨?ㄦ?规?锛???杩?杩??ヤ?涓?mysql???版??婧?锛?璁捐?′?涓???琛ㄥ????ヨ〃锛?骞惰?茶堪浜???ava绋?搴?涓?浣跨?ㄦ?ゆ?ヨ〃???烘??姝ラ?ゃ???ヨ〃??缁???棰?瑙?濡?涓??撅?
锛?http://www.宸?姹??峰??.cn ??
?????浜烘??Word?靛????妗ｆ?煎?锛?濡???瑕?锛?璇疯??绯绘??浜猴?[email?protected]
1涓?杞?Report
iReport??涓?涓???瑙??????ヨ〃妯℃?胯?捐?″伐?凤?浣跨?ㄦ?ゅ伐?疯?芥?逛究?板?规?ヨ〃杩?琛?璁捐?°????Report涓?宸茬?????浜?jasperreports?ㄨ?琛??堕??瑕???jar??浠讹??ㄩ」??涓???lib??褰?涓?????Jasperreports-***.jar?冲??锛??朵腑***涓虹?????凤?姣?濡?2.0.3??
涓?杞藉?板??锛?http://sourceforge.net/project/showfiles.php?group_id=64348锛?姝ゆ??妗ｇ????剁????涓?.0.3锛?濡??撅?
?瑰??ownload?虹?颁互涓??????
??浠ョ???版??渚?浜?澶?绉?涓?杞藉??锛??朵腑锛?
?iReport-2.0.3-src.zip锛?涓?Report??婧?浠ｇ??
?iReport-2.0.3.tar.gz锛?涓?tar.gz?煎?锛?涓????ㄤ?Linux??Unix绛???windows绯荤?
?iReport-2.0.3-windows.installer.exe锛?涓?xe?煎?锛?涓????ㄤ?windows绯荤?
?iReport-2.0.3.zip锛?涓?ip?煎?锛???浠ョ?ㄤ???绫绘??浣?绯荤?
????浣跨??indow????涓轰?锛???姝や?杞?Report-2.0.3-windows.installer.exe?冲????
2瀹?瑁?iReport
瀹?瑁?iReport??瑕???璁剧疆JDK??澧?锛?2.0.X????瑕?姹?JDK1.5??澧?(????????妗???
濡?????windows绯荤?锛??存?ュ???诲??瑁??炬??
?冲????(濡?????涓?杞界??ZIP??妗ｏ???灏??惰В???版??瀹?????褰?锛?杩???杩?琛?bin/startup.bat)??
濡??????朵?绯荤?锛?姣?濡?Linux锛?Unix绛?锛?瑙ｅ??涓?杞界??瀹?瑁???浠?濡?涓?杞界????tar.gz?煎?锛?浣跨??ar xvfziReport-2.0.3.tar.gz杩?琛?瑙ｅ??锛?濡?涓?杞界??zip?煎?锛?浣跨??ip?戒护瑙ｅ??)锛??跺??杩?琛?bin/startup.sh?冲????
浠ヤ?浠ュ??indows涓?瀹?瑁?涓轰?锛?
A.娆㈣???????瑰?烩??Next >??缁х画
B.??璇?icense??瀹癸??瑰?烩??I Agree??缁х画
C.???╁??瑁?缁?浠讹??瑰?烩??Next >??缁х画
D.??瀹?瀹?瑁?璺?寰?锛??瑰?烩??Next >??缁х画
E.??瀹?绋?搴?缁???绉帮??瑰?烩??Install???冲??
F.绛?寰?瀹?瑁?杩?绋?
G.瀹?瑁?缁???锛??瑰?烩??Finish??瀹???
?ㄦ????浼??虹?板?姝ゅ?炬??锛?
??
3缂?杈?涓?涓??ヨ〃妯℃??
3.1 ????Report
????Report-2.0.3锛?濡??撅?
iReport???ㄤ??规??杩?琛????哄?ㄧ??Locale灞??ц???ㄨ?剧疆杞?浠惰??瑷?(Language)锛?杩??????戒??虹?颁?浜???宸?锛?绗???浣跨?ㄧ????绠?浣?涓???锛?浣????ㄥ??璁捐?＄???㈡??绻?浣?涓???锛???姝ゆ??浠???瑕?瀵瑰?惰?琛?璁剧疆??
3.2 璁剧疆榛?璁よ??瑷?
宸ュ?锋??->??宸ュ?封??(????Option??)->???搁????
?存?硅??瑷?绉?绫伙?浠?涓??ヨ????涓????┾??涓???(涓???????濡?????寮?灏辨??姝ら」锛???浠ュ???存?㈡??????绉?绫?姣?濡???涓?????)锛??跺????娆¤??ユ?ょ???㈠??舵?存?㈡????涓???(涓???????
?瑰?烩??瀛?妾?????锛???浠ョ???扮???㈠????浜???绠?浣?涓?????锛?
3.3 ?朵?璁剧疆
姝ゆ?ヤ???蹇?椤荤??锛??规????瑕?璁惧????
浣跨??Report?板??寤虹???ヨ〃妯℃?夸负.jrxml?煎?锛?缂?杈?瀹?姣?????瑕?缂?璇?锛?缂?璇?浼?浜х??.jasper??浠讹??ㄨ?琛??堕??瑕?缂?璇?濂界??.jasper??浠躲??杩?????绫讳技java绋?搴?锛?婧?浠ｇ????浠舵??.java锛?缂?璇?濂戒?????.class??浠讹??ㄥ??ㄧ???跺??????瑕?.class??浠躲??
?变?瀹?瑁?濂戒???榛?璁ょ??浜х??.jasper??浠跺氨?ㄥ?????褰?锛?涓轰?渚夸?绠＄??锛???浠ュ??Report璁捐?¤蒋浠惰?琛?涓?浜?璁剧疆锛?缁?涓???褰??ヤ?瀛?缂?璇?濂界??jasper??浠躲??
iReport??浠ユ??澶?绉??瑰?杩?琛??ヨ〃棰?瑙?(pdf??excel)绛?锛?姣?娆￠?瑙??跺??锛?濡??????╄?浜??煎?锛??ｄ?浼?浜х??杩?浜???浠讹?涔???浠ラ??杩?姝よ?剧疆缁?涓?淇?瀛???
宸ュ?锋??涓???Option??->????椤光??锛??跺???ㄩ??椤瑰?′????┾??Compiler??锛?瀵光??Default compilation directory??????Directory where the paged out data is stored??杩?琛?璁剧疆锛??瑰?绘??杈圭????娴?瑙????冲??杩?琛???褰????┿??
濡???缂?璇?涓?甯???淇?瀛????ㄤ骇????java??浠讹???浠ュ?绘????keep .java file?????㈢???鹃????
3.4 ?板缓?ヨ〃妯℃??ample
A.宸ュ?锋??->??妗ｆ???->??寮????版。??
B.杈??ユ?ヨ〃??绉帮?????涓衡??sample??锛??瑰?烩??OK??缁х画
C.濡??剧????
濡??撅???浠ョ???版?ヨ〃妯℃?挎?ｆ??????涓??哄??锛?瑙ｉ??濡?涓?锛?
?title
title娈靛???ㄦ?翠釜?ヨ〃??绗?涓?椤电????涓??㈤?ㄥ???剧ず锛??や?绗?涓?椤典互澶?锛?涓?绠℃?ヨ〃涓??辨??澶?灏?涓?椤甸???涓?浼????虹??itle娈典腑????瀹广??
?pageHeader
pageHeader娈典腑????瀹瑰?浼??ㄦ?翠釜?ヨ〃涓???姣?涓?涓?椤甸??腑?戒??虹?帮??剧ず?ㄤ?缃??ㄩ〉?㈢??涓????濡??????ヨ〃??绗?涓?椤碉?pageHeader涓?????瀹瑰??剧ず??itle娈典?????や?绗?涓?椤典互澶????朵?????椤甸??腑pageHeader涓?????瀹瑰??ㄦ?剧ず?ㄩ〉?㈢????涓?绔???
?columnHeader
??瀵?etail娈电??琛ㄥご娈碉?涓??????典??ㄨ?涓?娈典腑?绘?ヨ〃涓?????????棰???姣?椤靛??浼??虹?颁?娆°??
?detail
?ヨ〃??瀹规?碉??ㄨ?涓?娈典腑璁捐?℃?ヨ〃涓???瑕???澶??虹?扮????瀹癸?detail娈典腑????瀹规??椤甸?戒??虹?般??
?columnFooter
??瀵?etail娈电??琛ㄥ熬娈碉?姣?椤靛??浼??虹?颁?娆°??
?pageFooter
?剧ず?ㄦ???ㄩ〉?㈢????涓?绔?锛?姣?椤甸?芥?剧ず锛?????涓?椤电??astPageFooter?夸唬
?lastPageFooter
????涓?椤甸〉灏炬?靛??瀹癸????ㄦ????涓?椤靛?虹?颁?娆°??
?summary
琛ㄦ?肩????璁℃?碉??虹?板?ㄦ?翠釜?ヨ〃??????涓?椤典腑??detail娈电???????涓????ㄦ?ョ?璁℃?ヨ〃涓???涓?涓???????涓?瀛?娈电????璁″?笺??
D.??寤烘?版??搴?绫诲????JDBC?版??婧?
iReport????澶?绉??版??搴?锛???渚?????ysql浣?涓虹ず渚?
宸ュ?锋??涓???Data??->??杩?缁?/璧?婧??ユ???
?ㄢ??Connections/Datasources??????腑?瑰?烩??New??
?ㄢ??Connections properties??涓????┾??DatabaseJDBC connection??锛??瑰?烩??Next??缁х画锛?杩?????浠ョ???帮?jasperreport???版???ユ???浠ユ??寰?澶??瑰?锛??版??搴???XML??浠躲??JavaBean??浠剁??锛?浠?涓??句腑??浠ョ???烘?ャ??
E.??瀹??版??搴?JDBC绫诲????JDBC URL
?朵腑锛?iReport涓?宸茬?????浜?mysql??hsqldb杩?涓ょ??版??搴???椹卞??ar??浠讹???浠ユ?规??瀹?????瑕????╀?????JDBC Type锛?(璁板??疯??稿????版??搴?JDBC椹卞??ar??浠跺?伴」????lib??褰?涓?)
?规??瀹?????瀹癸?杈???DBC URL???ㄦ?峰????瀵???
杈??ュ??????锛??瑰?烩??Text??锛?濡??虹?板?涓??????璇存??杩??ユ??????
?瑰?烩??save??淇?瀛?锛??ㄥ??琛ㄤ腑??浠ョ???版?よ??ョ????缃?
F.璁剧疆?ヨ〃?ヨ??
宸ュ?锋????Data??->???ヨ〃?ヨ?⑩??
?虹?板?涓??????
??浠ョ???版?版??婧???澶?绉??瑰?锛?杩?????浠?浣跨??eport Query?瑰?锛?杩?绉??瑰???浠ョ?存?ラ????uery Lanuage绉?绫伙??跺?????ㄧ?杈?妗?涓?杈???QL璇??ャ??
濡?锛?select * from employee锛??跺??浼????ㄨ?诲???稿?宠〃??缁????烘?ワ?濡??撅?
?瑰?烩??OK??浠ュ??锛?杩?浜?琛ㄧ??Field Name灏?浼?琚????ュ?扳??Document structure??????Fields???ㄥ??锛?濡??撅?
杩???涔???浠ラ???ㄥ???绉??瑰?锛?灏辨??寮??ュ???帮?杩??峰??浠ュ?ㄨ??ㄧ???跺???规??涓??¤???姣?杈??垫椿?伴??杩?璁剧疆???版?ユ?瑰???版????瀹癸?
?ㄢ??Document structure???烘?惧?扳??Parameters??锛??抽?????诲??锛????┾??Add????锛??????┾??Parameter??锛?濡??撅?
杈??ヤ互涓???瀹癸?ParameterName?ㄦ?ヨ〃?ヨ?㈢????腑瑕?浣跨??????ㄨ??宸辩??涓??￠?昏?涓?浣跨?????浠ユ?瑰??锛?杩???涔???浠ョ?涓?涓?榛?璁ゅ?硷???efault ValueExpression??瀹癸?娉ㄦ??Parameter Class Type绫诲??锛???渚?浣跨?ㄩ?璁ょ??java.lang.String
?ㄢ???ヨ〃?ヨ?⑩??缂?杈???瀹逛腑灏辨??瀹?涓轰娇?ㄦ?ゅ???帮??煎?涓衡??$P!{parameterName}??锛???渚?涓?灏变娇?ㄢ??$P!{SQLSTR}??锛?杈??ュ??锛????峰??浠ョ???拌〃缁???浼????ㄦ?存?板?烘?ワ??瑰?烩??OK??锛????蜂???杩?浜?琛ㄧ?????瀹规?剧疆?扳??Fileds???哄??涓???
G.缂?杈??ヨ〃妯℃??
濡??撅??ㄧ?杈??轰腑瀵瑰???娈典腑?剧疆??瑕???瑕?绱?锛?瑕?绱???寰?澶?绉?锛?甯哥?ㄧ????浠ヤ???绉?绫诲??锛?
???????????瀹?
锛?杩?浜???瀹规???哄??涓???????????瀹癸?濡?涓??剧????Test Report??
?????Parameter)锛?濡?涓??锯??$P{SQLSTR}??
?瀛?娈?Fields)锛?濡?涓??锯??$F{EMPLOYEE_ID}??
?????(Variables)锛?濡?涓??锯??$V{PAGE_NUMBER}??
浠?杩????㈡????瑕?????瀹规???烘?ユ?剧疆?版ā?跨?杈??轰腑
?稿???娈典腑?冲????
H.缂?璇?棰?瑙?
?ㄥ伐?锋??涓??惧??
锛???????缂?璇????ц????ц?(?ㄦ??杩?缁?)锛??瑰?荤?璇?灏?浼?浜х??.jasper??浠讹??瑰?绘?ц?浼???缂?璇???棰?瑙?(濡???璁惧??浜?瀵瑰???棰?瑙?)??
棰?瑙???澶?绉??瑰?锛??瑰?诲伐?锋??涓???寤虹????锛???浠ョ???板?涓??惧?绉?棰?瑙??瑰?锛?
?规????瑕????╅?瑙?绫诲??锛?杩?瑕?娉ㄦ??锛?濡???娌℃??瀵瑰???杞?浠?姣?濡?Adobe Reader)?ユ?ョ??????濂界????浠讹??ｄ?浼????版????锛?iReport浼??ㄥ?瑰?????褰???????浠惰??宸?瑙?3.3??)??
濡?浣?璁剧疆??浠剁???ョ??杞?浠讹?杩????ㄥ伐?锋??涓??瑰?烩??Options??->????椤光??锛??跺???ㄩ??椤瑰?′腑???┾??External Programs??锛???瀵规??涓?绉???瑕?璁剧疆???煎????╁?瑰????ョ??杞?浠讹?濡??撅?
杩??凤???瀹?浜?棰?瑙???浠剁??绫诲??锛?????瀹?浜?棰?瑙???杞?浠讹??瑰?婚?瑙??跺氨浼????ㄥ?瑰???娑??灞?绀哄?烘?ャ??
I.棰?瑙?????
J.?ヨ〃妯℃?垮?朵?瀹???
4Web涓?浣跨??Report
4.1 寮???宸ュ??
寮???宸ュ?蜂娇??clispe3.2.2??MyEclipse5.0????寮???????澧???缃????????????????
4.2 ??寤洪」??
??寮?Eclipse锛??ㄥ伐?锋??涓?锛???File??->??New??->??Other??
??寤轰?涓?web椤圭??锛????┾??MyEclipse??涓?????Web Project??锛??瑰?烩??Next??涓?涓?姝ワ?濡??撅?
杈???roject Name锛???渚?涓衡??iReportTest??锛??瑰?烩??Finish??瀹???濡??撅?
?ㄩ」????琛ㄤ腑??浠ョ????ReportTest??椤圭??锛?
4.3 瀵煎??ar??浠?
?ㄩ」??涓??惧?扳??WebRoot??->??lib??锛??抽?????伙????┾??Import????锛?濡??撅?
???┾??General??->??File System???瑰?烩??Next??缁х画
?瑰?烩??Browse????锛???瀹?jar??浠讹?杩?????绾у??????浠ユ????Jasper瀹?瑁???褰?涓???lib??褰?涓???????jar??浠讹?杩??峰??浠ュ揩?????版????锛???浠ユ???ゅ?朵腑??txt??浠躲??
椤圭??涓???浠ョ????ar??浠惰?寮??ヤ?锛?濡??撅?
4.4 瀵煎??asper??浠?
??ebRoot涓?寤虹????褰?report锛?骞舵??3.4??缂?璇?濂界??jasper??浠跺?煎?ヨ??ャ??
4.5 澶???甯???涓??????ヨ〃
褰?????涓?DF?煎??讹????戒????颁腑????瀹规??娉??剧ず锛?涓昏???璁剧疆font?跺????瑕?娉ㄦ??浠ヤ????癸?
1.璁剧疆??瀛?浣???Font Name??瑕????芥?剧ず涓?????锛?姣?濡?瀹?浣???SansSerfi
2.璁剧疆PDF Font Name涓?TSong-Light
3.璁剧疆PDF Encoding涓?niGB-UCS2-H (Chinese Simplified)
4.????ib涓?????iTextAsian.jar??浠?
?抽?????婚??瑕??瑰??瀛?浣?????瀹癸????┾??灞??р??锛??ㄩ??椤瑰?′腑???┾??Font??锛???濡??炬?存?癸?
PDF棰?瑙?????濡?涓?锛?
4.6 瀛?浣?灞??х?涓?璁剧疆
?ㄤ?涓???涓?????瀵规??涓?涓?瀛?浣?妗?杩?琛?璁剧疆锛?濡?????瑕?璁剧疆100涓???璇?锛?杩??蜂?涓?涓?涓??昏?剧疆灏辨?惧?姣?杈?绻???锛???浣?浜???????
iReport??渚?浜?涓?涓????斤?灏辨????杩?绉?璁剧疆??缃?濂斤??跺????????瑕????跺?????╁氨??浠ヤ????ㄥ伐?锋??涓????煎?????->??Style??(2.0.3???ㄨ??浣跨?ㄨ?绉??瑰?锛?濡????╂???????????┾??瀛?浣???)锛?濡??撅?
?瑰?烩??New????寤轰?绉??版?煎?锛??藉??涓衡??瀹?浣???锛???杩?琛??稿?宠?剧疆锛?濡??撅?
杩??凤?杩?涓???瀹?浣?????Style灏辫?剧疆濂戒?锛??ㄨ?惧??瀛?浣????跺??灏变???瑕????伴??椤瑰?′?椤逛?椤瑰?拌?琛?璁剧疆锛??ㄥ??浣???灞??т腑???┾??Common????椤瑰?★???tyle涓????╄?涓???瀹?浣????冲??锛?
4.7 ??寤烘?剧ずHTML?煎??ヨ〃??JSP??浠?
??ebRoot?圭??褰?涓???寤?sp??浠?esthtml.jsp锛???瀹瑰?涓?锛?
pagecontentType="text/html;charset=GB2312"%>
pageimport="net.sf.jasperreports.engine.*"%>
pageimport="java.util.*"%>
pageimport="java.io.*"%>
pageimport="java.sql.*"%>
//?ヨ〃缂?璇?涔?????????.jasper??浠剁??瀛??句?缃?
File reportFile =newFile(this.getServletContext().(1)
getRealPath("/report/sample.jasper"));
String url="jdbc:mysql://localhost:3306/db";
Class.forName("com.mysql.jdbc.Driver");
Map parameters =newHashMap();
//"SQLSTR"???ヨ〃涓?瀹?涔??????板??绉??剁被??涓?tring??
//璁剧疆SQLSTR???扮????瀹??规????瑕?璧???ql璇???
parameters.put("SQLSTR","select *
from employee");(2)
Connectionconn =DriverManager.getConnection(url,(3)
"username","password");
JasperRunManager.runReportToHtmlFile(reportFile.getPath(),(4)
parameters,conn);
response.sendRedirect("report/sample.html");(5)
%>
浠ｇ??璇存??锛?
1.瀹?浣?jasper??浠?
2.缁??ヨ〃妯℃?夸腑浣跨?ㄥ?扮??????QLSTR璧??硷?杩?????瀹?涓?涓?sql璇???
3.????DBC?瑰?杩?缁??版??搴?
4.????HTML??浠讹????板????涓烘?ヨ〃??浠舵ā?跨?╃??浣?缃?锛??ヨ〃???帮??版??搴?杩?缁?
5.杞????版?ら〉???杩?涓?椤甸?㈡???哄????锛???瑕????ヨ〃妯℃?跨??浣?缃???璺?寰??稿??
??甯?椤圭????棰?瑙?锛?杈???ttp://localhost:8080/iReportTest/testhtml.jsp(??渚?????omcat浣?涓?eb???″?????甯?杩?绋??????朵???妗ｏ??版??搴????ㄧ??mysql)
????锛?
4.8 ??寤烘?剧ずPDF?煎??ヨ〃??JSP??浠?
??ebRoot?圭??褰?涓???寤?sp??浠?estpdf.jsp锛???瀹瑰?涓?锛?
pagecontentType="application/pdf;charset=UTF-8"%>
pageimport="net.sf.jasperreports.engine.*"%>
pageimport="java.util.*"%>
pageimport="java.io.*"%>
pageimport="java.sql.*"%>
//?ヨ〃缂?璇?涔?????????.jasper??浠剁??瀛??句?缃?
File reportFile =newFile(this.getServletContext().
getRealPath("/report/sample.jasper"));
String url="jdbc:mysql://localhost:3306/db";
Class.forName("com.mysql.jdbc.Driver");
Map parameters =newHashMap();
//"SQLSTR"???ヨ〃涓?瀹?涔???涓?涓????板??绉??剁被??涓?tring??
parameters.put("SQLSTR",
"select * from employee where employee_id like 'Z%'");
Connection conn = DriverManager.getConnection(url,
"username","password");
byte[] bytes=JasperRunManager.
runReportToPdf(reportFile.getPath(),parameters,conn);
response.setContentType("application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream outStream = response.getOutputStream();
outStream.write(bytes,0,bytes.length);
outStream.flush();
outStream.close();
out.clear();
out = pageContext.pushBody();
%>
????濡?涓?锛?
??????????甯?php涓???缃?锛?杞?杞借?锋敞???哄?锛???璋㈡?ㄧ??灏???锛?