Java encapsulates the database result set into map (Java obtains database fields)

This sectionCodeIs to encapsulate the result set into map, the field is key, record is value. Then add each map to the list.

If you have any suggestions or ideas, please leave me a message.

Import Java. SQL. connection; import Java. SQL. drivermanager; import Java. SQL. resultset; import Java. SQL. resultsetmetadata; import Java. SQL. sqlexception; import Java. SQL. statement; import Java. util. arraylist; import Java. util. hashmap; public class dbhelper {public static void main (string [] ARGs) throws classnotfoundexception, sqlexception {class. forname ("com. mySQL. JDBC. driver "); string url =" JDBC: mysql: // 127. 0.0.1: 3306/db123 "; string user =" root "; string Password =" root "; connection conn = drivermanager. getconnection (URL, user, password); statement stmt = Conn. createstatement ();/* For (char letter = 'a'; letter <= 'Z'; letter ++) {int id = letter-97; string name = ""; string sex = (ID & 1 )! = 0? "Male": "female"; string state = "Y"; string SQL = "insert into person (ID, name, sex, state) values (" + ID + ", "+ name +", "+ sex +", "+ state +") "cmdps.exe cute (SQL );} */resultset rs = stmt.exe cutequery ("select * From person P"); resultsetmetadata data Data = Rs. getmetadata (); arraylist