package webchurch.cms.dao;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import webchurch.push.util.Connector2;

public class FileTest {
	public static void main(String[] args) {
		try {
			Connection con = null;
			PreparedStatement pstmt = null;
			con = Connector2.getConnection();
			String query = "select top 1 * from cms_file where hoiwonno = '02283' order by createday desc";
			ResultSet rs = null;
			pstmt = con.prepareStatement(query);
			rs = pstmt.executeQuery();
			rs.next();
			InputStream is2 = rs.getBinaryStream("IMAGE_FILE");
			//File file = new File("d:/copy.png");
			//FileOutputStream fos = new FileOutputStream(file);
			//int b = 0;
			//while((b = is2.read()) != -1){
			//	fos.write(b);
			//}
			
			//FileReader fr = new FileReader(file);
			InputStreamReader fir = new InputStreamReader(is2,"euc-kr");
			BufferedReader br = new BufferedReader(fir);
			String cont3 = "";
			int length3 = 0;
			while((cont3 = br.readLine()) != null){
				System.out.println(cont3);
				length3 = length3 + cont3.length();
			}
			System.out.println(length3);
			/*InputStreamReader isr2 = new InputStreamReader(is2, "euc-kr");
			BufferedReader br2 = new BufferedReader(isr2);
			String cont2 = "";
			int length2 = 0;
			while((cont2 = br2.readLine())!= null){
				length2 += cont2.length();
				
			}
			System.out.println("DB Files - " + length2);
			
			File file = new File("D:/CONF/kihasung02283.jpg");
			FileInputStream fis = new FileInputStream(file);
			FileReader fr = new FileReader(file);
			InputStream in = new FileInputStream(file);
			InputStreamReader isr = new InputStreamReader(in);
			//InputStreamReader isr = new InputStreamReader(in);
			BufferedReader br = new BufferedReader(isr);
			String cont = "";
			int length = 0 ;
			while ((cont = br.readLine()) != null) {
				//System.out.println(cont);
				length += cont.length();
			}
			System.out.println("File size : " + file.length());
			System.out.println("String length : " + file.length());*/
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}