package com.jiang.Util;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

/**
 * @author Administrator
 * 用来生成测试数据
 */
public class CreateSql {
	public static void main(String[] args) {
		FileOutputStream fos = null;
		try {
			fos = new FileOutputStream(new File("auto.sql"));
			for (int i = 0; i < 10000; i++) {
				// insert into pagetest values(1,'11',22,'33','44');
				String sql = "insert into pagetest values(" + i + ",'" + i
						+ "'," + i + ",'" + i + "','" + i + "');\n";
				fos.write(sql.getBytes());
				System.out.print(sql);
			}
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		} finally {
			if(fos!=null){
				try {
					fos.close();
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}
}