Endnu et problem under linux
Jeg fatter hat af hvad der er galt her. Jeg syntes jeg har prøvet alt men intet syntes at virke. Det virker fint under windows men ikke under Linux som det jo meget gerne skulle. 200 points til den som finder fejlen. Den henter data fint nok ind, men når jeg trykker på knappen så går der et eller andet galt.Det kan ses her
http://web-oasen.dk/golf/
user: testtest
pass: 12345abc
Tryk på indstillinger, og så på opdater. SUK
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">
<html>
<%@ page language="java" import="java.util.*,java.sql.*,util.*,framework.*" %>
<head>
<title>Personlige indstillinger</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="../style/golf.css">
<script language="JavaScript" src="../script/script.js"></script>
</head>
<body onload="self.focus();">
<%
Databaseforbindelsemysqlprepared d = new Databaseforbindelsemysqlprepared("jdbc:mysql://URL/DB?user=USER&password=PASS", "org.gjt.mm.mysql.Driver");
StringBuffer buffer = new StringBuffer();
try {
String user = (String)session.getAttribute("navn");
Vector vi = new Vector();
vi.addElement(user);
ResultSet rs = d.select("SELECT ID,username,pass,navn,adresse,postnr,email,telefon,mobil FROM users WHERE username=?", vi);
if(rs.next()) {
ResultSetMetaData rsmd = rs.getMetaData();
int antalKolonner = rsmd.getColumnCount();
// System.out.println(antalKolonner+" kolonner");
// udskriv kolonnenavnene
for (int i=1; i<=antalKolonner; i++) {
// System.out.println(rsmd.getColumnName(i) + "'s indhold: "+rs.getString(i));
String pv = request.getParameter(rsmd.getColumnName(i));
if (pv != null) {
rs.updateString(i,pv);
rs.updateRow();
}
}
String by;
ResultSet rs1 = d.select("SELECT p.byen FROM users u, postnr p WHERE p.postnr=u.postnr AND username=?", vi);
if(!rs1.first()) {
by = "ingen";
}
else
{
by = rs1.getString("byen");
}
String id = rs.getString("ID");
String pass = rs.getString("pass");
String navn = rs.getString("navn");
String adresse = rs.getString("adresse");
String postnr = rs.getString("postnr");
String telefon = rs.getString("telefon");
String mobil = rs.getString("mobil");
String email = rs.getString("email");
if(navn==null){
navn="";
}
if(adresse==null){
adresse="";
}
if( (postnr==null) || (postnr.equals("0")) ){
postnr="";
}
if(by==null){
by="";
}
if( (telefon==null) || (telefon.equals("0")) ){
telefon="";
}
if( (mobil==null) || (mobil.equals("0")) ){
mobil="";
}
if(email==null){
email="";
}
buffer.append("<div>");
buffer.append("Personlige indstillinger");
buffer.append("</div>");
buffer.append("<form action=\"./settings.jsp\" method=\"post\" onsubmit=\"return popupupd();\">");
buffer.append("<table>");
buffer.append("<tr><td>");
buffer.append("Brugernavn:");
buffer.append("</td><td>");
buffer.append(user);
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Password:");
buffer.append("</td><td>");
buffer.append("<input type=\"password\" class=\"inputf\" name=\"pass\" value=\""+pass+"\">");
buffer.append("</td></tr>");
buffer.append("<tr style=\"height:25px;\"><td>");
buffer.append("</td><td>");
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Navn:");
buffer.append("</td><td>");
buffer.append("<input type=\"text\" class=\"inputf\" name=\"navn\" value=\""+navn+"\">");
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Adresse:");
buffer.append("</td><td>");
buffer.append("<input type=\"text\" class=\"inputf\" name=\"adresse\" value=\""+adresse+"\">");
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Postnr.:");
buffer.append("</td><td>");
buffer.append("<input type=\"text\" class=\"inputf\" name=\"postnr\" value=\""+postnr+"\">");
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("By:");
buffer.append("</td><td>");
buffer.append(by);
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Telefon:");
buffer.append("</td><td>");
buffer.append("<input type=\"text\" class=\"inputf\" name=\"telefon\" value=\""+telefon+"\">");
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Mobil:");
buffer.append("</td><td>");
buffer.append("<input type=\"text\" class=\"inputf\" name=\"mobil\" value=\""+mobil+"\">");
buffer.append("</td></tr>");
buffer.append("<tr><td>");
buffer.append("Email:");
buffer.append("</td><td>");
buffer.append("<input type=\"text\" class=\"inputf\" name=\"email\" value=\""+email+"\">");
buffer.append("</td></tr>");
buffer.append("<tr style=\"height:50px;\"><td colspan=\"2\" style=\"text-align:right;\">");
buffer.append("<input type=\"submit\" class=\"knap\" name=\"updateknap\" value=\"Opdater\">");
buffer.append("</td><td>");
buffer.append("</table>");
buffer.append("</form>");
}
} catch (SQLException s) {
buffer.append("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
buffer.append("</body>\n");
buffer.append("</html>\n");
out.println(buffer.toString());
out.close();
d.close();
%>
</body>
</html>
