example.test2.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of j2mvc-framework-app Show documentation

强烈建议使用J2mvc 2.1以后的版本。 version 2.1.01 1.更换JSON依赖包. version 2.1.02 1.移除com.j2mvc.StringUtils.getUtf8()方法调用. 更改为getCharset() version 2.1.03 1.更新JNDI连接设置 version 2.1.04 1.修改works.xml配置url-pkg-prefixes改为pkg

There is a newer version: 2.1.12

Show newest version

-- 测试系统数据库
drop database test2;
create database test2;
grant all privileges on test2.* to test2@localhost identified by 'test2@123' WITH GRANT OPTION;
flush privileges;
use test2;

-- 用户
DROP TABLE IF EXISTS carts;
CREATE TABLE IF NOT EXISTS carts(
	id					varchar(30)	NOT NULL,
	name				varchar(50)	NOT NULL COMMENT '名称',			
	price				double(10,2)	NOT NULL COMMENT '价格',			
  	PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;