Mega Code Archive
Categories
/
Java
/
JSP
Filling a Table
<%@ page import="java.sql.*" %>
Filling a Table
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) %>
<% } %>