To run this code we need to create a maven project so that we can add faker dependency to import the faker package in the project.<\/strong><\/p>\nSteps to create a Project:<\/h2>\n
\n
\n<!--https:\/\/mvnrepository.com\/artifact\/com.github.javafaker\/javafaker -->
\n<dependency>
\n<groupId>com.github.javafaker<\/groupId>
\n<artifactId>javafaker<\/artifactId>
\n<version>0.16<\/version>
\n<\/dependency><\/em><\/code>\n<\/li>\n
\npackage TestingAutomation.testingfaker;
\nimport java.sql.Connection;
\nimport java.sql.DriverManager;
\nimport java.sql.PreparedStatement;
\nimport java.sql.ResultSet;
\nimport java.sql.SQLException;
\nimport java.sql.Statement;
\nimport com.github.javafaker.Faker;
\npublic class Testing{
\n\t\/\/creating faker object
\n\tstatic Faker faker = new Faker();
\n\tpublic static String getName() {
\n\t\t\/\/Generating the first name
\n\t\tString Name = faker.name().name();
\n\t\treturn Name;
\n\t}
\n\tpublic static String getCompany() {
\n\t\t\/\/Generating company name
\n\t\tString Company = faker.company().name();
\n\t\treturn Company;
\n\t}
\n\tpublic static void main(String arg[]) throws SQLException,
\n\tClassNotFoundException {
\n\t\t\/\/Intialialization of variables
\n\t\tString url = \"jdbc:mysql:\/\/127.0.0.1:3306\/testing?user=root\";
\n\t\t\/\/Loading the required MYSQL JDBC Driver class
\n\t\tClass.forName(\"com.mysql.cj.jdbc.Driver\");
\n\t\t\/\/Creating a connection to the database
\n\t\tConnection conn = DriverManager.getConnection(url);
\n\t\t\/\/ Insert 10 records in the database
\n\t\tint count = 0;
\n\t\twhile (count < 10) {\n\t\t\t\/\/Executing SQL query and fetching the result\n\t\t\tStatement fetchData = conn.createStatement();\n\t\t\t\/\/ Execute the Insert command\n\t\t\tString excuteComm = \"INSERT INTO testing.testing(name,company)VALUES(?,?)\";\n\t\t\tPreparedStatement preparedStmt = conn.prepareStatement(excuteComm, Statement.RETURN_GENERATED_KEYS);\n\t\t\tpreparedStmt.setString(1, getName());\n\t\t\tpreparedStmt.setString(2, getCompany());\n\t\t\t\/\/ Execute the preparedstatement\n\t\t\tpreparedStmt.executeUpdate();\n\t\t\t\/\/ Getting Id of last Inserted records in the database\n\t\t\tResultSet result = preparedStmt.getGeneratedKeys();\n\t\t\tint id = 0;\n\t\t\tif (result.next()) {\n\t\t\t\tid = result.getInt(1);\n\t\t\t}\n\t\t\tSystem.out.println(\"Last Inserted ID:\" + id);\n\t\t\t\/\/Disconnect the database\n\t\t\tfetchData.close();\n\t\t\tcount++;\n\t\t}\n\t}\n}<\/code><\/p>\nResult:<\/h3>\n
![\"Faker](\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/05\/demo.png\")
\n<\/li>\n<\/ol>\n