Historier som finner sted i løpet av James Potters levetid, derunder den første store krigen mot Voldemort.
<% // Laster inn driver for databasekoblingen Class.forName("org.gjt.mm.mysql.Driver").newInstance(); // Kobler til databasen. java.sql.Connection db = java.sql.DriverManager.getConnection( "jdbc:mysql://mysql.stud.ntnu.no/kristink_skole", "kristink_hei", "hei"); java.sql.Statement st = db.createStatement(); java.sql.ResultSet rs; String sp = "SELECT DISTINCT f.mappe,f.navn,f.nydato,f.oppdatert,f.au,f.advarsler,f.smdrag,f.kap,f.ord,f.ferdig,f.ficID FROM Fic f NATURAL JOIN ForegI WHERE ForegI.tidID=3 ORDER BY f.navn ASC"; rs = st.executeQuery(sp); while ( rs.next() ) { //finn forfattere java.sql.Statement st2 = db.createStatement(); java.sql.ResultSet rs2; String sp2 = "SELECT Forf.side,Forf.navn FROM Forf NATURAL JOIN SkrevetAv WHERE SkrevetAv.ficID=" + Integer.parseInt(rs.getString(11)) + " ORDER BY Forf.navn ASC;"; rs2 = st2.executeQuery(sp2); //finn kategorier java.sql.Statement st3 = db.createStatement(); java.sql.ResultSet rs3; String sp3 = "SELECT Kat.side,Kat.navn FROM Kat NATURAL JOIN ErI WHERE ErI.ficID=" + Integer.parseInt(rs.getString(11)) + " ORDER BY Kat.navn ASC;"; rs3 = st3.executeQuery(sp3); //finn tider java.sql.Statement st4 = db.createStatement(); java.sql.ResultSet rs4; String sp4 = "SELECT Tid.side,Tid.navn FROM Tid NATURAL JOIN ForegI WHERE ForegI.ficID=" + Integer.parseInt(rs.getString(11)) + " ORDER BY Tid.navn ASC;"; rs4 = st4.executeQuery(sp4); out.print("");
out.print("Lagt ut: " + rs.getString(3) + " -- Oppdatert: " + rs.getString(4) + "
");
out.print("Kategorier: ");
while( rs3.next()) {
out.print("" + rs3.getString(2) + "");
if(!rs3.isLast()) {
out.print(", ");
}
}
out.print("
");
out.print(" Tid: ");
while( rs4.next()) {
out.print("" + rs4.getString(2) + "");
if(!rs4.isLast()) {
out.print(", ");
}
}
out.print("
");
out.print(" AU: " + rs.getString(5) + "
");
out.print("Advarsler: " + rs.getString(6) + "
");
out.print("Sammendrag: " + rs.getString(7) + "
");
out.print("Antall kapitler: " + rs.getString(8) + " - Antall ord: " + rs.getString(9) + "
");
out.print("Fullført: " + rs.getString(10));
out.print("