大神帮忙看一下
以下的代码能正常运行,就是在控制台输出不了任何内容, 希望大神们能帮忙看以下哪里有错
public class ParameterMetaTest {
public static void main(String[] args) throws SQLException {
String sql = "select * from stu where name=? and money>?";
Object[] obj = {"小白",9000f};
read1(sql,obj);
}
public static void read1(String sql,Object[] obj) throws SQLException {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
//创建连接
conn = JdbcParameter.getConnection();
//创建语句
ps = conn.prepareStatement(sql);
ParameterMetaData pmd = ps.getParameterMetaData();
int count = pmd.getParameterCount();
for(int i=1; i<=count; i++) {
ps.setObject(i, obj[i-1]);
}
//执行语句
rs = ps.executeQuery();
//处理结果集
System.out.println(rs.next()); //rs.next()返回的是false,控制台无法输出while循环的内容[/color]
while(rs.next()) {
System.out.println(rs.getInt("id")+"\t"+rs.getString("name")+"\t"
+rs.getDate("birth")+"\t"+rs.getFloat("money"));
}
} finally {
JdbcParameter.free(rs, ps, conn);
}
}
}