现在已经实现了从数据库取出来显示在前台界面,效果如图:
第1、2列是从数据库中取出的,第三列为输入列,要求批量提交123列的值。怎么把这个list传回后台action?????
代码如下:
公司名称 |
描述 |
子类 |
<tbody>
<%
request.setCharacterEncoding("utf-8");
SessionFactory sessionFactory = HibernateSessionFactory.getSessionFactory();
if(sessionFactory instanceof SessionFactoryImplementor){
ConnectionProvider cp =((SessionFactoryImplementor)sessionFactory).getConnectionProvider();
Connection conn = cp.getConnection();
conn.setAutoCommit(true);
Statement stmt = conn.createStatement();
String sql = "Select AKKONGNAME,organisationcode from ACP.IATABILLINGFEEDBACK where organisationcode" +
" not in('QAF','MKA','_JETA','GAF','DLH','JCS','JEC','THY','KFR','KFD','LAO'," +
"'BKM','_JETE','CRX','JNA','_CROW','PFA','XFA','SWR','HBI','BGB','BKS','VHP','XAX'," +
"'VHC','BMA','PRJ') order by organisationcode";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td width="60"><%=rs.getString("AKKONGNAME") %></td>
<td><%=rs.getString("organisationcode") %></td>
<td><input type="text" name="code" id="textfield3"
value="<s:property value="code"/>"/></td>
</tr>
<%
}
rs.close();
}
%>
<tr>
<td colspan="4"><div align="left">
<input
type="submit" id="submitButton" value="确认修改">
<input type="button" id="clearButton" value="清空">
</div></td>
</tr>
</tbody>
</table>
</s:form>