Registration Form for User Accounts
Registration Form for User Accounts
[Link]
<%
String basePath =
[Link]()+"://"+[Link]()+":"+[Link]()+path+"/";
%>
<html>
<head>
<base href="<%=basePath%>">
<!--
-->
<script language="JavaScript" src="<%=[Link]()+"/js/gen_validatorv31.js"%>"
type="text/javascript"></script>
<script>
function goOn() {
var port=[Link];
var host=[Link];
var userName=[Link];
[Link]='[Link]
erName+"&path=./[Link]";
;
</script>
<body>
<jsp:include page="[Link]"></jsp:include>
<br />
<center>
<h3>
</h3>
</center>
onSubmit="return validate()">
<!--<table border="1"><tr><td></td></tr></table>-->
<br />
Account Details
</th>
<tr></tr>
<tr></tr>
<tr>
<td align='right'>
User Name :
</td>
<td width="303">
value="<%
if([Link]("userName")!=null)
[Link]([Link]("userName")); %>"
<td align='left'>
test="${'requestScope.status1'!='null'}">
<c:out
value="${param.status1}"></c:out>
</c:if> </font>
</b>
</td>
<td></td><td></td>
<td></td>
</tr>
<tr>
<td align='right'>
PassWord :
</td>
<td>
onkeyup="testPassword([Link]);"
onchange="Encrypt([Link]);" />
</td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td align='right'>
</td>
<td>
<tr>
<td height=15 bgcolor=red></td>
</tr>
</table></center>
</td>
<td></td>
</tr>
<tr>
<td align='right'>
Confirm :
</td>
<td>
onBlur="checkconformpassword()" />
</td>
</td>
</tr>
<tr>
<td align='right'>
User Type :
</td>
<td width="276">
</option>
<option value="student">
<font size="3"
face="Verdana">Student</font>
</option>
<option value="faculty">
<font size="3"
face="Verdana">Faculty</font>
</option>
<option value="moderator">
<font size="3"
face="Verdana">Moderator</font>
</option>
</select>
</td>
<tr>
<td align='right'>
SecurityQuestion :
</td>
<td>
<select name="squest">
</option>
<option value="What is your favorite
pastime?">
pastime?</font>
</option>
</option>
first school?</font>
</option>
spouse?</font>
</option>
sports team?</font>
</option>
name?</font>
</option>
mascot?</font>
</option>
car or bike?</font>
</option>
</option>
</select>
</td>
</tr>
<tr>
onClick="check(register)" />
Own Question :
</td>
</tr>
<tr>
<td>
<td>
</td>
</tr>
<tr>
<td align='right'>
Security Answer :
</td>
<td>
</td>
</tr>
<tr></tr>
<tr></tr>
Personal Details
</th>
<tr></tr>
<tr></tr>
<tr>
<td align='right'>
First Name :
</td>
<td width="276">
<td align='right'>
Gender :
</td>
<td>
<select name="gender">
</option>
<option value="Male">
<font size="3"
face="Verdana">Male</font>
</option>
<option value="Female">
<font size="3"
face="Verdana">Female</font>
</option>
</select>
</td>
</tr>
<tr>
<td align='right'>
Last Name :
</td>
<td width="276">
</td>
<td align='right'>
Email :
</td>
<td>
</td>
</tr>
<tr>
<td align='right'>
Birth Date :
</td>
<td>
readonly="readonly" />
<a
href="javascript:show_calendar('[Link]', [Link]);">
<img src="<%=[Link]()+"/images/[Link]"%>" alt="a" width="18" height="18"
border="0"/></a>
</td>
<td align='right'>
Fax No :
</td>
<td>
</td>
</tr>
<tr>
<td align='right'>
Browse Photo :
</td>
<td>
onChange="preview(this)" />
</td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
<tr></tr>
<tr></tr>
<center>
Contact Details
</center>
</th>
<tr></tr>
<tr></tr>
<tr>
<td align='right'>
Address Type :
</td>
<td width="276">
</option>
<option value="home">
<font size="3"
face="Verdana">Home</font>
</option>
<option value="office">
<font size="3"
face="Verdana">Office</font>
</option>
<option value="personal">
<font size="3"
face="Verdana">Personal</font>
</option>
</select>
</td>
City :
</td>
<td width="273">
</td>
</tr>
<tr>
<td align='right'>
House No :
</td>
<td>
</td>
</tr>
<tr>
<td align='right'>
Street :
</td>
<td>
</td>
<td align='right'>
State :
</td>
<td>
</td>
</tr>
<tr>
<td align='right'>
Country :
</td>
<td>
</td>
</tr>
<tr>
<td align='right'>
Phone No :
</td>
<td>
onBlur="ValidateForm()" />
</td>
<td align='right'>
Pin :
</td>
<td>
onChange="showStatus()" />
</td>
</tr>
<th colspan="5">
</th>
<tr></tr>
<tr></tr>
<tr>
<td></td>
<td align="right">
name="register" value="Register"
/> </font>
</td>
<td align="left">
</td>
<td></td>
</tr>
</table>
<p>
<br />
<br />
<br />
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
<br />
</p>
</form>
//You should create the validator only after the definition of the HTML form
[Link]("gender","dontselect=0");
[Link]("email","maxlen=50");
[Link]("email","req");
[Link]("email","email");
[Link]("addressType","dontselect=0");
[Link]("phoneType","dontselect=0");
[Link]("phoneNo","req");
[Link]("phoneNo","maxlen=50");
[Link]("phoneNo","numeric");
[Link]("phoneNo","Phone");
[Link]("squest","dontselect=0");
</script>
<br />
<br />
<jsp:include page="[Link]"></jsp:include>
</body>
</html>
[Link]
package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public ProfileTo() {
} catch (NoSuchMethodException e) {
// TODO Auto-generated catch block
[Link]();
}
}
[Link]
package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class ProfileDAOImpl implements ProfileDAOI {
public Connection con;
private boolean flag;
/** Creates a new instance of ProfileDAO */
public ProfileDAOImpl(){
con=[Link]();
}
//User Registration
public boolean changePass(profileformbean pro) {
// TODO Auto-generated method stub
return false;
}
public boolean changeQuestion(profileformbean pro) {
// TODO Auto-generated method stub
return false;
}
public String checkUser(String userName) {
String user=null;
[Link]("username"+userName);
try
{
[Link](true);
CallableStatement cstmt=[Link]("{ call loginidavailablity(?,?) }");
[Link](1, userName);
[Link](2,[Link]);
[Link]();
user=[Link](2);
}
catch (SQLException ex)
{[Link]();
[Link](ex);
user=null;
}
catch (Exception e)
{
[Link](e);
user=null;
}
finally
{
try
{
[Link]();
}
catch(SQLException se)
{
[Link](se);
}
catch(Exception e)
{
[Link](e);
}
}
return user;
}
public boolean insertNewUser(profileformbean pro) throws FileNotFoundException{
boolean flag=false;
String firstname = [Link]();
[Link]("fname:"+firstname);
String lastname = [Link]();
[Link]("lname:"+lastname);
String birthdate = [Link]([Link]());
[Link]("dob:"+birthdate);
String squest = [Link]();
[Link]("question:"+squest);
if([Link]("")){
squest = [Link]();
[Link](squest);}
String sqansw = [Link]();
[Link]("answer:"+sqansw);
String fax = [Link]();
[Link]("fax:"+fax);
String email = [Link]();
[Link]("email:"+email);
String gender = [Link]();
[Link]("gender:"+gender);
String addresstype = [Link]();
[Link]("addresstype is:"+addresstype);
String houseno = [Link]();
[Link]("house no :"+houseno);
String street = [Link]();
[Link]("street:"+street);
String city = [Link]();
[Link]("city :"+city);
String state=[Link]();
[Link]("state:"+state);
String country=[Link]();
[Link]("country:"+country);
String pin = [Link]();
[Link]("pin:"+pin);
String phoneno = [Link]();
[Link]("phone is"+phoneno);
String logintype = [Link]();
[Link]("usertype is :"+logintype);
String username = [Link]();
[Link]("user is :"+username);
String password = [Link]();
[Link]("password is:"+password);
String photo= [Link]();
try {
[Link]("photo=" + photo);
File f = new File(photo);
FileInputStream fis = new FileInputStream(f);
[Link]("fole=" + [Link]());
CallableStatement cstmt = con
.prepareCall("{call
insertprocedure(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}");
[Link](1, fis, (int) [Link]());
[Link](2, firstname);
[Link](3, lastname);
[Link](4, birthdate);
[Link](5, squest);
[Link](6, sqansw);
[Link](7, email);
[Link](8, fax);
[Link](9, gender);
[Link](10, username);
[Link](11, password);
[Link](12, logintype);
[Link](13, addresstype);
[Link](14, houseno);
[Link](15, street);
[Link](16, city);
[Link](17, state);
[Link](18, country);
[Link](19, pin);
[Link](20, phoneno);
int i = [Link]();
if (i >= 0) {
flag = true;
} else {
flag = false;
}
[Link]();
} catch (SQLException e) {
[Link]([Link]());
if (e
.toString()
.equalsIgnoreCase(
"[Link]: [Microsoft][ODBC driver for
Oracle][Oracle]ORA-12571: TNS:packet writer failure")) {
flag = true;
[Link]("n===" + flag);
}
[Link](e);
} catch (Exception e) {
[Link]();
flag = false;
try {
[Link]();
} catch (SQLException se) {
[Link]();
}
}
return flag;
}
//Getting profile
public profileformbean getProfile(String loginname,String path)
{
profileformbean rb=new profileformbean();
try
{
CallableStatement cs=[Link]("{call showprofile(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}");
[Link](1,loginname);
[Link](2,[Link]);
[Link](3,[Link]);
[Link](4,[Link]);
[Link](5,[Link]);
[Link](6,[Link]);
[Link](7,[Link]);
[Link](8,[Link]);
[Link](9,[Link]);
[Link](10,[Link]);
[Link](11,[Link]);
[Link](12,[Link]);
[Link](13,[Link]);
[Link](14,[Link]);
[Link](15,[Link]);
[Link](16,[Link]);
[Link]();
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
//[Link]([Link]());
[Link]([Link](6));
[Link]([Link](7));
//[Link]([Link](8));
[Link]([Link](9));
[Link]([Link](10));
[Link]([Link](11));
[Link]([Link](12));
//[Link]([Link](13));
[Link]([Link](13));
[Link]([Link](14));
[Link]([Link](15));
Blob b =[Link](16);
byte b1[]=[Link](1,(int)[Link]());
OutputStream fout=new FileOutputStream(path+"/"+loginname+"+.jpg");
[Link](b1);
}
catch(Exception e)
{[Link]();
[Link](e);
}
finally
{
try{
[Link]();
}catch(Exception e)
{
[Link](e);
}
}
return rb;
}
}
[Link]
package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
/**
*/
/**
* This method is called when a form has its tag value method equals to
* post.
* @param request
* @param response
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
RequestDispatcher rd = null;
try {
[Link](pf, map);
[Link]();
[Link]();
try {
if (flag) {
path = UtilConstants._STATUS;
[Link]("status",
UtilConstants._REGISTERED_SUCCESS);
} else {
path = UtilConstants._STATUS;
[Link]("status", UtilConstants._REGISTERED_FAIL);
} catch (Exception e) {
[Link]();
path = UtilConstants._STATUS;
[Link]("status", UtilConstants._INVALID_ENTRIES);
rd = [Link](path);
[Link](request, response);