package com.sf._03_jdbc_dao.test;

import com.sf._03_jdbc_dao.dao.StudentDAO;
import com.sf._03_jdbc_dao.dao.impl.StudentDAOImpl;
import com.sf._03_jdbc_dao.domain.Student;
import org.junit.Test;

public class StudentJDBCTest {


    @Test
    public void test(){
        System.out.println("注册");
        // 插入一个学生
        Student s= new Student(null,"zhangsan",10,"123@qq.com");
        StudentDAO studentDAO = new StudentDAOImpl();
        studentDAO.save(s);
        System.out.println("注册后逻辑");
    }


    @Test
    public void test1(){
        System.out.println("批量处理");
        // 插入一个学生
        Student s= new Student(null,"zhangsan123",20,"123@qq.com");
        StudentDAO studentDAO = new StudentDAOImpl();
        studentDAO.save(s);
        System.out.println("批量处理后逻辑");
    }


    @Test
    public void test2(){
        Student student = new Student(5L,"fanjialong123",20,"234@qq.com");
        StudentDAO studentDAO = new StudentDAOImpl();
        studentDAO.update(student);
    }

    @Test
    public void test3(){
        StudentDAO studentDAO = new StudentDAOImpl();
        studentDAO.delete(5L);
    }

    @Test
    public void test4(){
        StudentDAO studentDAO = new StudentDAOImpl();
        System.out.println(studentDAO.get(6L));
    }


    @Test
    public void test5(){
        StudentDAO studentDAO = new StudentDAOImpl();
        for (Student student : studentDAO.list()) {
            System.out.println(student);
        }
    }
}