|
Im already on my learning path but I have a problem on my first example and I dont know exactly what it is.
This is the JSP File
<HTML> <HEAD><TITLE>Employee List</TITLE></HEAD> <BODY> <%@ page import="java.sql.*" %> <TABLE BORDER=1 width="75%"> <TR><TH>Last Name</TH><TH>First Name</TH></TR> <% Connection conn = null; Statement st = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","jonas","jonas"); st = conn.createStatement(); rs = st.executeQuery("select * from employees"); while(rs.next()) { %> <TR><TD><%= rs.getString("lname_txt") %></TD> <TD><%= rs.getString("fname_txt") %></TD></TR> <% } %> </TABLE> <% } catch (Exception ex) { ex.printStackTrace(); %> <%= ex.getMessage() %>
</TABLE>
Ooops, something bad happened:
<%
} finally {
if (rs != null) rs.close();
if (st != null) st.close();
if (conn != null) conn.close();
}
%>
</BODY>
</HTML>
and this is the output I get When I try to see it
I have some experience using the JDBC with mysql and i tried to use the ex.getSQLState() function but I got an error.
I really hope you can help me
Thanks on advance.
Claudio Veas | 