package testjdbc;


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

public class sql_con {


    public static void main(String[] args) {

    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'" ;
        ResultSet rs =null;
         try (
                Connection con = DriverManager.getConnection(url,user,pass);
            PreparedStatement ps =con.prepareStatement(query);
                )
         {
         rs =ps.executeQuery();
             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 (SQLException e) {
            System.err.println(e);
        }
         }

}