<%@ page contenttype="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%
string mysqldriver = "org.gjt.mm.mysql.driver";
string url = "jdbc:mysql://localhost/hq";//数据库连接
 connection conn;
 class.forname(mysqldriver);
 conn = drivermanager.getconnection( url,"root","");//用户名与密码
 if(conn==null){
system.out.println("get conn error");
}
statement stmt=conn.createstatement();
resultset rs=null;
rs=stmt.executequery("select * from news_art");
while(rs.next())
{//循环显示记录
%>
<a href='display.jsp?id=<%=rs.getstring("id")%>' target=_blank><%=rs.getstring("title")%></a>(<%=rs.getstring("times")%>)
<%="<br>"%>
<%
}
rs.close();
stmt.close();
conn.close();
%>