创建firstmysql.jsp,代码如下
<%@ page language="java"import="java.util.*" pageEncoding="GB18030"%>
<%@page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>JSP读取数据库</title>
</head>
<body>
<table border="1">
<tr>
<th>书号</th>
<th>书名</th>
<th>作者</th>
<th>出版社</th>
</tr>
<%
String driverClass="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/simple";//之前数据库名simple
String user="root";//MySQ帐号
String password="root";//MYSQL密码
Connection conn;
try {
Class.forName(driverClass).newInstance();
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="SELECT * FROM book";//表名book
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%=rs.getString("bookid")%></td>
<td><%=rs.getString("bookname")%></td>
<td><%=rs.getString("writer")%></td>
<td><%=rs.getString("publish")%></td>
</tr>
<%
}
}catch(Exception ex){
ex.printStackTrace();
}
%>
</body>
</html>
将firstmysql.jsp复制到D:\jspweb目录下,运行tomcat6,打开浏览器,输入http://127.0.0.1:8080/web/firstmysql.jsp
显示如下
最后附一段参考代码:
<%@ pagecontentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from first";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
把用户名和密码换乘你自己的