java
大家帮我看一下这段代码,不知道为什么会有这样的错误
import java.sql.*;
import java.util.Vector;
import com.weather.util.*;
public class TbResultAllDao {
private Vector data = new Vector();
Connection con = null;
String sql = "select *from Tb_expResult";///////////////就在这里报错:Syntax error on "",,expected
con = DB.getConnection();//DB是在上面的那个包里连接数据库的接口
public Vector getAllResult(){
try{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);//获得一个结果集
while(rs.next()){
Vector row = new Vector();
//取个字段的值
row.add(rs.getInt("tb_expResult_id"));
row.add(rs.getInt("tb_experiment_id"));
row.add(rs.getString(3));
row.add(rs.getString("tb_expResult_title"));
row.add(rs.getString("tb_expResult_content"));
row.add(rs.getDate("tb_expResult_time"));
data.add(row);
}
}catch(SQLException e){
e.printStackTrace();
}finally{
if(con != null){
con.close();
}
}
return data;
}
}