J250913/jdbc-advance-demo/src/com/sf/test/EmpTest.java

package com.sf.test;

import com.sf.dao.EmpDAO;
import com.sf.dao.impl.EmpDAOImpl;
import com.sf.domain.Emp;
import org.junit.Test;

import java.util.List;

public class EmpTest {
    @Test
    public void test(){
        EmpDAO empDAO = new EmpDAOImpl();
        List<Emp> emps = empDAO.queryEmpsByMaxAndMin(1400.0, 800.0);
        for (Emp emp : emps) {
            System.out.println(emp);
        }
    }

    @Test
    public void test1(){
        EmpDAO empDAO = new EmpDAOImpl();
        for (Emp emp : empDAO.selectList()) {
            System.out.println(emp);
        }
    }

    @Test
    public void test2(){
        EmpDAO empDAO = new EmpDAOImpl();
        List<Emp> emps = empDAO.queryEmpsByKey("A", 1, 3);
        for (Emp emp : emps) {
            System.out.println(emp);
        }
    }
}