createcoffees.java

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

import java.sql.*;

public class CreateCoffees {
	public static void main(String args[]) {
		String url = "jdbc:odbc:MyDB";
		Connection con;
		String createString;
		createString = "create table COFFEES" + "(COF_NAME VARCHAR(32),"
				+ "SUP_ID INTEGER," + "PRICE FLOAT," + "SALES INTEGER,"
				+ "TOTAL INTEGER)";

		Statement stmt;

		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			System.err.print("ClassNotFoundException:");
			System.err.println(e.getMessage());
		}
		try {
			con = DriverManager.getConnection(url);
			stmt = con.createStatement();
			stmt.executeUpdate(createString);
			stmt.close();
			con.close();
		} catch (SQLException ex) {
			System.err.println("SQLException:" + ex.getMessage());
		}
	}
}