First Create table in database
create table studentinfo
(
name varchar(20),
branch varchar(20),
year varchar(4),
email varchar(20)
)
insert into studentinfo values('Satyam','CSE','2013','satyam@gmail.com')
insert into studentinfo values('Anand','CSE','2013','anand@gmail.com')
Now create home.jsp page
<title>Jsp Page</title>
<script>
<body>
<form>
<select name="user" onchange="showuser(this.value)" >
<option value="">Select Student name....</option>
<option value="Satyam">Satyam</option>
<option value="Anand">Anand</option>
<option value="Shruti">Shruti</option>
<option value="Diksha">Diksha</option>
<option value="Shweta">Shweta</option>
</select>
</form>
<br />
<div id="showtext">The response will come here</div>
</body>
</html>
Now create one more jsp page
getuser.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
Output:
create table studentinfo
(
name varchar(20),
branch varchar(20),
year varchar(4),
email varchar(20)
)
insert into studentinfo values('Satyam','CSE','2013','satyam@gmail.com')
insert into studentinfo values('Anand','CSE','2013','anand@gmail.com')
Now create home.jsp page
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<title>Jsp Page</title>
<script>
</head>1:2: function showuser(str)3: {4: var xreq;5: if(str=="")6: {7: document.getElementById("showtext").innerHTML="Plase Select Name";8: return;9: }10:11: if(window.XMLHttpRequest)12: {13: xreq=new XMLHttpRequest();14: }15: else16: {17: xreq=new ActiveXObject("Microsoft.XMLHTTP");18: }19: xreq.onreadystatechange=function ()20: {21: if( (xreq.readyState==4) && (xreq.status==200) )22: {23: document.getElementById("showtext").innerHTML=xreq.responseText;24:25: }26: }27: xreq.open("get","getuser.jsp?q="+str,"true");28: xreq.send();29:30: }</script>
<body>
<form>
<select name="user" onchange="showuser(this.value)" >
<option value="">Select Student name....</option>
<option value="Satyam">Satyam</option>
<option value="Anand">Anand</option>
<option value="Shruti">Shruti</option>
<option value="Diksha">Diksha</option>
<option value="Shweta">Shweta</option>
</select>
</form>
<br />
<div id="showtext">The response will come here</div>
</body>
</html>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.*,java.sql.*,java.io.*" %>
<%@page import="javax.servlet.*" %>
<%@page import="javax.servlet.http.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>jsp Page</title>
</head>
<body>
<%
1: ! Connection con;
%>
<%
1: ! Statement s;
%>
<%
1: ! ResultSet rs;
%>
<%
1: String name=request.getParameter("q");2:3: try{4:5: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");6:7: con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=j2ee","sa","niitbpl123");8:9: s=con.createStatement();10:11: rs=s.executeQuery("select * from studentinfo where name='"+name+"'");12:13: }catch(Exception e){ e.printStackTrace(); }%>
<div id="dtl_table">
<table border='3' cellpadding='5'cellspacing='2' width="400px">
<tr bgcolor="66FF00">
<th>Name</th>
<th>Branch</th>
<th>Year</th>
<th>Email id</th>
</tr>
<tr>
<%
1: while(rs.next())2: {%>
<td><%1: = rs.getString(1) %></td>
<td><%1: = rs.getString(2) %></td>
<td><%1: = rs.getString(3) %></td>
<td><%1: = rs.getString(4) %></td>
<%
1: }
%>
</tr>
</table></div>
</body>
</html>
Comments
Post a Comment