Untitled

<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>

<%
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3307/db1","root","root");
Statement st= con.createStatement();
int id= Integer.parseInt(request.getParameter("t1"));
String name=request.getParameter("t2");
st.executeUpdate("insert into emp values("+id+",'"+name+"')");
ResultSet rs=st.executeQuery("select * from emp");
out.print("<h2 align=center>Employee Database</h2>");
out.print("<table border=1 align=center>");
out.print("<tr><th> ENo</th><th>Ename</th></tr>");


while(rs.next())
{
	out.print("<tr align=center>");
	out.print("<td>");
	out.print(rs.getInt(1));
	out.print("</td>");
	out.print("<td>");
	out.print(rs.getString(2));
	out.print("</td>");
	out.print("</tr>");
}
%>
-------------------------------------------
<html>
<body>
<form method="post" action="show.jsp">
Enter Employee No<input type="text" name="t1">
<br>
Enter Empoyee Name <input type="text" name="t2">
<br>
<input type="submit" value="submit">
</form>
</body>
</html>