public class LendBean
{
......
/**
* 获得lend表中的所有lender信息
*/
public String[]getAllLender()
{
String[]s=null;
int row=0;
int i=0;
Database DB=new Database();
sql="select lender from lend";
try
{
DB.OpenConn();
rs=DB.executeQuery(sql);
if(rs.last())
{
row=rs.getRow();
}
if(row==0)
{
s=null;
}
else
{
s=new String[row];
rs.first();
rs.previous();
while(rs.next())
{
s[i]=rs.getString(1);
i++;
}
}
}
catch(Exception e)
{
}
finally
{
DB.closeStmt();
DB.closeConn();
}
return s;
}
}
public class LendInfo extends JFrame implements ActionListener
{
JComboBox lender;
String [] slender;
......
/**
* Create the frame
*/
public void Init()
{
......
//通过slender数组获得getAllLender函数中所传递来的所有lender值
LendBean getLender=new LendBean();
slender=getLender.getAllLender();
//用所有的lender信息初始化JComboBox中的值
lender=new JComboBox(slender); ......
}
........
}
程序出错,经调试后发现slender=null,即,没有得到传送过来的值,有一点我可以保证sql="select lender from lend";
这句sql语句是能够得到值的.
{
......
/**
* 获得lend表中的所有lender信息
*/
public String[]getAllLender()
{
String[]s=null;
int row=0;
int i=0;
Database DB=new Database();
sql="select lender from lend";
try
{
DB.OpenConn();
rs=DB.executeQuery(sql);
if(rs.last())
{
row=rs.getRow();
}
if(row==0)
{
s=null;
}
else
{
s=new String[row];
rs.first();
rs.previous();
while(rs.next())
{
s[i]=rs.getString(1);
i++;
}
}
}
catch(Exception e)
{
}
finally
{
DB.closeStmt();
DB.closeConn();
}
return s;
}
}
public class LendInfo extends JFrame implements ActionListener
{
JComboBox lender;
String [] slender;
......
/**
* Create the frame
*/
public void Init()
{
......
//通过slender数组获得getAllLender函数中所传递来的所有lender值
LendBean getLender=new LendBean();
slender=getLender.getAllLender();
//用所有的lender信息初始化JComboBox中的值
lender=new JComboBox(slender); ......
}
........
}
程序出错,经调试后发现slender=null,即,没有得到传送过来的值,有一点我可以保证sql="select lender from lend";
这句sql语句是能够得到值的.
if(rs.last())
{ 这里是不是 next() 啊。