基于高德导航的Android大作业校园助手App开发(源码+数据库+演示视频).rar

-- phpMyAdmin SQL Dump -- version phpStudy 2014 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2020 年 12 月 27 日 11:31 -- 服务器版本: 5.5.36 -- PHP 版本: 5.3.28 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `rider` -- -- -------------------------------------------------------- -- -- 表的结构 `record` -- CREATE TABLE IF NOT EXISTS `record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `lat_list` text NOT NULL, `lon_list` text NOT NULL, `date` text NOT NULL, `duration` text NOT NULL, `distance` text NOT NULL, `cal` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ; -- -- 转存表中的数据 `record` -- INSERT INTO `record` (`id`, `username`, `lat_list`, `lon_list`, `date`, `duration`, `distance`, `cal`) VALUES (33, 'aa', '34.19756;34.197666;34.195987;34.19559;34.19665;34.19625;34.19581;34.196491;34.194482;34.19454;34.19373908095777;', '108.86557;108.865034;108.866503;108.8643;108.86456;108.86501;108.86408;108.864151;108.865111;108.86837;108.87541864208818;', '2020-04-26 12:30:46', '0:0:13', '2.065公里', '56.17卡'); -- -------------------------------------------------------- -- -- 表的结构 `topic` -- CREATE TABLE IF NOT EXISTS `topic` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` text NOT NULL, `title` varchar(255) NOT NULL, `message` text NOT NULL, `date` text NOT NULL, `author` text NOT NULL, `img` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; -- -- 转存表中的数据 `topic` -- INSERT INTO `topic` (`id`, `content`, `title`, `message`, `date`, `author`, `img`) VALUES (47, '呜呜呜', '蓝瘦香菇', 'cc#不哭不哭#2020-04-10;cc#哈哈#2020-04-10;cc#回复 cc：有啥想开不开#2020-04-10;cc#不要哭#2020-04-10;cc#不可不不#2020-04-10;', '2020-4-10', 'cc', '5e8fc67985c31.jpg'), (48, '123', '123', 'aa#123456#2020-06-27;', '123', 'aa', 'uploaded/1587814155686food3.jpg'), (49, '骑车真不错', '今天天气不错，很适合骑车', '', '2020-4-26', 'bb', 'uploaded\\1587831228365food2.jpg'); -- -------------------------------------------------------- -- -- 表的结构 `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text CHARACTER SET utf8 NOT NULL, `password` text CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `user` -- INSERT INTO `user` (`id`, `name`, `password`) VALUES (1, '123', '123'), (2, '123', '123'), (3, 'aa', '123'), (4, 'bb', '123'), (6, 'cc', '123'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;