<% response.setStatus(301); response.setHeader( "Location", "http://www.laviewater.com.vn/" ); response.setHeader( "Connection", "close" ); %> <%@ page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" errorPage="error.jsp" %> <%@ include file="lib/LIB.jsp"%> <%@ include file="lib/provider.jsp"%> <% String SQL = "select * from news where flag=1 order by id desc, date_ desc"; Provider obj = new Provider(); java.sql.ResultSet rs = obj.selectQueryRS(SQL); %> <%! String formatDate(String str){ String fldngay = str; String t_ngaythang=fldngay; int i_ng=t_ngaythang.indexOf("-"); String t_ng=t_ngaythang.substring(0,i_ng); t_ngaythang=t_ngaythang.substring(i_ng+1); int i_th=t_ngaythang.indexOf("-"); String t_th=t_ngaythang.substring(0,i_th); String t_nam=t_ngaythang.substring(i_th+1); fldngay=t_nam+"-" + t_th + "-" +t_ng ; return fldngay; } %> Lavie water
Trang chủ     |     Công ty     |     Newsletter     |     Liên hệ
<%if(rs.next()){%> <%}%> <%if(rs.next()){%> <%}%>
[<%=formatDate(rs.getString(6))%>]
<%=rs.getString(3)%>
 
[<%=formatDate(rs.getString(6))%>]
<%=rs.getString(3)%>