<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<html>
<head>
<title>
SQLlianjie
</title>
</head>
<body bgcolor="#ffffff">
<table border="2" align="center">
  <tr>
    <td>title_id</td>
    <td>title</td>
    <td>type</td>
    <td>pub_id</td>
    <td>price</td>
    <td>advance</td>
    <td>royalty</td>
    <td>ytd_sales</td>
    <td>notes</td>
    <td>pubdate</td>
  </tr>
  <%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();//加载驱动程序
  String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
  String user="sa";
  String password="";
  Connection conn=DriverManager.getConnection(url,user,password);
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
  ResultSet.CONCUR_UPDATABLE);
  String sql="select top 10* from titles";
  ResultSet rs=stmt.executeQuery(sql);
  while(rs.next()){%>
  <tr><td><%=rs.getString("title_id")%></td>
    <td><%=rs.getString("title")%></td>
    <td><%=rs.getString("type")%></td>
    <td><%=rs.getString("pub_id")%></td>
    <td><%=rs.getString("price")%></td>
    <td><%=rs.getString("advance")%></td>
    <td><%=rs.getString("royalty")%></td>
    <td><%=rs.getString("ytd_sales")%></td>
    <td><%=rs.getString("notes")%></td>
    <td><%=rs.getString("pubdate")%></td>
  </tr>
 <% }%>
  <%out.print("恭喜你,数据库连接成功!");%>
  <%rs.close();
  stmt.close();
  conn.close();
  %>
</table>
</body>
</html>