谁能给我看一下jbuilder中sample中的例程?appletToservlet

[tonybin]

我只是改了一点，我想将查询参数传进出，不知为何总不成功？
Applet programming
package dbApplet;
public class DbApplet extends JApplet
{

void jButton1_actionPerformed(ActionEvent e)

{
DataSetData data = null; // Temporary storage for the data.
URL servletURL = null; // The URL to the servlet.
URLConnection servletConnection = null; // The connection to the servlet.
ObjectInputStream dbStream = null; // The stream from the servlet.

try
{
String qry="qry="+jTextField1.getText() ;
servletURL = new URL( "http://localhost:8080/servlet/dbServlet.DbServlet?" +"qry");//增加查询参数
servletConnection = servletURL.openConnection();

dbStream = new ObjectInputStream( servletURL.openStream() );
.
data = (DataSetData) dbStream.readObject();
}
......省略

****package dbServlet;
public class DbServlet extends HttpServlet
{
private Database database1 = new Database();
private QueryDataSet queryDataSet1 = new QueryDataSet();

// Database connection information. Modify to match your database setup.
private String url = "sun.jdbc.odbc.JdbcOdbcDriver";
private String userName = "";
private String password = "";
private String driver = "jdbc:odbc:studentDatabase";
private String query = "";


//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
ObjectOutputStream dbStream = null;
DataSetData data = null;
query=request.getParameter("qry");////读取参数???????????//?////
try
{
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(url, userName, password, false, driver));
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, query, null, true, Load.ALL));
queryDataSet1.open();

data = DataSetData.extractDataSet( queryDataSet1 );

// Get the response stream so we can write the object to it.
dbStream = new ObjectOutputStream( response.getOutputStream() );
// Write the object...
dbStream.writeObject(query);
}
catch( DataSetException e )
{
System.err.println( "DataSetException caught in DbServlet.doGet()" );
System.err.println( e.getMessage() );
e.printStackTrace( System.err );
}
.........省略
}
****************************
" org.apache.catalina.startup.Bootstrap start -config "E:\junk\AppletToServlet\conf\server8080.xml" -nonaming
HttpConnector Opening server socket on all host IP addresses
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
WebappLoader[]: Deploying class repositories to work directory E:\junk\AppletToServlet\work
WebappLoader[]: Deploy JAR /WEB-INF/lib/beandt.jar to E:\junk\AppletToServlet\defaultroot\WEB-INF\lib\beandt.jar
WebappLoader[]: Deploy JAR /WEB-INF/lib/dbswing.jar to E:\junk\AppletToServlet\defaultroot\WEB-INF\lib\dbswing.jar
WebappLoader[]: Deploy JAR /WEB-INF/lib/dx.jar to E:\junk\AppletToServlet\defaultroot\WEB-INF\lib\dx.jar
StandardManager[]: Seeding random number generator class java.security.SecureRandom
StandardManager[]: Seeding of random number generator has been completed
StandardWrapper[:default]: Loading container servlet default
StandardWrapper[:invoker]: Loading container servlet invoker
HttpConnector[8080] Starting background thread
DataSetException caught in DbServlet.doGet()
Missing or Bad query or database property settings. Could not execute query
See com.borland.dx.dataset.DataSetException error code: BASE+1
com.borland.dx.dataset.DataSetException: Missing or Bad query or database property settings. Could not execute query
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.badQueryProperties(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at dbServlet.DbServlet.doGet(DbServlet.java:78)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:446)
at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:180)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:484)

[jimjxr]

取参数以后System.out.println( query );看看参数是不是穿过来了。