連接MySQL并執行Update

2019-11-18 16:06:43

字體：大中小

來源：轉載

供稿：網友

/*

Database PRogramming with JDBC and java, Second Edition
By George Reese
ISBN: 1-56592-616-1

Publisher: O'Reilly

*/

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

/**
* Example 3.3
*/
public class Update {
  public static void main(String args[]) {
    Connection con = null;

    if (args.length != 2) {
      System.out.println("Syntax: <java UpdateApp [number] [string]>");
      return;
    }
    try {
      String driver = "com.imaginary.sql.msql.MsqlDriver";      Class.forName(driver).newInstance();
      String url = "jdbc:msql://carthage.imaginary.com/ora";
      con = DriverManager.getConnection(url, "borg", "");
      Statement s = con.createStatement();
      String test_id = args[0];
      String test_val = args[1];
      int update_count = s
          .executeUpdate("INSERT INTO test (test_id, test_val) "
              + "VALUES(" + test_id + ", '" + test_val + "')");

      System.out.println(update_count + " rows inserted.");
      s.close();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      if (con != null) {
        try {
          con.close();
        } catch (SQLException e) {
          e.printStackTrace();
        }
      }
    }
  }
}

（出處：http://www.survivalescaperooms.com）

上一篇：在Spring中配置Collection

下一篇：連接MySQL并執行Select