package testjdbc;


import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class sql_con {


    public static void main(String[] args) {

        Connection conn = null;
    String url = "jdbc:sqlserver://localhost:1433;databaseName=AbsentNotev2";
    String user = "sa";
    String pass = "123456";

String query="select s.S_ID,s.SName,s.SPW,s.SMobileNumber,s.SEmail,scj.StartNumber,c.CName from Student s \n" +
"join StudentClassJoin scj \n" +
"on s.S_ID = scj.S_ID\n" +
"join StartClass sc\n" +
"on scj.StartNumber = sc.StartNumber\n" +
"join class c\n" +
"on sc.CNumber =c.CNumber\n" +
"where s.S_ID = 'A123456789'" ;

         try {
                 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                conn = DriverManager.getConnection(url,user,pass);
         if (conn != null && !conn.isClosed())
         {
          Statement stmt = conn.createStatement();
          ResultSet rs = stmt.executeQuery(query);
          while(rs.next()){
            String name , cname, snumber,sid;
            name = rs.getString(1);
            cname=rs.getString(2);
            snumber=rs.getString(3);
            sid=rs.getString(4);
               System.out.println(name +"  "+cname+"  "+snumber+"  "+sid);
               }
         }
         } catch (ClassNotFoundException e) {
             e.printStackTrace();
         } catch (SQLException e) {
             e.printStackTrace();
         }
         }
    }