Name	Name	Last commit message	Last commit date
Latest commit History 62 Commits
src	src
.gitignore	.gitignore
LICENSE	LICENSE
README.md	README.md
SqlFaker.iml	SqlFaker.iml
data.sql	data.sql
pom.xml	pom.xml

SqlFaker

Qing Liang Ji , Yi Tuo Zhan De Shu Ju Ku Zhi Neng Tian Chong JavaKai Yuan Ku

Jian Jie

SqlFakerShi Yi Ge JavaKai Fa De Ke Kuai Su Wei Shu Ju Ku Sheng Cheng Da Liang Fang Zhen De Gong Ju ,Jin Xu Jian Dan De Pei Zhi ,Ji Ke Wei Shu Ju Ku Biao Pi Liang Cha Ru You Gui Lu De Lei Si Zhen Shi Shu Ju De Nei Rong ,Ke Yong Yu Shu Ju Ku Diao You Deng Cao Zuo .

Xiang Xi Wen Dang Shuo Ming

GitBook:https://lkmc2.github.io/SqlFakerGitPage

Kai Yuan Ku Te Xing

Zhi Chi Zhu Liu De MySQL, Oracle, SQL Server, Sqlite, H2Deng Shu Ju Ku
Zhi Chi 8Chong Chang Jian Shu Ju Ku Zi Duan Lei Xing De Zhi Neng Tian Chong ,Bing Zhi Chi Zi Ding Yi Tuo Zhan
Zhi Chi Yi Ci Xing Cha Ru Yi Mo Ji Bie De Shu Ju
Zhi Chi JDK1.6Ji Yi Shang Ban Ben
Zhi Chi Shi Wu

Shi Yong Shi Fan

// Chuang Jian Shu Ju Ku Lian Jie DBTools.url("jdbc:mysql://localhost:3306/facker") .username("root") .password("123456") .connect(); // Gei userBiao De Si Ge Zi Duan Tian Chong 5Tiao Shu Ju Faker.tableName("user") .param("name", DataType.USERNAME) .param("age", DataType.AGE) .param("sex", DataType.SEX) .param("birthday", DataType.TIME) .insertCount(5) .execute();

Shang Shu Dai Ma Jiang Sheng Cheng Ru Xia SQLYu Ju ,Bing Zai Shu Ju Ku Zhong Zhi Xing :

insert into user(name,age,sex,address,birthday) values('Wu Tan Shuang ',21,'Shan Xi Sheng Jin Cheng Shi Ze Zhou Xian Qing Da Lu 463Hao ','2018-02-24 10:56:37') insert into user(name,age,sex,address,birthday) values('Gu Shi Ke ',50,'Yan Xi Zhuang Zu Zi Zhi Qu Liu Zhou Shi Rong Shui Miao Zu Zi Zhi Xian De Bao Lu 419Hao ','2018-04-09 08:10:22') insert into user(name,age,sex,address,birthday) values('Cai Jing Sui ',46,'He Nan Sheng Zheng Zhou Shi Gong Yi Shi Yan Yan Lu 240Hao ','2018-06-11 23:02:19') insert into user(name,age,sex,address,birthday) values('Wei Wan Chi ',27,'He Nan Sheng Jiao Zuo Shi Bo Ai Xian Pu Run Lu 148Hao ','2018-02-22 15:52:50') insert into user(name,age,sex,address,birthday) values('Ren Xu ',54,'He Nan Sheng Xin Xiang Shi Yan Jin Xian Yi Yuan Lu 14Hao ','2018-07-07 03:48:51')

Geng Xin Ri Zhi

v1.0.6:Tian Jia Dui ListLei Xing De Dong Tai Can Shu Zhi Chi .
v1.0.5:Zhi Chi Yi Ci Xing Cha Ru Yi Mo Ji Bie De Shu Ju .
v1.0.4:Tian Jia Zhen Dui Oracle, Sqlite, H2De FakerCreator,Bing Tian Jia Ke Sheng Cheng You Xu Shu Ju De GeneratorLei .
v1.0.3:Tian Jia Zhen Dui SQL ServerDe FakerCreator.
v1.0.2:Tian Jia Zhen Dui MySQLDe FakerCreator.
v1.0.1:Ti Gao Shu Ju Cha Ru Zhi Xing Su Du .
v1.0.0:Ke Yi Ci Cha Ru Bai Mo Ji Bie De Fang Zhen Shu Ju Dao Shu Ju Ku Zhong .

Yi Lai Tian Jia

Ben Kai Yuan Ku Yi Bao Han commons-dbcp2(2.0.1), commons-dbutils(1.6), junit(4.1.2)Yi Ji mysql-connector-java(5.1.46), sqlite-jdbc(3.28.0), h2(1.4.199)De Yi Lai .

<dependency> <groupId>com.github.lkmc2groupId> <artifactId>sql-fakerartifactId> <version>1.0.6version> dependency>

Zhu Yi :Mo Ren Shi Yong MySQLShu Ju Ku ,Ru Xu Geng Huan Cheng Oracle, SQL Server, H2Deng commons-dbcp2Lian Jie Chi Zhi Chi De Shu Ju Ku ,Ke Ling Xing Tian Jia Yi Lai ,Bing Zai DBToolsDe driverClassName(Shu Ju Ku Qu Dong Ming )Fang Fa Zhong Zhi Ding Shu Ju Ku Qu Dong Ming .

Shu Ju Ku Lian Jie

Yi , Lian Jie Shu Xing She Zhi

Zai Jin Xing Cha Ru Shu Ju Zhi Qian Xu Yao She Zhi Shu Ju Ku Shu Xing Jin Xing Lian Jie ,Ru Dai Ma Suo Shi :

// Chuang Jian Shu Ju Ku Lian Jie DBTools.url("jdbc:mysql://localhost:3306/facker") .username("root") .password("123456") .driverClassName("com.mysql.jdbc.Driver") .connect();

Ke She Zhi De Shu Xing Ru Xia Biao :

Shu Xing Ming	Shuo Ming	Mo Ren Zhi
url	Shu Ju Ku Lian Jie Di Zhi	jdbc:mysql://localhost:3306/Shu Ju Ku Ming ?useSSL=true&characterEncoding=utf8
username	Shu Ju Ku Yong Hu Ming	root
url	Shu Ju Ku Mi Ma	123456
driverClassName	Shu Ju Ku Qu Dong Ming	com.mysql.jdbc.Driver

Er , Te Shu Qing Kuang

Dang Shu Ju Ku Shu Xing Zhi Deng Yu Mo Ren Zhi Shi ,Ke Sheng Lue Gai Shu Xing De She Zhi (Ru Yong Hu Ming Deng Yu root, Qu Dong Ming Wei com.mysql.jdbc.DriverShi ,Ke Zhi She Zhi urlHe Mi Ma ):

// Chuang Jian Shu Ju Ku Lian Jie DBTools.url("jdbc:mysql://localhost:3306/facker") .password("OoOo00Oo00OoOo") .connect();

Dang Shu Ju Ku Shu Xing Zhi Du Deng Yu Mo Ren Zhi Shi ,Ke Zhi She Zhi Shu Ju Ku Ming (Ci Shi De urlZi Dong Pin Jie Wei :jdbc:mysql://localhost:3306/facker?useSSL=true&characterEncoding=utf8):

DBTools.dbName("facker").connect();

Zhu Yi :Shu Ju Ku Lian Jie Zhi Xu Yao She Zhi Yi Ci ,Zhi Hou Ke Yi Duo Ci Diao Yong FakerJin Xing Cha Ru Shu Ju Cao Zuo .

Shu Ju Cha Ru

Yi , Shu Xing Jie Shao

Ke She Zhi De Shu Xing Ru Xia Biao :

Shu Xing Ming	Shuo Ming
tableName(Shu Ju Ku Biao Ming )	She Zhi Shu Ju Ku Biao Ming
param(Zi Duan Ming , Shu Ju Sheng Cheng Qi Lei Xing 1)	She Zhi Shu Ju Ku Zi Duan Ming ,Yi Ji Dui Ying De Shu Ju Sheng Cheng Qi Lei Xing
insertCount(Cha Ru Tiao Shu )	She Zhi Cha Ru Shu Ju Tiao Shu
execute( )	Sheng Cheng SQL,Xian Shi Zai Kong Zhi Tai ,Bing Zai Shu Ju Ku Zhong Zhi Xing
onlyShowSql( )	Sheng Cheng SQL,Bing Xian Shi Zai Kong Zhi Tai
ignored( )	Bu Zhi Xing Ren He Cao Zuo

Zhu Yi :1 Shu Ju Sheng Cheng Qi Lei Xing ,Bi Xu Shi DataTypeMei Ju Zhi ,Huo Shi Xian Liao RandomJie Kou De Lei .

Shi Yong Shi Li :

// Gei userBiao De Si Ge Zi Duan Tian Chong 5Tiao Shu Ju Faker.tableName("user") .param("name", DataType.USERNAME) .param("age", DataType.AGE) .param("sex", DataType.SEX) .param("birthday", DataType.TIME) .insertCount(5) .execute(); // Gei userBiao De Liang Ge Zi Duan Sheng Cheng 5Tiao SQL,Bing Xian Shi Zai Kong Zhi Tai Faker.tableName("user") .param("name", DataType.USERNAME) .param("age", DataType.AGE) .insertCount(5) .onlyShowSql(); // Bu Zhi Xing Ren He Cao Zuo ,Bu Sheng Cheng SQL,Bu Xian Shi Zai Kong Zhi Tai Faker.tableName("user") .param("name", DataType.USERNAME) .param("age", DataType.AGE) .insertCount(5) .ignored();

Er , Cha Ru Shu Ju De Fang Shi

Ben Kai Yuan Ku Yi Gong Zhi Chi 4Chong Cha Ru Shu Ju De Fang Shi ,Ke Yi Hun He Shi Yong .

1. Shi Yong DataTypeZhi Ding Shu Ju Lei Xing

DataTypeYi Gong Zhi Chi 8Chong Mei Ju Lei Xing ,Ru Xia Biao Suo Shi :

Shu Xing Ming	Shuo Ming	Lei Xing	Shi Li Zhi
ID	Yong Hu ID	19Wei De Shu Zi Xing UUIDZi Fu Chuan	1049120504188764160
USERNAME	Yong Hu Ming	Chang Du Wei 2Dao 4Ge Zi De Zhong Wen Ming	Wu Tan Shuang
TIME	Shi Jian	Yi Nian Qian Dao Xian Zai De Shi Jian Fan Wei Nei Ren Yi Yi Ge Shi Ke	2018-03-01 12:41:00
PHONE	Shou Ji Hao	11Wei Shou Ji Hao	13192668109
ADDRESS	Di Zhi	Guo Nei Di Zhi ,Xiang Xi Dao Men Pai Hao	Si Chuan Sheng Mian Yang Shi Yan Ting Xian Bei Li Lu 738Hao
AGE	Nian Ling	18Dao 60Sui De Shu Zi	19
SEX	Xing Bie	Zi Fu ,0:Nan ,1:Nu	'1'
EMAIL	You Xiang	Chang Jian You Xiang Zi Fu Chuan	Alex705@gmail.com

Shi Yong Shi Li :

// Gei userBiao De 8Ge Zi Duan Tian Chong 1Tiao Shu Ju Faker.tableName("user") .param("id", DataType.ID) .param("name", DataType.USERNAME) .param("birthday", DataType.TIME) .param("phone", DataType.PHONE) .param("address", DataType.ADDRESS) .param("age", DataType.AGE) .param("sex", DataType.SEX) .param("email", DataType.EMAIL) .insertCount(1) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into user( id, name, birthday, phone, address, age, sex, email ) values( '1049120504188764160', 'Wu Tan Shuang ', '2018-03-01 12:41:00', '13192668109', 'Si Chuan Sheng Mian Yang Shi Yan Ting Xian Bei Li Lu 73Hao ', 19, '1', 'Alex705@gmail.com' )

2. Shi Yong Values.of()Xi Lie Fang Fa Sheng Cheng Qu Zhi Fan Wei

ValuesLei Gong You Yi Xia 9Chong Sheng Cheng Qu Zhi Fan Wei Fang Fa ,Ru Xia Biao :

Fang Fa Ming	Qu Zhi Fan Wei	Shi Li Zhi
Values.of(Ke Bian Chang Shu Zu )	Cong Ke Bian Chang Shu Zu Zhong Ren Yi Chou Qu Yi Ge Zhi	"You Pin ", "Liang Pin ", "Ci Pin "
Values.ofList(ListLie Biao )	Cong Lie Biao Zhong Ren Yi Chou Qu Yi Ge Zhi	"Jin Tian ", "Ming Tian ", "Hou Tian "
Values.ofIntRange(Qi Shi Zhi ,Jie Shu Zhi )	Zai [Qi Shi Zhi , Jie Shu Zhi ]De Fan Wei Nei Qu Yi Ge Zheng Shu	33
Values.ofLongRange(Qi Shi Zhi ,Jie Shu Zhi )	Zai [Qi Shi Zhi , Jie Shu Zhi )De Fan Wei Nei Qu Yi Ge Chang Zheng Xing Shu	777777777L
Values.ofFloatRange(Qi Shi Zhi ,Jie Shu Zhi )	Zai [Qi Shi Zhi , Jie Shu Zhi ]De Fan Wei Nei Qu Yi Ge Dan Jing Du Fu Dian Shu ,Mo Ren Jing Que Dao Xiao Shu Dian Hou 2Wei	22.22f
Values.ofFloatRange(Qi Shi Zhi ,Jie Shu Zhi ,Jing Du )	Zai [Qi Shi Zhi , Jie Shu Zhi ]De Fan Wei Nei Qu Yi Ge Dan Jing Du Fu Dian Shu ,Jing Du Gen Ju Can Shu She Zhi ,Zui Duo 6Wei	123.333333f
Values.ofDoubleRange(Qi Shi Zhi ,Jie Shu Zhi )	Zai [Qi Shi Zhi , Jie Shu Zhi ]De Fan Wei Nei Qu Yi Ge Shuang Jing Du Fu Dian Shu ,Mo Ren Jing Que Dao Xiao Shu Dian Hou 2Wei	788.31d
Values.ofDoubleRange(Qi Shi Zhi ,Jie Shu Zhi ,Jing Du )	Zai [Qi Shi Zhi , Jie Shu Zhi ]De Fan Wei Nei Qu Yi Ge Shuang Jing Du Fu Dian Shu ,Jing Du Gen Ju Can Shu She Zhi ,Zui Duo 6Wei	1820.4231d
Values.ofTimeRange(Kai Shi Shi Jian ,Jie Shu Shi Jian )	Zai [Kai Shi Shi Jian , Jie Shu Shi Jian ]De Fan Wei Nei Qu Yi Ge Shi Jian ,Jing Que Dao Miao	2018-03-14 13:21:11

Ling Wai ,TimesLei Zhong Huan You Yong Yu She Ding Shi Jian De Liang Ge Fang Fa :

Fang Fa Ming	Shuo Ming
Times.of(Nian ,Yue ,Ri )	Yong Yu Sheng Cheng Shi Jian ,Jing Que Dao Ri
Times.of(Nian ,Yue ,Ri ,Shi ,Fen ,Miao )	Yong Yu Sheng Cheng Shi Jian ,Jing Que Dao Miao

Shi Yong Shi Li :

// Gei productBiao De 10Ge Zi Duan Tian Chong 1Tiao Shu Ju Faker.tableName("product") .param("type", Values.of("You Pin ", "Liang Pin ", "Ci Pin ")) .param("date_info", Values.ofList(Arrays.asList("Jin Tian ", "Ming Tian ", "Hou Tian "))) .param("person_count", Values.ofIntRange(20, 50)) .param("total_count", Values.ofLongRange(555555555L, 888888888L)) .param("enter_price", Values.ofFloatRange(12.33f, 34.57f)) .param("outcome_price", Values.ofFloatRange(100.004132f, 240.281424f, 6)) .param("speed", Values.ofDoubleRange(750.34d, 800.27d)) .param("salary", Values.ofDoubleRange(1980.3415d, 2700.2315d, 4)) .param("firstTime", Values.ofTimeRange(Times.of(2018,3,22), Times.of(2018,10,22))) .param("secondTime", Values.ofTimeRange( Times.of(2018,3,22,11,23,24), Times.of(2018,10,22,22,15,17) ) ) .insertCount(1) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into product( type, date_info, person_count, total_count, enter_price, outcome_price, speed, salary, firstTime, secondTime ) values( 'Liang Pin ', 'Ming Tian ', 33, 777777777, 22.22, 123.333333, 788.31, 1820.4231, '2018-03-14 00:00:00', '2018-03-14 13:21:11' )

3.Shi Yong Generator.of()Xi Lie Fang Fa Sheng Cheng You Xu Qu Zhi Fan Wei

GeneratorLei Gong You Yi Xia 4Chong Sheng Cheng You Xu Qu Zhi Fan Wei Fang Fa ,Ru Xia Biao :

Fang Fa Ming	Qu Zhi Fan Wei	Shi Li Zhi
Generator.of(Ke Bian Chang Shu Zu )	Cong Ke Bian Chang Shu Zu Zhong Yi Ci Chou Qu Yi Ge Yuan Su ,Ke Xun Huan	"1001", "1002", "1003"
Generator.ofList(ListLie Biao )	Cong Lie Biao Zhong Yi Ci Chou Qu Yi Ge Yuan Su ,Ke Xun Huan	"Kai Xin ", "Nan Guo ", "Ping Jing "
Generator.ofIntStart(Qi Shi Zhi )	Zai [Qi Shi Zhi , Jie Shu Zhi ]De Fan Wei Nei Qu Yi Ge Zheng Shu	500
Generator.ofLongStart(Qi Shi Zhi )	Cong Qi Shi Zhi Kai Shi ,Mei Ci Qu Zhi Du +1	1000

Ling Wai ,Generator.of(Ke Bian Chang Shu Zu )He Generator.ofList(ListLie Biao )Fang Fa Zhong Huan You Yong Yu She Ding Ke Bian Chang Shu Zu Zhong Mei Ge Yuan Su Chu Xian Ci Shu De Fang Fa :

Fang Fa Ming	Shuo Ming
repeatCount(Chu Xian Ci Shu )	Yong Yu She Ding Ke Bian Chang Shu Zu Zhong Mei Ge Yuan Su Chu Xian Ci Shu

Shi Yong Shi Li 1:

// Gei userBiao De 1Ge Zi Duan Tian Chong 10Tiao Shu Ju // Generator.of()Fang Fa Zhong De Zhi Hui Yi Ci Chu Xian ,Di Da Zui Hou Yi Ge Yuan Su Hou Jiang Cong Di Yi Ge Yuan Su Kai Shi Xun Huan Faker.tableName("user") .param("deptNo", Generator.of("1001", "1002", "1003")) .insertCount(10) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into user(deptNo) values('1001') insert into user(deptNo) values('1002') insert into user(deptNo) values('1003') insert into user(deptNo) values('1001') insert into user(deptNo) values('1002') insert into user(deptNo) values('1003') insert into user(deptNo) values('1001') insert into user(deptNo) values('1002') insert into user(deptNo) values('1003') insert into user(deptNo) values('1001')

Shi Yong Shi Li 2:

// Gei userBiao De 2Ge Zi Duan Tian Chong 10Tiao Shu Ju // Generator.of()Fang Fa Zhong De Zhi Hui Yi Ci Chu Xian ,Di Da Zui Hou Yi Ge Yuan Su Hou Jiang Cong Di Yi Ge Yuan Su Kai Shi Xun Huan // repeatCount()Fang Fa Ke Zhi Ding Generator.of()Can Shu Zhong De Mei Ge Zhi Chu Xian De Ci Shu // Ru jackHui Chu Xian 3Ci Hou ,Zai Lun Dao andyChu Xian 3Ci ,wangChu Xian 3Ci ,Yi Ci Lei Tui Faker.tableName("user") .param("name", Generator.of("jack", "andy", "wang").repeatCount(3)) .param("deptNo", Generator.of("1001", "1002", "1003")) .insertCount(10) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into user(name,deptNo) values('jack','1001') insert into user(name,deptNo) values('jack','1002') insert into user(name,deptNo) values('jack','1003') insert into user(name,deptNo) values('andy','1001') insert into user(name,deptNo) values('andy','1002') insert into user(name,deptNo) values('andy','1003') insert into user(name,deptNo) values('wang','1001') insert into user(name,deptNo) values('wang','1002') insert into user(name,deptNo) values('wang','1003') insert into user(name,deptNo) values('jack','1001')

Shi Yong Shi Li 3:

// Gei userBiao De 4Ge Zi Duan Tian Chong 10Tiao Shu Ju // Generator.ofLongStart()He Generator.ofIntStart()Fang Fa ,Zai Zhi Ding Chu Shi Zhi Hou ,Mei Ci Qu Zhi Du Hui +1 Faker.tableName("user") .param("id", Generator.ofLongStart(10000L)) .param("name", Generator.of("jack", "andy", "wang").repeatCount(3)) .param("deptNo", Generator.of("1001", "1002", "1003")) .param("state", Generator.ofList("1001", "1002", "1003")) .param("serialNum", Generator.ofIntStart(500)) .insertCount(10) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into user(id,name,deptNo,serialNum) values('10000','jack','1001','500') insert into user(id,name,deptNo,serialNum) values('10001','jack','1002','501') insert into user(id,name,deptNo,serialNum) values('10002','jack','1003','502') insert into user(id,name,deptNo,serialNum) values('10003','andy','1001','503') insert into user(id,name,deptNo,serialNum) values('10004','andy','1002','504') insert into user(id,name,deptNo,serialNum) values('10005','andy','1003','505') insert into user(id,name,deptNo,serialNum) values('10006','wang','1001','506') insert into user(id,name,deptNo,serialNum) values('10007','wang','1002','507') insert into user(id,name,deptNo,serialNum) values('10008','wang','1003','508') insert into user(id,name,deptNo,serialNum) values('10009','jack','1001','509')

Shi Yong Shi Li 4:

List<Integer> numberList = Arrays.asList(1001, 2002, 3003); List<String> moodList = Arrays.asList("Kai Xin ", "Nan Guo ", "Ping Jing "); // Gei userBiao De 3Ge Zi Duan Tian Chong 10Tiao Shu Ju Faker.tableName("user") .param("id", Generator.ofLongStart(10000L)) .param("number", Generator.ofList(numberList).repeatCount(3)) .param("mood", Generator.ofList(moodList)) .insertCount(10) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into user(id,number,mood) values('10000','1001','Kai Xin ') insert into user(id,number,mood) values('10001','1001','Nan Guo ') insert into user(id,number,mood) values('10002','1001','Ping Jing ') insert into user(id,number,mood) values('10003','2002','Kai Xin ') insert into user(id,number,mood) values('10004','2002','Nan Guo ') insert into user(id,number,mood) values('10005','2002','Ping Jing ') insert into user(id,number,mood) values('10006','3003','Kai Xin ') insert into user(id,number,mood) values('10007','3003','Nan Guo ') insert into user(id,number,mood) values('10008','3003','Ping Jing ') insert into user(id,number,mood) values('10009','1001','Kai Xin ')

4. Shi Xian RandomDataJie Kou ,Ti Gong Ke Sui Ji Sheng Cheng De Fan Hui Zhi

RandomDataJie Kou De Dai Ma Ru Xia :

public interface RandomData<T> { T next(); }

Shi Xian Gai Jie Kou ,Bing Zhong Xie next( )Fang Fa Ti Gong Yi Ge Fan Hui Zhi ,Gai Fan Hui Zhi Jiu Shi Shu Ju Ku Zi Duan Dui Ying Cha Ru De Zhi .

Shi Yong Shi Li :

Chuang Jian Yi Ge Zi Ding Yi Lei EnglishNameRandom,Shi Xian RandomData(Fan Xing TKe Yi Shi Ren Yi Lei Xing )Jie Kou ,Bing Ti Gong Yi Ge Sui Ji Sheng Cheng De Fan Hui Zhi .

// Ying Wen Ming Shu Ju Sheng Cheng Qi public class EnglishNameRandom implements RandomData<String> { // Hou Xuan Zhi Shu Zu ,Cong Gai Shu Zu Zhong Sui Ji Chou Yi Ge Zuo Wei Fan Hui Zhi private static final String[] names = {"Kim Lily", "Andy Wang", "July Six"}; @Override public String next() { // Cong Shu Zu Zhong Sui Ji Xuan Qu Yi Ge Zhi return RandomUtils.selectOneInArray(names); } }

Zai FakerZhong Gei Zi Duan Zhi Ding Shi Yong EnglishNameRandom.classLei Xing De Sheng Cheng Qi .

// Zhi Ding nameZi Duan Shi Yong EnglishNameRandomLei Jin Xing Sui Ji Zhi De Sheng Cheng Faker.tableName("user") .param("name", EnglishNameRandom.class) .param("age", Values.ofIntRange(20, 50)) .param("address", DataType.ADDRESS) .insertCount(5) .execute();

Dui Ying Sheng Cheng De SQLYu Ju Ru Xia :

insert into user(name, age, address) values('Andy Wang', 23, 'Si Chuan Sheng Mian Yang Shi Yan Ting Xian Bei Li Lu 73Hao ')

Fan Xiang Sheng Cheng JavaWen Jian

Zhu Yi :Mu Qian Jin Zhen Wei MySQL, SQL Server, Oracle, SqliteHe H2Shu Ju Ku She Ji Liao FakerBiao Chuang Jian Qi .

Yi Xia De Li Zi Jin Zhen Dui MySQL,Qi Ta Shu Ju Ku Qing Can Kao Zhe Li .

Shi Yong Shi Fan

Ru testShu Ju Ku Zhong Han You Ru Xia Liang Zhang Biao .

create table user_table ( id varchar(32) primary key, name varchar(120), age int ) comments 'Yong Hu Biao '; create table product ( id varchar(32) primary key, name varchar(32), price int, tenant_id varchar(32), created_by varchar(32), updated_by varchar(32), created_at date, updated_at date, dr int(1) ) comments 'Chan Pin Biao ';

Shi Yong Ru Xia Dai Ma Ji Ke Shi Yong FakerBiao Chuang Jian Qi Kuai Su Wei testShu Ju Ku Zhong De Suo You Biao Sheng Cheng Dai You FakerJie Gou De javaWen Jian .

// Wei MySQL Shu Ju Ku De Suo You Biao Sheng Cheng Dai Faker Biao Jie Gou De java Wen Jian // Fang Shi 1:Jian Dan She Zhi Shu Ju Ku Ming ,Bing Chuang Jian FakerBiao Jie Gou // Shi Yong Fang Shi 1Shi ,Hui Shi Yong Ru Xia Mo Ren De Shu Ju Ku Can Shu Jin Xing Lian Jie // url: jdbc:mysql://localhost:3306/Shu Ju Ku Ming // Shu Ju Ku Qu Dong :com.mysql.jdbc.Driver // Yong Hu Ming :root // Mi Ma :123456 FakerCreator.mysql().dbName("test").build(); // Fang Shi 2:Wan Zheng She Zhi Shu Ju Ku Xin Xi ,Bing Chuang Jian FakerBiao Jie Gou FakerCreator.mysql() .url("jdbc:mysql://localhost:3306/facker") .driverClassName("com.mysql.jdbc.Driver") .username("root") .password("123456") .build();

Zhi Xing Shang Shu Dai Ma Zhong De Qi Zhong Yi Ge Fang Shi ,Sheng Cheng De javaWen Jian Nei Rong Ru Xia :

package com.lin.creator; import com.lin.datatype.DataType; import com.lin.faker.Faker; import com.lin.utils.DBTools; import com.lin.value.Times; import com.lin.value.Values; /** * FakerSheng Cheng De Biao Jie Gou */ public class CreateFakerTable { public static void main(String[] args) { // Chuang Jian Shu Ju Ku Lian Jie DBTools.url("jdbc:mysql://localhost:3306/test") .username("root") .password("123456") .driverClassName("com.mysql.jdbc.Driver") .connect(); // Yong Hu Biao Faker.tableName("user") .param("id", Values.ofIntRange(1, 18)) .param("name", Values.of("example1", "example2", "example3")) .param("age", Values.ofIntRange(1, 18)) .insertCount(5) .onlyShowSql(); // Chan Pin Biao Faker.tableName("product") .param("id", DataType.ID) .param("name", Values.of("example1", "example2", "example3")) .param("price", Values.ofIntRange(1, 18)) .param("tenant_id", Values.of("example1", "example2", "example3")) .param("created_by", Values.of("example1", "example2", "example3")) .param("updated_by", Values.of("example1", "example2", "example3")) .param("created_at", Values.ofTimeRange(Times.of(2019, 1, 1), Times.of(2019, 5, 1))) .param("updated_at", Values.ofTimeRange(Times.of(2019, 1, 1), Times.of(2019, 5, 1))) .param("dr", Values.ofIntRange(1, 18)) .insertCount(5) .onlyShowSql(); } }

Ke Yi Zai Ci Wen Jian De Ji Chu Shang Dui Jin Xing Kai Fa .

PS:Ru Guo You Ren He Jian Yi ,Ke Yi Zai IssuesZhong Ti Chu ,Ru Tian Jia DataTypeDe Mo Ren Lei Xing Deng .

License

The SqlFaker is released under version 2.0 of the Apache License.

Folders and files

Latest commit

History

Repository files navigation

SqlFaker

Qing Liang Ji , Yi Tuo Zhan De Shu Ju Ku Zhi Neng Tian Chong JavaKai Yuan Ku

Jian Jie

Xiang Xi Wen Dang Shuo Ming

Kai Yuan Ku Te Xing

Shi Yong Shi Fan

Geng Xin Ri Zhi

Yi Lai Tian Jia

Shu Ju Ku Lian Jie

Yi , Lian Jie Shu Xing She Zhi

Er , Te Shu Qing Kuang

Shu Ju Cha Ru

Yi , Shu Xing Jie Shao

Er , Cha Ru Shu Ju De Fang Shi

1. Shi Yong DataTypeZhi Ding Shu Ju Lei Xing

2. Shi Yong Values.of()Xi Lie Fang Fa Sheng Cheng Qu Zhi Fan Wei

3.Shi Yong Generator.of()Xi Lie Fang Fa Sheng Cheng You Xu Qu Zhi Fan Wei

4. Shi Xian RandomDataJie Kou ,Ti Gong Ke Sui Ji Sheng Cheng De Fan Hui Zhi

Fan Xiang Sheng Cheng JavaWen Jian

Shi Yong Shi Fan

License

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Uh oh!

Contributors

Uh oh!

Languages

Packages