java项目：进销存管理系统_获取所有商品信息的

获取所有商品信息的getSpInfos()方法
该方法主要用于获取数据库中的所有商品信息，并通过findForList()方法将所有商品信息封装到List集合对象中，而findForList()方法又是通过调用findForResultSet()方法获取数据的。这3个方法的关键代码如下：
src\com\lzw\dao\Dao.java类关键代码：
// 获取所有商品信息
public static List getSpInfos() {
List list = findForList("select * from tb_spinfo");
return list;
}
public static List findForList(String sql) {
List<List> list = new ArrayList<List>();
ResultSet rs = findForResultSet(sql);
try {
ResultSetMetaData metaData = rs.getMetaData();
int colCount = metaData.getColumnCount();
while (rs.next()) {
List<String> row = new ArrayList<String>();
for (int i = 1; i <= colCount; i++) {
String str = rs.getString(i);
if (str != null && !str.isEmpty())
str = str.trim();
row.add(str);
}
list.add(row);
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
public static ResultSet findForResultSet(String sql) {
if (conn == null)
return null;
long time = System.currentTimeMillis();
ResultSet rs = null;
try {
Statement stmt = null;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
second = ((System.currentTimeMillis() - time) / 1000d) + "";
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
src\com\lzw\dao\Dao.java类完整代码：
package com.lzw.dao;
import internalFrame.guanli.Item;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import model.TbGysinfo;
import model.TbKhinfo;
import model.TbKucun;
import model.TbRkthDetail;
import model.TbRkthMain;
import model.TbRukuDetail;
import model.TbRukuMain;
import model.TbSellDetail;
import model.TbSellMain;
import model.TbSpinfo;
import model.TbXsthDetail;
import model.TbXsthMain;
import model.TbUserlist;
public class Dao {
protected static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
protected static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;"
+ "DatabaseName=db_JXC;SelectMethod=Cursor";
protected static String dbUser = "sa";
protected static String dbPwd = "";
protected static String second = null;
public static Connection conn = null;
static {
try {
if (conn == null) {
Class.forName(dbClassName).newInstance();
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
}
} catch (Exception ee) {
ee.printStackTrace();
}
}
private Dao() {
}
// 读取所有客户信息
public static List getKhInfos() {
List list = findForList("select id,khname from tb_khinfo");
return list;
}
// 读取所有供应商信息
public static List getGysInfos() {
List list = findForList("select id,name from tb_gysinfo");
return list;
}
// 读取客户信息
public static TbKhinfo getKhInfo(Item item) {
String where = "khname='" + item.getName() + "'";
if (item.getId() != null)
where = "id='" + item.getId() + "'";
TbKhinfo info = new TbKhinfo();