初探MyBatis之HelloWorld（二）

二、不使用 XML 构建 SqlSessionFactory

不使用xml构建SqlSessionFactory的话，就要用java代码来连接数据库。我这里直接new DataSorce()接口实现getConnection()方法（不知道对不对，反正实验证明，可行）。

EmployeeDataSourceFactory.java：

package yyc.mybatis.util;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.util.logging.Logger;

import javax.sql.DataSource;

public class EmployeeDataSourceFactory {
    
    public static DataSource getEmployeeDataSorce(){
        DataSource ds=new DataSource() {
            
            public <T> T unwrap(Class<T> iface) throws SQLException {
                // TODO Auto-generated method stub
                return null;
            }
            
            public boolean isWrapperFor(Class<?> iface) throws SQLException {
                // TODO Auto-generated method stub
                return false;
            }
            
            public void setLoginTimeout(int seconds) throws SQLException {
                // TODO Auto-generated method stub
                
            }
            
            public void setLogWriter(PrintWriter out) throws SQLException {
                // TODO Auto-generated method stub
                
            }
            
            public Logger getParentLogger() throws SQLFeatureNotSupportedException {
                // TODO Auto-generated method stub
                return null;
            }
            
            public int getLoginTimeout() throws SQLException {
                // TODO Auto-generated method stub
                return 0;
            }
            
            public PrintWriter getLogWriter() throws SQLException {
                // TODO Auto-generated method stub
                return null;
            }
            
            public Connection getConnection(String username, String password) throws SQLException {
                // TODO Auto-generated method stub
                return null;
            }
            
57             public Connection getConnection() throws SQLException {
58                 try {
59                     Class.forName("com.mysql.jdbc.Driver");
60                     String url="jdbc:mysql:///mybatis";
61                     String user="root";
62                     String password="123";
63                     Connection connection = DriverManager.getConnection(url, user, password);
64                     return connection;
65                 } catch (ClassNotFoundException e) {
66                     e.printStackTrace();
67                 }
68                 return null;
69             }
70         };
71         return ds;
    }
}

在第一种时，写了一个xml的SQL映射文件（EmployeeMapperXml.xml），现在既然不用xml了，就需要另一种你方式来映射SQL吧，mybatis提供面向接口编程的方式。官方文档中是这样说的：

它们的映射的语句可以不需要用 XML 来做，取而代之的是可以使用 Java 注解。比如：
package org.mybatis.example;
public interface BlogMapper {
  @Select("SELECT * FROM blog WHERE id = #{id}")
  Blog selectBlog(int id);
}

我这里写一接口：

EmployeeMapper.java：

package yyc.mybatis.mapper;
import org.apache.ibatis.annotations.Select;
import yyc.mybatis.bean.Employee;
public interface EmployeeMapper {

    @Select("SELECT id,last_name lastName,gender,email FROM tb1_employee WHERE id= #{id}")
    public Employee selectOne(Integer id);
}

测试方法（不用xml来得到SqlSessionFactory的方式也不一样）：

@Test
    public void testJavaConfig(){
        DataSource dataSource = EmployeeDataSourceFactory.getEmployeeDataSorce();
        TransactionFactory transactionFactory = new JdbcTransactionFactory();
        Environment environment = new Environment("development", transactionFactory, dataSource);
        Configuration configuration = new Configuration(environment);
        configuration.addMapper(EmployeeMapper.class);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
    
        
        //2.获取sqlSession实例，能直接执行已经映射的sql语句
                SqlSession openSession = sqlSessionFactory.openSession();
                
                try {
                    EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
                    Employee employee = mapper.selectOne(3);
                    System.out.println(employee);
                } catch (Exception e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }finally {
                    openSession.close();
                }
    }

输出：

Employee [id=3, lastName=mac, gender=1, email=cc@163.com]

这样就完全脱离了两个xml配置文件实现查询数据库。