<%@ page import="java.sql.*" errorPage="error.jsp" %> Connecting Java Server Pages to MySQL

Connecting Java Server Pages to MySQL

<% Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con= DriverManager.getConnection("jdbc:mysql://Localhost/BabyTalkWebLibrary?user=root"); Statement stmt = con.createStatement(); String queryStr = "SELECT * from Status"; ResultSet rs = stmt.executeQuery(queryStr); while(rs.next()) { %> <% } if (rs!=null) rs.close(); if (stmt!=null) stmt.close(); if (con!=null) con.close(); %>

<%= rs.getString("description")%>