testemploydao.java~11~

来自「数据库应用程序.它比较全面的含盖了JAVA应用程序与数据库之间通讯的全过程.本程」· JAVA~11~ 代码 · 共 30 行

package chapter25.db;
import junit.framework.*;
import fixture.*;
import java.sql.*;
public class TestEmployDAO extends TestCase {
    private EmployeeDAO employDAO = null;
    HrJdbcFixture hrJdbcFixture;
    protected void setUp() throws Exception {
        super.setUp();
        hrJdbcFixture = new HrJdbcFixture(this);
        hrJdbcFixture.setUp();
        employDAO = new EmployeeDAO(hrJdbcFixture.getConnection());
        hrJdbcFixture.runSqlFile("D:/JTJB2005/chapter25/db/insert.sql",true);
    }

    protected void tearDown() throws Exception {
        employDAO = null;
        hrJdbcFixture.tearDown();
        hrJdbcFixture = null;
        super.tearDown();
    }

    public void testFindById() throws SQLException {
       Employee expectEmp = new Employee("0004","大山",23);
       Employee realEmp = employDAO.findById("0004");
       assertNotNull(realEmp);
       assertEquals(expectEmp,realEmp);
    }
}