Notifikationer

Markér alle som læst Log ud

mikmakmuk Nybegynder

13. april 2003 - 19:36 Der er 21 kommentarer og
2 løsninger

Problem i servlet

Hej Eksperter,
Jeg har en form i en servlet som ser således ud.

buffer.append("<form name=\"choose\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select name=\"choose\" onChange=\"document.editpage.submit();\">\n");
buffer.append("<option>------- Select -------</option>\n");
buffer.append("<option value=\"mortal\">Mortallove</option>\n");
buffer.append("<option value=\"beauty\">All The Beauty</option>\n");
buffer.append("</select>\n");
buffer.append("</form>\n");

Mit problem er at jeg skal have en variable om alt efter hvad der bliver valgt, altså i princippet sende den med som en hidden i formen.

Synes godt om

arne_v Ekspert

13. april 2003 - 19:38 #1

Jeg tror lige at du bliver nødt til at forklare lidt mere.

Synes godt om

arne_v Ekspert

13. april 2003 - 19:39 #2

Fordi din EditPage vil kunen se hvad der valgt.

Synes godt om

arne_v Ekspert

13. april 2003 - 19:40 #3

Hvis der er tale om at denne servlet skal sende en variabel med over til
EditPage, så har du flere muligheder:

1) generere et hidden felt med en værdi i denne servlet

2) gemme variabelen i sessionen

Jeg vil absolut anbefale #2.

Synes godt om

erikjacobsen Ekspert

13. april 2003 - 19:42 #4

<form name=\"editpage\"

??

Synes godt om

disky Nybegynder

13. april 2003 - 19:43 #5

Det er en utrolig dum ide at lave HTML i en servlet, du laver en extremt hård kobling imellem funktionalitet og design, hvilket du fortryder inderligt den da du vil ændre design.

Brug JSP og custom tags istedet.

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 19:45 #6

Det handler om at jeg har en variable i servletten som afgører hvad der skal vises. Den skal jeg have ændret alt efter hvad der bliver valgt i formen

Synes godt om

arne_v Ekspert

13. april 2003 - 19:47 #7

Øh.

Den her servlet genererer en form - den processer ikke submit fra
en form.

Ihvertfald udfra den kode vi har set.

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 19:47 #8

Jeg koder efter bedste evne :-)

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 19:49 #9

Servletten hedder Editpage.

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 19:50 #10

Den kalder sig selv via onchange i formen.

Synes godt om

arne_v Ekspert

13. april 2003 - 19:51 #11

OK, så EditPage både genererer formen og processer submitten ?

Men så bør du jo kunne bruge request.getParameter("choose") til
at finde værdi brugeren har SELECT'et.

Synes godt om

disky Nybegynder

13. april 2003 - 19:55 #12

yep

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:00 #13

Det har jeg lige prøvet. Der sker mærkelige ting :-)

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:01 #14

Jeg skal lige arbejde noget mere med det, så vender jeg tilbage :-)

Synes godt om

arne_v Ekspert

13. april 2003 - 20:03 #15

Husk at check for den er null.

Synes godt om

arne_v Ekspert

13. april 2003 - 20:18 #16

Husk at check for om den er null.

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:30 #17

Det hele ser således ud. Det kan ses her http://www.web-oasen.dk/mortallovebeta/adm/index.jsp

user: test
pass: test

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import util.*;

public class Editpage extends HttpServlet
{

public void doPost (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{

PrintWriter out;
response.setContentType("text/html");

StringBuffer buffer = new StringBuffer();

String page = request.getParameter("page");
String sel = request.getParameter("sel");

out = response.getWriter();
out.println("sel er: "+sel+"<br>");
out.println("page er: "+page);
buffer.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">\n");
buffer.append("<html><head><title>Update</title>\n");
buffer.append("<link rel=\"stylesheet\" type=\"text/css\" href=\"../style/styles.css\">\n");
buffer.append("<link rel=\"stylesheet\" type=\"text/css\" href=\"../style/scroll.css\">\n");
buffer.append("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=ISO-8859-1\">\n");

buffer.append("</script>\n");
buffer.append("<style type=\"text/css\">\n");
buffer.append("body{ margin-top:50px;}\n");
buffer.append("</style>\n");
buffer.append("</head>\n");
buffer.append("<body onload=\"self.focus();\">\n");
buffer.append("<p style=\"text-align:center;font-size:18px;font-weight:bold;\">\n");
buffer.append("Update Mortallove.com\n");
buffer.append("</p>\n");

buffer.append("<form method=\"post\" name=\"choose\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select name=\"sel\" onChange=\"document.choose.submit();\">\n");
buffer.append("<option>------- Select -------</option>\n");
buffer.append("<option value=\"mortal\">Mortallove</option>\n");
buffer.append("<option value=\"beauty\">All The Beauty</option>\n");
buffer.append("</select>\n");
buffer.append("</form>\n");

Databaseforbindelsemysql d = new Databaseforbindelsemysql("jdbc:mysql://URL/DB?user=USER&password=PASS","com.mysql.jdbc.Driver");

try {

buffer.append("<table style=\"width:700px;\">\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"text-align:left;font-weight:bold;width:100px;border-right:ridge;border-width:thin;\">\n");
buffer.append("Mortalove");
buffer.append("</td>\n");
buffer.append("<td style=\"padding-left:5px;text-align:left;font-weight:bold;width:600px;\">\n");
buffer.append("All The beuaty");
buffer.append("</td></tr>\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"text-align:left;border-right:ridge;border-width:thin;\">\n");

if (sel.equals("mortal")){
buffer.append("<form method=\"post\" name=\"editpage\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select class=\"dropbox\" name=\"page\" onChange=\"document.editpage.submit();\">\n");
buffer.append("<option value=\"start\" "+(page.equals("start")?"Selected":"")+">Start</option>\n");
buffer.append("<option value=\"news\" "+(page.equals("news")?"Selected":"")+">News</option>\n");
buffer.append("<option value=\"mrtlz\" "+(page.equals("mrtlz")?"Selected":"")+">the Mrtlz</option>\n");
buffer.append("<option value=\"credit\" "+(page.equals("credit")?"Selected":"")+">Credit</option>\n");
buffer.append("<option value=\"contact\" "+(page.equals("contact")?"Selected":"")+">Contact</option>\n");
buffer.append("<option value=\"guestbook\" "+(page.equals("guestbook")?"Selected":"")+">Guestbook</option>\n");
buffer.append("</select>\n");
buffer.append("<input type=\"hidden\" name=\"sel\" value=\"mortal\">\n");
buffer.append("</form>\n");
}

buffer.append("</td><td style=\"padding-left:5px;text-align:left;\">\n");

if (sel.equals("beauty")){
buffer.append("<form method=\"post\" name=\"editpage1\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select class=\"dropbox\" name=\"page\" onChange=\"document.editpage1.submit();\">\n");
buffer.append("<option value=\"album\" "+(page.equals("album")?"Selected":"")+">The Album</option>\n");
buffer.append("<option value=\"tracks\" "+(page.equals("tracks")?"Selected":"")+">Tracks</option>\n");
buffer.append("<option value=\"words\" "+(page.equals("words")?"Selected":"")+">Words</option>\n");
buffer.append("<option value=\"press\" "+(page.equals("press")?"Selected":"")+">Press</option>\n");
buffer.append("<option value=\"media\" "+(page.equals("media")?"Selected":"")+">Media</option>\n");
buffer.append("</select>\n");
buffer.append("<input type=\"hidden\" name=\"sel\" value=\"beauty\">\n");
buffer.append("</form>\n");
}

buffer.append("</td></tr>\n");
buffer.append("</table>\n");

if(page.equals("news")){
ResultSet rsnews = d.select("SELECT * FROM news ORDER BY id DESC");

buffer.append("<table style=\"width:700px;text-align:left;\">\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"vertical-align:bottom;\">\n");
buffer.append("<input type=\"button\" class=\"button1\" value=\"New entry\" onclick=\"self.location.href='../index/editnews.html';\">\n");
buffer.append("</td></tr>\n");
while(rsnews.next()) {

int id = rsnews.getInt(1);
String date = rsnews.getString(2).replaceAll("\n","<BR>");
String news = rsnews.getString(3).replaceAll("\n","<BR>");;

buffer.append("<tr><td class=\"celltext\" style=\"width:35%;border:ridge;border-width:thin;\">\n");
buffer.append(date);
buffer.append("</td><td class=\"celltext\" style=\"width:55%;border:ridge;border-width:thin;\">\n");
buffer.append(news);
buffer.append("</td><td style=\"width:10%;vertical-align:top;text-align:right;border:ridge;border-width:thin;\">\n");
buffer.append("<form method=\"post\" name=\"delnews"+id+"\" action=\"Edit\" style=\"display:inline;\">\n");
buffer.append("<input type=\"hidden\" name=\"page\" value=\"news\">\n");
buffer.append("<input type=\"hidden\" name=\"sel\" value=\"mortal\">\n");
buffer.append("<input type=\"hidden\" name=\"newsid\" value=\""+id+"\">\n");
buffer.append("<input type=\"hidden\" name=\"doedit\" value=\"delete\">\n");
buffer.append("<input type=\"button\" class=\"button1\" style=\"width:100%;\" name=\"delete\" value=\"Delete\" onClick=\"document.delnews"+id+".submit();\">\n");
buffer.append("</form>\n");
buffer.append("</td></tr>\n");
}

buffer.append("</table>\n");

}

else if(page.equals("tracks")){
ResultSet rstracks = d.select("SELECT * FROM tracks ORDER BY id DESC");

buffer.append("<table style=\"width:700px;\">\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"text-align:left;vertical-align:bottom;\">\n");
buffer.append("<input type='button' class='button1' value='Upload' onclick=\"self.location.href='../upload.jsp';\">\n");
buffer.append("</td></tr>\n");

while(rstracks.next()) {

int id = rstracks.getInt(1);
String name = rstracks.getString(2).replaceAll("\n","<BR>");
String url = rstracks.getString(3);
// System.out.println(id);

buffer.append("<tr><td class='celltext' style='width:35%;border:ridge;border-width:thin;'>\n");
buffer.append(name);
buffer.append("</td><td class='celltext' style='width:55%;border:ridge;border-width:thin;'>\n");
buffer.append(url);
buffer.append("</td><td style='width:10%;vertical-align:top;text-align:right;border:ridge;border-width:thin;'>\n");
buffer.append("<form method='post' name='deltracks"+id+"' action='Edit' style='display:inline;'>\n");
buffer.append("<input type='hidden' name='page' value='tracks'>\n");
buffer.append("<input type='hidden' name='sel' value='beauty'>\n");
buffer.append("<input type='hidden' name='tracksid' value='"+id+"'>\n");
buffer.append("<input type='hidden' name='doedit' value='delete'>\n");
buffer.append("<input type='button' class='button1' style='width:100%;' name='delete' value='Delete' onClick='document.deltracks"+id+".submit();'>\n");
buffer.append("</form>\n");
buffer.append("</td></tr>\n");
}

buffer.append("</table>\n");
}

else if(page.equals("guestbook")){
ResultSet rsguest = d.select("SELECT * FROM guestbook ORDER BY id DESC");

buffer.append("<table style=\"width:700px;\">\n");

while(rsguest.next()) {

int id = rsguest.getInt(1);
String name = rsguest.getString(2);
String homepage = rsguest.getString(3);
String email = rsguest.getString(4);
String country = rsguest.getString(5);
String comment = rsguest.getString(6).replaceAll("\n","<BR>");
String date = rsguest.getString(7);

// System.out.println(id);

buffer.append("<tr><td class='celltext' style='text-align:left;width:90%;border:ridge;border-width:thin;'>\n");
buffer.append("<table style=\"width:450px;text-align:left;\">\n");
buffer.append("<tr><td style=\"width:100px;\"></td><td style=\"width:350px;color:#0000ee;background-color:transparent;\">"+date+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;\">Name</td><td>"+name+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;\">E-mail</td><td>"+email+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;\">Country</td><td>"+country+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;vertical-align:top;\">Comment</td><td>"+comment+"</td></tr>\n");

buffer.append("</table>\n");
buffer.append("</td>\n");
buffer.append("<td style='width:10%;vertical-align:top;text-align:right;border:ridge;border-width:thin;'>\n");
buffer.append("<form method='post' name='delguestbook"+id+"' action='Edit' style='display:inline;'>\n");
buffer.append("<input type='hidden' name='page' value='guestbook'>\n");
buffer.append("<input type='hidden' name='sel' value='mortal'>\n");
buffer.append("<input type='hidden' name='guestid' value='"+id+"'>\n");
buffer.append("<input type='hidden' name='doedit' value='delete'>\n");
buffer.append("<input type='button' class='button1' style='width:100%;' name='delete' value='Delete' onClick='document.delguestbook"+id+".submit();'>\n");
buffer.append("</form>\n");
buffer.append("</td></tr>\n");
}

buffer.append("</table>\n");
}

else
{

ResultSet rs = d.select("SELECT content FROM pages WHERE name = '"+page+"'");

if (rs.next())
{
String content = rs.getString("content");

buffer.append("<form method='post' name='form' action='Edit' style='display:inline;'>\n");
buffer.append("<table style=\"text-align:left;\"><tr><td>\n");
buffer.append("<input type='hidden' name='page' value='"+page+"'>\n");
buffer.append("<input type='hidden' name='sel' value='"+sel+"'>\n");
buffer.append("<textarea name='content' cols='84' rows='13'>\n");
buffer.append(content);
buffer.append("</textarea>\n");
buffer.append("</td></tr>\n");
buffer.append("<tr><td>\n");
buffer.append("<input type='submit' class='button1' name='Update' value='Update'>\n");
buffer.append("</td></tr>\n");
buffer.append("</table>\n");
buffer.append("</form>\n");
}

}

/*
if(sel.equals("mortal")){
buffer.append("<script language=\"JavaScript\">{\n");
buffer.append(" document.getElementById('mortaltext').style.display='inline';\n");
buffer.append(" document.getElementById('mortaldrop').style.display='inline';\n");
buffer.append(" document.getElementById('beautytext').style.display='none';\n");
buffer.append(" document.getElementById('beautydrop').style.display='none';\n");
buffer.append("}</script>\n");
}
else if(sel.equals("beauty")){
buffer.append("<script language=\"JavaScript\">{\n");
buffer.append(" document.getElementById('beautytext').style.display='inline';\n");
buffer.append(" document.getElementById('beautydrop').style.display='inline';\n");
buffer.append(" document.getElementById('mortaltext').style.display='none';\n");
buffer.append(" document.getElementById('mortaldrop').style.display='none';\n");
buffer.append("}</script>\n");
}
*/
buffer.append("</body></html>");

} catch (SQLException s) {
buffer.append("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}

out.println(buffer.toString());
out.close();
d.close();
}

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
}
}

Synes godt om

disky Nybegynder

13. april 2003 - 20:33 #18

der er håb forude, brug JSP istedet.

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:35 #19

godt at vide :-)

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:43 #20

så virker det sku' *JUBIIIIIII*

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import util.*;

public class Editpage extends HttpServlet
{

public void doPost (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{

PrintWriter out;
response.setContentType("text/html");

StringBuffer buffer = new StringBuffer();

String page = request.getParameter("page");
String sel = request.getParameter("sel");

if(sel.equals("mortal") && page==null){
page = "start";
}

if(sel.equals("beauty") && page==null){
page = "album";
}

out = response.getWriter();
out.println("sel er: "+sel+"<br>");
out.println("page er: "+page);
buffer.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">\n");
buffer.append("<html><head><title>Update</title>\n");
buffer.append("<link rel=\"stylesheet\" type=\"text/css\" href=\"../style/styles.css\">\n");
buffer.append("<link rel=\"stylesheet\" type=\"text/css\" href=\"../style/scroll.css\">\n");
buffer.append("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=ISO-8859-1\">\n");

buffer.append("</script>\n");
buffer.append("<style type=\"text/css\">\n");
buffer.append("body{ margin-top:50px;}\n");
buffer.append("</style>\n");
buffer.append("</head>\n");
buffer.append("<body onload=\"self.focus();\">\n");
buffer.append("<p style=\"text-align:center;font-size:18px;font-weight:bold;\">\n");
buffer.append("Update Mortallove.com\n");
buffer.append("</p>\n");

buffer.append("<form method=\"post\" name=\"choose\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select name=\"sel\" onChange=\"document.choose.submit();\">\n");
buffer.append("<option>------- Select -------</option>\n");
buffer.append("<option value=\"mortal\">Mortallove</option>\n");
buffer.append("<option value=\"beauty\">All The Beauty</option>\n");
buffer.append("</select>\n");
buffer.append("</form>\n");

Databaseforbindelsemysql d = new Databaseforbindelsemysql("jdbc:mysql://URL/DB?user=USER&password=PASS","com.mysql.jdbc.Driver");

try {

buffer.append("<table style=\"width:700px;\">\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"text-align:left;font-weight:bold;width:100px;border-right:ridge;border-width:thin;\">\n");
buffer.append("Mortalove");
buffer.append("</td>\n");
buffer.append("<td style=\"padding-left:5px;text-align:left;font-weight:bold;width:600px;\">\n");
buffer.append("All The beuaty");
buffer.append("</td></tr>\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"text-align:left;border-right:ridge;border-width:thin;\">\n");

if (sel.equals("mortal")){
buffer.append("<form method=\"post\" name=\"editpage\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select class=\"dropbox\" name=\"page\" onChange=\"document.editpage.submit();\">\n");
buffer.append("<option value=\"start\" "+(page.equals("start")?"Selected":"")+">Start</option>\n");
buffer.append("<option value=\"news\" "+(page.equals("news")?"Selected":"")+">News</option>\n");
buffer.append("<option value=\"mrtlz\" "+(page.equals("mrtlz")?"Selected":"")+">the Mrtlz</option>\n");
buffer.append("<option value=\"credit\" "+(page.equals("credit")?"Selected":"")+">Credit</option>\n");
buffer.append("<option value=\"contact\" "+(page.equals("contact")?"Selected":"")+">Contact</option>\n");
buffer.append("<option value=\"guestbook\" "+(page.equals("guestbook")?"Selected":"")+">Guestbook</option>\n");
buffer.append("</select>\n");
buffer.append("<input type=\"hidden\" name=\"sel\" value=\"mortal\">\n");
buffer.append("</form>\n");
}

buffer.append("</td><td style=\"padding-left:5px;text-align:left;\">\n");

if (sel.equals("beauty")){
buffer.append("<form method=\"post\" name=\"editpage1\" action=\"Editpage\" style=\"display:inline;\">\n");
buffer.append("<select class=\"dropbox\" name=\"page\" onChange=\"document.editpage1.submit();\">\n");
buffer.append("<option value=\"album\" "+(page.equals("album")?"Selected":"")+">The Album</option>\n");
buffer.append("<option value=\"tracks\" "+(page.equals("tracks")?"Selected":"")+">Tracks</option>\n");
buffer.append("<option value=\"words\" "+(page.equals("words")?"Selected":"")+">Words</option>\n");
buffer.append("<option value=\"press\" "+(page.equals("press")?"Selected":"")+">Press</option>\n");
buffer.append("<option value=\"media\" "+(page.equals("media")?"Selected":"")+">Media</option>\n");
buffer.append("</select>\n");
buffer.append("<input type=\"hidden\" name=\"sel\" value=\"beauty\">\n");
buffer.append("</form>\n");
}

buffer.append("</td></tr>\n");
buffer.append("</table>\n");

if(page.equals("news")){
ResultSet rsnews = d.select("SELECT * FROM news ORDER BY id DESC");

buffer.append("<table style=\"width:700px;text-align:left;\">\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"vertical-align:bottom;\">\n");
buffer.append("<input type=\"button\" class=\"button1\" value=\"New entry\" onclick=\"self.location.href='../index/editnews.html';\">\n");
buffer.append("</td></tr>\n");
while(rsnews.next()) {

int id = rsnews.getInt(1);
String date = rsnews.getString(2).replaceAll("\n","<BR>");
String news = rsnews.getString(3).replaceAll("\n","<BR>");;

buffer.append("<tr><td class=\"celltext\" style=\"width:35%;border:ridge;border-width:thin;\">\n");
buffer.append(date);
buffer.append("</td><td class=\"celltext\" style=\"width:55%;border:ridge;border-width:thin;\">\n");
buffer.append(news);
buffer.append("</td><td style=\"width:10%;vertical-align:top;text-align:right;border:ridge;border-width:thin;\">\n");
buffer.append("<form method=\"post\" name=\"delnews"+id+"\" action=\"Edit\" style=\"display:inline;\">\n");
buffer.append("<input type=\"hidden\" name=\"page\" value=\"news\">\n");
buffer.append("<input type=\"hidden\" name=\"sel\" value=\"mortal\">\n");
buffer.append("<input type=\"hidden\" name=\"newsid\" value=\""+id+"\">\n");
buffer.append("<input type=\"hidden\" name=\"doedit\" value=\"delete\">\n");
buffer.append("<input type=\"button\" class=\"button1\" style=\"width:100%;\" name=\"delete\" value=\"Delete\" onClick=\"document.delnews"+id+".submit();\">\n");
buffer.append("</form>\n");
buffer.append("</td></tr>\n");
}

buffer.append("</table>\n");

}

else if(page.equals("tracks")){
ResultSet rstracks = d.select("SELECT * FROM tracks ORDER BY id DESC");

buffer.append("<table style=\"width:700px;\">\n");
buffer.append("<tr style=\"height:30px;\"><td style=\"text-align:left;vertical-align:bottom;\">\n");
buffer.append("<input type='button' class='button1' value='Upload' onclick=\"self.location.href='../upload.jsp';\">\n");
buffer.append("</td></tr>\n");

while(rstracks.next()) {

int id = rstracks.getInt(1);
String name = rstracks.getString(2).replaceAll("\n","<BR>");
String url = rstracks.getString(3);
// System.out.println(id);

buffer.append("<tr><td class='celltext' style='width:35%;border:ridge;border-width:thin;'>\n");
buffer.append(name);
buffer.append("</td><td class='celltext' style='width:55%;border:ridge;border-width:thin;'>\n");
buffer.append(url);
buffer.append("</td><td style='width:10%;vertical-align:top;text-align:right;border:ridge;border-width:thin;'>\n");
buffer.append("<form method='post' name='deltracks"+id+"' action='Edit' style='display:inline;'>\n");
buffer.append("<input type='hidden' name='page' value='tracks'>\n");
buffer.append("<input type='hidden' name='sel' value='beauty'>\n");
buffer.append("<input type='hidden' name='tracksid' value='"+id+"'>\n");
buffer.append("<input type='hidden' name='doedit' value='delete'>\n");
buffer.append("<input type='button' class='button1' style='width:100%;' name='delete' value='Delete' onClick='document.deltracks"+id+".submit();'>\n");
buffer.append("</form>\n");
buffer.append("</td></tr>\n");
}

buffer.append("</table>\n");
}

else if(page.equals("guestbook")){
ResultSet rsguest = d.select("SELECT * FROM guestbook ORDER BY id DESC");

buffer.append("<table style=\"width:700px;\">\n");

while(rsguest.next()) {

int id = rsguest.getInt(1);
String name = rsguest.getString(2);
String homepage = rsguest.getString(3);
String email = rsguest.getString(4);
String country = rsguest.getString(5);
String comment = rsguest.getString(6).replaceAll("\n","<BR>");
String date = rsguest.getString(7);

// System.out.println(id);

buffer.append("<tr><td class='celltext' style='text-align:left;width:90%;border:ridge;border-width:thin;'>\n");
buffer.append("<table style=\"width:450px;text-align:left;\">\n");
buffer.append("<tr><td style=\"width:100px;\"></td><td style=\"width:350px;color:#0000ee;background-color:transparent;\">"+date+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;\">Name</td><td>"+name+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;\">E-mail</td><td>"+email+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;\">Country</td><td>"+country+"</td></tr>\n");
buffer.append("<tr><td style=\"padding-left:5px;vertical-align:top;\">Comment</td><td>"+comment+"</td></tr>\n");

buffer.append("</table>\n");
buffer.append("</td>\n");
buffer.append("<td style='width:10%;vertical-align:top;text-align:right;border:ridge;border-width:thin;'>\n");
buffer.append("<form method='post' name='delguestbook"+id+"' action='Edit' style='display:inline;'>\n");
buffer.append("<input type='hidden' name='page' value='guestbook'>\n");
buffer.append("<input type='hidden' name='sel' value='mortal'>\n");
buffer.append("<input type='hidden' name='guestid' value='"+id+"'>\n");
buffer.append("<input type='hidden' name='doedit' value='delete'>\n");
buffer.append("<input type='button' class='button1' style='width:100%;' name='delete' value='Delete' onClick='document.delguestbook"+id+".submit();'>\n");
buffer.append("</form>\n");
buffer.append("</td></tr>\n");
}

buffer.append("</table>\n");
}

else
{

ResultSet rs = d.select("SELECT content FROM pages WHERE name = '"+page+"'");

if (rs.next())
{
String content = rs.getString("content");

buffer.append("<form method='post' name='form' action='Edit' style='display:inline;'>\n");
buffer.append("<table style=\"text-align:left;\"><tr><td>\n");
buffer.append("<input type='hidden' name='page' value='"+page+"'>\n");
buffer.append("<input type='hidden' name='sel' value='"+sel+"'>\n");
buffer.append("<textarea name='content' cols='84' rows='13'>\n");
buffer.append(content);
buffer.append("</textarea>\n");
buffer.append("</td></tr>\n");
buffer.append("<tr><td>\n");
buffer.append("<input type='submit' class='button1' name='Update' value='Update'>\n");
buffer.append("</td></tr>\n");
buffer.append("</table>\n");
buffer.append("</form>\n");
}

}
buffer.append("</body></html>");

} catch (SQLException s) {
buffer.append("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}

out.println(buffer.toString());
out.close();
d.close();
}

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
}
}

Synes godt om

arne_v Ekspert

13. april 2003 - 20:43 #21

Hvad er det der ikke virker ?

(der sker et eller andet når man selecter)

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:44 #22

Det var

if(sel.equals("mortal") && page==null){
page = "start";
}

if(sel.equals("beauty") && page==null){
page = "album";
}
som gjorde udslaget

Synes godt om

mikmakmuk Nybegynder

13. april 2003 - 20:47 #23

Tusinde tak for hjælpen endnu engang :-)))))

Synes godt om

Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Følg dette spørgsmål

Opret Preview

Programmeringssprog kurser

Kurser inden for grundlæggende programmering

Se alle Programmeringssprog kurser

Flere spørgsmål fra Java kategorien

Titel	Indlæg	Oprettet	Seneste aktivitet
Programmering: Produktmixoptimering Af OBS i Java	34	23/05/202513:55	27/05/202518:32
Seleniumspørgsmål vedr. getText() Af mergelspir i Java	11	08/05/202516:32	08/05/202522:16
eclipse Af OBS i Java	0	02/05/202512:51	-
eclipse Af OBS i Java	14	27/04/202521:14	28/04/202521:28
eclipse Af OBS i Java	2	18/04/202517:14	18/04/202519:52

Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester

Alle kategorier på Eksperten

Seneste artiklerRSS