六狼论坛

 找回密码
 立即注册

QQ登录

只需一步,快速开始

新浪微博账号登陆

只需一步,快速开始

搜索
查看: 191|回复: 0

ibatis中执行sql脚本

[复制链接]

升级  98%

11

主题

11

主题

11

主题

童生

Rank: 1

积分
49
 楼主| 发表于 2013-1-14 23:48:47 | 显示全部楼层 |阅读模式
package com.ibatis.jpetstore.persistence;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/jpetstore/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");      if (url.equals("jdbc:hsqldb:mem:jpetstore")) {        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);    }  }}
您需要登录后才可以回帖 登录 | 立即注册 新浪微博账号登陆

本版积分规则

快速回复 返回顶部 返回列表