updatesql.java

本书属于《开发专家之 Sun ONE》系列丛书

//UpdateSQL.java
// Update a couple of rows in a database.
import java.net.URL;
import java.sql.*;

class UpdateSQL
{

	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();
		}
	}
}