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 SelectUsers {
	public static void run(String path) {
		try {
			Connection conn = JdbcUtils.getConnection();
			conn.setAutoCommit(false);
			Statement stmt = conn.createStatement();
			String sql1 = "select * from users";
			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.getString(6) + "," + rs.getString(7) + "," + rs.getInt(8) + ","
							+ rs.getTimestamp(9);
					p1.println(sb);
				}
				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) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}