mskim100
asked on
using int value returned by a javabean
well, i'm new to jsp & javabean development and been having some what i consider as should be simple problems.
i''ve created a javabean that checks and returns an integer value of what the user did. it checks for user's id & password and depending on the user's correct info level, i'm returning a number. so 0 = no match, 1 = user id match, 2 = user id match but password wrong, 3 = all match.
in my jsp, i'm just trying to use the value that's returned.
well, i originally tested the bean just passing back true or false. so if the user's id matched, return true. that worked fine. now i''ve changed everything to use these int and it just doesn't seem to do anything but bomb. i tried to use Integer.parseInt but didn't do anything.
can you help me out?
as i'm sure it's usually the case here, i really need this working asap.
some code:
in javabean:
public int existsUser (String strEmail, String strPassword) {
String url = "jdbcdriver";
Connection con;
Statement stmt;
String query = "select UserID, Password from Authorization where Email = '" + strEmail + "'";
// 0= user does not exist, 1 = user exists but did not match password,
//2 = user exists, but password wrong, 3 = all matched & good
int intHaveRS = 0;
String strUID = "";
String strPass = "";
try {
Class.forName("com.mysql.j dbc.Driver ");
} catch(java.lang.ClassNotFo undExcepti on e) {
System.err.print("ClassNot FoundExcep tion: ");
System.err.println(e.getMe ssage());
return 0;
}
try {
con = DriverManager.getConnectio n(url, "iars_bears", "iars_bears");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
if (rs.next()) {
strUID = rs.getString("UserID");
strPass = rs.getString("Password");
intHaveRS = 1;
if (strPassword.equals(strPas s)) {
intHaveRS = 3;
} else {
intHaveRS = 2;
}
} else {
setUID(null);
intHaveRS = 0;
}
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLExc eption: " + ex.getMessage());
return 0;
}
return intHaveRS;
}
and jsp:
<%@page import="java.lang.*, java.io.*" %>
<jsp:useBean id="Authorization" class="msk.Authorization" />
<%
int iUExist=0;
if (request.getParameter("btn Submit") != null) {
iUExist = Authorization.existsUser(( request.ge tParameter ("txtEmail ")),(reque st.getPara meter("txt Password") ));
if (iUExist > 0) {
out.print("this user exists! " + iUExist);
} else {
out.print("this user DOES NOT exists!");
}
}
%>
<p>Welcome!</p>
<form name="frmAdmLogin" method="post" action="">
<p>user email
<input type="text" name="txtEmail">
</p>
<p>user password
<input type="text" name="txtPassword">
</p>
<p>
<input type="submit" name="btnSubmit" value="Submit">
<input type="reset" name="btnCancel" value="Cancel">
</p>
</form>
</body>
i''ve created a javabean that checks and returns an integer value of what the user did. it checks for user's id & password and depending on the user's correct info level, i'm returning a number. so 0 = no match, 1 = user id match, 2 = user id match but password wrong, 3 = all match.
in my jsp, i'm just trying to use the value that's returned.
well, i originally tested the bean just passing back true or false. so if the user's id matched, return true. that worked fine. now i''ve changed everything to use these int and it just doesn't seem to do anything but bomb. i tried to use Integer.parseInt but didn't do anything.
can you help me out?
as i'm sure it's usually the case here, i really need this working asap.
some code:
in javabean:
public int existsUser (String strEmail, String strPassword) {
String url = "jdbcdriver";
Connection con;
Statement stmt;
String query = "select UserID, Password from Authorization where Email = '" + strEmail + "'";
// 0= user does not exist, 1 = user exists but did not match password,
//2 = user exists, but password wrong, 3 = all matched & good
int intHaveRS = 0;
String strUID = "";
String strPass = "";
try {
Class.forName("com.mysql.j
} catch(java.lang.ClassNotFo
System.err.print("ClassNot
System.err.println(e.getMe
return 0;
}
try {
con = DriverManager.getConnectio
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
if (rs.next()) {
strUID = rs.getString("UserID");
strPass = rs.getString("Password");
intHaveRS = 1;
if (strPassword.equals(strPas
intHaveRS = 3;
} else {
intHaveRS = 2;
}
} else {
setUID(null);
intHaveRS = 0;
}
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLExc
return 0;
}
return intHaveRS;
}
and jsp:
<%@page import="java.lang.*, java.io.*" %>
<jsp:useBean id="Authorization" class="msk.Authorization" />
<%
int iUExist=0;
if (request.getParameter("btn
iUExist = Authorization.existsUser((
if (iUExist > 0) {
out.print("this user exists! " + iUExist);
} else {
out.print("this user DOES NOT exists!");
}
}
%>
<p>Welcome!</p>
<form name="frmAdmLogin" method="post" action="">
<p>user email
<input type="text" name="txtEmail">
</p>
<p>user password
<input type="text" name="txtPassword">
</p>
<p>
<input type="submit" name="btnSubmit" value="Submit">
<input type="reset" name="btnCancel" value="Cancel">
</p>
</form>
</body>
what's the error message?
ASKER
this is what i get
mskim100
=========================
HTTP Status 500 -
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx ception: msk.Authorization.existsUs er(Ljava/l ang/String ;Ljava/lan g/String;) I
at org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:2 54)
at org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:295)
at org.apache.jasper.servlet. JspServlet .service(J spServlet. java:241)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:247 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:1 93)
at org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:256)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:191)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.authen ticator.Au thenticato rBase.invo ke(Authent icatorBase .java:494)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 1)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.catalina.core.S tandardCon text.invok e(Standard Context.ja va:2417)
at org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:180 )
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.valves .ErrorDisp atcherValv e.invoke(E rrorDispat cherValve. java:171)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 1)
at org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:172 )
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 1)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :174)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.coyote.tomcat4. CoyoteAdap ter.servic e(CoyoteAd apter.java :193)
at org.apache.coyote.http11.H ttp11Proce ssor.proce ss(Http11P rocessor.j ava:781)
at org.apache.coyote.http11.H ttp11Proto col$Http11 Connection Handler.pr ocessConne ction(Http 11Protocol .java:549)
at org.apache.tomcat.util.net .TcpWorker Thread.run It(PoolTcp Endpoint.j ava:589)
at org.apache.tomcat.util.thr eads.Threa dPool$Cont rolRunnabl e.run(Thre adPool.jav a:666)
at java.lang.Thread.run(Threa d.java:534 )
root cause
javax.servlet.ServletExcep tion: msk.Authorization.existsUs er(Ljava/l ang/String ;Ljava/lan g/String;) I
at org.apache.jasper.runtime. PageContex tImpl.hand lePageExce ption(Page ContextImp l.java:536 )
at org.apache.jsp.admLogin_js p._jspServ ice(admLog in_jsp.jav a:108)
at org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:137 )
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:2 10)
at org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:295)
at org.apache.jasper.servlet. JspServlet .service(J spServlet. java:241)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:247 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:1 93)
at org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:256)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:191)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.authen ticator.Au thenticato rBase.invo ke(Authent icatorBase .java:494)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 1)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.catalina.core.S tandardCon text.invok e(Standard Context.ja va:2417)
at org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:180 )
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.valves .ErrorDisp atcherValv e.invoke(E rrorDispat cherValve. java:171)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 1)
at org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:172 )
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 1)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :174)
at org.apache.catalina.core.S tandardPip eline$Stan dardPipeli neValveCon text.invok eNext(Stan dardPipeli ne.java:64 3)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:480)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 95)
at org.apache.coyote.tomcat4. CoyoteAdap ter.servic e(CoyoteAd apter.java :193)
at org.apache.coyote.http11.H ttp11Proce ssor.proce ss(Http11P rocessor.j ava:781)
at org.apache.coyote.http11.H ttp11Proto col$Http11 Connection Handler.pr ocessConne ction(Http 11Protocol .java:549)
at org.apache.tomcat.util.net .TcpWorker Thread.run It(PoolTcp Endpoint.j ava:589)
at org.apache.tomcat.util.thr eads.Threa dPool$Cont rolRunnabl e.run(Thre adPool.jav a:666)
at java.lang.Thread.run(Threa d.java:534 )
mskim100
=========================
HTTP Status 500 -
--------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at javax.servlet.http.HttpSer
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.authen
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.coyote.tomcat4.
at org.apache.coyote.http11.H
at org.apache.coyote.http11.H
at org.apache.tomcat.util.net
at org.apache.tomcat.util.thr
at java.lang.Thread.run(Threa
root cause
javax.servlet.ServletExcep
at org.apache.jasper.runtime.
at org.apache.jsp.admLogin_js
at org.apache.jasper.runtime.
at javax.servlet.http.HttpSer
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at javax.servlet.http.HttpSer
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.authen
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.coyote.tomcat4.
at org.apache.coyote.http11.H
at org.apache.coyote.http11.H
at org.apache.tomcat.util.net
at org.apache.tomcat.util.thr
at java.lang.Thread.run(Threa
to avoid the obvious, you've re-compiled your bean and restarted your server right?
ASKER
i've recompiled my bean but it's a remote server and i can't restart. i did reload my class tho.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so as far as you can see, i should be able to use my int that's returned from my bean? well, i'll have to ask someone to restart then. i'll let you know what happens when i get it restarted.
mskim100
mskim100
ASKER
restart worked!
thanks!
mskim100
thanks!
mskim100