daoconfig.java

演示ibatis的基本使用方法

package learndao.config;

//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 = "learndao/config/daoMap.xml";
  private static final DaoManager daoManager;
  private static final String props = "common/database.properties";
//  private static final Properties DBprops;
  static {
    try {
//      DBprops = Resources.getResourceAsProperties(props);
      daoManager = newDaoManager();
//      daoManager.startTransaction();
//      daoManager.endTransaction();
//      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() {
    try {
      Reader reader = Resources.getResourceAsReader(resource);
      return DaoManagerBuilder.buildDaoManager(reader);
    } catch (Exception e) {
      throw new RuntimeException("Could not initialize DaoConfig.  Cause: " + e, e);
    }
  }

}