我用以下方法返回数据库信息,但不知如何在JSP页面中使用,把所有记录显示在JSP页面上。清指教,谢!!!
public static ArrayList excuteQuery(String SQLClause) throws SQLException {
Connection connection = DBConnectionManager.getConnection();
Statement statement = connection.createStatement();
ArrayList arrayList = new ArrayList();
SQLException exception = null;
ResultSet resultSet = null; try {
resultSet = statement.executeQuery(SQLClause);
ResultSetMetaData metaData = resultSet.getMetaData();
int columnCount = metaData.getColumnCount(); while (resultSet.next()) {
Hashtable dataTable = new Hashtable();
for (int i = 1; i <= columnCount; i++) {
Object columnData = resultSet.getObject(i);
if (!(columnData == null))
dataTable.put(metaData.getColumnName(i), columnData);
}
arrayList.add(dataTable);
}
} catch (SQLException e) {
exception = e;
} finally {
if (resultSet != null)
resultSet.close();
statement.close();
connection.close();
if (exception != null)
throw exception;
}
return arrayList;
}
public static ArrayList excuteQuery(String SQLClause) throws SQLException {
Connection connection = DBConnectionManager.getConnection();
Statement statement = connection.createStatement();
ArrayList arrayList = new ArrayList();
SQLException exception = null;
ResultSet resultSet = null; try {
resultSet = statement.executeQuery(SQLClause);
ResultSetMetaData metaData = resultSet.getMetaData();
int columnCount = metaData.getColumnCount(); while (resultSet.next()) {
Hashtable dataTable = new Hashtable();
for (int i = 1; i <= columnCount; i++) {
Object columnData = resultSet.getObject(i);
if (!(columnData == null))
dataTable.put(metaData.getColumnName(i), columnData);
}
arrayList.add(dataTable);
}
} catch (SQLException e) {
exception = e;
} finally {
if (resultSet != null)
resultSet.close();
statement.close();
connection.close();
if (exception != null)
throw exception;
}
return arrayList;
}
解决方案 »
- 请教Uploadbean上传的问题
- 关于JSP显示EXCEL的问题
- jsp连接access数据库发生错误?
- 请教:mysql中的bigint在jsp程序中如何表示或者转换?
- 急!求救提交数据库时的中文问题……
- 大家有什么好的jsp开发工具
- 从servlet返回jsp为何不能显示jsp链接的图片?
- 有什么著名的软件是用JAVA编的?
- JSP还是ASP+
- 上传文件到服务器遇到的问难题题,本地和测试环境都能上传,到了线上就出问题了。有人遇到过吗
- 我用一个serversocket抓浏览器发过来的包,请求头里面为何没有charset的说明?那我怎么知道内容是怎么编码的?
- 急!jsp写入二进制文件提示如下问题,大家帮忙!在线等!
if (list !=null){
for (int i=0; i<list.size(); i++){
HashTable has = (HashTable)list.get(i); //一条记录
Enumeration enu = has.keys(); //所有字段的名称
if (enu.hasMoreElements()){
String key = (String)enu.nextElements();
Object obj = has.get(key); //记录中的一个字段的值
}
}
}