偶的开发环境是JDK1.6_21+myeclipse7.1+Struts2+Tomcat7,用了Struts2的doubleselect做公司编号与公司名称的联动,现在的问题是第一下拉框有数据,第二下拉框无数据,代码如下:
CompanyDao.java的代码如下:
//所有公司编号的doubleSelect
public Collection getCompanyCode() {
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
sql="select companycode,companyname from tb_company order by companycode";
Map Company_Code=new HashMap();
ArrayList codeList=new ArrayList();
try {
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()) {
Company company=new Company();
company.setCompanycode(rs.getString("companycode"));
Company_Code.put(company.getCompanycode(), company);
}
}catch(SQLException ex) {
ex.printStackTrace();
}finally {
freeCon();
}
codeList.addAll(Company_Code.values());
return codeList;
}
//所有公司名称的doubleselect
public Collection getCompanyName() {
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
sql="select companycode,companyname from tb_company order by companycode";
Map Company_Name=new HashMap();
ArrayList nameList=new ArrayList();
try {
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()) {
Company company=new Company();
company.setCompanyname(rs.getString("companyname"));
Company_Name.put(company.getCompanyname(), company);
}
}catch(SQLException ex) {
ex.printStackTrace();
}finally {
freeCon();
}
nameList.addAll(Company_Name.values());
return nameList;
}
UserAction.java的代码如下:
//跳转到员工添加页面
public String add() throws Exception {
//HttpServletRequest request=ServletActionContext.getRequest();
CompanyDao companydao=new CompanyDao();
Collection Company_Code=companydao.getCompanyCode();
Collection Company_Name=companydao.getCompanyName();
setCompanycode(Company_Code);
setCompanyname(Company_Name);
return "add";
}
user_add.jsp的代码如下:
<p><label>公司编号:</label>
<s:doubleselect name="companycode" list="companycode" listKey="companycode" listValue="companycode"
doubleName="companyname" doubleList="companyname" doubleListKey="companyname" doubleListValue="companyname" />
</p>
也不知道问题出现在那里,代码看起来应该没有啥子问题,还望各位大仙看看。谢谢!
CompanyDao.java的代码如下:
//所有公司编号的doubleSelect
public Collection getCompanyCode() {
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
sql="select companycode,companyname from tb_company order by companycode";
Map Company_Code=new HashMap();
ArrayList codeList=new ArrayList();
try {
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()) {
Company company=new Company();
company.setCompanycode(rs.getString("companycode"));
Company_Code.put(company.getCompanycode(), company);
}
}catch(SQLException ex) {
ex.printStackTrace();
}finally {
freeCon();
}
codeList.addAll(Company_Code.values());
return codeList;
}
//所有公司名称的doubleselect
public Collection getCompanyName() {
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
sql="select companycode,companyname from tb_company order by companycode";
Map Company_Name=new HashMap();
ArrayList nameList=new ArrayList();
try {
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()) {
Company company=new Company();
company.setCompanyname(rs.getString("companyname"));
Company_Name.put(company.getCompanyname(), company);
}
}catch(SQLException ex) {
ex.printStackTrace();
}finally {
freeCon();
}
nameList.addAll(Company_Name.values());
return nameList;
}
UserAction.java的代码如下:
//跳转到员工添加页面
public String add() throws Exception {
//HttpServletRequest request=ServletActionContext.getRequest();
CompanyDao companydao=new CompanyDao();
Collection Company_Code=companydao.getCompanyCode();
Collection Company_Name=companydao.getCompanyName();
setCompanycode(Company_Code);
setCompanyname(Company_Name);
return "add";
}
user_add.jsp的代码如下:
<p><label>公司编号:</label>
<s:doubleselect name="companycode" list="companycode" listKey="companycode" listValue="companycode"
doubleName="companyname" doubleList="companyname" doubleListKey="companyname" doubleListValue="companyname" />
</p>
也不知道问题出现在那里,代码看起来应该没有啥子问题,还望各位大仙看看。谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货