...

View Full Version : need a little bit of help :)



random1988
01-07-2012, 06:55 PM
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/article.php?file=Article-EclipseDbWebapps/index.html



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum