Java连接MySql数据库,并且实现插入、删除、更新、(6)

Java连接MySql数据库,并且实现插入、删除、更新、选择操作Java连接MySql数据库,并且实现插入、删除、更新、选择操作Java连接MySql数据库,并且实现插入、删除、更新、选择操作

String sql = "";

String insertFields = "", temFields = "";

String insertValues = "", temValues = "";

boolean insertResult = false;

Iterator keyValues = values.entrySet().iterator();

for(int i = 0; i<values.size(); ++i)

{

Map.Entry entry = (Map.Entry) keyValues.next();

Object key = entry.getKey();

Object value = entry.getValue();

temFields += key + ", ";

temValues += "’" + value + "’" + ", ";

}

insertFields = temFields.substring(0, temFields.length() – 2);

insertValues = temValues.substring(0, temValues.length() – 2);

sql += "insert into " + tabName + " (" + insertFields + ") values" + "(" + insertValues + ")";

try

{

dbstate.executeUpdate(sql);

insertResult = true;

}catch(Exception e){

print("Sql = " + sql);

print("Exception: " + e.getMessage());

}

if (insertResult)

return true;

else

return false;

}//end dbInsert(…)

/**

* 断开数据库

* @return bool值，成功返回true，失败返回false

*/

public boolean dbClose()

{

boolean closeResult = false;

try

{

dbconn.close();

closeResult = true;

}catch(Exception e){

print("Exception: " + e.getMessage());