01.<%@ page import="java.sql.ResultSet" %>
02.<%@ page import="java.sql.SQLException" %>
03.<%@ page import="java.sql.Statement" %>
04.<%@ page import="java.sql.Connection" %>
05.<%@ page import="java.sql.DriverManager" %>
06.<html>
07.<head>
08. <title>ThaiCreate.Com JSP Tutorial</title>
09.</head>
10.<body>
11.
12. <%
13. Connection connect = null;
14. Statement s = null;
15.
16. try {
17. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
18.
19. connect = DriverManager.getConnection("" +
21.
22. s = connect.createStatement();
23.
24. String sql = "SELECT * FROM customer ORDER BY CustomerID ASC";
25.
26. ResultSet rec = s.executeQuery(sql);
27. %>
28. <table width="600" border="1">
29. <tr>
30. <th width="91"> <div align="center">CustomerID </div></th>
31. <th width="98"> <div align="center">Name </div></th>
32. <th width="198"> <div align="center">Email </div></th>
33. <th width="97"> <div align="center">CountryCode </div></th>
34. <th width="59"> <div align="center">Budget </div></th>
35. <th width="71"> <div align="center">Used </div></th>
36. </tr>
37. <%while((rec!=null) && (rec.next())) { %>
38. <tr>
39. <td><div align="center"><%=rec.getString("CustomerID")%></div></td>
40. <td><%=rec.getString("Name")%></td>
41. <td><%=rec.getString("Email")%></td>
42. <td><div align="center"><%=rec.getString("CountryCode")%></div></td>
43. <td align="right"><%=rec.getFloat("Budget")%></td>
44. <td align="right"><%=rec.getFloat("Used")%></td>
45. </tr>
46. <%}%>
47. </table>
48. <%
49. } catch (Exception e) {
50.
51. out.println(e.getMessage());
52. e.printStackTrace();
53. }
54.
55. try {
56. if(s!=null){
57. s.close();
58. connect.close();
59. }
60. } catch (SQLException e) {
61.
62. out.println(e.getMessage());
63. e.printStackTrace();
64. }
65. %>
66.</body>
67.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
