display date prob - Dev Articles

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

December 3rd, 2004, 05:57 AM

abhit_kumar

Registered User

Join Date: Nov 2004

Posts: 22

Time spent in forums: 17 m 3 sec
Reputation Power: 0

display date prob

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("jdbc

dbc

f","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.getParam eter("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>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: