怎么样才能让数据库中的内容显示在web上 求救

[liuzhx]

如何调用javabeans 从sql sevser2000数据库中把里面的内容显示在网页上！~
package jsj;
import java.sql.*;
public class Ans1

{
public String name;
public String content;
public void select()
{
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=feedback";
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// 加载驱动程序
}
catch (ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
Connection con= DriverManager.getConnection(url, "sa", "sasa");
Statement stmt=con.createStatement();
StringBuffer sql = new StringBuffer();



ResultSet rs=stmt.executeQuery("select * from answer");
while (rs.next())
{
System.out.print(rs.getString(" name content"));
}





stmt.close();
con.close();
}
catch (SQLException e)
{
System.out.println(e.getMessage());
}
}

}



网页上代码怎么写啊！~

[sunshine5246]

你要把你的select函数改为有返回值的,ResultSet,然后通过return rs;来实现,注意,你返回前,不能关闭.在网页中相应的如果你的bean的id为b1的话,你可以通过ResultSet rs =b1.select()来得到.然后从rs中得到相应的内容.

[AreamArgentateOfWing]

如何调用javabeans 从sql sevser2000数据库中把里面的内容显示在网页上！~
package jsj;
import java.sql.*; import java.util.ArrayList;
public class Ans1

{
public String name;
public String content;
public ArrayList select()
{
ArrayList arr = new ArrayList();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=feedback";
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// 加载驱动程序
}
catch (ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
Connection con= DriverManager.getConnection(url, "sa", "sasa");
Statement stmt=con.createStatement();
StringBuffer sql = new StringBuffer();



ResultSet rs=stmt.executeQuery("select * from answer");
while (rs.next())
{
arr.add(rs.getString(" name content")); } }
catch (SQLException e)
{
System.out.println(e.getMessage());
}
finally {
stmt.close();
con.close();
return arr;
}
}

}

页面上用
<%@ page import="jsj.Ans1"%>
<%@ page import="java.util.ArrayList" %>
<%
Ans1 ans1 = new Ans1();
ArrayList arr = ans1.select();
for (int i = 0; i < arr.size(); i++) {
%>
<%=arr.get(i)%>
<%
}
%>

[OnlyFor_love]

把你的写的bean也帖出来啊

[OnlyFor_love]

以下是我的一个例子，你把bean该一下就可以了：
public ArrayList getForum() {
ArrayList al = new ArrayList();
Statement stmt = null;
ResultSet rs = null;
Connection conn = DBConnection.getConnection();
try {
String sql = "select * from t_forum";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
ForumBean fb = new ForumBean();
fb.setId(rs.getString("id"));
fb.setForumname(rs.getString("forumname"));
fb.setCreatedate(rs.getString("createdate"));
fb.setAdministrator(rs.getString("administrator"));
al.add(fb);
}

} catch (SQLException ex) {
ex.printStackTrace();
} finally {
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException ex1) {
ex1.printStackTrace();
}
}
return al;
}

[OnlyFor_love]

在页面中用：
<%
ForumManager fm = new ForumManager();==============》这个是上面这个方法所在的类
ArrayList al = new ArrayList();
al=fm.getForum(); =================》调用getForum（）方法
ForumBean fb = new ForumBean();
for(int i = 0;i<bl.size();i++){
fb = (ForumBean)al.get(i);
%>
<%=fb.getId()%>
<%=fb.getForumname()%>
<%
}
%>

[liuzhx]

谢谢
我现在能够显示出来了
但是数据很多怎么样才能够实现分页呢？

[ipv]

人心不足蛇吞象
看看书
有现成的例子。。

[topil]

网上有很多分页的例子，搜索一下吧