利用JDBC连接取数据并导入到EXCEL中

最新推荐文章于 2022-05-20 09:46:19 发布

smvcn

最新推荐文章于 2022-05-20 09:46:19 发布

阅读量1.1k

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/smvcn/article/details/8677156

版权

JAVA 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

public void run(){
        String sql = "select * from SFA_CUST_WZ";
        try{
            FileOutputStream fos = new FileOutputStream("d:\\foo.xls");  
            HSSFWorkbook wb = new HSSFWorkbook();  
            HSSFSheet s = wb.createSheet();  
            wb.setSheetName(0, "Matrix");  
            
            _pstmt = _conn.getConn().prepareStatement(sql);
            //取结果集
            ResultSet _rs = _pstmt.executeQuery();
            //取数据结构
            ResultSetMetaData _rsm =  _rs.getMetaData();
            //取表字段总数
            int i = _rsm.getColumnCount();
            //获取字段集合
            String [] columnName = new String[i];
            int j = 0;
            for (int ri = 1; ri <= i; ri ++,j++) {
                columnName[j] = _rsm.getColumnName(ri);
            }
            //取值并写入xls
            int k = 0;
            while(_rs.next()){
                HSSFRow row = s.createRow(k); 
                for (j = 0; j < i; j++ ) {
                    HSSFCell cell = row.createCell(j); 
                    cell.setCellValue(_rs.getString(columnName[j]));  
                }
                k++;
            }
            wb.write(fos);  
            fos.close(); 
            _rs.close();
        }catch(Exception e){e.printStackTrace();}
    }