一个jsp连接mysql的简单例子-JSP教程,Jsp/Servlet

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

%>