<% java.sql.Connection db;
Class.forName( "org.gjt.mm.mysql.Driver").newInstance();
db = java.sql.DriverManager.getConnection (
"jdbc:mysql://****",
"****",
"*****"
);
int id = Integer.parseInt(request.getParameter("id"));
boolean oppdate = false;
if (request.getParameter("navn") != null && !oppdate){
String navn = request.getParameter("navn");
String email = request.getParameter("email");
String kommentar = request.getParameter("kommentar");
oppdate = true;
}
java.sql.Statement st = db.createStatement();
java.sql.ResultSet rs;
String sp4 = "insert into kommentar (innlegg_id,kommentar,dato,navn,email) values (id,kommentar,dato,navn,email)" ;
st = db.createStatement();
rs = st.executeQuery(sp4);
java.sql.Statement st1 = db.createStatement();
java.sql.ResultSet rs1 ;
String sp5 = "select * from innlegg where innlegg_id="+id ;
st1 = db.createStatement();
rs1 = st1.executeQuery(sp5);
rs1.next();
String tittle = rs1.getString ("oversikt");
String dato = rs1.getString ("dato");
String innlegg = rs1.getString ("innlegg");
java.sql.Statement st2 = db.createStatement ();
java.sql.ResultSet rs2;
String sp6 = "select kommentar from kommentar where innlegg_id="+id+"order by dato";
st2 = db.createStatement();
rs2 = st2.executeQuery(sp6);
while (rs2.next()){
String name = rs2.getString("navn");
String date = rs2.getString("dato");
innlegg = rs2.getString("innlegg");
out.println(name);
out.println(dato);
out.println(innlegg);
}
db.close();
%><form action = "kommentar.jsp?id=<%=id%>" method = "post" >
<h3> Skriv ny kommentar </h3>
<p>
Navn: <input type = "text" name = "navn" size = "30">
</p>
<p>
Email: <input type = "text" name = "email" value = " @ " size = "40">
</p>
<p>
Kommentar : <textarea name = " kommentar " row = "15" cols = "50"></textarea>
</p>
<p>
<input type = "submit" value = "submit">
</p>
</form>运行出现以下错误
500 Servlet Exceptionjava.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Integer.java:436)
at java.lang.Integer.parseInt(Integer.java:518)
at _lichao._kommentar__jsp._jspService(/lichao/kommentar.jsp:11)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:486)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.http.security.SecurityFilter.doFilter(SecurityFilter.java:115)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:311)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:218)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:160)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:534)不知道 为什么会出现这个问题
我把表格中的?id=<%=id%> 去掉 还是会出现这样的问题请教各位大虾
Class.forName( "org.gjt.mm.mysql.Driver").newInstance();
db = java.sql.DriverManager.getConnection (
"jdbc:mysql://****",
"****",
"*****"
);
int id = Integer.parseInt(request.getParameter("id"));
boolean oppdate = false;
if (request.getParameter("navn") != null && !oppdate){
String navn = request.getParameter("navn");
String email = request.getParameter("email");
String kommentar = request.getParameter("kommentar");
oppdate = true;
}
java.sql.Statement st = db.createStatement();
java.sql.ResultSet rs;
String sp4 = "insert into kommentar (innlegg_id,kommentar,dato,navn,email) values (id,kommentar,dato,navn,email)" ;
st = db.createStatement();
rs = st.executeQuery(sp4);
java.sql.Statement st1 = db.createStatement();
java.sql.ResultSet rs1 ;
String sp5 = "select * from innlegg where innlegg_id="+id ;
st1 = db.createStatement();
rs1 = st1.executeQuery(sp5);
rs1.next();
String tittle = rs1.getString ("oversikt");
String dato = rs1.getString ("dato");
String innlegg = rs1.getString ("innlegg");
java.sql.Statement st2 = db.createStatement ();
java.sql.ResultSet rs2;
String sp6 = "select kommentar from kommentar where innlegg_id="+id+"order by dato";
st2 = db.createStatement();
rs2 = st2.executeQuery(sp6);
while (rs2.next()){
String name = rs2.getString("navn");
String date = rs2.getString("dato");
innlegg = rs2.getString("innlegg");
out.println(name);
out.println(dato);
out.println(innlegg);
}
db.close();
%><form action = "kommentar.jsp?id=<%=id%>" method = "post" >
<h3> Skriv ny kommentar </h3>
<p>
Navn: <input type = "text" name = "navn" size = "30">
</p>
<p>
Email: <input type = "text" name = "email" value = " @ " size = "40">
</p>
<p>
Kommentar : <textarea name = " kommentar " row = "15" cols = "50"></textarea>
</p>
<p>
<input type = "submit" value = "submit">
</p>
</form>运行出现以下错误
500 Servlet Exceptionjava.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Integer.java:436)
at java.lang.Integer.parseInt(Integer.java:518)
at _lichao._kommentar__jsp._jspService(/lichao/kommentar.jsp:11)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:486)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.http.security.SecurityFilter.doFilter(SecurityFilter.java:115)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:311)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:218)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:160)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:534)不知道 为什么会出现这个问题
我把表格中的?id=<%=id%> 去掉 还是会出现这样的问题请教各位大虾
这个地方request.getParameter("id")获得值为空,好好检查下你的参数名称对不