一个swing做出来的界面点按钮后传递的参数servlet没有接受到,但通过浏览器servlet可以收到参数.代码如下:swing界面部份public void actionPerformed(ActionEvent e) {
try{
URL url = new URL("http://localhost:8080/servlet1?sql=select gsjc,gsbh from ld_gs");
URLConnection urlcon = url.openConnection();
urlcon.connect();
System.out.println("建立连接");
ObjectInputStream ois=new ObjectInputStream(urlcon.getInputStream());//和servlet建立连接
//CachedRowSetImpl crs = (CachedRowSetImpl)ois.readObject();
ResultSet rst = (ResultSet)ois.readObject();
while(rst.next())
{
String sqlname = rst.getString("gsjc");
System.out.println(sqlname);
} } catch(Exception e1){
}servlet部份:import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class Servlet1 extends HttpServlet {
//private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
Connection conn=null;
public void init() throws ServletException {
} public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("dbc:oracle:thin:@192.168.0.100:1521:dc","hydbuser","hydbuser");
Statement sta = conn.createStatement();
String sql = request.getParameter("sql");
System.out.println("sql:"+sql);
/*ResultSet rst = sta.executeQuery(sql);
//CachedRowSetImpl crs = new CachedRowSetImpl();
//crs.populate(rst);
while(rst.next())
{
String sqlname = rst.getString("gsjc");
System.out.println(sqlname);
}
rst.close();
sta.close();
conn.close();*/ /** response.setContentType("application/octet-stream");
ObjectOutputStream oos = new ObjectOutputStream(response.getOutputStream());
oos.writeObject(rst);//传递结果集
oos.close();
rst.close();
sta.close();
conn.close();*/
}
catch(Exception e){} } //Clean up resources
public void destroy() {
}
}
try{
URL url = new URL("http://localhost:8080/servlet1?sql=select gsjc,gsbh from ld_gs");
URLConnection urlcon = url.openConnection();
urlcon.connect();
System.out.println("建立连接");
ObjectInputStream ois=new ObjectInputStream(urlcon.getInputStream());//和servlet建立连接
//CachedRowSetImpl crs = (CachedRowSetImpl)ois.readObject();
ResultSet rst = (ResultSet)ois.readObject();
while(rst.next())
{
String sqlname = rst.getString("gsjc");
System.out.println(sqlname);
} } catch(Exception e1){
}servlet部份:import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class Servlet1 extends HttpServlet {
//private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
Connection conn=null;
public void init() throws ServletException {
} public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("dbc:oracle:thin:@192.168.0.100:1521:dc","hydbuser","hydbuser");
Statement sta = conn.createStatement();
String sql = request.getParameter("sql");
System.out.println("sql:"+sql);
/*ResultSet rst = sta.executeQuery(sql);
//CachedRowSetImpl crs = new CachedRowSetImpl();
//crs.populate(rst);
while(rst.next())
{
String sqlname = rst.getString("gsjc");
System.out.println(sqlname);
}
rst.close();
sta.close();
conn.close();*/ /** response.setContentType("application/octet-stream");
ObjectOutputStream oos = new ObjectOutputStream(response.getOutputStream());
oos.writeObject(rst);//传递结果集
oos.close();
rst.close();
sta.close();
conn.close();*/
}
catch(Exception e){} } //Clean up resources
public void destroy() {
}
}
解决方案 »
- 关于sleep的问题
- list转换成byte数组
- 菜鸟求帮助。。。下列程序的打印结果是。。。。。
- 反编译的代码有的JAVA代码中有GOTO、break lable1类似的语句该如何解决?
- java并行发送http请求的方法
- java 程序编译没出错 运行时出错 功能无法实现
- 文本编辑器添加新建与保存上卡住了.求救有代码
- 一个小问题,对于HashMap的困惑。
- 我使用dtree.js 生成树形目录,可是当单击节点时,如何获得节点的信息?
- [[急问]]jtextpane 如何进行图文混编?(在线等!!!!!!!!!!!!!!!)
- 选择题4道求教
- 小弟很着急~ 大哥看这里~ (关于:applet 在浏览器中读取文件时的错误)
try{
String data = URLEncoder.encode("sql", "UTF-8") + "=" + URLEncoder.encode("select gsjc,gsbh from ld_gs", "UTF-8");
URL url = new URL("http://192.168.0.117:8080/servlet1");
URLConnection urlcon = url.openConnection();
urlcon.setDoOutput(true);
urlcon.connect();
System.out.println("建立连接");
OutputStreamWriter wr = new OutputStreamWriter(urlcon.getOutputStream());
wr.write(data);
wr.flush(); ObjectInputStream ois=new ObjectInputStream(urlcon.getInputStream());//和servlet建立连接
//CachedRowSetImpl crs = (CachedRowSetImpl)ois.readObject();
ResultSet rst = (ResultSet)ois.readObject();
while(rst.next())
{
String sqlname = rst.getString("gsjc");
System.out.println(sqlname);
} } catch(Exception e1){
} }
servlet代码如下: Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("dbc:oracle:thin:@192.168.0.100:1521:dc","hydbuser","hydbuser");
Statement sta = conn.createStatement();
String sql = request.getParameter("sql");
System.out.println("sql:"+sql);
ResultSet rst = sta.executeQuery(sql);
//CachedRowSetImpl crs = new CachedRowSetImpl();
//crs.populate(rst);
// while(rst.next())
// {
// String sqlname = rst.getString("gsjc");
// System.out.println(sqlname);
// }
// rst.close();
// sta.close();
// conn.close(); response.setContentType("application/octet-stream");
ObjectOutputStream oos = new ObjectOutputStream(response.getOutputStream());
oos.writeObject(rst);//传递结果集
oos.close();
rst.close();
sta.close();
conn.close();
}