createcoffees.java

没有太多说明,一看就知道!我菜鸟一个,所以也没有什么太多意见!

import java.sql.*;
public  class  CreateCoffees
{public static void main(string args[]){ 
String myurl="jdbc://mysql/test/uer=admin?password=hello";
string mydirver="com.mysql.jdbc.dirver";
connetion con;
Staement stmt;
String createString;
createString="create table COFFEES"+"("cof_name varchar(32)"+sup_to int,"+"price float
,sales int,total int");
try{
Class.forname(mydirver);
}catch(java.lang.classnotfoundexception e){
System.err.print("ClassNotFoundException:");
System.err.println.getmassage();
}
try{
con=driverManager.getConnect(myurl);
stmt=con.createSatement();
stmt.executeupdata(createstring);
stmt.close();
con.close();}
catch(sqlexception ex)
{System.err.println("sql Exception:"+ex.getmassage());}
}
}