Question

1. Write Java code with JDBC (as discussed in class) to perform the following tasks:

   EMPLOYEE(Name, Ssn, Address, DeptNo, Age, Salary)

   DEPARTMENT(Dname, Dnumber, Budget, Mgr_ssn)

1. Establish a logical session with a database you have created for the two relations
2. Use JDBC to submit an SQL query and print the name of each employee with a salary greater than 100,000

Answer 1

CODE

import java.sql.*; public class Main { static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost/EMPLOYEE"; static final String USER = "username"; static final String PASS = "password"; public static void main(String[] args) { Connection conn = null; Statement stmt = null; try { Class.forName(JDBC_DRIVER); conn = DriverManager.getConnection(DB_URL, USER, PASS); stmt = conn.createStatement(); String sql; sql = "SELECT Name FROM Employees WHERE Salary > 100000"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { String name = rs.getString("Name"); System.out.println("Name: " + name); } rs.close(); stmt.close(); conn.close(); } catch (Exception se) { se.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); } catch (SQLException ignored) { } try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } } } }