连接MySQL并执行Update

王朝mysql·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

/*

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.knowsky.com)

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有  導航