Users.xml
<sqlMap>
<typeAlias alias="user" type="com.feng.pojo.Users" />
<update id="updateUser" parameterClass="user">
<![CDATA[
update users set
<dynamic prepend=" ">
<isNotNull prepend="," property="userpassword" removeFirstPrepend="true">
userpassword=#userpassword#
</isNotNull>
<isNotNull prepend="," property="userprivileges">
userprivileges=#userprivileges#
</isNotNull>
</dynamic>
where username=#username#
]]>
</update>
</sqlMap>userUpdate.jsp
<%@ page language="java" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>更新</title>
</head> <body> <s:property value="tips"/>
<s:form action="user/updateUser.action">
<s:textfield name="user.username" label="姓名"/>
<s:textfield name="user.userpassword" label="新密码"/>
<s:textfield name="user.userprivileges" label="权限"/>
<s:submit value="修改" />
</s:form>
</body>
</html>
UserAction.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<package name="user" extends="struts-default" namespace="/user">
<action name="updateUser" class="com.feng.action.UserAction" method="userUpdate">
<result name="success">/userUpdate.jsp</result>
<result name="loginfail">/userUpdate.jsp</result>
</action>
</package>
</struts>
UserAction.java
package com.feng.action;import com.feng.pojo.Users;
import com.feng.services.IsUserServices;public class UserAction { private IsUserServices userServices;
private Users user;
private String username;
private String userpassword;
private String tips;
public void setUserServices(IsUserServices userServices) {
this.userServices = userServices;
}
//省略user等SET和GET方法
public String userUpdate()
{
String result="loginfail";
try{
userServices.updateUser(user);
this.setTips("修改成功!");
result="success";
}catch (Exception e) {
e.getStackTrace();
this.setTips("修改失败!");
}
return result;
}
<sqlMap>
<typeAlias alias="user" type="com.feng.pojo.Users" />
<update id="updateUser" parameterClass="user">
<![CDATA[
update users set
<dynamic prepend=" ">
<isNotNull prepend="," property="userpassword" removeFirstPrepend="true">
userpassword=#userpassword#
</isNotNull>
<isNotNull prepend="," property="userprivileges">
userprivileges=#userprivileges#
</isNotNull>
</dynamic>
where username=#username#
]]>
</update>
</sqlMap>userUpdate.jsp
<%@ page language="java" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>更新</title>
</head> <body> <s:property value="tips"/>
<s:form action="user/updateUser.action">
<s:textfield name="user.username" label="姓名"/>
<s:textfield name="user.userpassword" label="新密码"/>
<s:textfield name="user.userprivileges" label="权限"/>
<s:submit value="修改" />
</s:form>
</body>
</html>
UserAction.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<package name="user" extends="struts-default" namespace="/user">
<action name="updateUser" class="com.feng.action.UserAction" method="userUpdate">
<result name="success">/userUpdate.jsp</result>
<result name="loginfail">/userUpdate.jsp</result>
</action>
</package>
</struts>
UserAction.java
package com.feng.action;import com.feng.pojo.Users;
import com.feng.services.IsUserServices;public class UserAction { private IsUserServices userServices;
private Users user;
private String username;
private String userpassword;
private String tips;
public void setUserServices(IsUserServices userServices) {
this.userServices = userServices;
}
//省略user等SET和GET方法
public String userUpdate()
{
String result="loginfail";
try{
userServices.updateUser(user);
this.setTips("修改成功!");
result="success";
}catch (Exception e) {
e.getStackTrace();
this.setTips("修改失败!");
}
return result;
}
解决方案 »
- jsp:include的使用
- 高手来下嘛 Jetty 怎么添加servlet映射
- spring,hibernate,struts集成问题有关session的,各位大哥帮帮忙啊
- 如何把内网服务器内容通过外网服务器上发布在网站上
- 数据乱码问提,请高手帮忙!!!!!!!!!!急啊!!!!!!!!!!!!!!!!!!!!!!!
- MYSQL连接问题:java.sql.SQLException: Communication failure during handshake. Is there a server running on 192.168.100.16:3306?
- 用Microsoft SQL Server 2000 Driver for JDBC连接数据库的问题。
- 编译问题!help
- 如何对日志进行处理。。。
- Spring security中authentication-provider的实现问题
- 各位前辈,我有一个HTML页面,想变成JSP页面,但出现在了乱码,而且不能保存~~~
- 模拟POST 返回值为乱码
SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]