一個jsp串連mysql的簡單例子

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