Hi
jsp code following
<html>
<head><title>Getting totalamount</title></head>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date.*" %>
<%@ page import="java.util.*" %>
<%@ page import= "java.SimpleDateFormat" %>
<%@ page import =java.text.DateFormat" %>
<body>
<body>
<%
String start_date = request.getParameter("begindate");
String end_date = request.getParameter("enddate");
SimpleDateFormat sdf = java.text.SimpleDateFormat("dd/MM/yyyy");
java.util.Date d = sdf.parse(start_date);
java.utildate e =sdf.parse(end_date);
java.sql.Date startdate = new java.sql.Date(d);
java.sql.Date enddate = new java.sql.Date(e);
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@toshiba-user:1521:orcl","wara","kali");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(" SELECT SUM(sale)total FROM DAILYSALE WHERE saledate BETWEEN startdate AND enddate " );
while (rs.next()) {
int result = rs.getInt("total"); %>
<%= result %>
<% }
conn.close();
stmt.close();
%>
</body>
</html>
When i input fields of html form to run the jsp i get error:jasperException sales.jsp(6 18) qoute symbol expected.
Please help me to solve this.
