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

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

}

if (closeResult)

return true;

else

return false;

}//end dbClose()

/////////////////////////////////////////———–>>>入口主函数

public static void main(String[] args)

{

DbConnect dc = new DbConnect();

//连接数据库用到的一些参数.

String dbHost = "localhost";

String dbPort = "3306";

String dbName = "feast";

String dbuserName = "root";

String dbpsw = "";

boolean con = dc.dbConnection(dbHost, dbPort, dbName, dbuserName, dbpsw); //连接数据库

if (con)

{

ArrayList fields = new ArrayList();

fields.add("message_content");

fields.add("message_type");

Map lmap = new HashMap();

String selCondition = " where message_type = 1 limit 2";

ArrayList str = dc.dbSelect("feast", fields, selCondition); //—>>>选择记录

if (str.size() != 0){

dc.print("select OK!");

dc.print("str’s size = " + str.size());

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

lmap = (HashMap)str.get(i);

dc.print("lmap = " + lmap);

}

}

}

else

dc.print("fail");

String tableName = "feast";

String condition = "where message_type = 5";