说明.txt

java+mysql开发的档案管理系统

开发环境：
jdk1.5
Eclipse 3.1
mysql-connector-java-3.2.0


数据库
mysql5.0
用户为root
密码为5740472

数据表如下及初始
create table user(
num int(20) not null auto_increment,
id varchar(20) not null,
name varchar(25) not null,
sex varchar(20) not null,
date varchar(20) not null,
address varchar(50) not null,
phone varchar(20),
home varchar(20),
wenhua varchar(20),
zhiwu varchar(20) not null,
part varchar(20) not null,
salary varchar(20),
password varchar(20),
primary key(num));

create table part(
id int(10) not null auto_increment,
name varchar(25) not null,
peple int(10),
primary key(id));


create table zhiwu(
id int(10) not null auto_increment,
zhiwu varchar(25) not null,
peple int(10),
primary key(id));

create table wenhua(
id int(10) not null auto_increment,
wenhua varchar(25) not null,
peple int(10),
primary key(id));

insert into user(id,name,sex,date,address,phone,home,wenhua,zhiwu,part,salary,password) values("1001","lieping","男","1985","西安","2185042","贵州","大学","员工","财政部","3000","2185042");

create table admin(
id int(10) not null auto_increment,
name varchar(30),
password varchar(30),
primary key(id));

insert into admin(name,password)values("lieping","2185042");