用子宫托能恢复吗:怎样把数据从数据库里取出来,在JSP页面上用下拉框显示

来源:百度文库 编辑:神马品牌网 时间:2024/05/09 12:20:28
用得JBuiler9,在Action里用断点调试,发现到List跳不过去,高手帮我看看
List有什么错,实在搞不定~~`
public static Vector list(Connection conn)
throws Exception
{
String sql= "SELECT " +
" A.cord_no AS cord_no, " + //投诉记录表.卡号
" A.complain_date AS complain_date, " + //投诉记录表.投诉日期
" A.complain_subject AS complain_subject, " + //投诉记录表.投诉摘要
" A.complain_content AS complain_content, " + //投诉记录表.投诉内容
" A.transact_content AS transact_content, " + //投诉记录表.处理内容
" A.state AS state," + //客户基本信息投诉记录表.处理状态
" B.types_id AS types_id," + //投诉记录表.投诉类型
" C.property_id AS property_id, " + //投诉记录表.投诉性质
" D.modes_id AS modes_id," + //投诉记录表.处理方式
" A.add_datetime AS add_datetime, " + //投诉记录表.创建日期
" A.add_user AS add_user, " + //投诉记录表.创建者id
" A.update_datetime AS update_datetime," + //投诉记录表.更新日期
" A.update_user AS update_user, " + //投诉记录表.更新者id
" A.delete_flag AS delete_flag " + //投诉记录表.删除标记
"FROM cus_complain_records A " + //投诉记录表
"LEFT JOIN const_complain_types B " + //投诉类型
"ON A.types_id=B.types_id " + //投诉类型id==投诉类型id
"LEFT JOIN const_complain_property C "+ //投诉性质
"ON A.property_id=C.property_id " + //投诉性质id==投诉性质dd
"LEFT JOIN const_service_modes D " + //处理方式
"ON A.modes_id=D.modes_id" + //处理方式id==处理方式id
"WHERE A.complain_record_id " + //投诉记录表
"ORDER BY A.complain_date "; //投诉记录表.按投诉日期降序排列

Vector complains = new Vector();

Statement stmt = conn.createStatement();
ResultSet rst = stmt.executeQuery(sql);

// 显示结果
while(rst.next()) {
Complain complain = new Complain();

complain.setComplain_subject(rst.getString(1));
complain.setComplain_date(rst.getString(2));
complain.setType_id(rst.getInt(3));
complain.setProperty_id(rst.getInt(4));
complain.setState(rst.getString(5));

complains.add(complain);
}

rst.close();
stmt.close();

return complains;

}
我主要是让问问 我这个LIST有什么错 我快找死了~~`

?