hero表:
CREATE TABLE hero (
id int(11) AUTO_INCREMENT,
name varchar(20) ,
hp float ,
damage int(10) ,
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);
}
规则如下:
1.逗号分隔各个数据,所以逗号间要有“双引号” ,以下规则均建立在此规则之下
ps:如果插入数据只是个变量,那么就不用加这个“双引号”
例:注意最后的i
2.如果只是常数,则+常数+即可
3.如果含有字符,需要单引号和双引号配合使用,即+“‘字符’”+(外双内单)
4.如果含有变量,同上,不过位置不同,即‘“+变量+”’
(外单内双)
5.如果既有字符又有变量,则+“‘字符“+变量+”’”+ 或+"’"+变量+“字符’”+
即在字符规则的‘单引号’内,把此‘单引号’当做变量规则的’单引号’,再以变量规则输入变量内容。
String sql = "insert into hero values(null,"+"'提莫"+i+"'"+","+313+","+50+")";
String sql = "insert into hero values(null,'同学"+i+"号',313,50)" ; //增加命令