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 java.sql.*;
import java.util.*;

import org.apache.log4j.*;
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://localhost:1433;DatabaseName=NorthWind";
  private CreateHtml cah = null;
  public DataBean() {

  }
  public ArrayList getArr(){
    conn();
    return data;
  }
  private void conn(){
    try{

      Class.forName(classForName);
      conn = DriverManager.getConnection(url,"sa","qaz123");
      stmt = conn.createStatement();
      String sql = "SELECT ProductID,ProductName,UnitPrice FROM Products";
      rs = stmt.executeQuery(sql);
      while(rs.next()){
        row = new ArrayList();
        row.add(rs.getString("ProductID"));
        row.add(rs.getString("ProductName"));
        row.add(new Float(rs.getFloat("UnitPrice")));
        data.add(row);
      }
      rs.close();
      stmt.close();
      conn.close();
    }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);
//  }

}