testemploydao.java~9~

数据库应用程序.它比较全面的含盖了JAVA应用程序与数据库之间通讯的全过程.本程序在JBUILDER2005上开发运行.

package chapter25.db;
import junit.framework.*;
import fixture.*;
import java.sql.*;
public class TestEmployDAO extends TestCase {
    private EmployDAO employDAO = null;
    HrJdbcFixture hrJdbcFixture;
    protected void setUp() throws Exception {
        super.setUp();
        hrJdbcFixture = new HrJdbcFixture(this);
        hrJdbcFixture.setUp();
        employDAO = new EmployDAO(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);
    }
}