Forum:

jsp and jdbc

Greenhorn

Posts: 16

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi..I have jsp page call sucess.jsp. which is basically get data from a form and stors in database. In my all table i created Sequences to generate accountID and stuff. Now when write my sql query..for example:
Insert into('"+accountId_sequence.NEXTVAL+"','"+viral+"'...);
it gives me error that it can find variable call accountID_squence...
SO my question is how can i store data from a form using Sequence from jsp page..

<html>
<head>
<title>store data in database</title>
</head>
<%@ page import="java.sql.*" %>
<body>
<%
String userName= request.getParameter("userName");
String secretWord= request.getParameter("secretWord");
String firstName= request.getParameter("firstName");
String lastName= request.getParameter("lastName");
String address= request.getParameter("address");
String city= request.getParameter("city");
String state= request.getParameter("state");
String zipCode= request.getParameter("zipCode");
String accountId_seq;
String companyId_seq;
%>
<%
String connURL = "jdbc :-o	 racle:thin:@orca.csc.ncsu.edu:1521 :-o	 RCL";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager.getConnection(connURL, "vapatel","239873846");
stmt = conn.createStatement();
      
         stmt.executeUpdate (" INSERT INTO Accounts (accountID,firstName, lastName, mailAdress, Zipcode) VALUES ('"+firstName+"','"+lastName+"','"+address+"','"+zipCode+"')");
 stmt.executeUpdate(" INSERT INTO Password (Username, Password) VALUES ('"+userName+"','"+secretWord+"')");
         stmt.executeUpdate("INSERT INTO Region (zipCode, city, state) VALUES ('"+zipCode+"','"+city+"', '"+state+"')");
 stmt.close();  
         conn.close();

} catch (ClassNotFoundException e) {
System.err.println("Couldn't find the mm " + "database driver: "+ e.getMessage());
} catch (InstantiationException e) {
System.err.println(e.getMessage());
} catch (IllegalAccessException e) {
System.err.println(e.getMessage());
} catch (SQLException e) {
 System.err.println("SQL problem: " + e.getMessage());
 System.err.println("SQL state: " + e.getSQLState());
 System.err.println("Vendor error: " + e.getErrorCode());
} finally {
try {
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
System.err.println(e.getMessage());
}
}

%>
<h1>Thank You for registration</h1>
<h2>Please login</h2>
</body>
</html>

Praful Thakare

Ranch Hand

Posts: 645

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi virla
try this out
1)
Insert into.....("accountId_sequence.NEXTVAL"....)
i.e as accountId_sequence is defined in ur database give it in quotes !!!
or u can do this as well
2)
rs=stmt.executeQuery("select accountId_sequence.NEXTVAL from dual");
if(rs.next())
String accountId_seq=rs.getString(1);
and then ur insert stuff ...
Hope this helps u
cheers
Praful

[ March 19, 2003: Message edited by: Praful Thakare ]

All desirable things in life are either illegal, banned, expensive or married to someone else !!!

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?