this is section of sending data to the applet :
Statement stmt = conConnection.createStatement();
query =
"select cmhfarm, cmhflock, dmhdatein, cmhstrain, cmhgrade,
"+
"nmhjml_in, nmslastpop, (dmhdatein+nmhumurakh-1) as
tglakhirmg, nmhumurakh, nmhtpanen, nmhtberat, nmhumur, "+
"nmsfcr1, nmsfcr2, nmsfcr3, nmsfcr4, nmsfcr5, nmsfcr6,
nmsfcr7, nmsfcr8, nmsfcr9, nmsfcr10, "+
"nmsdpl1, nmsdpl2, nmsdpl3, nmsdpl4, nmsdpl5, nmsdpl6,
nmsdpl7, nmsdpl8, nmsdpl9, nmsdpl10, "+
"nmswhrate1, nmswhrate2, nmswhrate3, nmswhrate4,
nmswhrate5, nmswhrate6, nmswhrate7, nmswhrate8, nmswhrate9,
nmswhrate10, "+
"nmhfcr, nmhdepl, nmhbw, nmhip, "+
"cmhppl, nmhpakan, nmhumrekor, cmhnipkey "+
"from mrtrxhd, mrstat "+
"where "+
"cmhnipkey like '"+tlokkey+"' and "+
"between((dmhdatein+nmhumur),{"+tPeriode1+"},{"+tPeriode2+"}) and
lmhposted=.T. and "+
"cmh_pk=cms_mhfk order by cmhppl";
log(query);
ResultSet rs = stmt.executeQuery(query);
int count=1;
byte data=1;
while (rs.next()) {
String tfarm = rs.getString("cmhfarm");
if (tfarm.trim().equals(""))
out.writeUTF(rs.getString("cmhnipkey"));
else
out.writeUTF(tfarm);
out.writeUTF(rs.getString("cmhflock"));
out.writeUTF(rs.getString("dmhdatein"));
out.writeUTF(rs.getString("cmhstrain"));
out.writeUTF(rs.getString("cmhgrade"));
out.writeUTF(rs.getString("nmhjml_in"));
out.writeUTF(rs.getString("nmslastpop"));
out.writeUTF(rs.getString("tglakhirmg"));
out.writeUTF(rs.getString("nmhumurakh"));
out.writeUTF(rs.getString("nmhtpanen"));
out.writeUTF(rs.getString("nmhtberat"));
out.writeUTF(rs.getString("nmhumur"));
out.writeUTF(rs.getString("nmsfcr1"));
out.writeUTF(rs.getString("nmsfcr2"));
out.writeUTF(rs.getString("nmsfcr3"));
out.writeUTF(rs.getString("nmsfcr4"));
out.writeUTF(rs.getString("nmsfcr5"));
out.writeUTF(rs.getString("nmsfcr6"));
out.writeUTF(rs.getString("nmsfcr7"));
out.writeUTF(rs.getString("nmsfcr8"));
out.writeUTF(rs.getString("nmsfcr9"));
out.writeUTF(rs.getString("nmsfcr10"));
out.writeUTF(rs.getString("nmsdpl1"));
out.writeUTF(rs.getString("nmsdpl2"));
out.writeUTF(rs.getString("nmsdpl3"));
out.writeUTF(rs.getString("nmsdpl4"));
out.writeUTF(rs.getString("nmsdpl5"));
out.writeUTF(rs.getString("nmsdpl6"));
out.writeUTF(rs.getString("nmsdpl7"));
out.writeUTF(rs.getString("nmsdpl8"));
out.writeUTF(rs.getString("nmsdpl9"));
out.writeUTF(rs.getString("nmsdpl10"));
out.writeUTF(rs.getString("nmswhrate1"));
out.writeUTF(rs.getString("nmswhrate2"));
out.writeUTF(rs.getString("nmswhrate3"));
out.writeUTF(rs.getString("nmswhrate4"));
out.writeUTF(rs.getString("nmswhrate5"));
out.writeUTF(rs.getString("nmswhrate6"));
out.writeUTF(rs.getString("nmswhrate7"));
out.writeUTF(rs.getString("nmswhrate8"));
out.writeUTF(rs.getString("nmswhrate9"));
out.writeUTF(rs.getString("nmswhrate10"));
out.writeUTF(rs.getString("nmhfcr"));
out.writeUTF(rs.getString("nmhdepl"));
out.writeUTF(rs.getString("nmhbw"));
out.writeUTF(rs.getString("nmhip"));
out.writeUTF(rs.getString("cmhppl"));
out.writeUTF(rs.getString("nmhpakan"));
out.writeUTF(rs.getString("nmhumrekor"));
out.writeUTF(rs.getString("cmhnipkey"));*/
}
rs.close();
stmt.close();
}
catch (SQLException ex) {
log(ex.getMessage());
}
out.flush();
byte buf[] = byteOut.toByteArray();
resp.setContentLength(buf.length);
ServletOutputStream servletOut = resp.getOutputStream();
servletOut.write(buf);
servletOut.close();
and this is the section of receiving data from servlet :
System.out.println("Reading response...");
DataInputStream in = new DataInputStream(con.getInputStream());
System.out.println("Reading data ...");
// viewTableAfter(in);
while (in.available()!=0) {
farm = in.readUTF();
// etc ...
}
in.close();
System.out.println("Closing data ...");
___________________________________________________________________________
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
