QuestionAsk Questions?
Rahul tenguriya
i want to a job site, in this site user can registered by a form..
in this form there are his information...
i use three form for it
1)for user name and password..
2)for personal detail...
3)for educational details..
by 1 and 2 i can move on three by continue.. button..
and on 3rd form i use submit button...
data of form 1 and 2 can also be store in table along with 3 form..
how can i do it... i use sql server2000
in this form there are his information...
i use three form for it
1)for user name and password..
2)for personal detail...
3)for educational details..
by 1 and 2 i can move on three by continue.. button..
and on 3rd form i use submit button...
data of form 1 and 2 can also be store in table along with 3 form..
how can i do it... i use sql server2000
View Answers
April 20, 2010 at 3:44 PM
Hi Friend,
We have created 4 jsp files:
1)login.jsp:
<html>
<head>
<script src="valid.js" type="text/javascript"></script>
<style>
A:hover {
text-decoration: none;
font-family:arial;
font-size:12px;
color: #000000;
BORDER: none;
}
A {
text-decoration: underline;
font-family:arial;
font-size:12px;
color: #000000;
BORDER: none;
}
</style>
</head>
<body>
<br><br><br>
<form name="loginform" method="post" action="checklogin.jsp" >
<table width="250px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td colspan=2 align="center" style="font-weight:bold;font-size:20pt;" align="center">User Login</td>
</tr>
<tr>
<td colspan=2> </td>
</tr>
<tr>
<td style="font-size:12pt;" align="center">Login Name</td>
<td><input type="text" name="userName" value=""></td>
</tr>
<tr>
<td style="font-size:12pt;" align="center">Password</td>
<td><input type="password" name="password" value=""></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
<tr>
<td></td>
<td align="right"><a href="register.jsp">New User?</a></td>
</tr>
</table>
</form>
</body>
</html>
2)checklogin.jsp:
<%@ page language="java" import="java.sql.*;"%>
<html>
<body>
<%
String userName = request.getParameter("userName");
String password = request.getParameter("password");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st = conn.createStatement();
String strQuery = "select count(*) from login where username='"+userName+"' and password='"+password+"'";
out.println(strQuery);
ResultSet rs = st.executeQuery(strQuery);
if(rs.next()) {
if(rs.getInt(1)>0) {
session.setAttribute("userid",userName);
response.sendRedirect("details.jsp");
}
else
{
response.sendRedirect("checklogin.jsp");
}
}
System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
We have created 4 jsp files:
1)login.jsp:
<html>
<head>
<script src="valid.js" type="text/javascript"></script>
<style>
A:hover {
text-decoration: none;
font-family:arial;
font-size:12px;
color: #000000;
BORDER: none;
}
A {
text-decoration: underline;
font-family:arial;
font-size:12px;
color: #000000;
BORDER: none;
}
</style>
</head>
<body>
<br><br><br>
<form name="loginform" method="post" action="checklogin.jsp" >
<table width="250px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td colspan=2 align="center" style="font-weight:bold;font-size:20pt;" align="center">User Login</td>
</tr>
<tr>
<td colspan=2> </td>
</tr>
<tr>
<td style="font-size:12pt;" align="center">Login Name</td>
<td><input type="text" name="userName" value=""></td>
</tr>
<tr>
<td style="font-size:12pt;" align="center">Password</td>
<td><input type="password" name="password" value=""></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
<tr>
<td></td>
<td align="right"><a href="register.jsp">New User?</a></td>
</tr>
</table>
</form>
</body>
</html>
2)checklogin.jsp:
<%@ page language="java" import="java.sql.*;"%>
<html>
<body>
<%
String userName = request.getParameter("userName");
String password = request.getParameter("password");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st = conn.createStatement();
String strQuery = "select count(*) from login where username='"+userName+"' and password='"+password+"'";
out.println(strQuery);
ResultSet rs = st.executeQuery(strQuery);
if(rs.next()) {
if(rs.getInt(1)>0) {
session.setAttribute("userid",userName);
response.sendRedirect("details.jsp");
}
else
{
response.sendRedirect("checklogin.jsp");
}
}
System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
April 20, 2010 at 3:47 PM
continue..
3)register.jsp:
<%@ page import="java.sql.*"%>
<html>
<body>
<br>
<form name="userform" method="post" >
<table width="350px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td colspan=2 style="font-weight:bold;font-size:20pt;" align="center">User Registeration</td>
</tr><tr><td colspan=2> </td>
</tr><tr>
<td>First Name </td>
<td><input type="text" name="firstName" ></td>
</tr>
<tr>
<td>Last Name </td>
<td><input type="text" name="lastname"></td>
</tr>
<tr>
<td>Login Name</td>
<td><input type="text" name="userName" ></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" ></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" ></td>
</tr>
<tr>
<td>Address</td>
<td><textarea name="address" rows=5 cols=25></textarea></td>
</tr>
<tr>
<td>Contact No</td>
<td><input type="text" name="contactNo" ></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Save"></td>
</tr>
</table>
</form>
</body>
</html>
<%String fname=request.getParameter("firstName");
String lname=request.getParameter("lastName");
String uname=request.getParameter("userName");
String password=request.getParameter("password");
String email=request.getParameter("email");
String address=request.getParameter("address");
String contact=request.getParameter("contactNo");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st = conn.createStatement();
int i=st.executeUpdate("insert into login(firstname,lastname,username,password,email,address,contactno) values('"+fname+"','"+lname+"','"+uname+"','"+password+"','"+email+"','"+address+"','"+contact+"')");
}
catch(Exception e){}
%>
<form name="form" action="details.jsp">
<table width="350px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
<td><input type="submit" value="continue" ></td></tr>
</table>
</form>
3)register.jsp:
<%@ page import="java.sql.*"%>
<html>
<body>
<br>
<form name="userform" method="post" >
<table width="350px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td colspan=2 style="font-weight:bold;font-size:20pt;" align="center">User Registeration</td>
</tr><tr><td colspan=2> </td>
</tr><tr>
<td>First Name </td>
<td><input type="text" name="firstName" ></td>
</tr>
<tr>
<td>Last Name </td>
<td><input type="text" name="lastname"></td>
</tr>
<tr>
<td>Login Name</td>
<td><input type="text" name="userName" ></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" ></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" ></td>
</tr>
<tr>
<td>Address</td>
<td><textarea name="address" rows=5 cols=25></textarea></td>
</tr>
<tr>
<td>Contact No</td>
<td><input type="text" name="contactNo" ></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Save"></td>
</tr>
</table>
</form>
</body>
</html>
<%String fname=request.getParameter("firstName");
String lname=request.getParameter("lastName");
String uname=request.getParameter("userName");
String password=request.getParameter("password");
String email=request.getParameter("email");
String address=request.getParameter("address");
String contact=request.getParameter("contactNo");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st = conn.createStatement();
int i=st.executeUpdate("insert into login(firstname,lastname,username,password,email,address,contactno) values('"+fname+"','"+lname+"','"+uname+"','"+password+"','"+email+"','"+address+"','"+contact+"')");
}
catch(Exception e){}
%>
<form name="form" action="details.jsp">
<table width="350px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
<td><input type="submit" value="continue" ></td></tr>
</table>
</form>
April 20, 2010 at 3:48 PM
continue..
4)details.jsp:
<%@ page import="java.sql.*"%>
<html>
<body>
<br>
<form method="post" >
<table width="350px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td colspan=2 style="font-weight:bold;font-size:20pt;" align="center">Education Details</td>
</tr>
<tr>
<td>Highest Qualification</td>
<td><input type="text" name="qualification" ></td>
</tr>
<tr>
<td>Specialization</td>
<td><input type="text" name="specialization"></td>
</tr>
<tr>
<td>Year Of Passing</td>
<td><input type="text" name="year" ></td>
</tr>
<tr>
<td>Institute</td>
<td><input type="text" name="institute" ></td>
</tr>
<tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Save Details"></td>
</tr>
</table>
</form>
</body>
</html>
<%String qua=request.getParameter("qualification");
String special=request.getParameter("specialization");
String year=request.getParameter("year");
String institute=request.getParameter("institute");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st = conn.createStatement();
int i=st.executeUpdate("insert into education(qualification,specialization,year,instatitute) values('"+qua+"','"+special+"','"+year+"','"+institute+"')");
}
catch(Exception e){}
%>
Thanks
4)details.jsp:
<%@ page import="java.sql.*"%>
<html>
<body>
<br>
<form method="post" >
<table width="350px" border=0 align="center" style="background-color:ffeeff;">
<tr>
<td colspan=2 style="font-weight:bold;font-size:20pt;" align="center">Education Details</td>
</tr>
<tr>
<td>Highest Qualification</td>
<td><input type="text" name="qualification" ></td>
</tr>
<tr>
<td>Specialization</td>
<td><input type="text" name="specialization"></td>
</tr>
<tr>
<td>Year Of Passing</td>
<td><input type="text" name="year" ></td>
</tr>
<tr>
<td>Institute</td>
<td><input type="text" name="institute" ></td>
</tr>
<tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Save Details"></td>
</tr>
</table>
</form>
</body>
</html>
<%String qua=request.getParameter("qualification");
String special=request.getParameter("specialization");
String year=request.getParameter("year");
String institute=request.getParameter("institute");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st = conn.createStatement();
int i=st.executeUpdate("insert into education(qualification,specialization,year,instatitute) values('"+qua+"','"+special+"','"+year+"','"+institute+"')");
}
catch(Exception e){}
%>
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
