i have a jsp page, from that i can insert date in database..



my form is working.. and my database accept the date in dd-MMM-yy

format...which is working,



but the prob is that it does not display in same pattern means dd-MMM-yy format.



i want to display date in dd-MMM-yy format.i.e 26-jan-04.



it displays date values in yyyy-mm-dd format.



help me.. my code is as follow:




<html>
<body>
<table>
<tr>
<td>

<%@ page import =" java.sql.Date.*" %>
<%@ page import =" java.text.SimpleDateFormat.*" %>
<%@ page import =" java.util.Date.*" %>
<%@ page import="java.text.*" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page language="java" import="java.sql.*" %>



<%
try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbcdbcf","scott","ttlscott");
System.out.println("got connection");

%>

<%

String action = request.getParameter("action");
if (action != null && action.equals("save")) {
conn.setAutoCommit(false);



String pattern = "dd/MM/yyyy";

SimpleDateFormat sdf = new SimpleDateFormat(pattern);
sdf.setLenient(false);




PreparedStatement pstmt = conn.prepareStatement(
("INSERT INTO pay_header VALUES (?, ?, ?, ?, ?, ?,?,?)"));

pstmt.setString(1,request.getParameter("vou_no"));
java.util.Date dt = sdf.parse(request.getParameter("pay_date"));
pstmt.setDate(2, new java.sql.Date(dt.getTime()));

char pay_post;
if (request.getParameter("pay_post") != null) {pay_post = 'Y';} else {pay_post = 'N';}
pstmt.setString(3,request.getParameter("pay_post"));
pstmt.setString(4,request.getParameter("pay_narr"));
pstmt.setString(5, request.getParameter("chq_no"));
java.util.Date dt1 = sdf.parse(request.getParameter("chq_date"));
pstmt.setDate(6, new java.sql.Date(dt1.getTime()));
pstmt.setFloat(7,Float.parseFloat(request.getParameter("chq_amt")));
pstmt.setString(8,request.getParameter("pay_type"));



pstmt.executeUpdate();
conn.commit();
conn.setAutoCommit(true);
}




%>


<%

Statement statement = conn.createStatement();


ResultSet rs = statement.executeQuery
("SELECT * FROM pay_header ");



%>

<table>
<tr>
<th>Code</th>
<th>Description</th>
<th>Dr. Amt</th>
<th>Cr. Amt</th>
<th>Type</th>
<th>Pct</th>
<th>Pct</th>
</tr>
<tr>
<form action="payment_save1.jsp" method="get">
<input type="hidden" value="save" name="action">
<th><input value="<%= request.getParameter("voucherno") %>" name="vou_no" size="10"></th>
<th><input value="<%= request.getParameter("date") %>" name="pay_date" size="10"></th>
<th><input value="<%= request.getParameter("hold") %>" name="pay_post" size="15"></th>
<th><input value="<%= request.getParameter("narration") %>" name="pay_narr" size="15"></th>
<th><input value="<%= request.getParameter("chqno") %>" name="chq_no" size="15"></th>
<th><input value="<%= request.getParameter("chqdate") %>" name="chq_date" size="15"></th>
<th><input value="<%= request.getParameter("chqamt") %>" name="chq_amt" size="15"></th>
<th><input value="<%= request.getParameter("post") %>" name="pay_type" size="15"></th>
<th><input type="submit" value="save"></th>
</form>
</tr>

<%

while ( rs.next() ) {

%>



<tr>
<form action="payment_save1.jsp" method="get">
<input type="hidden" value="save" name="action">
<td><input value="<%= rs.getString("vou_no") %>" name="vou_no"></td>
<td><input value="<%= rs.getDate("pay_date") %>" name="gl_descr"></td>
<td><input value="<%= rs.getString("pay_post") %>" name="pay_post"></td>
<td><input value="<%= rs.getString("pay_narr") %>" name="pay_narr"></td>
<td><input value="<%= rs.getString("chq_no") %>" name="chq_no"></td>
<td><input value="<%= rs.getDate("chq_date") %>" name="chq_date"></td>
<td><input value="<%= rs.getFloat("chq_amt") %>" name="chq_amt"></td>
<td><input value="<%= rs.getString("pay_type") %>" name="pay_type"></td>


<td><input type="submit" value="save"></td>
</form>
</tr>


<%
}
%>
</table>



<%
// Close the ResultSet
rs.close();

// Close the Statement
statement.close();

// Close the Connection
conn.close();
} catch (SQLException sqle) {
out.println(sqle.getMessage());
} catch (Exception e) {
out.println(e.getMessage());
}
%>
</td>
</tr>
</body>
</html>