//新增列 public String insert(String[] attributes, String[] value) { DBConnector db = new DBConnector(); String s = "INSERT INTO [" + tableName + "]("; for (int i = 1; i < attributes.Length - 1; i++) { s += "[" + attributes[i] + "],"; } s += "[" + attributes[attributes.Length - 1] + "])VALUES("; for (int i = 1; i < value.Length - 1; i++) { s += "'" + value[i] + "',"; } s += "'" + value[value.Length - 1] + "')"; return db.sql(s); }
//修改字串欄位 public String modify(String modifyColumn, String modifyValue, String conditionColumn, String conditionValue) { DBConnector db = new DBConnector(); String sqlStr = "UPDATE " + tableName + " SET " + modifyColumn + " = '" + modifyValue + "' WHERE " + conditionColumn + " = '" + conditionValue + "'"; return db.sql(sqlStr); }
//刪除列 public String delete(String fieldName, String value) { DBConnector db = new DBConnector(); String sqlStr = "DELETE FROM "+tableName+" WHERE ["+fieldName +"] = '" + value + "'"; return db.sql(sqlStr); }