Hvorfor kan jeg ikke reloade den her side
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"><html>
<%@ page language="java" import="java.util.*,java.sql.*,util.*" %>
<%@ include file="../include/checklogin.jsp" %>
<head>
<title>Kontaktpersoner</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="../style/style1024.css">
<!-- <script language="JavaScript" src="../script/script.js"></script> -->
</head>
<body style="background-image:url('../billeder/bt3u.jpg');background-repeat: no-repeat;">
<%
Databaseforbindelsemysqlprepared d = new Databaseforbindelsemysqlprepared("jdbc:mysql://URL/DB?user=USER&password=PASSWORD", "com.mysql.jdbc.Driver");
// Opdater kontaktperson
if (request.getParameter("update")!=null && request.getParameter("update").equals("update")){
Vector vi = new Vector();
vi.addElement(request.getParameter("navn"));
vi.addElement(request.getParameter("funktion"));
vi.addElement(request.getParameter("telefon"));
vi.addElement(request.getParameter("mobil"));
vi.addElement(request.getParameter("fax"));
vi.addElement(request.getParameter("email"));
vi.addElement(request.getParameter("personid"));
d.insertUpdate("UPDATE kontakt_info SET navn=?, funktion=?, telefon=?, mobil=?, fax=?, email=? WHERE id = ? ", vi);
}
// Fjern kontaktperson (sletter også alle relationer til produktgrupper)
if (request.getParameter("update")!=null && request.getParameter("update").equals("slet")){
Vector vi = new Vector();
vi.addElement(request.getParameter("personid"));
d.insertUpdate("delete from kontakt_info WHERE id = ? ", vi);
d.insertUpdate("delete from menutekst_user_rel WHERE user_id = ? ", vi);
}
%>
<div style="position:absolute;padding-top:0px;margin-top:10px;margin-left:50px;height:50px;width:800px;background-color:transparent;">
Kontaktpersoner
</div>
<%
Vector vi1 = new Vector();
try {
ResultSet rs1 = d.select("select ki.id, ki.navn, ki.funktion, ki.telefon, ki.mobil, ki.email, ki.fax from kontakt_info ki", vi1);
%>
<div style="overflow:auto;position:absolute;padding-top:0px;margin-top:50px;margin-left:50px;height:550px;width:900px;background-color:#999999;">
<table border="1" style="width:900px;">
<tr>
<th>Navn</th>
<th>Funktion</th>
<th>Telefon</th>
<th>Mobil</th>
<th>Fax</th>
<th>E-mail</th>
<th></th>
</tr>
<%
while(rs1.next()){
%>
<tr>
<form name="kontaktperson" method="post" style="display:inline;">
<input type="hidden" name="update" value="">
<input type="hidden" name="personid" value="<%= rs1.getString("id") %>">
<td><input type="text" name="navn" value="<%= rs1.getString("navn") %>" size="15" /></td>
<td><input type="text" name="funktion" value="<%= rs1.getString("funktion") %>" size="15" /></td>
<td><input type="text" name="telefon" value="<%= rs1.getString("telefon") %>" size="15" /></td>
<td><input type="text" name="mobil" value="<%= rs1.getString("mobil") %>" size="15" /></td>
<td><input type="text" name="fax" value="<%= rs1.getString("fax") %>" size="15" /></td>
<td><input type="text" name="email" value="<%= rs1.getString("email") %>" size="15" /></td>
<td style="text-align:right;">
<button type="submit" style="width:60px;" onclick="this.form.update.value='update'">Opdater</button>
<button type="submit" style="width:50px;" onclick="this.form.update.value='slet'">Fjern</button>
</td>
</form>
</tr>
<%
}
%>
<tr><td colspan="7" style="text-align:right;"><button name="opretkontaktperson" onclick="win=window.open('./opret_kontaktperson.jsp', 'opretkontaktperson', 'scrollbars=yes,resizable=no,copyhistory=yes,height=500,width=600,top=100,left=100,screenY=150,screenX=100');win.focus();">Opret kontaktperson</button></td></tr>
</table>
</div>
<%
} catch (SQLException s) {
System.out.println("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
d.close();
%>
</body>
</html>
