prodao.java

使用JSP+Servlet+Ajax的供应商管理系统（不包含数据库部分）

package com.aowin.scm.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.aowin.scm.model.Pro;
import com.aowin.scm.util.DBConnection;

public class ProDAO {

	DBConnection conn = new DBConnection();
	ArrayList al = new ArrayList();
	public ArrayList queryAll()
	{
		String sql = "select ProductCode,UnitName from product";
		ResultSet rs = conn.executeQuery(sql);
		Pro product;
		try {
			while(rs.next())
			{
				product = new Pro();
				product.setProductCode(rs.getString("ProductCode"));
				product.setUnitName(rs.getString("UnitName"));
				al.add(product);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return al;
	}
}