connect = DriverManager.getConnection("" + "jdbc:sqlserver://bc6hela9fr.database.windows.net:1433;" + "database=thaicreate-db;" + "user=thaicreate_user@bc6hela9fr;password=password@123;" + "encrypt=true;hostNameInCertificate=*.database.windows.net;" + "loginTimeout=30;");
<%@ page import="java.sql.ResultSet" %> <%@ page import="java.sql.SQLException" %> <%@ page import="java.sql.Statement" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.DriverManager" %> <html> <head> <title>ThaiCreate.Com JSP Tutorial</title> </head> <body> <% Connection connect = null; Statement s = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); connect = DriverManager.getConnection("" + "jdbc:sqlserver://bc6hela9fr.database.windows.net:1433;" + "database=thaicreate-db;" + "user=thaicreate_user@bc6hela9fr;password=password@123;" + "encrypt=true;hostNameInCertificate=*.database.windows.net;" + "loginTimeout=30;"); s = connect.createStatement(); String sql = "SELECT * FROM customer ORDER BY CustomerID ASC"; ResultSet rec = s.executeQuery(sql); %> <table width="600" border="1"> <tr> <th width="91"> <div align="center">CustomerID </div></th> <th width="98"> <div align="center">Name </div></th> <th width="198"> <div align="center">Email </div></th> <th width="97"> <div align="center">CountryCode </div></th> <th width="59"> <div align="center">Budget </div></th> <th width="71"> <div align="center">Used </div></th> </tr> <%while((rec!=null) && (rec.next())) { %> <tr> <td><div align="center"><%=rec.getString("CustomerID")%></div></td> <td><%=rec.getString("Name")%></td> <td><%=rec.getString("Email")%></td> <td><div align="center"><%=rec.getString("CountryCode")%></div></td> <td align="right"><%=rec.getFloat("Budget")%></td> <td align="right"><%=rec.getFloat("Used")%></td> </tr> <%}%> </table> <% } catch (Exception e) { // TODO Auto-generated catch block out.println(e.getMessage()); e.printStackTrace(); } try { if(s!=null){ s.close(); connect.close(); } } catch (SQLException e) { // TODO Auto-generated catch block out.println(e.getMessage()); e.printStackTrace(); } %> </body> </html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
Load balance : Server 02
