Results 1 to 2 of 2
LinkBack URL
About LinkBacks- 11-17-2011, 07:04 AM #1
Member
- Join Date
- Sep 2011
- Posts
- 9
- Rep Power
- 0
error occured:-java.lang.NullPointerException
Here is my code:-
<%@ page import="java.sql.*" %>
<%
String payer = request.getParameter("payer");
String payment = request.getParameter("payment");
String date = request.getParameter("date");
String details = request.getParameter("details");
String[] vals = request.getParameterValues("all");
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@172.16.2.48:1521:DIANAPRD", "difbank", "difbank");
PreparedStatement ps=conn.prepareStatement("INSERT INTO p_city VALUES (?,?,?,?,?)");
ps.setString(1,payer );
ps.setString(2,payment );
ps.setString(3,date );
for (String val : vals)
{ ps.setString(4, val);
}
ps.setString(5,details);
ps.execute();
ps.close(); %>
<html>
<center>
<body>
<b>Successfully inserted expenditure.You want to insert another expenditure pls click</b>
<a href = "C:\workspace\HouseManagement\WebContent\ExpendInf o.jsp"><b>INFORMATION FILL</b></a>
</body>
</center>
</html>
<%}
catch(Exception e)
{
out.println("error occured:-"+e);
} %>
please tell me where I hv mistaken.
- 11-17-2011, 02:54 PM #2
Moderator
- Join Date
- Apr 2009
- Posts
- 10,438
- Rep Power
- 16
Re: error occured:-java.lang.NullPointerException
Your mistake is putting Java code into a JSP.
That code should be in a servlet or, since it's all to do with DB access, in a data layer that the servlet calls.
The JSP should simply be for displaying the result forwarded on by that servlet.
Reply With QuoteSimilar Threads
-
java.lang.NullPointerException Error
By Manfizy in forum NetBeansReplies: 3Last Post: 02-24-2011, 06:27 AM -
Please solve my error occured java.lang.NullPointerException
By Viruthagiri in forum JavaServer Pages (JSP) and JSTLReplies: 1Last Post: 03-24-2010, 12:08 PM -
Please solve my java.lang.NullPointerException error.?
By Viruthagiri in forum JavaServer Pages (JSP) and JSTLReplies: 0Last Post: 03-23-2010, 09:30 PM -
Thread: Error 500--Internal Server Error java.lang.NullPointerException
By jackdear44 in forum New To JavaReplies: 1Last Post: 12-05-2009, 07:28 AM -
Error Java.lang.NullPointerException in JBuilder2006
By Jack in forum Other IDEsReplies: 2Last Post: 07-02-2007, 02:29 AM
Bookmarks