Java 36---短消息项目总结

2022-11-30 15:06:56

导读

1.项目功能及相应能力
2.项目框架
3.数据库
4.项目流程
5.源码链接
6.项目优化

项目功能及相应能力

项目框架

AJAX框架

数据库

CREATE TABLE user(
	id INT(7) auto_increment,
	username VARCHAR(20),
	password VARCHAR(20) 
			CONSTRAINT user_password_nn NOT NULL,
	email VARCHAR(50)
			CONSTRAINT user_email_nn NOT NULL,

	CONSTRAINT user_id_pk PRIMARY KEY(id),
	CONSTRAINT user_username_un UNIQUE(username)
);

CREATE TABLE mes(
	id INT(7) auto_increment,
	sendid INT(7) CONSTRAINT mes_sendid_nn NOT NULL,
	title VARCHAR(40) NOT NULL,
	msgcontent VARCHAR(400) NOT NULL,
	state INT(1) NOT NULL,
	receiveid INT(7) NOT NULL,
	msg_date VARCHAR(40) NOT NULL,


	CONSTRAINT mes_id_pk PRIMARY KEY(id),
	CONSTRAINT mes_send_fk FOREIGN KEY(sendid) REFERENCES user(id),
	CONSTRAINT mes_receive_fk FOREIGN KEY(receiveid) REFERENCES user(id)
);