Date.jsp
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<form action="show.jsp" method="post">
<table border="1" bgcolor="pink" bordercolor="green">
<tr>
<td>Name:<input type="text" name="name"/></td>
</tr>
<tr>
<td>Select Date: (YYYY)</td><td><select name="year">
<option value="">--Select--</option>
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option> </select></td>
<td>MM</td><td><select name="month">
<option value="">--Select--</option>
<option value="01">jan</option>
<option value="02">Feb</option>
<option value="03">March</option>
<option value="04">April</option> </select></td>
<td>DD</td><td><select name="day">
<option value="">--Select--</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option></select></td>
</tr>
<tr>
<td colspan="6" align="center"><input type="submit" name="submit" value="submit"/></td>
</tr>
</form>
</body>
</html>
Show.jsp
<%@page import="java.text.SimpleDateFormat"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*,java.util.*,java.text.*"%>
<%
String nm=request.getParameter("name");
String year=request.getParameter("year");
String month=request.getParameter("month");
String day=request.getParameter("day");
String ddd=year+"/"+month+"/"+day;
//String d1=year+month+day;
out.println("year is"+year);
out.println("name is"+nm);
//java.sql.Date date=new java.sql.Date(0000-00-00);
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","ims");
PreparedStatement ps=con.prepareStatement("insert into tbl_date(name,DOB) values(?,?)");
ps.setString(1,nm);
//ps.setDate(2,date.valueOf(d1));
ps.setString(2,ddd);
int i=ps.executeUpdate();
if(i==1)
{
out.println("Date success");
}
else
{
out.println("problem while inserting");
}
}
catch(Exception e)
{
out.println(" "+e.getMessage());
}
%> Aryantech pune
No comments:
Post a Comment