Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

amend jsp code

Posted on 2004-04-07
12
Medium Priority
?
336 Views
Last Modified: 2010-04-01

Hi, im using the below commands to set a name a user has entered in a jsp bean. Id like to amend this so the the users id is set instead.
<jsp:useBean id="AccessV" scope="session" class="classfiles.AccessVals"/>
<% AccessV.setName(request.getParameter("strUserName")); %>  

Ive been trying this:
string name = request.getParameter("strUserName");
<% AccessV.setName(select idnum from users where name like 'name'); %>  

That does'nt work although.

Thanks
0
Comment
Question by:Ronayne
[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
  • 7
  • 5
12 Comments
 
LVL 18

Expert Comment

by:bobbit31
ID: 10776189
<% AccessV.setName("select idnum from users where name like '" + name + "'"); %>  
0
 

Author Comment

by:Ronayne
ID: 10776632

I tried that but got this error:

Generated servlet error:
    [javac] Compiling 1 source file

C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\seanproj\insert_jsp.java:62: cannot resolve symbol
symbol  : variable name  
location: class org.apache.jsp.insert_jsp
 AccessV.setName("select idnum from users where name like '" + name + "'");
0
 
LVL 18

Expert Comment

by:bobbit31
ID: 10776741
<%
String name = request.getParameter("strUserName");
AccessV.setName("select idnum from users where name like '" + name + "'");
%>
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Ronayne
ID: 10776830

Ive tried that as well but it just outputs all my insert.jsp source code.

This is insert.jsp:

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="classfiles.*" %>

<jsp:useBean id="AccessV" scope="session" class="classfiles.AccessVals"/>
<%
 String name = request.getParameter("strUserName");
 AccessV.setName("select idnum from users where name like '" + name + "'");
%>
 

 try {
 
   String userName = request.getParameter("strUserName");
   String pass = request.getParameter("password");
   if (userName != null)
   out.print("User Name: " +userName);
 
  String inServer = "localhost";
  String inDBName = "test";
  String DATABASE_URL = "jdbc:mysql://" + inServer + ":3306/" + inDBName;
 
  Class.forName("com.mysql.jdbc.Driver").newInstance();
  Connection con = DriverManager.getConnection(DATABASE_URL, "username", "password");
  Statement stmt = con.createStatement();
   
 ResultSet rs1 = stmt.executeQuery("select password from userdesc where password like \""+pass+"\" and name like \""+name+"\"");
  String passwordtocompare = "";
  if (rs1.next())
  {
 
         passwordtocompare = rs1.getString(1);
         out.print("\nCorrect password");
         response.sendRedirect("main.jsp?strUserName="+userName+"+password="+pass+"");
         Object id = getServletConfig().getServletContext().getAttribute("someid");
       boolean loggedIn = (id != null);
  }
  else {
     out.print("\nIncorrect username / password");
     response.sendRedirect("reelogin.jsp");
   }
 
//   out.print("\nPassword:" +passwordtocompare);
 //if (passwordtocompare.equals(password)){

//  out.print("\nCorrect password");
//  }
  /*else {
   out.print("\nIncorrect password");
   }*/
}
      catch (ClassNotFoundException cnfe) {
        out.println(cnfe.toString());
      }
      catch (SQLException sqle) {
        out.println(sqle.toString());
    }
%>

0
 

Author Comment

by:Ronayne
ID: 10777125

Ive fixed that but its now just outputting :select idnum from users where name like 'adrian_eire' on the page it links to
0
 
LVL 18

Accepted Solution

by:
bobbit31 earned 200 total points
ID: 10777249
you have to edit AccessV, in particular the setName function so that it runs the query and returns whatever value it is you are looking for
0
 

Author Comment

by:Ronayne
ID: 10777294
How can I do this, this is my bean that contains the setName method

package classfiles;

public class AccessVals {
  private String name;
  public AccessVals() {
    name = "";
  }
  public String getName() {
    return name;
  }
 
  public void setName(String x) {
    name = x;
  }
}

0
 
LVL 18

Expert Comment

by:bobbit31
ID: 10777405
public void setName(String x) {
  Class.forName("com.mysql.jdbc.Driver").newInstance();
  Connection con = DriverManager.getConnection(DATABASE_URL, "username", "password");
  Statement stmt = con.createStatement();
   
 ResultSet rs1 = stmt.executeQuery("select idnum from users where name like '" + x + "' );
 if (rs.next()) {
    name = rs1.getString("idnum");
 }
 rs.close();
 stmt.close();
 con.close();
}

then call setName like this:

<%
 String name = request.getParameter("strUserName");
 AccessV.setName(name);
%>

0
 

Author Comment

by:Ronayne
ID: 10777702
I amedned as you said but its still causing this error: <<Ive fixed that but its now just outputting :select idnum from users where name like 'adrian_eire' on the page it links to

This is the jsp along with the bean (i know its skimply coded but it will do for now)
<%
 String name = request.getParameter("strUserName");
 AccessV.setName(name);
%>

package classfiles;

import java.sql.*;
import java.util.*;
public class AccessVals {
  private String name;
  public AccessVals() {
    name = "";
  }
  public String getName() {
    return name;
  }
 
  public void setName(String x) {
        try{
          String inServer = "localhost";
  String inDBName = "test";
  String DATABASE_URL = "jdbc:mysql://" + inServer + ":3306/" + inDBName;
 
  Class.forName("com.mysql.jdbc.Driver").newInstance();
  Connection con = DriverManager.getConnection(DATABASE_URL, "username", "password");
  Statement stmt = con.createStatement();
   
 ResultSet rs1 = stmt.executeQuery("select idnum from users where name like '" + x + "'" );
 if (rs1.next()) {
    name = rs1.getString("idnum");
 }
 rs1.close();
 stmt.close();
 con.close();
}
catch(ClassNotFoundException e){
                  
            }
catch(InstantiationException ee){
                  
            }
catch(IllegalAccessException eee){
                  
            }
catch(SQLException eeee){
                  
            }
 
}
  //public void setName(String x) {
    //name = x;
 // }
}
0
 

Author Comment

by:Ronayne
ID: 10777744

Its ok, I fixed that, should'nt this output the value : <%=AccessV.getName()%>
0
 
LVL 18

Expert Comment

by:bobbit31
ID: 10777813
yeah... you should be able to do that.
0
 

Author Comment

by:Ronayne
ID: 10778160

That wont work, ive tried this also :
String n  = AccessV.getName();
out.print(n);

But nothing is displayed in both cases
0

Featured Post

Industry Leaders: 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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Files go missing when using DFS (Distributed File System) Replication and how to recover them and fix it.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

730 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