For the code snippet listed below, fill in the code snippet based on the followi
ID: 3928016 • Letter: F
Question
For the code snippet listed below, fill in the code snippet based on the following information.
We have a customer table that has the following fields, where we assume that there is a customer with a CustomerNumber value of 10.
CustomerNumber Integer
CustomerName Varchar
Also, use the following string information.
String dataBaseURL = "jdbc:mysql://localhost:3306/Customer;
String userName = "Rich";
String passWord ="zebra";
You will need to build a SELECT STATEMENT that searches for the CustomerName based on the CustomerNumber field having a value of 10.
try
{
String dataBaseURL = "";
String userName = "";
String passWord ="";
Connection connection = DriverManager.getConnection( , ,);
Statement statement= connnection.createStatement();
ResultSet rs = statement.executeQuery("");
System.out.println(rs.getString(""));
}
catch (SQLException e)
{
e.printStackTrace();
}
Explanation / Answer
try
{
String dataBaseURL = "jdbc:mysql://localhost:3306/Customer";
String userName = "Rich";
String passWord ="zebra";
Connection connection = DriverManager.getConnection(dataBaseURL,userName,passWord);
Statement statement= connnection.createStatement();
ResultSet rs = statement.executeQuery("select CustomerName from Customer where CustomerNumber=10);
System.out.println(rs.getString(1));
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
connection.close();
statement.close();
rs.close();
}