943,940 Members | Top Members by Rank

Web Development > JSP > need help plz
Ad:
  • JSP Discussion Thread
  • Unsolved
  • Views: 4374
  • JSP RSS
Permalink
May 31st, 2007
0

need help plz

Expand Post »
Hi all,
i did code in jsp for "change password" when user want to change his password he have to enter his old password and then new password.
if he enter wrong password there will be error msg display "sorry you have entered wrong password, and if he enter correct password msg will display "your password has successfully change", this is the code:

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {font-size: 16px;
font-weight: bold;
font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style15 {font-family: "Cooper Black"}
.style16 {font-size: 12px; font-weight: bold; }
.style3 {font-size: 18px}
-->
</style>
</head>
<body>

<table width="700" height="735" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
<td height="132" colspan="4"><img src="images/simple_01.gif" width="700" height="132" alt=""></td>
</tr>
<tr>
<td height="51" colspan="4"><img src="images/simple_02.gif" width="700" height="51" alt=""></td>
</tr>
<tr>
<td height="233" colspan="2" background="images/simple_03.gif"><table width="185" border="0" align="center">
<tr>
<td><form name="form1" method="post" action="LogInPage.jsp">
<table width="189" height="177" border="0" align="center">
<tr>
<td><div align="right"></div>
<div align="right"><span class="style1">Log In</span></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="100"><div align="right"><span class="style16">User Name:</span></div></td>
<td width="90" align="right"><div align="left">
<input name="txtUserName" type="text" id="txtUserName" size="10">
</div></td>
</tr>
<tr>
<td><div align="right"><span class="style16">Password:</span></div></td>
<td><input name="txtPass" type="password" id="txtPass" size="10"></td>
</tr>
<tr>
<td colspan="2"><div align="right">
<input type="submit" name="Submit" value="Log In">
<input type="reset" name="Reset" value="Reset">
</div></td>
</tr>
<tr>
<td height="43" colspan="2"><div align="center"><a href="ChangePassword.htm">ChangePassword</a></div></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
<td rowspan="2" background="images/simple_04.gif"><table width="445" border="0">
<tr>
<td width="439"><div align="center">
<p>

<p>
<%

Connection conn;
Statement stm = null;
String r = "";
ResultSet rs = null;

String user=request.getParameter("txtUser");
String pass=request.getParameter("txtOldPass");
String newpass=request.getParameter("txtNewPass");


r = "update PersonalInfo set Password1 ='" + newpass + "' where UserName = '" + user + "' and Password1 = '" + pass+ "'";

try
{
sqlStat="SELECT * from PersonalInfo where UserName='" +user+ "' and Password1='" +pass+ "'";
out.print(sqlStat);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:liwa");
// rs.next();
stm = con.createStatement();
stm.executeUpdate(r);
rs = stmt.executeQuery(sqlStat);

if (!rs.next())
{
out.println("you have entered wrong password");
out.println("<a href=ChangePassword.htm>Click here to try again</a>");
}
else
{
out.println("Password Changed Successfully<br/>");
out.print("<a href='Admin.htm'> Home </a>");

}
}

rs.close();
conn.close();
catch (Exception e){
out.println("There is an error" + e.getMessage());
}
%>
</p>
<p>&nbsp; </p>
</div></td>
</tr>
<tr>
<td><div align="justify"><span class="style15"></span></div></td>
</tr>
</table></td>
<td rowspan="3" background="images/simple_05.gif">&nbsp;</td>
</tr>
<tr>
<td height="298" colspan="2" background="images/simple_06.gif"><table width="200" border="0" align="center">
<tr>
<td><form name="form2" method="post" action="">
<table width="200" height="245" border="0" align="center">
<tr>
<td width="122"><div align="right"><span class="style1">Reservation </span></div></td>
<td width="68" height="36">&nbsp;</td>
</tr>
<tr>
<td><div align="right"><span class="style16">Check In Date:</span></div></td>
<td height="21">&nbsp;</td>
</tr>
<tr>
<td colspan="2"><div align="center"><span class="style3">
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="select" size="1">
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</span><span class="style3"> </span></div></td>
</tr>
<tr>
<td><div align="right"><span class="style16">Check Out Date:</span></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="2"><div align="center"><span class="style3">
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="select" size="1">
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</span></div></td>
</tr>
<tr>
<td><div align="right"><span class="style16">Room Type:</span></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="2" valign="bottom"><div align="center"><span class="style3">
<select name="select" size="1">
<option value="King">King</option>
<option value="Big Double">Big Double</option>
<option value="Small Double">Small Double</option>
<option value="Double">Double</option>
</select>
</span></div></td>
</tr>
<tr>
<td height="35" colspan="2"><div align="center"><span class="style3">
<input type="submit" name="Submit" value="Check Availibility">
</span></div></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
<tr>
<td background="images/simple_07.gif">&nbsp;</td>
<td colspan="2" background="images/simple_08.gif">&nbsp;</td>
</tr>
<tr>
<td><img src="images/spacer.gif" width="13" height="1" alt=""></td>
<td><img src="images/spacer.gif" width="194" height="1" alt=""></td>
<td><img src="images/spacer.gif" width="468" height="1" alt=""></td>
<td><img src="images/spacer.gif" width="25" height="1" alt=""></td>
</tr>
</table>
</body>
</html>

but this code doesnt display right, this error display:

An error occurred at line: 70 in the jsp file: /saroo/site/ChangePassAction.jsp
Generated servlet error:
Syntax error, insert "Finally" to complete TryStatement

An error occurred at line: 70 in the jsp file: /saroo/site/ChangePassAction.jsp
Generated servlet error:
Syntax error, insert "}" to complete Block

Generated servlet error:
Syntax error on tokens, delete these tokens

Generated servlet error:
Syntax error on token "finally", delete this token


plllllz help
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
saasbs is offline Offline
6 posts
since May 2007
Permalink
May 31st, 2007
0

Re: need help plz

to be easier for you, this is the code that had error:

<%

Connection conn;
Statement stm = null;
String r = "";
ResultSet rs = null;

String user=request.getParameter("txtUser");
String pass=request.getParameter("txtOldPass");
String newpass=request.getParameter("txtNewPass");


r = "update PersonalInfo set Password1 ='" + newpass + "' where UserName = '" + user + "' and Password1 = '" + pass+ "'";

try
{
sqlStat="SELECT * from PersonalInfo where UserName='" +user+ "' and Password1='" +pass+ "'";
out.print(sqlStat);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:liwa");
// rs.next();
stm = con.createStatement();
stm.executeUpdate(r);
rs = stmt.executeQuery(sqlStat);

if (!rs.next())
{
out.println("you have entered wrong password");
out.println("<a href=ChangePassword.htm>Click here to try again</a>");
}
else
{
out.println("Password Changed Successfully<br/>");
out.print("<a href='Admin.htm'> Home </a>");

}
}

rs.close();
conn.close();
catch (Exception e){
out.println("There is an error" + e.getMessage());
}
%>

thnx
Reputation Points: 10
Solved Threads: 0
Newbie Poster
saasbs is offline Offline
6 posts
since May 2007
Permalink
May 31st, 2007
0

Re: need help plz

try have to by accomplished by one or more catch blocks to handle exceptions and in addition you can use finaly after either try or catch complished. Learn more about Exception handling at http://java.sun.com/docs/books/tutor...ons/index.html

in your case this should sort problem
JSP Syntax (Toggle Plain Text)
  1. catch(SQLException sqlEx)
  2. {
  3.      sqlEx.printStackTrace();
  4. }

Also it is very bad idea to use JSP to access database, you should validate your entry data before submiting in your JSP, then submit them to servlet which will set connection with DB and store them. Plus in servlet you can setup session and store data there so they can be passed from page to page
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 873
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Permalink
Jun 1st, 2007
0

Re: need help plz

thanks peter_budo for your reply, i solved it, and now its workin probebly, i knew what my mistake is.
thank you for your help

Regards,
saasbs
Reputation Points: 10
Solved Threads: 0
Newbie Poster
saasbs is offline Offline
6 posts
since May 2007
Permalink
Jun 19th, 2007
0

Re: need help plz

Click to Expand / Collapse  Quote originally posted by saasbs ...
Hi all,
i did code in jsp for "change password" when user want to change his password he have to enter his old password and then new password.
if he enter wrong password there will be error msg display "sorry you have entered wrong password, and if he enter correct password msg will display "your password has successfully change", this is the code:

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {font-size: 16px;
font-weight: bold;
font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style15 {font-family: "Cooper Black"}
.style16 {font-size: 12px; font-weight: bold; }
.style3 {font-size: 18px}
-->
</style>
</head>
<body>

<table width="700" height="735" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
<td height="132" colspan="4"><img src="images/simple_01.gif" width="700" height="132" alt=""></td>
</tr>
<tr>
<td height="51" colspan="4"><img src="images/simple_02.gif" width="700" height="51" alt=""></td>
</tr>
<tr>
<td height="233" colspan="2" background="images/simple_03.gif"><table width="185" border="0" align="center">
<tr>
<td><form name="form1" method="post" action="LogInPage.jsp">
<table width="189" height="177" border="0" align="center">
<tr>
<td><div align="right"></div>
<div align="right"><span class="style1">Log In</span></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="100"><div align="right"><span class="style16">User Name:</span></div></td>
<td width="90" align="right"><div align="left">
<input name="txtUserName" type="text" id="txtUserName" size="10">
</div></td>
</tr>
<tr>
<td><div align="right"><span class="style16">Password:</span></div></td>
<td><input name="txtPass" type="password" id="txtPass" size="10"></td>
</tr>
<tr>
<td colspan="2"><div align="right">
<input type="submit" name="Submit" value="Log In">
<input type="reset" name="Reset" value="Reset">
</div></td>
</tr>
<tr>
<td height="43" colspan="2"><div align="center"><a href="ChangePassword.htm">ChangePassword</a></div></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
<td rowspan="2" background="images/simple_04.gif"><table width="445" border="0">
<tr>
<td width="439"><div align="center">
<p>

<p>
<%

Connection conn;
Statement stm = null;
String r = "";
ResultSet rs = null;

String user=request.getParameter("txtUser");
String pass=request.getParameter("txtOldPass");
String newpass=request.getParameter("txtNewPass");


r = "update PersonalInfo set Password1 ='" + newpass + "' where UserName = '" + user + "' and Password1 = '" + pass+ "'";

try
{
sqlStat="SELECT * from PersonalInfo where UserName='" +user+ "' and Password1='" +pass+ "'";
out.print(sqlStat);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:liwa");
// rs.next();
stm = con.createStatement();
stm.executeUpdate(r);
rs = stmt.executeQuery(sqlStat);

if (!rs.next())
{
out.println("you have entered wrong password");
out.println("<a href=ChangePassword.htm>Click here to try again</a>");
}
else
{
out.println("Password Changed Successfully<br/>");
out.print("<a href='Admin.htm'> Home </a>");

}
}

rs.close();
conn.close();
catch (Exception e){
out.println("There is an error" + e.getMessage());
}
%>
</p>
<p>&nbsp; </p>
</div></td>
</tr>
<tr>
<td><div align="justify"><span class="style15"></span></div></td>
</tr>
</table></td>
<td rowspan="3" background="images/simple_05.gif">&nbsp;</td>
</tr>
<tr>
<td height="298" colspan="2" background="images/simple_06.gif"><table width="200" border="0" align="center">
<tr>
<td><form name="form2" method="post" action="">
<table width="200" height="245" border="0" align="center">
<tr>
<td width="122"><div align="right"><span class="style1">Reservation </span></div></td>
<td width="68" height="36">&nbsp;</td>
</tr>
<tr>
<td><div align="right"><span class="style16">Check In Date:</span></div></td>
<td height="21">&nbsp;</td>
</tr>
<tr>
<td colspan="2"><div align="center"><span class="style3">
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="select" size="1">
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</span><span class="style3"> </span></div></td>
</tr>
<tr>
<td><div align="right"><span class="style16">Check Out Date:</span></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="2"><div align="center"><span class="style3">
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<select name="select" size="1">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="select" size="1">
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</span></div></td>
</tr>
<tr>
<td><div align="right"><span class="style16">Room Type:</span></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="2" valign="bottom"><div align="center"><span class="style3">
<select name="select" size="1">
<option value="King">King</option>
<option value="Big Double">Big Double</option>
<option value="Small Double">Small Double</option>
<option value="Double">Double</option>
</select>
</span></div></td>
</tr>
<tr>
<td height="35" colspan="2"><div align="center"><span class="style3">
<input type="submit" name="Submit" value="Check Availibility">
</span></div></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
<tr>
<td background="images/simple_07.gif">&nbsp;</td>
<td colspan="2" background="images/simple_08.gif">&nbsp;</td>
</tr>
<tr>
<td><img src="images/spacer.gif" width="13" height="1" alt=""></td>
<td><img src="images/spacer.gif" width="194" height="1" alt=""></td>
<td><img src="images/spacer.gif" width="468" height="1" alt=""></td>
<td><img src="images/spacer.gif" width="25" height="1" alt=""></td>
</tr>
</table>
</body>
</html>

but this code doesnt display right, this error display:

An error occurred at line: 70 in the jsp file: /saroo/site/ChangePassAction.jsp
Generated servlet error:
Syntax error, insert "Finally" to complete TryStatement

An error occurred at line: 70 in the jsp file: /saroo/site/ChangePassAction.jsp
Generated servlet error:
Syntax error, insert "}" to complete Block

Generated servlet error:
Syntax error on tokens, delete these tokens

Generated servlet error:
Syntax error on token "finally", delete this token


plllllz help
Hi.use this code .it will work correctly.
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#EAFFFF">
<p>
<%! String op,np,name;%>
<%
name=request.getParameter("name");
op=request.getParameter("op");
np=request.getParameter("np");
Connection con;
Statement st;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:m2","","");
st=con.createStatement();
st.executeUpdate("update registration set password='"+np+"' where password='"+op+"' AND name='"+name+"'");
%>
</p>
<p align="center"><strong><font color="#400080"><br>
<br>
<br>
<br>
Your password has been successfully changed<br>
<br>
<br>
</font></strong></p>
<table width="221" align="center">
<tr>
<td width="141"><strong><font color="#400040">Your&nbsp;New&nbsp;Password:</font></strong></td>
<td width="68"><strong><em><font color="#FF80C0"><%=np%></font></em></strong></td>
</tr>
</table>
<p align="center"><strong><font color="#400080"></font></strong></p>
<p align="center"><strong><font color="#400080"></font></strong></p>
<p> <%
st.close();
con.close();
}
catch(Exception e)
{
out.println(""+e);
}
%>
</p>
</body>
</html>
Reputation Points: 10
Solved Threads: 0
Newbie Poster
suvitha_raj is offline Offline
4 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in JSP Forum Timeline: about eclipse. Please help me
Next Thread in JSP Forum Timeline: Struts 2 tags within tag files





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC