Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.JdbcTemplate.execute()

52
53
54
55
56
57
58
59
60
61
62
    public void init() {
        super.init(dataSource);
        JdbcTemplate template = new JdbcTemplate(dataSource);

        // Schema: Petclinic
        template
                .execute("CREATE TABLE vets (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30))");
        template.execute("CREATE TABLE specialties (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");

        template.execute("CREATE TABLE vet_specialties (vet_id INT NOT NULL, specialty_id INT NOT NULL)");
        template
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        JdbcTemplate template = new JdbcTemplate(dataSource);

        // Schema: Petclinic
        template
                .execute("CREATE TABLE vets (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30))");
        template.execute("CREATE TABLE specialties (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");

        template.execute("CREATE TABLE vet_specialties (vet_id INT NOT NULL, specialty_id INT NOT NULL)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_vets foreign key (vet_id) references vets(id)");
        template
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
        // Schema: Petclinic
        template
                .execute("CREATE TABLE vets (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30))");
        template.execute("CREATE TABLE specialties (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");

        template.execute("CREATE TABLE vet_specialties (vet_id INT NOT NULL, specialty_id INT NOT NULL)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_vets foreign key (vet_id) references vets(id)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_specialties foreign key (specialty_id) references specialties(id)");
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
        template
                .execute("CREATE TABLE vets (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30))");
        template.execute("CREATE TABLE specialties (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");

        template.execute("CREATE TABLE vet_specialties (vet_id INT NOT NULL, specialty_id INT NOT NULL)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_vets foreign key (vet_id) references vets(id)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_specialties foreign key (specialty_id) references specialties(id)");

        template.execute("CREATE TABLE types (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
        template.execute("CREATE TABLE specialties (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");

        template.execute("CREATE TABLE vet_specialties (vet_id INT NOT NULL, specialty_id INT NOT NULL)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_vets foreign key (vet_id) references vets(id)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_specialties foreign key (specialty_id) references specialties(id)");

        template.execute("CREATE TABLE types (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");
        template
                .execute("CREATE TABLE owners (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30), address VARCHAR(255), city VARCHAR(80), telephone VARCHAR(20))");
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_vets foreign key (vet_id) references vets(id)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_specialties foreign key (specialty_id) references specialties(id)");

        template.execute("CREATE TABLE types (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");
        template
                .execute("CREATE TABLE owners (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30), address VARCHAR(255), city VARCHAR(80), telephone VARCHAR(20))");

        template
                .execute("CREATE TABLE pets (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30), birth_date DATE, type_id INT NOT NULL, owner_id INT NOT NULL)");
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
                .execute("alter table vet_specialties add constraint fk_vet_specialties_vets foreign key (vet_id) references vets(id)");
        template
                .execute("alter table vet_specialties add constraint fk_vet_specialties_specialties foreign key (specialty_id) references specialties(id)");

        template.execute("CREATE TABLE types (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");
        template
                .execute("CREATE TABLE owners (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30), address VARCHAR(255), city VARCHAR(80), telephone VARCHAR(20))");

        template
                .execute("CREATE TABLE pets (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30), birth_date DATE, type_id INT NOT NULL, owner_id INT NOT NULL)");
        template.execute("alter table pets add constraint fk_pets_owners foreign key (owner_id) references owners(id)");
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
        template.execute("CREATE TABLE types (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(80))");
        template
                .execute("CREATE TABLE owners (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30), address VARCHAR(255), city VARCHAR(80), telephone VARCHAR(20))");

        template
                .execute("CREATE TABLE pets (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30), birth_date DATE, type_id INT NOT NULL, owner_id INT NOT NULL)");
        template.execute("alter table pets add constraint fk_pets_owners foreign key (owner_id) references owners(id)");
        template.execute("alter table pets add constraint fk_pets_types foreign key (type_id) references types(id)");

        template
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
        template
                .execute("CREATE TABLE owners (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30), address VARCHAR(255), city VARCHAR(80), telephone VARCHAR(20))");

        template
                .execute("CREATE TABLE pets (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30), birth_date DATE, type_id INT NOT NULL, owner_id INT NOT NULL)");
        template.execute("alter table pets add constraint fk_pets_owners foreign key (owner_id) references owners(id)");
        template.execute("alter table pets add constraint fk_pets_types foreign key (type_id) references types(id)");

        template
                .execute("CREATE TABLE visits (id INT NOT NULL IDENTITY PRIMARY KEY, pet_id INT NOT NULL, visit_date DATE, description VARCHAR(255))");
        template.execute("alter table visits add constraint fk_visits_pets foreign key (pet_id) references pets(id)");
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
                .execute("CREATE TABLE owners (id INT NOT NULL IDENTITY PRIMARY KEY, first_name VARCHAR(30), last_name VARCHAR(30), address VARCHAR(255), city VARCHAR(80), telephone VARCHAR(20))");

        template
                .execute("CREATE TABLE pets (id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30), birth_date DATE, type_id INT NOT NULL, owner_id INT NOT NULL)");
        template.execute("alter table pets add constraint fk_pets_owners foreign key (owner_id) references owners(id)");
        template.execute("alter table pets add constraint fk_pets_types foreign key (type_id) references types(id)");

        template
                .execute("CREATE TABLE visits (id INT NOT NULL IDENTITY PRIMARY KEY, pet_id INT NOT NULL, visit_date DATE, description VARCHAR(255))");
        template.execute("alter table visits add constraint fk_visits_pets foreign key (pet_id) references pets(id)");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.