This project provides sample code and documentation for Online Advertising Agency Project to all final semester students at engineering level, Degree level and also Masters Level. This project provide advertising facilities at online using internet world.

Online Advertising Agency Project trail application module code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
import java.io.*;
import java.util.*;
public class trialapp extends HttpServlet
{
String trialno,applno,subid,msg=" ",img;
int trial_no,appno;
ResultSet rs,rs1;
Statement stmt,stmt1;
PreparedStatement pstmt;
Connection con;
String str,str1,str2;
public void init(ServletConfig sc)throws ServletException
{
super.init(sc);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:advt","scott","tiger");
System.out.println("connection established");
}catch(Exception e){}
}
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
applno=req.getParameter("applno");
appno=Integer.parseInt(applno);
trialno=req.getParameter("r1");
subid=req.getParameter("subid");
trial_no=Integer.parseInt(trialno);
img=req.getParameter("img")+".gif";
System.out.println(img);
try
{
stmt=con.createStatement();
rs=stmt.executeQuery("select typeid from subtypes1 where applno="+appno);
rs.next();
str=rs.getString(1);
stmt.close();
stmt1=con.createStatement();
rs1=stmt1.executeQuery("select images from user_applications where applno="+appno);
rs1.next();
str1=rs1.getString(1);
stmt1.close();
if(trial_no==1)
{

if(str.startsWith("N"))
{
if(subid.equals("halfqtr"))
{
pw.println("");
pw

Download  the Online Advertising Agency Project Documentation