package com.duplicall.export.dao;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.duplicall.export.util.JdbcUtils;

public class SelectTarget {

	public static void run(String path) {
		try {
			Connection conn = JdbcUtils.getConnection();
			conn.setAutoCommit(false);
			Statement stmt = conn.createStatement();
			String sql1 = "select * from target";
			ResultSet rs = stmt.executeQuery(sql1);
			FileOutputStream fos1 = null;
			try {
				
				fos1 = new FileOutputStream(path, true);
				
			} catch (FileNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				
				PrintStream p1 = new PrintStream(fos1);

				while (rs.next()) {
					String sb = rs.getInt(1) + "," + rs.getString(2) + "," + rs.getString(3) + "," + rs.getString(4) + ","
							+ rs.getInt(5) + rs.getInt(6) + "," + rs.getString(7) + "," + rs.getInt(8) + ","
							+ rs.getInt(9)+","+rs.getString(10);
					p1.println(sb);
				}
//				fos1.close();
				p1.close();
				
				try {
					if(fos1!=null){
						System.out.println("------ceshi");
					fos1.close();
					}
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

//	public static void main(String[] args) {
//		run();
//	}

	

}