JavaIO操作完成有序编号输出

来源:互联网 发布:正在识别网络 编辑:程序博客网 时间:2024/05/21 09:55

业务要求:打印一串编码例如Aa0001-Aa1000。要求

1:编号从Aa 到Jj 

2:要求每一组字母编号从1-1000 自上而下的输入xls表格:例如

Aa0001

Aa0002

.

.

Aa1000

文件名称为Aa0001到Aa1000.xls

Ab0001

Ab0002

.

.

.

Ab1000

文件名称:为Ab0001到Ab1000.xls


现在要弄到xls表格里 完成如下代码!


其实这是java的io操作。业务逻辑并不复杂。无非是三个循环就能搞定。难在IO文件操作呵呵 怎么做呢附上代码 给大家参考

import java.io.BufferedWriter;import java.io.File;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStreamWriter;/** *  * @author TengSir * */public class GenerateNumbers {public static void main(String[] args) {for (int i = 'A'; i <='J'; i++) {for (int j = 'a'; j <='j'; j++) {StringBuffer  text=new StringBuffer();for (int t = 1; t <=1000; t++) {String message=String.valueOf((char)i)+String.valueOf((char)j);if(t<10){message+="000"+t;}else if(t>=10&&t<100){message+="00"+t;}else if(t>=100&&t<1000){message+="0"+t;}else if(t>1000){message+=t;}else{message+=t;}text.append(message+"\r\n");}File  numbers=new File("d:\\sou\\"+(char)i+""+(char)j+"0到"+(char)i+""+(char)j+"1000"+".xls");FileOutputStream  output=null;BufferedWriter writer=null;try {output=new FileOutputStream(numbers);writer=new BufferedWriter(new OutputStreamWriter(output));} catch (FileNotFoundException e) {e.printStackTrace();}try {writer.write(text.toString());} catch (IOException e) {e.printStackTrace();}try {writer.close();} catch (IOException e) {e.printStackTrace();}}}}}