jsp文档怎么读取2次以上数据库中的文本

来源:百度知道 编辑:UC知道 时间:2024/05/24 17:01:03
<td width="382" height="28" class="navText >
<%String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:com";
Class.forName(sDBDriver);
Connection con = DriverManager.getConnection(sConnStr);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from news where news_no=1";
ResultSet rs=null;
int i=1;//i用来计数几条内容
String book_page;
try{
rs=stmt.executeQuery(sql);

while(rs.next())
{//此处可把书的简介页面地址作为一个数据库字段读入href
book_page=rs.getString("news_no");
out.print("<a href="+book_page+">"+rs.getString("news_text")+"</a><br>");
i++;
if(i>1) break;
}

}finally{
rs.close();
stmt.close();
con.close();
}

%></td>

<td width="382" height="28" class="navText >
<%String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:com";
Class.forName(sDBDriver);
Connection con = DriverManager.getConnection(sConnStr);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from news where news_no=1";
ResultSet rs=null;
int i=1;//i用来计数几条内容
String book_page;

rs=stmt.executeQuery(sql);

while(rs.next())
{//此处可把书的简介页面地址作为一个数据库字段读入href
book_page=rs.getString("news_no");
out.print("<a href="+book_page+">"+rs.getString("news_text")+"</a><br>");
i++;
if(i>1) break;
}

%></td>

<td width="382" height="28" class="navText &g