JSP nullpointer exception
Hvad gør jeg galt her...er det mine request.setAttribute("liste", rs); og request.getAttribute("liste");...der ikke funker???<%@ page contentType="text/html;charset=windows-1252"%>
<%@ page language="java" import="java.sql.*, mypackage8.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>untitled</title>
</head>
<body>
<form action="MedlemsListeController" method="get">
<%
int medlemId;
String fornavn;
String efternavn;
String adresse;
String telefon;
String email;
String sportsgrene;
%>
<table cellspacing="0" bordercolor="red" cellpadding="0" border="1" width="100%" bgcolor="Silver">
<tr>
<td>ID</td><td>Fornavn</td><td>Efternavn</td><td>Adresse</td><td>Telefon</td><td>E-mail</td><td>Tilknyttet</td>
</tr>
<%
try
{
ResultSet res = (ResultSet)request.getAttribute("liste");
System.out.println("hej "+res);
while (res.next())
{
int i = 1;
medlemId = res.getInt(i++);
fornavn = res.getString(i++);
efternavn = res.getString(i++);
adresse = res.getString(i++);
telefon = res.getString(i++);
email = res.getString(i++);
sportsgrene = res.getString(i++);
%>
<tr>
<td><%=medlemId%></td><td><%=fornavn%></td><td><%=efternavn%></td><td><%=adresse%></td><td><%=telefon%></td><td><%=email%></td><td><%=sportsgrene%></td>
</tr>
<%
}
}
catch (SQLException e) {System.out.println(e);}
finally {}
%>
</table>
</form>
</body>
</html>
........................................................
package mypackage8;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
public class MedlemsListeController extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=windows-1252";
private ConnectionFacade2 connect;
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
connect = ConnectionFacade2.getInstance();
int medlemId;
String fornavn;
String efternavn;
String adresse;
String telefon;
String email;
String sportsgrene;
ResultSet rs = null;
String query = "SELECT * FROM Gren";
System.out.println(query);
try
{
rs = connect.executeQuery(query);
while (rs.next())
{
int i = 1;
medlemId = rs.getInt(i++);
fornavn = rs.getString(i++);
efternavn = rs.getString(i++);
adresse = rs.getString(i++);
telefon = rs.getString(i++);
email = rs.getString(i++);
sportsgrene = rs.getString(i++);
System.out.println(fornavn);
request.setAttribute("liste", rs);
}
}
catch (SQLException e)
{(e.printStackTrace());}
finally {}
}
}
Ideen er at MedlemsListeController skal hente info i database og sende det tilbage til MedlemsListe.jsp, der skal vise det....
på forhånd tak.
