customerbusiness.java

来自「同样是简单的JAVA程序,适合初学者,大家来看看吧!」· Java 代码 · 共 45 行

package customer;
import java.io.Serializable;
import java.util.*;
import java.sql.*;
public class CustomerBusiness implements Serializable
{
	public List getAllEmp()
	{
		
		String sql="select * from Customers";
		
		List empList=new ArrayList();
		
		try
		{
			  
			  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			  Connection cn=DriverManager.getConnection("jdbc:odbc:xueqiang");
			  PreparedStatement ps=cn.prepareStatement(sql);
			  
			  ResultSet rs=ps.executeQuery();
			  while(rs.next())
			  {
				   CustomerValue ev=new CustomerValue();
				   ev.setId(rs.getString("CustomerID"));
				   ev.setName(rs.getString("CompanyName"));
				   ev.setCname(rs.getString("ContactName"));
				   empList.add(ev);
				   
				   
				   
			  }
			  
		}
		catch(Exception e)
		{
			
		}
		
		return empList;
		
		
	}
}