数据的JDBC连接和使用方法.txt

--资费信息表
create table cost(
   cost_id int(4) auto_increment primary key,
   cname  varchar(50)  not null,
   base_duration    int(11),
   base_cost DOUBLE(7,2),
   unit_cost DOUBLE(7,4),
   cstatus  char(1),
   descr  varchar(100),
   creatime date  ,
   startime  date,
cost_type char(1)
  );
--帐务信息表
create table account(
  account_id int(9)  primary key auto_increment,
  recommender_id int(9),
  login_name varchar(30)  not null,
  login_passwd varchar(30) not null,
  status char(1),
  create_date date,
  pause_date date,
  close_date date,
  real_name varchar(20) not null,
  idcard_no char(18) not null,
  birthdate date,
  gender     char(1),
  occupation varchar(50),
  telephone varchar(15) not null,
  email varchar(50),