1000 Projects
<<<Classroom & Online Training's on android, Java, .Net, C, C++, Big Data Hadoop, SAP, SQL, Oracle, Sales Force>>>

Advertising Agency Project in Java

August 26, 2012

Advertising agency project is developed in java platform. Main aim of this project is to provide a web based application for advertising agency to take orders from clients and improve chances of advertising business by going online. Clients can look after the sample works which are done by advertising agency and contact agency and find solution in quick time.  In present trend most of the systems work on web for increasing business.

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");
}catch(Exception e){System.OUT.println(e);}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
try
{

applno=req.getParameter("applno");
appno=INTEGER.parseInt(applno);
trialno=req.getParameter("trialno");
subid=req.getParameter("subid");
trial_no=INTEGER.parseInt(trialno);
stmt=con.createStatement();
rs=stmt.executeQuery("select pname,sysdate from user_applications where applno="+appno);
rs.NEXT();
party=rs.getString(1);
bdate=rs.getDate(2);
//rs.close();
stmt.close();

stmt2=con.createStatement();
rs2=stmt2.executeQuery("select 'B'||lpad(to_char(nvl(to_number(max(substr(receiptno,3))),0)+1),3,'0') from user_applications");

while(rs2.NEXT())
{
billno=rs.getString(1);
}
stmt2.close();
stmt3=con.createStatement();
INT x=stmt3.executeUpdate("update user_applications set receiptno='"+billno+"' where applno="+appno);
stmt3.close();
stmt4=con.createStatement();
rs3=stmt4.executeQuery("select typeid from subtypes1 where applno="+appno);
rs3.NEXT();
typeid=rs.getString(1);
stmt4.close();
pstmt2=con.prepareStatement("update user_applications set receipt_date=? where applno=?");
pstmt2.setDate(1,bdate);
pstmt2.setInt(2,appno);
pstmt2.executeUpdate();
pstmt2.close();

Computer science students can find more advertising agency related project reports and source code in java and asp.net for free download.

Download advertising agency project in java with source code.


posted in CSE Mini Projects, CSE Projects with Source Code, J2EE Projects, Java Based Projects, Web based projects in java by Ramesh Gavva/Kasarla shanthan

Follow comments via the RSS Feed | Leave a comment | Trackback URL


‹‹‹ Online Address Book Project in Java with Source Code

Inet Address Class in java ›››

Custom Search

Leave Your Comment

 
Copyright 2014 | Powered by 1000Projects.org | Developed by WikiHands.