JAVA从sqlserver2012数据库读数据并写出到Excel文件里

最新推荐文章于 2022-07-27 11:01:41 发布

Keep Slient,

最新推荐文章于 2022-07-27 11:01:41 发布

阅读量768

点赞数 2

文章标签： java excel 数据库 sqlserver

本文链接：https://blog.csdn.net/qq_33303925/article/details/51327459

版权

import java.io.*;
import java.sql.*;
import jxl.Workbook;
import jxl.write.*;

public class Excel {
    public Excel() throws Exception
    {
        WritableWorkbook writeBook = Workbook.createWorkbook(new File("./write.xls"));   //创建名为write的excel表格 在当前目录下
        WritableSheet firstSheet = writeBook.createSheet("logon_users_info", 1);         // 表名称，页数
        Class.forName(DB_link_Info.driverName);                                          //数据库链接
        Connection con=DriverManager.getConnection(DB_link_Info.dbURL,DB_link_Info.userName,DB_link_Info.userPwd);
        Statement sta=con.createStatement();
        ResultSet rs=sta.executeQuery("select * from logon_users_info ");                //将logon_users_info整张表写入write文件中
        int count = rs.getMetaData().getColumnCount();                                   //获得数据库中logon_users_info表的列数
        for(int j=0;j<count;j++){                                                        //将表logon_users_info的属性输出到excel表第一行
			jxl.write.Label label = new jxl.write.Label( j,0,rs.getMetaData().getColumnName(j+1)); 
    		firstSheet.addCell(label);  
        }
        int i = 1;
        while(rs.next()){                                                                 //遍历数据库中的表logon_users_info并写入excel
        	for(int j=0;j<count;j++){  			
        			jxl.write.Label label = new jxl.write.Label( j,i,rs.getString(j+1)); 
            		firstSheet.addCell(label);   		
        	}
        	i++;
        }
		rs.close();                                                                       
		sta.close();
        writeBook.write();
        writeBook.close();
    }
    public static void main(String[] args) throws Exception {
        new Excel();
    }

}

数据库为SQLServer2012