dbcompare.java

来自「23种GOF模式的java代码实现」· Java 代码 · 共 39 行

package org.gof.structure.facade;

/**
 * <p>Title: facade模式</p>
 * <p>Description: facade模式范例</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * Facade模式的定义: 为子系统中的一组接口提供一个一致的界面.
 * @author by lbj
 * @version 1.0
 */

import java.sql.*;

public class DBCompare {
  Mysql mysql;
  String sql = "SELECT * FROM <table> WHERE <column name> = ?";
  public void operation() throws Exception {
    try {
      mysql = new Mysql(sql);
      PreparedStatement prep = null;
      prep.setString(1, "<column value>");
      ResultSet rset = prep.executeQuery();
      if (rset.next()) {
        System.out.println(rset.getString("<column name"));
      }

    }
    catch (SQLException e) {
      e.printStackTrace();

    }
    finally {
      mysql.close();
      mysql = null;

    }
  }
}