i have developed code in jsp but the problem is i need to convert this to asp.........ple asehelp me regarding this im sending code which i've developed....wi th file names..........
code.jsp
<%@ page import = "java.util. *" %>
<%@ page import = "java.io.*" %>
<%@ page import = "java.lang. *" %>
<%@ page import = "org.apache.com mons.fileupload .*" %>
<%@ page import = "java.sql.* " %>
<%
try{
Connection con = null;
Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
String user="scott";
String password="tiger ";
System.out.prin tln("errrrrrrrr r");
con=DriverManag er.getConnectio n("jdbc:oracle: thin:@localhost :1521:welcome", user,password);
System.out.prin tln("errrrrrrrr ragain");
String name = null;
int icon = 0;
String name1=null,coun try1=null,state 1=null,gender1= null,age1=null, pref_lang1=null ,emailid1=null, comment1=null,s tory1=null,url= null;
File uploadFile=null ;
response.setCon tentType("text/html");
DiskFileUpload df=new DiskFileUpload( );
List items=df.parseR equest(request) ;
Iterator iter=items.iter ator();
while(iter.hasN ext())
{
FileItem item=(FileItem) iter.next();
if(item.isFormF ield())
{
name=item.getFi eldName();
if(name.equals( "name"))
{
name1=item.getS tring();
}
else if(name.equals( "country"))
{
country1=item.g etString();
}
else if(name.equals( "state"))
{
state1=item.get String();
}
else if(name.equals( "gender"))
{
gender1=item.ge tString();
}
else if(name.equals( "age"))
{
age1=item.getSt ring();
}
else if(name.equals( "language") )
{
pref_lang1=item .getString();
}
else if(name.equals( "emailid"))
{
emailid1= item.getString( );
}
else if(name.equals( "comment"))
{
comment1= item.getString( );
}
else if(name.equals( "story"))
{
story1= item.getString( );
}
}
else
{
String locPath = item.getString( );
String subPath = locPath.substri ng(0,locPath.in dexOf("."));
url ="c:\\bhanu\\"+ name1+".jpeg";
uploadFile=new File(url);
item.write(uplo adFile);
out.println("Fi le Uploaded Successfully... ....");
}
}
PreparedStateme nt stmt = con.prepareStat ement("insert into join_us values(?,?,?,?, ?,?,?,?,?,?)");
stmt.setString( 1,name1);
stmt.setString( 2,country1);
stmt.setString( 3,state1);
stmt.setString( 4,gender1);
stmt.setString( 5,age1);
stmt.setString( 6,pref_lang1);
stmt.setString( 7,emailid1);
stmt.setString( 8,comment1);
stmt.setString( 9,story1);
stmt.setString( 10,url);
stmt.executeUpd ate();
out.println("Yo ur details has been uploaded");
session.setAttr ibute("name","n ame1");
RequestDispatch er rd = request.getRequ estDispatcher(" codeDisplay.jsp ");
rd.forward(requ est,response);
}
catch(Exception e){
System.out.prin tln("errrrrrrrr r");
e.printStackTra ce();
}
%>
codeDisplay.jsp
<HTML>
<HEAD>
</HEAD>
<%@page import="java.sq l.*"%>
<BODY bgcolor="#00000 0"><center>
<marquee bgcolor="#CC669 9"><b>STOP TEARS</b></marquee><BR><BR ><BR>
<h2><font color="#993366" >STOP TEARS</font></h2>
<!--<form action="code.js p" method="post" >-->
<% String strName=null,st rCountry=null,s trState=null,st rGender=null,st rLang=null,strE mail=null,strCo mment=null,strS tory=null,strIm age=null,strAge =null;
%>
<%try{ String name = (String) session.getAttr ibute("name");
Connection con=null;
Statement stmt=null;
DriverManager.r egisterDriver(( Driver) Class.forName(" oracle.jdbc.dri ver.OracleDrive r").newInstance ());
con=DriverManag er.getConnectio n("jdbc:oracle: thin:@localhost :1521:welcome", "scott","tiger" );
stmt=con.create Statement();
//retriving data from database
ResultSet rs=stmt.execute Query("select * from join_us");
while(rs.next() ){
// ResultSet rs=stmt.execute Query("select * from join_us");
strName = ""+rs.getString (1);
strCountry = rs.getString(2) ;
strState = rs.getString(3) ;
strGender = rs.getString(4) ;
strAge = rs.getString(5) ;
strLang = rs.getString(6) ;
strEmail = rs.getString(7) ;
strComment = rs.getString(8) ;
strStory = rs.getString(9) ;
strImage = rs.getString(10 );
}//while close
}//try close
catch(Exception e){e.printStack Trace();}
%>
<table border=1 width="929" height="411">
<tr><th width="805" height="1"><fon t color="#669900" >Personal Details</font></th></tr>
<tr><td width="805" height="102">
<IMG
border="0" src=<%=strImage %> width="125" height="100"><b ><font color="#CC9900" >Name</font><INPUT readonly type='text'name ='Name' value='<%=strNa me%>' size="32"></b><font color="#CC9900" ><b>Country<INP UT readonly type='text'name ='Country' value='<%=strCo untry%>' size="20">
State<INPUT readonly type='text'name ='State' value='<%=strSt ate%>' size="20">
</b></font>
<p><font color="#CC9900" ><b>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp; Gender<INPUT readonly type='text'name ='Gender' value='<%=strGe nder%>' size="10"> Age<INPUT readonly type='text'name ='Age' value='<%=strAg e%>' size="5"> Language<INPUT readonly type='text'name ='' value='<%=strLa ng%>' size="20"> Email-id<INPUT readonly type='text'name ='' value='<%=strEm ail%>' size="20">
</b></font></p>
<p><font color="#CC9900" ><b>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp; Comment<INPUT readonly type='textarea' name='' value='<%=strCo mment%>' size="85">
</b></font></p>
<p><font color="#CC9900" ><b>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp; Story<INPUT readonly type='textarea' name='' value='<%=strSt ory%>' size="89">
</b></font></p>
<p> </td>
</tr>
</table>
</body>
</html>
code.jsp
<%@ page import = "java.util. *" %>
<%@ page import = "java.io.*" %>
<%@ page import = "java.lang. *" %>
<%@ page import = "org.apache.com mons.fileupload .*" %>
<%@ page import = "java.sql.* " %>
<%
try{
Connection con = null;
Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
String user="scott";
String password="tiger ";
System.out.prin tln("errrrrrrrr r");
con=DriverManag er.getConnectio n("jdbc:oracle: thin:@localhost :1521:welcome", user,password);
System.out.prin tln("errrrrrrrr ragain");
String name = null;
int icon = 0;
String name1=null,coun try1=null,state 1=null,gender1= null,age1=null, pref_lang1=null ,emailid1=null, comment1=null,s tory1=null,url= null;
File uploadFile=null ;
response.setCon tentType("text/html");
DiskFileUpload df=new DiskFileUpload( );
List items=df.parseR equest(request) ;
Iterator iter=items.iter ator();
while(iter.hasN ext())
{
FileItem item=(FileItem) iter.next();
if(item.isFormF ield())
{
name=item.getFi eldName();
if(name.equals( "name"))
{
name1=item.getS tring();
}
else if(name.equals( "country"))
{
country1=item.g etString();
}
else if(name.equals( "state"))
{
state1=item.get String();
}
else if(name.equals( "gender"))
{
gender1=item.ge tString();
}
else if(name.equals( "age"))
{
age1=item.getSt ring();
}
else if(name.equals( "language") )
{
pref_lang1=item .getString();
}
else if(name.equals( "emailid"))
{
emailid1= item.getString( );
}
else if(name.equals( "comment"))
{
comment1= item.getString( );
}
else if(name.equals( "story"))
{
story1= item.getString( );
}
}
else
{
String locPath = item.getString( );
String subPath = locPath.substri ng(0,locPath.in dexOf("."));
url ="c:\\bhanu\\"+ name1+".jpeg";
uploadFile=new File(url);
item.write(uplo adFile);
out.println("Fi le Uploaded Successfully... ....");
}
}
PreparedStateme nt stmt = con.prepareStat ement("insert into join_us values(?,?,?,?, ?,?,?,?,?,?)");
stmt.setString( 1,name1);
stmt.setString( 2,country1);
stmt.setString( 3,state1);
stmt.setString( 4,gender1);
stmt.setString( 5,age1);
stmt.setString( 6,pref_lang1);
stmt.setString( 7,emailid1);
stmt.setString( 8,comment1);
stmt.setString( 9,story1);
stmt.setString( 10,url);
stmt.executeUpd ate();
out.println("Yo ur details has been uploaded");
session.setAttr ibute("name","n ame1");
RequestDispatch er rd = request.getRequ estDispatcher(" codeDisplay.jsp ");
rd.forward(requ est,response);
}
catch(Exception e){
System.out.prin tln("errrrrrrrr r");
e.printStackTra ce();
}
%>
codeDisplay.jsp
<HTML>
<HEAD>
</HEAD>
<%@page import="java.sq l.*"%>
<BODY bgcolor="#00000 0"><center>
<marquee bgcolor="#CC669 9"><b>STOP TEARS</b></marquee><BR><BR ><BR>
<h2><font color="#993366" >STOP TEARS</font></h2>
<!--<form action="code.js p" method="post" >-->
<% String strName=null,st rCountry=null,s trState=null,st rGender=null,st rLang=null,strE mail=null,strCo mment=null,strS tory=null,strIm age=null,strAge =null;
%>
<%try{ String name = (String) session.getAttr ibute("name");
Connection con=null;
Statement stmt=null;
DriverManager.r egisterDriver(( Driver) Class.forName(" oracle.jdbc.dri ver.OracleDrive r").newInstance ());
con=DriverManag er.getConnectio n("jdbc:oracle: thin:@localhost :1521:welcome", "scott","tiger" );
stmt=con.create Statement();
//retriving data from database
ResultSet rs=stmt.execute Query("select * from join_us");
while(rs.next() ){
// ResultSet rs=stmt.execute Query("select * from join_us");
strName = ""+rs.getString (1);
strCountry = rs.getString(2) ;
strState = rs.getString(3) ;
strGender = rs.getString(4) ;
strAge = rs.getString(5) ;
strLang = rs.getString(6) ;
strEmail = rs.getString(7) ;
strComment = rs.getString(8) ;
strStory = rs.getString(9) ;
strImage = rs.getString(10 );
}//while close
}//try close
catch(Exception e){e.printStack Trace();}
%>
<table border=1 width="929" height="411">
<tr><th width="805" height="1"><fon t color="#669900" >Personal Details</font></th></tr>
<tr><td width="805" height="102">
<IMG
border="0" src=<%=strImage %> width="125" height="100"><b ><font color="#CC9900" >Name</font><INPUT readonly type='text'name ='Name' value='<%=strNa me%>' size="32"></b><font color="#CC9900" ><b>Country<INP UT readonly type='text'name ='Country' value='<%=strCo untry%>' size="20">
State<INPUT readonly type='text'name ='State' value='<%=strSt ate%>' size="20">
</b></font>
<p><font color="#CC9900" ><b>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp; Gender<INPUT readonly type='text'name ='Gender' value='<%=strGe nder%>' size="10"> Age<INPUT readonly type='text'name ='Age' value='<%=strAg e%>' size="5"> Language<INPUT readonly type='text'name ='' value='<%=strLa ng%>' size="20"> Email-id<INPUT readonly type='text'name ='' value='<%=strEm ail%>' size="20">
</b></font></p>
<p><font color="#CC9900" ><b>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp; Comment<INPUT readonly type='textarea' name='' value='<%=strCo mment%>' size="85">
</b></font></p>
<p><font color="#CC9900" ><b>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp; Story<INPUT readonly type='textarea' name='' value='<%=strSt ory%>' size="89">
</b></font></p>
<p> </td>
</tr>
</table>
</body>
</html>
Comment