从数据库读取数据

[laoyao319]

想了好多天，还是想不出来
知道的给思路 ，最好是代码学习学习

[傻根她弟]

jsp文件
<html:select property="roleCode" name="userInfoForm">
<html:options collection="list" property="roleCode" labelProperty="roleName"/> </html:select>

action里相关代码
RoleInfo rInfo = new RoleInfo();
list = rInfo.getRoleList();
request.setAttribute("list",list);

form里设置roleCode,roleName

[kingdoom]

JSP2.0技术手册 里面讲的很详细

[傻根她弟]

list.add(res.getString("rolename"));这个地方有问题

应该有form（get set）
form.setRoleName(res.getString("rolename"));

list.add（form）；

[laoyao319]

我按照2楼的做了一下 还是没成功，郁闷了
RoleInfo类里
public class RoleInfo {
private Connection conn = null;

private ResultSet res = null;

private java.sql.PreparedStatement prepar = null;
public List getRoleList(){
ArrayList list = new ArrayList();
try {
String sql =
"select rolename from tt";
prepar = conn.prepareStatement(sql);
res = prepar.executeQuery();
while (res.next()) {
list.add(res.getString("rolename"));



}
} catch (Exception e) {
e.printStackTrace();
}


return list;


}
public RoleInfo() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;databasename=kk",
"sa", "");
System.out.println("连接成功");
} catch (SQLException ex) {
System.out.println(ex.getMessage() + "路径错误");
} catch (ClassNotFoundException ex) {
System.out.println(ex.getMessage() + "驱动错误");
}


// TODO 自动生成构造函数存根
}

}
ACTION里
SelectForm selectForm = (SelectForm) form;
RoleInfo rInfo = new RoleInfo();
List list = rInfo.getRoleList();
request.setAttribute("list",list);
return mapping.findForward("sel");

JSP里
<html:form action="ok.do" >

<html:select property="rolename">

<html:options collection="list" property="rolename" labelProperty="rolename"/>
</html:select>

</html:form>
路过帮我看看，指出错误