In looking at the JDBC code, how can you tell what type of Database Management System being used in this code?
import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.*;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;public class guiDBExample extends JFrame implements ActionListener { String inputNumber; int sqlNumber; String partName = null; String partDescription = null; String partPrice = null; JTextField name; JTextField number; public guiDBExample() { buildGUI(); } public final void buildGUI() { JPanel panel1 = new JPanel(); JPanel panel2 = new JPanel(); JPanel panel3 = new JPanel(); JPanel panel4 = new JPanel(); JPanel panel5 = new JPanel(); getContentPane().add(panel1, "North"); getContentPane().add(panel2, "West"); getContentPane().add(panel3, "Center"); getContentPane().add(panel4, "East"); getContentPane().add(panel5, "South"); JLabel partNumber = new JLabel("Part number "); panel1.add(partNumber); number = new JTextField("", 10); panel1.add(number); JLabel partNameLabel = new JLabel("Name "); panel1.add(partNameLabel); name = new JTextField("", 15); panel1.add(name); JButton read = new JButton("Read"); read.addActionListener(this); panel5.add(read); setDefaultCloseOperation(EXIT_ON_CLOSE); } public void getPartName() throws SQLException, ClassNotFoundException { Class.forName("com.mysql.jdbc.Driver"); System.out.println("Driver loaded"); // Establish a connection Connection connection = DriverManager.getConnection ("jdbc:mysql://localhost/test"); //Sample connection if you have a password set on your machine //Connection connection = DriverManager.getConnection // ("jdbc:mysql://localhost/test","root", "MySQL"); System.out.println("Database connected"); // Create a statement Statement statement = connection.createStatement(); // Execute a statement ResultSet resultSet = statement.executeQuery ("select * from Inventory WHERE partNumber = " + sqlNumber + ";"); // Iterate through the result and print the student names while (resultSet.next()) { partName = resultSet.getString(2); } // Close the connection connection.close(); } public void actionPerformed(ActionEvent action) { if(action.getActionCommand().equals("Read")) { try { inputNumber = number.getText(); sqlNumber = Integer.parseInt(inputNumber); getPartName(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } name.setText(partName); } } public static void main(String[] args) { guiDBExample ex = new guiDBExample(); //the next statement correctly sizes your GUI ex.pack(); ex.setVisible(true); }}
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here