ctrl

package DB2Package;

import java.sql.*;
import java.util.*;
import javax.swing.table.DefaultTableModel;

public class Controller {

    DAL dal = new DAL();

    //----------------- Skapa -------------------------//

    public Student createStudent(String pnr, String sname, String saddress){
        return dal.createStudent(pnr, sname, saddress);
    }
    public Course createCourse(String ccode, String cname, String caddress){
        return dal.createCourse(ccode, cname, caddress);
    }

    //----------------- Söka -------------------------//


      public Student findStudentByPnr(String pnr){
            return dal.findStudentByPnr(pnr);
        }
      public Course findCourseByccode(String ccode){
            return dal.findCourseByccode(ccode);
        }
      public Studied getCourseResults(String ccode){
            return dal.getCourseResults(ccode);
        }
      public Studied getStudentResult(String pnr, String ccode){
            return dal.getStudentResult(pnr, ccode);
        }
      public Student findAllStudentsByPnr(String pnr){
            return dal.findAllStudentsByPnr(pnr);
        }
      public Course findAllCourseBycCode(String ccode){
            return dal.findAllCourseByccode(ccode);
        }

    //----------------- Registrera -------------------------//

      public Student addStudentToStudied(String pnr, String ccode, String grade){
            return dal.addStudentToStudied(pnr, ccode, grade);
        }
      public Student addStudentToStudies(String pnr, String ccode){
            return dal.addStudentToStudies(pnr, ccode);
        }
}