Displaying Date in jsp

View Answers

June 14, 2008 at 7:39 PM

Hi

form

<html>
<title>Insert into database</title>
<head>

<script type="text/javascript">

function validateForm(theForm){

if(theForm.userid.value==""){

//Please enter username

alert("Please enter User Name!");

theForm.userid.focus();

return false;

}
if(theForm.address.value==""){
//please enter passward
alert("Please enter Address!");
theForm.address.focus();
return false;
}

if(theForm.dob.value==""){
//please enter passward
alert("Please enter Date of birth!");
theForm.dob.focus();
return false;
}

return true;
}
</script>
</head>

<body>

<table border="1" width="50%" bgcolor="pink">
<tr>
<td width="100%">
<form method="POST" action="DateInsertAction.jsp" onsubmit="return validateForm(this);">

<h2 align="center">Insert Date into Database</h2>
<table border="1" width="100%">
<tr>
<td width="50%"><b>User Name:</b></td>
<td width="50%"><input type="text" name="userid" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Address:</b></td>
<td width="50%"><input type="test" name="address" size="50"/> </td>
</tr>
<tr>
<td width="50%"><b>Date of Birth:</b></td>
<td width="50%"><input type="test" name="dob" size="20"/> </td>
</tr>
</table>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></p>

</form>
</td>
</tr>
</table>

</body>

</html>

June 14, 2008 at 7:41 PM

insert action

<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>

<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String userid=request.getParameter("userid");
String address=request.getParameter("address");
DateFormat dformat = new SimpleDateFormat("dd-MM-yyyy");

try{
date = new java.util.Date();
s = dformat.format(date);
System.out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
int val = st.executeUpdate("insert userInform values('"+userid+"','"+address+"','"+s+"')");
con.close();
out.println("Successfully insert Date into database.");
out.println("<br/><a href=dateForm.jsp><b>Back to Register Form</b></a>");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}

%>

-----------------------------------------

Read for more information.

http://www.roseindia.net/jsp/

Thanks

Amardeep)