insertcoffees.java

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

import java.sql.*;

public class InsertCoffees {
	public static void main(String args[]) {
		String url = "jdbc:odbc:MyDB";
		Connection con;
		String s = "INSERT INTO COFFEES";
		String s1 = s + " VALUES ('Colombian',101,7.99,0,0)";
		String s2 = s + " VALUES ('French_Roast',49,8.99,0,0)";
		String s3 = s + " VALUES ('Espresso',150,9.99,0,0)";
		String s4 = s + " VALUES ('Colombian_Decaf',101,8.99,0,0)";
		String s5 = s + " VALUES ('French_Roast_Decaf',49,9.99,0,0)";
		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(s1);
			stmt.executeUpdate(s2);
			stmt.executeUpdate(s3);
			stmt.executeUpdate(s4);
			stmt.executeUpdate(s5);
			stmt.close();
			con.close();
		} catch (SQLException ex) {
			System.err.println("SQLException:" + ex.getMessage());
		}
	}
}