<%@page contentType="text/html" import="java.io.*, java.net.*, java.util.*, java.sql.*, javax.servlet.*, javax.servlet.http.*, java.math.*, java.lang.StringBuffer, java.awt.Toolkit" %> <%@include file="incDef.jsp"%> <%@include file="incParams.jsp"%> <% try{ if(err.equals("")){ if(connect(aDBUrl, aDBUser, aDBPass, aDBDrv) && normalStatement()){ //sql = "SELECT * FROM news WHERE n_show = true order by n_date desc limit 5"; sql = "SELECT * FROM news WHERE n_show = true order by n_date desc"; execQ(sql); String filmName; double randNumb = Math.random(); if(randNumb<0.3){ filmName="1"; }else if(randNumb>=0.3 && randNumb<=0.6){ filmName="3"; }else{ filmName="2"; } %> Pet Soccer
 
<%@include file="include/menu.htm"%> <% i=0; String sDate=""; while(rs.next()){ sDate = rs.getString("n_date"); sDate = sDate.substring(0, sDate.indexOf(" ")); sDate = sDate.substring(8, 10)+"-"+sDate.substring(5, 7)+"-"+sDate.substring(0, 4); %> <% i++; } %>
<%=rs.getString("n_title")%>

<%=sDate%>
<%=rs.getString("n_text")%>
<%@include file="include/side.jsp"%>
 
<% closeAll(); }//connect }//err %><%=err%><% }catch(Exception e){ String ee = "err.jsp?e="+e.toString()+"&m="+e.getMessage(); %> <% } if(!err.equals("")){ String ee = "err.jsp?e="+err.substring(err.indexOf(":")+1, err.length())+"&m="; %> <% } %>