mybatis案例

来源：互联网发布：淘宝主播的东西可靠吗编辑：程序博客网时间：2024/04/30 13:05

1.login.jsp:

<body>
<form action="userinfoAction/login.action" method="post">
请选择您的身份：<input type="text" name="type"><br/>
请输入您的账号：<input type="text" name="userid"><br/>
请输入您的账号：<input type="password" name="userpwd"><br/>
<input type="submit" value="登录"><br/>
</form>
</body>

2.T_employerMapper.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.ruicaiedu.ayi51.dao.T_employerMapper">

<select id="login" resultType="T_employer">
select * from t_employer where userid = #{userid} and userpwd = #{userpwd} and type = #{type}
</select>
</mapper>

3.T_employerMapper接口：

package com.ruicaiedu.ayi51.dao;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import com.ruicaiedu.ayi51.domain.T_employer;

@Component("t_employerMapper")
public interface T_employerMapper {
//雇主登录
public T_employer login(@Param("userid")String userid,@Param("userpwd")String userpwd,@Param("type")String type);
}

0 0