Can someone help what is the reason of ERROR in 39th line and 43rd line?search from database 1String departmentCment") 7JOptionPane.showMessageDialog(null, "Name:" + name + "\nAGE: " + age + "\nPOSITION: " + position + "\nDEPARTMENT: " + department, "SEARCH FROM DATABASE", JOptionPane. INFORMATION_MESSAGE) ;}rs.close();stmt.close();conn.close();} catch (SQLException se) {se.printStackTrace();} catch (Exception e) {e.printStackTrace();} finally{try{if (stmt!=null)stmt.close();}catch (SQLException se2) {}try{if (conn!=null)conn.close();} catch (SQLException se) {se.printStackTrace();}JOptionPane.showMessageDialog(null, "Thank you.", SEARCH FROM DATABASE", JOptionPane. INFORMATION_MESSAGE) ;} 4* and open the template in the editor.5package mysqlsearch;78import java.beans. Statement;9 import java.sql.Connection;10import java.sql.DriverManager;11import java.sql.ResultSet;12import java.sql.SQLException;13import javax.swing.JOptionPane;1415/**16*17* @author kell_pc18*/19public class MySqlSearch {2021static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";2223static final String DB_URL = "jdbc:mysql://localhost/sanagustin_database";2425static final String USER = "root";26static final String PASS = "";2728public static void main(String[] args) {29Connection conn = null;30Statement stmt = null;31String searchName= JOptionPane.show Input Dialog(null, "Select the name or first letter of the name");try{3233Class. forName ("com.mysql.jdbc.Driver");3435System.out.println("Connecting to database...");36conn = DriverManager.getConnection (DB_URL, USER, PASS);3738System.out.println("Creating statement...");stmt = conn.createStatement ();40String sql;4142;sql = "SELECT name, age, position, department FROM tblinfol WHERE name LIKE'"+searchName+"""ResultSet rs = stmt.executeQuery (sql);4445while (rs.next()) {4647String name = rs.getString ("name");48int age = rs.getInt ("age");49String position = rs.getString("position");50String department = rs.getString ("department");51

Answered: import java.beans.Statement; import…

import java.beans.Statement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.JOptionPane;

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

connect sql with this code class DiplomaProgram: def __init__(self): self.listCourse = set() def addCourse(self, course): self.listCourse.add(course) def removeCourse(self, course): self.listCourse.remove(course) def listPassedStudent(self): listStudent = set() for course in self.listCourse: for student in course.listStudent: if student not in listStudent and student.isPassed(): student.printInfo() listStudent.add(student) def listDistinctStudent(self): listStudent = set() for course in self.listCourse: for student in course.listStudent: if student not in listStudent and student.isDistinct(): student.printInfo() listStudent.add(student) class Course: id = 1 def __init__(self, name, assignments): self.name = name self.id = Course.id…
97. When SQL statements are embedded inside 3GL, we call such a program as a. Nested query b. Nested programming c. Distinct query d. Embedded SQL
/* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE VALUES('6','Mr.','Renselaer','Cary','A','12/25/1965','GEN','1'); INSERT INTO EMPLOYEE VALUES('7','Mr.','Ogallo','Roberto','S','7/31/1962','MGR','3'); INSERT INTO EMPLOYEE VALUES('8','Ms.','Johnsson','Elizabeth','I','9/10/1968','SEC','1'); INSERT INTO EMPLOYEE…
/* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE VALUES('6','Mr.','Renselaer','Cary','A','12/25/1965','GEN','1'); INSERT INTO EMPLOYEE VALUES('7','Mr.','Ogallo','Roberto','S','7/31/1962','MGR','3'); INSERT INTO EMPLOYEE VALUES('8','Ms.','Johnsson','Elizabeth','I','9/10/1968','SEC','1'); INSERT INTO EMPLOYEE…
/* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE VALUES('6','Mr.','Renselaer','Cary','A','12/25/1965','GEN','1'); INSERT INTO EMPLOYEE VALUES('7','Mr.','Ogallo','Roberto','S','7/31/1962','MGR','3'); INSERT INTO EMPLOYEE VALUES('8','Ms.','Johnsson','Elizabeth','I','9/10/1968','SEC','1'); INSERT INTO EMPLOYEE…
Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.
Create a database class in python. Create four variables for the database class: str_databasename, int_databaseid, lst_tablenames and int_count. str_databasename will store the name of the database, int_databaseid will store the identification number of the database and each identifier number is a unique number. lst_tablenames will store the list of tables for one particular database object. Int_count will store the number of tables for this database object.
hello please i want SQL Statements (DDL & DML) full code based on this ERD diagram Patient patientiD PK Pharmacy BloodBank PAame Medicine pharmacylD PK bankID bloodType patientiD PK PAge treatmentiD 0.. PK treatmentID FK pHeathissue medName FK peloodType medPrice FK medPrice 0. Appointment appointmentiD Doctor DoctorClinic 1 appointmentiD FK PK doctoriD PK 0.appointmentDate 0. dName treamentiD FK medPrice doctoriD FK appointment_price FK patientiD FK FK appointmentStatus appoinment_price
Lecture 7 DHTML with jQuery Lab Exercise 1 Display the text "Welcome to the world of jQuery" on clicking a button using jQuery.
Make use of Windows Presentation Foundation (WPF) to develop a Stock Management System thatwill manage the items being stocked in a warehouse. The application has 3 modules named: Addproduct, List Product, and Print Bar Code.Add Product:This module is used for adding new products to the system. It will require some basic details likeProduct category, Product Name, cost price, selling price, quantity and bar code. The details willbe saved into a SQL database named StockSystemdb. One other interesting feature of this systemis the alert system.You can set a particular quantity for each item. Now a notification or alert will be given to the userif a particular item’s quantity gets below the set quantity. This will help the user in gettingnotifications of the items getting low in stock.List Product:This module lists all the items present in the database of the Stock Management System. It will haveoptions to edit the details of each item or delete a particular item from the list.Print Bar…
The SQLiteOpenHelper and SQLiteCursor classes are described, with a focus on how they may be used to perform create, read, update, and delete (CRUD) actions on a SQLite database.
You are in charge of creating a small database for a store that sells goods so that it can keep track of its customers and their orders. Write an SQL statement to create a customer table containing the following information: Every customer has a unique ID, that should not be empty and set as the primary key The customer's first and last name that shouldn't be empty The phone number that shouldn't be empty The email, which could be empty. The address, which could be empty. Write a SQL statement to create the table Orders, which will keep track of customer orders, using the following information: Each order has a unique ID, which shouldn't be empty and should be set as the primary key. The customer's ID and should not be empty and assign it as the foreign key of the customer ID in table customer. The Items purchased by the customer and shouldn't be left empty. The amount of each item, and should not be empty The price of the items, and should not be empty