?? 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());}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -