package com.example.controller;

import org.apache.ibatis.datasource.DataSourceFactory;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.transaction.TransactionFactory;
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

public class SqlSessionController {
    private static final Properties prop = new Properties();
    private static final Configuration config;

    static {
        InputStream is = SqlSessionController.class.getResourceAsStream("..\\..\\..\\dataSource.properties");
        try {
            prop.load(is);
        } catch ( IOException e ) {
            e.printStackTrace();
            System.exit(-1);
        } finally {
            if (is != null)
                try {
                    is.close();
                } catch ( IOException e ) {
                    e.printStackTrace();
                    System.exit(-1);
                }
        }
        /*prop.setProperty("driver","org.mariadb.jdbc.Driver");
        prop.setProperty("url","jdbc:mariadb://192.168.88.128:3306/MyBatisDemo");
        prop.setProperty("username","alan");
        prop.setProperty("password","123456");*/
        DataSourceFactory dataSourceFactory = new UnpooledDataSourceFactory();
        dataSourceFactory.setProperties(prop);
        DataSource dataSource = dataSourceFactory.getDataSource();
        TransactionFactory transactionFactory = new JdbcTransactionFactory();
        Environment environment = new Environment("development",transactionFactory,dataSource);
        config = new Configuration(environment);
        config.addMappers("com.example.dao");
    }

    public static SqlSessionFactory getSqlSessionFactory () {
        return new SqlSessionFactoryBuilder().build(config);
    }
}