Java实现用户信息修改功能:数据库操作与用户界面
以下是实现系统用户信息修改功能的Java代码:\n\njava\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.SQLException;\n\npublic class GuangzhouFengyuUserInformation {\n public static void main(String[] args) {\n // 输入用户信息\n String userId = "123456";\n String userName = "John";\n String phoneNumber = "1234567890";\n String address = "123 Main Street";\n String postalCode = "12345";\n String email = "john@example.com";\n String nickname = "Johnny";\n int passwordErrorCount = 0;\n String organizationName = "ABC Company";\n String userStatus = "Active";\n\n // 保存用户信息\n saveUserInformation(userId, userName, phoneNumber, address, postalCode, email, nickname, passwordErrorCount, organizationName, userStatus);\n }\n\n private static void saveUserInformation(String userId, String userName, String phoneNumber, String address, String postalCode,\n String email, String nickname, int passwordErrorCount, String organizationName, String userStatus) {\n // JDBC连接参数\n String url = "jdbc:mysql://localhost:3306/mydatabase";\n String username = "root";\n String password = "password";\n\n // SQL语句\n String sql = "INSERT INTO user_information (user_id, user_name, phone_number, address, postal_code, email, nickname, password_error_count, organization_name, user_status) " +\n "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";\n\n try {\n // 加载MySQL JDBC驱动\n Class.forName("com.mysql.jdbc.Driver");\n\n // 建立数据库连接\n Connection connection = DriverManager.getConnection(url, username, password);\n\n // 创建PreparedStatement对象\n PreparedStatement statement = connection.prepareStatement(sql);\n\n // 设置参数\n statement.setString(1, userId);\n statement.setString(2, userName);\n statement.setString(3, phoneNumber);\n statement.setString(4, address);\n statement.setString(5, postalCode);\n statement.setString(6, email);\n statement.setString(7, nickname);\n statement.setInt(8, passwordErrorCount);\n statement.setString(9, organizationName);\n statement.setString(10, userStatus);\n\n // 执行SQL语句\n int rowsAffected = statement.executeUpdate();\n\n // 关闭连接和语句对象\n statement.close();\n connection.close();\n\n // 输出结果\n if (rowsAffected > 0) {\n System.out.println("编辑成功");\n } else {\n System.out.println("编辑失败");\n }\n } catch (ClassNotFoundException e) {\n e.printStackTrace();\n } catch (SQLException e) {\n e.printStackTrace();\n }\n }\n}\n\n\n请注意,上述代码中的数据库连接参数(url、username和password)应根据实际情况进行修改,以便正确连接到您的MySQL数据库。
原文地址: https://www.cveoy.top/t/topic/qyIS 著作权归作者所有。请勿转载和采集!