+ -
当前位置:首页 → 问答吧 → 请教取return返回值的问题

请教取return返回值的问题

时间:2010-08-11

来源:互联网

本帖最后由 qcxubin 于 2010-08-11 20:43 编辑

package ywfx;

/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/

import java.sql.*;
public class Connect1 {
  String sDBDriver = "com.informix.jdbc.IfxDriver";
  String url = "jdbc:informix-sqli://192.168.1.100:8888/ywfx:INFORMIXSERVER=ywfx_tcp;user=ywfx;password=ywfx";
  Connection conn = null;
  ResultSet rs = null;
  public Connect1() {
    try {
        Class.forName(sDBDriver);
        }
        catch (java.lang.ClassNotFoundException e) {
        System.err.println("Connect1():" + e.getMessage());
        }
  }

  public ResultSet executeQuery(String sql) {
    rs = null;
    try {
        conn = DriverManager.getConnection(url);
        Statement stmt = conn.createStatement();
        rs = stmt.executeQuery(sql);
        }
        catch (SQLException ex) {
        System.err.println("co.executeQuery:" + ex.getMessage());
        }
        return rs;
  }

  public ResultSet branch() {
     String sql="select branch_no,branch_name from branch";
     try{
          conn = DriverManager.getConnection(url);
          PreparedStatement ps = conn.prepareStatement(sql);
          ResultSet res = ps.executeQuery();
          return res;
        }
        catch(Exception e){
          return null;
        }
    }
}

请问如何在jsp网页中获取return res的返回值。

作者: qcxubin   发布时间: 2010-08-11

  1. <%
  2. String sql = "select * from dual";
  3. java.sql.ResultSet rs = new Connect1().executeQuery(sql);
  4. while(rs.next()){
  5.        System.out.println(rs.getString(1));
  6. }
  7. %>
复制代码

作者: cectsky   发布时间: 2010-08-12

回复 cectsky


    应该用response的out 你写的这个写入到控制台了

作者: tong0245   发布时间: 2010-08-12