servlet (problem med vinduer)
Hej EksperterHej har en klasse som jeg bruger til at editerer i min database
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&password=PASS","org.gjt.mm.mysql.Driver");
try {
ResultSet rs = d.select("SELECT content,content1 FROM pages WHERE name = '"+page+"'");
if (rs.next())
{
String content = rs.getString("content");
String content1 = rs.getString("content1");
out.println("<HTML><HEAD><TITLE></TITLE>");
out.println("<link rel='stylesheet' type='text/css' href='../style/styles.css'>");
out.println("<style type='text/css'>");
out.println("body{ margin: 80px,0px,0px,0px;}");
out.println("</style>");
out.println("</head>");
out.println("<body onload='self.focus();' bgcolor='#000000'>");
out.println("<center>");
out.println("<table border='1' style='width:700px;' cellpadding=0' cellspacing='0'><tr style='height:30px;'><td>");
out.println("<form method='post' name='editpage' action='Editpage' style='display:inline;'>");
out.println("<select name='page' onChange='document.editpage.submit();'>");
out.println("<option value='start' "+(page.equals("start")?"Selected":"")+">Start");
out.println("<option value='news' "+(page.equals("news")?"Selected":"")+">News");
out.println("<option value='mrtls' "+(page.equals("mrtls")?"Selected":"")+">the Mrtls");
out.println("<option value='credit' "+(page.equals("credit")?"Selected":"")+">Credit");
out.println("<option value='contact' "+(page.equals("contact")?"Selected":"")+">Contact");
out.println("</select>");
out.println("</form>");
out.println("</td></tr>");
if(page.equals("news")){
ResultSet rsnews = d.select("SELECT * FROM news ORDER BY id DESC");
out.println("<tr><td>");
//,'newentry', 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=no,copyhistory=yes,height=400,width=750,top=150,left=100,screenY=150,screenX=100')\"
out.println("<input type='button' class='button1' value='New entry' onclick=\"window.open('../index/editnews.html')\">");
out.println("<table border='1' style='width:100%;' cellpaddig='0' cellspacing='0'>");
while(rsnews.next()) {
int id = rsnews.getInt(1);
String date = rsnews.getString(2).replaceAll("\n","<BR>");
String news = rsnews.getString(3).replaceAll("\n","<BR>");;
out.println("<tr><td class='celltext' style='width:30%;'>");
out.println(date);
out.println("</td><td class='celltext' style='width:60%;'>");
out.println(news);
out.println("</td><td style='width:10%;vertical-align:top;text-align:right;'>");
out.println("<form method='post' name='delnews"+id+"' action='Edit' style='display:inline;'>");
out.println("<input type='hidden' name='page' value='news'>");
out.println("<input type='hidden' name='newsid' value='"+id+"'>");
out.println("<input type='hidden' name='doedit' value='delete'>");
out.println("<input type='button' class='button1' name='delete' value='Delete' onClick='document.delnews"+id+".submit();'>");
out.println("</form>");
out.println("</td></tr>");
}
out.println("</table>");
}
else
{
out.println("<tr><td>");
out.println("<form method='post' name='form' action='Edit' style='display:inline;'>");
out.println("<table border='0' cellspacing='0' cellpadding='0'><tr><td>");
out.println("<input type='hidden' name='page' value='"+page+"'>");
out.println("<textarea name='content' cols='42' rows='13'>");
out.println(content);
out.println("</textarea>");
out.println("</td><td>");
out.println("<input type='hidden' name='page' value='"+page+"'>");
out.println("<textarea name='content1' cols='42' rows='13'>");
out.println(content1);
out.println("</textarea>");
out.println("</td></tr></table>");
out.println("<input type='submit' class='button1' name='Update' value='Update'>");
out.println("</form>");
}
out.println("</td></tr></table>");
out.println("</center>");
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
{
}
}
Mit problem er at hvis page=news, så skal der komme en knap som henviser til en form hvor man kan skrive news ind. Tingen er bare at jeg så åbner et nyt vindue. Det vil jeg gerne undgå.
Hvis jeg ikke er præcis nok i min beskrivelse af problemet kan give URL'en så I kan se det :-)
