无法负值到jtable,帮看看问题出在哪里 谢谢

将数据库里的值负给jtable,总是抛出sql语句错误,但是我在Access里查询又没有问题,而且我用System.out.print(rs.getRow());能打出记录集行数,请高手指点

Connection con=null;
Statement stmt=null;
ResultSet rs=null;
String sql="";
Vector tvector = new Vector(1, 1);
for (int n = model.getRowCount() - 1; n >= 0; n--)
model.removeRow(n);
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String urlName = "jdbc:odbc:studentinfo";
con = DriverManager.getConnection(urlName);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
if (jRadioButton1.isSelected()){
if(jTextName.getText().trim().equals(null))
sql="select * from student";
else
sql="select * from student where sname like '%"+jTextName.getText().trim()+"%'";
}
else
if (jRadioButton2.isSelected()){
if(jTextID.getText().trim().equals(null))
sql="select * from student";
else
sql="select * from student where sno like '%"+jTextID.getText().trim()+"%'";
}
rs=stmt.executeQuery(sql);
rs.last();
System.out.print(rs.getRow());
if (rs.getRow()==0)
JOptionPane.showMessageDialog(null,"没有符合条件的记录存在!");
else
{
rs.beforeFirst();

while (rs.next())
{

tvector=new Vector(1,1);
tvector.add(rs.getString("sno"));
tvector.add(rs.getString("sname"));
tvector.add(rs.getInt("sage"));
tvector.add(rs.getInt("sdeptno"));
model.addRow(tvector);
}
}
}
[1589 byte] By [realwow] at [2008-1-9]