建库：test
建表：
复制代码 代码如下:
/*
navicat mysql data transfer
source server : localhost
source server version : 50520
source host : localhost:3306
source database : mo
target server type : mysql
target server version : 50520
file encoding : 65001
date: 2013-10-17 12:00:56
*/
-- ----------------------------
-- table structure for [user]
-- ----------------------------
use test
go
drop table [user];
create table [user] (
id bigint not null primary key identity(1000, 1),
create_date datetime default null,
edit_date datetime default null,
is_delete int default null,
[name] varchar(255) default null,
sex varchar(255) default null,
age int default null
);
-- ----------------------------
-- records of user
-- ----------------------------
insert into [user] values ('2013-04-02 16:01:00', '2013-04-02 16:01:17', '0', 'oppo', '男', '20');
insert into [user] values ('2013-04-02 16:01:02', '2013-04-02 16:01:17', '0', 'mini', '女', '18');
insert into [user] values ('2013-04-02 16:01:04', '2013-04-02 16:01:17', '0', 'kina', '女', '18');
insert into [user] values ('2013-04-02 16:01:06', '2013-04-02 16:01:17', '0', 'lora', '男', '19');
insert into [user] values ('2013-04-02 16:01:08', '2013-04-02 16:01:17', '0', '榕sir', '女', '18');
insert into [user] values ('2013-04-02 16:01:10', '2013-04-02 16:01:17', '0', '兼容', '女', '19');
insert into [user] values ('2013-04-02 16:01:13', '2013-04-02 16:01:17', '0', 'sir云', '男', '18');
insert into [user] values ('2013-04-02 16:01:17', '2013-04-02 16:01:17', '0', '明白了', '男', '18');
insert into [user] values ('2013-04-02 16:37:00', '2013-04-02 16:37:00', '0', 'guro go sir', '女', '19');
二、在页面js代码操作数据库
复制代码 代码如下:
js操作数据库