<%@page import="java.sql.*"%> <%! java.util.Date date = new java.util.Date(); %> <%! java.text.SimpleDateFormat sdate = new java.text.SimpleDateFormat("yyyy-MM-dd"); %> <%! String checkDate = sdate.format(date,new StringBuffer(),new java.text.FieldPosition(0)).toString(); %> <% PreparedStatement stmt = null; Connection conn = null; Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost/b3007?user=b3007&password=u0pr7FMx9"); %>
 
Sök på innehåll:
 Sök!
 
<% 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()) { %> <% 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()) { %> <% } } catch (Exception e) { out.println(e); } } } } } catch (Exception e) { out.println(e); } %>
 Innehåll
Startsida
> "><%out.println(rs1.getString("tblm.MainLinkName"));%>
      &x=<%out.println(rs2.getString("tbls.Counter"));%>"><%out.println(rs2.getString("tbls.SecondLinkName"));%>
 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); } } %>
Christian Rydell 2010