n 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); } }
In looking at the JDBC code, how can you tell what type of
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);
}
}
Step by step
Solved in 2 steps