io流简单读写文件-获取sql表名

package com.kedia.io;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileReader;
import java.io.FileWriter;


public class IOTest {

	/**
	 * @param args
	 * @throws Exception 
	 */
	public static void main(String[] args) throws Exception {
		FileReader fileReader = 
				new FileReader("C:/Users/Administrator/Desktop/20170217.sql");  
	    BufferedReader reader = new BufferedReader(fileReader); 
	    int x = 0;
	    String line = null;  
	    while ((line = reader.readLine()) != null) { 
	    	if(line.contains("CREATE TABLE")){
	    		x = x + 1;
	    		writerTableName(line);
	    	}
	    }  
	    System.out.println(x);
	    reader.close();  
	}
	
	public static void writerTableName(String line) throws Exception{
		FileWriter fileWriter = 
				new FileWriter("C:/Users/Administrator/Desktop/20170217.txt",true);
		BufferedWriter writer = new BufferedWriter(fileWriter);
		writer.write(line);
		writer.newLine();
		writer.flush();
		writer.close();
	}

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值