First JSP Page
JSP Code
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
String s1 = request.getParameter("T1");
String s2 = request.getParameter("T2");
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/harish", "root", "root");
Statement st = conn.createStatement();
int a = st.executeUpdate("insert into register values('"+s1+"','"+s2+"')");
ResultSet rs = st.executeQuery("select * from register");
while(rs.next()){
String s3=rs.getString(1);
String s4 = rs.getString(2);
%>
<br>
<b><%=s3 %> <t><%=s4 %></t></b>
<%
}
}
catch(Exception e){
e.printStackTrace();
}
%>
<h1>Successfully Register... </h1>
</body>
</html>
====================================================
HTML Code
<!DOCTYPE html>
<html>
<body>
<form action="/B19/Welcome.jsp" method="get">
<div>
<label for="username">Enter Name :</label>
<input type="text" name="T1">
</div><br>
<div>
<label for="username">Enter Surname :</label>
<input type="text" name="T2">
</div><br>
<div>
<button type="submit">Register</button>
</div>
</form>
</body>
</html>
Comments
Post a Comment