DaniWeb Forum Index > Web Development > JSP

how to connect with oracle in this code

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2007

Posts: 49

Reputation: larryperl is an unknown quantity at this point

Solved Threads: 0

larryperl

Offline

Light Poster

how to connect with oracle in this code

Nov 10th, 2008

Hi Everyone,

I need some suggestions from you guys. I am totally unaware of JSP or java and trying to learn a bit , as i need to develop a sample application using web services.I am in need of some help from you guys. If there are some errors in the code or i can modify for the better then please tell me.Please explain the things as i am a layman..

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<%@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/>
    <%
 
        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>Submit</td><td><input type="submit" name="submit" value="submit"/></td></tr>
</table> 
</form>
    <%-- end web service invocation --%><hr/>    
    </body>
</html>
<%@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/>
    <%
    
        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>Submit</td><td><input type="submit" name="submit" value="submit"/></td></tr>
</table> 
</form>
    <%-- end web service invocation --%><hr/>    
    </body>
</html>

I am using netbeans here.

now what i need to do is----

when i click on the submit button the entries should be updated in the database, how i can achieve that. syntax for database connection. i am using oracle as DB.
kindly give me some ideas how to go about this...

Thanks
NT

•

Join Date: Dec 2004

Posts: 4,273

Reputation: peter_budo has much to be proud of

Solved Threads: 494

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: how to connect with oracle in this code

-1

Nov 10th, 2008

Read this how to establish connection with database the right way and here is info on Oracle and connection string (Sorry couldn't find latest version)

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group