You have to build query after reading the values from request.
<%
//Declare your variables;
String driver = "org.gjt.mm.mysql.Driver";
String connect = "jdbc:mysql://127.0.0.1/userinfo";
String idnum = request.getParameter("idnum");
// Read all other params in the same way
String query = "insert into info values('" +
idnum + "','" + fname + "','" + lname + "','" +
addr1 + "','" + addr2 + "','" + city + "','" +
state + "','" + zip + "','" + phone1 + "')";
Class.forName(driver);
Connection con = DriverManager.getConnection(connect);
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery(query);%>
%>
> -----Ursprüngliche Nachricht-----
> Von: John Elia [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 21. Dezember 2000 14:51
> An: [EMAIL PROTECTED]
> Betreff: my jsp updates with null values.
>
>
> This code is inserting NULL values into a mysql database. It
> is taking the
> values from an HTML form, and should just insert the values.
>
> Please Help.
>
> <%@page import="java.sql.*,javax.servlet.http.HttpServletRequest" %>
> <%!
> //Declare your variables;
> String DRIVER = "org.gjt.mm.mysql.Driver";
> String CONNECT = "jdbc:mysql://127.0.0.1/userinfo";
> String QUERY = "insert into info
> values('"+idnum+"','"+fname+"','"+lname+"','"+addr1+"','"+addr
> 2+"','"+city+"
> ','"+state+"','"+zip+"','"+phone1+"')";
> %>
> <%
> //some debug code to see what the values of these fields are... (not
> working)
> out.println(idnum);
> out.println(fname);
> out.println(lname);
> out.println(addr1);
> out.println(addr2);
> out.println(city);
> out.println(state);
> out.println(phone1);
> %>
>
> <% //get information from another page, and, if there is no
> information, set
> the values to NULL
>
> String idnum = request.getParameter("idnum");
> String fname = request.getParameter("fname");
> String lname = request.getParameter("lname");
> String addr1 = request.getParameter("addr1");
> String addr2 = request.getParameter("addr2");
> String city = request.getParameter("city");
> String state = request.getParameter("state");
> String zip = request.getParameter("zip");
> String phone1 = request.getParameter("phone1");
>
> %>
>
>
> <% //Let's figure it out shall we?
> Class.forName(DRIVER);
> Connection con = DriverManager.getConnection(CONNECT);
> Statement stm = con.createStatement();
> ResultSet rs = stm.executeQuery(QUERY);
> %>
>
> <h4><br><b>WebDesk Development</b> USERINFO Database
> Accessed, INFO Table
> Results returned.</h4><br>
> <a href="JEInsert.jsp">Back to the Form</a>
> <BR><BR><BR>
>
>
>
