Untitled

<html>

	<head>

		<title> Min Gjestebok </title>

	</head>

	<body bgcolor="#3576148">

	<h2> Gjestebok </h2>

	<form action="gjestebok.jsp" method="post">
	<p>
	Skriv en hilsen i gjesteboka mi PLZ. <em> TY </em>
	</p>
	<p>
	 Navn: <input type="tekst" name="navn" value="" size="30">
	 </p>
	 <p>
	 Epost: <input type="text" name="epost" value="@" size="30">
	 </p>
	 <p>
	 Din hilsen:
	 <textarea name="hilsen" rows="5" cols="50"> </textarea>
	 </p>
	 <p>

	 	<input type="submit" value="Legg inn hilsen">
	 	<input type="reset" value="Fjern innhold">
	 	</p>
	 </form>

	<%
		if (request.getParameter("navn") == " ") {
		out.print("<h3> skriv inn navn </h3>");
		}
	%>


	</body>
</html>


<%
String navn = request.getParameter("navn");
String epost = request.getParameter("epost");
String hilsen = request.getParameter("hilsen");


Class.forName("org.gjt.mm.mysql.Driver").newInstance();

java.sql.Connection db =
java.sql.DriverManager.getConnection(
	"jdbc:mysql://mysql.stud.ntnu.no/markeng_gjestebok",
	"markeng_admin",
	"nanni"
);

java.sql.Statement st = db.createStatement();

java.sql.ResultSet rs;

%>

<%
rs = st.executeQuery ("INSERT INTO gjestebok(navn, epost, hilsen) values('" + navn + "','" + epost + "','" + hilsen + "')");
%>

<%
st = db.createStatement();
rs = st.executeQuery("SELECT navn, tidspunkt, epost, hilsen FROM gjestebok ORDER BY tidspunkt DESC");

while (rs.next() ) {

	out.println("<p>");
	out.println("<h4>" + rs.getString("navn"));
	out.println("klokka " + rs.getString("tidspunkt") + "inn hilsen</h4>");
	out.println("<em> Epost: " + rs.getString("epost") + "</em><br>");
	out.println("<strong>" + rs.getString("hilsen") + "</strong>");
	out.println("</p>");
}

rs.close();
%>