请教取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的返回值。
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
- <%
- String sql = "select * from dual";
- java.sql.ResultSet rs = new Connect1().executeQuery(sql);
- while(rs.next()){
- System.out.println(rs.getString(1));
- }
- %>
作者: cectsky 发布时间: 2010-08-12
回复 cectsky
应该用response的out 你写的这个写入到控制台了
应该用response的out 你写的这个写入到控制台了
作者: tong0245 发布时间: 2010-08-12
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28