主要功能有: 费用管理 所有费用 增加收入 增加支出 费用类型 报销人 费用统计 用户管理 增加用户 登陆信息 后台登录页面: login.jsp 用户:a

源代码在线查看: caiwu.sql

软件大小: 332 K
上传用户: tanghui2008
关键词: login 用户 jsp 后台
下载地址: 免注册下载 普通下载 VIP

相关代码

				# Dump for Database caiwu

				

				CREATE DATABASE caiwu;

				

				# Dumping Table class

				#

				CREATE TABLE class (

					id int(4) NOT NULL  auto_increment, 

					name varchar(20) NOT NULL   ,

					PRIMARY KEY (id),

					KEY name (name)	
				);

				

				# Dumping Data - 1 rows

				

				INSERT INTO class VALUES(1,"财务处");

				

				# Dumping Table master

				#

				CREATE TABLE master (

					id int(4) NOT NULL  auto_increment, 

					name varchar(20) NOT NULL  , 

					truename varchar(20) NOT NULL  , 

					pass varchar(20) NOT NULL  , 

					joindate varchar(10) NOT NULL  , 

					classid int(4) NOT NULL  , 

					loginnum int(10) NOT NULL  , 

					ipaddress varchar(20) NOT NULL   ,

					PRIMARY KEY (id)	
				);

				

				# Dumping Data - 1 rows

				

				INSERT INTO master VALUES(1,"admin","总管理员","admin","2003-03-08",0,143,"172.18.88.218");

				

				# Dumping Table pay

				#

				CREATE TABLE pay (

					id int(11) NOT NULL  auto_increment, 

					classid int(11)   , 

					payerid int(11) NOT NULL  , 

					paytypeid int(11) NOT NULL  , 

					money int(40) NOT NULL  , 

					project varchar(40)   , 

					message varchar(40)   , 

					addtime date NOT NULL  , 

					inout int(1) NOT NULL   ,

					PRIMARY KEY (id)	
				);

				

				# Dumping Data - 0 rows

				

				

				# Dumping Table payer

				#

				CREATE TABLE payer (

					id int(11) NOT NULL  auto_increment, 

					name varchar(20) NOT NULL   ,

					PRIMARY KEY (id),

					KEY name (name)	
				);

				

				# Dumping Data - 0 rows

				

				

				# Dumping Table paytype

				#

				CREATE TABLE paytype (

					id int(10) NOT NULL  auto_increment, 

					name varchar(20) NOT NULL  , 

					inout int(1) NOT NULL   ,

					PRIMARY KEY (id),

					KEY name (name)	
				);

				

				# Dumping Data - 0 rows

				

				

				# Dumping Table userlog

				#

				CREATE TABLE userlog (

					id int(11) NOT NULL  auto_increment, 

					user varchar(20) NOT NULL  , 

					logindate datetime NOT NULL  , 

					logoutdate datetime NOT NULL  , 

					ip varchar(20) NOT NULL   ,

					PRIMARY KEY (id)	
				);

				

				

							

相关资源