- 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;
- }
- 一般用来显示数据库表里面所有的数据。