servlet med dropdownboks
Hej Eksperter,Jeg har lavet følgende servlet og den virker sådan set også næsten som den skal. Mit problem er at jeg ikke kan finde ud af hvordan jeg for den page som er blevet valgt sidst til at være selected i dropdownboksen?
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Editpage extends HttpServlet
{
// doPost is used to alter the content on the edit page
public void doPost (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
String page = request.getParameter("page");
System.out.println(page);
if (page == null) {
page = "start";
}
out = response.getWriter();
response.setContentType("text/html");
Databaseforbindelsemysql d = new Databaseforbindelsemysql("jdbc:mysql://URL/DB?user=USER","org.gjt.mm.mysql.Driver");
try {
ResultSet rs = d.select("SELECT content FROM pages WHERE name = '"+page+"'");
if (rs.next())
{
String content = rs.getString("content");
out.println("<HTML><HEAD><TITLE></TITLE>");
out.println("<link rel='stylesheet' type='text/css' href='../style/styles.css'>");
out.println("</head>");
out.println("<BODY>");
out.println("<div class='margin1'>");
out.println("<form method='post' name='form' action='Editpage' style='display:inline;'>");
out.println("<select name='page'>");
out.println("<option value='start'>Start");
out.println("<option value='news'>News");
out.println("<option value='mrtls'>the Mrtls");
out.println("<option value='credit'>Credit");
out.println("<option value='contact'>Contact");
out.println("</select>");
out.println("<input type='submit' class='button1' name='Vis' value='Vis'>");
out.println("</form>");
out.println("<form method='post' name='form' action='Edit' style='display:inline;'>");
out.println("<input type='hidden' name='page' value='"+page+"'>");
out.println("<textarea name='content' cols='75' rows='15'>");
out.println(content);
out.println("</textarea><br>");
out.println("<input type='submit' class='button1' name='Update' value='Update'>");
out.println("</div>");
out.println("</form>");
out.println("</BODY></HTML>");
}
else
{
System.out.println("No records in resultset");
}
} catch (SQLException s) {
out.println("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
out.close();
d.close();
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
}
}
