DB2

package DB2Package;

import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DB2Connection {

    public static void main(String[] args) throws SQLException {
        try{
    DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
        } catch(Exception e) {System.out.println("Kan inte hitta database driver class: " + e);}
        try {
            Connection con =
                    DriverManager.getConnection
                    ("jdbc:sqlserver://localhost:1433;" + "databaseName=DBprojekt;user=sa;password=1234;");
            Statement stmt = con.createStatement( );
            String SQL = "SELECT * FROM Student";
            ResultSet rs = stmt.executeQuery( SQL );

            while (rs.next()){
                String pnr_st = rs.getString("spnr");
                String s_name = rs.getString("sname");
                String s_adress = rs.getString("sadress");
                String s_tel = rs.getString("stel");
                System.out.println(pnr_st + " " + s_name + " " + s_adress + " " + s_tel);
//              stmt.close();
            }



            if(con == null)
            System.out.println("No driver found!");
        else System.out.println("Connection Established!");
        } catch(Exception e) { System.out.println("Kan inte hitta database driver class: " + e);}
    }
    }