|
Innehåll |
|
Startsida
|
|
<%
try {
stmt = conn.prepareStatement("SELECT tblm.Counter, tblm.MainLinkName FROM tblmainlink tblm WHERE tblm.Active = 1 ORDER BY tblm.Priority");
ResultSet rs1 = stmt.executeQuery();
while(rs1.next()) { %>
>
"><%out.println(rs1.getString("tblm.MainLinkName"));%>
|
|
<% if (request.getParameter("NodeId") != null) {
if (rs1.getString("tblm.Counter").equals(request.getParameter("NodeId"))) {
try {
stmt = conn.prepareStatement("SELECT tbls.Counter, tbls.MainLinkCounter, tbls.SecondLinkName FROM tblsecondlink tbls WHERE tbls.Active = 1 AND tbls.MainLinkCounter = ("+rs1.getString("tblm.Counter")+") ORDER BY tbls.Priority");
ResultSet rs2 = stmt.executeQuery();
while(rs2.next()) { %>
&x=<%out.println(rs2.getString("tbls.Counter"));%>"><%out.println(rs2.getString("tbls.SecondLinkName"));%>
|
|
<% }
}
catch (Exception e) {
out.println(e);
}
}
}
}
}
catch (Exception e) {
out.println(e);
} %>
|
|
|
|
Nyheter |
|
|
<% try {
stmt = conn.prepareStatement("DELETE FROM tblpublish WHERE ToDate < ("+checkDate+")");
stmt.executeUpdate();
stmt = conn.prepareStatement("SELECT tblp.Counter, tblp.Headline, tblp.FromDate FROM tblpublish tblp, tbluser tblu WHERE tblp.IDofUser = tblu.Counter");
ResultSet rs = stmt.executeQuery();
while(rs.next()) { %>
<%out.println(rs.getString("tblp.FromDate"));%>
<%out.println(rs.getString("tblp.Headline"));%>
">Läs mer
<% }
}
catch (Exception e) {
out.println(e);
} %>
|
|
|
<%
// Nyhet
if (request.getParameter("publish") != null) {
try {
stmt = conn.prepareStatement("SELECT tblp.Counter, tblp.Headline, tblp.PM, tblp.FromDate, tblu.FName, tblu.LName FROM tblpublish tblp, tbluser tblu WHERE tblp.IDofUser = tblu.Counter AND tblp.Counter = ("+request.getParameter("publish")+")");
ResultSet rs = stmt.executeQuery();
rs.next(); %>
<%out.println(rs.getString("tblp.Headline"));%>
<%out.println(rs.getString("tblp.PM"));%>
Publicerad av:
<%out.println(rs.getString("tblu.FName"));%><%out.println(rs.getString("tblu.LName"));%><%out.println(rs.getString("tblp.FromDate"));%>
<% }
catch (Exception e) {
out.println(e);
}
}
// Sök
if (request.getParameter("search") != null) {
try {
stmt = conn.prepareStatement("SELECT m.Counter, m.MainLinkName, m.Link FROM tblmainlink m, tblpage p WHERE m.Link = p.Counter AND p.PM like '%"+request.getParameter("search")+"%'");
ResultSet rs = stmt.executeQuery();
while(rs.next()) { %>
"><%out.println(rs.getString("m.MainLinkName"));%>
<% }
}
catch (Exception e) {
out.println(e);
}
try {
stmt = conn.prepareStatement("SELECT s.Counter, s.SecondLinkName, s.MainLinkCounter FROM tblsecondlink s, tblpage p WHERE s.Link = p.Counter AND p.PM like '%"+request.getParameter("search")+"%'");
ResultSet rs = stmt.executeQuery();
while(rs.next()) { %>
"><%out.println(rs.getString("s.SecondLinkName"));%>
<% }
}
catch (Exception e) {
out.println(e);
}
}
// NodeId
if (request.getParameter("NodeId") != null && request.getParameter("x") == null) {
try {
stmt = conn.prepareStatement("SELECT tblp.PM, tblp.CreatedDate, tblm.Counter, tblm.Link FROM tblpage tblp, tblmainlink tblm WHERE tblm.Counter = ("+request.getParameter("NodeId")+") AND tblm.Link = tblp.Counter");
ResultSet rs = stmt.executeQuery();
rs.next(); %>
<%out.println(rs.getString("tblp.PM"));%>
Sidan senast ändrad:
<%out.println(rs.getString("tblp.CreatedDate"));%>
<% }
catch (Exception e) {
out.println(e);
}
}
// NodeId + x
if (request.getParameter("NodeId") != null && request.getParameter("x") != null) {
try {
stmt = conn.prepareStatement("SELECT tblp.PM, tblp.CreatedDate, tbls.Counter, tbls.Link FROM tblpage tblp, tblsecondlink tbls WHERE tbls.Counter = ("+request.getParameter("x")+") AND tbls.Link = tblp.Counter");
ResultSet rs = stmt.executeQuery();
rs.next(); %>
<%out.println(rs.getString("tblp.PM"));%>
Sidan senast ändrad:
<%out.println(rs.getString("tblp.CreatedDate"));%>
<% }
catch (Exception e) {
out.println(e);
}
}
// NodeId = null
if (request.getParameter("NodeId") == null && request.getParameter("publish") == null && request.getParameter("search") == null) {
try {
stmt = conn.prepareStatement("SELECT tblp.PM FROM tblpage tblp WHERE tblp.Counter = 1");
ResultSet rs = stmt.executeQuery();
rs.next(); %>
<%out.println(rs.getString("tblp.PM"));%>
<% }
catch (Exception e) {
out.println(e);
}
}
%>
|
|