mybatis从入门到过门坎

一.创建数据库

1包括id,last_name,gender,email,d_id外键

2.加入jar包mybatis-3.4.4.jar(mybatis包) mysql-connector-java-6.0.5.jar(数据库驱动包)

3.创建一个java文件，里面包含数据库参数(建议名字一样)

二,配置mybatis-config.xml

1.创建一个包(conf)里面放mybatis-config.xml

2.配置请先复制

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "mybatis-3-config.dtd" >

<configuration>

//会加载dbconf.properties配置如下(建一个文件，文件内容如下)

//jdbc.username=root
//jdbc.password=123456

//jdbc.driver=com.mysql.jdbc.Driver
//jdbc.url=jdbc:mysql://localhost:3306/stutest?//跟剧自己的配置//serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false

<properties resource="dbconf.properties"></properties>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">//加载数据池
       <property name="driver" value="${jdbc.driver}" />
                 <property name="url" value="${jdbc.url}"/>
                 <property name="username" value="${jdbc.username}" />
                 <property name="password" value="${jdbc.password}" />
</dataSource>
</environment>
</environments>

//以下内容请注意必须
<!-- sql映射到xml -->
<mappers>
<!-- <mapper resource="EmployeeMapper.xml" /> 

</mappers>
</configuration>

3.第一个helloworld

创建SqlSessionFactory
public void test() throws IOException{
String resource="mybatis-config.xml";
InputStream inputStream= Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
}

  //执行语句语句
SqlSession openSession = sqlSessionFactory.openSession();
try{

//执行语句
//是从config.xmr到Mapper中间mapper<mapper resource="EmployeeMapper.xml" /> 
//是空间+id  
EEmployee  employee=openSession.selectOne("conf.EmployeeMapper.xml.selectEmp",1);
System.out.println(employee);
}finally{
openSession.close();}
}

4.创建一个EmployeeMapper.XML

//根剧id查员工

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >
<mapper namespace="com.mybats.dao.EmployeeMapper">
  <select id="selectOne" resultType="Employee"  >
  <!-- select id,last_name lastName,gender,email from tabl_emple where id= #{id}  -->
  select *from tabl_emple where id= #{id} 
  </select>
</mapper>

5.接口绑定(推荐方法)

1注意必须空间和接口名字一样，函数方法和i一样（Mapper中）
2.通过SqlSessiond的到接口的类名，通过类名调函数（反射）
3.SqlSession connection 都是非线程安全的 不能写private ..
4.mapper接口没有实现类，但mybatis会成生代理对象与xml绑定
5.mybatis.xml包含数据库连接信息。。。，和sql映射文件