hero表:
CREATE TABLE hero (
id int(11) AUTO_INCREMENT,
name varchar(30) ,
hp float ,
damage int(11) ,
PRIMARY KEY (id)
) DEFAULT CHARSET=utf8;
插入语句:
insert into hero values(id,name,hp,damage)
java中拼接:
for (int i = 0; i < 100; i++) {
String sql = "insert into hero values(null," + "'英雄"+i+"'" + "," + 313.0f + "," + 50 + ")";
s.execute(sql);
}
for (int i = 0; i < 10; i++) {
String sql = "insert into hero values(null,"+"'"+i+"英雄'"+"," + 313.0f + "," + 50 + ")"; s.execute(sql);
}
规则如下:
- 逗号分隔各个数据,所以逗号间要有
“双引号”
,以下规则均建立在此规则之下
ps:如果插入数据只是个变量,那么就不用加这个“双引号”
例:注意最后的i
`
String sql = "insert into hero values(null,"+"'英雄'"+"," + 313.0f + ",'"+i+"')";
`
- 如果只是常数,则
+常数+
即可 - 如果含有字符,需要单引号和双引号配合使用,即
+“‘字符’”+
(外双内单) - 如果含有变量,同上,不过位置不同,即
‘“+变量+”’
(外单内双) - 如果既有字符又有变量,则
+“‘字符“+变量+”’”+
或+"'"+变量+"字符'"+
即在字符规则的‘单引号’内,把此‘单引号’当做变量规则的’单引号’,再以变量规则输入变量内容
也就是规则3和规则4的单引号合并了