JSP RSS JSP RSS

need help plz

Reply

•
•
Join Date: May 2007
Posts: 6
Reputation: saasbs is an unknown quantity at this point 
Solved Threads: 0
saasbs saasbs is offline Offline
Newbie Poster

need help plz

 
0
  #1
May 31st, 2007
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
Reply With Quote Quick reply to this message  
•
•
Join Date: May 2007
Posts: 6
Reputation: saasbs is an unknown quantity at this point 
Solved Threads: 0
saasbs saasbs is offline Offline
Newbie Poster

Re: need help plz

 
0
  #2
May 31st, 2007
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2004
Posts: 4,212
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 489
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: need help plz

 
0
  #3
May 31st, 2007
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
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
•
•
Join Date: May 2007
Posts: 6
Reputation: saasbs is an unknown quantity at this point 
Solved Threads: 0
saasbs saasbs is offline Offline
Newbie Poster

Re: need help plz

 
0
  #4
Jun 1st, 2007
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2007
Posts: 4
Reputation: suvitha_raj is an unknown quantity at this point 
Solved Threads: 0
suvitha_raj suvitha_raj is offline Offline
Newbie Poster

Re: need help plz

 
0
  #5
Jun 19th, 2007
•
•
•
•
Originally Posted by saasbs View 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
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>
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC