java转接sqlite,导出成excel
java 代码[*]package com.taihee.sql;
[*]
[*]import java.io.File;
[*]import java.sql.*;
[*]
[*]import jxl.Workbook;
[*]import jxl.write.Label;
[*]import jxl.write.WritableSheet;
[*]import jxl.write.WritableWorkbook;
[*]
[*]import org.sqlite.JDBC;
[*]
[*]import com.taihee.swt.constant.GBISO;
[*]public class SQLitetoXLS {
[*] public void proccess(ResultSet rs,String file_name){
[*] rstoXls(rs,file_name);
[*] }
[*] public void rstoXls(ResultSet rs,String bm) {
[*]
[*] try {
[*] int i=1;
[*] WritableWorkbook book=Workbook.createWorkbook(
[*] new File("D:\\jxpj\\"+bm+".xls"));
[*] WritableSheet sheet=book.createSheet(bm,0);
[*] ResultSetMetaData rsmt=rs.getMetaData();
[*] for(int z=0;z<rsmt.getColumnCount();z++){
[*] Label label1=new Label(z,0,rsmt.getColumnName(z+1));
[*] sheet.addCell(label1);
[*] }
[*]
[*] while(rs.next()){
[*] for(int y=0;y<rsmt.getColumnCount();y++){
[*] Label label=new Label(y,i,GBISO.iso2gb(rs.getString(y+1)));
[*] sheet.addCell(label);
[*] }
[*] i++;
[*]
[*] }
[*] book.write();
[*] book.close();
[*] } catch (Exception e) {
[*] e.printStackTrace();
[*] }
[*]
[*] }
[*] public static void main(String[] args) {
[*] try {
[*] String fileName = "F:/SQLite/mydb";
[*] Class.forName("org.sqlite.JDBC");
[*] Connection conn = DriverManager.getConnection("jdbc:sqlite:"+fileName);
[*] Statement stmt = conn.createStatement();
[*] ResultSet rs = stmt.executeQuery("SELECT k_address 考试地点,count(k_address) 考场容量 from anpai group by k_address");
[*] SQLitetoXLS sqlite=new SQLitetoXLS();
[*] sqlite.rstoXls(rs,"ok");
[*] conn.close();
[*]
[*] }
[*] catch (Exception e) {
[*] System.out.println(e.getMessage());
[*] System.out.println(e.toString());
[*] }
[*]
[*] }
[*]
[*]}
页:
[1]