•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 426,478 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,197 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our JSP advertiser: Lunarpages JSP Web Hosting
Views: 8208 | Replies: 4
 |
•
•
Join Date: Aug 2004
Posts: 11
Reputation: 
Rep Power: 5
Solved Threads: 0
Newbie Poster
I have a search code from Database. i want to display queries from Database with multiple option. how do i assign variable on both. for example
String jsql= "Select * from UserList WHERE '"+abu+ "' = '"+userSearch+ "'";
the full code:
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*, java.util.*" errorPage="error.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Chemistry Search</title>
</head>
<body>
<br>
<%
//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);
%>
<br>
<form method="POST" action="ChemistryDataSearchVar.jsp">
<table border="0" width="228" id="table1">
<tr>
<td colspan="2">Please choose</td>
</tr>
<tr>
<td width="150"><input type="text" name="Pnumber" size="20"></td>
<td><input type="submit" value="Search" name="B2"></td>
</tr>
<tr>
<td colspan="2"><input type="radio" value="username" checked name="searchChoice">user name
<input type="radio" value="userrole" name="searchChoice">role
<input type="radio" value="firstname" name="searchChoice">first name</td>
</tr>
</table>
</form>
<br>
<br>
<br>
<tt class="1">User Information</tt><br><br>
<table border="1" width="300" id="table1" cellspacing="0" cellpadding="4">
<tr bgcolor="bcbcbc">
<td width="30">First Name</td>
<td width="50">Last Name</td>
<td width="30">User Name</td>
<td width="20">Password</td>
<td width="30">Role</td>
<td width="140">E-mail Address</td>
</tr>
//assign ResultSet's column 1 to a String variable
<% while(rs.next()){
%>
<tr>
<td><%=rs.getString("Fname")%> </td>
<td><%=rs.getString("Lname")%> </td>
<td><%=rs.getString("Uname")%> </td>
<td><%=rs.getString("pword")%> </td>
<td><%=rs.getString("Role")%> </td>
<td><%=rs.getString("email")%> </td>
</tr>
<%
}
//clean up all objects
rs.close();
%>
</body>
</html>
<%
testConn.close();
%>
Please help.
String jsql= "Select * from UserList WHERE '"+abu+ "' = '"+userSearch+ "'";
the full code:
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*, java.util.*" errorPage="error.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Chemistry Search</title>
</head>
<body>
<br>
<%
//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);
%>
<br>
<form method="POST" action="ChemistryDataSearchVar.jsp">
<table border="0" width="228" id="table1">
<tr>
<td colspan="2">Please choose</td>
</tr>
<tr>
<td width="150"><input type="text" name="Pnumber" size="20"></td>
<td><input type="submit" value="Search" name="B2"></td>
</tr>
<tr>
<td colspan="2"><input type="radio" value="username" checked name="searchChoice">user name
<input type="radio" value="userrole" name="searchChoice">role
<input type="radio" value="firstname" name="searchChoice">first name</td>
</tr>
</table>
</form>
<br>
<br>
<br>
<tt class="1">User Information</tt><br><br>
<table border="1" width="300" id="table1" cellspacing="0" cellpadding="4">
<tr bgcolor="bcbcbc">
<td width="30">First Name</td>
<td width="50">Last Name</td>
<td width="30">User Name</td>
<td width="20">Password</td>
<td width="30">Role</td>
<td width="140">E-mail Address</td>
</tr>
//assign ResultSet's column 1 to a String variable
<% while(rs.next()){
%>
<tr>
<td><%=rs.getString("Fname")%> </td>
<td><%=rs.getString("Lname")%> </td>
<td><%=rs.getString("Uname")%> </td>
<td><%=rs.getString("pword")%> </td>
<td><%=rs.getString("Role")%> </td>
<td><%=rs.getString("email")%> </td>
</tr>
<%
}
//clean up all objects
rs.close();
%>
</body>
</html>
<%
testConn.close();
%>
Please help.
•
•
Join Date: Aug 2004
Posts: 11
Reputation:
Rep Power: 5
Solved Threads: 0
Newbie Poster
I resolved it. thanks
•
•
Join Date: Nov 2004
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
I have the same problem, can u post ur working code please..
Greetz,
EEE
Greetz,
EEE
•
•
Join Date: May 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by zaman1111
I resolved it. thanks
•
•
Join Date: Aug 2004
Posts: 11
Reputation:
Rep Power: 5
Solved Threads: 0
Newbie Poster
Here it is. Good Luck
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*, java.util.*"errorPage="error.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Chemistry Search</title>
</head>
<body>
<br>
<br>
<form method="POST" action="ChemistryDataSearchVar.jsp">
<table border="0" width="270" id="table1">
<tr>
<td colspan="2">Please choose</td>
</tr>
<tr>
<td width="150"><input type="text" name="Pnumber" size="20"></td>
<td><input type="submit" value="Search" name="B2"></td>
</tr>
<tr>
<td colspan="2">
<input type="radio" value="uName" checked name="searchChoice">user name
<input type="radio" value="Role" name="searchChoice">User role
<input type="radio" value="Fname" name="searchChoice">first name</td>
</tr>
</form>
</table>
<br>
<br>
<br>
<tt class="1">User Information</tt><br><br>
<table border="1" width="300" id="table1" cellspacing="0" cellpadding="4">
<tr bgcolor="bcbcbc">
<td width="30">First Name</td>
<td width="50">Last Name</td>
<td width="30">User Name</td>
<td width="20">Password</td>
<td width="30">Role</td>
<td width="140">E-mail Address</td>
</tr>
<%
//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()){
%>
<tr>
<td><%=rs.getString("Fname")%> </td>
<td><%=rs.getString("Lname")%> </td>
<td><%=rs.getString("Uname")%> </td>
<td><%=rs.getString("pword")%> </td>
<td><%=rs.getString("Role")%> </td>
<td><%=rs.getString("email")%> </td>
</tr>
<%
}
//clean up all objects
rs.close();
%>
</body>
</html>
<%
testConn.close();
%>
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*, java.util.*"errorPage="error.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Chemistry Search</title>
</head>
<body>
<br>
<br>
<form method="POST" action="ChemistryDataSearchVar.jsp">
<table border="0" width="270" id="table1">
<tr>
<td colspan="2">Please choose</td>
</tr>
<tr>
<td width="150"><input type="text" name="Pnumber" size="20"></td>
<td><input type="submit" value="Search" name="B2"></td>
</tr>
<tr>
<td colspan="2">
<input type="radio" value="uName" checked name="searchChoice">user name
<input type="radio" value="Role" name="searchChoice">User role
<input type="radio" value="Fname" name="searchChoice">first name</td>
</tr>
</form>
</table>
<br>
<br>
<br>
<tt class="1">User Information</tt><br><br>
<table border="1" width="300" id="table1" cellspacing="0" cellpadding="4">
<tr bgcolor="bcbcbc">
<td width="30">First Name</td>
<td width="50">Last Name</td>
<td width="30">User Name</td>
<td width="20">Password</td>
<td width="30">Role</td>
<td width="140">E-mail Address</td>
</tr>
<%
//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()){
%>
<tr>
<td><%=rs.getString("Fname")%> </td>
<td><%=rs.getString("Lname")%> </td>
<td><%=rs.getString("Uname")%> </td>
<td><%=rs.getString("pword")%> </td>
<td><%=rs.getString("Role")%> </td>
<td><%=rs.getString("email")%> </td>
</tr>
<%
}
//clean up all objects
rs.close();
%>
</body>
</html>
<%
testConn.close();
%>
|
•
•
•
•
•
•
•
•
DaniWeb JSP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Dynamic query string (Search Engine Optimization)
- Googles php and MySQL preferences (Search Engine Optimization)
- Dynamic Initialization implies Dynamic Help (C++)
Other Threads in the JSP Forum
- Previous Thread: stopping further execution
- Next Thread: question
