mybatis的第一个程序-蒲公英云

mybatis的第一个程序

1、首先第一步，通过 xml 文件创建 SqlSessionFactory

xml文件如下所示：

mybatis-config.xml

<?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="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/test"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>
  <!--  加载Dao的xml映射文件  -->
  <mappers>
      <mapper resource="com/zwz/mapper/UserDao.xml" />
  </mappers>
</configuration>

2、java代码加载SqlSessionFactory，创建 Session，发送 sql 语句

代码实现如下：

public class MybatisTest {
    public static void main(String[] args) throws Exception {
        String resource = "mybatis-config.xml";
        InputStream in = Resources.getResourceAsStream(resource);
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
        SqlSession sqlsession = factory.openSession();
        List<User>ulist = sqlsession.selectList(  "com.zwz.dao.UserDao.selectList"  );
        for(User user:ulist){
            System.out.println( user.getName() );
        }    
    }
}