怎样用table标签从数据库里面取值并在页面一条条显
小鸭无罪 2014-09-18 02:52:42 <%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="java.util.ArrayList"%>
<%@ page import="java.util.List"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>提取数据</title>
</head>
<body>
<table><tr><th>数据库中的数据</th></tr>
<%
String username = "test";
String password = "test123";
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
// String driverClassName = "com.sybase.jdbc2.jdbc.SybDriver";
String url = "jdbc:sybase:Tds:192.168.0.71:5000/testoa?charset=cp936";
Connection connection = DriverManager.getConnection(url,username,password);
Statement statement = (Statement)connection.createStatement();//实例化一个sql语句
ResultSet rs = statement.executeQuery(" SELECT* FROM T_LOGIN");
List<String> lists = new ArrayList<String>();
while (rs.next()) {
lists.add(rs.next()); //这行报错。。。
}
rs.close();
statement.close();
connection.close();
for (String s : lists) {
%>
<tr><td><%=s%></td></tr>
<% }
%>
</table>
</body>
</html>