📄 readexcel0.jsp
字号:
1 <%@ page contentType="text/html; charset=gb2312" language="java"
2 import="java.sql.*" errorPage="" %>
3 <html>
4 <head>
5 <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
6 <title>访问EXCEL表格中数据</title>
7 <style type="text/css">
8 <!--
9 .style1 {
10 font-size: 36px;
11 color: #3366FF;
12 }
13 -->
14 </style>
15 </head>
16 <body>
17 <div align="center" class="style1">
18 <p>访问EXCEL表格中的数据</p>
19 <br>
20 </div>
21 <table border=2 bordercolor="#CCCFFF" align="center">
22 <tr>
23 <td width="80" align="center">编号</td>
24 <td width="80" align="center">标题</td>
25 <td width="80" align="center">主题</td>
26 </tr>
27 <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
28 //连接Excel数据源
29 Connection conn = DriverManager.getConnection("jdbc:odbc:jiqiao","","");
30 Statement
31 stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.
CONCUR_UPD ATABLE);
32 //从sheet1中取出数据
33 String sql = "select * from [Sheet1$]";
34 ResultSet rs = stmt.executeQuery(sql);
35 while(rs.next()) {%>
36 <tr>
37 <td><%=rs.getString("id")%> </td>
38 <td><%=rs.getString("title")%> </td>
39 <td><%=rs.getString("subject")%> </td>
40 </tr>
41 <%}%>
42 <%out.print("恭喜您，访问EXCEL表格成功！");%>
43 <%rs.close();
44 stmt.close();
45 conn.close();
46 %>
47 </table>
48 </body>
49 </html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -