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 ]
scriptlet tag was missing)
