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() );
		}	
	}
}