有一个table_sum,有28列,id, 从A到Z,sum 都是int数据类型。
id A B C ... Z sum
现将几行数据插入到table里。我写的代码,麻烦帮忙看下可否可行,如有不对,那该如何实现,谢谢!
public insert{
int[] char=new int[26];
int id, sum;
public void insertDB(DB db){
string sql=null;
db.open();
sql="insert into table_sum values('" + id + "," + this.getSum + sum + ")";
db.executeUpdate();
db.close();
} public String getSum(){
String Val = "";
for(int i=0; i<26; i++){
Val = Val + char[i] + "','";
}
return Val;
}
public setID(int id){
this.id=id;
}
public setSum(int sum){
this.sum=sum;
}
public setChar(int[] char){
this.char = char;
}
id A B C ... Z sum
现将几行数据插入到table里。我写的代码,麻烦帮忙看下可否可行,如有不对,那该如何实现,谢谢!
public insert{
int[] char=new int[26];
int id, sum;
public void insertDB(DB db){
string sql=null;
db.open();
sql="insert into table_sum values('" + id + "," + this.getSum + sum + ")";
db.executeUpdate();
db.close();
} public String getSum(){
String Val = "";
for(int i=0; i<26; i++){
Val = Val + char[i] + "','";
}
return Val;
}
public setID(int id){
this.id=id;
}
public setSum(int sum){
this.sum=sum;
}
public setChar(int[] char){
this.char = char;
}
批量插入用addBatch
如果插入多条相似的数据可以用preparestatment(预编译)
或批量插入用addBatch,这样效率会高一些。