<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 选择默认的连接方式 -->
<environments default="myb">
<environment id="myb">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/easybuy"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="entity/adminUsersMapper.xml"/>
<mapper resource="entity/shinfoMapper.xml"/>
</mappers>
</configuration>
entity
package entity;
import java.util.Date;
/**
* 管理员用户实体类
* @author Administrator
*
*/
public class adminUsers {
private int id;
private String uname;
private String pwd;
private Date createtime;
public adminUsers(){
}
public adminUsers(String uname, String pwd, Date createtime) {
super();
this.uname = uname;
this.pwd = pwd;
this.createtime = createtime;
}
public adminUsers(int id, String uname, String pwd, Date createtime) {
super();
this.id = id;
this.uname = uname;
this.pwd = pwd;
this.createtime = createtime;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Date getCreatetime() {
return createtime;
}
public void setCreatetime(Date createtime) {
this.createtime = createtime;
}
}
entity对应的mapper文件
<?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="entity.adminUsers">
<!-- 登录 -->
<select id="adminlogin" parameterType="entity.adminUsers" resultType="entity.adminUsers">
select * from adminusers where uname=#{uname} and pwd=#{pwd}
</select>
</mapper>
service
package service;
import entity.adminUsers;
public interface adminUsersService {
public adminUsers login(String uname,String pwd);
}
serviceimpl
package service.impl;
import dao.adminUsersDao;
import dao.impl.adminUsersDaoImpl;
import entity.adminUsers;
import service.adminUsersService;
public class adminUsersServiceImpl implements adminUsersService{
adminUsersDao aud=new adminUsersDaoImpl();
@Override
public adminUsers login(String uname, String pwd) {
adminUsers au=aud.login(uname, pwd);
return au;
}
}
dao
package dao;
import entity.adminUsers;
public interface adminUsersDao {
public adminUsers login(String uname,String pwd);
}
daoimpl
package dao.impl;
import org.apache.ibatis.session.SqlSession;
import dao.adminUsersDao;
import entity.adminUsers;
import util.mybatisutil;
public class adminUsersDaoImpl implements adminUsersDao{
SqlSession session=null;
@Override
public adminUsers login(String uname, String pwd) {
adminUsers adu=new adminUsers(uname, pwd, null);
session=mybatisutil.getsession();
adminUsers au=session.selectOne("entity.adminUsers.adminlogin", adu);
return au;
}
}