Use Jdbc Template To Create Table : JdbcTemplate « Spring « Java Tutorial






File: context.xml

File: Main.java

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.SingleConnectionDataSource;

public class Main {
  public static void main(String args[]) throws Exception {
    SingleConnectionDataSource ds = new SingleConnectionDataSource();
    ds.setDriverClassName("org.hsqldb.jdbcDriver");
    ds.setUrl("jdbc:hsqldb:data/tutorial");
    ds.setUsername("sa");
    ds.setPassword("");
    //
    // ds.setDriverClassName("com.mysql.jdbc.Driver");
    // ds.setUrl("jdbc:mysql://localhost:3306/spring");
    // ds.setUsername("spring");
    // ds.setPassword("password");
    //
    // ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    // ds.setUrl("jdbc:oracle:thin:@spring:1521:my10g");
    // ds.setUsername("spring");
    // ds.setPassword("password");
    
    JdbcTemplate jt = new JdbcTemplate(ds);
    jt.execute("create table employee (id int, name varchar)");
    jt.execute("insert into employee (id, name) values (1, 'A')");
    jt.execute("insert into employee (id, name) values (2, 'B')");
    jt.execute("insert into employee (id, name) values (3, 'C')");
    jt.execute("insert into employee (id, name) values (4, 'D')");
    jt.execute("insert into employee (id, name) values (5, 'E')");
    jt.execute("insert into employee (id, name) values (6, 'F')");    
    
    
    int count = jt.queryForInt("select count(*) from employee");    
    
    System.out.println(count);
    ds.destroy();
  }
}
  Download:  Spring-UseJdbcTemplateToCrateTable.zip( 3,487 k)








28.21.JdbcTemplate
28.21.1.Use QueryForInt To Execute Aggregate Function
28.21.2.Use JdbcTemplate To Execute Aggregate Function
28.21.3.Use Jdbc Template To Create Table
28.21.4.Use batchUpdate To Execute Two Update Statements
28.21.5.Update, Delete Statements With Jdbc Template
28.21.6.Execute DeleteStatement
28.21.7.Query For Object, Return String
28.21.8.Query For Map
28.21.9.Query For List, Returns List Of LinkedHashMap
28.21.10.Query For List
28.21.11.Pass RowCallbackHandler Into Query Method In JdbcTemplate
28.21.12.Pass ResultSetExtractor To Query Method In JdbcTemplate
28.21.13.Pass Parameter As Object Array
28.21.14.Pass Object Array To Query Method In JdbcTemplate
28.21.15.Number Of Row Affected