File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes help needed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "help needed" Watch "help needed" New topic
Author

help needed

mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
hi guys here...igot a minor problem and im sure you guys will easily figure it out..coz im new to programming...
currently i just wan a simple form that can store datas into an oracle database called toad.i hav simply 2 pages, one is appsform.jsp and the other is appsdata.jsp

but i cant seem to put those values into the toad table in the database..can u guys help me figure out wads wrong?

appsform.jsp
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>


<html>
<body>
<br>
<center>
<p>
<u><b><font size="5">For Applicating DepartMent</font></b></u>
</p>
<form method="post" action="appsdata.jsp" >
<table border="0">
<tr>
<td>Employee's Full name</td>
<td>
<input name="employee_name" value="" size="30"/>
</td>
</tr>
<tr>
<td>Employee's number</td>
<td>
<input name="employee_number" value="" size="30"/>
</td>
</tr>
<tr>
<td>Department</td>
<td>
<input name="department" value="" size="30"/>
</td>
</tr>
<tr>
<td>Designation</td>
<td>
<input name="desgination" value="" size="30"/>
</td>
<tr>
<td>Telephone Extension</td>
<td>
<input name="telephone_extension" value="" size="30"/>
</td>
<tr>
<td>Name of Superior</td>
<td>
<input name="name_of_superior" value="" size="30"/>
</td>
<tr>
<td>Account Effect Date</td>
<td>
<input name="account_effective_date" value="" size="30"/>
</td>


<tr>
<td>Domain Access (Yes/No): </td>


<tr>
<td>Shared Drive (S):</td>
<td>
<input type="radio" name="shared_drive_flag" value="yes">Yes
<input type="radio" name="shared_drive_flag" value="no">No
</td>

<tr>
<td>Department Drive (G):</td>
<td>
<input type="radio" name="dept_drive_flag">Yes
<input type="radio" name="dept_drive_flag">No
</td>
<tr>
<td>Other Drives</td>
<td>
<input type="radio" name="other_drive_flag">Yes
<input type="radio" name="other_drive_flag">No
</td>


<tr>
<td></td>
<td>If yes, pls state: <input name="other_drives" value="" size="30"/></td>

<tr>
<tr>
<td>Kermit System</td>
<td>
<input type="radio" name="kermit_access_flag">Yes
<input type="radio" name="kermit_access_flag">No
</td>
<tr>
<tr>
<td>Internet Access</td>
<td>
<input type="radio" name="internet_access_flag">Yes
<input type="radio" name="internet_access_flag">No
</td>
<tr>
<tr>
<td>Email Account</td>
<td>
<input type="radio" name="email_flag">Yes
<input type="radio" name="email_flag">No
</td>
<tr>
<tr>
<td>Oracle Account</td>
<td>
<input type="radio" name="oracle_flag">Yes
<input type="radio" name="oracle_flag">No
</td>
<tr>
<tr>
<td>Discoverer Account</td>
<td>
<input type="radio" name="discoverer_flag">Yes
<input type="radio" name="discoverer_flag">No
</td>
<tr><tr>
<td>*Remote Access to office network</td>
<td>
<input type="radio" name="remote_access_flag">Yes
<input type="radio" name="remote_access_flag">No
</td>

<tr>
<td>Requested By:</td>
<td>
<input name="requested_by" value="" size="30"/>
</td>
<tr>
<td>Request Date</td>
<td>
<input name="request_date" value="" size="30"/>
</td>

</table>


<br>
<input type="submit" value="Submit"/>
<input type="reset" value="Clear"/>
</form>
</center>
</body>
</html>


appsdata.jsp

<%@ page language="java"%>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>

<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;


String employee_name=request.getParameter("employee_name");
String employee_number=request.getParameter("employee_number");
String department=request.getParameter("department");
String designation=request.getParameter("designation");
String telephone_extension=request.getParameter("telephone_extension");
String name_of_superior=request.getParameter("name_of_superior");
String account_effective_date=request.getParameter("account_effective_date");
String shared_drive_flag=request.getParameter("shared_drive_flag");
String dept_drive_flag=request.getParameter("dept_drive_flag");
String other_drive_flag=request.getParameter("other_drive_flag");
String other_drives=request.getParameter("other_drives");
String kermit_access_flag=request.getParameter("kermit_access_flag");
String internet_access_flag=request.getParameter("internet_access_flag");
String email_flag=request.getParameter("email_flag");
String oracle_flag=request.getParameter("oracle_flag");
String discoverer_flag=request.getParameter("discoverer_flag");
String remote_access_flag=request.getParameter("remote_access_flag");
String requested_by=request.getParameter("requested_by");
String requested_date=request.getParameter("requested_date");

String querytext = "INSERT INTO sshl_account_application VALUES('"+employee_name+"','"+employee_number+"','"+department+"','"+designation+"','"+telephone_extension+"','"+name_of_superior+"','"+account_effective_date+"','"+shared_drive_flag+"','"+dept_drive_flag+"','"+other_drive_flag+"','"+other_drives+"','"+kermit_access_flag+"','"+internet_access_flag+"','"+email_flag+"','"+oracle_flag+"','"+discoverer_flag+"','"+remote_access_flag+"','"+requested_by+"','"+requested_date+"')";



try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc racle:thin:@15.12.88.202:1522:test", "apps", "apps");
stmt = con.createStatement();
rs = stmt.executeQuery(querytext);
} catch (Exception e) {


%>

<%@ include file="fail.jsp"%>

<%

}

response.sendRedirect("success.jsp");

%>
[ July 30, 2004: Message edited by: Bear Bibeault ]
Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
Hi,

Print ur querytext before calling executeQuery(). Just see whether the insert string formed is correct or not.
Also add a line e.printStackTrace() in ur exception block.
Hope u will get a solution after this.

----
Atul
Pranit Saha
Ranch Hand

Joined: Sep 09, 2001
Posts: 130
It'll be easier to figure out the error if you specify what problem you are facing.. Coding seems to be all rite..

Pranit..
mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
thx guys..atul i will try use ur method ltr..thx a lot..
the problem im facing rite now is that...when i enter values in the form and click submit, it can process to the page called success.jsp but when i look at the toad database, the table is empty...

any ideas?
Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
Hi Mary,

This is just a wild guess. Hope this solves ur problem.




w.r.t to ur code if there is a exception it would include fail.jsp content into ur current jsp page.
But just after the exception block u have given response.sendRedirect(). So even if there is a exception the code would redirect it to success.jsp.
Try placing response.sendRedirect() in the try block.

Hope this works.

---
Atul
mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
thx guys sorry, sorry for late reply..i've been tired trying all the solutions but to no avail...is toad oracle database doesnt evolve in a full blown jdbc components like one guy says or isit tt my codes aint right?

help needed...
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60996
    
  65

Moving to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
Hi Mary,

Did u try placing response.sendRedirect()in the try block. Or did u write a println statement in the exception block. There is problem in the code. Please do try this.U cant just blindly say the codes not working, u have to try all posssible combination.

---
Atul
Sonny Gill
Ranch Hand

Joined: Feb 02, 2002
Posts: 1211

Hi Mary,

What you need to do is try to narrow down where the problem may be. Put some 'System.out.print' statements to see whether the correct parameters are being passed, whether any exceptions are being thrown etc.

Put an exception.printStackTrace(System.out) in your catch block, so you know what exceptions if any are being thrown. If everything else is ok, and only the database is not being updated, you could be getting a SQLException


The future is here. It's just not evenly distributed yet. - William Gibson
Consultant @ Xebia. Sonny Gill Tweets
mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
hi atul,

u mean this? placing system.out.println(request.getparameter("Employee_name")); {




try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc racle:thin:@15.12.88.202:1522:test", "apps", "apps");
stmt = con.createStatement();
rs = stmt.executeQuery(queryText);
} catch (Exception e)
system.out.println(request.getparameter("Employee_name")); {


im not good at this..pls correct me or excuse me..
mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
hi sonny,

u mean placing this exact statement?


try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc racle:thin:@15.12.88.202:1522:test", "apps", "apps");
stmt = con.createStatement();
rs = stmt.executeQuery(querytext);
} catch (Exception e)
exception.printStackTrace(System.out){
Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
Hi Mary,

Could u please replace your code by the one as given below :

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc racle:thin:@15.12.88.202:1522:test", "apps", "apps");
stmt = con.createStatement();
rs = stmt.executeQuery(querytext);
response.sendRedirect("success.jsp");

} catch (Exception e) {

e.printStackTrace();
%>

<%@ include file="fail.jsp"%>

<%

}

This should work. Please check if there are any error messages in the back end.If there is any exception please do inform.

Regards
Atul
mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
hi atul,


try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc racle:thin:@15.12.88.202:1522:test", "apps", "apps");
stmt = con.createStatement();
rs = stmt.executeQuery(querytext);
response.sendRedirect("success.jsp");

} catch (Exception e) {

e.printStackTrace();
%>

<%@ include file="fail.jsp"%>

}


i got these errors, it seems i cant capture any data from the form as i use a println statement..it shows a blank page...

Line 119 '}' expected. }

Line 120 'try' without 'catch' or 'finally'. private static class __jsp_StaticText {

Line 120 Statement expected. private static class __jsp_StaticText {
Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
Hi Mary,

Try this code scriptlet tag was missing)

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc racle:thin:@15.12.88.202:1522:test", "apps", "apps");
stmt = con.createStatement();
rs = stmt.executeQuery(querytext);
response.sendRedirect("success.jsp");

} catch (Exception e) {

e.printStackTrace();
%>

<%@ include file="fail.jsp"%>

<%
}
%>

Please inform if problem still exists.

Regards
Atul
mary bate
Greenhorn

Joined: Jul 30, 2004
Posts: 12
hi atul,

theres this error, but i already declared rs..

Line 82 Undefined variable: querytext rs = stmt.executeQuery(querytext);

Connection con = null;
Statement stmt = null;
ResultSet rs = null;
Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
Hi,

Line 82 Undefined variable: querytext rs = stmt.executeQuery(querytext);

This is telling you that querytext is undefined. And not rs(Resultset).

Check whether you have declared querytext...

Note:
if you have any further problem i am online on yahoo (prabhu_atul@yahoo.com)You can buzz me.

Regards
Atul
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: help needed