java code for Filling a Table

<%@ page import="java.sql.*" %>

Filling a Table

<%
Connection connection = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection("jdbc:odbc:data", "userName", "password");

Statement statement = connection.createStatement();

String command = "INSERT INTO Employees (ID, Name) VALUES (1, 'Joe')";
statement.executeUpdate(command);

command = "INSERT INTO Employees (ID, Name) VALUES (2, 'Yin')";
statement.executeUpdate(command);

ResultSet resultset =
statement.executeQuery("select * from Employees");

while(resultset.next()){
%>

ID	Name
<%= resultset.getString(1) %>	<%= resultset.getString(2) %>

<%
}
%>