準(zhǔn)備環(huán)境：安裝jdk 录肯、maven锹杈、mysql志电、Intellij IDEA
官方文檔：http://www.mybatis.org/mybatis-3/zh/index.html
示例步驟
1.新建maven項(xiàng)目
1.png
2.在pom.xml中配置mybatis彻消、mysql依賴
<dependencies>
<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.38</version>
</dependency>
</dependencies>
3.啟動(dòng)本地mysql服務(wù)，創(chuàng)建mysql數(shù)據(jù)庫student嚣崭，數(shù)據(jù)庫中創(chuàng)建student表
2.png
4.創(chuàng)建Student類笨触，類中屬性與student表中字段一 一對(duì)應(yīng)
public class Student{
int id;
String name;
String sex;
public Student(){
}
public Student(int id,String name,String sex){
this.id=id;
this.name=name;
this.sex=sex;
}
public int getId(){
returnid;
}
public void setId(intid){
this.id=id;
}
public String getName(){
returnname;
}
public void setName(String name){
this.name=name;
}
public String getSex(){
returnsex;
}
public void setSex(String sex){
this.sex=sex;
}
@Override
public String toString(){
return"Student{"+
"id="+id+
",name='"+name+'\''+
",sex='"+sex+'\''+
'}';
}
}
5.創(chuàng)建studentMapper.xml，在此文件中管理sql語句
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEmapper
PUBLIC"-//mybatis.org//DTDMapper3.0//EN"
"[http://mybatis.org/dtd/mybatis-3-mapper.dtd](http://mybatis.org/dtd/mybatis-3-mapper.dtd)">
<mapper namespace="orm.mapper.studentMapper">
<!--resultType:返回值類型 parameterType:參數(shù)類型-->
<selectid="selectById"
resultType="orm.entity.Student" parameterType="int">
select*from student where id=#{id}
</select>
</mapper>
6.創(chuàng)建config.xml配置文件雹舀，配置數(shù)據(jù)庫連接信息芦劣、mapper信息
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEconfiguration
PUBLIC"-//mybatis.org//DTDConfig3.0//EN"
"[http://mybatis.org/dtd/mybatis-3-config.dtd](http://mybatis.org/dtd/mybatis-3-config.dtd)">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<!--此處配置數(shù)據(jù)庫連接信息
type="POOLED":為用鏈接池方式訪問數(shù)據(jù)庫-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/student"/>
<property name="username" value="root"/>
<property name="password" value="xiaofu"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="orm/mapper/studentMapper.xml"/>
</mappers>
</configuration>
7.測試一下
public class FirstBasicDemoTest{
public static void main(String[] args){
//獲取sqlsession對(duì)象
String resource="firstBasicDemoConfigure.xml";
Reader reader=null;
try{
reader=Resources.getResourceAsReader(resource);
}catch(IOExceptione){
e.printStackTrace();
}
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(reader);
SqlSessionsession=sqlSessionFactory.openSession();
//進(jìn)行查詢操作
Stringstatment="orm.mapper.studentMapper.selectById";
Studentstudent=session.selectOne(statment,1);
System.out.println(student);
}
}
運(yùn)行結(jié)果：
image
運(yùn)行程序時(shí)可能會(huì)報(bào)錯(cuò)：
mybatis讀取配置文件報(bào)錯(cuò)：Could not find resource firstBasicDemoConfigure.xml
原因：在classes目錄下沒有找到配置文件，所以配置文件沒有在編譯范圍
解決：在pom.xml中添加下方配置
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
