IBATIS 的DaoConfig类

最新推荐文章于 2019-03-04 13:39:23 发布

原创最新推荐文章于 2019-03-04 13:39:23 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ibatis #properties #exception #string #null #url

JAVA 专栏收录该内容

42 篇文章

订阅专栏

本文介绍了一个使用IBATIS框架进行DAO配置和数据库初始化的例子。通过加载配置文件、建立数据库连接并运行SQL脚本来完成数据表结构及数据的创建。

import com.ibatis.common.jdbc.ScriptRunner; import com.ibatis.common.resources.Resources; import com.ibatis.dao.client.DaoManager; import com.ibatis.dao.client.DaoManagerBuilder; import java.io.Reader; import java.sql.Connection; import java.sql.DriverManager; import java.util.Properties; public class DaoConfig { private static final String resource = "com/ibatis/ben/persistence/dao.xml"; private static final DaoManager daoManager; static { try { daoManager = newDaoManager(null); Properties props = Resources .getResourceAsProperties("properties/database.properties"); String url = props.getProperty("url"); String driver = props.getProperty("driver"); String username = props.getProperty("username"); String password = props.getProperty("password"); Class.forName(driver).newInstance(); Connection conn = DriverManager.getConnection(url, username, password); try { ScriptRunner runner = new ScriptRunner(conn, false, false); runner.setErrorLogWriter(null); runner.setLogWriter(null); runner .runScript(Resources .getResourceAsReader("ddl/hsql/jpetstore-hsqldb-schema.sql")); runner .runScript(Resources .getResourceAsReader("ddl/hsql/jpetstore-hsqldb-dataload.sql")); } finally { conn.close(); } } catch (Exception e) { throw new RuntimeException("Description. Cause: " + e, e); } } public static DaoManager getDaoManager() { return daoManager; } public static DaoManager newDaoManager(Properties props) { try { Reader reader = Resources.getResourceAsReader(resource); return DaoManagerBuilder.buildDaoManager(reader, props); } catch (Exception e) { throw new RuntimeException( "Could not initialize DaoConfig. Cause: " + e, e); } } }