Hello, I am trying to input data into a mySQL database using a
JSP but when I run it through localhost I am getting an error saying- root cause java.lang.NullPointerException.
Dose anyone know what the problem is. I have put my code that is causing the problem below. Its taking in the information from another page alright. It just wont write it to the table. Any feedback would be much appreciated.
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%
Class.forName("org.gjt.mm.mysql.Driver");
String strUrl = "jdbc:mysql://localhost/niall";
Connection conn=DriverManager.getConnection (strUrl, "root", "password");
Statement stmt=conn.createStatement();
Connection con = null;
%>
<% // Fetch the form data
String into = request.getParameter("name");
// save info into the user's session
session.setAttribute("name", into);
//out.println(into); //It prints out here alright so it has takin in the information
String template = "INSERT INTO
test (name) VALUE(?)";
PreparedStatement pstmt = con.prepareStatement(template);
pstmt.setString(1, into);
pstmt.executeUpdate();
if (pstmt!=null) pstmt.close();
if (con!=null) con.close();
%>
</li>
