一、模糊查询
<%
//jdbc连接Oracle查询所有的主题:tid tname
String CNAME="oracle.jdbc.driver.OracleDriver";
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
//加载驱动
Class.forName(CNAME);
//创建连接
Connection con=DriverManager.getConnection(URL, "scott", "tiger");
//定义sql语句
String sql="select * from topic280 order by tid";//tid tname
//获得执行对象
PreparedStatement ps=con.prepareStatement(sql);
//获得结果集
ResultSet rs=ps.executeQuery();
//循环遍历
while(rs.next()){
%>
<a href='index.jsp?tid=<%=rs.getInt(1)%>'><b> <%=rs.getString(2) %> </b></a>
<%
}
%>
<a href="index.jsp"><b>全部</b></a>
</li>
</ul>
<ul class="classlist">
<%
//接收tid
String tid=request.getParameter("tid");
//查询编号、标题、发表时间
sql="select nid,ntitle,naddtime from news280";
if(tid!=null){//说明点击了主题名称
sql+=" where tid="+tid;
}
//out.print(sql);
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
%>
<li><a href='/s4/news/read.jsp?nid=<%=rs.getInt(1)%>'><%=rs.getString(2) %></a><span><%=rs.getString(3) %></span></li>
<%
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
二、评论
<