1.在数据库中创建数据
CREATE TABLE `t_person`(
`id` int(32) NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT NULL,
`nickname` varchar(32) DEFAULT NULL,
`age` int(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `t_person` VALUES ('1','zs','zz','3');
INSERT INTO `t_person` VALUES ('2','lisi','ll','4');
INSERT INTO `t_person` VALUES('3','wangwu','ww','5');
视图如下:
2.创建实体类
简单代码如下:
public class PersonMapper {
private Integer id;
private String name;
private String nickname;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getNickname() {
return nickname;
}
public void setNickname(String nickname) {
this.nickname = nickname;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
3.创建接口制定方法
public interface PersonMapper {
public Integer findCount();
}
4.由于我们使用的是maven所以在pom.xml中导包
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.36</version>
</dependency>
(如果使用的是java-web,则下载包后,导包通过如下添加)
5.创建连接数据库的xml文件:mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/db_mybatis"/>
<property name="username" value="root"/>
<property name="password" value="123"/>
</dataSource>
</environment>
</environments>
</configuration>
6.创建可以对接接口类,后对数据库进行操作的xml文件:PersonMapper.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="cn.kgc.mapper.PersonMapper">
<select id="findCount" resultType="java.lang.Integer">
select count(*) from t_person
</select>
</mapper>
7.创建测试类
public class TestMybatis {
@Test
public void testHelloWorld() throws IOException {
//1.定义配置文件
String config="mybatis-config.xml";
//2.读取配置文件
InputStream in= Resources.getResourceAsStream(config);
//3.创建SqlSessionFactionBuilder对象
SqlSessionFactoryBuilder builder =new SqlSessionFactoryBuilder();
//4.创建SqlSessionFactory对象
SqlSessionFactory factory=builder.build(in);
//5.获取sqlSession对象
SqlSession sqlSession = factory.openSession();
//6.执行sql语句
Integer count=sqlSession.getMapper(PersonMapper.class).findCount();
System.out.println("count:"+count);
//7.关闭sqlSession对象
sqlSession.close();
}
}
注意:各个类的位置如下
各类型的包设置途径如下