package com.zjy.ibatis.model;
import java.util.List;
public class Customer {
private int id;
private String username;
private String password;
private Account account;
private List<Order> orders;
private List<Activity> activitys;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
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 Account getAccount() {
return account;
}
public void setAccount(Account account) {
this.account = account;
}
public List<Order> getOrders() {
return orders;
}
public void setOrders(List<Order> orders) {
this.orders = orders;
}
public List<Activity> getActivitys() {
return activitys;
}
public void setActivitys(List<Activity> activitys) {
this.activitys = activitys;
}
}
<?xml version=”1.0″ encoding=”UTF-8″ ?>
<!DOCTYPE mapper
PUBLIC “-////DTD Mapper 3.0//EN”
”-3-mapper.dtd”>
<mapper namespace=”com.zjy.ibatis.ICustomerDao” >
<resultMap type=”com.zjy.ibatis.model.Customer” id=”customerResultMap”>
<id property=”id” column=”id”/>
<result property=”username” column=”user_name”/>
<result property=”password” column=”user_pass”/>
<association property=”account” select=”com.zjy.ibatis.IAccountDao.findAccountByCustomerId” column=”id”></association>
<collection property=”orders” javaType=”ArrayList” ofType=”Order”
select=”com.zjy.ibatis.IOrderDao.findOrderByCustomerId” column=”id”/>
<collection property=”activitys” javaType=”ArrayList” ofType=”Activity”
select=”com.zjy.ibatis.IActivityDao.findActivitysByCustomerId” column=”id”/>
</resultMap>
<insert id=”insert” parameterType=”Customer”>
insert into customer(username,password)values(#{username},#{password})
</insert>
<delete id=”delete” parameterType=”java.lang.Integer”>
delete from customer where id=#{id}
</delete>
<update id=”update” parameterType=”Customer”>
update customer set username=#{username},password=#{password} where id=#{id}
</update>
<select id=”findById” parameterType=”java.lang.Integer” resultType=”Customer” resultMap=”customerResultMap” >
select * from customer where id=#{id}
</select>
<select id=”query” parameterType=”Customer” resultMap=”customerResultMap”>
select * from customer
<where>
<if test=”username!=null and username!=””>
user_name like concat(concat(‘%’,#{username}),’%’)
</if>
<if test=”password!=null and password!=””>
or user_pass like concat(concat(‘%’,#{password}),’%’)
</if>
</where>
</select>
</mapper>
世上最累人的事，莫过於虚伪的过日子
