//新增列
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);
}