標籤：
1 <%@ page contentType="text/html; charset=utf-8" language="java" errorPage=""%> 2 <%@ page import="java.sql.*" %> 3 <html> 4 <head> 5 <title>歡迎</title> 6 </head> 7 <%! 8 public int count=0; 9 public String info()10 {11 return "hello";12 }13 %>14 <body>15 <%16 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver") ; 17 Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=QHY","sa","sa");18 Statement stmt = conn.createStatement();19 ResultSet rs = stmt.executeQuery("select * from t_users");20 %>21 <table bgcolor="#9999dd" border="1" width="300px">22 <% 23 while(rs.next())24 {25 %>26 <tr>27 <td>迴圈值：</td>28 <td><%=rs.getString(1)%></td>29 <td><%=rs.getString(2)%></td>30 </tr>31 <% 32 }33 %>34 </table>35 </body>36 </html>
要先下載jdbc驅動放到tomcat的lib或項目的lib下；
JSP直接連接sql2008資料庫並顯示
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
