JSP课后作业（二）连接查询数据库 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>图书列表</title>
  </head>
  <body>
    <table bgcolor="lightgray">
        <tr>
            <td>ISBM</td>
            <td>书名</td>
            <td>版本</td>
            <td>出版时间</td>
            <td>价格</td>
        </tr>
        <%
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/books?useUnicode=true&characterEncoding=UTF-8";
            Connection dbCon = DriverManager.getConnection(url, "root", "30");
            Statement stmt = dbCon.createStatement();
            ResultSet rs = stmt.executeQuery("select * from titles");
            while (rs.next()) {
         %>
         <tr bgcolor="cyan">
             <td><%= rs.getString(1) %></td>
             <td><%= rs.getString(2) %></td>
             <td><%= rs.getInt("editionNumber") %></td>
             <td><%= rs.getInt(4) %></td>
             <td><%= rs.getDouble("price") %></td>
         </tr>
         <%
             }
             rs.close();
             stmt.close();
             dbCon.close(); 
         %>
    </table>
  </body>
</html>

 

posted @ 2017-11-15 11:44  douzujun  阅读(284)  评论(0)    收藏  举报