import java.sql.*;
import javax.sql.*;
import javax.naming.*;
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/myDB");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM employees");
while (rs.next()) {
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
}
Statement stmt = conn.createStatement();
int rowsAffected = stmt.executeUpdate("UPDATE employees SET salary = salary + 10000 WHERE age > 30");
System.out.println("Rows affected: " + rowsAffected);
conn.close();
