Dynamic Query

[zaman1111]

<%

//load the MS Access JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//open a connection to the "chemistry_test" database
String url="jdbc:odbc:chemistry_test";

Connection testConn= DriverManager.getConnection(url,"test1","test1");
String userSearch = request.getParameter("Pnumber") ;
String buttonChoice = request.getParameter("searchChoice") ;
//place query results in a ResultSet object
//String jsql="Select * from UserList WHERE uName= '"+userSearch + "'" ;

// String abu = request.getParameter("Pnumber") ;

String abu;

if (buttonChoice == ("username"))
abu = "uName";
else if(buttonChoice == ("userrole"))
abu = "Role" ;
else if (buttonChoice == ("firstname"))
abu = "Fname" ;

String jsql= "Select * from UserList WHERE '"+abu+ "' = '"+userSearch+ "'";

//create a statement object for sending SQL queries
Statement stmt = testConn.createStatement();

ResultSet rs = stmt.executeQuery(jsql);

%>



Please choose


user name
role
first name




User Information

First Name
Last Name
User Name
Password
Role
E-mail Address

//assign ResultSet's column 1 to a String variable
<% while(rs.next()){
%>
<%=rs.getString("Fname")%> 
<%=rs.getString("Lname")%> 
<%=rs.getString("Uname")%> 
<%=rs.getString("pword")%> 
<%=rs.getString("Role")%> 
<%=rs.getString("email")%> 

<%
}
//clean up all objects
rs.close();

%>

[zaman1111]

I resolved it. thanks

[eee]

I have the same problem, can u post ur working code please..

Greetz,

EEE

[arpit]

I resolved it. thanks

Kindly send me the same solution

[zaman1111]

Please choose

user name
User role
first name



User Information

First Name
Last Name
User Name
Password
Role
E-mail Address

<%

//load the MS Access JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//open a connection to the "chemistry_test" database
String url="jdbc:odbc:chemistry_test";

Connection testConn= DriverManager.getConnection(url,"test1","test1");
String userSearch = request.getParameter("Pnumber") ; //get data from the textbox
String buttonChoice = request.getParameter("searchChoice") ; //get choice from the radio button

String abu = buttonChoice ;

String jsql= "Select *from UserList WHERE "+abu+" = '"+userSearch+"'"; //abu is a variable for executing BD and userSearch is from textbox typed by user

//Select * from UserList WHERE uName= 'admin'

//System.out.println(jsql);
out.println(jsql);
//%>>>><%
//out.println(buttonChoice);

//create a statement object for sending SQL queries
Statement stmt = testConn.createStatement();

ResultSet rs = stmt.executeQuery(jsql);

%>

<% //assign ResultSet's column 1 to a String variable
while(rs.next()){
%>
<%=rs.getString("Fname")%> 
<%=rs.getString("Lname")%> 
<%=rs.getString("Uname")%> 
<%=rs.getString("pword")%> 
<%=rs.getString("Role")%> 
<%=rs.getString("email")%> 

<%
}
//clean up all objects
rs.close();

%>