科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道JDBC 程序实例

JDBC 程序实例

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

B.1 Using SELECT import java.net.URL;   import java.sql.*;   class Select

作者:中国IT实验室 来源:中国IT实验室 2007年9月9日

关键字: JDBC

  • 评论
  • 分享微博
  • 分享邮件

   B.1 Using SELECT import java.net.URL;
  import java.sql.*;
  class Select {
  public static void main(String argv[]) {
  try {
  // Create a URL specifying an ODBC data source name.
  String url = "jdbc:odbc:wombat";
  // Connect to the database at that URL.
  Connection con = DriverManager.getConnection(url, "kgh", "");
  // Execute a SELECT statement
  Statement stmt = con.createStatement();
  ResultSet rs = stmt.executeQuery("SELECT a, b, c, d, key FROM Table1");
  // Step through the result rows.
  System.out.println("Got results:");
  while (rs.next()) {
  // get the values from the current row:
  int a = rs.getInt(1);
  BigDecimal b = rs.getBigDecimal(2);
  char c[] = rs.getString(3).tocharArray();
  boolean d = rs.getBoolean(4);
  String key = rs.getString(5);
  // Now print out the results:
  System.out.print(" key=" + key);
  System.out.print(" a=" + a);
  System.out.print(" b=" + b);
  System.out.print(" c=");
  for (int i = 0; i < c.length; i++) {
  System.out.print(c[i]);
  }
  System.out.print(" d=" + d);
  System.out.print("\n");
  }
  stmt.close();
  con.close();
  } catch (java.lang.Exception ex) {
  ex.printStackTrace();
  }
  }
  }
  
  B.2 Using UPDATE // Update a couple of rows in a database.
  import java.net.URL;
  import java.sql.*;
  class Update {
  public static void main(String argv[]) {
  try {
  // Create a URL specifying an ODBC data source name.
  String url = "jdbc:odbc:wombat";
  // Connect to the database at that URL.
  Connection con = DriverManager.getConnection(url, "kgh", "");
  // Create a prepared statement to update the "a" field of a
  // row in the "Table1" table.
  // The prepared statement takes two parameters.
  PreparedStatement stmt = con.prepareStatement(
  "UPDATE Table1 SET a = ? WHERE key = ?");
  // First use the prepared statement to update
  // the "count" row to 34.
  stmt.setInt(1, 34);
  stmt.setString(2, "count");
  stmt.executeUpdate();
  System.out.println("Updated \"count\" row OK.");
  // Now use the same prepared statement to update the
  // "mirror" field.
  // We rebind parameter 2, but reuse the other parameter.
  stmt.setString(2, "mirror");
  stmt.executeUpdate();
  System.out.println("Updated \"mirror\" row OK.");
  stmt.close();
  con.close();
  } catch (java.lang.Exception ex) {
  ex.printStackTrace();
  }
  }
  }
  
  

查看本文来源

    • 评论
    • 分享微博
    • 分享邮件
    邮件订阅

    如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章