开发Spring MVC应用程序(4-2)

l         最后创建TestProductManagerDaoJdbc类对DAO进行单元测试

package tests;

import java.util.List;

import junit.framework.TestCase;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import db.ProductManagerDaoJdbc;

import bus.Product;

public class TestProductManagerDaoJdbc extends TestCase {

    private ProductManagerDaoJdbc pmdao;

    public void setUp() {

        pmdao = new ProductManagerDaoJdbc();

        DriverManagerDataSource ds = new DriverManagerDataSource();

        ds.setDriverClassName("com.mysql.jdbc.Driver");

        ds.setUrl("jdbc:mysql://localhost/test");

        ds.setUsername("test");

        ds.setPassword("test");

        pmdao.setDataSource(ds);

    }

    public void testGetProductList() {

        List l = pmdao.getProductList();

        Product p1 = (Product) l.get(0);

        assertEquals("Lamp", p1.getDescription());

        Product p2 = (Product) l.get(1);

        assertEquals("Table", p2.getDescription());

    }

    public void testIncreasePrice() {

        List l1 = pmdao.getProductList();

        Product p1 = (Product) l1.get(0);

        assertEquals(new Double("5.78"), p1.getPrice());

        pmdao.increasePrice(p1, 10);

        List l2 = pmdao.getProductList();

        Product p2 = (Product) l2.get(0);

        assertEquals(new Double("6.36"), p2.getPrice());

    }

}

l         在setUp()方法中创建DataSource用于测试

（25）修改Web应用程序来使用数据库持久

l         我们只需要修改业务类ProductManager来使用数据库持久，而不需要修改视图和控制器部分的代码

package bus;

import java.io.Serializable;

import java.util.ListIterator;

import java.util.List;

import db.ProductManagerDao;

public class ProductManager implements Serializable {

    private ProductManagerDao pmd;

    private List products;

    public void setProductManagerDao(ProductManagerDao pmd) {

        this.pmd = pmd;

    }

/*

    public void setProducts(List p) {

        products = p;

    }

*/

    public List getProducts() {

        products = pmd.getProductList();

        return products;

    }

    public void increasePrice(int pct) {

        ListIterator li = products.listIterator();

        while (li.hasNext()) {

            Product p = (Product) li.next();

/*

            double newPrice = p.getPrice().doubleValue() * (100 + pct)/100;

            p.setPrice(new Double(newPrice));

*/            

            pmd.increasePrice(p, pct);

        }

    }

}

l         这里需要一个ProductManagerDao接口的引用和它的setter方法，该引用会在Bean配置中设置

l         这样，在ProductManager类中，使用DAO的方法来实现数据库持久