QuestionAsk Questions?
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>
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)
<%@ 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)
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
