All about Agnit Chatterjee

how can i compare a session parameter value with variable value?

Sorry......it's resolved .equals method was required!!!

14 years ago

how can i compare a session parameter value with variable value?

how can i compare a session parameter value with variable value? will this code work? It doesn't give the correct result.........please help

useraccount.jsp

<%@ page import= "ac.Account" %>
<%
String username=(String) session.getAttribute("username");
if(username==null) username="";
%>
<jsp:useBean id= "ac" scope= "application" class= "ac.Account" />
<jsp:setProperty name="ac" property= "*" />
<html>
<body background="juric 2.jpg">
<br>
<div align="right"><h4><font face="Lucida Console"><font face="Times New Roman" style="font-weight: normal;">Welcome back,</font> </font><%=username%>
<center><h1><font color="#4d4d4d" face="Calibri">WELCOME TO THE  ACCOUNT CREATION SECTION<br></font></h1></center>
<br><br>
<br>
<table border="0" width="994" height="566">
<tr>
<td width="50">                                                <br></td>
<td width="450">
<form method="get">
<h3><font size="3" color="#000000"><font size="4"> Account Type:</font> </font><font face="Calibri" size="3" color="#800080"><font color="#000000"> </font>                                             
<select name="type">
<option value="fixed deposit">fixed deposit</option>
<option value="current">current</option>
<option value="savings">savings</option>
</select>
</font></h3>
<h3><font size="4" color="#800080"> <font color="#000000">Account Type Description:</font>  </font><font face="Calibri" size="3" color="#800080">                           <input type="text" name="desc" size="25"></font></h3>
<h3><font face="Calibri" size="4" color="#800080"> </font><font color="#000000"><strong><font size="4">Customer ID</font></strong></font><font face="Calibri" size="3" color="#800080"><font color="#000000"> </font>                                                 <input type="text" name="id" size="25"></font></h3>
<h3><font color="#800080" face="Calibri" size="3"> <font size="4"><font color="#000000">Amount:</font> </font>                                                       <input type="text" name="amount" size="25">    <br></font></h3>
<h3><font face="Calibri" size="5" color="#800080"> </font><font size="3" color="#800080"><font size="4" color="#000000">Transaction Password:</font> </font><font face="Calibri" size="3" color="#800080">                                  <input type="text" name="trpass" size="25">    <br></font></h3>
<h3><font color="#800080" face="Calibri" size="3"> <font size="4"><font color="#000000">Time in Years (only for fixed deposit):</font> </font>       <input type="text" name="timespan" size="25">    <br></font></h3>
<br>                                                                                       
<input type="submit" value="SUBMIT">        
<input type="reset" value="RESET">
</form>
</td>
</tr>
</table>
<%
if (request.getParameter("id") == username){
%>
<%@ include file="accountprops.jsp" %>
<%
}
%>
</body>
</html>

[Edit by Dave - removed the shouting]

14 years ago

JSP

Can't find the error

please tell me where is the error?

<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn3=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
PreparedStatement ps3=conn3.prepareStatement
("select fdaccountno,customerid,amount,interest,to_char(account_start_date),duration,to_char(maturityday),
case
when (sysdate-maturityday) > 0 then 'matured'
when (sysdate-maturityday) = 0 then 'maturityday'
when (sysdate-maturityday) < 0 then 'notmatured'
end maturity
from fixed_deposit_account where customerid=? ");
ps3.setString(1,request.getParameter("id"));
ResultSet rs3=ps3.executeQuery();
%>
<TABLE cellpadding="15" border="1" style="background-color: #ffffcc;">
<%
while (rs3.next()) {
%>
<TR>
<TD><%=rs3.getString(1)%></TD>
<TD><%=rs3.getString(2)%></TD>
<TD><%=rs3.getDouble(3)%></TD>
<TD><%=rs3.getDouble(4)%></TD>
<TD><%=rs3.getString(5)%></TD>
<TD><%=rs3.getDouble(6)%></TD>
<TD><%=rs3.getString(7)%></TD>
<TD><%=rs3.getString(8)%></TD>
</TR>
<% } %>
<%
conn3.close();
} catch (Exception ex) {
%>
</font>
<font size="+3" color="red"></b>
<%
out.println("Unable to connect to database.");
}
%>
</TABLE>
</font>
</body>
</html>

I get the following error:

An error occurred at line: 13 in the jsp file: /fdmonitorprops.jsp
String literal is not properly closed by a double-quote
10: Class.forName("oracle.jdbc.driver.OracleDriver");
11: Connection conn3=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
12: PreparedStatement ps3=conn3.prepareStatement
13: ("select fdaccountno,customerid,amount,interest,to_char(account_start_date),duration,to_char(maturityday),
14: case
15: when (sysdate-maturityday) > 0 then 'matured'
16: when (sysdate-maturityday) = 0 then 'maturityday'

Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:95)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:457)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:367)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:345)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:332)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:594)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:342)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

14 years ago

JSP

sending email through jsp

Do we have to use a virtual ftp server to be able to send email through JSP?
Would you please suggest me the software and code to send email through JSP??
Thanks in advance

14 years ago

JSP

getting the name of file uploaded using uploadbean

It's name is uploadbean1.9........i downloaded it from http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html

14 years ago

Other Open Source Projects

getting the name of file uploaded using uploadbean

how can I get the name of file uploaded using uploadbean???

14 years ago

Other Open Source Projects

doubt in Session parameters

I have done it.......thanks to everyone who helped!!! Actually the problem was that the session parameter was not being recognized by the bean form..........so I tried the other way round.............I did not use:

What I did was that pass the session parameter as an argument to the Java file and got the result

The problem why I got the resultSet exhausted was that the Java program was not able to recognize one of the parameters and taking it as null for which I was basically getting:

14 years ago

JSP

doubt in Session parameters

getting exhausted result set when using <jsp:setProperty name="details" property="id" value="${sessionScope.user}" />

14 years ago

JSP

doubt in Session parameters

thanks.........I don't know whether it worked or not because when I am sending the value to the java file I still get the same result as follows:
false ACCOUNT NUMBER: 5456
ACCOUNT TYPE:null
USERNAME:null
ID:
BALANCE:null

here are the codes:

viewuserdetails.jsp

<%@ page language="java" %>
<%@ page import= "details.viewaccountbalance" %>
<%
String user=(String) session.getAttribute("username");
if(user==null) user="";
%>
<jsp:useBean id= "details" scope= "session" class= "details.viewaccountbalance" />
<jsp:setProperty name="details" property= "*" />
<html>
<body background="orange-2.jpg">
<table border="0" width="1048" height="73">
<tr>
<td width="150">   </td>
<td width="550">
<div align="right"><h4><font face="Lucida Console"><font face="Times New Roman" style="font-weight: normal;">Welcome back,</font> </font><%=user%>
<br>
<br>
<br>
<br>
<center><h1><font face="Calibri" color="#515151">WELCOME TO THE VIEW ACCOUNT DETAILS IN PAGE</font></h1></center>
<br>
<br>
<table border="0" width="700">
<tr>
<td width="150"> </td>
<td width="550">
<form method="get">
<h3><font size="4" face="Cambria"><font size="4" face="Calibri" color="#800080">ACCOUNT NO:</font><font face="Calibri"> </font> </font>          <input type="text" name="acno" size="25"></h3>
<jsp:setProperty name="details" property="id" value="${sessionScope.user}" />
<br>
<br>
<br>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
</td>
</tr>
</table>
<%
if (request.getParameter("acno") != null) {
%>
<%@ include file="detailsproperties.jsp" %>
<%
}
%>
</body>
</html>

detailsproperties.jsp

viewaccountbalance.java

package details;
import java.sql.*;
public class viewaccountbalance {
private String acno;
private String actype;
private String username;
private String id;
private String balance;
private String check;
public void setCheck(String check)
{
this.check=check;
}
public void setAcno(String acno)
{
this.acno=acno;
}
public void setActype(String actype)
{
this.actype=actype;
}
public void setUsername(String username)
{
this.username=username;
}
public void setId(String id)
{
this.id=id;
}
public void setBalance(String balance)
{
this.balance=balance;
}
public String getCheck()
{
return check;
}
public String getAcno()
{
return acno;
}
public String getActype()
{
return actype;
}
public String getUsername()
{
return username;
}
public String getId()
{
return id;
}
public String getBalance()
{
return balance;
}
public void check() throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
PreparedStatement ps=conn.prepareStatement("select customerid from account where accountno=? and customerid=?");
ps.setString(1,acno);
ps.setString(2,id);
ResultSet rs=ps.executeQuery();
if(rs.next())
{
check="true";
connection();
}
else
check="false";
}
public void connection() throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
PreparedStatement ps=conn.prepareStatement("select accountno,account_type,customerid,amount from account where accountno=? ");
ps.setString(1,acno);
ResultSet rs=ps.executeQuery();
rs.next();
acno=rs.getString(1);
actype=rs.getString(2);
id=rs.getString(3);
balance=rs.getString(4);
Connection conn2=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
PreparedStatement ps2=conn2.prepareStatement("select customername from customer where customerid=? ");
ps2.setString(1,id);
ResultSet rs2=ps2.executeQuery();
rs2.next();
username=rs2.getString(1);
conn2.close();
}
}

I would be grateful if someone could point out my mistake

Please tell me whether the JSP programs are right and whether the values enter the java file because I have separately run the java file in IDE using specific values and it worked just fine

I am now sure that the value is not entering the java program because I am getting Resultset exhausted

14 years ago

JSP

doubt in Session parameters

Can we assign a session variable to a form property

Suppose I have a session variable named "username"........I do the following:

<%
String user=(String) session.getAttribute("username");
if(user==null) user="";
%>

Now can I write:

<jsp:setProperty name="details" property= "*" />

<jsp:setProperty name="details" property="id" value="user" />

If no, then how can I use the session parameter as a form parameter?

14 years ago

JSP

Extending bean's properties

Can we use this name property in another jsp file say efgh just by using <jsp:setProperty id="myBean" property="name"> or using the request.getParameter("name");

How will the jsp recognize in which jsp file the property name was initially used for???

14 years ago

JSP

Extending bean's properties

suppose we write a jsp file and obtain a property called name from the user input like say:

<input type="text" name="name" size="25" />

in abc.jsp

how can we use this name property in another jsp file

14 years ago

JSP

JSP error again

userpass.jsp

UserpassCheck.java

package jdbc;
import java.sql.*;
public class UserpassCheck {
private String username;
private String password;
private static String val;
public UserpassCheck() {
username="";
password="";
val="";
}
public void setUsername(String username)
{
this.username=username;
}
public void setPassword(String password)
{
this.password=password;
}
public void setVal(String val)
{
this.val=null;
}
public String getUsername()
{
return username;
}
public String getPassword()
{
return password;
}
public void getvalue() throws ClassNotFoundException,SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
PreparedStatement ps=conn.prepareStatement("select username,password from userpass where username=? and password=?");
ps.setString(1,username);
ps.setString(2,password);
ResultSet rs=ps.executeQuery();
if(rs.next())
val="true";
else
val="false";
System.out.println(val);
}
public String getVal()
{
return val;
}
}

And there are three other html files........

I was getting the correct values in the morning and now this:

init:
deps-module-jar:
deps-ear-jar:
deps-jar:
library-inclusion-in-archive:
library-inclusion-in-manifest:
compile:
compile-jsps:
Compiling 2 source files to C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\classes
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:129: 'catch' without 'try'
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:129: ')' expected
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:129: not a statement
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:129: ';' expected
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:136: 'finally' without 'try'
} finally {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:35: 'try' without 'catch' or 'finally'
try {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\UserpassCheck_jsp.java:140: reached end of file while parsing
}
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:129: 'catch' without 'try'
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:129: ')' expected
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:129: not a statement
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:129: ';' expected
} catch (Throwable t) {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:136: 'finally' without 'try'
} finally {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:35: 'try' without 'catch' or 'finally'
try {
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\build\generated\src\org\apache\jsp\userpass_jsp.java:140: reached end of file while parsing
}
14 errors
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\nbproject\build-impl.xml:589: The following error occurred while executing this line:
C:\Users\Agnit\Documents\NetBeansProjects\FirstReal\nbproject\build-impl.xml:285: Compile failed; see the compiler error output for details.
BUILD FAILED (total time: 0 seconds)

14 years ago

JSP

Error in Javac compilation for JSP

If you are using IDE then the process is completely different

14 years ago

Other IDEs, Version Control

Conditional Redirecting using JSP

I have been able to do it..........something like this:

where users is the name of the bean I have used!!!

Just wanted to know whether this is the right way to it or not??? Is there any other alternate way?

14 years ago

JSP

Agnit Chatterjee

Recent posts by Agnit Chatterjee