updatecoffees.java

来自「一个简单的连接数据库的小程序,适合新手学习JAVA用」· Java 代码 · 共 38 行

import java.sql.*;

public class UpdateCoffees {
	public static void main(String args[]) {
		String url = "jdbc:odbc:MyDB";
		Connection con;
		String UPdateString1 = "UPdate COFFEES SET SALES=75 WHERE COF_NAME LIKE 'Colombian'";
		String UPdateString2 = "UPdate COFFEES SET TOTAL=75+TOTAL WHERE COF_NAME LIKE 'Colombian'";
		String query = "SELECT COF_NAME,SALES,TOTAL FROM COFFEES WHERE COF_NAME LIKE 'Colombian'";
		Statement stmt;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (java.lang.ClassNotFoundException e) {
			System.err.print("ClassNotFoundException:");
			System.err.println(e.getMessage());
		}
		try {
			con = DriverManager.getConnection(url);
			stmt = con.createStatement();
			stmt.executeUpdate(UPdateString1);
			stmt.executeUpdate(UPdateString2);
			ResultSet rs = stmt.executeQuery(query);
			while (rs.next()) {
				String s = rs.getString("COF_NAME");
				int n = rs.getInt("SALES");
				int m = rs.getInt(3);
				System.out.println(n + "pounds of" + s + "sold this week.");
				System.out.println(m + "pounds of" + s + "sold to date.");
			}
			stmt.close();
			con.close();
		} catch (SQLException ex) {
			System.err.println("SQLException:" + ex.getMessage());
		}
	}
}