namishtiwari
Posts: 1
|
Posted: 11/12/2008, 4:47 AM |
|
I dont have any idea about jsp or java but i have to do some coding part in it.
i tried to develop a sample jsp page that will take the values and will upload it in database.
I am not getting the proper output, i am also not sure i am on the right direction to do it.I need some help in this regard.
kindly help me in achieving the proper output..
the output should be--
when i click on the submit button the inputs which i enter should be saved in the database.
I am using oracle as db and using netbeans to do this.
<%--
Document : index
Created on : Nov 10, 2008, 5:59:35 PM
Author : namish
--%>
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h2>Hello World!</h2>
<%-- start web service invocation --%><hr/>
<%
Connection conn = null;
try {
Class c = Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (Exception e) {
System.out.println("Error occurred " + e);
}
try {
conn = DriverManager.getConnection("jdbc:oracle:thin:nameesh/dost1234@(description=(address_list=(address=(protocol=tcp) (host=arcot-w2kts01)(port=1521))) (source_route=yes)(connect_data=(sid=ts)))");
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
String userName=" ";
String groupName=" ";
String firstName=" ";
String lastName=" ";
String pam=" ";
String emailAddress=" ";
try {
com.arcot.schemas.regfort.v2.AuthProvisionAPIService service = new com.arcot.schemas.regfort.v2.AuthProvisionAPIService();
com.arcot.schemas.regfort.v2.RegFortAPIPortType port = service.getRegFortAPISOAP11Port();
port.createUser(userName, groupName, firstName, lastName, pam, emailAddress);
} catch (Exception ex) {
// TODO handle custom exceptions here
}
%>
<form action="response.jsp" method="POST">
<table>
<tr><td>User Name</td><td><input type="text" name="userName" value="" /></td></tr><br></br>
<tr><td>Group Name</td><td><input type="text" name="groupName" value="" /></td></tr><br></br>
<tr><td>First Name</td><td><input type="text" name="firstName" value="" /></td></tr><br></br>
<tr><td>Last Name</td><td><input type="text" name="lastName" value="" /></td></tr><br></br>
<tr><td>PAM</td><td><input type="text" name="pam" value="" /></td></tr><br></br>
<tr><td>Email Address</td><td><input type="text" name="emailAddress" value="" /></td></tr>
<tr><td><input type="submit" name="submit" value="submit"/></td></tr>
</table>
</form>
<%-- end web service invocation --%><hr/>
</body>
</html>
i will be very thankfull for any help in this regard.
Thanks
NT
_________________
nt |