jar连接数据库出现断开的解决方案

1. 采用JDBC连接数据库，如：DB2

 /**
  * 建立联接
  *
  * @return
  */
 public Connection getConnection() {
  try {
   conn = null;
   Class.forName(driverClassName).newInstance();
   log.debug("创建Mon连接……");
   conn = DriverManager.getConnection(app_url, app_user, app_password);
   log.debug("Mon连接创建成功!");
  } catch (Exception e) {
   log.debug("Mon连接创建失败!");
   log.error(e);
  }
  return conn;
 }

2. 实际应用

public class Dao extends DbFactory {

 private static Logger log = Logger.getLogger(Dao.class);

 private Dao() {
 }

 private static Dao instance = new Dao();

 public static Dao getInstance() {
  return instance;
 }

 /**
  * @return
  */
 public Map findAllTasks() {
  Map map = new HashMap();
  try {
   getConnection();
   if (conn == null) {
    throw new SQLException("数据库连接未创建!");
   }
   ps = conn.prepareStatement(SQL.YTPUB_BPCTA_LOAD);
   rs = ps.executeQuery();
   while (rs.next()) {
    Task entry = new Task();
    entry.setId(rs.getString(0));
    map.put(entry.getId(), entry);
   }

  } catch (SQLException e) {

   return null;
  } finally {
   this.close();
  }
  return map;
 }

}