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
JSP2.0技术手册 里面讲的很详细
我按照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"));
<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
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>
路过帮我看看,指出错误
form.setRoleName(res.getString("rolename"));list.add(form);