Document : login
--%>
<%@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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Register Page</title>
</head>
<body>
<center><h1> <b><u>Register Here</u></b></h1><hr>
<form action="r1.jsp"><table><b>
<br> <tr><td>Name</td><td><input type="text" name="name"></td></tr>
<br><tr><td>User ID</td><td><input type="text" name="id"></td></tr>
<br><tr><td>Password</td><td><input type="password" name="password"></td></tr>
<br><tr><td>Date of Birth</td><td><input type="text" name="date"></td></tr>
<br><tr><td>Address</td><td><textarea name="address"></textarea></td></tr>
<br>
<tr><td> <input type="submit" value="Register"></td></tr></b></table>
</form>
<br><hr>
Already Registered!! To Login <a href="login.jsp">Click Here</a>
<hr>
</center>
</body>
</html>
|
<%--
Document : r1
--%>
<%@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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.sql.DriverManager.*" %>
<%
String m=null, mn=null;
String s=request.getParameter("name");
String s1=request.getParameter("id");
String s2=request.getParameter("password");
String s3=request.getParameter("date");
String s4=request.getParameter("address");
PreparedStatement ps;
Connection con;
ResultSet rs= null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");
Statement st=con.createStatement();
ps= con.prepareStatement("insert into register values (?,?,?,?,?)");
ps.setString(1,s);
ps.setString(2, s1);
ps.setString(3,s2);
ps.setString(4,s3);
ps.setString(5,s4);
int insertResult = ps.executeUpdate();
if (insertResult!=0)
{
out.println("Successfully registered");
}
%>
<br><hr>
To Login <a href="login.jsp">Click Here</a>
<hr>
</body>
</html>
|
create table register(
name varchar2(20),
id varchar2(20),
password varchar2(10),
dated varchar2(10),
address varchar2(30),
primary key(id));
);
|