Databases Programming Challenges 3, Personnel Database Creator Write an applicat

Question

Databases

Programming Challenges

3, Personnel Database Creator

Write an application that creates a database named Personnel. The database should have a table named Employee, with columns for employee ID, named position, and hourly pay rate. The employee ID should be the primary key.Insert at least five sample rows of data into the Employee table.

4, Employee Inserter

Write a GUI application that allows the user to add new employee to the Personnel database you created in Programming Challenges 3.

pls add comments

Explanation / Answer

You would need JDBC driver installed to interface with the Database
//STEP 1. Import required packages import java.sql.*;
public class JDBCExample { // JDBC driver name and database URL static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost/";
// Database credentials static final String USER = "username"; static final String PASS = "password"; public static void main(String[] args) { Connection conn = null; Statement stmt = null; try{ //STEP 2: Register JDBC driver Class.forName("com.mysql.jdbc.Driver");
//STEP 3: Open a connection System.out.println("Connecting to database..."); conn = DriverManager.getConnection(DB_URL, USER, PASS);
//STEP 4: Execute a query System.out.println("Creating database..."); stmt = conn.createStatement();    String sql = "CREATE DATABASE Personnel"; stmt.executeUpdate(sql); System.out.println("Database created successfully..."); String sql = "CREATE TABLE Employee " + "(id INTEGER not NULL, " + " named VARCHAR(255), " + " hourly VARCHAR(255), " + " PRIMARY KEY ( id ))"; stmt.executeUpdate(sql);
String sql = "INSERT INTO Registration " + "VALUES (100, 'Zara', 18)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES (101, 'Mahnaz', 'Fatma', 25)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES (102, 'Zaid', 30)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES(103, 'Sumit', 28)";
stmt.executeUpdate(sql); System.out.println("Created table in given database..."); String sql = "CREATE TABLE Employee " + "(id INTEGER not NULL, " + " named VARCHAR(255), " + " hourly VARCHAR(255), " + " PRIMARY KEY ( id ))"; stmt.executeUpdate(sql);
String sql = "INSERT INTO Registration " + "VALUES (100, 'Zara', 18)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES (101, 'Mahnaz', 'Fatma', 25)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES (102, 'Zaid', 30)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES(103, 'Sumit', 28)";
String sql = "INSERT INTO Registration " + "VALUES (100, 'Zara', 18)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES (101, 'Mahnaz', 'Fatma', 25)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES (102, 'Zaid', 30)"; stmt.executeUpdate(sql); sql = "INSERT INTO Registration " + "VALUES(103, 'Sumit', 28)";
stmt.executeUpdate(sql); System.out.println("Created table in given database..."); }catch(SQLException se){ //Handle errors for JDBC se.printStackTrace(); }catch(Exception e){ //Handle errors for Class.forName e.printStackTrace(); }finally{ //finally block used to close resources try{ if(stmt!=null) stmt.close(); }catch(SQLException se2){ }// nothing we can do try{ if(conn!=null) conn.close(); }catch(SQLException se){ se.printStackTrace(); }//end finally try }//end try System.out.println("Goodbye!"); }//end main }//end JDBCExample

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.