jdbc2.java

java 北大青鸟 java 北大青鸟

/** (c) 北大青鸟APTECH
 * 版权所有
 */

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

/** 这个类演示 SQL 中命令的用法.
 * @version 1.0, 2005 年 8 月 26 日
 * @author Ben
 */

class Jdbc2 {

  /**
   * 构造方法.
   */

  protected Jdbc2() {
  }

  /** 这是 main 方法.
   * 它演示 SQL 中各种命令的用法
   * @param args 被传递至 main 方法
   */
  public static void main(String[] args) {

    Connection con;
    Statement stmt;
    String url;
    String sql;

    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException ce) {
      System.out.println(ce);
    }

    try {
      url = "jdbc:odbc:test";
      con = DriverManager.getConnection(url,"sa","");
      sql = "Delete from friends where rtrim(name) like \'张三\';";
      System.out.println(" ");
      stmt = con.createStatement();
      stmt.executeUpdate(sql);
      System.out.println("张三 的记录已删除");
      con.close();
      con = DriverManager.getConnection(url,"sa","");
      sql = "Update friends set address=\'青岛\' where "
          + "rtrim(name) like \'李四\'; ";
      System.out.println(" ");
      stmt = con.createStatement();
      stmt.executeUpdate(sql);
      stmt.close();
      con.close();
      System.out.println("李四 的记录已更新");
    }
    catch (SQLException ce) {
      System.out.println(ce);
    }
  }
}