<%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="java.util.Date"%> LAMAN WEB RASMI MAJLIS SUKAN NEGERI TERENGGANU <% Date today = new Date(); %>
  Total Visitor         Font Resize Decrease text size Increase text size


 
SUKMA XX JOHOR 2020
              16 - 14 MAC 2021
 
   
<% String Host = "jdbc:mysql://localhost:3306/ifastdem_webmsnt"; Connection connection = null; Statement statement = null; ResultSet rs = null; Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection(Host, "ifastdem_admin", "P@s$w()rd"); statement = connection.createStatement(); String Data = "select negeri, emas, perak, gangsa, (emas + perak + gangsa) AS jumlah from pingat order by emas desc, perak desc, gangsa desc "; rs = statement.executeQuery(Data); while (rs.next()) { %> <% } %>
  Kedudukan Pingat      Terkini
Emas

Perak

Gangsa

Total
<%=rs.getString("negeri")%> <%=rs.getString("emas")%> <%=rs.getString("perak")%> <%=rs.getString("gangsa")%> <%=rs.getString("jumlah")%>



    Twitter Feed Display :  #msnt

Sign In