QuestionAsk Questions?
nagababu
hi,plz send me the code for me using search button bind the data from data base in dropdownlist
View Answers
November 29, 2012 at 4:21 PM
Here is a jsp code that allow the user to search the particular employee details by selecting name of the employee.
1)selectname.jsp:
<%@page import="java.sql.*"%>
<html>
<head>
<script type="text/javascript">
function showEmp(emp_value){
if(document.getElementById("address").value!="-1"){
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null){
alert ("Browser does not support HTTP Request")
return
}
var url="getvalue.jsp"
url=url+"?name="+emp_value
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
else{
alert("Please Select Employee Id");
}
}
function stateChanged(){
document.getElementById("email").value ="";
document.getElementById("address").value ="";
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") {
var showdata = xmlHttp.responseText;
var strar = showdata.split(":");
if(strar.length==1){
document.getElementById("address").focus();
alert("Please Select Employee Id");
document.getElementById("email").value =" ";
document.getElementById("address").value =" ";
}
else if(strar.length>1) {
var strname = strar[1];
document.getElementById("address").value= strar[1];
document.getElementById("email").value= strar[2];
}
}
}
function GetXmlHttpObject(){
var xmlHttp=null;
try{
xmlHttp=new XMLHttpRequest();
}
catch (e) {
try {
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e) {
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
</head>
<body>
<form name="employee">
<br><br>
<table border="0" width="400px" align="center" bgcolor="#CDFFFF">
<div id="mydiv"></div>
<tr><td><b>Select Employee Name to Search</b></td><td>
<select name="name" onchange="showEmp(this.value);">
<option value="-1">Select</option>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test","root","root");
String query = "select * from employee";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
%>
<option value="<%=rs.getString("name")%>"><%=rs.getString("name")%></option>
<%
}
%>
</select>
</td></tr>
<tr><td ><b>Employee Address:</b></td><td>
<input type="text" name="address" id="address" value=""></td></tr>
<tr><td><b>Employee Email:</b></td><td>
<input type="text" name="email" id="email" value=""></td></tr>
</table>
</form>
<table border="0" width="100%" align="center">
<br>
<br>
</table>
</body>
</html>
November 29, 2012 at 4:21 PM
2)getvalue.jsp:
<%@page import="java.sql.*"%>
<%
String emp_id = request.getParameter("name").toString();
String data="";
int sumcount=0;
Statement st;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test","root","root");
String query = "select * from employee where name='"+emp_id+"'";
st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
data = ":" + rs.getString("address") +":"+ rs.getString("email");
}
out.println(data);
}
catch (Exception e) {
e.printStackTrace();
}
%>
3)For the above code, we have created following table:
CREATE TABLE `employee` (
`id` bigint(255) default NULL,
`name` varchar(255) default NULL,
`address` varchar(255) default NULL,
`contactNo` int(255) default NULL,
`email` varchar(255) default NULL
)
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
