Opgave7

package example;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;

public class DAOSMiniOpg7 {

    public static void main(String[] args) {
        try {
            String timeStamp = new SimpleDateFormat("yyyyMMdd").format(Calendar.getInstance().getTime());
            System.out.println(timeStamp);
            PrintWriter printWriter = new PrintWriter(
                    "C:\\Users\\Allan Birch\\Documents\\SQL Server Management Studio\\Temp/"
                            + timeStamp + ".txt");

            Connection minConnection;
            minConnection = DriverManager.getConnection(
                    "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=MiniProjekt;user=sa;password=@11@nblackisle;");

            Statement stmt = minConnection.createStatement();

            ResultSet res = stmt.executeQuery("select * from Studerende");
            while (res.next()) {
                printWriter.println(res.getString(1) + "    " + res.getString(2));
                printWriter.flush();
            }
            printWriter.close();
            if (res != null)
                res.close();
            if (stmt != null)
                stmt.close();
            if (minConnection != null)
                minConnection.close();
        } catch (Exception e) {
            System.out.println("fejl:  " + e.getMessage());
        }
    }
}