ssh集成后，hibernate做表单修改

0 0

ssh集成后，hibernate做表单修改5

要修改的jsp表单内容

<%@ include file="../common/IncludeTop.jsp"%>

<div id="Catalog">
	<html:form action="account.do?method=editAccount" method="post">

		<h3>
			User Information
		</h3>

		<table>
			<tr>
				<td>
					User ID:
				</td>
				<td>
					${actionBean.username}
				</td>
			</tr>
			<tr>
				<td>
					New password:
				</td>
				<td>
					<html:text property="password"></html:text>
				</td>
			</tr>
			<tr>
				<td>
					Repeat password:
				</td>
				<td>
					<html:text property="repeatedPassword"></html:text>
				</td>
			</tr>
		</table>
		<h3>Account Information</h3>

<table>
	<tr>
		<td>First name:</td>
		<td><html:text property="firstName" /></td>
	</tr>
	<tr>
		<td>Last name:</td>
		<td><html:text property="lastName" /></td>
	</tr>
	<tr>
		<td>Email:</td>
		<td><html:text property="email" size="40" /></td>
	</tr>
	<tr>
		<td>Phone:</td>
		<td><html:text property="phone" /></td>
	</tr>
	<tr>
		<td>Address 1:</td>
		<td><html:text property="address1" size="40" /></td>
	</tr>
	<tr>
		<td>Address 2:</td>
		<td><html:text property="address2" size="40" /></td>
	</tr>
	<tr>
		<td>City:</td>
		<td><html:text property="city" /></td>
	</tr>
	<tr>
		<td>State:</td>
		<td><html:text property="state" size="4" /></td>
	</tr>
	<tr>
		<td>Zip:</td>
		<td><html:text property="zip" size="10" /></td>
	</tr>
	<tr>
		<td>Country:</td>
		<td><html:text property="country" size="15" /></td>
	</tr>
</table>

<h3>Profile Information</h3>

<table>
	<tr>
		<td>Language Preference:</td>
		<td>
		 	<html:select property="languagePreference">
				<logic:iterate id="language" name="LANGUAGE_LIST">
					<html:option value="language">
						<bean:write name="language"/>
					</html:option>
				</logic:iterate>
			</html:select>
		</td>
	</tr>
	<tr>
		<td>Favourite Category:</td>
		<td>
		 	<html:select property="favouriteCategoryId">
				<logic:iterate id="category" name="CATEGORY_LIST">
					<html:option value="category">
						<bean:write name="category"/>
					</html:option>
				</logic:iterate>
			</html:select>
		</td>
	</tr>
	<tr>
		<td>Enable MyList</td>
		<td>
		 	<html:checkbox property="listOption" />
		</td>
	</tr>
	<tr>
		<td>Enable MyBanner</td>
		<td>
		 	<html:checkbox property="bannerOption" />
		</td>
	</tr>

</table>

		
		<html:submit value="Save Account Information"></html:submit>
	</html:form>

	<html:link page="/order.do?method=listOrders">
		My Orders
	</html:link>
</div>

<%@ include file="../common/IncludeBottom.jsp"%>

struts-comfig.xml配置了action和form-bean

<form-beans>
		<form-bean name="accountForm" type="com.frankco.biz.web.form.AccountForm"></form-bean>
	</form-beans>

<action path="/account"
	  			type="com.frankco.biz.web.actions.AccountAction"
	  			scope="request"
	  			parameter="method"
	  			name="accountForm">
	  		<forward name="SIGNON" path="/WEB-INF/jsp/account/SignonForm.jsp"></forward>
	  		<forward name="CATALOG_VIEWMAIN" path="/catalog.do?method=viewMain"></forward>
	  		<forward name="EDIT_ACCOUNT" path="/WEB-INF/jsp/account/EditAccountForm.jsp"></forward>
	  	</action>

下面是AccountForm：

package com.frankco.biz.web.form;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

public class AccountForm extends ActionForm {
	private String username;
	private String password;
	private String repeatedPassword;

	private String email;
	private String firstName;
	private String lastName;
	private String status;
	private String address1;
	private String address2;
	private String city;
	private String state;
	private String zip;
	private String country;
	private String phone;
	private String favouriteCategoryId;
	private String languagePreference;
	private boolean listOption;
	private boolean bannerOption;
	private String bannerName;

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public String getRepeatedPassword() {
		return repeatedPassword;
	}

	public void setRepeatedPassword(String repeatedPassword) {
		this.repeatedPassword = repeatedPassword;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getAddress1() {
		return address1;
	}

	public void setAddress1(String address1) {
		this.address1 = address1;
	}

	public String getAddress2() {
		return address2;
	}

	public void setAddress2(String address2) {
		this.address2 = address2;
	}

	public String getCity() {
		return city;
	}

	public void setCity(String city) {
		this.city = city;
	}

	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getZip() {
		return zip;
	}

	public void setZip(String zip) {
		this.zip = zip;
	}

	public String getCountry() {
		return country;
	}

	public void setCountry(String country) {
		this.country = country;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public String getFavouriteCategoryId() {
		return favouriteCategoryId;
	}

	public void setFavouriteCategoryId(String favouriteCategoryId) {
		this.favouriteCategoryId = favouriteCategoryId;
	}

	public String getLanguagePreference() {
		return languagePreference;
	}

	public void setLanguagePreference(String languagePreference) {
		this.languagePreference = languagePreference;
	}

	public boolean isListOption() {
		return listOption;
	}

	public void setListOption(boolean listOption) {
		this.listOption = listOption;
	}

	public boolean isBannerOption() {
		return bannerOption;
	}

	public void setBannerOption(boolean bannerOption) {
		this.bannerOption = bannerOption;
	}

	public String getBannerName() {
		return bannerName;
	}

	public void setBannerName(String bannerName) {
		this.bannerName = bannerName;
	}
	
	/**
	 * 不推荐使用ActionErrors
	 */
	/*
	@Override
	public ActionErrors validate(ActionMapping mapping,
			HttpServletRequest request) {
		ActionErrors errors = new ActionErrors();
        if(getUsername() == null || 
                getUsername().length() < 1) {

            errors.add(ActionMessages.GLOBAL_MESSAGE, 
                new ActionMessage("error.invalidUsername"));
        }
        
        if(getPassword() == null || 
                getPassword().length() < 1) {

            errors.add(ActionMessages.GLOBAL_MESSAGE, 
                new ActionMessage("error.invalidPassword"));
        }
        
        return errors;
	}
	*/
}

我这里怎么把form中用户提交的Account信息在数据库做修改（数据库已经存在数据记录）

我想到几种方式;
1.将form的Account信息通过反射填充到Account的pojo，pojo取得这些信息后
传到dao层给修改；但这里修改有些疑问。

public void update(Account account) throws DataAccessException {
	getHibernateTemplate().update(account);
}

直接这样修改？
hibernate的修改，我记得好像要先将Account中数据库中取出，此时Account为persistent状态，修改account的数据，再update到数据库。

但是我这里已经有了Account的对象作为参数传进来了，难道我要先从数据库get或load Account的对象出来，再把参数的account信息set到刚get或load出来的Account对象属性中（这里有两Account的pojo）再修改？

那太麻烦了。

我从Form填充到pojo，在dao层又要从pojo填充到get或load出的persistent状态的pojo，再做修改。蛋疼！！eggache！！

2.将AccountForm中用户提交的数据，复制到AccountDTO。数据传输对象。
AccountDTO作为参数传递到dao层用原生sql修改。

public void updateAccount(AccountDTO accountDTO) {
	
	UPDATE ACCOUNT SET
	      EMAIL = #{email},
	      FIRSTNAME = #{firstName},
	      LASTNAME = #{lastName},
	      STATUS = #{status},
	      ADDR1 = #{address1},
	      ADDR2 = #{address2,jdbcType=VARCHAR},
	      CITY = #{city},
	      STATE = #{state},
	      ZIP = #{zip},
	      COUNTRY = #{country},
	      PHONE = #{phone}
	    WHERE USERID = #{username}
 .........
	}

但我用这种方法完全体会不到hibernate给我带来的好处。

大家平时系统中是怎么实现的呢？
hibernate做修改真心麻烦啊！！还不如写jdbc呢！！！