MyBatis - 如何从 swing 应用程序设置数据库属性？

Question

假设我有 swing 应用程序，并且正在使用 mybatis：

public class MyAppCView extends FrameView {

    public SqlSession session;
    public StaticMapper mapper;

    public Config c = new Config();

    public MyAppView(SingleFrameApplication app) {
        super(app);      

        String user="root", pswd="root"    

        session = MyBatisSqlSessionFactory.getSqlSessionFactory().openSession();
        mapper = session.getMapper(StaticMapper.class);  

MyBatisSqlSessionFactory 看起来像这样：

public class MyBatisSqlSessionFactory {
    public static Map<String,String> propeties = new HashMap<String,String>();

    protected static final SqlSessionFactory FACTORY;


    static {
        try {
            Properties props = new Properties();

            props.setProperty("username", user);
            ....

            // how can i get variables from swing application into configuration of sqlfactory?

            Reader reader = Resources.getResourceAsReader("wsnscc/mybatis/xml/Configuration.xml");
            FACTORY = new SqlSessionFactoryBuilder().build(reader,props);
        } catch (Exception e){
            throw new RuntimeException("Fatal Error.  Cause: " + e, e);
        }
    }

    public static SqlSessionFactory getSqlSessionFactory() {
        return FACTORY;
    }
}

如何从 swing 应用程序获取变量到 sqlfactory 的配置中？

感谢您的任何建议。

Answer 1

您将变量传递到 SQL 工厂。

您可以通过将类 MyBatisSQLSessionFactory 更改为如下内容来实现此目的：

public class MyBatisSqlSessionFactory {
    public static Map<String,String> properties = new HashMap<String,String>();

    protected static final SqlSessionFactory FACTORY;

    public MyBatisSqlSessionFactory(String userid, String password) {
        try {
            Properties props = new Properties();

            props.setProperty("username", userid);
            props.setProperty("password", password);

            Reader reader = Resources.getResourceAsReader
               ("wsnscc/mybatis/xml/Configuration.xml");

        } catch (Exception e){
            throw new RuntimeException("Fatal Error.  Cause: " + e, e);
        }
    }

    public static SqlSessionFactory getSqlSessionFactory
            (String userid, String password) 
            throws RuntimeException {
        if (FACTORY == null) 
            FACTORY = new MyBatisSqlSessionFactory(userid, password);
        return FACTORY;
    }
}