plz suggest for how to write this is code banking debit+credit+balance+sdate
our required to follow just like any Bank Pass Book Format.
Plz any javacondidate help us i am student for MCA plz do full describe.
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<%@ page import="java.util.Calendar" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<%
//java Code
String date = (new java.util.Date()).toString();
String UserName = request.getParameter("UserName");
String CusId= request.getParameter("CusId");
String AccountNo = request.getParameter("AccountNo");
String Debit = request.getParameter("Debit");
String Credit=request.getParameter("Credit");
String Balance=request.getParameter("Balance");
String sDate=request.getParameter("sDate");
//String startDate=request.getParameter("startDate");
try
{
String s="jdbc:odbc:Database1";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(s);
Statement statement = conn.createStatement();
Calendar calendar = Calendar.getInstance();
java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime());
//String sqls="SELECT (SUM(debit)*-1) + SUM(credit) Balance FROM abcbank WHERE sDate BETWEEN CURDATE() AND ADDDATE(CURDATE() INTERVAL -30 DAY)";
String sql= "SELECT sDate ,(SUM(Debit)*-1) + SUM(Credit) Balance FROM abcbank GROUP BY sDate ";
ResultSet rst = statement.executeQuery(sql);
while (rst.next())
{
rst.getInt("Balance");
}
String update="UPDATE abcbank SET Balance =Balance +Debit WHERE Debit=? AND sDate ="+sDate+" ";
int updateSet = 0;
updateSet = statement.executeUpdate(update);
if (updateSet > 0)
{
System.out.println("An existing user was updated successfully!");
}
rst.close();
statement.close();
conn.close();
out.println("Data is update successfully !");
}
catch(Exception ex)
{
System.err.println(ex.getMessage());
}
%>
|  0 |
