JDBC示例

上一篇 / 下一篇 2009-04-29 14:13:47 / 个人分类：监控服务器

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Class.forName("jdbc.DriverXYZ");

Connection con = DriverManager.getConnection(url, "myLogin", "myPassword");

String createTableCoffees = "CREATE TABLE COFFEES " + "(COF_NAME VARCHAR(32), SUP_ID INTEGER, PRICE FLOAT, " + "SALES INTEGER, TOTAL INTEGER)";

Statement stmt = con.createStatement();

stmt.executeUpdate(createTableCoffees);

stmt.executeUpdate( "INSERT INTO COFFEES " + "VALUES ('Colombian', 101, 7.99, 0, 0)");

stmt.executeUpdate("INSERT INTO COFFEES " + "VALUES ('French_Roast', 49, 8.99, 0, 0)");

TAG: