QuestionAsk Questions?
View Answers
September 25, 2008 at 6:15 PM
Hi Dear,
Please Write clearly what is your requirement
and write your code also i can suggest you.
you are getting error on
request.getParameter(); its taking String parameter from other page may be that name is spelling mistake
so once again check your code.
thanks
Rajkumar
Please Write clearly what is your requirement
and write your code also i can suggest you.
you are getting error on
request.getParameter(); its taking String parameter from other page may be that name is spelling mistake
so once again check your code.
thanks
Rajkumar
September 25, 2008 at 11:03 PM
Dear Rajkumar,
Pl. tell me how to write the oracle query which is commented in ashok.jsp program.How should I pass request.getParameter or fname, lname, add,phones (from html input parameters), because it compiles, runs without any error but in the databse it is not stored.
-----------------------------------------------
Login.html
<html>
<form action="ashok.jsp" method="post">
First name:<input type="text" name="firstname"><br>
Last name: <input type="text" name="lastname"></br>
Address:<input type="text" name="address"><br>
Phone No:<input type="text" name="phone"></br>
<input type="submit" value="Submit">
</form>
</html>
------------------------------------------------------
ashok.jsp
<%@ page language="java" contentType="text/html"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%
String fname="",lname="",add="",phones="";
fname=request.getparameter("firstname");
lname=request.getparameter("lastname");
add=request.getparameter("address");
phones=request.getparameter("phone");
out.println(fname);//it prints the parameter correctly
out.println(lname);
out.println(add);
out.println(phones);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con="DriverManager.getConnection("jdbc:odbc:ashokdb","scott","tiger");
Statement st=con.createStatement();
//here How I should write in oracle so that all the parameters filled in the html is stored in the oracle database named ashoktable pl.?
st.executeUpdate("insert into ashoktable values(......);");
}catch(Exception e){}
%>
Pl. tell me how to write the oracle query which is commented in ashok.jsp program.How should I pass request.getParameter or fname, lname, add,phones (from html input parameters), because it compiles, runs without any error but in the databse it is not stored.
-----------------------------------------------
Login.html
<html>
<form action="ashok.jsp" method="post">
First name:<input type="text" name="firstname"><br>
Last name: <input type="text" name="lastname"></br>
Address:<input type="text" name="address"><br>
Phone No:<input type="text" name="phone"></br>
<input type="submit" value="Submit">
</form>
</html>
------------------------------------------------------
ashok.jsp
<%@ page language="java" contentType="text/html"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%
String fname="",lname="",add="",phones="";
fname=request.getparameter("firstname");
lname=request.getparameter("lastname");
add=request.getparameter("address");
phones=request.getparameter("phone");
out.println(fname);//it prints the parameter correctly
out.println(lname);
out.println(add);
out.println(phones);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con="DriverManager.getConnection("jdbc:odbc:ashokdb","scott","tiger");
Statement st=con.createStatement();
//here How I should write in oracle so that all the parameters filled in the html is stored in the oracle database named ashoktable pl.?
st.executeUpdate("insert into ashoktable values(......);");
}catch(Exception e){}
%>
September 26, 2008 at 12:10 AM
Hi Krishna
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Statement"%><%
String fname= request.getParameter("firstname");
String lname="";
String add = "";
String phone = "";
//do your code here
//.............
//................
Connection con = DriverManager.getConnection("","","");
String query = "INSERT INTO ashoktable values(?,?,?,?)";
PreparedStatement pst = con.prepareStatement(query);
pst.setString(1,fname);
pst.setString(2,"");
pst.setString(3,"");
pst.setString(4,"");
pst.executeUpdate();
//OR this way alos
//String query1 = "INSERT INTO ashoktable values("+fname+"," +lname+"," + add+","+ phone +")";
//Statement stmt = con.createStatement();
//stmt.executeUpdate(query1);
%>
Thanks
Rajanikant
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Statement"%><%
String fname= request.getParameter("firstname");
String lname="";
String add = "";
String phone = "";
//do your code here
//.............
//................
Connection con = DriverManager.getConnection("","","");
String query = "INSERT INTO ashoktable values(?,?,?,?)";
PreparedStatement pst = con.prepareStatement(query);
pst.setString(1,fname);
pst.setString(2,"");
pst.setString(3,"");
pst.setString(4,"");
pst.executeUpdate();
//OR this way alos
//String query1 = "INSERT INTO ashoktable values("+fname+"," +lname+"," + add+","+ phone +")";
//Statement stmt = con.createStatement();
//stmt.executeUpdate(query1);
%>
Thanks
Rajanikant
September 26, 2008 at 3:22 PM
Dear Rajanikanth,
thank you very much for posting the answer.
Now the code is working.
thanks a lot.
thank you very much for posting the answer.
Now the code is working.
thanks a lot.
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
