Hazem Salama's Database Notes from Nov. 15

(Corrected 11.16.2005: change typographic quotes to straight quotes.)

Steps for JDBC direct database access.

• Load the vendor specific driver

                        Class.forName("com.mysql.jdbc.Driver");

• Make the connection

Connection con = DriverManager.getConnection("jdbc:mysql://localhost/testDB", username, password);

• Create SQL statements

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery("select * from tbl_employees");

while (rs.next()){

                        FirstName = rs.getString("FirstName");

}

stmt.executeUpdate("insert into tbl_employees values('Hazem', 'Salama', 001)")

Steps for JNDI

• Context init = new InitialContext();
• Context ctx = (Context)init.lookup("java:comp/env");
• DataSource ds = (DataSource)ctx.lookup("jdbc/test");
• Connection con = ds.getConnection();