<%@ 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(); %>
|