劳驾，帮忙看看，为什么？

[teddy_huang]

源程序如下：

/*
SqlBean.java
*/

import java.sql.*;

public class SqlBean{

String sConnStr="jdbc:oracle:thin:@LH:1521:TEST";
String user="system";
String pwd="manager";

Connection conn=null;
ResultSet rs=null;

public SqlBean(){
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
}catch(Exception e){
System.out.println("Class driver not found!");
}
}

public Void executeInsert(String sql){
try{
conn=DriverManager.getConnection(sConnStr,user,pwd);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);

}catch(SQLException se){
System.out.println("Error:"+se.getMessage());
}
}

public ResultSet executeSelect(String sql){
try{
conn=DriverManager.getConnection(sConnStr,user,pwd);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
return(rs);
}catch(SQLException se){
System.out.println("Error:"+se.getMessage());
}
}

public Void executeDelete(String sql){
try{
conn=DriverManager.getConnection(sConnStr,user,pwd);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}catch(SQLException se){
System.out.println("Error:"+se.getMessage());
}
}

}


编译后的错误信息：

D:\workdir\java\SqlBean.java:24: missing return statement
public Void executeInsert(String sql){
^
D:\workdir\java\SqlBean.java:35: missing return statement
public ResultSet executeSelect(String sql){
^
D:\workdir\java\SqlBean.java:46: missing return statement
public Void executeDelete(String sql){
^
3 errors

[15年老程创业中]

Void 是 void。

[wwangl]

public ResultSet executeSelect(String sql){
try{
conn=DriverManager.getConnection(sConnStr,user,pwd);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
return rs;
}catch(SQLException se){
System.out.println("Error:"+se.getMessage());
}
}

[teddy_huang]

经修改后，还是出错：

D:\workdir\java\SqlBean.java:35: missing return statement
public ResultSet executeSelect(String sql){
^
1 error

[leo_zhangfh]

D:\workdir\java\SqlBean.java:35: missing return statement
public ResultSet executeSelect(String sql){
^
1 error


你先把executeSelect(String sql)赋给一个变量试试看。

[ldgs]

改这个方法：把return (rs);移到后面去。

......
public ResultSet executeSelect(String sql){
try{
conn=DriverManager.getConnection(sConnStr,user,pwd);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}catch(SQLException se){
System.out.println("Error:"+se.getMessage());
}
return (rs);
}
......

[teddy_huang]

这回对了，多谢大家