81,092
社区成员
发帖
与我相关
我的任务
分享struts2 s:iterator中做修改的问题
<table border = 1>
<s:iterator value="levels" var = "level" status="status">
<tr>
<td>
<s:property value="#level.net"/>
</td>
<td>
<s:property value="#level.level_id"/>
</td>
<td>
<s:textfield name="%{'levels['+#status.index+'].jf'}"></s:textfield>
</td>
<td>
<s:submit type="button" value="修改"></s:submit>
</td>
</tr>
</s:iterator>
</table>
想实现修改textfield的值点击修改后修改表中的数据。
LevelAction中调用LevelService的update方法
public void update(Level level) {
Connection conn = DB.createConn();
String sql = "update integral_level set jf = ? where level_id = ? and net = ? ";
PreparedStatement ps = DB.prepare(conn, sql);
try {
ps.setString(1, level.getJf());
ps.setString(2, level.getLevel_id());
ps.setString(3, level.getNet());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
DB.close(ps);
DB.close(conn);
};
请教怎么实现
<s:iterator value="levels" var = "level" status="status">
<tr>
<td>
<s:property value="#level.net"/>
</td>
<td>
<s:property value="#level.level_id"/>
</td>
<td>
<s:textfield name="%{'levels['+#status.index+'].jf'}"></s:textfield>
</td>
<td>
<s:submit type="button" value="修改"></s:submit>
</td>
</tr>
</s:iterator>
</table>
想实现修改textfield的值点击修改后修改表中的数据。
LevelAction中调用LevelService的update方法
public void update(Level level) {
Connection conn = DB.createConn();
String sql = "update integral_level set jf = ? where level_id = ? and net = ? ";
PreparedStatement ps = DB.prepare(conn, sql);
try {
ps.setString(1, level.getJf());
ps.setString(2, level.getLevel_id());
ps.setString(3, level.getNet());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
DB.close(ps);
DB.close(conn);
};
请教怎么实现
...全文
请发表友善的回复…
发表回复
sttyy 2013-05-21
- 打赏
- 举报
第一次发帖代码没弄规范啊，大虾们帮帮忙呀
struts实现数据库添删改查，以及分页
ArrayList list;
UserService service;
Users user;
Pager page=new Pager();
public Pager getPage() {
return page;
}
public void setPage(Pager page) {
this.page = page;
}
public Users getUser() {
return user;
}
public void setUser(Users user) {
this.user = user;
}
public ArrayList getList() {
return list;
}
public void setList(ArrayList list) {
this.list = list;
}
public String lists() {
service = new UserService();
// list=service.getAllUsers();
System.out.println("page.pageNow="+page.getPageNow());
list = service.getUsersByPage(page.getPageNow(), page.getPageSize());
return Action.SUCCESS;
}
public String input() {
service = new UserService();
if (user != null) {
user = service.getUsersByname(user);
System.out.println(user.toString());
}
return Action.SUCCESS;
}
public String save() {
service = new UserService();
if (user != null && user.getCdate() != null) {
service.updateUsers(user);
System.out.println(user.toString());
} else {
service.addUsers(user);
}
return Action.SUCCESS;
}
public String deleteusers() {
service = new UserService();
service.delUsers(user);
return Action.SUCCESS;
}
用户名密码权限日期操作
修改
删除
添加用户
首页
