页面数据输不出来
用到了BEAN,但输不出结果,页面什么也不显示。也没有错误提示,BEAN程序如下:如果给变量jg赋初值,则输出这个值,循环中的赋值语句不起作用。
package a;
import java.sql.*;
public class SelectStu
{
public String sort()
{
String jg="";
String url = "jdbc:odbc:zhuce";
String user="dba";
String password="sql";
Connection con;
Statement stmt;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
stmt=con.createStatement();
rs=stmt.executeQuery("select * from users");
while(rs.next())
{
String s1=rs.getString("id");
String s2=rs.getString("logID");
String s3=rs.getString("logPw");
jg="结果:" + s1 + s2 + s3;
}
stmt.close();
con.close();
}catch(Exception ex)
{
System.err.print("Exception:");
System.err.println(ex.getMessage());
}finally{
return jg;}
}
}