java - 如果有除零以外的值，如何输入新字符串

Question

我需要帮助。有人可以告诉我我需要使用的概念和示例代码吗？情况是，我想使用java将游戏历史记录输入mysql(phpmyadmin)。

我已经像这样创建了 if S0: 1.0; 并且所有值都为零

try
{
   connection = dbManager.getConnection();    
   String bs = "S0:"+s[0]+"; S1:"+s[1]+"; S2:"+s[2]+"; S3:"+s[3]+"; S4:"+s[4]+"; S5:"+s[5]+"; S6:"+s[6]+"; S7:"+s[7]+"; S8:"+s[8]+"; S9:"+s[9]+"; S10:"+s[10]+"; S11:"+s[11]+"; S12:"+s[12]+"; S13:"+s[13]+"; S14:"+s[14]+"; S15:"+s[15]+"; S16:"+s[16]+"; S17:"+s[17]+"; S18:"+s[18]+"; S19:"+s[19]+"; S20:"+s[20]+"; S21:"+s[21]+"; S22:"+s[22]+"; S23:"+s[23]+"; S24:"+s[24]+"; S25:"+s[25]+"; S26:"+s[26]+"; S27:"+s[27]+"; S28:"+s[28]+"; S29:"+s[29]+"; S30:"+s[30]+"; S31:"+s[31]+"; S32:"+s[32]+"; S33:"+s[33]+"; S34:"+s[34]+"; S35:"+s[35]+"; S36:"+s[36]+"";
}
catch (SQLException e)
{
   trace("player 1 update error");
}

它的工作原理和结果是这样的

S0:1.0; S1:0.0; S2:0.0; S3:0.0; S4:0.0; S5:0.0; S6:0.0; S7:0.0; S8:0.0; S9:0.0; S10:0.0; S11:0.0; S12:0.0; S13:0.0; S14:0.0; S15:0.0; S16:0.0; S17:0.0; S18:0.0; S19:0.0; S20:0.0; S21:0.0; S22:0.0; S23:0.0; S24:0.0; S25:0.0; S26:0.0; S27:0.0; S28:0.0; S29:0.0; S30:0.0; S31:0.0; S32:0.0; S33:0.0; S34:0.0; S35:0.0; S36:0.0

但效率不高，问题是如果有除零之外的任何值，我如何输入，例如 S0:1 ； S1:0； S2:1 并像这样 S0:1 一样插入到 mysql 中； S2:1 所以如果没有值/零，则不会被插入。谢谢

Answer 1

你可以试试这个:

String bs = "";
int count = 0;
for (int i = 0; i < size; i++) {
    if(!s[i].equals(0.0)) {
        if(count > 0) {
            bs += " ; " ;
        }
        bs += "S" + count + ":" + s[i].split(".")[0];
        count++;
    }

}