Hi,
I tried similar way as Abhay, and having error message
"java.net.UnknownServiceException:protocol doesn't support output". Do you
have any idea? If I use full path to servlet directory, then the applet
doesn't find the servlet. I placed my applet under webpages directory and
my servlets under servlet directory which is two directory under webpages.
Any insights?
//************************here is my applet
import java.awt.*;
import java.applet.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.net.*;
public class gantt extends Applet
{
private Vector queryResults;
private String message = "Initializing";
int step_size = 0;
String week = "";
int sdate, fdate, smonth, fmonth, syear, fyear;
int semester_date = 21;
int semester_month = 8;
int semester_year = 2000;
ObjectOutputStream outputToServlet;
ObjectInputStream inputFromServlet;
static final int DEFAULT_PORT = 8113;
public void init() {
step_size = 18;
week = "w";
setBackground(Color.white);
String team = getParameter("team");
try{
//establish connection to dbservlet
//String location = "http://pete.cs.msstate.edu:8113/servlet/dbserver";
URL dbserver = new URL(getCodeBase(), "/servlet/dbserver");//location);
URLConnection servletConnection =dbserver.openConnection();
//establish the bridge that applet can send a message to the dbservlet
servletConnection.setDoInput(true);
servletConnection.setDoOutput(true);
//don't use a cached version of URL connection
servletConnection.setUseCaches(false);
servletConnection.setDefaultUseCaches(false);
//set content type that we will send binary data to dbservlet
servletConnection.setRequestProperty("Content-Type",
"application/Octet-stream");
outputToServlet = new ObjectOutputStream(servletConnection.getOutputStream());
outputToServlet.writeObject(team);
outputToServlet.flush();
outputToServlet.close();
//for reading vector from dbservlet
inputFromServlet = new ObjectInputStream(servletConnection.getInputStream());
queryResults = (Vector) inputFromServlet.readObject();
}
catch(Exception e){
System.out.println("exceptions :"+e);
}
}//end of init
public void paint(Graphics g) {
}//end of int paint
}//end of gantt
/*************my servlet
import java.io.*;
import java.util.*;
import java.lang.*;
import java.sql.*;
import oracle.jdbc.driver.*;
import java.net.*;
import javax.servlet.http.*;
public class dbserver implements Serializable
{
private Vector queryResults;
//String team="";
private Connection dbc;
Statement get_team;
ResultSet rs_team;
Statement stmt;
ResultSet rs;
public void doPost(HttpServletRequest request, HttpServletResponse response) {
ObjectInputStream inputFromApplet = null;
String team = null;
PrintWriter out = null;
BufferedReader inTest = null;
try{
//get an input steam from the applet
inputFromApplet = new ObjectInputStream(request.getInputStream());
team = (String)inputFromApplet.readObject();
inputFromApplet.close();
//Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url ="jdbc:oracle:thin:@walt.cs.msstate.edu:1521:CS";
Connection dbc = DriverManager.getConnection(url, "hp1", "ChunSu34");
}
catch(Exception e){
System.out.println("Cannot connect to Oracle database!" +e);
}
try{
get_team = dbc.createStatement();
rs_team = get_team.executeQuery("select TeamNum from team_account where
TeamID='"+team+"'");
rs_team.next();
int teamnum = rs_team.getInt (1);
Vector results = new Vector();
stmt = dbc.createStatement();
rs = stmt.executeQuery ("select TaskID, StartDate, FinishDate from
schedule where TeamNum = "+teamnum+"");
while (rs.next()){
String task = (rs.getString("TaskID")).trim();
String start_date = (rs.getString("StartDate")).trim();
String finish_date = (rs.getString("FinishDate")).trim();
String text = task+" "+start_date+" "+finish_date;
results.addElement(text);
}//end of while
queryResults = results;
if(queryResults == null)
System.out.println("ERRO");
else System.out.println("It's not null.");
stmt.close();
get_team.close();
rs_team.close();
dbc.close();
}
catch(Exception e){
System.out.println("SQLException: "+e);
}
}//end of dbs
public void sendVector(HttpServletResponse response, Vector queryResults){
ObjectOutputStream outputToApplet;
try{
outputToApplet = new ObjectOutputStream(response.getOutputStream());
System.out.println("Sending vector to th applet");
outputToApplet.writeObject(queryResults);
outputToApplet.flush();
outputToApplet.close();
System.out.println("Data transmission complete");
}catch(IOException e){
e.printStackTrace();
}
}//end of sendVector
}//end of gantt
On Sat, 4 Nov 2000, Abhay wrote:
> Hi HeaKyung,
> You can see/use Orielly's HttpMessage class. It's source is also
> available on Orielly's site. This class does the same thing. i.e.
> AppletServletCommunication. You can definitely get your problem solved.
>
> Bye
>
> Abhay
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
