This the source, please check this.
<%@ page language = "java" import =
"java.sql.*,oracle.jdbc.driver.OracleDriver" %>
<html><head><title>Registration Form</title></head>
<script language=JavaScript src=webFrmValid.js></script>
</head>
<body leftmargin=0 topmargin=0 marginheight=0 bgcolor=#FFFCD5 marginwidth=0>
<table border="0" width="100%" bgcolor="#FFFCD5" cellspacing="0"
cellpadding="0">
<tr><td width="17%" bgcolor="#000000" height="100">
<img SRC="../WebAcc/Image/Earth.jpg" ALT="Earth.jpg (19123 bytes)"
height="100" width="100"></td>
<td width="83%" bgcolor="#000000" height="100"><p align="center">
<font size="+2" color="#FFFF00" face="Copperplate Gothic Bold">Web Based
Personal Accounting System</font>
<br><font size="2"><font color="#FFFFC6"><b>(Your Any Time Any Where
Accountant)</b></font>
</font></td></tr></table>
<div align=center> </div>
<%
Connection con = null;
//try
//{
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//con=DriverManager.getConnection("jdbc:odbc:WebAcc","WebAcc","WebAcc");
DriverManager.registerDriver(new OracleDriver());
con =
DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521:dlinx","use
r","password");
}
catch(SQLException e)
{
response.sendRedirect("../WebAcc/siteUnava.htm");
}
Statement st=con.createStatement();
Statement stt=con.createStatement();
Statement st1=con.createStatement();
Statement st2=con.createStatement();
ResultSet rs=null;
ResultSet rs1=null;
con.setAutoCommit(false);
int id=0;
int cnt=0;
int nameCount = 0;
String a = "sss";
String status = "active";
String underscore = "_";
String firstSub = "";
String middleSub = "";
String lastSub = "";
String firlastSub = "";
String countName = "";
String username = request.getParameter("Reg_frmRegUname");
String password = request.getParameter("Reg_frmRegPword");
String firstname = request.getParameter("Reg_frmRegFName");
String middlename = request.getParameter("Reg_frmRegMName");
String lastname = request.getParameter("Reg_frmRegLName");
String saddress = request.getParameter("Reg_frmRegSAddress");
String city = request.getParameter("Reg_frmRegCity");
String state = request.getParameter("Reg_frmRegState");
String country = request.getParameter("Reg_frmRegCountry");
String zcode = request.getParameter("Reg_frmRegZcode");
String phone = request.getParameter("Reg_frmRegPNo");
String emailid = request.getParameter("Reg_frmRegEmail");
String fax = request.getParameter("Reg_frmRegFax");
String hquestion = request.getParameter("Reg_frmRegHquestion");
String hanswer = request.getParameter("Reg_frmRegHanswer");
rs1 = stt.executeQuery("select count(*) from tbl_reg_usermast where
fld_reg_var2usrname='"+username+"' ");
if(rs1.next())
{
cnt = Integer.parseInt(rs1.getString(1));
}
rs1.close();
if(!(cnt>=1))
rs = st1.executeQuery("select FN_REG_USRAUTO ausrid from
dual");
if(rs.next())
{
String uid = rs.getString("ausrid");
id = Integer.parseInt(uid);
int i=st.executeUpdate("insert into tbl_reg_usermast
values("+id+",'"+username+"','"+password+"','"+status+"')");
int j=st2.executeUpdate("insert into tbl_reg_userdet
values("+id+",'"+firstname+"','"+middlename+"','"+lastname+"','"+saddress+"'
,'"+a+"','"+city+"','"+state+"','"+country+"','"+zcode+"','"+phone+"','"+fax
+"','"+emailid+"','"+hquestion+"','"+hanswer+"')");
if(i==1 && j==1)
{
con.commit();
out.println("<table border=0 width=100%
cellspacing=0
cellpadding=0><tr><td width=\"100%\"><center><br><font face=tahoma
color=#800000 size=2><b>Hi "+username+"<br><br><br>Thank you for registering
with us. Please remember your Username &
password</b></font><br><br><br><b><a href=../WebAcc/home.htm
style=\"text-decoration:
none\">CONTINUE</a></b></center></td></tr></table></table>");
}
else
{
con.rollback();
}
}
rs.close();
}
else
{
out.println("<form name=frmReg method=POST
action=../WebAcc/RegForm1.jsp
onsubmit=\"return chkOptions(this)\">");
out.println("<div align=center><center>");
out.println("<table border=0 width=100% cellspacing=0
cellpadding=0>");
out.println("<tr><td width=\"10%\"></td>");
out.println("<td width=80% bgcolor=#346767
align=center><strong>");
out.println("<font color=#FFFFFF face=Times New Roman
size=3> </font>");
out.println("<font color=#FFFFFF>The Username <font
face=arial size=3
color=#ffff00>"+username+"</font> you have choosen is already in
use.</font>");
out.println("</strong></td><td width=\"10%\"></td></tr>");
out.println("<tr><td width=\"10%\"></td>");
out.println("<td width=80% bgcolor=#346767 align=center><font
color=#FFFFFF></font>");
out.println("<font color=#FFFFFF face=Times New Roman
size=3>");
out.println("<strong>Please select a suggested Username or
type in a new
Username</strong>.</font>");
out.println("</td><td width=\"10%\"></td></tr>");
out.println("</table></center></div>");
out.println("<div align=center><br><center>");
out.println("<table border=0 width=100% cellspacing=0
cellpadding=0>");
out.println("<tr>");
for(int i=0;i<firstname.length();i++)
{
firstSub = username + underscore + firstname.charAt(i);
rs1 = st.executeQuery("select FLD_REG_VAR2USRNAME from
TBL_REG_USERMAST
where FLD_REG_VAR2USRNAME='"+firstSub+"'");
if(rs1.next()==false)
{
out.println("<td width=25% align=right><input
type='radio'
name='Reg_frmRegUname1' value=\""+firstSub+"\" checked></td>");
out.println("<td width=75% align=left><font
face=Arial size=2
color=#000000><b>"+firstSub+"</b></font></td></tr>");
break;
}
rs1.close();
}
if(!(middlename.equals(null)))
{
for(int i=0;i<middlename.length();i++)
{
middleSub = username + underscore +
middlename.charAt(i);
rs1 = st.executeQuery("select
FLD_REG_VAR2USRNAME from TBL_REG_USERMAST
where FLD_REG_VAR2USRNAME='"+middleSub+"'");
if(rs1.next()==false)
{
if(!middleSub.equals(firstSub))
{
out.println("<td width=25%
align=right><input type='radio'
name='Reg_frmRegUname1' value=\""+middleSub+"\"></td>");
out.println("<td width=75%
align=left><font face=Arial size=2
color=#000000><b>"+middleSub+"</b></font></td></tr>");
break;
}
}
rs1.close();
}
}
else
{
for(int i=0;i<hquestion.length();i++)
{
middleSub = username + underscore +
hquestion.charAt(i);
rs1 = st.executeQuery("select
FLD_REG_VAR2USRNAME from TBL_REG_USERMAST
where FLD_REG_VAR2USRNAME='"+middleSub+"'");
if(rs1.next()==false)
{
if(!middleSub.equals(firstSub))
{
out.println("<td width=25%
align=right><input type='radio'
name='Reg_frmRegUname1' value=\""+middleSub+"\"></td>");
out.println("<td width=75%
align=left><font face=Arial size=2
color=#000000><b>"+middleSub+"</b></font></td></tr>");
break;
}
}
rs1.close();
}
}
for(int i=0;i<lastname.length();i++)
{
lastSub = username + underscore + lastname.charAt(i);
rs1 = st.executeQuery("select FLD_REG_VAR2USRNAME from
TBL_REG_USERMAST
where FLD_REG_VAR2USRNAME='"+lastSub+"'");
if(rs1.next()==false)
{
if(!(lastSub.equals(middleSub)) &&
!(lastSub.equals(firstSub)))
{
out.println("<td width=25%
align=right><input type='radio'
name='Reg_frmRegUname1' value=\""+lastSub+"\"></td>");
out.println("<td width=75%
align=left><font face=Arial size=2
color=#000000><b>"+lastSub+"</b></font></td></tr>");
break;
}
}
rs1.close();
}
for(int i=0;i<lastname.length();i++)
firlastSub = username + underscore +
firstname.charAt(i) +
lastname.charAt(i);
rs1 = st.executeQuery("select FLD_REG_VAR2USRNAME from
TBL_REG_USERMAST
where FLD_REG_VAR2USRNAME='"+firlastSub+"'");
if(rs1.next()==false)
{
out.println("<td width=25% align=right><input
type='radio'
name='Reg_frmRegUname1' value=\""+firlastSub+"\"></td>");
out.println("<td width=75% align=left><font
face=Arial size=2
color=#000000><b>"+firlastSub+"</b></font></td></tr>");
break;
}
rs1.close();
}
rs = st2.executeQuery("select count(*) from TBL_REG_USERMAST");
if(rs.next())
{
nameCount = rs.getInt(1);
}
countName = username + underscore + nameCount;
rs1 = st.executeQuery("select FLD_REG_VAR2USRNAME from
TBL_REG_USERMAST
where FLD_REG_VAR2USRNAME='"+countName+"'");
if(rs1.next()==false)
{
out.println("<td width=25% align=right><input
type='radio'
name='Reg_frmRegUname1' value=\""+countName+"\"></td>");
out.println("<td width=75% align=left><font face=Arial
size=2
color=#000000><b>"+countName+"</b></font></td></tr>");
}
rs1.close();
out.println("</tr><tr><td width=25% align=right>");
out.println("<font face=Arial size=2><b><font
color=#000000>Your
Choice</font>");
out.println("<font face=Arial color=#000000
size=2>:</font></b></font></td>");
out.println("<td width=75% align=left><input type=text
name=Reg_frmRegUname2 size=43 onchange=onchg() onblur=onchg()></td>");
out.println("<input type=hidden name=Reg_frmRegUname><input
type=hidden
name=Reg_frmRegPword value=\""+password+"\">");
out.println("<input type=hidden name=Reg_frmRegFName
value=\""+firstname+"\"><input type=hidden name=Reg_frmRegMName
value=\""+middlename+"\">");
out.println("<input type=hidden name=Reg_frmRegLName
value=\""+lastname+"\"><input type=hidden name=Reg_frmRegSAddress
value=\""+saddress+"\">");
out.println("<input type=hidden name=Reg_frmRegCity
value=\""+city+"\"><input type=hidden name=Reg_frmRegState
value=\""+state+"\">");
out.println("<input type=hidden name=Reg_frmRegCountry
value=\""+country+"\"><input type=hidden name=Reg_frmRegZcode
value=\""+zcode+"\">");
out.println("<input type=hidden name=Reg_frmRegPNo
value=\""+phone+"\"><input type=hidden name=Reg_frmRegEmail
value=\""+emailid+"\">");
out.println("<input type=hidden name=Reg_frmRegFax
value=\""+fax+"\"><input type=hidden name=Reg_frmRegHquestion
value=\""+hquestion+"\">");
out.println("<input type=hidden name=Reg_frmRegHanswer
value=\""+hanswer+"\">");
out.println("</tr></tr></table>");
out.println("</center></div><div align=center><center><p>");
out.println("<input type=submit value=Submit name=B1>");
out.println("<input type=reset value=Reset name=B2></p>");
out.println("</center></div><div align=center><center>");
out.println("</center></div></form></td></tr></table>");
}
/*}
catch(Exception e)
{
try
{
con.rollback();
}
catch(SQLException sql){}
}*/
con.close();
%>
<div align="center"> </div>
<table border="0" width="100%" bgcolor="#FFFCD5" cellspacing="0"
cellpadding="0">
<tr><td width="100%" align="center">
<font face="Arial Narrow" size="1" color="#66A0E6">Copyright � 2000 All
Rights Reserved S3iL</font></td></tr>
</table>
</body></html>
-----Original Message-----
From: Matthew L. Wright [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 03, 2001 4:30 AM
To: JRun-Talk
Subject: Re: what is this can any one help me (utf codE)
Can you copy and past the code itself, easier to take a look at the source
than the result. :)
Matt
Java Internet Programmer
Jupiter One, Web World Studios WC
www.jupiterone.com
(818) 763-2927
----- Original Message -----
From: "Venkata Sudheer Buddiga" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 03, 2001 2:13 PM
Subject: what is this can any one help me (utf codE)
> Hi all,
>
> please help me in solving this problem,
>
> when I hit a page I am getting these lines in error file, please help in
> solving......
>
> Sat Mar 03 13:09:40 PST 2001: Running servlet
> { (Running servlet) javax.servlet.ServletException: Invalid UTF-8 code.
> (bytes: 0xffffffa9 0x20)
> at com.livesoftware.jsp.JSPServlet.service(JSPServlet.java, Compiled Code)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
> at com.livesoftware.jrun.JRun.runServlet(JRun.java, Compiled Code)
> at com.livesoftware.jrun.JRunGeneric.handleConnection(JRunGeneric.java,
> Compiled Code)
> at
> com.livesoftware.jrun.JRunGeneric.handleProxyConnection(JRunGeneric.java,
> Compiled Code)
> at
>
com.livesoftware.jrun.service.proxy.JRunProxyServiceHandler.handleRequest(JR
> unProxyServiceHandler.java, Compiled Code)
> at
>
com.livesoftware.jrun.service.ThreadConfigHandler.run(ThreadConfigHandler.ja
> va, Compiled Code)
> }
>
>
> TIA
> sudheer.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
