Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Whre to put <a href ...>

Posted on 2003-10-22
16
Medium Priority
?
254 Views
Last Modified: 2010-04-01

This is jsp code for vol2.jsp

<%@ page import="java.sql.*, com.dhal.*"%>
 
<jsp:useBean id="vol" class="com.dhal.volun" scope="session"/>
<jsp:setProperty name="vol" property="*"/>

<Html>
<body>
<form action="vol.jsp...>
......
<% database queries.....%>
<input type="submit" value="Update">

</form>

When the user presses the update, it needs to go to vol.jsp
where do i put
<a href= ?   >so that it would go to vol.jsp



0
Comment
Question by:Jasbir21
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 8
16 Comments
 
LVL 35

Accepted Solution

by:
TimYates earned 400 total points
ID: 9598030
You don't...

<form action="vol.jsp">
<% database queries.....%>
<input type="submit" value="Update">
</form>

Will post this form to vol.jsp
0
 

Author Comment

by:Jasbir21
ID: 9598072
The vol2.jsp code:
<%@ page import="java.sql.*, com.dhal.*"%>
 
<jsp:useBean id="vol" class="com.dhal.volun" scope="session"/>
<jsp:setProperty name="vol" property="*"/>

<Html>
<body>

<%
String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";
Connection connection = null;
ResultSet rs=null;
ResultSet rs1=null;
Statement statement=null;
String username=null;
String passwd=null;
String verify=null;
String name=null;
String education=null;
String city=null;
String state=null;
String post=null;
String qualify=null;
String house1=null;
String house2=null;
String office1=null;
String office2=null;
String mobile1=null;
String mobile2=null;
String email=null;
String notify=null;
String add1=null;
String add2=null;

Statement statement1=null;

try
{

Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement=connection.createStatement();
String myquery="select * from accou where username='jasbir22'";
rs=statement.executeQuery(myquery);

boolean anyRecords=rs.next();

String query="select * from my where username='jasbir22'";
statement1=connection.createStatement();
rs1=statement1.executeQuery(query);
boolean any=rs1.next();

if(rs1.getString(1).trim().equals(rs.getString(1).trim()))
{

name=rs1.getString(2).trim();
education=rs1.getString(3).trim();
city=rs1.getString(4).trim();
state=rs1.getString(5).trim();
post=rs1.getString(6).trim();
qualify=rs1.getString(7).trim();
house1=rs1.getString(8).trim();
house2=rs1.getString(9).trim();
office1=rs1.getString(10).trim();
office2=rs1.getString(11).trim();
mobile1=rs1.getString(12).trim();
mobile2=rs1.getString(13).trim();
email=rs1.getString(14).trim();
notify=rs1.getString(15).trim();
add1=rs1.getString(16).trim();
add2=rs1.getString(17).trim();


username=rs.getString(1).trim();
passwd=rs.getString(2).trim();
verify=rs.getString(3).trim();


}



}
catch(SQLException ex )
{
   ex.printStackTrace() ;
}
catch( ClassNotFoundException ex )
{
   ex.printStackTrace() ;
}
finally
{
  try { if( rs != null ) rs.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
 //  try { if( prep1 != null ) prep1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
try { if( rs1 != null ) rs1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( connection != null ) connection.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
}

%>

<%
//String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";
//Connection connection = null;
PreparedStatement prep1=null;

try
{
passwd=vol.getPasswd();
verify=vol.getVerifypwd();
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");


String y="update accou set " +"password='"+passwd+"'," + "verifypassdword='" +verify+"' " +
"where username='"+username+"'";

prep1=connection.prepareStatement(y);
prep1.executeUpdate();

S
}

catch(SQLException ex )
{
   ex.printStackTrace() ;
}
catch( ClassNotFoundException ex )
{
   ex.printStackTrace() ;
}
finally
{
  //try { if( rs != null ) rs.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( prep1 != null ) prep1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
//try { if( rs1 != null ) rs1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( connection != null ) connection.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
}

%>
<table border="4" BGColor="#FFF8DC" width="100%">
<tr>
<td>
<Font Color="#000000" Face="Garamond" Size="4">
<b>ACCOUNT INFORMATION</b>
</Font>
</td>
</tr>
</table>
<br>
<form action="vol2.jsp" method="post">
<Font Size="4 Color="Black" Face="Garamond" Align="Center">



<br>
Username :

<input type="text" name="username" value=<%=username%> size=20 /><br>

Password :
<input type="password" name="passwd" value=<%=passwd%> size=20/><br>


Verify Password :
<input type="password" name="verifypwd" value=<%=verify%> size=20/> <br>


<input type="submit" value="Submit">

</form>
</Font>



</body>

<html>




The vol.jsp<%@ page import="java.sql.*"%>
<Html>
<body>

<%
String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";
Connection connection = null;

PreparedStatement prep1;
prep1=null;
ResultSet rs=null;
ResultSet rs1=null;
Statement statement=null;
String username=null;
String passwd=null;
String verify=null;
String name=null;
String education=null;
String city=null;
String state=null;
String post=null;
String qualify=null;
String house1=null;
String house2=null;
String office1=null;
String office2=null;
String mobile1=null;
String mobile2=null;
String email=null;
String notify=null;
String add1=null;
String add2=null;

Statement statement1=null;

try
{

Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement=connection.createStatement();
String myquery="select * from accou where username='jasbir22'";
rs=statement.executeQuery(myquery);

boolean anyRecords=rs.next();

String query="select * from my where username='jasbir22'";
statement1=connection.createStatement();
rs1=statement1.executeQuery(query);
boolean any=rs1.next();

if(rs1.getString(1).trim().equals(rs.getString(1).trim()))
{
name=rs1.getString(2).trim();
education=rs1.getString(3).trim();
city=rs1.getString(4).trim();
state=rs1.getString(5).trim();
post=rs1.getString(6).trim();
qualify=rs1.getString(7).trim();
house1=rs1.getString(8).trim();
house2=rs1.getString(9).trim();
office1=rs1.getString(10).trim();
office2=rs1.getString(11).trim();
mobile1=rs1.getString(12).trim();
mobile2=rs1.getString(13).trim();
email=rs1.getString(14).trim();
notify=rs1.getString(15).trim();
add1=rs1.getString(16).trim();
add2=rs1.getString(17).trim();


username=rs.getString(1).trim();

passwd=rs.getString(2).trim();
System.out.println(passwd);
verify=rs.getString(3).trim();


}



}
catch(SQLException ex )
{
   ex.printStackTrace() ;
}
catch( ClassNotFoundException ex )
{
   ex.printStackTrace() ;
}
finally
{
  try { if( rs != null ) rs.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( prep1 != null ) prep1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
try { if( rs1 != null ) rs1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( connection != null ) connection.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
}

%>

Username : <%=username%><p/>
Password : <%=passwd%><p/>
Verify Password : <%=verify%>
<p/>
Name : <%=name%><p/>
Education : <%=education%></p>
City   : <%=city%></p>
State  : <%=state%></p>
Qualification : <%=qualify%></p>

Phone (H) : <%=house1%>&nbsp;&nbsp;<%=house2%></p>

Phone (O) : <%=office1%>&nbsp;&nbsp;<%=office2%></p>

Handphone : <%=mobile1%>&nbsp;&nbsp;<%=mobile2%></p>

Email    :<%=email%></p>

Notification :<%=notify%></p>

Address  : <%=add1%></p>
           <%=add2%>



           




</Body>
</html>

Thanks

0
 
LVL 35

Expert Comment

by:TimYates
ID: 9598101
Errr...yes....that's fine...

What's wrong with it?  vol2 will post the form to vol

Then in vol, you can get the values out with:

request.getParameter( "username" ) ;

etc
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Jasbir21
ID: 9598117
Tim,
 I got one more question to ask,

i don't know what's wrong with this statement:




String y="update accou set " +"password='"+passwd+"'," + "verifypassdword='" +verify+"' " +
"where username='"+username+"'";

Thanks

0
 

Author Comment

by:Jasbir21
ID: 9598185
I get it , put the action in the form , i thought you meant post the vol codes.


Could you pls look at the sql statement, really don't know what's wrong
Thanks
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9598187
Should be ok, so long as the username or password doesn't include ' chars

Have you considered PreparedStatements?

Much easier for this sort of thing...

And the string looks nicer like:

        String y = "update accou set password='" + passwd + "', verifypassdword='" +verify+ "' where username='" + username + "'" ;
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9598206
Change:

try
{
passwd=vol.getPasswd();
verify=vol.getVerifypwd();
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");


String y="update accou set " +"password='"+passwd+"'," + "verifypassdword='" +verify+"' " +
"where username='"+username+"'";

prep1=connection.prepareStatement(y);
prep1.executeUpdate();

S
}

to:

try
{
    passwd=vol.getPasswd();
    verify=vol.getVerifypwd();
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    connection = DriverManager.getConnection(connectionURL, "", "");

    String y = "update accou set password=?, verifypassdword=? where username=?" ;

    prep1=connection.prepareStatement( y );
    prep1.setString( 1, passwd ) ;
    prep1.setString( 2, verify ) ;
    prep1.setString( 3, username ) ;
    prep1.executeUpdate();
}
0
 

Author Comment

by:Jasbir21
ID: 9598293
Hi,
 
  I guess i did something wrong,  i didn't get any errors but the data is not updating..
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9598351
Any stack traces being output in the log files?
0
 

Author Comment

by:Jasbir21
ID: 9598488
Surprisingly no,

it is as if the code the understand which user i am pointing to
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9598626
can you post your updating code?

(vol.jsp)?
0
 

Author Comment

by:Jasbir21
ID: 9598782
I tried something, i changed:

 <form action="vol.jsp">

to

<form action="vol2.jsp">

meaning that after pressing the submit , i call the same page back and not vol.jsp,suprisingly it gets updated,
but then how do i call vol.jsp

user would use vol2.jsp to input data

the vol.jsp code just shows the data inputed:
<%@ page import="java.sql.*"%>
<Html>
<body>

<%
String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";
Connection connection = null;

PreparedStatement prep1;
prep1=null;
ResultSet rs=null;
ResultSet rs1=null;
Statement statement=null;
String username=null;
String passwd=null;
String verify=null;
String name=null;
String education=null;
String city=null;
String state=null;
String post=null;
String qualify=null;
String house1=null;
String house2=null;
String office1=null;
String office2=null;
String mobile1=null;
String mobile2=null;
String email=null;
String notify=null;
String add1=null;
String add2=null;

Statement statement1=null;

try
{

Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement=connection.createStatement();
String myquery="select * from accou where username='jasbir22'";
rs=statement.executeQuery(myquery);

boolean anyRecords=rs.next();

String query="select * from my where username='jasbir22'";
statement1=connection.createStatement();
rs1=statement1.executeQuery(query);
boolean any=rs1.next();

if(rs1.getString(1).trim().equals(rs.getString(1).trim()))
{
name=rs1.getString(2).trim();
education=rs1.getString(3).trim();
city=rs1.getString(4).trim();
state=rs1.getString(5).trim();
post=rs1.getString(6).trim();
qualify=rs1.getString(7).trim();
house1=rs1.getString(8).trim();
house2=rs1.getString(9).trim();
office1=rs1.getString(10).trim();
office2=rs1.getString(11).trim();
mobile1=rs1.getString(12).trim();
mobile2=rs1.getString(13).trim();
email=rs1.getString(14).trim();
notify=rs1.getString(15).trim();
add1=rs1.getString(16).trim();
add2=rs1.getString(17).trim();


username=rs.getString(1).trim();

passwd=rs.getString(2).trim();
System.out.println(passwd);
verify=rs.getString(3).trim();


}



}
catch(SQLException ex )
{
   ex.printStackTrace() ;
}
catch( ClassNotFoundException ex )
{
   ex.printStackTrace() ;
}
finally
{
  try { if( rs != null ) rs.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( prep1 != null ) prep1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
try { if( rs1 != null ) rs1.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
   try { if( connection != null ) connection.close() ; } catch( Exception ex ) {ex.printStackTrace() ;}
}

%>

Username : <%=username%><p/>
Password : <%=passwd%><p/>
Verify Password : <%=verify%>
<p/>
Name : <%=name%><p/>
Education : <%=education%></p>
City   : <%=city%></p>
State  : <%=state%></p>
Qualification : <%=qualify%></p>

Phone (H) : <%=house1%>&nbsp;&nbsp;<%=house2%></p>

Phone (O) : <%=office1%>&nbsp;&nbsp;<%=office2%></p>

Handphone : <%=mobile1%>&nbsp;&nbsp;<%=mobile2%></p>

Email    :<%=email%></p>

Notification :<%=notify%></p>

Address  : <%=add1%></p>
           <%=add2%>



     

</Body>
</html>
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9598952
oh...

vol doesn't do any updating in it...  you do the update in vol2...

I would add a bit to vol2

get the form to post to vol2

and after you do the update, do:

response.sendRedirect( "vol.jsp" ) ;
0
 

Author Comment

by:Jasbir21
ID: 9599105
Hi,
 When i put the line, it automatically redirects to vol.jsp.
But I need to redirect it only after, the user presses the submit button because, then only i can enter the changes(update S) and then press submit,


Thanks



 
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9599145
put a hidden value into the form:

<form action="vol2.jsp">
  <input type="hidden" name="posted" value="yes">
   ...rest of your form...
</form>

then, only redirect (and do the update) if this value exists;

if( request.getParameter( "posted" ) != null )
{
  // form was posted!!  Not just a click!!
0
 

Author Comment

by:Jasbir21
ID: 9599240
Wow,it s working, thanks so much,
I would learn more on hidden type,it is very interesting .

Thanks again
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
An overview of cyber security, cyber crime, and personal protection against hackers. Includes a brief summary of the Equifax breach and why everyone should be aware of it. Other subjects include: how cyber security has failed to advance with technol…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question