// Plain_MSSQL.java - example connection to a Microsoft SQL Server

import java.io.*;
import java.sql.*;

public class Plain_MSSQL {
 
    public static void main (String[] args) {

        System.out.println( "Films Example in Plain Java, MSSQL version\n" );

        try {
 	    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException e) {
            System.err.println( "Driver not found: " + e + "\n" + e.getMessage() );
        }

        try {
	    Connection conn = DriverManager.getConnection (
	    	"jdbc:microsoft:sqlserver://db-ms.doc.ic.ac.uk:1433",
		"lab", "lab" );

            Statement stmt = conn.createStatement();
            ResultSet rs;

            rs = stmt.executeQuery("SELECT * FROM films");
            while ( rs.next() ) {
                String title = rs.getString("title");
                String director = rs.getString("director");
                String origin = rs.getString("origin");
                String made = rs.getString("made");
                String length = rs.getString("length");
                System.out.println(title+","+director+","+origin+","+
			made+","+length );
            }

            conn.close();
        } catch (Exception e) {
            System.err.println("Exception: " + e + "\n" + e.getMessage() );
        }
        
    }

}