【郑州校区】传智健康项目讲义第八章三 - 黑马程序员技术交流社区

【郑州校区】传智健康项目讲义第八章三

[AppleScript] 纯文本查看 复制代码

 public void add(Member member);

public Member findByTelephone(String telephone);

[AppleScript] 纯文本查看 复制代码

//根据手机号查询会员

public Member findByTelephone(String telephone) {

return memberDao.findByTelephone(telephone);

}

//新增会员

public void add(Member member) {

if(member.getPassword() != null){

member.setPassword(MD5Utils.md5(member.getPassword()));

}

memberDao.add(member);

}

[AppleScript] 纯文本查看 复制代码

public Member findByTelephone(String telephone);

public void add(Member member);

[AppleScript] 纯文本查看 复制代码

<!‐‐新增会员‐‐>

<insert id="add" parameterType="com.itheima.pojo.Member">

<selectKey resultType="java.lang.Integer" order="AFTER"

keyProperty="id">

SELECT LAST_INSERT_ID()

</selectKey>

insert into t_member

(fileNumber,name,sex,idCard,phoneNumber,regTime,password,email,birthday,r

emark)

values

(#{fileNumber},#{name},#{sex},#{idCard},#{phoneNumber},#{regTime},#

{password},#{email},#{birthday},#{remark})

</insert>

<!‐‐根据手机号查询会员‐‐>

<select id="findByTelephone" parameterType="string"

resultType="com.itheima.pojo.Member">

select * from t_member where phoneNumber = #{phoneNumber}

</select>