<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<% String msg=request.getParameter("msg"); %>
<%=msg %>
</head>
<body bgcolor="#8b8378">
<center>
<form method="post" action="Infosend">
<table border="30" bordercolor="#8b3e2f" bgcolor="#66cd00" cellpadding="20" cellspacing="0">
<th colspan="2">Infomation</th>
<tr><td>Name</td><td><input type="text" name="name" placeholder="Enter your name"></td></tr>
<tr><td>Post</td><td><input type="text" name="post" placeholder="Enter your name"></td></tr>
<tr><td>E.Q.</td><td><select name="Qualification" style="width:100px">
<option value="">Select</option>
<option value="B.A.">B.A.</option>
<option value="B.Sc.">B.Sc.</option>
<option value="B.Tech.">B.Tech.</option>
<option value="B.com">B.com</option>
<option value="M.Sc.">M.Sc.</option>
<option value="MCA">MCA</option>
</select>
</td></tr>
<tr><td>Mob.No.</td><td><input type="text" name="mobileno"></td></tr>
<tr><td>Favourite Color</td><td><input type="text" name="favouritecolor"></td></tr>
<tr><td>Submit:-</td><td><input type="reset" name="Reset">
<input type="submit" name="submit"></td></tr>
<tr><th colspan="7">Infomation</th></tr>
<tr><td>id</td><td>Name</td><td>Post</td><td>Qualification</td><td>Mobile_No</td><td>favourite_color</td></tr>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/empinfo","root","");
java.sql.PreparedStatement stmt=con.prepareStatement("select id,name,post,Qualification,mobileno,favouritecolor from info");
java.sql.ResultSet rs=stmt.executeQuery(); %>
<% while(rs.next()){ %>
<tr><td><% out.println(rs.getString("id")); %></td>
<td><% out.println(rs.getString("name")); %> </td>
<td><% out.println(rs.getString("post"));%> </td>
<td> <% out.println(rs.getString("Qualification"));%></td>
<td><% out.println(rs.getString("mobileno"));%></td>
<td><% out.println(rs.getString("favouritecolor"));%></td></tr>
<% }
con.close();
} catch(Exception e)
{
System.out.println(e);
}
%>
</table>
</form>
</center>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<% String msg=request.getParameter("msg"); %>
<%=msg %>
</head>
<body bgcolor="#8b8378">
<center>
<form method="post" action="Infosend">
<table border="30" bordercolor="#8b3e2f" bgcolor="#66cd00" cellpadding="20" cellspacing="0">
<th colspan="2">Infomation</th>
<tr><td>Name</td><td><input type="text" name="name" placeholder="Enter your name"></td></tr>
<tr><td>Post</td><td><input type="text" name="post" placeholder="Enter your name"></td></tr>
<tr><td>E.Q.</td><td><select name="Qualification" style="width:100px">
<option value="">Select</option>
<option value="B.A.">B.A.</option>
<option value="B.Sc.">B.Sc.</option>
<option value="B.Tech.">B.Tech.</option>
<option value="B.com">B.com</option>
<option value="M.Sc.">M.Sc.</option>
<option value="MCA">MCA</option>
</select>
</td></tr>
<tr><td>Mob.No.</td><td><input type="text" name="mobileno"></td></tr>
<tr><td>Favourite Color</td><td><input type="text" name="favouritecolor"></td></tr>
<tr><td>Submit:-</td><td><input type="reset" name="Reset">
<input type="submit" name="submit"></td></tr>
<tr><th colspan="7">Infomation</th></tr>
<tr><td>id</td><td>Name</td><td>Post</td><td>Qualification</td><td>Mobile_No</td><td>favourite_color</td></tr>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/empinfo","root","");
java.sql.PreparedStatement stmt=con.prepareStatement("select id,name,post,Qualification,mobileno,favouritecolor from info");
java.sql.ResultSet rs=stmt.executeQuery(); %>
<% while(rs.next()){ %>
<tr><td><% out.println(rs.getString("id")); %></td>
<td><% out.println(rs.getString("name")); %> </td>
<td><% out.println(rs.getString("post"));%> </td>
<td> <% out.println(rs.getString("Qualification"));%></td>
<td><% out.println(rs.getString("mobileno"));%></td>
<td><% out.println(rs.getString("favouritecolor"));%></td></tr>
<% }
con.close();
} catch(Exception e)
{
System.out.println(e);
}
%>
</table>
</form>
</center>
</body>
</html>
No comments:
Post a Comment