importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;public classJDBCTools {public static void main(String[] args) throwsException {
JDBCTools.query("select * from t_balance t");
System.out.println();
JDBCTools.execute("update t_balance t set t.balance = 20000 where t.user_id = 100");
System.out.println();
JDBCTools.query("select * from t_balance t");
}public static String HOST = "localhost";public static String PORT = "3306";public static String DATABASE_NAME = "demo";public static String USER_NAME = "root";public static String PASSWORD = "123456";/*** 获取数据库连接
*@return数据库连接*/
p