随机生成数据注入excel的xls、xlsx表格。数据导入oracle，输出oracle的数据，分表，打包。

梦里梦外; 2024-03-26 22:47 3阅读 0赞

## 代码以及详细代码讲解文档：[代码以及代码详细解释![icon-default.png?t=N7T8][icon-default.png_t_N7T8]https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/520f8ffa86214616ac0e9ff6b31c1287.png][icon-default.png_t_N7T8_icon-default.png_t_N7T8_https_pan.baidu.com_s_1flNFzYK2MuRmz2GOFxvUAQ_pwd_1234] ##

### 这个代码实现主要功能： ###

##### 1.随机生成100条数据存入到excel表格（可以选xls和xlsx） #####

##### 2.把生成数据在上传到oracle数据库 #####

##### 3.遍历展示Oracle数据库信息 #####

##### 4.把数据库的100条数据输出分20条数据输出到一个excel表格（正好分成5个表） #####

##### 5.把这几个分表打包成zip包 #####

## 前期准备 ##

### 1.创建java项目 ###

![962c04dad7e343bcb87c6a8c2021fd3b.png][]

### 2.创建lib文件夹、导包 ###

[需要导入jar包![icon-default.png?t=N7T8][icon-default.png_t_N7T8]https://pan.baidu.com/s/1hxomPBKpELF1E\_aNtAQtuw?pwd=1234][jar_icon-default.png_t_N7T8_icon-default.png_t_N7T8_https_pan.baidu.com_s_1hxomPBKpELF1E_aNtAQtuw_pwd_1234]

![b2eca4aa10894ce88aca4827d16fb348.png][]

###  ###

右击你要添加的jar包，build path -> add to build path

![7f05699f930b401fb176762172c7063e.png][]![13335613dd7a495bb88f9730b6a687d9.png][]

### 3.链接oracle数据库 ###

### 4.写我文件中的代码 ###

## 最终测试： ##

**主体：**![064e2478286d42cd892c97f97c09ca91.png][]![1e37876714214963a7feabea951ccb94.png][]

![29f4b49e007443f08427e2f7b834c6cb.png][]

![9160ff53c80946648ad977903cb61a9c.png][]

![b739879588384265ae7c623a37b4d610.png][]

![094b34e66f5a42b7922ecd5312f477bb.png][]

[icon-default.png_t_N7T8]: https://csdnimg.cn/release/blog_editor_html/release2.3.6/ckeditor/plugins/CsdnLink/icons/icon-default.png?t=N7T8
[icon-default.png_t_N7T8_icon-default.png_t_N7T8_https_pan.baidu.com_s_1flNFzYK2MuRmz2GOFxvUAQ_pwd_1234]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/520f8ffa86214616ac0e9ff6b31c1287.png
[962c04dad7e343bcb87c6a8c2021fd3b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/836517c8fdb948ca9de66e11ac6c1c3a.png
[jar_icon-default.png_t_N7T8_icon-default.png_t_N7T8_https_pan.baidu.com_s_1hxomPBKpELF1E_aNtAQtuw_pwd_1234]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/8f8007c273d241c898ae0bf810f96785.png
[b2eca4aa10894ce88aca4827d16fb348.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/0182d8b71e3d40f5915082b2820f1cd3.png
[7f05699f930b401fb176762172c7063e.png]: https://img-blog.csdnimg.cn/7f05699f930b401fb176762172c7063e.png
[13335613dd7a495bb88f9730b6a687d9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/5e1cf930bef949cf836932c477e35094.png
[064e2478286d42cd892c97f97c09ca91.png]: https://img-blog.csdnimg.cn/064e2478286d42cd892c97f97c09ca91.png
[1e37876714214963a7feabea951ccb94.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/4d5bb372048b4046b22208c716234956.png
[29f4b49e007443f08427e2f7b834c6cb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/a113fbb4dccc4c139881e9d2b354da6f.png
[9160ff53c80946648ad977903cb61a9c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/a448a2a035654f02bca8ab010f71965e.png
[b739879588384265ae7c623a37b4d610.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/d588372b7005405384435047fb10d34b.png
[094b34e66f5a42b7922ecd5312f477bb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/7da626a83c52492494438d321807890c.png