Rising Sun 
          
				
          
			          		
		
          
	
          

          

          
	
          
		
          
			
 
BlogJava ::
首頁(yè) ::
新隨筆 ::
聯(lián)系 ::
聚合
 ::
管理 ::


			
			
				

          
	
          
		
          
			
			
			
				 
				148 
				隨筆 ::
				0 文章
				::
				22 評(píng)論
				::
				0 Trackbacks
			
		
          
	
          

          

			          		
		
          
	
          

          


          


          
	
					

          
	
	
	
          
		
		
            
				
          1. 
						
								/*
						
				
            2. 
				
          2. 
						
								?*?QuickExcel.java
						
				
            3. 
				
          3. 
						
								?*?作者：楊慶成
						
				
            4. 
				
          4. 
						
								?*?Created?on?2004年11月22日,?下午4:05
						
				
            5. 
				
          5. 
						
								?*?在實(shí)際應(yīng)用中經(jīng)常要將數(shù)據(jù)庫(kù)中的表導(dǎo)入Excel
						
				
            6. 
				
          6. 
						
								?*?本人在Apache的POI基礎(chǔ)上寫了一個(gè)簡(jiǎn)單的類
						
				
            7. 
				
          7. 
						
								?*?有不當(dāng)指出請(qǐng)指正，謝謝！
						
				
            8. 
				
          8. 
						
								?*?
						
				
            9. 
				
          9. 
						
								?*/
						
				
            10. 
				
          10. 
				
            11. 
				
          11. 
						
								package
						?yqc.poi; 

            12. 
				
          12. 
				
            13. 
				
          13. 
						
								import
						?java.sql.*; 

            14. 
				
          14. 
						
								import
						?java.util.*; 

            15. 
				
          15. 
						
								import
						?java.io.*; 

            16. 
				
          16. 
						
								import
						?java.io.ByteArrayInputStream; 

            17. 
				
          17. 
						
								import
						?java.io.FileInputStream; 

            18. 
				
          18. 
						
								import
						?java.io.FileOutputStream; 

            19. 
				
          19. 
						
								import
						?java.io.IOException; 

            20. 
				
          20. 
				
            21. 
				
          21. 
						
								import
						?org.apache.poi.hssf.usermodel.*; 

            22. 
				
          22. 
						
								import
						?org.apache.poi.poifs.filesystem.POIFSFileSystem; 

            23. 
				
          23. 
						
								import
						?org.apache.poi.hssf.record.*; 

            24. 
				
          24. 
						
								import
						?org.apache.poi.hssf.model.*; 

            25. 
				
          25. 
						
								import
						?org.apache.poi.hssf.usermodel.*; 

            26. 
				
          26. 
						
								import
						?org.apache.poi.hssf.util.*;import?yqc.sql.*; 

            27. 
				
          27. 
				
            28. 
				
          28. 
						
								/**
						
				
            29. 
				
          29. 
						
								?*
						
				
            30. 
				
          30. 
						
								?*?@author??Administrator
						
				
            31. 
				
          31. 
						
								?*/
						
				
            32. 
				
          32. 
						
								public
						?class?QuickExcel?{ 

            33. 
				
          33. ???? 

            34. 
				
          34. ????/**?Creates?a?new?instance?of?QuickExcel?*/
            35. 
				
          35. ????private?QuickExcel(String?file){ 

            36. 
				
          36. ????????_file=file; 

            37. 
				
          37. ????} 

            38. 
				
          38. ???? 

            39. 
				
          39. ????private?void?open()throws?IOException{ 

            40. 
				
          40. ????????InputStream?stream?=?null; 

            41. 
				
          41. ????????Record[]?records?=?null; 

            42. 
				
          42. ????????POIFSFileSystem?fs?= 

            43. 
				
          43. ????????????new?POIFSFileSystem(new?FileInputStream(_file)); 

            44. 
				
          44. ????????_wb?=?new?HSSFWorkbook(fs); 

            45. 
				
          45. ????} 

            46. 
				
          46. ???? 

            47. 
				
          47. ????private?void?create(){ 

            48. 
				
          48. ????????_wb=new?HSSFWorkbook(); 

            49. 
				
          49. ????} 

            50. 
				
          50. ???? 

            51. 
				
          51. ????public?static?QuickExcel?newInstance?(String?file){ 

            52. 
				
          52. ????????QuickExcel?qe=new?QuickExcel(file); 

            53. 
				
          53. ????????qe.create(); 

            54. 
				
          54. ????????return?qe; 

            55. 
				
          55. ????} 

            56. 
				
          56. ???? 

            57. 
				
          57. ????public?static?QuickExcel?openInstance(String?file)?throws?IOException?{ 

            58. 
				
          58. ????????QuickExcel?qe=new?QuickExcel(file); 

            59. 
				
          59. ????????qe.open(); 

            60. 
				
          60. ????????return?qe; 

            61. 
				
          61. ????} 

            62. 
				
          62. ???? 

            63. 
				
          63. ????public?void?close(){ 

            64. 
				
          64. ????????try{ 

            65. 
				
          65. ????????????FileOutputStream?fileOut?=?new?FileOutputStream(_file); 

            66. 
				
          66. ????????????_wb.write(fileOut);//把Workbook對(duì)象輸出到文件workbook.xls中
            67. 
				
          67. ????????????fileOut.close(); 

            68. 
				
          68. ????????} 

            69. 
				
          69. ????????catch?(Exception?ex){ 

            70. 
				
          70. ????????????System.out.println(ex.getMessage()); 

            71. 
				
          71. ????????} 

            72. 
				
          72. ????} 

            73. 
				
          73. ???? 

            74. 
				
          74. ????private?void?removeSheet(String?sheetName){ 

            75. 
				
          75. ????????int?i=_wb.getSheetIndex("sheetName"); 

            76. 
				
          76. ????????if?(i>=0)?_wb.removeSheetAt(i); 

            77. 
				
          77. ????} 

            78. 
				
          78. ???? 

            79. 
				
          79. ????public?int?fillSheet?(ResultSet?rs,String?sheetName)throws?SQLException?{ 

            80. 
				
          80. ????????HSSFSheet?st=?_wb.createSheet(sheetName); 

            81. 
				
          81. ????????ResultSetMetaData?rsmd=?rs.getMetaData(); 

            82. 
				
          82. ????????int?index=0; 

            83. 
				
          83. ????????int?result=0; 

            84. 
				
          84. ????????HSSFRow?row=st.createRow(index++); 

            85. 
				
          85. ????????for(int?i=1;i<=rsmd.getColumnCount();++i){ 

            86. 
				
          86. ????????????HSSFCell?cell=row.createCell((short)(i-1)); 

            87. 
				
          87. ????????????cell.setCellValue(rsmd.getColumnName(i)); 

            88. 
				
          88. ????????} 

            89. 
				
          89. ????????while(rs.next())?{ 

            90. 
				
          90. ????????????result++; 

            91. 
				
          91. ????????????row=st.createRow(index++); 

            92. 
				
          92. ????????????for(int?i=1;i<=rsmd.getColumnCount();++i){ 

            93. 
				
          93. ????????????????HSSFCell?cell=row.createCell((short)(i-1)); 

            94. 
				
          94. ????????????????cell.setEncoding(cell.ENCODING_UTF_16); 

            95. 
				
          95. ????????????????cell.setCellValue(rs.getString(i)); 

            96. 
				
          96. ????????????} 

            97. 
				
          97. ????????} 

            98. 
				
          98. ????????return?result; 

            99. 
				
          99. } 

            100. 
				
          100. ???? 

            101. 
				
          101. ????public?static?void?main(String[]?args){ 

            102. 
				
          102. ????????try{ 

            103. 
				
          103. ????????????QuickConnection?qc=new?MssqlConnection("jdbc:microsoft:sqlserver://192.168.0.100:1433;DatabaseName=ls"); 

            104. 
				
          104. ????????????QuickExcel?qe=QuickExcel.newInstance("a.xls"); 

            105. 
				
          105. ????????????qc.connect(); 

            106. 
				
          106. ????????????String?sql="select?*?from?ls.dbo.radio1_emcee"; 

            107. 
				
          107. ????????????ResultSet?rs=qc.getStatement().executeQuery(sql); 

            108. 
				
          108. ????????????qe.fillSheet(rs,"MT"); 

            109. 
				
          109. ????????????qe.close(); 

            110. 
				
          110. ????????????qe=QuickExcel.openInstance("a.xls"); 

            111. 
				
          111. ????????????qe.fillSheet(rs,"MO"); 

            112. 
				
          112. ????????????qe.close(); 

            113. 
				
          113. ????????????qc.close(); 

            114. 
				
          114. ????????} 

            115. 
				
          115. ????????catch?(SQLException?ex){ 

            116. 
				
          116. ????????????System.out.println(ex.getMessage()); 

            117. 
				
          117. ????????} 

            118. 
				
          118. ????????catch?(IOException?ex){ 

            119. 
				
          119. ????????????System.out.println(ex.getMessage()); 

            120. 
				
          120. ????????} 

            121. 
				
          121. ????} 

            122. 
				
          122. ???? 

            123. 
				
          123. ????HSSFWorkbook?_wb; 

            124. 
				
          124. ????String?_file="new.xls"; 

            125. 
				
          125. } 
            126. 
		
          

	
          
	
	
          
		posted on 2006-07-26 15:30 brock 閱讀(459) 評(píng)論(0)  編輯  收藏  所屬分類: 處理Excel poi 
	
          

          







          
	    
    




          








          

				

          




    







          
        
	




主站蜘蛛池模板：
潮州市|
东丰县|
南溪县|
鱼台县|
蓬溪县|
武邑县|
黔江区|
时尚|
响水县|
那坡县|
大理市|
溧水县|
常山县|
海城市|
阳高县|
彩票|
延安市|
钟祥市|
界首市|
江山市|
交城县|
宝坻区|
全州县|
宝山区|
马关县|
定南县|
沿河|
周宁县|
旬阳县|
丹东市|
郓城县|
房产|
淮安市|
监利县|
敦煌市|
垣曲县|
天津市|
潜山县|
东安县|
邵武市|
通榆县|