数据库列表创建于上传

dev.mysql.com/downloads/   5.6.17 MySql

CREATE DATABASE  students;(name of table);
USE students;
CREATE TABLE  classes(
    prefix     varchar(4)  not null,
    classesID  int(11)     primary key);                           prefix    classID :two columns
     
    
    INSERT INTO classes       (prefix,classesID)
       VALUES('csci',120);   
    INSERT INTO classes VALUES('CSCI',320) ;
  
    SELECT FROM classes where classesID=120;
    SELECT FROM classes where prefix='csci';

    DELETE classes where classesID=320;   // be careful to use delete statement
   
    DROP TABLE classes;   // table is gone
    
    DROP DATABASE students; //difference?
  
   //execute( "INSERT INTO user values('" + name + "');"  );


F:\>cd F:\mysql-5.5.37-win32\bin

F:\mysql-5.5.37-win32\bin>javac JDBCTest.java

F:\mysql-5.5.37-win32\bin>java -classpath .;mysql-connector-java-5.1.30-bin.jar