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;

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Any comments i could add to this? package attendance; import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement; public class SqliteDB {Connection conn = null;Statement stmt = null;public SqliteDB() throws ClassNotFoundException {//try to connect with dbtry {Class.forName("org.sqlite.JDBC");// db parametersString url = "jdbc:sqlite:C:/sqlite/db/attendance.db";// create a connection to the databaseconn = DriverManager.getConnection(url);System.out.println("Connection to SQLite has been established.");} catch (SQLException e) {System.out.println(e.getMessage());}}public void executeQuery(String query) {try {this.stmt = conn.createStatement();stmt.execute(query);}catch (Exception e) {System.out.println(e);}}public void closeConnection() {try {this.conn.close();}catch( Exception e) {System.out.println(e);}}}
Can you help me here to find what is wr The time , dosn't work , it show 0000. 00 . 00 As in picture I attached with the question. Here the code for class and follow for the main. <?php//include("includes/config.php"); class Posts { private $db; // This __construct function I use to open up a connection to my database function __construct() { $this->db = new mysqli(DBHOST, DBUSER, DBPASS, DBDATABASE); if($this->db->connect_errno > 0) { die("Connection error: " . $db->connect_error); } } // My method to read posts from my database public function getPosts() { // sql command to get data from my database table called 'guestbook' $sql = "SELECT * from guestbook /*ORDER BY created DESC*/"; $result = $this->db->query($sql); return mysqli_fetch_all($result, MYSQLI_ASSOC); } public function addPost(string $user, string $content, $created ) { $created =date("M-d-Y h:i:s A");…
Explain this code detail by detail like putting comments private void table_update() { int CC; try { // It is for SOMETHING ETC.*** Class.forName("com.mysql.jdbc.Driver"); con1 = DriverManager.getConnection("jdbc:mysql://localhost/linda","root",""); insert = con1.prepareStatement("SELECT * FROM record"); ResultSet Rs = insert.executeQuery(); ResultSetMetaData RSMD = Rs.getMetaData(); CC = RSMD.getColumnCount(); DefaultTableModel DFT = (DefaultTableModel) jTable1.getModel(); DFT.setRowCount(0); while (Rs.next()) { Vector v2 = new Vector(); for (int ii = 1; ii <= CC; ii++) { v2.add(Rs.getString("id")); v2.add(Rs.getString("name")); v2.add(Rs.getString("mobile")); v2.add(Rs.getString("course")); }…
What comments can be added to this code? package attendance; import java.sql.ResultSet; import java.sql.SQLException; import javafx.collections.FXCollections; import javafx.collections.ObservableList; public class RFIDTagsDB { privateSqliteDB db; privatestaticObservableList<RFID> dbData; publicRFIDTagsDB() throwsClassNotFoundException{ db = new SqliteDB(); dbData = FXCollections.observableArrayList(); } publicObservableList<RFID>getDBData(){ return dbData; } publicvoidreadOne(intid) { System.out.println("READ One"); try { this.db.stmt =this.db.conn.createStatement(); System.out.println(db.stmt); String sql ="SELECT * FROM RFIDTags " +"WHERE id = "+ id +""; System.out.println(sql); ResultSet rs =this.db.stmt.executeQuery(sql); while( rs.next() ) { dbData.add( newRFID( rs.getInt("id"),…
Using MySQL Workbench, Create a database named “bank” with the following tables: Customer with filds: customer_id (integer) name (string) Account with fields: account_id (integer) balance (float) type (one of ‘savings’, ‘checking’, ‘cd’) Customer_Account id (integer) cust_id (integer) acc_id (integer) Populate the database with data of your choice. Note 1: Export the database into a self-contained file named bank1.sql before you continue. Note 2: Using Apache NetBeans, create a Java project that connects to the bank database.
Why line 18 is wrong ? please help <?php namespace Database\Seeders; use Illuminate\Database\Seeder; class Fakeseeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { $faker =\Faker\Factory::create(); for ($i=1; $i <= 40; $i++) { \App\Student::create([ 'first_name' => $this->faker->first_name(), 'last_name' => $this->faker->last_name(), 'phone_no' => $this->faker->phone_number(), 'email' => $this->faker->unique()->safeEmail(), ]); } } }
This is a JAVA Programming Language, please use JAVA ECLIPSE as the IDECreate a GUI application for a PAYROLL MANAGEMENT SYSTEM which is connected with database to do the following functions.• Adding new record• Deleting record• Read all the record from the database• Searching record by using StudentID• Searching record by using CourseID• Sort Data by TotalScore• Exit the application.Please upload the codes - screenshots and the output -screenshots with detailed explainations like a report with introductions, conclusions scope, objectives and so on. Don't copy from other sources
/* 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…
simple xamarin application that contain 3tabs pages , lists , buttons , sqlite database , and icon and images its is simple app seems like this photo bellow
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");…