![]() |
JSP
JDBC Source, Screen Capture
|
||
![]() |
![]() |
![]() |
|
|
![]() <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <META http-equiv="Expires" content="0" > </META> <title>Insert Data</title> </HEAD> <BODY>
<font size="7"> Quick & Dirty Database Call </font> </P>
<table border =1> <%
Class.forName("com.mysql.jdbc.Driver").newInstance(); java.sql.Connection conn; conn = DriverManager.getConnection("jdbc:mysql://localhost/students");
// Do the select.
recordNo++; %> <tr> <td colspan = 4> Record # <%=recordNo%> </td> <tr> <tr> <td>Name: <%=rs.getString("Name")%></td> <td>ID: <%=rs.getString("BearcatID")%></td> <td>Gender: <%=rs.getString("Gender")%></td> <td>Major: <%=rs.getString("Major")%></td> <td>College ID: <%=rs.getString("CollegeId")%></td> </tr> <% }
</table>
</HTML>
|