Creating a Table : Database « JSP « Java Tutorial

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

        <TITLE>Creating a Table</TITLE>

        <H1>Creating a Table</H1>

            Connection connection = null;
            try {
                connection = DriverManager.getConnection("jdbc:odbc:data", "YourName", "password");

                Statement statement = connection.createStatement();
                String command = "CREATE TABLE Employees (ID INTEGER, Name CHAR(50));";

            } catch (Exception e) {
                out.println("An error occurred.");
        The Employees table was created.

23.52.1.Make Database connection
23.52.2.Accessing the Database Table
23.52.3.Retrieve data in Database based on form input
23.52.4.Output ResultSet
23.52.5.Joining Tables
23.52.6.Creating a Table
23.52.7.Insert data to a table
23.52.8.Navigate Database Table With Javascript and JSP
23.52.9.Database Table Navigation Based On Form
23.52.10.Connect to Database in Servlet
23.52.11.Using Table Metadata
23.52.12.Output data in database as XML