Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    Jan 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    need a little bit of help :)

    hey guys

    m new here for my project as we have chosen to build a website using eclipse and derby database and m trying to run it in apache 6.0.35 and i am facing some small problems like the control is not passing through the if statement it directly gives the alert and i needed a little bit of help in figuring out what i am doing

    this is my code i am trying 2 create

    <%@ page language="java" contentType="text/html; charset=ISO-8859-1"%>

    <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

    <sql:setDataSource dataSource="jdbc/SampleDB" />
    <!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=ISO-8859-1">
    <title>Registration Page</title>
    <style>
    form {
    width: 400px;
    }

    label {
    float: left;
    width: 120px;
    }

    input[type=text] {
    float: left;
    width: 250px;
    }

    .clear {
    clear: both;
    height: 0;
    line-height: 0;
    }

    .floatright {
    float: right;
    }

    body {
    background: red;
    }
    </style>
    <script type="text/javascript">
    function error() {
    alert("Please provide all details!");
    }
    </script>
    <script type="text/javascript">
    function reset() {
    alert("Details have Been Reset!");
    }
    </script>
    </head>
    <body>

    <center>
    <h1>Registration Page</h1>
    </center>
    <hr>

    <div style="position: absolute; top: 200px; right: 500px;">

    <form>

    <b> <label for="Name">Name:</label> <input
    type="text" name="name" /><br /> <br /> <label
    for="Address">Address:</label> <input type="text"
    name="addr" /><br /> <br /> <br /> <label for="Contact Person">Contact
    Person:</label> <input type="text" name="coperson" /><br /> <br /> <label
    for="Contact Number">Contact Number:</label> <input type="text"
    name="conumber" /><br /> <br /> <label for="Email-Id">Email-Id:</label>

    <input type="text" name="email" /><br />

    </b> <br /> <br /> <br /> <input type="submit" name="action"
    value="Submit" /><input type="Reset" onclick="reset()" /><br />



    </form>
    </div>
    <c:set var="coname" value="${param.name}" />
    <c:set var="coaddr" value="${param.addr}" />
    <c:set var="coperson" value="${param.coperson}" />
    <c:set var="conumber" value="${param.conumber}" />
    <c:set var="email" value="${param.email}" />


    <c:if test="${param.action == 'Submit'}">
    <c:choose>
    <c:when
    test="${not empty name and not empty addr and not empty coperson and not empty conumber and not empty email}">
    <sql:update>
    INSERT INTO app1.posts(Name,Address,ContactPerson,ContactNumber,EmailID) VALUES(?,?,?,?,?)
    <sql: param value="${name}" />
    <sql: param value="${addr}" />
    <sql: param value="${coperson}" />
    <sql: param value="${conumber}" />
    <sql: param value="${email}" />
    </sql:update>
    <c:set var="msg" value="Thank you. Details saved. " />
    <c:set var="name" value="" />
    <c:set var="addr" value="" />
    <c:set var="coperson" value="" />
    <c:set var="conumber" value="" />
    <c:set var="email" value="" />
    </c:when>
    <c: otherwise>
    <script>
    alert("Please provide all details.!");
    </script>
    </c: otherwise>
    </c:choose>
    </c:if>
    </body>
    </html>

    and this is the table i have created in derby database

    CREATE TABLE app1.posts(
    post_id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
    name varchar(45),
    address varchar(75),
    contactperson varchar(40),
    contactnumber varchar(15),
    emailid varchar(35)
    );

    i was referring to this link on how to create a database application

    http://www.eclipse.org/articles/arti...pps/index.html
    Last edited by random1988; 01-08-2012 at 11:14 AM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •