package com.hygj.sunqi.serverlet.bean;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2006</p> * <p>Company: </p> * @author not attributable * @version 1.0 */import org.apache.log4j.Logger;import java.sql.*;import java.util.*;public class DataBean {  private static Logger log = Logger.getLogger(DataBean.class);  private ArrayList data = new ArrayList();  private ArrayList row;  private Connection conn = null;  private Statement stmt = null;  private ResultSet rs = null;  private String classForName  = "com.microsoft.jdbc.sqlserver.SQLServerDriver";  private String url = "jdbc:microsoft:sqlserver://hostlocal:1433;DataBaseName = NorthWind";  public DataBean() {  }  public ArrayList getArr(){    conn();    return data;  }  private void conn(){    try{      row = new ArrayList();      Class.forName(classForName);      conn = DriverManager.getConnection(url);      stmt = conn.createStatement();      String sql = "SELECT ProductID,ProductName,UnitPrice FROM Products";      rs = stmt.executeQuery(sql);      while(rs.next()){        row.add(rs.getString("ProductID"));        row.add(rs.getString("ProductName"));        row.add(new Float(rs.getFloat("UnitPrice")));        data.add(row);      }    }catch(Exception e){      log.info(e.getMessage());      //System.out.println(e.getMessage());    }  }  public static void main(String[] args){    DataBean db = new DataBean();    ArrayList line = db.getArr();    System.out.println(line);  }}