register.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
background-image: url();
}
-->
</style></head>
<body>
<table width="800" height="1028" border="0" align="center">
<tr>
<td width=
"795" height=
"134"><img src=
"banner2.gif" width=
"795" height=
"95" align=
"top" /><br />
<img src=
"home.gif" width=
"132" height=
"35" /><img src=
"team.gif" width=
"132" height=
"35" /><img src=
"players.gif" width=
"132" height=
"35" /><img src=
"message.gif" width=
"132" height=
"35" /><img src=
"tranfer.gif" width=
"132" height=
"35" /><img src=
"about.gif" width=
"135" height=
"35" /></td>
</tr>
<tr>
<td height="788" align="left" valign="top"><form id="form1" name="form1" method="post" action="doregister.jsp">
<p> </p>
<table width="200" border="1">
<tr>
<td colspan=
"2"><div align=
"center">Register</div></td>
</tr>
<tr>
<td width="83">Username</td>
<td width="101"><label>
<input type="text" name="txtuser" id="txtuser" />
</label></td>
</tr>
<tr>
<td>Password</td>
<td><label>
<input type="password" name="txtpass" id="txtpass" />
</label></td>
</tr>
<tr>
<td>Age</td>
<td><label>
<input type="text" name="txtage" id="txtage" />
</label></td>
</tr>
<tr>
<td>Club</td>
<td><label>
<select name="selectclub" id="selectclub">
<option>Manchaster United</option>
<option>Inter Milan</option>
</select>
</label></td>
</tr>
<tr>
<td colspan="2"><label>
<div align="center">
<input type="submit" name="button" id="button" value="Submit" />
</div>
</label></td>
</tr>
<tr>
<td height="62" colspan="2"> <%
String error = request.getParameter("err");
if(error!=null) out.println(error);
%></td>
</tr>
</table>
</form>
<p> </p></td>
</tr>
<tr>
<td height=
"80" align=
"left" valign=
"top"><p> </p>
<p>
</p></td>
</tr>
</table>
</body>
</html>
doregister.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file ="konek.jsp" %>
<%
String user = request.getParameter("txtuser");
String pass = request.getParameter("txtpass");
String age = request.getParameter("txtage");
String query = null;
if(user == null || user.equals(""))
{
response.sendRedirect("register.jsp?err = please fill the username");
}
else if (user != null)
{
query = "select username from msUser where username like '%"+user+"%'";
}
else if(pass == null || pass.equals(""))
{
response.sendRedirect("register.jsp?err = please fill the pass");
}
else if(age == null || age.equals(""))
{
response.sendRedirect("register.jsp?err = please fill the age");
}
else
{
if(user == query)
{
response.sendRedirect("register.jsp?err = please choose a diffrent user name");
}
else if(user != query)
{
st.executeUpdate("insert into msUser values('"+user+"','"+pass+"',"+age+")");
con.close();
response.sendRedirect("home.jsp");
}
}
%>