1、40101 SET OLD_COLLATION_CONNECTION=COLLATION_CONNECTION */;40101 SET NAMES gbk */;40103 SET OLD_TIME_ZONE=TIME_ZONE */;40103 SET TIME_ZONE=+00:00 */;40014 SET OLD_UNIQUE_CHECKS=UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;40014 SET OLD_FOREIGN_KEY_CHECKS=FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;40101 SET OL
2、D_SQL_MODE=SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO40111 SET OLD_SQL_NOTES=SQL_NOTES, SQL_NOTES=0 */;- Table structure for table loginfoCREATE DATABASE IF NOT EXISTS st2;use st2;DROP TABLE IF EXISTS loginfo;40101 SET saved_cs_client = character_set_client */;40101 SET character_set_client = utf8 */;
3、CREATE TABLE loginfo ( id int(11) NOT NULL AUTO_INCREMENT, userid varchar(20) DEFAULT NULL, logintime datetime DEFAULT NULL, PRIMARY KEY (id) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;40101 SET character_set_client = saved_cs_client */;- Dumping data for table loginfoLOCK TABLES loginfo WRI
4、TE;40000 ALTER TABLE loginfo DISABLE KEYS */;INSERT INTO loginfo VALUES (1,200901,2013-11-15 07:31:35),(2,59);40000 ALTER TABLE loginfo ENABLE KEYS */;UNLOCK TABLES;- Table structure for table vip2.向vip 表中插入数据:DROP TABLE IF EXISTS vip;CREATE TABLE vip ( id int(100) NOT NULL AUTO_INCREMENT, name varc
5、har(50) , mail varchar(50), tel varchar(50),adds varchar(30), PRIMARY KEY (id) ENGINE=MyISAM AUTO_INCREMENT=12348 DEFAULT CHARSET=gbk;- Dumping data for table vipLOCK TABLES vip WRITE;40000 ALTER TABLE vip DISABLE KEYS */;INSERT INTO vip VALUES (01,wang123456hjkl),(02,li5468sdl),(03,zhao789haoba),(0
6、4,ge9565e),(05,dnf345ndv40000 ALTER TABLE vip ENABLE KEYS */;- Table structure for table user_tableDROP TABLE IF EXISTS user_table;CREATE TABLE user_table ( user_id int(11) NOT NULL AUTO_INCREMENT, user_name varchar(50) NOT NULL, user_pass varchar(50) NOT NULL, email varchar(100) DEFAULT NULL, PRIMA
7、RY KEY (user_id), UNIQUE KEY user_name (user_name) ENGINE=MyISAM AUTO_INCREMENT=200906 DEFAULT CHARSET=gbk;- Dumping data for table user_tableLOCK TABLES user_table WRITE;40000 ALTER TABLE user_table DISABLE KEYS */;INSERT INTO user_table VALUES (200901,abc1234yisjfds),(200902,cde),(200903,efg),(200
8、904,ghi147),(200905,ijk258),(3456,NULL);40000 ALTER TABLE user_table ENABLE KEYS */;40103 SET TIME_ZONE=OLD_TIME_ZONE */;40101 SET SQL_MODE=OLD_SQL_MODE */;40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */;40014 SET UNIQUE_CHECKS=OLD_UNIQUE_CHECKS */;40101 SET CHARACTER_SET_CLIENT=OLD_CHARACTER
9、_SET_CLIENT */;40101 SET CHARACTER_SET_RESULTS=OLD_CHARACTER_SET_RESULTS */;40101 SET COLLATION_CONNECTION=OLD_COLLATION_CONNECTION */;40111 SET SQL_NOTES=OLD_SQL_NOTES */;- Dump completed on 2013-12-10 14:03:28显示数据库文件列表;显示st2数据库文件下的表格;显示vip表格的所有属性及值;字段含义: id为vip代号不可重复;name为vip姓名;Mail为vip的电子邮件;tel为v
10、ip的电话;adds为vip的地址; 三. 功能图解:该项目是对教师表进行的操作,采用内嵌式窗体,实现了登录功能,查找表中的记录,组合查找,模糊查找,查看功能,插入新记录,修改记录,删除记录,保存新添加记录,保存全部,退出,清除功能等.其中还添加了另一个添加,删除,更新界面.下面分别介绍:1.登录界面:学号200901 登录密码12342.(已经设计好,直接点击登录按钮即可)点击退出按钮即可退出操作2.登录后,进入主菜单3.点击”查询所有记录”,弹出主窗体如图:4.点击”添加”,如图:5.点击主界面里面的显示单条记录,功能如图:6.实现另一个界面的修改功能进入修改界面:7.实现另一个界面的删除功能,进入界面8.直接删除和修改单条记录操作,进入界面
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1