1、首先在MySQL数据库中建立books数据库，再建book表。
然后插入数据。SQL语言如下：
create database books;
use books;
create table book(bookId varchar(50),bookName varchar(50),publisher varchar(100),price float,constraint pk_book primary key(bookId))
insert into book values('1001','An inconvenient truth','电子工业出版社',45.00);
insert into book values('1002','The satanic gases','电子工业出版社',49.00);
insert into book values('1003','Global climate change and wildlife','电子工业出版社',59.00);
insert into book values('1004','Environmental resource handbook','电子工业出版社',59.00);
insert into book values('1005','American heritage science dictionary','电子工业出版社',56.00);
2.新建sql.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<html>
<body>
以下是从MySQL数据库读取的数据：<hr>
<table border=0>
<tr><td>ID</td><td>书名</td><td>出版社</td><td>价格</td></tr>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://192.168.1.8/books?
useUnicode=true&characterEncoding=GBK","root","1234");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from book");
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("bookId")+"</td>");
out.println("<td>"+rst.getString("bookName")+"</td>");
out.println("<td>"+rst.getString("publisher")+"</td>");
out.println("<td>"+rst.getFloat("price")+"</td>");
out.println("</tr>");
}
//关闭连接、释放资源
rst.close();
stmt.close();
con.close();
%>
</table>
</body>
</html>
we can get
以下是从MySQL数据库读取的数据：
| ID | 书名 | 出版社 | 价格 |
| 1001 | An inconvenient truth | Bogdonoff & Rubin | 45.0 |
| 1002 | The satanic gases | Rodale | 49.0 |
| 1003 | Global climate change and wildlife | Cato Institute | 59.0 |
| 1004 | Environmental resource handbook | Wildlife Society | 59.0 |
| 1005 | American heritage science dictionary | Houghton Mifflin Book | 56.0 |
No comments:
Post a Comment