thinkphp 3.2 =》0625-6_登录业务与 验证码 =》登录页 与 验证码

来源:互联网 发布:pic单片机指令集 编辑:程序博客网 时间:2024/04/20 22:37

1.登录控制器  Application/Admin/Controller/ManagerController.class.php


<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 14-6-25
 * Time: 下午2:06
 */

namespace Admin\Controller;


use Think\Controller;
use Think\Verify;

class ManagerController extends  Controller{

    public function  login(){
        if(IS_POST){



            //>>验证码进行判断
            $verify = new Verify();
            if(!$verify->check(I('post.captcha'))){
                $this->error('登录失败,验证码错误!');
            }







            //>>1.执行登录操作
            $managerModel =  D('Manager');
            /*
             * 如果登录成功, 返回 当前用户的id
             * 如果失败.. 返回
             * -1  : 用户名错误
             * -2  : 密码错误
             */
            $result = $managerModel->login(I('post.username'),I('post.password'));
            if($result>0){ //登录成功
//                echo '登录成功的id'.$result;
                //登录成功后将 用户名对应的id和用户名放到session
                $loginInfo = array(
                    'id'=>$result,
                    'username'=>I('post.username')
                );
                 session('login_info',$loginInfo);

                $this->success('登录成功',U('Index/index'));

            }else{
                $errorInfo = '';
                if($result==-1){
                    $errorInfo = '用户名出错';
                }else if($result==-2){
                    $errorInfo = '密码出错';
                }
                $this->error('登录失败!'.$errorInfo,U('login'));//通过javascript实现.. back
            }

        }else{
            $this->display();
        }
    }


    public function logout(){
        session('login_info',null); //通过名字将一直从session中删除
        $this->redirect('Manager/login'); //U
    }

}


-------------------------------------------*****************-----------------------------------*********-------------------


1.2  验证码控制器   

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 14-6-25
 * Time: 下午3:24
 */

namespace Admin\Controller;


use Think\Controller;
use Think\Verify;

class VerifyController extends  Controller{

    public function  index(){
        $config = array(
            'useZh'     =>  false,
            'useImgBg'  =>  false,           // 使用背景图片
            'fontSize'  =>  25,              // 验证码字体大小(px)
            'useCurve'  =>  false,            // 是否画混淆曲线
            'useNoise'  =>  false,            // 是否添加杂点
            'imageH'    =>  0,               // 验证码图片高度
            'imageW'    =>  0,               // 验证码图片宽度
            'length'    =>  2,               // 验证码位数
        );
        //>>1.创建验证码类对象
        $verify =  new Verify($config);
        //>>2.生成验证码
        $verify->entry();
    }
}



----------------------************-------------------------******************-------------------

2.模型   pplication/Admin/Model/ManagerModel.class.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 14-6-25
 * Time: 下午2:19
 */

namespace Admin\Model;


use Think\Model;

class ManagerModel extends  Model{


    //该方法用来判断登录信息
    public function  login($username,$password){
           //>>1.根据用户名查询表中是否有对应的记录
          $manager = $this->getByMg_name($username);//select * from 表名  where mg_name = $username limit 1;
          if($manager){
              //>>2.比对密码
              if($manager['mg_pwd']==$password){
                  return $manager['mg_id'];
              }else{//密码错误
                    return -2;
              }
          }else{
             return -1; //用户名错误
          }

    }

}


------------------------****************-------------------*************----------------------


3.  视图 Application/Admin/View/Manager/login.html


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ECSHOP 管理中心</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="__CSS__/general.css" rel="stylesheet" type="text/css" />
<link href="__CSS__/main.css" rel="stylesheet" type="text/css" />
</head>
<body style="background: #278296;color:white">
<form method="post" action="{:U()}">
    <table cellspacing="0" cellpadding="0" style="margin-top:100px" align="center">
        <tr>
            <td>
                <img src="__IMG__/login.png" width="178" height="256" border="0" alt="ECSHOP" />
            </td>
            <td style="padding-left: 50px">
                <table>
                    <tr>
                        <td>管理员姓名:</td>
                        <td>
                            <input type="text" name="username" />
                        </td>
                    </tr>
                    <tr>
                        <td>管理员密码:</td>
                        <td>
                            <input type="password" name="password" />
                        </td>
                    </tr>
                    <tr>
                        <td>验证码:</td>
                        <td>
                            <input type="text" name="captcha" class="capital" />
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" align="right">
                            <img src="{:U('Verify/index')}" style="cursor: pointer" onclick="javascript:this.src='{:U('Verify/index')}?xxx='+Math.random()"/>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" align="center">
                            <input type="checkbox" value="1" name="remember" id="remember" />
                            <label for="remember">请保存我这次的登录信息。</label>
                        </td>
                    </tr>
                    <tr>
                        <td>&nbsp;</td>
                        <td>
                            <input type="submit" value="进入管理中心" class="button" />
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
  <input type="hidden" name="act" value="signin" />
</form>
</body>


----------**********-------------------------***********----------------

4.数据库   thinkphp0421.sql


/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50524
Source Host           : 127.0.0.1:3306
Source Database       : thinkphp0421

Target Server Type    : MYSQL
Target Server Version : 50524
File Encoding         : 65001

Date: 2014-06-25 18:27:17
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for beijing_user
-- ----------------------------
DROP TABLE IF EXISTS `beijing_user`;
CREATE TABLE `beijing_user` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of beijing_user
-- ----------------------------

-- ----------------------------
-- Table structure for itcast_c_user
-- ----------------------------
DROP TABLE IF EXISTS `itcast_c_user`;
CREATE TABLE `itcast_c_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `age` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of itcast_c_user
-- ----------------------------
INSERT INTO `itcast_c_user` VALUES ('1', '刘备', '27');
INSERT INTO `itcast_c_user` VALUES ('2', '关羽', '26');
INSERT INTO `itcast_c_user` VALUES ('3', '张飞', '25');
INSERT INTO `itcast_c_user` VALUES ('4', '赵云', '24');
INSERT INTO `itcast_c_user` VALUES ('5', '黄忠', '23');
INSERT INTO `itcast_c_user` VALUES ('6', '马超', '22');
INSERT INTO `itcast_c_user` VALUES ('7', '魏延', '21');
INSERT INTO `itcast_c_user` VALUES ('8', '1111', '111');

-- ----------------------------
-- Table structure for itcast_goods
-- ----------------------------
DROP TABLE IF EXISTS `itcast_goods`;
CREATE TABLE `itcast_goods` (
  `goods_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `goods_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '商品名称',
  `goods_sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  `goods_number` int(11) NOT NULL DEFAULT '100' COMMENT '数量',
  `goods_category_id` int(11) DEFAULT NULL,
  `goods_introduce` text COLLATE utf8_unicode_ci COMMENT '详细介绍',
  `goods_big_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '商品图片',
  `goods_small_img` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '商品小图',
  `goods_create_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `goods_last_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='商品表';

-- ----------------------------
-- Records of itcast_goods
-- ----------------------------
INSERT INTO `itcast_goods` VALUES ('3', '诺基亚666原装充ee电器1', null, '331.00', '1111', '0', '货品简介11111', '', '', '1241422082', '1376313495');
INSERT INTO `itcast_goods` VALUES ('4', '诺基亚N85原装充电器', null, '111.00', '222', '8', '货品简介', '', '', '1241422402', '0');
INSERT INTO `itcast_goods` VALUES ('6', '胜创KIN33GMAX', null, '42.00', '15', '0', '货品简介', '', '', '1241422573', '1376313927');
INSERT INTO `itcast_goods` VALUES ('7', '诺基亚N85原装立体声耳机HS-82', null, '100.00', '20', '0', '货品简介', '', '', '1241422785', '1376309276');
INSERT INTO `itcast_goods` VALUES ('8', '飞利浦6@6v', null, '1200.00', '55', '3', '货品简介', '', '', '1241425512', '0');
INSERT INTO `itcast_goods` VALUES ('9', '诺基亚E33', null, '5000.00', '4', '3', '货品简介', '', '', '1241511871', '0');
INSERT INTO `itcast_goods` VALUES ('10', '索爱C706', null, '1500.00', '7', '3', '货品简介', '', '', '1241965622', '0');
INSERT INTO `itcast_goods` VALUES ('11', '索爱C702c', null, '1300.00', '1', '3', '货品简介', '', '', '1241966951', '0');
INSERT INTO `itcast_goods` VALUES ('12', '摩托罗拉A810', null, '983.00', '8', '3', '货品简介', '', '', '1245297652', '0');
INSERT INTO `itcast_goods` VALUES ('13', '诺基亚5320 XpressMusic', null, '1311.00', '8', '4', '货品简介', '', '', '1241967762', '0');
INSERT INTO `itcast_goods` VALUES ('14', '诺基亚5800XM', null, '2625.00', '1', '3', '货品简介', '', '', '1241968492', '0');
INSERT INTO `itcast_goods` VALUES ('15', '摩托罗拉A810', null, '788.00', '3', '2', '货品简介', '', '', '1241968703', '0');
INSERT INTO `itcast_goods` VALUES ('16', '恒基伟业G101', null, '823.33', '0', '3', '货品简介', '', '', '1241968949', '0');
INSERT INTO `itcast_goods` VALUES ('17', '夏新N7', null, '2300.00', '1', '4', '货品简介', '', '', '1241969394', '0');
INSERT INTO `itcast_goods` VALUES ('18', '夏新T5', null, '2878.00', '1', '3', '货品简介', '', '', '1241969533', '0');
INSERT INTO `itcast_goods` VALUES ('19', '三星SGH-F258', null, '858.00', '12', '3', '货品简介', '', '', '1241970139', '0');
INSERT INTO `itcast_goods` VALUES ('20', '三星BC01', null, '280.00', '12', '3', '货品简介', '', '', '1241970417', '0');
INSERT INTO `itcast_goods` VALUES ('21', '金立 A30', null, '2000.00', '40', '3', '货品简介', '', '', '1241970634', '0');
INSERT INTO `itcast_goods` VALUES ('22', '多普达Touch HD', null, '5999.00', '1', '5', '货品简介', '', '', '1241971076', '0');
INSERT INTO `itcast_goods` VALUES ('23', '诺基亚N97', null, '4000.00', '8', '3', '货品简介', '', '', '1241971488', '1376313982');
INSERT INTO `itcast_goods` VALUES ('24', 'P807', null, '2000.00', '100', '13', '货品简介', '', '', '1241971981', '0');
INSERT INTO `itcast_goods` VALUES ('25', '小灵通/固话50元充值卡', null, '48.00', '2', '13', '货品简介', '', '', '1241972709', '0');
INSERT INTO `itcast_goods` VALUES ('26', '小灵通/固话20元充值卡', null, '19.00', '2', '0', '货品简介', '', '', '1241972789', '0');
INSERT INTO `itcast_goods` VALUES ('27', '联通100元充值卡', null, '95.00', '2', '15', '货品简介', '', '', '1241972894', '1376309295');
INSERT INTO `itcast_goods` VALUES ('28', '联通50元充值卡', null, '45.00', '0', '14', '货品简介', '', '', '1241972976', '0');
INSERT INTO `itcast_goods` VALUES ('29', '移动100元充值卡', null, '90.00', '0', '14', '货品简介', '', '', '1241973022', '0');
INSERT INTO `itcast_goods` VALUES ('30', '移动20元充值卡', null, '18.00', '9', '3', '货品简介', '', '', '1241973114', '0');
INSERT INTO `itcast_goods` VALUES ('31', '摩托罗拉E8 ', null, '1337.00', '1', '0', '货品简介', '', '', '1242110412', '0');
INSERT INTO `itcast_goods` VALUES ('32', 'htc_one', null, '3999.00', '25', '23', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('33', 'htc_s', null, '3456.00', '12', '23', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('34', 'htc_ss', null, '3456.00', '12', '0', '货品简介', '', '', '1370660527', '0');
INSERT INTO `itcast_goods` VALUES ('35', 'apple5s', null, '5999.00', '34', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('36', 'LV包', null, '12000.00', '13', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('37', '三星耳机', null, '109.00', '59', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('39', 'HTC_one', null, '3555.00', '100', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('41', '三星耳机', null, '109.00', '59', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('44', '南孚34电池', null, '50.00', '59', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('45', '波导手机333', null, '1200.00', '40', '4', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('47', 'haier999', null, '3210.00', '101', '0', '货品简介', '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('56', '新货品1新货品1', null, '100.00', '20', null, null, '', '', '1403514677', '1403514677');
INSERT INTO `itcast_goods` VALUES ('57', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('58', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('59', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('60', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('61', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('62', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('63', '新货品1', null, '1001.00', '501', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('64', '新货品', null, '100.00', '50', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('65', '新货品', null, '100.00', '50', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('66', '新货品', null, '100.00', '50', null, null, '', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('70', '123', '123123132', '12313.00', '222', null, 'asdfsdf', '/Uploads/Pictrue/2014-06-25/53aa8fc4a5978.jpg', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('71', '', '', '0.00', '0', null, '222', '/Uploads/Pictrue/2014-06-25/53aa972e47103.jpg', 'Uploads/Pictrue/2014-06-25/53aa972e47103.jpg', '0', '0');
INSERT INTO `itcast_goods` VALUES ('72', '234', '234', '0.00', '0', null, '', '/Uploads/Pictrue/2014-06-25/53aa974fb8eeb.jpg', '/Uploads/Pictrue/2014-06-25/small_53aa974fb8eeb.jpg', '0', '0');

-- ----------------------------
-- Table structure for itcast_log
-- ----------------------------
DROP TABLE IF EXISTS `itcast_log`;
CREATE TABLE `itcast_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(10) DEFAULT NULL,
  `controller` varchar(20) DEFAULT NULL,
  `action` varchar(20) DEFAULT NULL,
  `user` varchar(10) DEFAULT NULL,
  `operate_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1604 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of itcast_log
-- ----------------------------
INSERT INTO `itcast_log` VALUES ('1572', 'Admin', 'Goods', 'index', null, '1403691244');
INSERT INTO `itcast_log` VALUES ('1573', 'Admin', 'Goods', 'add', null, '1403691261');
INSERT INTO `itcast_log` VALUES ('1574', 'Admin', 'Manager', 'index', null, '1403691278');
INSERT INTO `itcast_log` VALUES ('1575', 'Admin', 'Manager', 'login', null, '1403691298');
INSERT INTO `itcast_log` VALUES ('1576', 'Admin', 'Verify', 'index', null, '1403691299');
INSERT INTO `itcast_log` VALUES ('1577', 'Admin', 'Manager', 'login', '127.0.0.1', '1403691471');
INSERT INTO `itcast_log` VALUES ('1578', 'Admin', 'Verify', 'index', '127.0.0.1', '1403691471');
INSERT INTO `itcast_log` VALUES ('1579', 'Admin', 'Manager', 'login', '127.0.0.1', '1403691486');
INSERT INTO `itcast_log` VALUES ('1580', 'Admin', 'Index', 'index', '127.0.0.1', '1403691487');
INSERT INTO `itcast_log` VALUES ('1581', 'Admin', 'Index', 'menu', '127.0.0.1', '1403691487');
INSERT INTO `itcast_log` VALUES ('1582', 'Admin', 'Index', 'top', '127.0.0.1', '1403691487');
INSERT INTO `itcast_log` VALUES ('1583', 'Admin', 'Index', 'main', '127.0.0.1', '1403691487');
INSERT INTO `itcast_log` VALUES ('1584', 'Admin', 'Index', 'Js', '127.0.0.1', '1403691488');
INSERT INTO `itcast_log` VALUES ('1585', 'Admin', 'Index', 'Js', '127.0.0.1', '1403691488');
INSERT INTO `itcast_log` VALUES ('1586', 'Admin', 'Index', 'Js', '127.0.0.1', '1403691488');
INSERT INTO `itcast_log` VALUES ('1587', 'Admin', 'Index', 'index', '127.0.0.1', '1403691497');
INSERT INTO `itcast_log` VALUES ('1588', 'Admin', 'Index', 'menu', '127.0.0.1', '1403691497');
INSERT INTO `itcast_log` VALUES ('1589', 'Admin', 'Index', 'main', '127.0.0.1', '1403691497');
INSERT INTO `itcast_log` VALUES ('1590', 'Admin', 'Index', 'top', '127.0.0.1', '1403691497');
INSERT INTO `itcast_log` VALUES ('1591', 'Admin', 'Index', 'Js', '127.0.0.1', '1403691498');
INSERT INTO `itcast_log` VALUES ('1592', 'Admin', 'Index', 'Js', '127.0.0.1', '1403691498');
INSERT INTO `itcast_log` VALUES ('1593', 'Admin', 'Index', 'Js', '127.0.0.1', '1403691498');
INSERT INTO `itcast_log` VALUES ('1594', 'Admin', 'Index', 'index', '127.0.0.1', '1403691595');
INSERT INTO `itcast_log` VALUES ('1595', 'Admin', 'Index', 'menu', '127.0.0.1', '1403691595');
INSERT INTO `itcast_log` VALUES ('1596', 'Admin', 'Index', 'top', '127.0.0.1', '1403691595');
INSERT INTO `itcast_log` VALUES ('1597', 'Admin', 'Index', 'main', '127.0.0.1', '1403691595');
INSERT INTO `itcast_log` VALUES ('1598', 'Admin', 'Index', 'index', '127.0.0.1', '1403691603');
INSERT INTO `itcast_log` VALUES ('1599', 'Admin', 'Index', 'menu', '127.0.0.1', '1403691603');
INSERT INTO `itcast_log` VALUES ('1600', 'Admin', 'Index', 'top', '127.0.0.1', '1403691603');
INSERT INTO `itcast_log` VALUES ('1601', 'Admin', 'Index', 'main', '127.0.0.1', '1403691603');
INSERT INTO `itcast_log` VALUES ('1602', 'Admin', 'Index', 'index', '127.0.0.1', '1403691656');
INSERT INTO `itcast_log` VALUES ('1603', 'Admin', 'Goods', 'add', 'admin', '1403691699');

-- ----------------------------
-- Table structure for itcast_manager
-- ----------------------------
DROP TABLE IF EXISTS `itcast_manager`;
CREATE TABLE `itcast_manager` (
  `mg_id` int(11) NOT NULL AUTO_INCREMENT,
  `mg_name` varchar(32) NOT NULL,
  `mg_pwd` varchar(32) NOT NULL,
  `mg_time` int(10) unsigned NOT NULL COMMENT '时间',
  `mg_role_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
  PRIMARY KEY (`mg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of itcast_manager
-- ----------------------------
INSERT INTO `itcast_manager` VALUES ('1', 'admin', '123456', '0', '0');
INSERT INTO `itcast_manager` VALUES ('2', 'tom', '123456', '0', '1');
INSERT INTO `itcast_manager` VALUES ('3', 'linken', '123456', '0', '2');
INSERT INTO `itcast_manager` VALUES ('4', 'mary', '123456', '1387785044', '2');
INSERT INTO `itcast_manager` VALUES ('5', 'yuehan', '123456', '1387785056', '1');

-- ----------------------------
-- Table structure for itcast_user
-- ----------------------------
DROP TABLE IF EXISTS `itcast_user`;
CREATE TABLE `itcast_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `username` varchar(128) NOT NULL DEFAULT '' COMMENT '登录名',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码',
  `user_email` varchar(64) NOT NULL DEFAULT '' COMMENT '邮箱',
  `user_sex` tinyint(4) NOT NULL DEFAULT '1' COMMENT '性别',
  `user_qq` varchar(32) NOT NULL DEFAULT '' COMMENT 'qq',
  `user_tel` varchar(32) NOT NULL DEFAULT '' COMMENT '手机',
  `user_xueli` tinyint(4) NOT NULL DEFAULT '1' COMMENT '学历',
  `user_hobby` varchar(32) NOT NULL DEFAULT '' COMMENT '爱好',
  `user_introduce` text COMMENT '简介',
  `user_time` int(11) DEFAULT NULL,
  `last_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
-- Records of itcast_user
-- ----------------------------
INSERT INTO `itcast_user` VALUES ('1', 'zhangsanff', '1234', 'zhangsan@163.com', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('3', 'jack', 'jack', 'tom@163.com', '1', '', '', '1', '', null, null, '0');
INSERT INTO `itcast_user` VALUES ('98', 'linken', 'abcd', 'lin@q.com', '1', '78347832', '13245671234', '4', '', 'I am linken', null, '0');
INSERT INTO `itcast_user` VALUES ('100', 'tom', 'tom', 'tom@q.com', '3', '263872', '13465432345', '5', '1,3', 'I am tom', null, '0');
INSERT INTO `itcast_user` VALUES ('113', '', '1234', '', '1', '', '13425364536', '5', '1,4', 'I am aobama', null, '0');
INSERT INTO `itcast_user` VALUES ('114', 'xiaoming', 'ming', 'ming@m.com', '1', '9273982', '1349874834', '4', '1,3,4', 'I am xiaoming', null, '0');
INSERT INTO `itcast_user` VALUES ('115', 'xiaoqiang', 'qiang', 'qiang@q.com', '1', '92382738', '13425364536', '4', '1,3,4', 'qiang', '1385107783', '0');
INSERT INTO `itcast_user` VALUES ('116', 'xiaomingg', '1234', 'q@q.com', '1', '92382738', '13425364536', '3', '1,2,3', 'sdfs', '92382738', '0');
INSERT INTO `itcast_user` VALUES ('117', 'tom', '1234', 'tom@q.com', '1', '297398273', '13245673214', '5', '', 'I am tom', null, '0');
INSERT INTO `itcast_user` VALUES ('118', 'slkjdlks', 'lsjdksjd', '', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('119', 'linken', '1234', '', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('120', 'zhangsan', '123', 'zhangsan@qq.com', '1', '2398273', '329492843', '5', '', 'I am zhangsan', null, '0');
INSERT INTO `itcast_user` VALUES ('121', 'xiaoli', 'abc', 'xiaoli@q.com', '1', '24234', '24323432', '4', '2,3,4', 'i am xiaoli', null, '0');
INSERT INTO `itcast_user` VALUES ('122', 'aaa', '123', 'aaa@q.com', '1', '344444', '13248457', '4', '1,2,3', 'sfddsf', null, '0');
INSERT INTO `itcast_user` VALUES ('124', 'xiaoming', '1234', 'xiaoming@q.com', '3', '2973982', '23982789', '4', '1,3,4', 'I am xiaoming', null, '0');
INSERT INTO `itcast_user` VALUES ('125', 'daxiong', '900150983cd24fb0d6963f7d28e17f72', 'daxiong@q.com', '3', '9273982', '23927392', '5', '1,2,4', 'I am daxiong', null, '0');
INSERT INTO `itcast_user` VALUES ('126', 'xiaoli', 'caf1a3dfb505ffed0d024130f58c5cfa', 'xiaoli@q.com', '2', '234253', '2423432', '5', '1,3', 'I am xiaoli', '1387702517', '0');
INSERT INTO `itcast_user` VALUES ('127', 'qqqq', 'b59c67bf196a4758191e42f76670ceba', '', '1', '', '2332434', '4', '1,2', 'sdfsfs', '1387702814', '0');
INSERT INTO `itcast_user` VALUES ('128', 'tttt', '310dcbbf4cce62f762a2aaa148d556bd', 'ttt@q.com', '1', '2342543', '2432342', '3', '1,2,3', 'sdfsf', '1387703022', '0');
INSERT INTO `itcast_user` VALUES ('130', 'qqq', 'www', '', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('131', 'www', 'qqq', '', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('132', '', 'eeee', '', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('133', '123', '202cb962ac59075b964b07152d234b70', '123', '1', '123', '123', '2', '1,2,3', '123123', '1403066372', '1403066372');
INSERT INTO `itcast_user` VALUES ('134', 'qwe', '76d80224611fc919a5d54f0ff9fba446', 'qwe', '1', '123', '123', '4', '1,2', '123123', '1403066457', '1403066457');
INSERT INTO `itcast_user` VALUES ('135', 'asdfasdfadf', '12ef16e0d2c395d10cb4ded21aa1a799', 'asdfasdfadf', '1', '123', '123', '3', '1,2,3', '', '1403066538', '1403066538');
INSERT INTO `itcast_user` VALUES ('136', 'asdfasdfadf', 'd41d8cd98f00b204e9800998ecf8427e', 'asdfasdfadf', '1', '123', '123', '3', '1,2,3,4', '', '1403066609', '1403066609');
INSERT INTO `itcast_user` VALUES ('137', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@itcast.com', '1', '123123123', '123123123', '3', '1,2,3,4', 'asdfadfasdf', '1403078160', '1403078160');
INSERT INTO `itcast_user` VALUES ('138', 'adsf', 'adfasd', 'adf', '1', 'asss', 'sdfsdf', '1', '', 'adsfasdf', null, '0');
INSERT INTO `itcast_user` VALUES ('139', '张三张三', 'f6fdffe48c908deb0f4c3bd36c032e72', '', '1', '', '', '1', '1,2,3', '3333', '1403665821', '0');

---------------------------*************-----------------------*************----------------------


0 0