DROP ? TABLE ?t_user_mail;

CREATE ? TABLE ?t_user_mail?(
???????id? INT ? NOT ? NULL ?AUTO_INCREMENT
?????,?name? VARCHAR ( 50 )
?????,?age? INT
?????,?email? VARCHAR ( 300 )
?????,? PRIMARY ? KEY ?(id)
);

package ?cn.blogjava.usertype;

import ?java.io.Serializable;
import ?java.sql.PreparedStatement;
import ?java.sql.ResultSet;
import ?java.sql.SQLException;
import ?java.sql.Types;
import ?java.util.ArrayList;
import ?java.util.List;

import ?org.apache.commons.lang.StringUtils;
import ?org.hibernate.Hibernate;
import ?org.hibernate.HibernateException;
import ?org.hibernate.usertype.UserType;

public ? class ?EMailList? implements ?UserType?{

???? private ? static ? final ? char ?SPLITTER = ? ' ; ' ;
???? private ? static ? final ? int []?TYPES? = ? new ? int []?{Types.VARCHAR};
????
???? public ? int []?sqlTypes()?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ?TYPES;
????}

???? public ?Class?returnedClass()?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ?List. class ;
????}

???? public ? boolean ?equals(Object?x,?Object?y)? throws ?HibernateException?{
???????? if (x? == ?y)? return ? true ;
???????? if (x? != ? null ? & ?y? != ? null )?{
????????????List?xlist? = ?(List)x;
????????????List?ylist? = ?(List)y;
????????????
???????????? if (xlist.size()? != ?ylist.size())? return ? false ;
???????????? for ?( int ?i? = ? 0 ;?i? < ?xlist.size();?i ++ )?{
????????????????String?str1? = ?(String)xlist.get(i);
????????????????String?str2? = ?(String)ylist.get(i);
???????????????? if ( ! str1.equals(str2))? return ? false ;
????????????}
???????????? return ? true ;
????????}
???????? return ? false ;
????}

???? public ? int ?hashCode(Object?arg0)? throws ?HibernateException?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ? 0 ;
????}

???? public ?Object?nullSafeGet(ResultSet?rs,?String[]?names,?Object?owner)
???????????? throws ?HibernateException,?SQLException?{
????????String?value? = ?(String)Hibernate.STRING.nullSafeGet(rs,?names[ 0 ]);
???????? if (value? != ? null )?{
???????????? return ?parse(value);
????????}? else ?{
???????????? return ? null ;
????????}
????}

???? public ? void ?nullSafeSet(PreparedStatement?st,?Object?value,? int ?index)
???????????? throws ?HibernateException,?SQLException?{
???????? if (value? != ? null )?{
????????????String?str? = ?assemble((List)value);
????????????Hibernate.STRING.nullSafeSet(st,?str,?index);
????????}? else ?{
????????????Hibernate.STRING.nullSafeSet(st,?value,?index);
????????}
????}

???? public ?Object?deepCopy(Object?value)? throws ?HibernateException?{
????????List?sourceList? = ?(List)value;
????????List?targetList? = ? new ?ArrayList();
????????targetList.addAll(sourceList);
???????? return ?targetList;
????}

???? public ? boolean ?isMutable()?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ? false ;
????}

???? public ?Serializable?disassemble(Object?arg0)? throws ?HibernateException?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ? null ;
????}

???? public ?Object?assemble(Serializable?arg0,?Object?arg1)
???????????? throws ?HibernateException?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ? null ;
????}

???? public ?Object?replace(Object?arg0,?Object?arg1,?Object?arg2)
???????????? throws ?HibernateException?{
???????? // ?TODO?Auto-generated?method?stub
???????? return ? null ;
????}
????
???? private ?String?assemble(List?emailList)?{
????????StringBuffer?strBuf? = ? new ?StringBuffer();
???????? for ?( int ?i? = ? 0 ;?i? < ?emailList.size() - 1 ;?i ++ )?{
????????????strBuf.append((String)emailList.get(i)).append(SPLITTER);????????????
????????}
????????strBuf.append(emailList.get(emailList.size() - 1 ));
???????? return ?strBuf.toString();
????}
????
???? private ?List?parse(String?value)?{
????????String[]?strs? = ?StringUtils.split(value,?SPLITTER);
????????List?emailList? = ? new ?ArrayList();
???????? for ?( int ?i? = ? 0 ;?i? < ?strs.length;?i ++ )?{
????????????emailList.add(strs[i]);
????????}
???????? return ?emailList;
????}

}