?? databean.java~3~
字號:
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 com.hygj.sunqi.serverlet.bean.CreateHtml;import org.apache.log4j.Logger;import java.sql.*;import java.util.*;import java.io.*;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() { cah = new CreateHtml(); cah.createAHtml(); } 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); }}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -