乱写乱记

 

String sql="create table member(userName char(12) primary key,password char(6) not null," +
                "email char(30),phone char(11))";
        String sql1="create table memberInfo(userName char(12) primary key,registerTime char(20)," +
                "preLogin char(20),loginNum int,grandConsume int,credits int,state char(1),status char(1))";

5        create table order(orderId char(14) primary key,userName char(12),shippingAddress char(100),totalPrice int,payment char(20),logistics char(20),oddNum char(20),state char(1))