导入MyBatis的jar包和连接数据库的驱动包
通过maven的依赖直接导入:
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
使用MyBatis
- 首相创建一个Person类:
package com.jd.vo;
public class Person {
private String id;
private String userName;
private String password;
public String getId() {
return id;
}
public void setId(String 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;
}
@Override
public String toString() {
return "Person{" +
"id='" + id + '\'' +
", userName='" + userName + '\'' +
", password='" + password + '\'' +
'}';
}
}
- 再创建一个接口:
package com.jd.person;
import com.jd.vo.Person;
import org.apache.ibatis.annotations.Param;
public interface IPersonDao {
Person getPersonById(Person person);
}
- 创建名为mybatis-config.xml的xlm文件:
<?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="dev">
<!-- 配置数据库连接信息 -->
<environment id="dev">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
<environment id="test">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
<environment id="apply">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!-- 注册Mapper xml文件 -->
<mappers>
<mapper resource="./person.xml"/>
</mappers>
</configuration>
- 创建名为person.xml的xlm文件
<?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.jd.person.IPersonDao">
<select id="getPersonById" resultType="Person">
select id,user_name,password from user_info where id = #{id} and user_name = #{userName}
</select>
</mapper>
- 创建Test类进行测试:
package com.jd.test;
import com.jd.person.IPersonDao;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
public class Test {
public static void main(String[] args) throws IOException {
//加载全局配置文件
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
//sqlSession对象表示一次数据库连接
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = factory.openSession();//当为true时,则会自动提交事务;当为false时,需要手动提交;默认值为false
//从sqlSession获取接口实现类对象
IPersonDao personDao = sqlSession.getMapper(com.jd.person.IPersonDao.class);
Person person = new Person();
person.setId("92a089f7-fb9c-4824-851b-a27c766bdc38");
person.setUserName("Make");
person = personDao.getPersonById(person);
System.out.println(person);
}
}
最终输出通过mybits连接数据库查询的结果:
Person{id='92a089f7-fb9c-4824-851b-a27c766bdc38', userName='Make', password='22222222222'}
参数传递
有时Mapper接口需要将一个或多个参数传递到XML映射文件中,那么XML文件如何接收到来自Mapper接口的参数数据呢?
- Mapper接口方法只有一个参数时,则XML映射文件中获取该参数数据时硬性的要求,比如:接口抽象方法参数为String。
id,则XML映射文件中可通过 #{任意字符串 } 获取到该参数的数据。 - Mapper接口方法当有多个参数时,默认情况下MyBatis将这些参数放在Map集合中,key为arg0…argn或param1…paramn,在XML映射文件中通过#{key}获取key所对应的参数数据;但为了在获取参数数据时XML映射文件中的key有意义,可以通过在Mapper接口相应抽象方法的参数数据类型前添加 @Param 注解的方式指定key的值。
- 当参数为自定义引用类型时,则XML映射文件直接使用#{成员变量名}的方式获取相应成员变量的值。(如上述使用MyBits的例子便是用自定义的引用类型Person)
例如:
package com.jd.person;
import com.jd.vo.Person;
import org.apache.ibatis.annotations.Param;
public interface IPersonDao {
//返回值为boolean类型则返回是否成功,返回值为int类型则返回受影响的有几行
boolean delete(@Param("id")String id, @Param("userName")String userName);
}
此时传入了两个参数,则必须加上@Param来指定每一个参数的名字,然后在person.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.jd.person.IPersonDao">
<delete id="delete">
delete from user_info where id=#{id} and user_name=#{userName}
</delete>
</mapper>
由此便可以删除同时符合相同id和相同user_name的数据。