db.sql

一个公司管理系统,用简单的htmlt要servlet做的,有增.查.改功能.适合同学学习交流.

create database tarena;

use tarena;

drop table users;


create table users (
userid int auto_increment primary key,
username varchar(50),
password varchar(50),
role varchar(20)
);


drop table company;

create table company (
id int auto_increment primary key,
name varchar(50),
city varchar(20),
address varchar(100),
scale varchar(10),
requiretech varchar(20),
kind varchar(2),
email varchar(70),
description varchar(255)
);