Hi Guyz,
Can some one post a JSP code to insert values
from an HTML Form to a SQL server table.
Am using Apache tomcat. am a new to jsp.
I will be glad.
u can send the Code can be sent to [email protected]

easy peasy. Ok, so suppose your form has a field - 'txtFirstName'. Here is the code you might use to enter that persons first name into the 'UserInfo' table using mysql.



...tagblibs for core and sql standard libraries...

<sql:update dataSource="...datasource for sql table">
INSERT INTO UserInfo (firstName) VALUES (?)
<sql:param value="${param.txtFirstName}" />
</sql:param>

<c:redirect url="success.jsp" />

:D

IronChef - http://www.freewebs.com/cool_recipes

.<%
String connectionURL = "jdbc:mysql://localhost:3306/xxx";
Class.forName("com.mysql.jdbc.Driver").newInstance ();
java.sql.Connection connection = java.sql.DriverManager.getConnection(connectionURL , "xxxx", "xxxx");

String strSQL_Select = "SELECT * FROM user WHERE username = '"+request.getParameter("username")+"'";

java.sql.Statement statement = connection.createStatement();

java.sql.ResultSet RS = statement.executeQuery(strSQL_Select);

int i = 0;
while (RS.next())
{
i++;
}

if (i == 0)
{

String query = "INSERT INTO user (username,password,address1,address2,city,postcode ,number,name,surname,email) VALUES (?,?,?,?,?,?,?,?,?,?)"; java.sql.PreparedStatement statement = connection.prepareStatement(query);
statement.setString(1,request.getParameter("userna me"));
statement.setString(2,request.getParameter("passwo rd"));
statement.setString(3,request.getParameter("addres s1"));
statement.setString(4,request.getParameter("addres s2"));
statement.setString(5,request.getParameter("city") );
statement.setString(6,request.getParameter("postco de"));
statement.setString(7,request.getParameter("number "));
statement.setString(8,request.getParameter("name") );
statement.setString(9,request.getParameter("surnam e"));
statement.setString(10,request.getParameter("email "));
statement.executeUpdate();

}
else
{
out.println("Username has been used!"); }

connection.close();
%>

----------------------------------------------------
I get an error

The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 74 in the jsp file: /ProcessInsertUser1.jsp Duplicate local variable statement
71: {
72:
73: String query = "INSERT INTO user (username,password,address1,address2,city,postcode ,number,name,surname,email) VALUES (?,?,?,?,?,?,?,?,?,?)";
74: java.sql.PreparedStatement statement = connection.prepareStatement(query);
75: statement.setString(1,request.getParameter("userna me"));
76: statement.setString(2,request.getParameter("passwo rd"));
77: statement.setString(3,request.getParameter("addres s1"));


Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.jav acError(DefaultErrorHandler.java:93)
org.apache.jasper.compiler.ErrorDispatcher.javacEr ror(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateCla ss(JDTCompiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:319)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:298)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:286)
org.apache.jasper.JspCompilationContext.compile(Js pCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)