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" "/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="/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" οnclick="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> </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: -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/-06-25/53aa8fc4a5978.jpg', '', '0', '0');
INSERT INTO `itcast_goods` VALUES ('71', '', '', '0.00', '0', null, '222', '/Uploads/Pictrue/-06-25/53aa972e47103.jpg', 'Uploads/Pictrue/-06-25/53aa972e47103.jpg', '0', '0');
INSERT INTO `itcast_goods` VALUES ('72', '234', '234', '0.00', '0', null, '', '/Uploads/Pictrue/-06-25/53aa974fb8eeb.jpg', '/Uploads/Pictrue/-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@', '1', '', '', '1', '', '', null, '0');
INSERT INTO `itcast_user` VALUES ('3', 'jack', 'jack', 'tom@', '1', '', '', '1', '', null, null, '0');
INSERT INTO `itcast_user` VALUES ('98', 'linken', 'abcd', 'lin@', '1', '78347832', '13245671234', '4', '', 'I am linken', null, '0');
INSERT INTO `itcast_user` VALUES ('100', 'tom', 'tom', 'tom@', '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@', '1', '9273982', '1349874834', '4', '1,3,4', 'I am xiaoming', null, '0');
INSERT INTO `itcast_user` VALUES ('115', 'xiaoqiang', 'qiang', 'qiang@', '1', '92382738', '13425364536', '4', '1,3,4', 'qiang', '1385107783', '0');
INSERT INTO `itcast_user` VALUES ('116', 'xiaomingg', '1234', 'q@', '1', '92382738', '13425364536', '3', '1,2,3', 'sdfs', '92382738', '0');
INSERT INTO `itcast_user` VALUES ('117', 'tom', '1234', 'tom@', '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@', '1', '2398273', '329492843', '5', '', 'I am zhangsan', null, '0');
INSERT INTO `itcast_user` VALUES ('121', 'xiaoli', 'abc', 'xiaoli@', '1', '24234', '24323432', '4', '2,3,4', 'i am xiaoli', null, '0');
INSERT INTO `itcast_user` VALUES ('122', 'aaa', '123', 'aaa@', '1', '344444', '13248457', '4', '1,2,3', 'sfddsf', null, '0');
INSERT INTO `itcast_user` VALUES ('124', 'xiaoming', '1234', 'xiaoming@', '3', '2973982', '23982789', '4', '1,3,4', 'I am xiaoming', null, '0');
INSERT INTO `itcast_user` VALUES ('125', 'daxiong', '900150983cd24fb0d6963f7d28e17f72', 'daxiong@', '3', '9273982', '23927392', '5', '1,2,4', 'I am daxiong', null, '0');
INSERT INTO `itcast_user` VALUES ('126', 'xiaoli', 'caf1a3dfb505ffed0d024130f58c5cfa', 'xiaoli@', '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@', '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@', '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');
---------------------------*************-----------------------*************----------------------